public List <RecentRequisitions> GetRecentRequisitions(int regionID)
{
/*var requisitions = new RecentRequisition();
* var limResult =
* requisitions.Query(
* "SELECT TOP 5 * FROM Dashborad_Regional_Requisitions WHERE RegionID=@0 ORDER BY RequestedDate DESC",
* args: regionID);
* return limResult.ToList();*/
var r = new List <RecentRequisitions>();
var currentHRD = _unitOfWork.HRDRepository.FindBy(m => m.Status == 3);
var requisitions = _unitOfWork.ReliefRequisitionRepository.FindBy(t => t.RegionID == regionID).OrderByDescending(t => t.RequisitionID).Take(5);
foreach (var regionalRequisition in requisitions)
{
var n = new Models.ViewModels.Dashboard.RecentRequisitions
{
RequisitionID = regionalRequisition.RequisitionID,
RequisitionNo = regionalRequisition.RequisitionNo,
Status = regionalRequisition.Status,
RequestedDate = regionalRequisition.RequestedDate,
BenficiaryNo = regionalRequisition.ReliefRequisitionDetails.Sum(t => t.BenficiaryNo),
Name = regionalRequisition.Commodity.Name,
Amount = regionalRequisition.ReliefRequisitionDetails.Sum(s => s.Amount)
};
r.Add(n);
}
return(r);
}
public List<RecentRequisitions> GetRecentRequisitions(int regionID)
{
/*var requisitions = new RecentRequisition();
var limResult =
requisitions.Query(
"SELECT TOP 5 * FROM Dashborad_Regional_Requisitions WHERE RegionID=@0 ORDER BY RequestedDate DESC",
args: regionID);
return limResult.ToList();*/
var r = new List<RecentRequisitions>();
var currentHRD = _unitOfWork.HRDRepository.FindBy(m => m.Status == 3);
var requisitions = _unitOfWork.ReliefRequisitionRepository.FindBy(t => t.RegionID == regionID).OrderByDescending(t => t.RequisitionID).Take(5);
foreach (var regionalRequisition in requisitions)
{
var n = new Models.ViewModels.Dashboard.RecentRequisitions
{
RequisitionID = regionalRequisition.RequisitionID,
RequisitionNo = regionalRequisition.RequisitionNo,
Status = regionalRequisition.Status,
RequestedDate = regionalRequisition.RequestedDate,
BenficiaryNo = regionalRequisition.ReliefRequisitionDetails.Sum(t => t.BenficiaryNo),
Name = regionalRequisition.Commodity.Name,
Amount = regionalRequisition.ReliefRequisitionDetails.Sum(s=>s.Amount)
};
r.Add(n);
}
return r;
}
