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