private void SetAuditInitiated(int auditId, SQLHoshinCoreContext ctx)
{
var audit = ctx.Audits.FirstOrDefault((x) => x.AuditID == auditId);
var stateInitiated = ctx.AuditStates.FirstOrDefault(x => x.Code == "INI").AuditStateID;
if (audit.AuditStateID != stateInitiated)
{
audit.AuditStateID = stateInitiated;
ctx.Update(audit);
}
}
public ParametrizationCriteria Update(ParametrizationCriteria updateparam)
{
var paramCriteria = _ctx.ParametrizationCriterias.Where(x => x.ParametrizationCriteriaID == updateparam.Id).FirstOrDefault();
paramCriteria.Name = updateparam.Name;
paramCriteria.DataType = updateparam.DataType;
_ctx.Update(paramCriteria);
_ctx.SaveChanges();
return(updateparam);
}
public void UpdateAssociations(Plant plant)
{
try
{
var pl = _ctx.Plants
.Include(x => x.SectorsPlants)
.ThenInclude(x => x.JobsSectorsPlants)
.Where(x => x.PlantID == plant.PlantID)
.FirstOrDefault();
var listSectorsPlants = new List <SectorsPlants>();
foreach (var sector in plant.Sectors)
{
var sectorPlant = pl.SectorsPlants.Where(x => x.SectorID == sector.Id && x.PlantID == plant.PlantID).FirstOrDefault();
if (sectorPlant == null)
{
sectorPlant = new SectorsPlants()
{
Plant = pl,
Sector = _ctx.Sectors.Where(x => x.SectorID == sector.Id).FirstOrDefault(),
JobsSectorsPlants = new List <JobsSectorsPlants>()
};
}
if (sector.jobs != null && sector.jobs.Count > 0)
{
sectorPlant.JobsSectorsPlants = this.GetUpdatedJobsOfSector(sector.jobs, sectorPlant);
}
listSectorsPlants.Add(sectorPlant);
}
pl.SectorsPlants = listSectorsPlants;
_ctx.Update(pl);
_ctx.SaveChanges();
}
catch (DbUpdateException ex)
{
throw new DbUpdateException("No puede actualizarse ya que existen registros asociados a la Planta/Sector/Puesto", ex);
}
catch (Exception ex)
{
throw new Exception("No puede actualizarse ya que existen registros asociados a la Planta/Sector/Puesto", ex);
}
}