public int UpdateRace(RaceDTO raceDTO) { var currentRace = _context.Races.SingleOrDefault(r => r.Race_id == raceDTO.RaceId); using (var transaction = _context.Database.BeginTransaction()) { try { currentRace.Name = raceDTO.Name; currentRace.Race_Format_id = raceDTO.RaceFormatId; currentRace.Year = raceDTO.Year; int result = _context.SaveChanges(); transaction.Commit(); return(result); } catch (Exception e) { throw e; } finally { _context.Database.CloseConnection(); } } }
public int AddRace(RaceDTO raceDTO) { //var race = new Race() { Race_Format_id = raceDTO.RaceFormatId, Name = raceDTO.Name, Year = raceDTO.Year }; var race = _mapper.Map <RaceDTO, Race>(raceDTO); _context.Races.Add(race); using (var transaction = _context.Database.BeginTransaction()) { try { //_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Races ON"); int result = _context.SaveChanges(); //_context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Races OFF"); transaction.Commit(); return(result); } catch (Exception e) { throw e; } finally { _context.Database.CloseConnection(); } } }