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