void populateDataGridView() { dataCustomer.AutoGenerateColumns = false; using (CrudDBEntities db = new CrudDBEntities()) { dataCustomer.DataSource = db.Customers.ToList <Customer>(); } }
private void dataCustomer_MouseDoubleClick(object sender, MouseEventArgs e) { if (dataCustomer.CurrentRow.Index != -1) { model.CustomerID = Convert.ToInt32(dataCustomer.CurrentRow.Cells["CustomerID"].Value); using (CrudDBEntities db = new CrudDBEntities()) { model = db.Customers.Where(x => x.CustomerID == model.CustomerID).FirstOrDefault(); txtFirstname.Text = model.FirstName; txtLastname.Text = model.Lastname; txtCity.Text = model.City; txtAddress.Text = model.Address; } btnSave.Text = "Update"; btnDelete.Enabled = true; } }
private void btnDelete_Click(object sender, EventArgs e) { if (MessageBox.Show("Are you Sure to Delete this Record ?", "CRUD Operation", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (CrudDBEntities db = new CrudDBEntities()) { var entry = db.Entry(model); if (entry.State == EntityState.Detached) { db.Customers.Attach(model); } db.Customers.Remove(model); db.SaveChanges(); populateDataGridView(); Clear(); MessageBox.Show("Deleted Successfully"); } } }
private void btnSave_Click(object sender, EventArgs e) { model.FirstName = txtFirstname.Text.Trim(); model.Lastname = txtLastname.Text.Trim(); model.City = txtCity.Text.Trim(); model.Address = txtAddress.Text.Trim(); using (CrudDBEntities db = new CrudDBEntities()) { if (model.CustomerID == 0)//Insert { db.Customers.Add(model); } else //Update { db.Entry(model).State = EntityState.Modified; } db.SaveChanges(); } Clear(); populateDataGridView(); MessageBox.Show("Submitted Successfully"); }