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);
}
}
