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 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 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 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 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 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(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 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(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 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 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(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 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 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 btnadd_Click(object sender, EventArgs e)
{
try
{
ent = new Cfirst();
Supplier sp = new Supplier();
sp.supplierId = int.Parse(supplierId.Text);
sp.telephone = supplierphone.Text;
sp.fax = supplierFax.Text;
sp.Email = supplierEmail.Text;
sp.Mobile = supplierMobile.Text;
sp.Name = name.Text;
sp.website = supplierWebsite.Text;
ent.Suppliers.Add(sp);
ent.SaveChanges();
supplierId.Text = supplierMobile.Text = supplierphone.Text = supplierFax.Text =
supplierEmail.Text = supplierWebsite.Text = string.Empty;
gridupdate();
}
catch (Exception)
{
MessageBox.Show("problem with 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");
}
}
private void btnadd_Click(object sender, EventArgs e)
{
try
{
ent = new Cfirst();
Customer cu = new Customer();
cu.customerId = int.Parse(customerId.Text);
cu.telephone = customerphone.Text;
cu.fax = customerFax.Text;
cu.Mobile = customerMobile.Text;
cu.Email = customerEmail.Text;
cu.Name = name.Text;
cu.website = customerWebsite.Text;
ent.Customers.Add(cu);
ent.SaveChanges();
customerId.Text = customerEmail.Text = customerFax.Text = customerMobile.Text =
customerphone.Text = customerWebsite.Text = string.Empty;
gridupdate();
}
catch (Exception)
{
MessageBox.Show("fault in data entry");
}
}
