public static TransportRequisitionViewModel BindTransportRequisitionViewModel(TransportRequisition transportRequisition,List<WorkflowStatus> statuses,string datePrefrence,List<UserInfo> users ) { TransportRequisitionViewModel transportRequisitionViewModel = null; if (transportRequisition != null) { transportRequisitionViewModel = new TransportRequisitionViewModel(); transportRequisitionViewModel.CertifiedBy =users.First(t=>t.UserProfileID==transportRequisition.CertifiedBy).FullName; transportRequisitionViewModel.CertifiedDate = transportRequisition.CertifiedDate; transportRequisitionViewModel.DateCertified = transportRequisition.CertifiedDate.ToCTSPreferedDateFormat(datePrefrence); //EthiopianDate.GregorianToEthiopian(transportRequisition.CertifiedDate); transportRequisitionViewModel.Remark = transportRequisition.Remark; transportRequisitionViewModel.RequestedBy = users.First(t => t.UserProfileID == transportRequisition.RequestedBy).FullName; transportRequisitionViewModel.RequestedDate = transportRequisition.RequestedDate; transportRequisitionViewModel.DateRequested = transportRequisition.RequestedDate.ToCTSPreferedDateFormat(datePrefrence); //EthiopianDate.GregorianToEthiopian( transportRequisition.RequestedDate); transportRequisitionViewModel.Status = statuses.First(t=>t.StatusID==transportRequisition.Status).Description; transportRequisitionViewModel.StatusID = transportRequisition.Status; transportRequisitionViewModel.TransportRequisitionID = transportRequisition.TransportRequisitionID; transportRequisitionViewModel.TransportRequisitionNo = transportRequisition.TransportRequisitionNo; transportRequisitionViewModel.Program = transportRequisition.Program.Name; transportRequisitionViewModel.Month = RequestHelper.MonthName( transportRequisition.TransportRequisitionDetails.FirstOrDefault().ReliefRequisition.Month); transportRequisitionViewModel.Round =transportRequisition.TransportRequisitionDetails.FirstOrDefault().ReliefRequisition.Round; transportRequisitionViewModel.Date = DateTime.Now.ToCTSPreferedDateFormat(datePrefrence); } return transportRequisitionViewModel; }
private TransportRequisitionViewModel BindTransportRequisitionViewModel(TransportRequisition transportRequisition) { string userPreference = _userAccountService.GetUserInfo(HttpContext.User.Identity.Name).DatePreference; TransportRequisitionViewModel transportRequisitionViewModel = null; if (transportRequisition != null) { var transportRequisitionObj = _transportRequisitionService.FindById(transportRequisition.TransportRequisitionID); transportRequisitionViewModel = new TransportRequisitionViewModel(); transportRequisitionViewModel.CertifiedBy = _userAccountService.FindById(transportRequisitionObj.CertifiedBy).FullName; transportRequisitionViewModel.CertifiedDate = transportRequisitionObj.CertifiedDate; transportRequisitionViewModel.DateCertified = transportRequisitionObj.CertifiedDate.ToCTSPreferedDateFormat(userPreference); //EthiopianDate.GregorianToEthiopian(transportRequisition.CertifiedDate); transportRequisitionViewModel.Remark = transportRequisitionObj.Remark; transportRequisitionViewModel.RequestedBy = _userAccountService.FindById(transportRequisitionObj.RequestedBy).FullName; transportRequisitionViewModel.RequestedDate = transportRequisitionObj.RequestedDate; transportRequisitionViewModel.DateRequested = transportRequisitionObj.RequestedDate.ToCTSPreferedDateFormat(userPreference); //EthiopianDate.GregorianToEthiopian( transportRequisition.RequestedDate); transportRequisitionViewModel.Status = _workflowStatusService.GetStatusName(WORKFLOW.TRANSPORT_REQUISITION, transportRequisitionObj.Status); transportRequisitionViewModel.StatusID = transportRequisitionObj.Status; transportRequisitionViewModel.TransportRequisitionID = transportRequisitionObj.TransportRequisitionID; transportRequisitionViewModel.TransportRequisitionNo = transportRequisitionObj.TransportRequisitionNo; transportRequisitionViewModel.Region = _adminUnitService.FindById(transportRequisitionObj.RegionID).Name; transportRequisitionViewModel.Program = _programService.FindById(transportRequisitionObj.ProgramID).Name; } return transportRequisitionViewModel; }
private TransportRequisition BindTransportRequisition(TransportRequisitionViewModel transportRequisitionViewModel) { string userPreference = _userAccountService.GetUserInfo(HttpContext.User.Identity.Name).DatePreference; TransportRequisition transportRequisition = null; if (transportRequisitionViewModel != null) { transportRequisition = new TransportRequisition(); var firstOrDefault = _userAccountService.FindBy(t => t.UserName == transportRequisitionViewModel.CertifiedBy).FirstOrDefault(); if (firstOrDefault != null) transportRequisition.CertifiedBy = firstOrDefault.UserProfileID; transportRequisition.CertifiedDate = transportRequisitionViewModel.CertifiedDate; transportRequisition.CertifiedDate = transportRequisitionViewModel.CertifiedDate; //EthiopianDate.GregorianToEthiopian(transportRequisition.CertifiedDate); transportRequisition.Remark = transportRequisition.Remark; var firstOrDefault1 = _userAccountService.FindBy(t => t.UserName == transportRequisitionViewModel.RequestedBy).FirstOrDefault(); if (firstOrDefault1 != null) transportRequisition.RequestedBy = firstOrDefault1.UserProfileID; transportRequisition.RequestedDate = transportRequisitionViewModel.RequestedDate; transportRequisition.RequestedDate = transportRequisitionViewModel.RequestedDate; //EthiopianDate.GregorianToEthiopian( transportRequisition.RequestedDate); transportRequisition.Status = transportRequisitionViewModel.StatusID; transportRequisition.TransportRequisitionID = transportRequisitionViewModel.TransportRequisitionID; transportRequisition.TransportRequisitionNo = transportRequisitionViewModel.TransportRequisitionNo; transportRequisition.RegionID = transportRequisitionViewModel.RegionID; transportRequisition.AdminUnit = _adminUnitService.FindById(transportRequisitionViewModel.RegionID); transportRequisition.ProgramID = transportRequisitionViewModel.ProgramID; transportRequisition.Program = _programService.FindById(transportRequisitionViewModel.ProgramID); } return transportRequisition; }
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, Donor = "WFP", transportRequisitionDetail.RequisitionID, fromSIPC = (from projectCodeAllocation in _projectCodeAllocationService.FindBy(p => p.HubAllocationID == 3/*_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] = header; reportData[1] = requisitionsSummary; reportData[2] = detailsT; var result = ReportHelper.PrintReport(reportPath, reportData, dataSources); return File(result.RenderBytes, result.MimeType); }
public ActionResult Edit(TransportRequisitionViewModel transportRequisitionViewModel) { if (!ModelState.IsValid) { return View(transportRequisitionViewModel); } //var transportRequisition = BindTransportRequisition(transportRequisitionViewModel); var transportRequisition = _transportRequisitionService.FindById(transportRequisitionViewModel.TransportRequisitionID); transportRequisition.CertifiedBy = int.Parse(transportRequisitionViewModel.CertifiedBy); transportRequisition.CertifiedDate = transportRequisitionViewModel.CertifiedDate; transportRequisition.RequestedBy = int.Parse(transportRequisitionViewModel.RequestedBy); transportRequisition.RequestedDate = transportRequisitionViewModel.RequestedDate; transportRequisition.TransportRequisitionNo = transportRequisitionViewModel.TransportRequisitionNo; transportRequisition.Remark = transportRequisitionViewModel.Remark; _transportRequisitionService.EditTransportRequisition(transportRequisition); return RedirectToAction("Index","TransportRequisition"); }
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); }