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);
}
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);
}
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"));
}
//[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));
}
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,
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));
}
