//populate shortfall data for sub gridview
public List <RetrievalShortfallItemSub> DisplayRetrievalShortfallSubGridView(int requisitionId, string shortfallItemCode)
{
List <RetrievalShortfallItemSub> RetrievalShortfallItemSubGridViewList = new List <RetrievalShortfallItemSub>();
List <Disbursement> disbursementList = EFBroker_Disbursement.GetDisbursmentListbyRetrievalID(requisitionId);
int i = 0;
foreach (Disbursement d in disbursementList)
{
foreach (Requisition r in EFBroker_Requisition.GetRequisitionListByDisbursementID(d.DisbursementID))
{
//if only one departmentName
string departmentName = d.Department.DeptName.ToString();
string departmentCode = d.Department.DeptCode.ToString();
try
{
int requestedQty = EFBroker_Requisition.FindReqItemsByReqIDItemID(r.RequisitionID, shortfallItemCode).RequestedQty ?? 0; //if RequestedQty is null, assign to 0
//actualQty(0) bind with avialableQty(retrievedQty)
RetrievalShortfallItemSub rsfs = new RetrievalShortfallItemSub((DateTime)r.RequestDate, departmentName, departmentCode, requestedQty, 0, shortfallItemCode);
RetrievalShortfallItemSubGridViewList.Add(rsfs);
i++;
}
catch (Exception e)
{
continue;
}
}
}
return(RetrievalShortfallItemSubGridViewList);
}
//update Disbursement Status
public void UpdateDisbursementStatus(int disbId)
{
EFBroker_Disbursement.UpdateDisbursementStatus(disbId);
List <Requisition> requisitionList = EFBroker_Requisition.GetRequisitionListByDisbursementID(disbId);
requisitionList.ForEach(r => r.Status = "Closed");
EFBroker_Requisition.UpdateRequisitionList(requisitionList);
}