public void AutoAllocateDisbursementsByOrderOfRequisition(DateTime?deliveryDate)
{
System.Web.HttpContext.Current.Application.Lock();
RetrievalList retrievalList = (RetrievalList)System.Web.HttpContext.Current.Application["RetrievalList"];
foreach (var itemsCollected in retrievalList.itemsToRetrieve)
{
UpdateInventoryQuantity(itemsCollected.itemNo, itemsCollected.collectedQuantity);
}
try
{
fcm.CheckForStockReorder();
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e.ToString());
}
List <Requisition> requisitionListFromRList = retrievalList.requisitionList;
DisbursementList dList = new DisbursementList();
List <DisbursementDetail> tempDisbursementDetailList = new List <DisbursementDetail>();
int?currentDisbursementListId = null;
foreach (Requisition requisition in requisitionListFromRList)
{
var q = (from x in db.DisbursementLists
where x.RetrievalId == retrievalList.retrievalId &&
x.DepartmentId == requisition.DepartmentId
select x).FirstOrDefault();
if (q == null) // if its first time entering loop, create new disbursementlist for dept
{
currentDisbursementListId = CreateNewDisbursementListForDepartment(dList, requisition, retrievalList, currentDisbursementListId, deliveryDate);
foreach (RequisitionDetail reqDetails in requisition.RequisitionDetails)
{
AddDisbursementDetailToTempList(currentDisbursementListId, reqDetails, retrievalList, tempDisbursementDetailList);
}
}
else if (q.DepartmentId == requisition.DepartmentId)
{
foreach (RequisitionDetail reqDetails in requisition.RequisitionDetails)
{
currentDisbursementListId = q.DisbursementListId;
AddDisbursementDetailToTempList(currentDisbursementListId, reqDetails, retrievalList, tempDisbursementDetailList);
}
}
}
SaveDisbursementDetailsIntoDB(tempDisbursementDetailList);
foreach (Requisition r in requisitionListFromRList)
{
Requisition temp = db.Requisitions.Find(r.RequisitionId);
temp.RetrievalId = retrievalList.retrievalId;
temp.RequisitionStatus = "Processing";
db.Entry(temp).State = EntityState.Modified;
db.SaveChanges();
}
ClearRetrievalList();
HttpContext.Current.Application.UnLock();
}
