public FileResult Print(int bidID, int regionID) { var datePref = _userAccountService.GetUserInfo(HttpContext.User.Identity.Name).DatePreference; var reportPath = Server.MapPath("~/Report/Procurment/RFQ.rdlc"); var bid = _bidService.FindById(bidID); var planID = bid.TransportBidPlanID; TransportBidPlan bidPlan = _transportBidPlanService.FindById(planID); List <TransportBidPlanDetail> regionalPlan = _transportBidPlanDetailService.FindBy(t => t.BidPlanID == planID && t.Destination.AdminUnit2.AdminUnit2.AdminUnitID == regionID); var totalReliefAmount = regionalPlan.Where(m => m.ProgramID == 1).Sum(m => m.Quantity); var totalPsnpAmount = regionalPlan.Where(m => m.ProgramID == 2).Sum(m => m.Quantity); var rfqDetail = (from transportBidPlanDetail in regionalPlan select new RfqPrintViewModel { Source = transportBidPlanDetail.Source.Name, Zone = transportBidPlanDetail.Destination.AdminUnit2.Name, Woreda = transportBidPlanDetail.Destination.Name, WoredaID = transportBidPlanDetail.DestinationID, Region = transportBidPlanDetail.Destination.AdminUnit2.AdminUnit2.Name, BidReference = bid.BidNumber, ProgramID = transportBidPlanDetail.ProgramID, Quantity = transportBidPlanDetail.Quantity / 10, BidOpeningdate = bid.OpeningDate.ToCTSPreferedDateFormat(datePref), BidOpeningTime = bid.startTime } ).Where(m => m.Quantity > 0) .GroupBy(ac => new { ac.Woreda, ac.Source, ac.Region, ac.Zone }) .Select(ac => new RfqPrintViewModel { Source = ac.Key.Source, Zone = ac.Key.Zone, Woreda = ac.Key.Woreda, Region = ac.Key.Region, BidReference = bid.BidNumber, Quantity = ac.Sum(m => m.Quantity), ReliefAmount = totalReliefAmount / 10, PsnpAmount = totalPsnpAmount / 10, BidOpeningdate = bid.OpeningDate.ToCTSPreferedDateFormat(datePref), BidOpeningTime = bid.startTime }); var reportData = rfqDetail; var dataSourceName = "RFQDataset"; var result = ReportHelper.PrintReport(reportPath, reportData, dataSourceName); return(File(result.RenderBytes, result.MimeType)); }
public ActionResult WoredasWithoutOffer_Read([DataSourceRequest] DataSourceRequest request, int BIDID) { var bid = _bidService.FindById(BIDID); var bidPlanDetail = _bidPlanService.FindById(bid.TransportBidPlanID); var planned = (from planDetail in bidPlanDetail.TransportBidPlanDetails group planDetail by new { planDetail.DestinationID, planDetail.SourceID } into grouped select grouped ); var detailPlans = planned.Select(d => d.ToList()).Select(er => er.FirstOrDefault()).ToList(); var result = new List <BidWinnerViewModel>(); foreach (TransportBidPlanDetail pdetail in detailPlans) { var detail = _bidWinnerService.FindBy(t => t.BidID == BIDID && t.SourceID == pdetail.SourceID && t.DestinationID == pdetail.DestinationID).FirstOrDefault(); if (detail == null) { result.Add(new BidWinnerViewModel() { SourceWarehouse = pdetail.Source.Name, Zone = pdetail.Destination.AdminUnit2.Name, Region = pdetail.Destination.AdminUnit2.AdminUnit2.Name, Woreda = pdetail.Destination.Name, BidID = BIDID, DestinationId = pdetail.DestinationID, SourceId = pdetail.SourceID }); } } return(Json(result.ToDataSourceResult(request), JsonRequestBehavior.AllowGet)); }
public TransportBidPlan fetchFromDB(int id) { TransportBidPlan transportbidplan = _transportBidPlanService.FindById(id); return(transportbidplan); }