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));
}
