public void SaveHoistWayData(HoistWayData hoistWayData)
{
if (hoistWayData.HoistWayDataID == 0)
{
context.HoistWayDatas.Add(hoistWayData);
}
else
{
HoistWayData dbEntry = context.HoistWayDatas
.FirstOrDefault(p => p.HoistWayDataID == hoistWayData.HoistWayDataID);
if (dbEntry != null)
{
dbEntry.JobID = hoistWayData.JobID;
dbEntry.FrontFirstServed = hoistWayData.FrontFirstServed;
dbEntry.RearFirstServed = hoistWayData.RearFirstServed;
dbEntry.FrontSecondServed = hoistWayData.FrontSecondServed;
dbEntry.RearSecondServed = hoistWayData.RearSecondServed;
dbEntry.FrontThirdServed = hoistWayData.FrontThirdServed;
dbEntry.RearThirdServed = hoistWayData.RearThirdServed;
dbEntry.FrontFourthServed = hoistWayData.FrontFourthServed;
dbEntry.RearFourthServed = hoistWayData.RearFourthServed;
dbEntry.FrontFifthServed = hoistWayData.FrontFifthServed;
dbEntry.RearFifthServed = hoistWayData.RearFifthServed;
dbEntry.FrontSexthServed = hoistWayData.FrontSexthServed;
dbEntry.RearSexthServed = hoistWayData.RearSexthServed;
dbEntry.FrontSeventhServed = hoistWayData.FrontSeventhServed;
dbEntry.RearSeventhServed = hoistWayData.RearSeventhServed;
dbEntry.FrontEightServed = hoistWayData.FrontEightServed;
dbEntry.RearEightServed = hoistWayData.RearEightServed;
dbEntry.FrontNinthServed = hoistWayData.FrontNinthServed;
dbEntry.RearNinthServed = hoistWayData.RearNinthServed;
dbEntry.FrontTenthServed = hoistWayData.FrontTenthServed;
dbEntry.RearTenthServed = hoistWayData.RearTenthServed;
dbEntry.FrontEleventhServed = hoistWayData.FrontEleventhServed;
dbEntry.RearEleventhServed = hoistWayData.RearEleventhServed;
dbEntry.FrontTwelvethServed = hoistWayData.FrontTwelvethServed;
dbEntry.RearTwelvethServed = hoistWayData.RearTwelvethServed;
dbEntry.FrontThirteenthServed = hoistWayData.FrontThirteenthServed;
dbEntry.RearThirteenthServed = hoistWayData.RearThirteenthServed;
dbEntry.FrontFourteenthServed = hoistWayData.FrontFourteenthServed;
dbEntry.RearFourteenthServed = hoistWayData.RearFourteenthServed;
dbEntry.FrontFifteenthServed = hoistWayData.FrontFifteenthServed;
dbEntry.RearFifteenthServed = hoistWayData.RearFifteenthServed;
dbEntry.FrontSixteenthServed = hoistWayData.FrontSixteenthServed;
dbEntry.RearSixteenthServed = hoistWayData.RearSixteenthServed;
dbEntry.Capacity = hoistWayData.Capacity;
dbEntry.UpSpeed = hoistWayData.UpSpeed;
dbEntry.DownSpeed = hoistWayData.DownSpeed;
dbEntry.TotalTravel = hoistWayData.TotalTravel;
dbEntry.LandingSystem = hoistWayData.LandingSystem;
}
}
context.SaveChanges();
}
public HoistWayData DeleteHoistWayData(int hoistWayDataID)
{
HoistWayData dbEntry = context.HoistWayDatas
.FirstOrDefault(p => p.HoistWayDataID == hoistWayDataID);
if (dbEntry != null)
{
context.HoistWayDatas.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 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);
}
}
}
}