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