public ActionResult DCLosses()
{
AutoMapper.Mapper.CreateMap <Package, PackageViewModel>();
AutoMapper.Mapper.CreateMap <Medicine, MedicineViewModel>();
AutoMapper.Mapper.CreateMap <PackageStatus, PackageStatusViewModel>();
AutoMapper.Mapper.CreateMap <PackageTransactions, PackageTransactionsViewModel>();
AutoMapper.Mapper.CreateMap <DistributionCenter, DistributionCenterViewModel>();
var lstDcReport = new List <DCLossReportViewModel>();
var lstDCLostPerDCReport = new List <DCLossReportViewModel>();
var lstLostDiscardedPerDCReport = new List <DCLossReportViewModel>();
DCLossReportViewModel objDC = new DCLossReportViewModel();
DCLossReportViewModel objDCLostPerDC = new DCLossReportViewModel();
DCLossReportViewModel objDCLostDiscardedPerDC = new DCLossReportViewModel();
var packagesLostPerDC = PackagesContracts.GetAll().Where(x => x.PackageStatus.PackageStatusId == 2 || x.PackageStatus.PackageStatusId == 3)
.GroupBy(x => new { x.CurrentLocation.Name })
.Select(y => new { DistID = y.Key.Name, TotalPackages = y.Count(), TotalCost = y.Sum(w => w.Medicine.Value) });
var packagesLostDistrDC = PackagesContracts.GetAll().Where(x => x.PackageStatus.PackageStatusId == 2 || x.PackageStatus.PackageStatusId == 3 || x.PackageStatus.PackageStatusId == 4)
.GroupBy(x => new { x.CurrentLocation.Name })
.Select(y => new { DistID = y.Key.Name, TotalPackages = y.Count(), TotalCost = y.Sum(w => w.Medicine.Value) });
foreach (var o in packagesLostPerDC)
{
objDCLostPerDC.DistributionCenter = o.DistID.ToString();
objDCLostPerDC.TotalLostORDiscardedPackages = o.TotalPackages;
objDCLostPerDC.TotalLostORDiscardedValue = o.TotalCost;
lstDCLostPerDCReport.Add(objDCLostPerDC);
}
foreach (var o in packagesLostDistrDC)
{
objDCLostDiscardedPerDC.DistributionCenter = o.DistID.ToString();
objDCLostDiscardedPerDC.TotalLostORDiscardedORDistributedPackages = o.TotalPackages;
objDCLostDiscardedPerDC.TotalLostORDiscardedORDIstributedValue = o.TotalCost;
lstLostDiscardedPerDCReport.Add(objDCLostDiscardedPerDC);
}
objDCLostDiscardedPerDC = null; objDCLostPerDC = null;
int i = 0;
for (i = 0; i < lstDCLostPerDCReport.Count; i++)
{
objDC.DistributionCenter = (lstDCLostPerDCReport[i]).DistributionCenter;
objDC.TotalLostORDiscardedPackages = (lstDCLostPerDCReport[i]).TotalLostORDiscardedPackages;
objDC.TotalLostORDiscardedValue = (lstDCLostPerDCReport[i]).TotalLostORDiscardedValue;
objDC.TotalLostORDiscardedORDistributedPackages = (lstLostDiscardedPerDCReport[i]).TotalLostORDiscardedORDistributedPackages;
objDC.TotalLostORDiscardedORDIstributedValue = (lstLostDiscardedPerDCReport[i]).TotalLostORDiscardedORDIstributedValue;
objDC.LossRatio = lstDCLostPerDCReport[i].TotalLostORDiscardedValue / lstLostDiscardedPerDCReport[i].TotalLostORDiscardedORDIstributedValue;
lstDcReport.Add(objDC);
}
return(PartialView("_DistributionCenterLosses", lstDcReport));
}
public PackagesController()
{
packagesContracts = new PackagesContracts();
medicineContracts = new MedicinesContracts();
userContracts = new UserContracts();
dcContracts = new DistributionCentersContracts();
packageTransactionsContracts = new PackageTransactionsContracts();
distributionsContracts = new DistributionsContracts();
}
public ActionResult GlobalStock()
{
AutoMapper.Mapper.CreateMap <Package, PackageViewModel>();
AutoMapper.Mapper.CreateMap <Medicine, MedicineViewModel>();
AutoMapper.Mapper.CreateMap <PackageStatus, PackageStatusViewModel>();
AutoMapper.Mapper.CreateMap <PackageTransactions, PackageTransactionsViewModel>();
var packagesModels = PackagesContracts.GetAll().Where(x => x.PackageStatus.PackageStatusId == 1);
var packages = AutoMapper.Mapper.Map <IEnumerable <PackageViewModel> >(packagesModels);
foreach (var VARIABLE in packages)
{
VARIABLE.TransitState =
PackagesContracts.GetAllStatus().First(x => x.PackageStatusId == VARIABLE.PackageStatusId).TransitState;
}
return(PartialView("_GlobalStock", packages));
}
public ReportsController()
{
PackagesContracts = new PackagesContracts();
UserContracts = new UserContracts();
}
