public int Insert(LossGameDto dto)
{
var entity = new Entities.LossGame
{
GameId = dto.GameId,
Class = dto.Class
};
using (var db = new DbContext())
{
Entities.LossGame addedLossGame = db.LossGame.Add(entity);
db.SaveChanges();
return(addedLossGame.Id);
}
}
public void Insert(LossGameDto lossGameDto, LossDto lossDto)
{
using (var db = new DbContext())
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
var lossGameEntity = new Entities.LossGame
{
GameId = lossGameDto.GameId,
Class = lossGameDto.Class
};
db.LossGame.Add(lossGameEntity);
db.SaveChanges();
var lossEntity = new Entities.Loss
{
LossGameId = lossGameEntity.Id,
RegionId = lossDto.RegionId,
Date = lossDto.Date,
Description = lossDto.Description,
SanitaryLoss = lossDto.SanitaryLoss
};
db.Loss.Add(lossEntity);
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
}
