private void Delete_Message_btn_Click(object sender, EventArgs e) { List <string> DF_requests = new List <string>(); int checkBoxColumn = dataGridView1.Columns.Count - 1; //List marked scholarships foreach (DataGridViewRow rw in this.dataGridView1.Rows) { if (rw.Cells[checkBoxColumn].Value != null && Convert.ToBoolean(rw.Cells[checkBoxColumn].Value) == true) { DF_requests.Add(rw.Cells[2].Value.ToString()); } } using (Entities context = new Entities()) { //Delete each marked scholarship foreach (string i in DF_requests) { DF_requests msg = context.DF_requests.FirstOrDefault(s => s.Subject == i); context.DF_requests.Remove(msg); } //Save changes and reload grid context.SaveChanges(); reloadDataGridView(context); } dataGridView1.Refresh(); }
public DF_requests newrequset() { using (Entities context = new Entities()) { DF_requests msg = new DF_requests { Date = DateTime.Today, Intended_to = "Tech_Team", Subject = subject_txtbox.Text, Message = message_textbox.Text, Status = "Open" }; return(msg); } }
public DF_requests newrequsettoall() { using (Entities context = new Entities()) { DF_requests msg = new DF_requests { Date = DateTime.Today, Intended_to = Intended_to_combo.Text, Subject = Subject_textbox.Text, Message = Message_textbox.Text, Status = "Open" }; return(msg); } }