protected void sendBTN_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(Server.HtmlEncode(MSGTextBox.Text))) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Javascript", "alert('Enter Message'); ", true); return; } if (string.IsNullOrWhiteSpace(Server.HtmlEncode(CurrentRecevier.Text))) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Javascript", "alert('Select Recevier'); ", true); return; } string StrCmd = "AddMsgToTable2 @msg , @SenderName, @ReciverName"; SqlCommand sqlcmd = new SqlCommand(StrCmd, sqlconn); sqlcmd.Parameters.AddWithValue("@msg", Server.HtmlEncode(MSGTextBox.Text)); sqlcmd.Parameters.AddWithValue("@SenderName", Server.HtmlEncode(CurrentSender.Text)); sqlcmd.Parameters.AddWithValue("@ReciverName", Server.HtmlEncode(CurrentRecevier.Text)); sqlconn.Open(); sqlcmd.ExecuteNonQuery(); sqlconn.Close(); MSGTextBox.Text = ""; MSGTextBox.Focus(); LoadChatList(); LoadingImage.Attributes.CssStyle.Add("opacity", "0"); }
protected void Page_Load(object sender, EventArgs e) { string connectionString = ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ToString(); SqlConnection sqlconn = new SqlConnection(connectionString); if (!User.Identity.IsAuthenticated) { Response.Redirect("login.aspx"); } else { CurrentSender.Text = Server.HtmlEncode(User.Identity.Name); if (!IsPostBack) { LoadChatList(); MSGTextBox.Focus(); LoadingImage.Attributes.CssStyle.Add("opacity", "0"); } int x = checkNewMessage(); UnreadMsgCountLabel.Text = x.ToString(); if (x != 0) { LoadChatList(); this.Title = x.ToString() + " new messages"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Javascript", "javascript:playSound()", true); } else { this.Title = "chat"; } } }
protected void sendBTN_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(Server.HtmlEncode(MSGTextBox.Text))) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Javascript", "alert('Enter Message'); ", true); return; } if (string.IsNullOrWhiteSpace(Server.HtmlEncode(CurrentRecevier.Text))) { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Javascript", "alert('Select Recevier'); ", true); return; } String conString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\var\Desktop\asp.net\p3\ProjectWeMate\App_Data\Database.mdf;Integrated Security=True"; SqlConnection sqlconn = new SqlConnection(conString); string StrCmd = "AddMsgToTable @msg , @SenderName, @ReciverName"; SqlCommand sqlcmd = new SqlCommand(StrCmd, sqlconn); sqlcmd.Parameters.AddWithValue("@msg", Server.HtmlEncode(MSGTextBox.Text)); sqlcmd.Parameters.AddWithValue("@SenderName", Server.HtmlEncode(CurrentSender.Text)); sqlcmd.Parameters.AddWithValue("@ReciverName", Server.HtmlEncode(CurrentRecevier.Text)); sqlconn.Open(); sqlcmd.ExecuteNonQuery(); sqlconn.Close(); MSGTextBox.Text = ""; MSGTextBox.Focus(); LoadChatList(); LoadingImage.Attributes.CssStyle.Add("opacity", "0"); }