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 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 vName_SelectedIndexChanged(object sender, EventArgs e) { ent = new Cfirst(); DateTime dateTime = DateTime.Today; Varieties_supplypermessions vsp = (from em in ent.Varieties_supplypermessions where em.Varieties == vName.Text select em).First(); supplyPermession sp = (from en in ent.supplyPermessions where en.SuplyId == vsp.SupplyId select en).First(); System.TimeSpan diff = dateTime.Subtract((DateTime)sp.history); Duration.Text = diff.ToString(); }
private void varietyName_SelectedIndexChanged(object sender, EventArgs e) { ent = new Cfirst(); Varieties_supplypermessions vsp = (from em in ent.Varieties_supplypermessions where em.Varieties == varietyName.Text select em).First(); int si = vsp.SupplyId; var sp = (from en in ent.supplyPermessions where en.SuplyId == si select en); storeName.Items.Clear(); foreach (var item in sp) { storeName.Items.Add(item.Storename); } }
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 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"); } }