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