private void btAddP_Click(object sender, EventArgs e) { try { ent = new Cfirst(); supplyPermession sp = new supplyPermession(); Varieties_supplypermessions vsp = new Varieties_supplypermessions(); vsp.SupplyId = int.Parse(supplyId.Text); vsp.Varieties = variatiesName.Text; vsp.quantities = int.Parse(varietiesQuantity.Text); sp.SuplyId = int.Parse(supplyId.Text); sp.supplieName = supplierName.Text; sp.history = DateTime.Parse(permissionDate.Text); sp.Storename = storeName.Text; sp.supplieName = supplierName.Text; sp.ptoductionHistory = DateTime.Parse(productionHistory.Text); sp.expiry = expiry.Text; ent.Varieties_supplypermessions.Add(vsp); ent.supplyPermessions.Add(sp); ent.SaveChanges(); gridupdate(); } catch (Exception) { MessageBox.Show("Problem in Data Entry"); } }
private void btnadd_Click(object sender, EventArgs e) { try { Variety vi = new Variety(); ent = new Cfirst(); vi.code = int.Parse(varietiesCode.Text); vi.vName = variatiesName.Text; vi.measruingUnit = messurementUnit.Text; vi.storeID = int.Parse(storedId.Text); vi.quantity = int.Parse(qantity.Text); vi.productionDate = DateTime.Parse(productionDate.Text); vi.supplier = supplierName.Text; vi.expire = int.Parse(expire.Text); ent.Varieties.Add(vi); varietiesCode.Text = variatiesName.Text = messurementUnit.Text = storedId.Text = string.Empty; ent.SaveChanges(); gridupdate(); } catch (Exception) { MessageBox.Show("fault in data entering"); } }
private void btnedit_Click(object sender, EventArgs e) { try { ent = new Cfirst(); int code = int.Parse(varietiesCode.Text); Variety vi = (from em in ent.Varieties where em.code == code select em).FirstOrDefault(); vi.code = varietiesCode.Text == string.Empty ? vi.code : int.Parse(varietiesCode.Text); vi.vName = variatiesName.Text == string.Empty ? vi.vName : variatiesName.Text; vi.measruingUnit = messurementUnit.Text == string.Empty ? vi.measruingUnit : messurementUnit.Text; vi.supplier = supplierName.Text == string.Empty ? vi.supplier : supplierName.Text; vi.productionDate = productionDate.Text == string.Empty ? vi.productionDate : DateTime.Parse(productionDate.Text); vi.quantity = qantity.Text == string.Empty ? vi.quantity : int.Parse(qantity.Text); vi.expire = expire.Text == string.Empty ? vi.expire : int.Parse(expire.Text); vi.storeID = storedId.Text == string.Empty ? vi.storeID : int.Parse(storedId.Text); ent.SaveChanges(); gridupdate(); } catch (Exception) { MessageBox.Show("problem with the data"); } }
private void update_Click(object sender, EventArgs e) { try { ent = new Cfirst(); int id = int.Parse(dissmalId.Text); DismissalPermission sp = (from em in ent.DismissalPermissions where em.dismissalId == id select em).FirstOrDefault(); var vsp = (from en in ent.Varieties_Dismissalpermessions where en.dismissalId == id select en).FirstOrDefault(); sp.supplieName = customerName.Text == String.Empty ? sp.supplieName : customerName.Text; vsp.Varieties = variatiesName.Text == string.Empty ? vsp.Varieties : variatiesName.Text; vsp.quantities = varietiesQuantity.Text == string.Empty ? vsp.quantities : int.Parse(varietiesQuantity.Text); sp.expiry = expiry.Text == string.Empty ? sp.expiry : expiry.Text; sp.history = permissionDate.Text == string.Empty ? sp.history : DateTime.Parse(permissionDate.Text); sp.ptoductionHistory = productionHistory.Text == string.Empty ? sp.ptoductionHistory : DateTime.Parse(productionHistory.Text); sp.Storename = storeName.Text == string.Empty ? sp.supplieName : storeName.Text; ent.SaveChanges(); gridupdate(); } catch (Exception) { MessageBox.Show("somethin is wrong"); } }
private void btAddP_Click(object sender, EventArgs e) { try { ent = new Cfirst(); DismissalPermission dp = new DismissalPermission(); Varieties_Dismissalpermessions vdp = new Varieties_Dismissalpermessions(); int id = int.Parse(dissmalId.Text); Varieties_supplypermessions vsp = (from en in ent.Varieties_supplypermessions where en.SupplyId == id select en).FirstOrDefault(); vsp.quantities = vsp.quantities - int.Parse(varietiesQuantity.Text); vdp.dismissalId = int.Parse(dissmalId.Text); vdp.Varieties = variatiesName.Text; vdp.quantities = int.Parse(varietiesQuantity.Text); dp.supplieName = customerName.Text; dp.dismissalId = int.Parse(dissmalId.Text); dp.history = DateTime.Parse(permissionDate.Text); dp.Storename = storeName.Text; dp.ptoductionHistory = DateTime.Parse(productionHistory.Text); dp.expiry = expiry.Text; ent.Varieties_Dismissalpermessions.Add(vdp); ent.DismissalPermissions.Add(dp); ent.SaveChanges(); gridupdate(); } catch (Exception) { MessageBox.Show("something wrong in data entry"); } }
private void Add_Click(object sender, EventArgs e) { try { ent = new Cfirst(); //change quantities between tables store sof = (from em in ent.stores where em.name == fromStore.Text select em).First(); store sot = (from em in ent.stores where em.name == toStore.Text select em).First(); Variety vf = (from em in ent.Varieties where em.storeID == sof.storeId select em).First(); Variety vt = (from em in ent.Varieties where em.storeID == sot.storeId select em).First(); vf.quantity = vf.quantity - int.Parse(quantity.Text); vt.quantity = vf.quantity - int.Parse(quantity.Text); transform tr = new transform(); tr.transformid = int.Parse(transformId.Text); tr.sfrom = fromStore.Text; tr.sto = toStore.Text; tr.varieties = varieties.Text; tr.supplier = supplier.Text; tr.production_history = DateTime.Parse(pHistory.Text); tr.quantity = int.Parse(quantity.Text); tr.Expiry = expiry.Text; ent.transforms.Add(tr); ent.SaveChanges(); gridupdate(); } catch (Exception) { MessageBox.Show("Something wrong in Data entry"); } }
private void btndelete_Click(object sender, EventArgs e) { try { ent = new Cfirst(); int id = int.Parse(storedId.Text); store so = (from en in ent.stores where en.storeId == id select en).FirstOrDefault(); ent.stores.Remove(so); ent.SaveChanges(); gridupdate(); } catch (Exception) { MessageBox.Show("Fault in data entry"); } }
private void btndelete_Click(object sender, EventArgs e) { try { ent = new Cfirst(); int id = int.Parse(supplierId.Text); Supplier sp = (from en in ent.Suppliers where en.supplierId == id select en).FirstOrDefault(); ent.Suppliers.Remove(sp); ent.SaveChanges(); gridupdate(); } catch (Exception) { MessageBox.Show("problem with data entry"); } }
private void btndelete_Click(object sender, EventArgs e) { try { ent = new Cfirst(); int id = int.Parse(customerId.Text); Customer cu = (from en in ent.Customers where en.customerId == id select en).FirstOrDefault(); ent.Customers.Remove(cu); ent.SaveChanges(); gridupdate(); } catch (Exception) { MessageBox.Show("error in data entry"); } }
private void btndelete_Click(object sender, EventArgs e) { try { ent = new Cfirst(); int id = int.Parse(varietiesCode.Text); Variety vi = (from em in ent.Varieties where em.code == id select em).FirstOrDefault(); ent.Varieties.Remove(vi); ent.SaveChanges(); gridupdate(); } catch (Exception) { MessageBox.Show("problem in Data entry"); } }
private void btnAddV_Click(object sender, EventArgs e) { try { ent = new Cfirst(); Varieties_supplypermessions vsp = new Varieties_supplypermessions(); vsp.SupplyId = int.Parse(supplyId.Text); vsp.Varieties = variatiesName.Text; vsp.quantities = int.Parse(varietiesQuantity.Text); ent.Varieties_supplypermessions.Add(vsp); ent.SaveChanges(); } catch (Exception) { MessageBox.Show("something went wrong in data entry"); } }
private void btnedit_Click(object sender, EventArgs e) { try { ent = new Cfirst(); int id = int.Parse(storedId.Text); store so = (from en in ent.stores where en.storeId == id select en).FirstOrDefault(); so.name = storedName.Text == string.Empty ? so.name : storedName.Text; so.address = storedAddress.Text == string.Empty ? so.address : storedAddress.Text; so.admnistrator = storedAdminstrator.Text == string.Empty ? so.admnistrator : storedAdminstrator.Text; ent.SaveChanges(); gridupdate(); } catch (Exception) { MessageBox.Show("Fault in data entry"); } }
private void btnedit_Click(object sender, EventArgs e) { try { ent = new Cfirst(); int id = int.Parse(supplierId.Text); Supplier sp = (from em in ent.Suppliers where em.supplierId == id select em).FirstOrDefault(); sp.telephone = supplierphone.Text == string.Empty ? sp.telephone : supplierphone.Text; sp.fax = supplierFax.Text == string.Empty ? sp.fax : supplierFax.Text; sp.Mobile = supplierMobile.Text == string.Empty ? sp.Mobile : supplierMobile.Text; sp.Email = supplierEmail.Text == string.Empty ? sp.Email : supplierEmail.Text; sp.Name = name.Text == string.Empty ? sp.Name : name.Text; sp.website = supplierWebsite.Text == string.Empty ? sp.website : supplierWebsite.Text; ent.SaveChanges(); gridupdate(); } catch (Exception) { MessageBox.Show("problem with data entry"); } }
private void btnedit_Click(object sender, EventArgs e) { try { ent = new Cfirst(); int id = int.Parse(customerId.Text); Customer cu = (from em in ent.Customers where em.customerId == id select em).FirstOrDefault(); cu.telephone = customerphone.Text == string.Empty ? cu.telephone : customerphone.Text; cu.fax = customerFax.Text == string.Empty ? cu.fax : customerFax.Text; cu.Mobile = customerMobile.Text == string.Empty ? cu.Mobile : customerMobile.Text; cu.Email = customerEmail.Text == string.Empty ? cu.Email : customerEmail.Text; cu.Name = name.Text == string.Empty ? cu.Name : name.Text; cu.website = customerWebsite.Text == string.Empty ? cu.website : customerWebsite.Text; ent.SaveChanges(); gridupdate(); } catch (Exception) { MessageBox.Show("fault in data entry"); } }
private void btnadd_Click(object sender, EventArgs e) { try { store so = new store(); ent = new Cfirst(); so.storeId = int.Parse(storedId.Text); so.name = storedName.Text; so.address = storedAddress.Text; so.admnistrator = storedAdminstrator.Text; ent.stores.Add(so); ent.SaveChanges(); storedId.Text = storedName.Text = storedAddress.Text = storedAdminstrator.Text = string.Empty; gridupdate(); } catch (Exception) { MessageBox.Show("can't add 2 stores witn the same id"); } }
private void btnadd_Click(object sender, EventArgs e) { try { ent = new Cfirst(); Supplier sp = new Supplier(); sp.supplierId = int.Parse(supplierId.Text); sp.telephone = supplierphone.Text; sp.fax = supplierFax.Text; sp.Email = supplierEmail.Text; sp.Mobile = supplierMobile.Text; sp.Name = name.Text; sp.website = supplierWebsite.Text; ent.Suppliers.Add(sp); ent.SaveChanges(); supplierId.Text = supplierMobile.Text = supplierphone.Text = supplierFax.Text = supplierEmail.Text = supplierWebsite.Text = string.Empty; gridupdate(); } catch (Exception) { MessageBox.Show("problem with data entry"); } }
private void button2_Click(object sender, EventArgs e) { try { ent = new Cfirst(); int id = int.Parse(supplyId.Text); supplyPermession sp = (from em in ent.supplyPermessions where em.SuplyId == id select em).FirstOrDefault(); Varieties_supplypermessions vsp = (from en in ent.Varieties_supplypermessions where en.SupplyId == id select en).FirstOrDefault(); sp.supplieName = supplierName.Text == String.Empty ? sp.supplieName : supplierName.Text; vsp.Varieties = variatiesName.Text == string.Empty ? vsp.Varieties : variatiesName.Text; vsp.quantities = varietiesQuantity.Text == string.Empty ? vsp.quantities : int.Parse(varietiesQuantity.Text); sp.expiry = expiry.Text == string.Empty ? sp.expiry : expiry.Text; sp.supplieName = supplierName.Text == string.Empty ? sp.supplieName : supplierName.Text; sp.history = permissionDate.Text == string.Empty ? sp.history : DateTime.Parse(permissionDate.Text); sp.ptoductionHistory = productionHistory.Text == string.Empty ? sp.ptoductionHistory : DateTime.Parse(productionHistory.Text); sp.Storename = storeName.Text == string.Empty ? sp.supplieName : storeName.Text; ent.SaveChanges(); gridupdate(); } catch (Exception) { MessageBox.Show("Somethig went wrong in Data Entry"); } }
private void btnadd_Click(object sender, EventArgs e) { try { ent = new Cfirst(); Customer cu = new Customer(); cu.customerId = int.Parse(customerId.Text); cu.telephone = customerphone.Text; cu.fax = customerFax.Text; cu.Mobile = customerMobile.Text; cu.Email = customerEmail.Text; cu.Name = name.Text; cu.website = customerWebsite.Text; ent.Customers.Add(cu); ent.SaveChanges(); customerId.Text = customerEmail.Text = customerFax.Text = customerMobile.Text = customerphone.Text = customerWebsite.Text = string.Empty; gridupdate(); } catch (Exception) { MessageBox.Show("fault in data entry"); } }