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