private void PopulateDataGridView()
{
dgvCustomer.AutoGenerateColumns = false;
using (EFDBEntities db = new EFDBEntities())
{
mainListCustomer = db.Customers.ToList <Customer>();
}
cloneListCustomer = mainListCustomer;
dgvCustomer.DataSource = cloneListCustomer;
}
private void dgvCustomer_DoubleClick(object sender, EventArgs e)
{
if (dgvCustomer.CurrentRow.Index != -1)
{
customer_model.CustomerID = Convert.ToInt32(dgvCustomer.CurrentRow.Cells["CustomerID"].Value);
using (EFDBEntities db = new EFDBEntities())
{
customer_model = db.Customers.Where(x => x.CustomerID == customer_model.CustomerID).FirstOrDefault();
txt_FirstName.Text = customer_model.FirstName;
txt_LastName.Text = customer_model.LastName;
txt_City.Text = customer_model.City;
txt_Address.Text = customer_model.Address;
}
//btnSave.Text = "Update";
//btnDelete.Enabled = true;
}
}
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");
}
