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