Example #1
0
 void DisplayDataGridview()
 {
     dataGridView1.AutoGenerateColumns = false;
     using (EFDBEntities db = new EFDBEntities())
     {
         dataGridView1.DataSource = db.Rockets.ToList <Rocket>();
     }
 }
Example #2
0
 private void dataGridView1_DoubleClick(object sender, EventArgs e)
 {
     if (dataGridView1.CurrentRow.Index != 0)
     {
         using (EFDBEntities db = new EFDBEntities())
         {
             txtId.Text          = Convert.ToString(model.Id);
             txtName.Text        = model.Name;
             txtVehicleType.Text = model.VehicleType;
             txtPurpose.Text     = model.Purpose;
         }
     }
 }
Example #3
0
 private void btnUpdate_Click(object sender, EventArgs e)
 {
     model.Id          = Convert.ToInt32(txtId.Text.Trim());
     model.Name        = txtName.Text.Trim();
     model.VehicleType = txtVehicleType.Text.Trim();
     model.Purpose     = txtPurpose.Text.Trim();
     using (EFDBEntities db = new EFDBEntities())
     {
         db.Entry(model).State = EntityState.Modified;
         db.SaveChanges();
     }
     Clear();
     DisplayDataGridview();
     MessageBox.Show("Record Succcessfully Updated..");
 }
Example #4
0
 private void btnDelete_Click(object sender, EventArgs e)
 {
     if (MessageBox.Show("Are You Sure To Delete this Record?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
     {
         using (EFDBEntities db = new EFDBEntities())
         {
             var entry = db.Entry(model);
             if (entry.State == EntityState.Detached)
             {
                 db.Rockets.Attach(model);
             }
             db.Rockets.Remove(model);
             db.SaveChanges();
             DisplayDataGridview();
             Clear();
             MessageBox.Show("Record Deleted Successfully");
         }
     }
 }