public FreeSIPC getSIPCLists(int reqId, int CommodityID) { var hubId = _hubAllocationService.GetAllocatedHubId(reqId); List <LedgerService.AvailableShippingCodes> freeSICodes = _ledgerService.GetFreeSICodesByCommodity(hubId, CommodityID); List <LedgerService.AvailableProjectCodes> freePCCodes = _ledgerService.GetFreePCCodesByCommodity(hubId, CommodityID); FreeSIPC free = new FreeSIPC { FreePCCodes = freePCCodes, FreeSICodes = freeSICodes }; return(free); }
public ActionResult Assign(int reqId, double remaining, double totalAssigned) { var previousModelState = TempData["ModelState"] as ModelStateDictionary; if (previousModelState != null) { foreach (KeyValuePair <string, ModelState> kvp in previousModelState) { if (!ModelState.ContainsKey(kvp.Key)) { ModelState.Add(kvp.Key, kvp.Value); } } } var hubId = _hubAllocationService.GetAllocatedHubId(reqId); ReliefRequisition listOfRequsitions = _requisitionService.Get(r => r.RequisitionID == reqId).SingleOrDefault(); List <LedgerService.AvailableShippingCodes> freeSICodes = _ledgerService.GetFreeSICodesByCommodity(hubId, (int)listOfRequsitions.CommodityID); List <LedgerService.AvailableProjectCodes> freePCCodes = _ledgerService.GetFreePCCodesByCommodity(hubId, (int)listOfRequsitions.CommodityID); ViewBag.FreeSICodes = freeSICodes; ViewBag.FreePCCodes = freePCCodes; ViewBag.SI = new SelectList(freeSICodes, "siCodeId", "SIcode"); ViewBag.PC = new SelectList(freePCCodes, "pcCodeId", "PCcode"); // ViewBag.SI = new SelectList(_shippingInstructionService.GetAllShippingInstruction(), "ShippingInstructionID", "Value"); ViewBag.Total = totalAssigned; //ViewBag.PC = new SelectList(_projectCodeService.GetAllProjectCode(), "ProjectCodeID", "Value"); ViewBag.RequetedAmount = Math.Round(listOfRequsitions.ReliefRequisitionDetails.Sum(a => a.Amount)); ViewBag.Hub = _hubAllocationService.GetAllocatedHub(reqId); ViewBag.ReqId = listOfRequsitions.RequisitionID; ViewBag.Remaining = Math.Round(remaining); return(View()); }
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)); }