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