public MainResponse GetAllGroups(BaseRecordFilterRequest request) { IEnumerable <GroupResponse> GroupResponses; GroupListResponse GroupListResponse = new GroupListResponse(); GroupResponses = (from Group in _context.Groups join address in _context.Addresses on Group.AddressId equals address.AddressId into data1 from data in data1.DefaultIfEmpty() where Group.IsActive == true && Group.IsDeleted == false && data.IsActive == true && data.IsDeleted == false select new GroupResponse { GroupId = Group.GroupId, GroupName = Group.GroupName, ContactName = Group.ContactName, Phone = Group.Phone, Email = Group.Email, AmountReceived = Group.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 (GroupResponses.Count() > 0) { if (request.SearchTerm != null && request.SearchTerm != "") { GroupResponses = GroupResponses.Where(x => Convert.ToString(x.GroupId).ToLower().Contains(request.SearchTerm) || x.GroupName.ToLower().Contains(request.SearchTerm.ToLower())); } var propertyInfo = typeof(GroupResponse).GetProperty(request.OrderBy); if (request.OrderByDescending == true) { GroupResponses = GroupResponses.OrderByDescending(s => s.GetType().GetProperty(request.OrderBy).GetValue(s)).ToList(); } else { GroupResponses = GroupResponses.AsEnumerable().OrderBy(s => propertyInfo.GetValue(s, null)).ToList(); } GroupListResponse.TotalRecords = GroupResponses.Count(); if (request.AllRecords == true) { GroupResponses = GroupResponses.ToList(); } else { GroupResponses = GroupResponses.Skip((request.Page - 1) * request.Limit).Take(request.Limit).ToList(); } } GroupListResponse.groupResponses = GroupResponses.ToList(); _MainResponse.GroupListResponse = GroupListResponse; return(_MainResponse); }
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 : "", ZipCode = data != null ? data.ZipCode :"", StateId = data != null ? data.StateId : 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 MainResponse GetAllClassSponsorWithFilter(BaseRecordFilterRequest request) { _mainResponse = _ClassSponsorRepository.GetAllClassSponsorWithFilters(request); if (_mainResponse.ClassSponsorListResponse.classSponsorResponses != null && _mainResponse.ClassSponsorListResponse.classSponsorResponses.Count > 0) { _mainResponse.ClassSponsorListResponse.TotalRecords = _mainResponse.ClassSponsorListResponse.classSponsorResponses.Count(); _mainResponse.Message = Constants.RECORD_FOUND; _mainResponse.Success = true; } return(_mainResponse); }
public ExhibitorListResponse GetAllExhibitors(BaseRecordFilterRequest filterRequest) { IEnumerable <ExhibitorResponse> exhibitorResponses = null; ExhibitorListResponse exhibitorListResponses = new ExhibitorListResponse(); exhibitorResponses = (from exhibitor in _context.Exhibitors where exhibitor.IsActive == true && exhibitor.IsDeleted == false select new ExhibitorResponse { ExhibitorId = exhibitor.ExhibitorId, AddressId = exhibitor.AddressId, FirstName = exhibitor.FirstName, LastName = exhibitor.LastName, BackNumber = exhibitor.BackNumber, BirthYear = exhibitor.BirthYear, IsNSBAMember = exhibitor.IsNSBAMember, IsDoctorNote = exhibitor.IsDoctorNote, QTYProgram = exhibitor.QTYProgram, PrimaryEmail = exhibitor.PrimaryEmail, SecondaryEmail = exhibitor.SecondaryEmail, Phone = exhibitor.Phone, }).ToList(); if (exhibitorResponses.Count() > 0) { if (filterRequest.SearchTerm != null && filterRequest.SearchTerm != "") { exhibitorResponses = exhibitorResponses.Where(x => Convert.ToString(x.ExhibitorId).Contains(filterRequest.SearchTerm) || x.FirstName.ToLower().Contains(filterRequest.SearchTerm.ToLower()) || x.LastName.ToLower().Contains(filterRequest.SearchTerm.ToLower()) || Convert.ToString(x.BirthYear).Contains(filterRequest.SearchTerm)); } var propertyInfo = typeof(ExhibitorResponse).GetProperty(filterRequest.OrderBy); if (filterRequest.OrderByDescending == true) { exhibitorResponses = exhibitorResponses.OrderByDescending(s => s.GetType().GetProperty(filterRequest.OrderBy).GetValue(s)).ToList(); } else { exhibitorResponses = exhibitorResponses.AsEnumerable().OrderBy(s => propertyInfo.GetValue(s, null)).ToList(); } exhibitorListResponses.TotalRecords = exhibitorResponses.Count(); if (filterRequest.AllRecords == true) { exhibitorListResponses.exhibitorResponses = exhibitorResponses.ToList(); } else { exhibitorListResponses.exhibitorResponses = exhibitorResponses.Skip((filterRequest.Page - 1) * filterRequest.Limit).Take(filterRequest.Limit).ToList(); } } return(exhibitorListResponses); }
public MainResponse GetAllSponsors(BaseRecordFilterRequest request) { _mainResponse = _SponsorRepository.GetAllSponsors(request); if (_mainResponse.SponsorListResponse.sponsorResponses != null && _mainResponse.SponsorListResponse.sponsorResponses.Count() > 0) { _mainResponse.Message = Constants.RECORD_FOUND; _mainResponse.Success = true; } else { _mainResponse.Message = Constants.NO_RECORD_FOUND; _mainResponse.Success = false; } return(_mainResponse); }
public MainResponse GetAllGroups(BaseRecordFilterRequest request) { // AddZipCodes(); _mainResponse = _GroupRepository.GetAllGroups(request); if (_mainResponse.GroupListResponse.groupResponses != null && _mainResponse.GroupListResponse.groupResponses.Count() > 0) { _mainResponse.Message = Constants.RECORD_FOUND; _mainResponse.Success = true; } else { _mainResponse.Message = Constants.NO_RECORD_FOUND; _mainResponse.Success = false; } return(_mainResponse); }
public MainResponse GetAllExhibitors(BaseRecordFilterRequest filterRequest) { var exhibitorList = _exhibitorRepository.GetAllExhibitors(filterRequest); if (exhibitorList.exhibitorResponses != null && exhibitorList.TotalRecords > 0) { _mainResponse.ExhibitorListResponse = exhibitorList; _mainResponse.Message = Constants.RECORD_FOUND; _mainResponse.Success = true; } else { _mainResponse.Message = Constants.NO_RECORD_FOUND; _mainResponse.Success = false; } return(_mainResponse); }
public MainResponse GetAllAdvertisements(BaseRecordFilterRequest request) { IEnumerable <AdvertisementResponse> advertisementResponses; AdvertisementListResponse advertisementListResponse = new AdvertisementListResponse(); advertisementResponses = (from ad in _context.Advertisements where ad.IsActive == true && ad.IsDeleted == false select new AdvertisementResponse { AdvertisementId = ad.AdvertisementId, AdvertisementTypeId = ad.AdvertisementTypeId, AdvertisementSizeId = ad.AdvertisementSizeId, AdvertisementNumber = ad.AdvertisementNumber, Name = ad.Name, Comments = ad.Comments, }).ToList(); if (advertisementResponses.Count() > 0) { var propertyInfo = typeof(SponsorResponse).GetProperty(request.OrderBy); if (request.OrderByDescending == true) { advertisementResponses = advertisementResponses.OrderByDescending(s => s.GetType().GetProperty(request.OrderBy).GetValue(s)).ToList(); } else { advertisementResponses = advertisementResponses.AsEnumerable().OrderBy(s => propertyInfo.GetValue(s, null)).ToList(); } advertisementListResponse.TotalRecords = advertisementResponses.Count(); if (request.AllRecords == true) { advertisementResponses = advertisementResponses.ToList(); } else { advertisementResponses = advertisementResponses.Skip((request.Page - 1) * request.Limit).Take(request.Limit).ToList(); } } advertisementListResponse.advertisementResponses = advertisementResponses.ToList(); _MainResponse.AdvertisementListResponse = advertisementListResponse; return(_MainResponse); }
public MainResponse GetAllClassSponsorWithFilters(BaseRecordFilterRequest request) { IEnumerable <ClassSponsorResponse> classSponsorResponses; ClassSponsorListResponse classSponsorListResponse = new ClassSponsorListResponse(); classSponsorResponses = (from classSponsor in _context.ClassSponsors where classSponsor.IsActive == true && classSponsor.IsDeleted == false select new ClassSponsorResponse { ClassSponsorId = classSponsor.ClassSponsorId, SponsorId = classSponsor.SponsorId, ClassId = classSponsor.ClassId, }).ToList(); if (classSponsorResponses.Count() > 0) { var propertyInfo = typeof(ClassSponsorResponse).GetProperty(request.OrderBy); if (request.OrderByDescending == true) { classSponsorResponses = classSponsorResponses.OrderByDescending(s => s.GetType().GetProperty(request.OrderBy).GetValue(s)).ToList(); } else { classSponsorResponses = classSponsorResponses.AsEnumerable().OrderBy(s => propertyInfo.GetValue(s, null)).ToList(); } if (request.AllRecords == true) { classSponsorResponses = classSponsorResponses.ToList(); } else { classSponsorResponses = classSponsorResponses.Skip((request.Page - 1) * request.Limit).Take(request.Limit).ToList(); } } classSponsorListResponse.classSponsorResponses = classSponsorResponses.ToList(); _mainResponse.ClassSponsorListResponse = classSponsorListResponse; return(_mainResponse); }
public ActionResult GetAllExhibitors(BaseRecordFilterRequest filterRequest) { _mainResponse = _exhibitorService.GetAllExhibitors(filterRequest); _jsonString = Mapper.Convert <ExhibitorListResponse> (_mainResponse); return(new OkObjectResult(_jsonString)); }
public ActionResult GetAllAdvertisements(BaseRecordFilterRequest request) { _mainResponse = _AdvertisementService.GetAllAdvertisements(request); _jsonString = Mapper.Convert <AdvertisementListResponse>(_mainResponse); return(new OkObjectResult(_jsonString)); }
public ActionResult GetAllGroups(BaseRecordFilterRequest request) { _mainResponse = _GroupService.GetAllGroups(request); _jsonString = Mapper.Convert <GroupListResponse>(_mainResponse); return(new OkObjectResult(_jsonString)); }
public ActionResult GetAllClassSponsorsWithFilter([FromBody] BaseRecordFilterRequest request) { _mainResponse = _ClassSponsorService.GetAllClassSponsorWithFilter(request); _jsonString = Mapper.Convert <ClassSponsorListResponse>(_mainResponse); return(new OkObjectResult(_jsonString)); }