public bool createTransaction(Disbursement_M disbl, item newitem,int userid) { bool ans = false; //Save In transaction transaction t = new transaction(); t.TransDate = DateTime.Now; t.TransItemID = disbl.ItemID; t.TransItemQuant = disbl.RequiredQuant; t.TransItemBalance = newitem.ItemQuant ?? default (int); t.TransReason = "Retrived For Department " + disbl.DepID; t.TransactionType = "out"; t.TranUserID = userid; t.TransCode = "RTR"; try { se.transactions.Add(t); se.SaveChanges(); ans = true; } catch { ans = false; } return ans; }
public bool UpdateItem(String itemID, String quantity, String userID) { try { int id = Convert.ToInt32(itemID); int updateqty = Convert.ToInt32(quantity); var query = from p in entities.items where p.ItemID == id select p; item _item = query.SingleOrDefault(); //Get original quantity int originalqty = _item.ItemQuant ?? default(int); //Update the quantity _item.ItemQuant = updateqty; entities.SaveChanges(); //Save In Transaction if original qty < update quantity transtype is in if (originalqty < updateqty) { transaction t = new transaction(); // t.TransID = 1; t.TransCode = "ADJ"; t.TransactionType = "in"; t.TransDate = DateTime.Today.Date; t.TransItemQuant =updateqty - originalqty; t.TransItemBalance = updateqty; t.TransItemID = _item.ItemID; t.TransReason = "Monthly Adjustment run"; t.TranUserID = Convert.ToInt32(userID); entities.transactions.Add(t); entities.SaveChanges(); } else { transaction t = new transaction(); //t.TransID = 1; t.TransCode = "ADJ"; t.TransactionType = "out"; t.TransDate = DateTime.Today.Date; t.TransItemQuant = originalqty-updateqty; t.TransItemBalance = updateqty; t.TransItemID = _item.ItemID; t.TransReason = "Monthly Adjustment run"; t.TranUserID = Convert.ToInt32(userID); entities.transactions.Add(t); } entities.SaveChanges(); } catch (Exception ex) { String aa = ex.ToString(); } return true; }
//By Seint San Thandar bo public bool UpdatePurchaseOrder(String poID, String approveEmpID) { try { int id = Convert.ToInt32(poID); var query = from p in se.purchaseorders where p.POID == id select p; purchaseorder po = query.SingleOrDefault(); // po.POApprovedByEmpID = Convert.ToInt32(approveEmpID); po.PORecieveDate = DateTime.Today.Date; //Save In Transaction var podetail = from pd in se.purchaseorderdetails where pd.POID == id select pd; List<purchaseorderdetail> details = podetail.ToList<purchaseorderdetail>(); foreach (purchaseorderdetail d in details) { transaction t = new transaction(); t.TransCode = "PO"; t.TransactionType = "in"; t.TransDate = DateTime.Today.Date; t.TransItemBalance = d.POItemQuant; t.TransItemID = d.POItemID; t.TransReason = "PO Received"; t.TranUserID = Convert.ToInt32(approveEmpID); se.transactions.Add(t); //Update Item balance var q = from i in se.items where i.ItemID == d.POItemID select i; item iTem = q.SingleOrDefault(); iTem.ItemQuant = iTem.ItemQuant + d.POItemQuant; se.SaveChanges(); } return true; } catch (Exception ex) { return false; } }
public bool UpdatePurchaseOrderDetailStatusApprove(int poid) { purchaseorder p = new purchaseorder(); List<purchaseorderdetail> pd = new List<purchaseorderdetail>(); item itm = new item(); try { p = cntx.purchaseorders.Find(poid); p.PORecieveDate = DateTime.Now; pd = (from f in cntx.purchaseorderdetails where f.POID==poid select f).ToList(); foreach (purchaseorderdetail dd in pd) { int poQty = dd.POItemQuant; dd.POStatus = "approved"; //increase item quantity itm = (from it in cntx.items where it.ItemID == dd.POItemID select it).FirstOrDefault(); int itmQty = int.Parse(itm.ItemQuant.ToString()); int total = poQty + itmQty; itm.ItemQuant = total; //increase item quantity //Include Tranaction Table transaction tnew = new transaction(); tnew.TransItemID = itm.ItemID; tnew.TransDate = DateTime.Now; tnew.TransItemBalance = total; tnew.TransItemQuant = poQty; tnew.TransReason = "Recieved Purchase Order from Supplier"; tnew.TransactionType = "in"; tnew.TranUserID = Convert.ToInt32(System.Web.HttpContext.Current.Session["userid"]); tnew.TransCode = "Purchase"; cntx.transactions.Add(tnew); } cntx.SaveChanges(); return true; } catch (Exception ex) { throw ex; } }
public bool addItems(int itemCatID, string itemdesp, int quant, int itemReO, int itemReOQ, string uom, string BNom, int Supplier1ID, int Supplier2ID, int Supplier3ID, int SPrice1, int SPrice2, int SPrice3) { itemsupplier its1 = new itemsupplier(); itemsupplier its2 = new itemsupplier(); itemsupplier its3 = new itemsupplier(); supplier s1 = new supplier(); supplier s2 = new supplier(); supplier s3 = new supplier(); s1 = se.suppliers.Find(Supplier1ID); s2 = se.suppliers.Find(Supplier2ID); s3 = se.suppliers.Find(Supplier3ID); bin newbin = new bin(); var q = from b in se.bins where b.BinNumber == BNom select b; newbin = q.FirstOrDefault(); bool ans = false; item Item = new item(); Item.ItemCatID = itemCatID; Item.ItemDescription = itemdesp; Item.ItemQuant = quant; Item.ItemReOrderLvl = itemReO; Item.ItemReOrderQuant = itemReOQ; Item.ItemUOM = uom; Item.bin = newbin; try { se.items.Add(Item); se.SaveChanges(); } catch (Exception) { //dos something } //adding for Supplier1 its1.item = Item; its1.Price = SPrice1; its1.supplier = s1; its1.SupplierRank = 1; se.itemsuppliers.Add(its1); //adding for Supplier2 its2.item = Item; its2.Price = SPrice2; its2.supplier = s2; its2.SupplierRank = 2; se.itemsuppliers.Add(its2); //adding for Supplier3 its3.item = Item; its3.Price = SPrice3; its3.supplier = s3; its3.SupplierRank = 3; se.itemsuppliers.Add(its3); try { se.SaveChanges(); ans = true; } catch (Exception ex) { ans = false; } //Adding to Transsaction Tables transaction it = new transaction(); it.TransactionType = "in"; it.TransCode = "NEWITEM"; //yet to decide it.TransDate = DateTime.Today; it.TransItemBalance = Item.ItemQuant ?? default(int); it.TransItemQuant = Item.ItemQuant ?? default(int); it.TransReason = "Added new Item: " + Item.ItemDescription; it.TranUserID = Convert.ToInt32(System.Web.HttpContext.Current.Session["userid"]); it.TransItemID = Item.ItemID; se.transactions.Add(it); se.SaveChanges(); return ans; }