private void btnSave_Click(object sender, EventArgs e) { model.Name = txtName1.Text.Trim(); model.Surname = txtSurname.Text.Trim(); model.INN = txtINN.Text.Trim(); model.City = txtCity.Text.Trim(); model.Street = txtStreet.Text.Trim(); model.DomAndKV = txtDKV.Text.Trim(); model.Status = txtRemove1.Text.Trim(); using (ZakupkaSuria1Entities db = new ZakupkaSuria1Entities()) { if (model.IdSupplier == 0)//Insert { db.Supplier.Add(model); } else //Update { db.Entry(model).State = EntityState.Modified; } db.SaveChanges(); } Clear(); PopulateDataGridView(); MessageBox.Show("Submitted Successfully"); }
private void btnDelete_Click(object sender, EventArgs e) { if (MessageBox.Show("Are You Sure to Delete this Record ?", "EF CRUD Operation", MessageBoxButtons.YesNo) == DialogResult.Yes) { using (ZakupkaSuria1Entities db = new ZakupkaSuria1Entities()) { var entry = db.Entry(model); if (entry.State == EntityState.Detached) { db.IdProdukts.Attach(model); } db.IdProdukts.Remove(model); db.SaveChanges(); PopulateDataGridView(); Clear(); MessageBox.Show("Deleted Successfully"); } } }
private void btnSave_Click(object sender, EventArgs e) { model.Articul = txtArt.Text.Trim(); model.Name = txtName.Text.Trim(); model.Remove = txtRemove.Text.Trim(); using (ZakupkaSuria1Entities db = new ZakupkaSuria1Entities()) { if (model.IdGoods == 0)//Insert { db.IdProdukts.Add(model); } else //Update { db.Entry(model).State = EntityState.Modified; } db.SaveChanges(); } Clear(); PopulateDataGridView(); MessageBox.Show("Submitted Successfully"); }