public WCFRegenerateRequest GetRegenerateDate(string disbId)
{
string reqDate = (disbCon.GetRegenrateDate(Convert.ToInt32(disbId))).ToLongDateString();
string depName = EFBroker_Disbursement.GetDisbursmentbyDisbID(Convert.ToInt32(disbId)).Department.DeptName;
string reqBy = EFBroker_DeptEmployee.GetDeptRepByDeptCode(depName);
WCFRegenerateRequest r = new WCFRegenerateRequest();
r = WCFRegenerateRequest.Make(reqDate, reqBy, depName);
return(r);
}
public void RegenerateRequisition(List <WCFRequestedItem> regenList)
{
int disbId = 0;
List <RequestedItem> requItemList = new List <RequestedItem>();
foreach (WCFRequestedItem r in regenList)
{
RequestedItem rItem = new RequestedItem(r.Code, r.Description, Convert.ToInt32(r.ShortfallQty), RequisitionControl.getUOM(r.Code));
disbId = r.DisbId;
requItemList.Add(rItem);
}
DateTime date = (disbCon.GetRegenrateDate(disbId));
string depName = EFBroker_Disbursement.GetDisbursmentbyDisbID(Convert.ToInt32(disbId)).Department.DeptName;
string reqBy = EFBroker_DeptEmployee.GetDeptRepByDeptCode(depName);
int empID = EFBroker_DeptEmployee.GetDeptRepEmpIDByDeptCode(depName);
string depCode = EFBroker_DeptEmployee.GetDepartByEmpID(empID).DeptCode;
string status = "Priority";
RequisitionControl.addNewRequisitionItem(requItemList, date, status, empID, depCode);
}
//
public void AddDisbursement(int requisitionId, List <int> requisitionNo)
{
List <int> disbursementIDList = new List <int>();
Disbursement d = new Disbursement();
List <int> requestedByList = new List <int>(); //EmpID
List <string> departmentCodeList = new List <string>();
foreach (int i in requisitionNo)
{
requestedByList.Add((int)(EFBroker_Requisition.GetRequisitionByID(i).RequestedBy));
}
//foreach requestedByList get depcode
foreach (int i in requestedByList)
{
string departmentCode = EFBroker_DeptEmployee.GetDepartByEmpID(i).DeptCode.ToString();
if (departmentCodeList.Count() != 0)
{
bool add = true;
foreach (string s in departmentCodeList)
{
if (s == departmentCode)
{
add = false;
}
}
if (add)
{
departmentCodeList.Add(departmentCode);
}
}
else
{
departmentCodeList.Add(departmentCode);
}
}
//foreach depcode add disbursement + disbDetail
foreach (string i in departmentCodeList)
{
//add Disbursement
d.RetrievalID = requisitionId;
d.DeptCode = i;
d.Status = "Pending";
int disbursementId = EFBroker_Disbursement.AddNewDisbursment(d);
disbursementIDList.Add(disbursementId);//auto increasement disbursementIDList after SaveChanges
}
foreach (int i in disbursementIDList)
{
string departmentCode = EFBroker_Disbursement.GetDisbursmentbyDisbID(i).DeptCode;
foreach (int no in requisitionNo)
{
//update requisition table
Requisition r = new Requisition();
r = EFBroker_Requisition.GetRequisitionByID(no);
string dep = EFBroker_DeptEmployee.GetDepartByEmpID(r.RequestedBy ?? 0).DeptCode;//if null, ==0
if (dep == departmentCode)
{
r.Status = "InProgress";/////////////////////////////////////////////
r.DisbursementID = i;
EFBroker_Requisition.UpdateRequisition(r);
}
}
AddDisbursemen_Item(i);
}
}
//GET DISBURSEMENT DETAIL OBJECT TO DISPLAY
public DisbursementListItems DisbursementListItemsObj(int disbId)
{
Disbursement disb = EFBroker_Disbursement.GetDisbursmentbyDisbID(disbId);
return(CreateDisbursementListItem(disb));
}
//Get Current Disbursement
public Disbursement GetCurrentDisbursement(int disbId)
{
return(EFBroker_Disbursement.GetDisbursmentbyDisbID(disbId));
}
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);
}
}
