private int?findId() { int? x = 0; ShopkeyContext db = new ShopkeyContext(); var xx = db.Items.FirstOrDefault(); if (xx != null) { x = db.Items.Max(a => a.Itemid); } x = x + 1; return(x); }
public String setsaleshaders([Service] ShopkeyContext db, saleshaderswrapper iteeeee) { String msg = ""; try { switch (iteeeee.txnCheck5) { case 1: db.Salesheader.Add(iteeeee.salesheader); db.SaveChanges(); msg = "ok"; break; case 2: var modi = db.Salesheader.Where(a => a.Billno == iteeeee.salesheader.Billno).FirstOrDefault(); modi.Salesdate = iteeeee.salesheader.Salesdate; modi.Cname = iteeeee.salesheader.Cname; modi.Mobile = iteeeee.salesheader.Mobile; modi.Baseamt = iteeeee.salesheader.Baseamt; modi.Taxes = iteeeee.salesheader.Taxes; modi.Discount = iteeeee.salesheader.Discount; modi.Totamt = iteeeee.salesheader.Totamt; msg = "ok"; db.SaveChanges(); break; case 3: var irm = db.Salesheader.Where(a => a.Billno == iteeeee.salesheader.Billno).FirstOrDefault(); db.Remove(irm); db.SaveChanges(); msg = "ok"; break; } } catch (Exception ee) { return(ee.Message); } iteeeee.result5 = msg; return(iteeeee.result5); }
public String setPurchasesheaders([Service] ShopkeyContext db, purchasesheaderswrapper iteee) { String msg = ""; try { switch (iteee.txnCheck3) { case 1: db.Purchasesheader.Add(iteee.purchasesheader); db.SaveChanges(); msg = "ok"; break; case 2: var modi = db.Purchasesheader.Where(a => a.Mir == iteee.purchasesheader.Mir).FirstOrDefault(); modi.Purchesesdate = iteee.purchasesheader.Purchesesdate; modi.Suppliers = iteee.purchasesheader.Suppliers; modi.Mobile = iteee.purchasesheader.Mobile; modi.Taxes = iteee.purchasesheader.Taxes; modi.Totamt = iteee.purchasesheader.Totamt; modi.Discount = iteee.purchasesheader.Discount; modi.Totamt = iteee.purchasesheader.Totamt; msg = "ok"; db.SaveChanges(); break; case 3: var irm = db.Purchasesheader.Where(a => a.Mir == iteee.purchasesheader.Mir).FirstOrDefault(); db.Remove(irm); db.SaveChanges(); msg = "ok"; break; } } catch (Exception ee) { return(ee.Message); } iteee.result3 = msg; return(iteee.result3); }
public String setsaleslines([Service] ShopkeyContext db, saleslineswrapper iteeeeee) { String msg = ""; try { switch (iteeeeee.txnCheck6) { case 1: db.Salesline.Add(iteeeeee.salesline); db.SaveChanges(); msg = "ok"; break; case 2: var modi = db.Salesline.Where(a => a.Billno == iteeeeee.salesline.Sno).FirstOrDefault(); modi.Itemname = iteeeeee.salesline.Itemname; modi.Rat = iteeeeee.salesline.Rat; msg = "ok"; db.SaveChanges(); break; case 3: var irm = db.Salesline.Where(a => a.Billno == iteeeeee.salesline.Sno).FirstOrDefault(); db.Remove(irm); db.SaveChanges(); msg = "ok"; break; } } catch (Exception ee) { return(ee.Message); } iteeeeee.result6 = msg; return(iteeeeee.result6); }
public String setPurchselines([Service] ShopkeyContext db, purchaselinesswrapper iteeee) { String msg = ""; try { switch (iteeee.txnCheck4) { case 1: db.Purchaseslines.Add(iteeee.purchaseslines); db.SaveChanges(); msg = "ok"; break; case 2: var modi = db.Purchaseslines.Where(a => a.Mir == iteeee.purchaseslines.Sno).FirstOrDefault(); modi.Pitem = iteeee.purchaseslines.Pitem; modi.Rat = iteeee.purchaseslines.Rat; msg = "ok"; db.SaveChanges(); break; case 3: var irm = db.Purchasesheader.Where(a => a.Mir == iteeee.purchaseslines.Sno).FirstOrDefault(); db.Remove(irm); db.SaveChanges(); msg = "ok"; break; } } catch (Exception ee) { return(ee.Message); } iteeee.result4 = msg; return(iteeee.result4); }
public String setiteamss([Service] ShopkeyContext db, itemsswrapper ite) { String msg = ""; try { switch (ite.txnCheck1) { case 1: db.Items.Add(ite.items); db.SaveChanges(); msg = "ok"; break; case 2: var modi = db.Items.Where(a => a.Itemid == ite.items.Itemid).FirstOrDefault(); modi.Itemname = ite.items.Itemname; modi.Grpid = ite.items.Grpid; modi.Uom = ite.items.Uom; msg = "ok"; db.SaveChanges(); break; case 3: var irm = db.Itemgroups.Where(a => a.Grpid == ite.items.Itemid).FirstOrDefault(); db.Remove(irm); db.SaveChanges(); msg = "ok"; break; } } catch (Exception ee) { return(ee.Message); } ite.result1 = msg; return(ite.result1); }
public String setitems([Service] ShopkeyContext db, itemgrouwrapper it) { String msg = ""; try { switch (it.txnCheck) { case 1: db.Itemgroups.Add(it.itemgroups); db.SaveChanges(); msg = "ok"; break; case 2: var adit = db.Itemgroups.Where(a => a.Grpid == it.itemgroups.Grpid).FirstOrDefault(); adit.Grpname = it.itemgroups.Grpname; adit.Maingrp = it.itemgroups.Maingrp; msg = "ok"; db.SaveChanges(); break; case 3: var itm = db.Itemgroups.Where(a => a.Grpid == it.itemgroups.Grpid).FirstOrDefault(); db.Remove(itm); db.SaveChanges(); msg = "ok"; break; } } catch (Exception ee) { return(ee.Message); } it.result = msg; return(it.result); }
public String setprices([Service] ShopkeyContext db, pricelistswrapper itee) { String msg = ""; try { switch (itee.txnCheck2) { case 1: db.Pricelist.Add(itee.pricelist); db.SaveChanges(); msg = "ok"; break; case 2: var modi = db.Pricelist.Where(a => a.Itemid == itee.pricelist.Itemid).FirstOrDefault(); modi.Rat = itee.pricelist.Rat; msg = "ok"; db.SaveChanges(); break; case 3: var irm = db.Pricelist.Where(a => a.Itemid == itee.pricelist.Itemid).FirstOrDefault(); db.Remove(irm); db.SaveChanges(); msg = "ok"; break; } } catch (Exception ee) { return(ee.Message); } itee.result2 = msg; return(itee.result2); }
public IQueryable <Materialmanagement> GetMaterialmanagements([Service] ShopkeyContext db) { return(db.Materialmanagement); }
public IQueryable <Pricelist> GetPricelist([Service] ShopkeyContext db) { return(db.Pricelist); }
public IQueryable <Salesline> GetSaleslines([Service] ShopkeyContext db) { return(db.Salesline); }
public IQueryable <Salesheader> GetSalesheader([Service] ShopkeyContext db) { return(db.Salesheader); }
public IQueryable <Purchaseslines> GetPurchaselines([Service] ShopkeyContext db) { return(db.Purchaseslines); }
public IQueryable <Purchasesheader> GetPurchaseheader([Service] ShopkeyContext db) { return(db.Purchasesheader); }
public IQueryable <Itemgroups> GetItemGroups([Service] ShopkeyContext db) { return(db.Itemgroups); }