private List <TransportRequisitionDetailViewModel> GetDetail(IEnumerable <TransportRequisitionDetail> transportRequisitionDetails) { var requIds = (from itm in transportRequisitionDetails select itm.RequisitionID).ToList(); var temp = _transportRequisitionService.GetTransportRequisitionDetail(requIds); var result = TransportRequisitionViewModelBinder.BindListTransportRequisitionDetailViewModel(temp); return(result.ToList()); }
//[LogisticsAuthorize(operation = LogisticsCheckAccess.Operation.Edit__transport_order)] public ActionResult Details(int id) { ViewBag.RequisistionId = id; var transportRequisitonViewModel = new TransportRequisitionViewModel(); try { var datePref = _userAccountService.GetUserInfo(HttpContext.User.Identity.Name).DatePreference; var statuses = _workflowStatusService.GetStatus(WORKFLOW.TRANSPORT_REQUISITION); var users = _userAccountService.GetUsers(); var transportRequisition = _transportRequisitionService.FindById(id); transportRequisitonViewModel = TransportRequisitionViewModelBinder.BindTransportRequisitionViewModel(transportRequisition, statuses, datePref, users); transportRequisitonViewModel.TransportRequisitionDetailViewModels = GetDetail(transportRequisition.TransportRequisitionDetails.ToList()); foreach (var transportRequisitionDetailViewModel in transportRequisitonViewModel.TransportRequisitionDetailViewModels) { var count = _reliefRequisitionDetailService.FindBy( t => t.RequisitionID == transportRequisitionDetailViewModel.RequisitionID).Count; transportRequisitionDetailViewModel.DestinationsCount = count; } } catch (Exception ex) { var log = new Logger(); log.LogAllErrorsMesseges(ex, _log); transportRequisitonViewModel.TransportRequisitionDetailViewModels = new List <TransportRequisitionDetailViewModel>(); ViewBag.Error = "An error has occured: Check Detail."; ModelState.AddModelError("Errors", ViewBag.Error); } // Session["transport_requisiton_return_id"]=id; return(View(transportRequisitonViewModel)); }
public ActionResult PrintSummary(int id) { var reportPath = Server.MapPath("~/Report/Logisitcs/TransportRequisitionSummary.rdlc"); var transportR = _transportRequisitionService.FindBy(t => t.TransportRequisitionID == id); var transportRequisitonViewModel = new TransportRequisitionViewModel(); var headerInfo = new List <TransportRequisitionViewModel>(); headerInfo.Add(transportRequisitonViewModel); var datePref = _userAccountService.GetUserInfo(HttpContext.User.Identity.Name).DatePreference; var statuses = _workflowStatusService.GetStatus(WORKFLOW.TRANSPORT_REQUISITION); var users = _userAccountService.GetUsers(); var transportRequisition = _transportRequisitionService.FindById(id); transportRequisitonViewModel = TransportRequisitionViewModelBinder. BindTransportRequisitionViewModel( transportRequisition, statuses, datePref, users ); //transportRequisitonViewModel.TransportRequisitionDetailViewModels = GetDetail(transportRequisition.TransportRequisitionDetails.ToList()); //var transportRequisition = _transportRequisitionService.FindById(id); var details = GetDetail(transportRequisition.TransportRequisitionDetails.ToList()); var header = (from requisition in headerInfo select new { //TransportRequisitionID=requisition.TransportRequisitionNo, //requisition.Remark, //DateRequested=requisition.RequestedDate, //DateRecieved = requisition.CertifiedDate, //requisition.RequestedBy, //requisition.CertifiedBy requisition.TransportRequisitionNo, requisition.Remark, DateRequested = requisition.RequestedDate, DateRecieved = requisition.CertifiedDate, RequestedBy = requisition.RequestedBy, CertifiedBy = requisition.CertifiedBy }); var requisitionsSummary = (from transportRequisitionDetail in details select new { Commodity = transportRequisitionDetail.CommodityName, RequisitionNumber = transportRequisitionDetail.RequisitionNo, Amount = transportRequisitionDetail.QuanityInQtl, Warehouse = transportRequisitionDetail.OrignWarehouse, Region = transportRequisitionDetail.Region, Zone = transportRequisitionDetail.Zone, Program = transportRequisitionDetail.Program, Donor = "WFP", transportRequisitionDetail.RequisitionID, fromSIPC = (from projectCodeAllocation in _projectCodeAllocationService.FindBy(p => p.HubAllocationID == _hubAllocationService.GetAllocatedHubId(transportRequisitionDetail.RequisitionID)) select new { CommodityName = transportRequisitionDetail.CommodityName, fromSIPC = projectCodeAllocation.Amount_FromSI, //fromSIPCKEy = projectCodeAllocation.ProjectCodeAllocationID } ) } ); var detailsT = ( from requisition in requisitionsSummary select requisition.fromSIPC ); //foreach (var detail in details) //{ // var hubAllocationID = _hubAllocationService.GetAllocatedHubId(detail.RequisitionID); // var projectCodeAllocations = _projectCodeAllocationService.FindBy(p=>p.HubAllocationID==hubAllocationID); // var ds = from projectCodeAllocation in projectCodeAllocations // select new // { // CommodityName = detail.CommodityName, // fromSIPC = projectCodeAllocation.Amount_FromSI, // fromSIPCKEy = projectCodeAllocation.ProjectCodeAllocationID // } //} /* * var detail = * (from projectCodeAllocation in _projectCodeAllocationService.FindBy( * p => * p.HubAllocationID == * _hubAllocationService.GetAllocatedHubId(transportRequisitionDetail.RequisitionID)) * select new * { * CommodityName = transportRequisitionDetail.CommodityName, * fromSIPC = projectCodeAllocation.Amount_FromSI, * fromSIPCKEy = projectCodeAllocation.ProjectCodeAllocationID * } * ); * * //var data = (from requisition in transportRequisition * // select new * // { * // requisition.TransportRequisitionID, * // requisition.Remark, * // requisition.RequestedDate, * // requisition.CertifiedDate, * // requisition.RequestedBy, * // requisition.CertifiedBy, * // requisitionsSummary = (from transportRequisitionDetail in GetDetail(requisition.TransportRequisitionDetails.ToList()) * // select new * // { * // Commodity = transportRequisitionDetail.CommodityName, * // RequisitionNumber = transportRequisitionDetail.RequisitionNo, * // Amount = transportRequisitionDetail.QuanityInQtl, * // Warehouse = transportRequisitionDetail.OrignWarehouse, * // Region = transportRequisitionDetail.Region, * // Zone = transportRequisitionDetail.Zone, * // Donor = "WFP", * // RecievedDate = DateTime.Now, * // DateofRequisition = DateTime.Now, * // fromSIPC = (from projectCodeAllocation in _projectCodeAllocationService.FindBy(p => p.HubAllocationID == _hubAllocationService.GetAllocatedHubId(transportRequisitionDetail.RequisitionID)) * // select new * // { * // CommodityName = transportRequisitionDetail.CommodityName, * // fromSIPC = projectCodeAllocation.Amount_FromSI, * // fromSIPCKEy = projectCodeAllocation.ProjectCodeAllocationID * // } * // ) * // } * // ) * * // } * // ); * * * * var reportData = (from detail in details * select new * { * Commodity = detail.CommodityName, * RequisitionNumber = detail.RequisitionNo, * Amount = detail.QuanityInQtl, * Warehouse = detail.OrignWarehouse, * Region = detail.Region, * Zone= detail.Zone, * Donor = "WFP", * RecievedDate= DateTime.Now, * DateofRequisition = DateTime.Now, * Remark = transportRequisition.Remark, * RequestedBy = transportRequisition.RequestedBy, * CertifiedBy = transportRequisition.CertifiedBy, * //fromSIPCAllocations = detail. * });*/ //var dataSourceName = "RequisitionsSummary"; //var dataSourceName2 = "Header"; //var dataSourceName3 = "details"; var dataSources = new string[3]; // dataSources[0] = ""; dataSources[0] = "Header"; dataSources[1] = "RequisitionsSummary"; dataSources[2] = "details"; var reportData = new IEnumerable[3]; reportData[0] = new Collection <TransportRequisitionViewModel> { transportRequisitonViewModel }; reportData[1] = requisitionsSummary; reportData[2] = detailsT; var result = ReportHelper.PrintReport(reportPath, reportData, dataSources); return(File(result.RenderBytes, result.MimeType)); }