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); } }