//private void btnSave_Click(object sender, EventArgs e) //{ // c.FirstName = txtFName.Text; // c.LastName = txtLName.Text; // c.Address = txtAddress.Text; // c.City = txtCity.Text; // using (var contex = new EFWINFORMDBEntities()) // { // if (c.CustomerID == 0) // { // contex.Customer.Add(c); // } // else // { // contex.Entry(c).State = EntityState.Modified; // } // contex.SaveChanges(); // } // Clear(); // PopulateGrid(); // MessageBox.Show("Record Saved Succefully"); //} private void btnSave_Click(object sender, EventArgs e) { c.FirstName = txtFName.Text; c.LastName = txtLName.Text; c.Address = txtAddress.Text; c.City = txtCity.Text; c.Image = File.ReadAllBytes(dlgOpenImage.FileName); using (var contex = new EFWINFORMDBEntities()) { try { contex.Customer.AddOrUpdate(c); } catch (Exception ex) { Console.WriteLine(ex); } contex.SaveChanges(); } Clear(); PopulateGrid(); MessageBox.Show("Record Saved Sucefully"); }
public void PopulateGrid() { dataGridView1.AutoGenerateColumns = false; using (var contex = new EFWINFORMDBEntities()) { dataGridView1.DataSource = contex.Customer.ToList <Customer>(); } }
private void dataGridView1_DoubleClick(object sender, EventArgs e) { if (dataGridView1.CurrentRow.Index != -1) { c.CustomerID = Convert.ToInt32(dataGridView1.CurrentRow.Cells["CustomerID"].Value); using (var contex = new EFWINFORMDBEntities()) { var query = contex.Customer.Where(x => x.CustomerID == c.CustomerID).FirstOrDefault(); txtFName.Text = query.FirstName; txtLName.Text = query.LastName; txtCity.Text = query.City; txtAddress.Text = query.Address; } btnSave.Text = "Update"; btnDelete.Enabled = true; } }
private void btnDelete_Click(object sender, EventArgs e) { if (MessageBox.Show("Are you Sure", "Delete Operation", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (var contex = new EFWINFORMDBEntities()) { c.CustomerID = Convert.ToInt32(dataGridView1.CurrentRow.Cells["CustomerID"].Value); var query = contex.Customer.Where(x => x.CustomerID == c.CustomerID).FirstOrDefault(); if (query != null) { contex.Customer.Remove(query); } contex.SaveChanges(); PopulateGrid(); Clear(); MessageBox.Show("Record Saved Sucefully"); } } }