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