public void AddGameHuntPlan(GameCountPlanViewModel model, int marketingYearId) { IList <GameDto> games = _gameDao.GetByKindName(model.GameKindName); if (!String.IsNullOrWhiteSpace(model.GameSubKindName)) { games = games.Where(x => x.SubKindName == model.GameSubKindName).ToList(); } int gameId = games.Select(x => x.Id).FirstOrDefault(); IList <GameCountFor10MarchDto> existingGameCountPlanDto = _gameCountFor10MarchDao.GetByMarketingYear(marketingYearId); if (existingGameCountPlanDto.Any(x => x.GameId == gameId && x.Class == model.Class)) { throw new Exception($"Plan liczebności zwierzyny {model.GameKindName} - {model.GameSubKindName} - {model.ClassName} już istnieje! Proszę użyć opcji edycji istniejącego już planu."); } var dto = new GameCountFor10MarchDto { GameId = gameId, Class = model.Class, Count = model.Count, MarketingYearId = marketingYearId }; _gameCountFor10MarchDao.Insert(dto); }
public void UpdateGameHuntPlan(GameCountPlanViewModel model, int marketingYearId) { var dto = new GameCountFor10MarchDto { Id = model.Id, GameId = model.GameId, Class = model.Class, Count = model.Count, MarketingYearId = marketingYearId }; _gameCountFor10MarchDao.Update(dto); }
public void Insert(GameCountFor10MarchDto dto) { var entity = new Entities.GameCountFor10March { GameId = dto.GameId, Class = dto.Class, Count = dto.Count, MarketingYearId = dto.MarketingYearId }; using (var db = new DbContext()) { db.GameCountFor10March.Add(entity); db.SaveChanges(); } }
private IList <GameCountFor10MarchDto> ToDtos(IList <Entities.GameCountFor10March> entityList) { var dtos = new List <GameCountFor10MarchDto>(); foreach (Entities.GameCountFor10March entity in entityList) { var dto = new GameCountFor10MarchDto { Id = entity.Id, GameId = entity.GameId, Class = entity.Class, Count = entity.Count, MarketingYearId = entity.MarketingYearId }; dtos.Add(dto); } return(dtos); }
public void Update(GameCountFor10MarchDto dto) { using (var db = new DbContext()) { Entities.GameCountFor10March gameCountFor10MarchPlan; if (dto.Id > 0) { gameCountFor10MarchPlan = db.GameCountFor10March.Single(x => x.Id == dto.Id); } else if (dto.GameId > 0 && dto.MarketingYearId > 0) { gameCountFor10MarchPlan = db.GameCountFor10March.Single(x => x.GameId == dto.GameId && x.MarketingYearId == dto.MarketingYearId); } else { throw new Exception($"Nie można edytować planu liczebności zwierzyny"); } gameCountFor10MarchPlan.Count = dto.Count; db.SaveChanges(); } }