I am saving text into database using Jquery ajax call by pressing of enter key. When I pressing enter key then, I have a button on master page it is redirecting to that button URL (In ASP.NET)
What I have tried:
I already apply below method but ajax success part is not working,
*HTML Code-----
<asp:Panel ID="panSearch" runat="server" DefaultButton="btnTemp" Width="100%">
<asp:Button ID="btnTemp" style="display:none;" runat="server" />
<input type="text" id="commentText<%# ((RepeaterItem)Container).ItemIndex + 1%>" class="form-control" placeholder="Your Comment" />
*AJAX Code-----
function SaveComment(e, cmntValue, UserId) {
var code = e.keyCode ? e.keyCode : e.which;
if (code === 13) {
var commentId = "#" + cmntValue.id;
var loginId = $('#ContentPlaceHolder1_sessionVal').val();
var username = $('#ContentPlaceHolder1_activeUser').val();
var obj = {};
obj.comment = $.trim($(commentId).val());
obj.userid = UserId;
obj.username = username;
obj.loginId = loginId;
console.log(obj.comment);
console.log(obj.userid);
console.log(obj.loginId);
console.log(obj.username);
if (obj.comment != '' && obj.userid != '' && obj.username != '' && obj.UserId != '') {
$.ajax({
type: "post",
url: "News.aspx/insertData",
data: JSON.stringify(obj),
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (data) {
console.log(data.d);
$(commentId).val("");
alert(0);
window.location.reload();
alert(1);
},
error: function (result) {
alert("Error");
}
});
}
}
}
*aspx.cs Code-----
public static string insertData(string userid, string username, string comment, string loginId)
{
string userImage = "images/avatar5.png";
var commentCount = "";
SqlCommand cmddd;
String strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["WebsiteDatabaseConnection"].ConnectionString;
SqlConnection connectify = new SqlConnection(strConnString);
SqlCommand cmd1 = new SqlCommand("SELECT FilePath FROM imageconnect WHERE UserId = '" + Convert.ToInt32(loginId) + "' ", connectify);
SqlDataReader CommentImage = null;
connectify.Open();
CommentImage = cmd1.ExecuteReader();
if (CommentImage.HasRows)
{
while (CommentImage.Read())
{
userImage = CommentImage["FilePath"].ToString();
}
}
else
{
userImage = "images/avatar5.png";
}
connectify.Close();
cmddd = new SqlCommand("insert into commentnews (userid,username,comment,timeago,userImage)" + " values(@userid,@username,@comment,@timeago,@userImage)", connectify);
cmddd.Parameters.AddWithValue("@userid", userid);
cmddd.Parameters.AddWithValue("@username", username);
cmddd.Parameters.AddWithValue("@comment", comment);
cmddd.Parameters.AddWithValue("@timeago", DateTime.Now);
cmddd.Parameters.AddWithValue("@userImage", userImage);
cmddd.CommandType = CommandType.Text;
cmddd.Connection = connectify;
try
{
connectify.Open();
cmddd.ExecuteNonQuery();
string query = "UPDATE newstable SET NumOfComment=(SELECT COUNT(*) FROM commentnews WHERE Userid='" + userid + "') WHERE UserId='" + userid + "'";
SqlHelper.ExecuteDataset(Connection.Getconstring(), CommandType.Text, query);
connectify.Close();
}
catch (Exception ex)
{
throw (ex);
}
finally
{
connectify.Close();
connectify.Dispose();
}
return string.Format("userid: {0},username: {1},commentCount: {2}", userid, username, commentCount, Environment.NewLine);
}