/// <summary> /// Checks if ch_deleted_messages already exist in database /// </summary> /// <param name="del_msg"></param> /// <returns>return true if ch_deleted_messages is exist in database. false if not exist.</returns> public static bool IsExist(ch_deleted_messages del_msg) { string queryIsExist = "SELECT COUNT(msg_id) FROM ch_deleted_messages WHERE msg_id=" + del_msg.msg_Id + " AND usr_id=" + del_msg.usr_Id; int k = Convert.ToInt32(Connect.MathAction(queryIsExist, "ch_deleted_messages")); if (k > 0) { return(true); } return(false); }
/// <summary> /// Adds a new record of deleted message to the database. /// </summary> /// <param name="del_msg">the message to delete</param> /// <returns>true if the message deleted now. false if already deleted in the past.</returns> public static bool Add(ch_deleted_messages del_msg) { if (IsExist(del_msg)) { return(false); } string strSql = "INSERT INTO ch_deleted_messages(msg_id, usr_id) "; strSql += "VALUES(" + del_msg.msg_Id + ", " + del_msg.usr_Id + ")"; Connect.DoAction(strSql, "ch_deleted_messages"); return(true); }
protected void btnMsgSentDelete_Click(object sender, ImageClickEventArgs e) { string[] arr = hfSelectedRowsSent.Value.Split(','); for (int i = 0; i < arr.Length; i++) { if (Convert.ToInt32(arr[i]) >= 0) { GridViewRow current = gvMessagesSent.Rows[Convert.ToInt32(arr[i])]; ch_deleted_messages del_msg = new ch_deleted_messages(Convert.ToInt32(((Label)current.FindControl("lbl_msg_id_sent")).Text), Convert.ToInt32(Session["usr_id"])); ch_deleted_messagesSvc.Add(del_msg); } } hfSelectedRowsSent.Value = "-1"; //bind data GVBindSent(); //select checkboxes SelectCheckboxesSent(); }