public JobExtension DeleteJobExtension(int jobExtensionID) { JobExtension dbEntry = context.JobsExtensions .FirstOrDefault(p => p.JobExtensionID == jobExtensionID); if (dbEntry != null) { context.JobsExtensions.Remove(dbEntry); context.SaveChanges(); } return(dbEntry); }
public Job DeleteEngJob(int JobID) { Job dbEntry = context.Jobs .FirstOrDefault(p => p.JobID == JobID); JobExtension jobExtension = context.JobsExtensions .FirstOrDefault(p => p.JobID == JobID); HydroSpecific hydroSpecific = context.HydroSpecifics .FirstOrDefault(p => p.JobID == JobID); GenericFeatures genericFeatures = context.GenericFeaturesList .FirstOrDefault(p => p.JobID == JobID); Indicator indicator = context.Indicators .FirstOrDefault(p => p.JobID == JobID); HoistWayData hoistWayData = context.HoistWayDatas .FirstOrDefault(p => p.JobID == JobID); if (dbEntry != null) { context.Jobs.Remove(dbEntry); context.SaveChanges(); } if (jobExtension != null) { context.JobsExtensions.Remove(jobExtension); context.SaveChanges(); } if (hydroSpecific != null) { context.HydroSpecifics.Remove(hydroSpecific); context.SaveChanges(); } if (genericFeatures != null) { context.GenericFeaturesList.Remove(genericFeatures); context.SaveChanges(); } if (indicator != null) { context.Indicators.Remove(indicator); context.SaveChanges(); } if (hoistWayData != null) { context.HoistWayDatas.Remove(hoistWayData); context.SaveChanges(); } return(dbEntry); }
public void SaveJobExtension(JobExtension jobExtension) { if (jobExtension.JobExtensionID == 0) { context.JobsExtensions.Add(jobExtension); } else { JobExtension dbEntry = context.JobsExtensions .FirstOrDefault(p => p.JobExtensionID == jobExtension.JobExtensionID); if (dbEntry != null) { dbEntry.JobID = jobExtension.JobID; dbEntry.NumOfStops = jobExtension.NumOfStops; dbEntry.JobTypeMain = jobExtension.JobTypeMain; dbEntry.JobTypeAdd = jobExtension.JobTypeAdd; dbEntry.InputVoltage = jobExtension.InputVoltage; dbEntry.InputPhase = jobExtension.InputPhase; dbEntry.InputFrecuency = jobExtension.InputFrecuency; dbEntry.DoorGate = jobExtension.DoorGate; dbEntry.DoorHoist = jobExtension.DoorHoist; dbEntry.InfDetector = jobExtension.InfDetector; dbEntry.MechSafEdge = jobExtension.MechSafEdge; dbEntry.HeavyDoors = jobExtension.HeavyDoors; dbEntry.CartopDoorButtons = jobExtension.CartopDoorButtons; dbEntry.DoorHold = jobExtension.DoorHold; dbEntry.Nudging = jobExtension.Nudging; dbEntry.DoorBrand = jobExtension.DoorBrand; dbEntry.DoorModel = jobExtension.DoorModel; dbEntry.SCOP = jobExtension.SCOP; dbEntry.SHC = jobExtension.SHC; dbEntry.SHCRisers = jobExtension.SHCRisers; dbEntry.AUXCOP = jobExtension.AUXCOP; } } context.SaveChanges(); }
public void SaveEngJobView(JobViewModel viewModelToSave) { SaveJob(viewModelToSave.CurrentJob); if (viewModelToSave.CurrentJobExtension != null) { if (viewModelToSave.CurrentJobExtension.JobID != 0) { JobExtension jobExtension = JobsExtensions.FirstOrDefault(j => j.JobID == viewModelToSave.CurrentJobExtension.JobID); if (jobExtension == null) { SaveJobExtension(viewModelToSave.CurrentJobExtension); } else { viewModelToSave.CurrentJobExtension.JobExtensionID = jobExtension.JobExtensionID; SaveJobExtension(viewModelToSave.CurrentJobExtension); } } } if (viewModelToSave.CurrentHydroSpecific != null) { if (viewModelToSave.CurrentHydroSpecific.JobID != 0) { HydroSpecific hydroSpecific = HydroSpecifics.FirstOrDefault(j => j.JobID == viewModelToSave.CurrentHydroSpecific.JobID); if (hydroSpecific == null) { SaveHydroSpecific(viewModelToSave.CurrentHydroSpecific); } else { viewModelToSave.CurrentHydroSpecific.HydroSpecificID = hydroSpecific.HydroSpecificID; SaveHydroSpecific(viewModelToSave.CurrentHydroSpecific); } } } if (viewModelToSave.CurrentGenericFeatures != null) { if (viewModelToSave.CurrentGenericFeatures.JobID != 0) { GenericFeatures genericFeatures = GenericFeaturesList.FirstOrDefault(j => j.JobID == viewModelToSave.CurrentGenericFeatures.JobID); if (genericFeatures == null) { SaveGenericFeatures(viewModelToSave.CurrentGenericFeatures); } else { viewModelToSave.CurrentGenericFeatures.GenericFeaturesID = genericFeatures.GenericFeaturesID; SaveGenericFeatures(viewModelToSave.CurrentGenericFeatures); } } } if (viewModelToSave.CurrentIndicator != null) { if (viewModelToSave.CurrentIndicator.JobID != 0) { Indicator indicator = Indicators.FirstOrDefault(j => j.JobID == viewModelToSave.CurrentIndicator.JobID); if (indicator == null) { SaveIndicator(viewModelToSave.CurrentIndicator); } else { viewModelToSave.CurrentIndicator.IndicatorID = indicator.IndicatorID; SaveIndicator(viewModelToSave.CurrentIndicator); } } } if (viewModelToSave.CurrentHoistWayData != null) { if (viewModelToSave.CurrentHoistWayData.JobID != 0) { HoistWayData hoistway = HoistWayDatas.FirstOrDefault(j => j.JobID == viewModelToSave.CurrentHoistWayData.JobID); if (hoistway == null) { SaveHoistWayData(viewModelToSave.CurrentHoistWayData); } else { viewModelToSave.CurrentHoistWayData.HoistWayDataID = hoistway.HoistWayDataID; SaveHoistWayData(viewModelToSave.CurrentHoistWayData); } } } }