public void ReportLoss(GameLossModel model)
{
IList <GameDto> gameDtos = _gameDao.Get(model.Type, model.Kind, model.SubKind);
GameDto gameDto = gameDtos.FirstOrDefault();
if (gameDto == null)
{
throw new Exception("Could not find specified game!");
}
int regionId = _regionDao.GetRegionId(model.City, model.Circuit, model.District);
var gameLoss = new LossGameDto
{
GameId = gameDto.Id,
Class = model.Class
};
var loss = new LossDto
{
RegionId = regionId,
Description = model.Description,
Date = model.Date,
SanitaryLoss = model.SanitaryLoss
};
_lossDao.Insert(gameLoss, loss);
}
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);
}
}
private IList <LossGameDto> ToDtos(IList <Entities.LossGame> entityList)
{
var dtos = new List <LossGameDto>();
foreach (Entities.LossGame entity in entityList)
{
var dto = new LossGameDto
{
Id = entity.Id,
GameId = entity.GameId,
Class = entity.Class
};
dtos.Add(dto);
}
return(dtos);
}
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();
}
}
}
}
