public Objects.activities.Category UpdateCategory(Objects.activities.Category item) { var _entity = _ctx.activities_categories.FirstOrDefault(x => x.id == item.id); if (_entity == null) { throw new ArgumentException("Category not exist"); } //parent exist ? if (item.season == null) { throw new ArgumentException("Season is null"); } var _parent = _ctx.seasons.FirstOrDefault(x => x.id == item.season.id); if (_parent == null) { throw new ArgumentException("Season not exist"); } var __entity = Mapper.Map(item, _entity); __entity.season = _parent; __entity.season_id = _parent.id; _ctx.Entry(__entity).State = System.Data.Entity.EntityState.Modified; _ctx.SaveChanges(); return(Mapper.Map <Objects.activities.Category>(__entity)); }
public void DeleteCategory(Objects.activities.Category item) { var _entity = _ctx.activities_categories.FirstOrDefault(x => x.id == item.id); if (_entity == null) { throw new ArgumentException("Category not exist"); } _ctx.activities_categories.Remove(_entity); _ctx.SaveChanges(); }
public List <Objects.activities.Activity> GetsActivities(Objects.activities.Category category = null) { var query = _ctx.activities.Where(x => true); if (category != null) { query = query.Where(x => x.category_id == category.id); } query = query.OrderBy(x => x.name); return(Mapper.Map <List <Objects.activities.Activity> >(query.ToList())); }
public Objects.activities.Category AddCategory(Objects.activities.Category item, Objects.Season season) { if (season == null) { throw new ArgumentNullException("Season"); } var _season = _ctx.seasons.FirstOrDefault(x => x.id == season.id); if (_season == null) { throw new ArgumentException("Season not exist"); } item.id = 0; var _entity = Mapper.Map <Entities.activities.Category>(item); _entity.season = _season; _entity.season_id = _season.id; _entity = _ctx.activities_categories.Add(_entity); _ctx.SaveChanges(); return(Mapper.Map <Objects.activities.Category>(_entity)); }