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