public ListResponse <PlayTitleDTO> SearchPlaysTitles(PlaysSearchingCriteria criteria, int pageNr, int pageAmount) { using (var context = new AF_Context()) { try { var skip = pageAmount * (pageNr - 1); var query = (from p in context.Plays select p); if (criteria.FestivalIdFilter != null) { query = query.Where(p => p.FestivalId == criteria.FestivalIdFilter); } if (!String.IsNullOrEmpty(criteria.Author)) { query = query.Where(p => p.Author.Contains(criteria.Author)); } if (!String.IsNullOrEmpty(criteria.Title)) { query = query.Where(p => p.Title.Contains(criteria.Title)); } if (!String.IsNullOrEmpty(criteria.Motto)) { query = query.Where(p => p.Motto.Contains(criteria.Motto)); } List <PlayTitleDTO> tmp = new List <PlayTitleDTO>(); foreach (Play pla in (query.OrderBy(p => p.FestivalId) .ThenBy(p => p.Day) .ThenBy(p => p.Order) .Skip(skip) .Take(pageAmount))) { var newPlayDto = new PlayTitleDTO() { PlayId = pla.PlayId, Title = pla.Title, }; tmp.Add(newPlayDto); } return(new ListResponse <PlayTitleDTO>(tmp)); } catch (Exception ex) { throw; } } }
public SingleItemResponse <PlayTitleDTO> GetPlayTitle(int id) { using (var context = new AF_Context()) { try { Play pla = context.Plays.First(p => p.PlayId == id); var newPlayDto = new PlayTitleDTO() { PlayId = pla.PlayId, Title = pla.Title, }; return(new SingleItemResponse <PlayTitleDTO>(newPlayDto)); } catch (Exception ex) { throw; } } }
public SingleItemResponse<PlayTitleDTO> GetPlayTitle(int id) { using (var context = new AF_Context()) { try { Play pla = context.Plays.First(p => p.PlayId == id); var newPlayDto = new PlayTitleDTO() { PlayId = pla.PlayId, Title = pla.Title, }; return (new SingleItemResponse<PlayTitleDTO>(newPlayDto)); } catch (Exception ex) { throw; } } }
public ListResponse<PlayTitleDTO> SearchPlaysTitles(PlaysSearchingCriteria criteria, int pageNr, int pageAmount) { using (var context = new AF_Context()) { try { var skip = pageAmount * (pageNr - 1); var query = (from p in context.Plays select p); if (criteria.FestivalIdFilter != null) query = query.Where(p => p.FestivalId == criteria.FestivalIdFilter); if (!String.IsNullOrEmpty(criteria.Author)) query = query.Where(p => p.Author.Contains(criteria.Author)); if (!String.IsNullOrEmpty(criteria.Title)) query = query.Where(p => p.Title.Contains(criteria.Title)); if (!String.IsNullOrEmpty(criteria.Motto)) query = query.Where(p => p.Motto.Contains(criteria.Motto)); List<PlayTitleDTO> tmp = new List<PlayTitleDTO>(); foreach (Play pla in (query.OrderBy(p => p.FestivalId) .ThenBy(p => p.Day) .ThenBy(p => p.Order) .Skip(skip) .Take(pageAmount))) { var newPlayDto = new PlayTitleDTO() { PlayId = pla.PlayId, Title = pla.Title, }; tmp.Add(newPlayDto); } return (new ListResponse<PlayTitleDTO>(tmp)); } catch (Exception ex) { throw; } } }