public string insertMaintenanceType(MaintenanceTypeDto maintenanceType) { GFI_AMM_VehicleMaintTypes maintType = new GFI_AMM_VehicleMaintTypes(); if (maintenanceType.MaintenanceTypeId != 0) { maintType = dbCon.GFI_AMM_VehicleMaintTypes.SingleOrDefault(c => c.MaintTypeId == maintenanceType.MaintenanceTypeId); } maintType.MaintCatId_cbo = maintenanceType.CategoryId; maintType.Description = maintenanceType.Description; maintType.OccurrenceEngineHrsTh = maintenanceType.EngineHrsBasedAlertThreshold; maintType.OccurrenceEngineHrs = maintenanceType.EngineHrsBasedMaintenanceDue; maintType.OccurrenceDuration = maintenanceType.OccurrenceDuration; maintType.OccurrenceDurationTh = maintenanceType.TimeBasedAlertThreshold; maintType.OccurrenceFixedDate = maintenanceType.OccurenceFixedDate; maintType.OccurrenceFixedDateTh = maintenanceType.OccurenceFixedDateThreshold; maintType.OccurrenceKM = maintenanceType.KMBasedMaintenanceDue; maintType.OccurrenceKMTh = maintenanceType.KMBasedAlertThreshold; maintType.OccurrencePeriod_cbo = maintenanceType.TimeBasedPeriod; maintType.OccurrenceType = maintenanceType.IsFixedDateChecked == true?0:1; maintType.One_Off = maintenanceType.One_Off; maintType.UpdatedDate = System.DateTime.Now; if (maintenanceType.MaintenanceTypeId == 0) { dbCon.GFI_AMM_VehicleMaintTypes.Add(maintType); } dbCon.SaveChanges(); return(""); }
public ActionResult CreateMaintenanceType(MaintenanceTypeDto maintType) { var maintTypeRepo = new MaintenanceTypeRepo(); var statusLst = maintTypeRepo.insertMaintenanceType(maintType); return(Json("Record saved successfully.")); }
public MaintenanceTypeDto getMaintenanceTypeByID(int maintenanceType) { var maintenanceResult = dbCon.GFI_AMM_VehicleMaintTypes.Where(x => x.MaintTypeId == maintenanceType).Select(x => new MaintenanceTypeDto { MaintenanceTypeId = x.MaintTypeId, CategoryId = x.MaintCatId_cbo ?? 0, Description = x.Description, EngineHrsBasedMaintenanceDue = x.OccurrenceEngineHrs ?? 0, EngineHrsBasedAlertThreshold = x.OccurrenceEngineHrsTh ?? 0, KMBasedMaintenanceDue = x.OccurrenceKM ?? 0, KMBasedAlertThreshold = x.OccurrenceKMTh ?? 0, TimeBasedMaintenanceDue = x.OccurrenceDuration ?? 0, TimeBasedAlertThreshold = x.OccurrenceDurationTh ?? 0, OccurenceFixedDateThreshold = (int)x.OccurrenceFixedDateTh, OccurenceFixedDate = x.OccurrenceFixedDate, IsFixedDateChecked = x.OccurrenceType == 0 ? true : false, IsRecurringChecked = x.OccurrenceType == 1 ? true : false, One_Off = x.One_Off, TimeBasedPeriod = x.OccurrencePeriod_cbo, }).FirstOrDefault(); if (maintenanceResult == null) { maintenanceResult = new MaintenanceTypeDto(); } maintenanceResult.CategoryList = categoryRepo.getAllCategories(); return(maintenanceResult); }
public MaintenanceTypeDto GetMaintenanceTypeDetailsById(int maintenanceTypeId) { var maintenanceTypeDetail = new MaintenanceTypeDto(); maintenanceTypeDetail = dbCon.GFI_AMM_VehicleMaintTypes. Where(x => x.MaintTypeId == maintenanceTypeId).Select(x => new MaintenanceTypeDto { KMBasedAlertThreshold = x.OccurrenceKMTh ?? 0, KMBasedMaintenanceDue = x.OccurrenceKM ?? 0, EngineHrsBasedMaintenanceDue = x.OccurrenceEngineHrs ?? 0, EngineHrsBasedAlertThreshold = x.OccurrenceEngineHrsTh ?? 0, OccurrenceDuration = x.OccurrenceDuration ?? 0, OccurenceFixedDateThreshold = x.OccurrenceDurationTh ?? 0, MaintenanceTypeId = x.MaintTypeId }) .FirstOrDefault(); return(maintenanceTypeDetail); }