Example #1
0
        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);
     }
 }
Example #3
0
 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);
     }
 }