public void updateRequisitionDelivery(DisbursementHelper disbursementHelper, string itemId)
{
try
{
ctx.updateRequisitionDeliveryPro(disbursementHelper.RequisitionId, itemId, disbursementHelper.DeliveredQty);
//requisitionDetail reqD = (from r in ctx.requisitionDetails
// where r.itemId == itemId && r.requisitionId == disbursementHelper.RequisitionId
// select r).FirstOrDefault();
//reqD.deliveredQty = disbursementHelper.DeliveredQty;
//ctx.SaveChanges();
}
catch (Exception exception)
{
errorobj.WriteErrorLog("RequisitionFacade-updateRequisitionDelivery():::" + exception.ToString());
}
}
public List<DisbursementHelper> getRequisitionsForDisbursement(string itemId)
{
List<DisbursementHelper> disbursementHelperCollection = new List<DisbursementHelper>();
try
{
var reqC = from rD in ctx.requisitionDetails
where
(new string[] { "Approved", "Outstanding","In Progress" }).Contains(rD.requisition.status) &&
rD.itemId == itemId &&
rD.requestedQty != rD.deliveredQty
group new { rD.requisition, rD } by new
{
rD.requisition.requisitionId,
Date = (DateTime?)rD.requisition.date,
rD.requisition.departmentId,
rD.requisition.status,
Column1 = (rD.requestedQty - rD.deliveredQty)
} into g
orderby
g.Key.Date ascending
select new
{
reqId = g.Key.requisitionId,
depId = g.Key.departmentId,
status = g.Key.status,
reqQ = g.Key.Column1
};
foreach(var r in reqC)
{
DisbursementHelper disbursementHelper = new DisbursementHelper();
disbursementHelper.RequisitionId = r.reqId;
disbursementHelper.DepartmentId = r.depId;
disbursementHelper.Status = r.status;
disbursementHelper.RequestedQty = Convert.ToInt32(r.reqQ);
disbursementHelperCollection.Add(disbursementHelper);
}
}
catch (Exception exception)
{
errorobj.WriteErrorLog("RequisitionFacade-getRequisitionsForDisbursement():::" + exception.ToString());
disbursementHelperCollection = new List<DisbursementHelper>();
}
return disbursementHelperCollection;
}