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 varatiesExpiry_Load(object sender, EventArgs e)
{
ent = new Cfirst();
DateTime dateTime = DateTime.Today;
var vi = from em in ent.Varieties select em;
foreach (var item in vi)
{
System.TimeSpan diff = dateTime.Subtract((DateTime)item.productionDate);
int s = (int)diff.Days;
int result = (int)(s - item.expire);
if (result <= 60)
{
if (result <= 0)
{
varietyName.Items.Add(item.vName + " Expiry End");
}
else
{
varietyName.Items.Add(item.vName + " " + result);
}
}
}
dataGridView1.DataSource = vi.ToList();
dataGridView1.Columns["store"].Visible = false;
}
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 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 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 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 storeName_SelectedIndexChanged(object sender, EventArgs e)
{
ent = new Cfirst();
var v = (from em in ent.Varieties where em.vName == vName.Text select em).ToList();
dataGridView1.DataSource = v;
dataGridView1.Columns["store"].Visible = false;
}
private void storeName_SelectedIndexChanged(object sender, EventArgs e)
{
ent = new Cfirst();
var sp = (from em in ent.supplyPermessions where em.Storename == storeName.Text select em).ToList();
dataGridView1.DataSource = sp;
dataGridView1.Columns["Varieties_supplypermessions"].Visible = false;
}
private void VarietyReport_Load(object sender, EventArgs e)
{
ent = new Cfirst();
var va = from em in ent.Varieties select em;
foreach (var item in va)
{
vName.Items.Add(item.vName);
}
}
private void VarietiesDurationReport_Load(object sender, EventArgs e)
{
ent = new Cfirst();
var va = (from em in ent.Varieties_supplypermessions select em);
foreach (var item in va)
{
vName.Items.Add(item.Varieties);
}
}
private void varitiesSituation_Load(object sender, EventArgs e)
{
ent = new Cfirst();
var sp = from em in ent.Varieties_supplypermessions select em;
foreach (var item in sp)
{
varietyName.Items.Add(item.Varieties);
}
}
private void storesReport_Load(object sender, EventArgs e)
{
ent = new Cfirst();
var so = from em in ent.stores select em;
foreach (var item in so)
{
storeName.Items.Add(item.name);
}
}
private void Form5_Load(object sender, EventArgs e)
{
gridupdate();
ent = new Cfirst();
var so = from em in ent.stores select em;
foreach (var s in so)
{
storeName.Items.Add(s.name);
}
}
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 storeName_SelectedIndexChanged(object sender, EventArgs e)
{
ent = new Cfirst();
store so = (from em in ent.stores where em.name == storeName.Text select em).First();
address.Text = so.address;
adminstrator.Text = so.admnistrator;
int id = so.storeId;
var vr = (from en in ent.Varieties where en.storeID == id select en).ToList();
dataGridView1.DataSource = vr;
dataGridView1.Columns["store"].Visible = false;
}
private void gridupdate()
{
try
{
ent = new Cfirst();
dataGridView1.DataSource = ent.DismissalPermissions.ToList();
dataGridView2.DataSource = ent.Varieties_Dismissalpermessions.ToList();
dataGridView1.Columns["Varieties_Dismissalpermessions"].Visible = false;
dataGridView2.Columns["DismissalPermission"].Visible = false;
}
catch (Exception)
{
MessageBox.Show("something wrong in data entry");
}
}
private void vName_SelectedIndexChanged(object sender, EventArgs e)
{
ent = new Cfirst();
var v = from em in ent.Varieties where em.vName == vName.Text select em;
foreach (var item in v)
{
storeName.Items.Clear();
var so = from em in ent.stores where em.storeId == item.storeID select em;
foreach (var i in so)
{
storeName.Items.Add(i.name);
}
}
}
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 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 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(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(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 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 storeName_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
ent = new Cfirst();
store so = (from em in ent.stores where em.name == storeName.Text select em).FirstOrDefault();
var va = from em in ent.Varieties where em.storeID == so.storeId select em;
variatiesName.Items.Clear();
foreach (var i in va)
{
variatiesName.Items.Add(i.vName);
}
}
catch (Exception)
{
MessageBox.Show("something went wrong in dataEntry");
}
}
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(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 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 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 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");
}
}