public ResultExhibitorDetails GetResultExhibitorDetails(ResultExhibitorRequest resultExhibitorRequest)
{
var exhibitor = (from exhibitors in _ObjContext.Exhibitors
join addresses in _ObjContext.Addresses on exhibitors.AddressId equals addresses.AddressId into addresses1
from addresses2 in addresses1.DefaultIfEmpty()
join city in _ObjContext.Cities on addresses2.CityId equals city.CityId into city1
from city2 in city1.DefaultIfEmpty()
join state in _ObjContext.States on city2.StateId equals state.StateId into state1
from state2 in state1.DefaultIfEmpty()
join zipcode in _ObjContext.ZipCodes2 on addresses2.ZipCodeId equals zipcode.ZipCodeId into zipcode1
from zipcode2 in zipcode1.DefaultIfEmpty()
join exhibitorsClass in _ObjContext.ExhibitorClass on exhibitors.ExhibitorId equals exhibitorsClass.ExhibitorId into exhibitorsClass1
from exhibitorsClass2 in exhibitorsClass1.DefaultIfEmpty()
where exhibitors.IsActive == true && exhibitors.IsDeleted == false &&
exhibitors.BackNumber == resultExhibitorRequest.BackNumber && exhibitorsClass2.ClassId == resultExhibitorRequest.ClassId &&
exhibitorsClass2.IsActive == true && exhibitorsClass2.IsDeleted == false
select new ResultExhibitorDetails
{
ExhibitorId = exhibitors.ExhibitorId,
ExhibitorName = exhibitors.FirstName + " " + exhibitors.LastName,
BirthYear = exhibitors.BirthYear,
HorseName = _ObjContext.Horses.Where(x => x.HorseId == exhibitorsClass2.HorseId && x.IsActive == true && x.IsDeleted == false).Select(x => x.Name).FirstOrDefault(),
Address = city2.Name + ", " + state2.Code + ", " + zipcode2.ZipCode
}).FirstOrDefault();
return(exhibitor);
}
public MainResponse GetResultExhibitorDetails(ResultExhibitorRequest resultExhibitorRequest)
{
var exhibitorDetails = _classRepository.GetResultExhibitorDetails(resultExhibitorRequest);
if (exhibitorDetails != null)
{
_mainResponse.ResultExhibitorDetails = exhibitorDetails;
_mainResponse.Success = true;
}
else
{
_mainResponse.Message = Constants.NO_RECORD_FOUND;
_mainResponse.Success = false;
}
return(_mainResponse);
}
public ResultExhibitorDetails GetResultExhibitorDetails(ResultExhibitorRequest resultExhibitorRequest)
{
var exhibitorHorse = _ObjContext.ExhibitorHorse.Where(x => x.BackNumber == resultExhibitorRequest.BackNumber && x.IsDeleted == false).FirstOrDefault();
var exhibitor = (from exhibitors in _ObjContext.Exhibitors
join addresses in _ObjContext.Addresses on exhibitors.AddressId equals addresses.AddressId into addresses1
from addresses2 in addresses1.DefaultIfEmpty()
join state in _ObjContext.States on addresses2.StateId equals state.StateId into state1
from state2 in state1.DefaultIfEmpty()
where exhibitors.IsActive == true && exhibitors.IsDeleted == false &&
exhibitors.ExhibitorId == (exhibitorHorse != null? exhibitorHorse.ExhibitorId:0)
select new ResultExhibitorDetails
{
ExhibitorId = exhibitors.ExhibitorId,
ExhibitorName = exhibitors.FirstName + " " + exhibitors.LastName,
BirthYear = exhibitors.BirthYear,
HorseId = exhibitorHorse != null ? exhibitorHorse.HorseId : 0,
HorseName = _ObjContext.Horses.Where(x => x.HorseId == (exhibitorHorse != null ? exhibitorHorse.HorseId : 0) && x.IsActive == true && x.IsDeleted == false).Select(x => x.Name).FirstOrDefault(),
Address = addresses2.City + ", " + state2.Code + ", " + addresses2.ZipCode
}).FirstOrDefault();
return(exhibitor);
}
public IActionResult GetResultExhibitorDetails(ResultExhibitorRequest resultExhibitorRequest)
{
_mainResponse = _classService.GetResultExhibitorDetails(resultExhibitorRequest);
_jsonString = Mapper.Convert <ResultExhibitorDetails>(_mainResponse);
return(new OkObjectResult(_jsonString));
}
