public MainResponse GetAllSponsors(BaseRecordFilterRequest request) { IEnumerable <SponsorResponse> sponsorResponses; SponsorListResponse sponsorListResponse = new SponsorListResponse(); sponsorResponses = (from sponsor in _context.Sponsors join address in _context.Addresses on sponsor.AddressId equals address.AddressId into data1 from data in data1.DefaultIfEmpty() where sponsor.IsActive == true && sponsor.IsDeleted == false && data.IsActive == true && data.IsDeleted == false select new SponsorResponse { SponsorId = sponsor.SponsorId, SponsorName = sponsor.SponsorName, ContactName = sponsor.ContactName, Phone = sponsor.Phone, Email = sponsor.Email, AmountReceived = sponsor.AmountReceived, Address = data != null ? data.Address : "", ZipCodeId = data != null ? data.ZipCodeId :0, CityId = data != null ? data.CityId : 0, StateId = data != null ? _context.Cities.Where(x => x.CityId == data.CityId).Select(y => y.StateId).FirstOrDefault() : 0, }).ToList(); if (sponsorResponses.Count() > 0) { if (request.SearchTerm != null && request.SearchTerm != "") { sponsorResponses = sponsorResponses.Where(x => Convert.ToString(x.SponsorId).ToLower().Contains(request.SearchTerm) || x.SponsorName.ToLower().Contains(request.SearchTerm.ToLower())); } var propertyInfo = typeof(SponsorResponse).GetProperty(request.OrderBy); if (request.OrderByDescending == true) { sponsorResponses = sponsorResponses.OrderByDescending(s => s.GetType().GetProperty(request.OrderBy).GetValue(s)).ToList(); } else { sponsorResponses = sponsorResponses.AsEnumerable().OrderBy(s => propertyInfo.GetValue(s, null)).ToList(); } sponsorListResponse.TotalRecords = sponsorResponses.Count(); if (request.AllRecords == true) { sponsorResponses = sponsorResponses.ToList(); } else { sponsorResponses = sponsorResponses.Skip((request.Page - 1) * request.Limit).Take(request.Limit).ToList(); } } sponsorListResponse.sponsorResponses = sponsorResponses.ToList(); _mainResponse.SponsorListResponse = sponsorListResponse; return(_mainResponse); }
public SponsorListResponse SearchSponsor(SearchRequest searchRequest) { IEnumerable <SponsorResponse> sponsorResponses; SponsorListResponse sponsorListResponse = new SponsorListResponse(); sponsorResponses = (from sponsor in _context.Sponsors join address in _context.Addresses on sponsor.AddressId equals address.AddressId into data1 from data in data1.DefaultIfEmpty() where sponsor.IsActive == true && sponsor.IsDeleted == false && data.IsActive == true && data.IsDeleted == false && ((searchRequest.SearchTerm != string.Empty ? Convert.ToString(sponsor.SponsorId).Contains(searchRequest.SearchTerm) : (1 == 1)) || (searchRequest.SearchTerm != string.Empty ? sponsor.SponsorName.Contains(searchRequest.SearchTerm) : (1 == 1))) select new SponsorResponse { SponsorId = sponsor.SponsorId, SponsorName = sponsor.SponsorName, ContactName = sponsor.ContactName, Phone = sponsor.Phone, Email = sponsor.Email, AmountReceived = sponsor.AmountReceived, Address = data != null ? data.Address : "", ZipCode = data != null ? data.ZipCode : "", StateId = data != null ? data.StateId : 0, }).ToList(); if (sponsorResponses.Count() > 0) { var propertyInfo = typeof(SponsorResponse).GetProperty(searchRequest.OrderBy); if (searchRequest.OrderByDescending == true) { sponsorResponses = sponsorResponses.OrderByDescending(s => s.GetType().GetProperty(searchRequest.OrderBy).GetValue(s)).ToList(); } else { sponsorResponses = sponsorResponses.AsEnumerable().OrderBy(s => propertyInfo.GetValue(s, null)).ToList(); } sponsorListResponse.TotalRecords = sponsorResponses.Count(); if (searchRequest.AllRecords == true) { sponsorResponses = sponsorResponses.ToList(); } else { sponsorResponses = sponsorResponses.Skip((searchRequest.Page - 1) * searchRequest.Limit).Take(searchRequest.Limit).ToList(); } } sponsorListResponse.sponsorResponses = sponsorResponses.ToList(); return(sponsorListResponse); }
/// <summary> /// Gets the list of channel memberships. /// </summary> /// <param name="maxResults">The maximum results to return</param> /// <returns>The list of channel memberships</returns> public async Task <IEnumerable <Sponsor> > GetChannelMemberships(int maxResults = 1) { return(await this.YouTubeServiceWrapper(async() => { List <Sponsor> results = new List <Sponsor>(); string pageToken = null; do { SponsorsResource.ListRequest request = this.connection.GoogleYouTubeService.Sponsors.List("id,snippet"); request.MaxResults = Math.Min(maxResults, 50); request.PageToken = pageToken; SponsorListResponse response = await request.ExecuteAsync(); results.AddRange(response.Items); maxResults -= response.Items.Count; pageToken = response.NextPageToken; } while (maxResults > 0 && !string.IsNullOrEmpty(pageToken)); return results; })); }