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; }