public IEnumerable <MaintenanceItemDetailViewModel> GetByModelC(string objectI, string modelC)
{
var items = from a in _maintenanceItemDetailRepository.GetAllQueryable()
join b in _maintenanceItemRepository.GetAllQueryable() on a.MaintenanceItemC equals b.MaintenanceItemC
where (a.ModelC == modelC && a.ObjectI == objectI)
orderby a.DisplayLineNo
select new MaintenanceItemDetailViewModel()
{
ObjectI = a.ObjectI,
ModelC = a.ModelC,
MaintenanceItemC = a.MaintenanceItemC,
MaintenanceItemN = b.MaintenanceItemN,
DisplayLineNo = a.DisplayLineNo
};
if (items.Any())
{
//var destination = Mapper.Map<IEnumerable<MaintenanceItem_D>, IEnumerable<MaintenanceItemDetailViewModel>>(items);
//return destination;
return(items);
}
return(null);
}
public IEnumerable <MaintenanceDetailViewModel> Get(string objectI, string code, string modelC)
{
var result = new List <MaintenanceDetailViewModel>();
var managementItems = from a in _maintenanceItemDetailRepository.GetAllQueryable()
join b in _maintenanceItemRepository.GetAllQueryable() on a.MaintenanceItemC
equals b.MaintenanceItemC
where a.ModelC == modelC && a.ObjectI == objectI
orderby a.DisplayLineNo
select new MaintenanceDetailViewModel()
{
ObjectI = a.ObjectI,
MaintenanceItemC = a.MaintenanceItemC,
MaintenanceItemN = b.MaintenanceItemN,
NoticeI = b.NoticeI,
ReplacementInterval = b.ReplacementInterval,
NoticeNo = b.NoticeNo
};
foreach (var item in managementItems)
{
var newItem = item;
var maintenanceItemHistory = (from a in _maintenanceDetailRepository.GetAllQueryable()
where (
a.ObjectI == objectI &&
a.Code == code &&
a.MaintenanceItemC == item.MaintenanceItemC)
orderby a.MaintenanceD descending
select new MaintenanceDetailViewModel()
{
TruckC = a.Code,
PlanMaintenanceD = a.MaintenanceD,
PlanMaintenanceKm = a.Odometer,
PartNo = a.PartNo,
Description = a.Description
}).FirstOrDefault();
// get next plan
var maintenancePlan = (from a in _maintenancePlanDetailRepository.GetAllQueryable()
where (
a.ObjectI == objectI &&
a.Code == code &&
a.MaintenanceItemC == item.MaintenanceItemC)
select new MaintenanceDetailViewModel()
{
NextMaintenanceD = a.PlanMaintenanceD,
NextMaintenanceKm = a.PlanMaintenanceKm
}).FirstOrDefault();
if (maintenanceItemHistory != null)
{
newItem.TruckC = maintenanceItemHistory.TruckC;
newItem.PlanMaintenanceD = maintenanceItemHistory.PlanMaintenanceD;
newItem.PlanMaintenanceKm = maintenanceItemHistory.PlanMaintenanceKm;
newItem.PartNo = maintenanceItemHistory.PartNo;
newItem.Description = maintenanceItemHistory.Description;
}
if (maintenancePlan != null)
{
newItem.NextMaintenanceD = maintenancePlan.NextMaintenanceD;
newItem.NextMaintenanceKm = maintenancePlan.NextMaintenanceKm;
}
result.Add(newItem);
}
return(result);
}
public IEnumerable <TruckMaintenanceViewModel> GetMaintenanceManagementItems(string truckC, string modelC)
{
List <TruckMaintenanceViewModel> result = new List <TruckMaintenanceViewModel>();
var managementItems = from a in _maintenanceItemDetailRepository.GetAllQueryable()
join b in _maintenanceItemRepository.GetAllQueryable() on a.MaintenanceItemC
equals b.MaintenanceItemC
where (a.ModelC == modelC && a.ObjectI == "0")
select new TruckMaintenanceViewModel()
{
ObjectI = a.ObjectI,
MaintenanceItemC = a.MaintenanceItemC,
MaintenanceItemN = b.MaintenanceItemN,
NoticeI = b.NoticeI,
ReplacementInterval = b.ReplacementInterval,
NoticeNo = b.NoticeNo
};
foreach (TruckMaintenanceViewModel item in managementItems)
{
TruckMaintenanceViewModel newItem = new TruckMaintenanceViewModel();
newItem = item;
var maintenanceItemHistory = (from a in _maintenanceDetailRepository.GetAllQueryable()
where (
a.ObjectI == "0" &&
a.Code == truckC &&
a.MaintenanceItemC == item.MaintenanceItemC)
orderby a.MaintenanceD descending
select new TruckMaintenanceViewModel()
{
TruckC = a.Code,
PlanMaintenanceD = a.PlanMaintenanceD,
PlanMaintenanceKm = a.PlanMaintenanceKm,
Description = a.Description
}).FirstOrDefault();
var maintenancePlan = (from a in _maintenancePlanDetailRepository.GetAllQueryable()
where (
a.ObjectI == "0" &&
a.Code == truckC &&
a.MaintenanceItemC == item.MaintenanceItemC)
select new TruckMaintenanceViewModel()
{
NextMaintenanceD = a.PlanMaintenanceD,
NextMaintenanceKm = a.PlanMaintenanceKm
}).FirstOrDefault();
if (maintenanceItemHistory != null)
{
newItem.TruckC = maintenanceItemHistory.TruckC;
newItem.PlanMaintenanceD = maintenanceItemHistory.PlanMaintenanceD;
newItem.PlanMaintenanceKm = maintenanceItemHistory.PlanMaintenanceKm;
newItem.Description = maintenanceItemHistory.Description;
}
if (maintenancePlan != null)
{
newItem.NextMaintenanceD = maintenancePlan.NextMaintenanceD;
newItem.NextMaintenanceKm = maintenancePlan.NextMaintenanceKm;
}
result.Add(newItem);
}
return(result);
}
