/// <summary> /// Add new message to the database /// </summary> /// <param name="msg1">ch_messages object</param> public static void NewUsrMsg(ch_messages msg1) { string strSql1 = "INSERT INTO ch_messages(msg_date, msg_title, msg_content, msg_checked) "; strSql1 += "VALUES('" + msg1.msg_Date + "', '" + msg1.msg_Title + "', '" + msg1.msg_Content + "', " + Convert.ToInt32(msg1.msg_Checked) + ")"; Connect.DoAction(strSql1, "ch_messages"); string strSql2 = "SELECT LAST(msg_id) FROM ch_messages"; int maxId = Convert.ToInt32(Connect.MathAction(strSql2, "ch_messages")); string strSql3 = "INSERT INTO ch_users_messages(msg_id, msg_sender_id, msg_reciver_id) "; strSql3 += "VALUES(" + maxId + ", '" + msg1.msg_Sender_Id + "', '" + msg1.msg_Reciver_Id + "')"; Connect.DoAction(strSql3, "ch_users_messages"); }
protected void btnSend_Click(object sender, EventArgs e) { ch_messages msg = new ch_messages(); msg.msg_Date = DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss"); msg.msg_Sender_Id = Session["usr_id"].ToString(); msg.msg_Reciver_Id = ddlTo.SelectedValue; msg.msg_Title = txtTitle.Text.Trim(); msg.msg_Content = txtContent.Text.Trim(); msg.msg_Checked = false; ch_messagesSvc.NewUsrMsg(msg); lblPopupTitle.Text = "ההודעה נשלחה"; lblPopupContent.Text = "לחץ אוקיי לכל ההודעות"; pnlPopup.Visible = true; }