public void AddPurchaseOrder(Dictionary <PurchaseOrder, List <Item_PurchaseOrder> > orderItems) { try { EFBroker_PurchaseOrder.AddPurchaseOrder(orderItems); string supervisorEmail = EFBroker_DeptEmployee.GetEmployeeListByRole("Store Supervisor")[0].Email; Utility.sendMail(supervisorEmail, "Purchase order", "There is a new purchase order created. Please review"); } catch (Exception e) { Console.WriteLine(e.Message); } }
public List <ItemPrice> GetItemPriceByItemCode(string itemCode) { return(EFBroker_PurchaseOrder.GetItemPriceByItemCode(itemCode)); }
public List <ItemPrice> GetItemPriceList() { return(EFBroker_PurchaseOrder.GetItemPriceList()); }
public List <ShortfallItems> GenerateShortfallItemsReport(DateTime startDate, DateTime endDate) { return(EFBroker_PurchaseOrder.GenerateShortfallItemsReport(startDate, endDate)); }
public List <ShortfallItems> GenerateReorderReportForPurchasedItems(DateTime startDate, DateTime endDate) { return(EFBroker_PurchaseOrder.GenerateReorderReportForPurchasedItems(startDate, endDate)); }
public List <ReorderItem> GetReorderItemList() { return(EFBroker_PurchaseOrder.GetReorderItemList()); }
public void DeletePurchaseOrder(int orderID) { EFBroker_PurchaseOrder.DeletePurchaseOrder(orderID); }
public List <DateTime?> GetAllReorderMonths() { List <DateTime?> allMonths = EFBroker_PurchaseOrder.GetAllFinalisedReorderMonths(); return(allMonths); }
public void ClosePurchaseOrder(PurchaseOrder pOrder) { EFBroker_PurchaseOrder.ClosePurchaseOrder(pOrder); }
public void UpdatePurchaseOrder(PurchaseOrder pOrder) { EFBroker_PurchaseOrder.UpdatePurchaseOrder(pOrder); return; }
public List <PurchaseOrderItemDetails> GetPurchaseOrderItemsDetails(int orderID) { return(EFBroker_PurchaseOrder.GetPurchaseOrderItemsDetailList(orderID)); }
public PurchaseOrder GetPurchaseOrderByID(int orderID) { return(EFBroker_PurchaseOrder.GetPurchaseOrderById(orderID)); }
public List <PurchaseOrder> SearchPurchaseOrder(string searchTxt) { return(EFBroker_PurchaseOrder.SearchPurchaseOrder(searchTxt)); }
public List <PurchaseOrder> GetPurchaseOrderListByStatus(string status) { return(EFBroker_PurchaseOrder.GetPurchaseOrderListByStatus(status)); }
public void UpdatePurchaseItem(Item_PurchaseOrder pItem) { EFBroker_PurchaseOrder.UpdatePurchaseItem(pItem); return; }
public List <PurchaseOrder> GetPurchaseOrderList() { return(EFBroker_PurchaseOrder.GetPurchaseOrderList()); }
protected void Page_Load(object sender, EventArgs e) { string itemCode = Request.QueryString["itemCode"]; string adjustment = "Adjustment"; //strings for stock card transaction type string disbursement = "Disbursement"; string purchase = "Purchase"; if (!ValidatorUtil.isEmpty(itemCode)) { Item item = EFBroker_Item.GetItembyItemCode(itemCode); string currentYear = DateTime.Now.Year.ToString(); List <PriceList> plList = EFBroker_PriceList.GetPriceListByItemCode(itemCode).Where(c => c.TenderYear == currentYear).ToList(); if (item != null && plList.Count > 0) { lblItemCode.Text = item.ItemCode; lblItemName.Text = item.Description; lblBin.Text = item.Bin; lblUom.Text = item.UnitOfMeasure; foreach (PriceList pl in plList) { switch (pl.SupplierRank) { case 1: lblSupp1.Text = pl.SupplierCode; break; case 2: lblSupp2.Text = pl.SupplierCode; break; case 3: lblSupp3.Text = pl.SupplierCode; break; } } if (plList.Count < 3) // N/A on supplier labels if there are less than 3 suppliers { lblSupp3.Text = "N/A"; if (plList.Count < 2) { lblSupp2.Text = "N/A"; } } List <StockCard> scList = EFBroker_StockCard.GetStockCardsByItemCode(itemCode); List <StockCardDisplayRow> scDisplayList = new List <StockCardDisplayRow>(); foreach (StockCard sc in scList) { if (sc.TransactionType == adjustment || sc.TransactionType == disbursement || sc.TransactionType == purchase) { //Possible to display 3 types of stock card entries (each accessing different tables) StockCardDisplayRow scdr = new StockCardDisplayRow(); if (sc.TransactionType == adjustment) { Discrepency d = EFBroker_Discrepancy.GetDiscrepancyById((int)sc.TransactionDetailID); scdr.TransDate = ((DateTime)d.Date).ToShortDateString(); scdr.TransDetails = "Adjustment ID. " + sc.TransactionDetailID; scdr.Quantity = "ADJ " + GetQuantityString((int)sc.Qty); } else if (sc.TransactionType == purchase) { PurchaseOrder po = EFBroker_PurchaseOrder.GetPurchaseOrderById((int)sc.TransactionDetailID); scdr.TransDate = ((DateTime)po.ExpectedDate).ToShortDateString(); scdr.TransDetails = "Supplier - " + po.SupplierCode; Item_PurchaseOrder ipo = EFBroker_PurchaseOrder.GetPurchaseOrderItem(po.PurchaseOrderID, itemCode); scdr.Quantity = GetQuantityString((int)sc.Qty); } else if (sc.TransactionType == disbursement) { Disbursement db = EFBroker_Disbursement.GetDisbursmentbyDisbID((int)sc.TransactionDetailID); scdr.TransDate = ((DateTime)db.CollectionDate).ToShortDateString(); scdr.TransDetails = EFBroker_DeptEmployee.GetDepartByDepCode(db.DeptCode).DeptName; scdr.Quantity = GetQuantityString((int)sc.Qty); } scdr.Balance = (int)sc.Balance; scDisplayList.Add(scdr); } } gvTransactions.DataSource = scDisplayList; gvTransactions.DataBind(); } else //if item is not found or no entries found in price list table { Response.Redirect(LoginController.StationeryCatalogueURI); } } else //if there is no itemCode in querystring { Response.Redirect(LoginController.StationeryCatalogueURI); } }