public Employee UpdateEmployee(Employee employeeToUpdate)
{
var currentValue = _context.Employees.First(n => n.EmployeeId == employeeToUpdate.EmployeeId);
employeeToUpdate.CreatedBy = currentValue.CreatedBy;
employeeToUpdate.DatetimeCreated = currentValue.DatetimeCreated;
_context.Entry(currentValue).State = Microsoft.EntityFrameworkCore.EntityState.Detached;
_context.Entry(employeeToUpdate).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
var updateResult = _context.Employees.Update(employeeToUpdate);
_context.SaveChanges();
return(updateResult.Entity);
}
public TankType UpdateTankType(TankType TankTypeToUpdate)
{
var currentValue = _context.TankTypes.First(n => n.TankTypeId == TankTypeToUpdate.TankTypeId);
TankTypeToUpdate.CreatedBy = currentValue.CreatedBy;
TankTypeToUpdate.DatetimeCreated = currentValue.DatetimeCreated;
TankTypeToUpdate.DatetimeUpdated = DateTime.Now;
TankTypeToUpdate.UpdatedBy = "SYSTEM";
_context.Entry(currentValue).State = Microsoft.EntityFrameworkCore.EntityState.Detached;
_context.Entry(TankTypeToUpdate).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
var updateResult = _context.TankTypes.Update(TankTypeToUpdate);
_context.SaveChanges();
return(updateResult.Entity);
}
public Line UpdateLine(Line lineToUpdate)
{
var currentValue = _context.Lines.First(n => n.LineId == lineToUpdate.LineId);
lineToUpdate.CreatedBy = currentValue.CreatedBy;
lineToUpdate.DatetimeCreated = currentValue.DatetimeCreated;
lineToUpdate.DatetimeUpdated = DateTime.Now;
lineToUpdate.UpdatedBy = "SYSTEM";
_context.Entry(currentValue).State = Microsoft.EntityFrameworkCore.EntityState.Detached;
_context.Entry(lineToUpdate).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
var updateResult = _context.Lines.Update(lineToUpdate);
_context.SaveChanges();
return(updateResult.Entity);
}
public TankMeasurementNominal UpdateTankMeasurementNominal(TankMeasurementNominal nominalToUpdate)
{
var currentValue = _context.TankMeasurementNominals.First(n => n.TankMeasurementNominalId == nominalToUpdate.TankMeasurementNominalId);
nominalToUpdate.CreatedBy = currentValue.CreatedBy;
nominalToUpdate.DatetimeCreated = currentValue.DatetimeCreated;
nominalToUpdate.DatetimeUpdated = DateTime.Now;
nominalToUpdate.UpdatedBy = "SYSTEM";
_context.Entry(currentValue).State = Microsoft.EntityFrameworkCore.EntityState.Detached;
_context.Entry(nominalToUpdate).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
var updateResult = _context.TankMeasurementNominals.Update(nominalToUpdate);
_context.SaveChanges();
return(updateResult.Entity);
}
public TankMeasurementType UpdateTankMeasurementType(TankMeasurementType tankMeasurementTypeToUpdate)
{
try
{
var currentValue = _context.TankMeasurementTypes.First(t => t.TankMeasurementTypeId == tankMeasurementTypeToUpdate.TankMeasurementTypeId);
tankMeasurementTypeToUpdate.CreatedBy = currentValue.CreatedBy;
tankMeasurementTypeToUpdate.DatetimeCreated = currentValue.DatetimeCreated;
tankMeasurementTypeToUpdate.DatetimeUpdated = DateTime.Now;
tankMeasurementTypeToUpdate.UpdatedBy = "SYSTEM";
_context.Entry(currentValue).State = Microsoft.EntityFrameworkCore.EntityState.Detached;
_context.Entry(tankMeasurementTypeToUpdate).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
var result = _context.TankMeasurementTypes.Update(tankMeasurementTypeToUpdate);
_context.SaveChanges();
return(result.Entity);
}
catch (Exception ex)
{
_logger.LogError(Utility.FlattException(ex));
return(null);
}
}