public HydroSpecific DeleteHydroSpecific(int hydroSpecificID) { HydroSpecific dbEntry = context.HydroSpecifics .FirstOrDefault(p => p.HydroSpecificID == hydroSpecificID); if (dbEntry != null) { context.HydroSpecifics.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 SaveHydroSpecific(HydroSpecific hydroSpecific) { if (hydroSpecific.HydroSpecificID == 0) { context.HydroSpecifics.Add(hydroSpecific); } else { HydroSpecific dbEntry = context.HydroSpecifics .FirstOrDefault(p => p.HydroSpecificID == hydroSpecific.HydroSpecificID); if (dbEntry != null) { dbEntry.JobID = hydroSpecific.JobID; dbEntry.Starter = hydroSpecific.Starter; dbEntry.HP = hydroSpecific.HP; dbEntry.FLA = hydroSpecific.FLA; dbEntry.SPH = hydroSpecific.SPH; dbEntry.MotorsNum = hydroSpecific.MotorsNum; dbEntry.ValveBrand = hydroSpecific.ValveBrand; dbEntry.ValveModel = hydroSpecific.ValveModel; dbEntry.ValveCoils = hydroSpecific.ValveCoils; dbEntry.ValveNum = hydroSpecific.ValveNum; dbEntry.ValveVoltage = hydroSpecific.ValveVoltage; dbEntry.Battery = hydroSpecific.Battery; dbEntry.BatteryBrand = hydroSpecific.BatteryBrand; dbEntry.LifeJacket = hydroSpecific.LifeJacket; dbEntry.LOS = hydroSpecific.LOS; dbEntry.OilCool = hydroSpecific.OilCool; dbEntry.OilTank = hydroSpecific.OilTank; dbEntry.PSS = hydroSpecific.PSS; dbEntry.Resync = hydroSpecific.Resync; dbEntry.Roped = hydroSpecific.Roped; dbEntry.VCI = hydroSpecific.VCI; } } 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); } } } }