public List<RequisitionDetails> selectRequisition(string requisitionId)
{
List<requisitionDetail> list = requisitionFacade.getRequisitionDetails_Lingna(requisitionId);
List<RequisitionDetails> l = new List<RequisitionDetails>();
foreach (requisitionDetail r in list)
{
RequisitionDetails R = new RequisitionDetails();
R.ItemId = r.itemId;
R.ItemName = r.item.description;
R.RequestedQty = (int)r.requestedQty;
R.DeliveredQty = (int)r.deliveredQty;
l.Add(R);
}
return l;
}
public List<RequisitionDetails> selectRequisitionDetail(string requisitionId)
{
//RequisitionDetails requisitionDetail = new RequisitionDetails();
//
//fill ctx here
//
List<requisitionDetail> list = requisitionFacade.getRequisitionDetails_PyaePyae(requisitionId);
List<RequisitionDetails> newlist = new List<RequisitionDetails>();
foreach (requisitionDetail r in list)
{
RequisitionDetails R = new RequisitionDetails();
//R.ItemId = r.itemId;
R.ItemName = r.item.description;
R.RequestedQty = Convert.ToInt32(r.requestedQty);
newlist.Add(R);
}
return newlist;
}
public List<RequisitionDetails> getRequisitionsForRetrieval()
{
List<RequisitionDetails> requisitionDetailsCollection = new List<RequisitionDetails>();
try
{
/*IEnumerable<requisitionDetail> reqDCollection = from req in ctx.requisitions
join reqD in ctx.requisitionDetails on req.requisitionId equals reqD.requisitionId
where req.status == "Approved" || req.status == "Outstanding" && reqD.status == "Pending" && reqD.requestedQty != reqD.deliveredQty
select reqD;
var reqVar = (from rqD in reqDCollection
select rqD.requisitionId.ToString()).Distinct();
foreach (string r in reqVar)
{
Requisition requisition = new Requisition();
requisition.RequisitionId = r;
List<RequisitionDetails> requisitionDetailsCollection = new List<RequisitionDetails>();
foreach (requisitionDetail rD in reqDCollection)
{
if (rD.requisitionId == r)
{
RequisitionDetails requisitionDetails = new RequisitionDetails();
requisitionDetails.ItemId = rD.itemId;
requisitionDetails.RequestedQty = Convert.ToInt32(rD.requestedQty);
requisitionDetails.DeliveredQty = Convert.ToInt32(rD.deliveredQty);
requisitionDetailsCollection.Add(requisitionDetails);
}
}
requisition.RequisitionDetailsCollection = requisitionDetailsCollection;
requisitionCollection.Add(requisition);
}*/
var reqDCollection = from rd in ctx.requisitionDetails
where
(new string[] { "Approved", "Outstanding","In Progress" }).Contains(rd.requisition.status) &&
rd.requestedQty != rd.deliveredQty
group rd by new
{
rd.itemId
} into g
select new
{
itemId = g.Key.itemId,
requestedQty = (int?)g.Sum(p => p.requestedQty),
deliveredQty = (int?)g.Sum(p => p.deliveredQty)
};
foreach (var rD in reqDCollection)
{
RequisitionDetails requisitionDetails = new RequisitionDetails();
requisitionDetails.ItemId = rD.itemId;
requisitionDetails.RequestedQty = Convert.ToInt32(rD.requestedQty);
requisitionDetails.DeliveredQty = Convert.ToInt32(rD.deliveredQty);
requisitionDetailsCollection.Add(requisitionDetails);
}
}
catch (Exception exception)
{
errorobj.WriteErrorLog("RequisitionFacade-getRequisitionsForRetrieval():::" + exception.ToString());
}
return requisitionDetailsCollection;
}
