private void btnDelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Update all gridview?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
using (EFDBEntities db = new EFDBEntities())
{
var query = from t in db.Customers.AsEnumerable()
join r in cloneListCustomer.AsEnumerable()
on t.CustomerID equals r.CustomerID
select t;
//Remove
db.Customers.RemoveRange(query);
//Add
db.Customers.AddRange(cloneListCustomer);
db.SaveChanges();
PopulateDataGridView();
Clear();
MessageBox.Show("Deleted Successfully");
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
customer_model.FirstName = txt_FirstName.Text.Trim();
customer_model.LastName = txt_LastName.Text.Trim();
customer_model.City = txt_City.Text.Trim();
customer_model.Address = txt_Address.Text.Trim();
using (EFDBEntities db = new EFDBEntities())
{
if (customer_model.CustomerID == 0) //Insert
{
db.Customers.Add(customer_model);
}
else //Update current row
{
db.Entry(customer_model).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
}
Clear();
PopulateDataGridView();
MessageBox.Show("Add Successfully");
}