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");
}
