private void btnAdd_Click(object sender, EventArgs e) { try { using (var context = new ProductType1Entities()) { var model_ProductType = new ProductType(); string Name = txtName.Text; model_ProductType.Name = txtName.Text; model_ProductType.Remark = txtRemark.Text; var model = context.ProductTypes.Where(a => a.Name == Name).FirstOrDefault(); if (model == null) { context.ProductTypes.Add(model_ProductType); } else { var entry = context.Entry(model); entry.CurrentValues.SetValues(model_ProductType); entry.State = System.Data.Entity.EntityState.Modified; } context.SaveChanges(); Load_Data_Grid(); } MessageBox.Show("Product Added Successfully!"); } catch (Exception ee) { MessageBox.Show(ee.Message); } }
private void btnDelete_Click_1(object sender, EventArgs e) { using (var context = new ProductType1Entities()) { var model_ProductType = new ProductType(); string Name = txtName.Text; var model = context.ProductTypes.Where(a => a.Name == Name).FirstOrDefault(); if (model != null) { context.ProductTypes.Remove(model); context.SaveChanges(); PopulateDataGridView(); MessageBox.Show("Product Deleted Successfully"); } } }