private void CategoryDGV_DoubleClick(object sender, EventArgs e) { category.c_id = Convert.ToInt32(CategoryDGV.CurrentRow.Cells[0].Value); categoryunit.c_id = Convert.ToInt32(CategoryDGV.CurrentRow.Cells[0].Value); using (StoreEFDBEntities storeEFDBEntities = new StoreEFDBEntities()) { category = storeEFDBEntities.Categories.Where(x => x.c_id == category.c_id).FirstOrDefault(); categoryunit = storeEFDBEntities.Category_Unit.Where(x => x.c_id == categoryunit.c_id).FirstOrDefault(); textBox5.Text = Convert.ToString(category.c_id); textBox6.Text = category.c_name; //if(categoryunit.unit_id !=) //{ textBox8.Text = Convert.ToString(categoryunit.unit_id); //} //else //{ // textBox8.Text = ""; // textBox7.Text = ""; //} textBox7.Text = categoryunit.unit; storeEFDBEntities.SaveChanges(); } }
private void CustomerDGV_DoubleClick(object sender, EventArgs e) { customer.cust_id = Convert.ToInt32(CustomerDGV.CurrentRow.Cells[0].Value); using (StoreEFDBEntities db = new StoreEFDBEntities()) { customer = db.Customers.Where(x => x.cust_id == customer.cust_id).FirstOrDefault(); textBox22.Text = customer.cust_id.ToString(); textBox21.Text = customer.cust_name; textBox20.Text = customer.cust_phone; textBox19.Text = customer.cust_fax; textBox18.Text = customer.cust_mobile; textBox17.Text = customer.cust_mail; textBox16.Text = customer.cust_website; db.SaveChanges(); } }
private void SupplierDGV_DoubleClick(object sender, EventArgs e) { supplier.supp_id = Convert.ToInt32(SupplierDGV.CurrentRow.Cells[0].Value); using (StoreEFDBEntities db = new StoreEFDBEntities()) { supplier = db.Suppliers.Where(x => x.supp_id == supplier.supp_id).FirstOrDefault(); textBox9.Text = supplier.supp_id.ToString(); textBox10.Text = supplier.supp_name; textBox11.Text = supplier.supp_phone; textBox12.Text = supplier.supp_fax; textBox13.Text = supplier.supp_mobile; textBox14.Text = supplier.supp_mail; textBox15.Text = supplier.supp_website; db.SaveChanges(); } }
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 StoreDGV_DoubleClick(object sender, EventArgs e) //selection from gridview { if (StoreDGV.CurrentRow.Index != -1) { store.s_id = Convert.ToInt32(StoreDGV.CurrentRow.Cells[0].Value); using (StoreEFDBEntities storeEFDBEntities = new StoreEFDBEntities()) { store = storeEFDBEntities.Stores.Where(x => x.s_id == store.s_id).FirstOrDefault(); textBox1.Text = store.s_id.ToString(); textBox2.Text = store.s_name; textBox3.Text = store.s_address; textBox4.Text = store.s_manager; storeEFDBEntities.SaveChanges(); } } }
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 button12_Click(object sender, EventArgs e) //customer insert btn { 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.Customers.Add(customer); db.SaveChanges(); } Clear(); CustomerGridViewer(); MessageBox.Show("Customer added 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 button7_Click(object sender, EventArgs e) //Supplier insert { 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.Suppliers.Add(supplier); db.SaveChanges(); } Clear(); SupplierGridViewer(); MessageBox.Show("Supplier added successfully!"); }
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 button1_Click(object sender, EventArgs e) // save in store { //string storeid = store.s_id.ToString(); //storeid = textBox1.Text; 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()) { //if (store.s_id == 0)//insert storeEFDBEntities.Stores.Add(store); //else //update // storeEFDBEntities.Entry(store).State = EntityState.Modified; storeEFDBEntities.SaveChanges(); } Clear(); StoresDataGridView(); MessageBox.Show("Store added successfully!"); }
private void SupplyPermissionDGV_DoubleClick(object sender, EventArgs e) { supplypermission.sp_id = Convert.ToInt32(SupplyPermissionDGV.CurrentRow.Cells[0].Value); //supplypermission.c_id = Convert.ToInt32(SupplyPermissionDGV.CurrentRow.Cells[4].Value); //supplypermission.s_id = Convert.ToInt32(SupplyPermissionDGV.CurrentRow.Cells[0].Value); using (StoreEFDBEntities db = new StoreEFDBEntities()) { supplypermission = db.SupplyPermissions.Where(x => x.sp_id == supplypermission.sp_id).FirstOrDefault(); textBox23.Text = supplypermission.sp_id.ToString(); textBox24.Text = supplypermission.sp_date.ToString(); textBox30.Text = supplypermission.s_id.ToString(); textBox25.Text = supplypermission.s_name; textBox31.Text = supplypermission.c_id.ToString(); textBox26.Text = supplypermission.c_quantity.ToString(); textBox32.Text = supplypermission.supp_id.ToString(); textBox27.Text = supplypermission.supp_name; textBox28.Text = supplypermission.prod_date.ToString(); textBox29.Text = supplypermission.exp_date.ToString(); db.SaveChanges(); } }
private void button4_Click(object sender, EventArgs e) //categ insert { category.c_id = categoryunit.c_id = Convert.ToInt32(textBox5.Text); category.c_name = textBox6.Text; categoryunit.unit_id = Convert.ToInt32(textBox8.Text); categoryunit.unit = textBox7.Text; using (StoreEFDBEntities db = new StoreEFDBEntities()) { //if (store.s_id == 0)//insert db.Categories.Add(category); db.Category_Unit.Add(categoryunit); //else //update // storeEFDBEntities.Entry(store).State = EntityState.Modified; db.SaveChanges(); } Clear(); CategoryDataGridView(); UnitCategoryDataGridView(); MessageBox.Show("Category added successfully!"); }
private void button13_Click(object sender, EventArgs e) //insert supply permission { 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.SupplyPermissions.Add(supplypermission); db.SaveChanges(); } Clear(); SupplyPermissionGridViewer(); MessageBox.Show("Supply permission added successfully!"); }