public Objects.activities.Section AddSection(Objects.activities.Section item) { item.id = 0; //parent exist ? if (item == null) { throw new ArgumentException("Section is null"); } if (item.activity == null) { throw new ArgumentException("Activity is null"); } var _parent = _ctx.activities.FirstOrDefault(x => x.id == item.activity.id); if (_parent == null) { throw new ArgumentException("Activity not exist"); } var _entity = Mapper.Map <Entities.activities.Section>(item); _entity.activity = _parent; _entity.activity_id = _parent.id; _entity = _ctx.activities_sections.Add(_entity); _ctx.SaveChanges(); return(Mapper.Map <Objects.activities.Section>(_entity)); }
public void DeleteSection(Objects.activities.Section item) { var _entity = _ctx.activities_sections.FirstOrDefault(x => x.id == item.id); if (_entity == null) { throw new ArgumentException("Section not exist"); } _ctx.activities_sections.Remove(_entity); _ctx.SaveChanges(); }
public List <Objects.activities.Session> GetsSessions(Objects.activities.Section section = null, Objects.activities.Place place = null, Objects.Season season = null) { var query = _ctx.activities_sessions.Where(x => true); if (section != null) { query = query.Where(x => x.section_id == section.id); } if (place != null) { query = query.Where(x => x.place_id == place.id); } if (season != null) { query = query.Where(x => x.section.activity.category.season_id == season.id); } query = query.OrderBy(x => x.day); return(Mapper.Map <List <Objects.activities.Session> >(query.ToList())); }
public Objects.activities.Section UpdateSection(Objects.activities.Section item) { if (item == null) { throw new ArgumentException("Section is null"); } var _entity = _ctx.activities_sections.FirstOrDefault(x => x.id == item.id); if (_entity == null) { throw new ArgumentException("Section not exist"); } //parent exist ? if (item.activity == null) { throw new ArgumentException("Activity is null"); } var _parent = _ctx.activities.FirstOrDefault(x => x.id == item.activity.id); if (_parent == null) { throw new ArgumentException("Activity not exist"); } var __entity = Mapper.Map(item, _entity); __entity.activity = _parent; __entity.activity_id = _parent.id; _ctx.Entry(__entity).State = System.Data.Entity.EntityState.Modified; _ctx.SaveChanges(); return(Mapper.Map <Objects.activities.Section>(__entity)); }