private void button5_Click(object sender, EventArgs e) //update btn
{
category.c_id = Convert.ToInt32(textBox5.Text);
category.c_name = textBox6.Text;
//categoryunit.unit_id = Convert.ToInt32(textBox8.Text);
categoryunit.unit = textBox7.Text;
//categoryunit.c_id = Convert.ToInt32(textBox5.Text);
using (StoreEFDBEntities db = new StoreEFDBEntities())
{
db.Entry(category).State = EntityState.Modified;
db.Entry(categoryunit).State = EntityState.Modified;
db.SaveChanges();
}
Clear();
CategoryDataGridView();
UnitCategoryDataGridView();
MessageBox.Show("Category updated successfully!");
}
private void button2_Click(object sender, EventArgs e) //update btn
{
store.s_id = Convert.ToInt32(textBox1.Text);
store.s_name = textBox2.Text;
store.s_address = textBox3.Text;
store.s_manager = textBox4.Text;
using (StoreEFDBEntities storeEFDBEntities = new StoreEFDBEntities())
{
storeEFDBEntities.Entry(store).State = EntityState.Modified;
storeEFDBEntities.SaveChanges();
}
Clear();
StoresDataGridView();
MessageBox.Show("Store updated successfully!");
}
private void button11_Click(object sender, EventArgs e) //customer update
{
customer.cust_id = Convert.ToInt32(textBox22.Text);
customer.cust_name = textBox21.Text;
customer.cust_phone = textBox20.Text;
customer.cust_fax = textBox19.Text;
customer.cust_mobile = textBox18.Text;
customer.cust_mail = textBox17.Text;
customer.cust_website = textBox16.Text;
using (StoreEFDBEntities db = new StoreEFDBEntities())
{
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
}
Clear();
SupplierGridViewer();
MessageBox.Show("Customer updated successfully!");
}
private void button8_Click(object sender, EventArgs e) //supplier update btn
{
supplier.supp_id = Convert.ToInt32(textBox9.Text);
supplier.supp_name = textBox10.Text;
supplier.supp_phone = textBox11.Text;
supplier.supp_fax = textBox12.Text;
supplier.supp_mobile = textBox13.Text;
supplier.supp_mail = textBox14.Text;
supplier.supp_website = textBox15.Text;
using (StoreEFDBEntities db = new StoreEFDBEntities())
{
db.Entry(supplier).State = EntityState.Modified;
db.SaveChanges();
}
Clear();
SupplierGridViewer();
MessageBox.Show("Supplier updated successfully!");
}
private void button14_Click(object sender, EventArgs e) //update btn
{
supplypermission.sp_id = Convert.ToInt32(textBox23.Text);
supplypermission.sp_date = Convert.ToDateTime(textBox24.Text);
supplypermission.s_name = textBox25.Text;
supplypermission.c_quantity = Convert.ToInt32(textBox26.Text);
supplypermission.supp_name = textBox27.Text;
supplypermission.prod_date = Convert.ToDateTime(textBox28.Text);
supplypermission.exp_date = Convert.ToDateTime(textBox29.Text);
supplypermission.s_id = Convert.ToInt32(textBox30.Text);
supplypermission.c_id = Convert.ToInt32(textBox31.Text);
supplypermission.supp_id = Convert.ToInt32(textBox32.Text);
using (StoreEFDBEntities db = new StoreEFDBEntities())
{
db.Entry(supplypermission).State = EntityState.Modified;
db.SaveChanges();
}
Clear();
SupplyPermissionGridViewer();
MessageBox.Show("Supply permission updated successfully!");
}