//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);
}
//FIND REQUISITION ITEM BY REQUISITION ID AND ITEM CODE
public static Requisition_Item findByReqIDItemCode(int id, string code)
{
return(EFBroker_Requisition.FindReqItemsByReqIDItemID(id, code));
}