public FeelAdminPlacesQueryResult Handle(FeelAdminPlacesQuery query)
{
List <FIL.Contracts.DataModels.Event> eventList = new List <Contracts.DataModels.Event>();
if (query.IsFeelExists)
{
if (_eventRepository.GetAllByUserAltId(query.UserAltId).Any())
{
return(new FeelAdminPlacesQueryResult {
IsFeelExists = true
});
}
else
{
return(new FeelAdminPlacesQueryResult {
});
}
}
if (query.IsMyFeel)
{
eventList = _eventRepository.GetAllByUserAltId(query.UserAltId).OrderByDescending(s => s.CreatedUtc).ToList();
}
else if (query.IsDeactivateFeels)
{
eventList = _eventRepository.GetAllFeels(true).Where(s => s.IsCreatedFromFeelAdmin == true).OrderByDescending(s => s.CreatedUtc).ToList();
eventList = eventList.Take(1000).ToList();
}
else
{
eventList = _eventRepository.GetAllFeelAdminEvents().OrderByDescending(s => s.CreatedUtc).ToList();
}
var users = _userRepository.GetAllByAltIds((eventList.Select(s => s.CreatedBy)));
var eventDetails = _eventDetailRepository.GetByEventIds(eventList.Select(s => s.Id));
var eventsModel = AutoMapper.Mapper.Map <List <FIL.Contracts.Models.Event> >(eventList);
var userModel = AutoMapper.Mapper.Map <List <FIL.Contracts.Models.User> >(users);
var eventDetailModel = AutoMapper.Mapper.Map <List <FIL.Contracts.Models.EventDetail> >(eventDetails);
var myFeelDetails = _eventRepository.GetMyFeelDetails(eventList.Select(s => s.Id).ToList()).ToList();
var eventAttributes = _eventAttributeRepository.GetByEventDetailIds(eventDetails.Select(s => s.Id).ToList()).ToList();
return(new FeelAdminPlacesQueryResult
{
IsFeelExists = eventsModel.Any() ? true : false,
Events = eventsModel,
EventDetails = eventDetailModel,
Users = userModel,
MyFeelDetails = myFeelDetails,
EventAttributes = eventAttributes
});
}
public GetExOzImagesQueryResult Handle(GetExOzImagesQuery query)
{
List <ExOzImageUploadModel> ExOzImageUploadModels = new List <ExOzImageUploadModel>();
var events = _eventRepository.GetBySourceId(Contracts.Enums.EventSource.ExperienceOz).ToList().Skip(query.SkipIndex).Take(query.TakeIndex);
var eventDetails = _eventDetailRepository.GetByEventIds(events.Select(s => s.Id));
var expOzImages = _exOzProductImageRepository.GetByEventDetailIds(eventDetails.Select(s => s.Id));
foreach (var currentEvent in events)
{
ExOzImageUploadModel ExOzImageUploadModel = new ExOzImageUploadModel();
List <string> imageLinks = new List <string>();
var currentEventDetailIds = eventDetails.Where(s => s.EventId == currentEvent.Id).ToList();
foreach (var currentEventDetailId in currentEventDetailIds)
{
var currentExpOzImages = expOzImages.Where(s => s.EventDetailId == currentEventDetailId.Id).FirstOrDefault();
if (currentExpOzImages != null)
{
imageLinks.Add(currentExpOzImages.ImageURL);
}
}
if (imageLinks.Count == 1)
{
imageLinks.Add(imageLinks.FirstOrDefault());
imageLinks.Add(imageLinks.FirstOrDefault());
}
if (imageLinks.Count == 2)
{
imageLinks.Add(imageLinks.FirstOrDefault());
}
if (imageLinks.Count > 0)
{
ExOzImageUploadModel.EventAltIds = currentEvent.AltId.ToString().ToUpper();
ExOzImageUploadModel.ImageLinks = imageLinks;
ExOzImageUploadModels.Add(ExOzImageUploadModel);
}
}
return(new GetExOzImagesQueryResult
{
ExOzImageUploadModels = ExOzImageUploadModels
});
}
public CategoryEventQueryResult Handle(CategoryEventQuery query)
{
var categoryEventsForSite = _eventRepository.GetByCategoryId(query.EventCategoryId).Where(e => e.IsEnabled).ToList();
var eventMapping = categoryEventsForSite.ToDictionary(e => e.Id);
var eventIds = eventMapping.Keys;
var allEventDetails = _eventDetailRepository.GetByEventIds(eventIds).Where(ed => ed.IsEnabled).ToList();
var venueMapping = _venueRepository.GetByVenueIds(allEventDetails.Select(ed => ed.VenueId).Distinct())
.ToDictionary(v => v.Id);
var eventDetailsMapping = allEventDetails.GroupBy(ed => ed.EventId)
.ToDictionary(g => g.Key, g => g.ToList());
var cityIds = venueMapping.Values.Select(s => s.CityId).Distinct();
var cityMapping = _cityRepository.GetByCityIds(cityIds)
.ToDictionary(c => c.Id);
var stateId = cityMapping.Values.Select(c => c.StateId).Distinct();
var stateMapping = _stateRepository.GetByStateIds(stateId)
.ToDictionary(s => s.Id);
var countryIdList = stateMapping.Values.Select(s => s.CountryId).Distinct();
var countryMapping = _countryRepository.GetByCountryIds(countryIdList)
.ToDictionary(c => c.Id);
var currencyTypeList = _currencyTypeRepository.GetAll();
var CategoryEventData = categoryEventsForSite.Select(ce =>
{
var eventObj = eventMapping[ce.Id];
if (eventDetailsMapping.ContainsKey(ce.Id))
{
var eventDetails = eventDetailsMapping[ce.Id];
var eventDetailIdList = eventDetails.Select(s => s.Id).Distinct();
var venues = eventDetails.Select(s => s.VenueId).Distinct().Select(v => venueMapping[v]);
var cities = venues.Select(s => s.CityId).Distinct().Select(c => cityMapping[c]);
var states = cities.Select(s => s.StateId).Distinct().Select(s => stateMapping[s]);
var countries = states.Select(s => s.CountryId).Distinct().Select(c => countryMapping[c]);
if (!eventDetailIdList.Any())
{
return(new CategoryEventContainer {
});
}
var eventTicketAttributeMapping = new List <Contracts.DataModels.EventTicketAttribute>
{
_eventTicketAttributeRepository.GetMaxPriceByEventDetailId(eventDetailIdList),
_eventTicketAttributeRepository.GetMinPriceByEventDetailId(eventDetailIdList)
};
if (eventTicketAttributeMapping.Any())
{
var currencyMapping = currencyTypeList.Where(s => s.Id == eventTicketAttributeMapping.FirstOrDefault().CurrencyId).FirstOrDefault();
return(new CategoryEventContainer
{
CategoryEvent = Mapper.Map <Contracts.Models.CategoryEvent>(ce),
EventType = eventObj.EventTypeId.ToString(),
City = Mapper.Map <IEnumerable <City> >(cities),
State = Mapper.Map <IEnumerable <State> >(states),
Country = Mapper.Map <IEnumerable <Country> >(countries),
Event = Mapper.Map <Event>(eventObj),
EventDetail = Mapper.Map <IEnumerable <EventDetail> >(eventDetails),
CurrencyType = Mapper.Map <CurrencyType>(currencyMapping),
Venue = Mapper.Map <IEnumerable <Venue> >(venues),
EventTicketAttribute = Mapper.Map <IEnumerable <EventTicketAttribute> >(eventTicketAttributeMapping),
});
}
else
{
return(new CategoryEventContainer {
});
}
}
else
{
return(new CategoryEventContainer
{
});
}
});
if (CategoryEventData.ToList() != null)
{
return(new CategoryEventQueryResult
{
CategoryEvents = CategoryEventData.Where(s => s.Event != null).ToList()
});
}
else
{
return(new CategoryEventQueryResult
{
});
}
}
public GetMultipleSubEventsQueryResult Handle(GetMultipleSubEventsQuery query)
{
List <FIL.Contracts.Models.EventDetail> subEventList = new List <FIL.Contracts.Models.EventDetail>();
List <EventDetail> subEventFinalList = new List <EventDetail>();
var userDetail = _userRepository.GetByAltId(query.UserAltId);
var eventDetail = _eventRepository.GetByAltIds(query.EventAltIds);
var eventIds = "";
foreach (var currentEvent in eventDetail)
{
eventIds = eventIds + currentEvent.Id + ",";
}
eventIds = eventIds.TrimEnd(',');
var currencyDetail = _currencyTypeRepository.GetByCurrencyIdsByEventIds(eventIds);
var assignedEvents = _eventsUserMappingRepository.GetByUserIdAndEventIds(userDetail.Id, eventDetail.Select(s => s.Id).ToList());
List <FIL.Contracts.Models.EventDetail> subEvents = new List <FIL.Contracts.Models.EventDetail>();
if (userDetail.RolesId != 1)
{
subEvents = AutoMapper.Mapper.Map <List <FIL.Contracts.Models.EventDetail> >(_eventDetailRepository.GetByEventDetailIds(assignedEvents.Select(s => s.EventDetailId)));
}
else
{
subEvents = AutoMapper.Mapper.Map <List <FIL.Contracts.Models.EventDetail> >(_eventDetailRepository.GetByEventIds(eventDetail.Select(s => s.Id).ToList()));
}
for (int k = 0; k < subEvents.Count; k = k + 2000)
{
var eventDetailBatcher = subEvents.Skip(k).Take(2000);
var Guid = new Guid("E6B318DB-0945-4F96-841A-F58AED54EFCB");
if (query.EventAltIds.Contains(Guid))
{
var venues = _venueRepository.GetByVenueIds(eventDetailBatcher.Select(s => s.VenueId).Distinct());
foreach (var item in venues)
{
subEventList.Add(new FIL.Contracts.Models.EventDetail
{
Id = item.Id,
Name = item.Name
});
}
}
else
{
subEventList = AutoMapper.Mapper.Map <List <FIL.Contracts.Models.EventDetail> >(eventDetailBatcher.OrderBy(o => o.StartDateTime));
}
subEventFinalList = subEventFinalList.Concat(AutoMapper.Mapper.Map <List <FIL.Contracts.Models.EventDetail> >(subEventList)).ToList();
}
return(new GetMultipleSubEventsQueryResult
{
SubEvents = subEventFinalList,
CurrencyTypes = currencyDetail
});
}
private FeelSearchQueryResult AdvanceSearch(FeelSearchQuery query)
{
var siteEvents = _eventSiteIdMappingRepository
.GetBySiteId(query.SiteId)
.OrderBy(o => o.SortOrder).ToList();
List <Contracts.DataModels.Event> searchEvents = new List <Contracts.DataModels.Event>();
if (query.PlaceAltIds != null && query.PlaceAltIds.Count() > 0)
{
searchEvents = _eventRepository.GetEventsByAltIds(query.PlaceAltIds)
.ToList();
}
else
{
searchEvents = _eventRepository.GetFeelEventsBySearchString(query.Name, query.SiteId)
.ToList();
}
var eventMapping = searchEvents.ToDictionary(e => e.Id);
var eventIds = eventMapping.Keys;
var eventCategoryMappings = _eventCategoryMappingRepository.GetByEventIds(eventIds).Where(ed => ed.IsEnabled == true);
var allEventDetails = _eventDetailRepository.GetByEventIds(eventIds).Where(ed => ed.IsEnabled == true);
var allEventRatings = _ratingRepository.GetByEventIds(eventIds);
var venueMapping = _venueRepository.GetByVenueIds(allEventDetails.Select(ed => ed.VenueId).Distinct())
.ToDictionary(v => v.Id);
var eventDetailsMapping = allEventDetails.GroupBy(ed => ed.EventId)
.ToDictionary(g => g.Key, g => g.ToList());
var eventCategoryMapping = eventCategoryMappings.GroupBy(ed => ed.EventId)
.ToDictionary(g => g.Key, g => g.ToList());
var eventRatingMapping = allEventRatings.GroupBy(ed => ed.EventId)
.ToDictionary(g => g.Key, g => g.ToList());
var cityIds = venueMapping.Values.Select(s => s.CityId).Distinct();
var cityMapping = _cityRepository.GetByCityIds(cityIds)
.ToDictionary(c => c.Id);
var stateId = cityMapping.Values.Select(c => c.StateId).Distinct();
var stateMapping = _stateRepository.GetByStateIds(stateId)
.ToDictionary(s => s.Id);
var countryIdList = stateMapping.Values.Select(s => s.CountryId).Distinct();
var countryMapping = _countryRepository.GetByCountryIds(countryIdList)
.ToDictionary(c => c.Id);
var eventsBySortOrder = new List <FIL.Contracts.DataModels.Event>();
foreach (var item in siteEvents)
{
var events = searchEvents.FirstOrDefault(w => w.Id == item.EventId);
if (events != null)
{
eventsBySortOrder.Add(AutoMapper.Mapper.Map <FIL.Contracts.DataModels.Event>(events));
}
}
var CategoryEventData = eventsBySortOrder.Select(ce =>
{
try
{
var eventObj = eventMapping[ce.Id];
var eventDetails = eventDetailsMapping[ce.Id];
var eventCategoryMap = eventCategoryMapping[ce.Id];
List <FIL.Contracts.DataModels.Rating> eventRatings;
if (eventRatingMapping.ContainsKey(ce.Id))
{
eventRatings = eventRatingMapping[ce.Id];
}
else
{
eventRatings = null;
}
var eventDetailIdList = eventDetails.Select(s => s.Id).Distinct().ToList();
var venues = eventDetails.Select(s => s.VenueId).Distinct().Select(v => venueMapping[v]);
var cities = venues.Select(s => s.CityId).Distinct().Select(c => cityMapping[c]);
var states = cities.Select(s => s.StateId).Distinct().Select(s => stateMapping[s]);
var countries = states.Select(s => s.CountryId).Distinct().Select(c => countryMapping[c]);
var eventTicketAttributeMapping = new List <Contracts.DataModels.EventTicketAttribute>
{
_eventTicketAttributeRepository.GetMaxPriceByEventDetailId(eventDetailIdList),
_eventTicketAttributeRepository.GetMinPriceByEventDetailId(eventDetailIdList)
};
var currencyMapping = _currencyTypeRepository.GetByCurrencyId(eventTicketAttributeMapping.First().CurrencyId);
List <string> eventCatMappings = new List <string>();
foreach (var eventCat in eventCategoryMap)
{
var eventCategoryDataModel = _eventCategoryRepository.Get(eventCat.EventCategoryId);
var eventCategoryModel = AutoMapper.Mapper.Map <Contracts.Models.EventCategory>(eventCategoryDataModel);
eventCatMappings.Add(eventCategoryModel.DisplayName);
}
return(new CategoryEventContainer
{
CategoryEvent = Mapper.Map <Contracts.Models.CategoryEvent>(ce),
EventType = eventObj.EventTypeId.ToString(),
EventCategory = eventObj.EventCategoryId.ToString(),
City = Mapper.Map <IEnumerable <City> >(cities),
State = Mapper.Map <IEnumerable <State> >(states),
Country = Mapper.Map <IEnumerable <Country> >(countries),
Event = Mapper.Map <Event>(eventObj),
EventDetail = Mapper.Map <IEnumerable <EventDetail> >(eventDetails),
Rating = Mapper.Map <IEnumerable <Rating> >(eventRatings),
CurrencyType = Mapper.Map <CurrencyType>(currencyMapping),
Venue = Mapper.Map <IEnumerable <Venue> >(venues),
EventTicketAttribute = Mapper.Map <IEnumerable <EventTicketAttribute> >(eventTicketAttributeMapping),
EventCategories = eventCatMappings
});
}
catch (Exception e)
{
return(new CategoryEventContainer
{
});
}
});
return(new FeelSearchQueryResult
{
FeelAdvanceSearchQueryResult = new FeelCategoryEventQueryResult
{
CategoryEvents = CategoryEventData.ToList()
}
});
}
public SearchVenueQueryResult Handle(SearchVenueQuery query)
{
List <FIL.Contracts.DataModels.SearchVenue> VenueResult = new List <Contracts.DataModels.SearchVenue>();
try
{
var citiesArray = query.CityName != null?query.CityName.Split(",") : null;
var eventCategoriesRepositoryData = _eventCategoryRepository.GetAll().Where(s => s.IsFeel == true);
var categories = query.Categories != null?query.Categories.Split(",") : null;
List <long> categoryList = new List <long>();
if (categories != null && categories.Count() > 0 && query.PlaceId == 0)
{
foreach (var item in categories)
{
try
{
var categoryInfo = eventCategoriesRepositoryData.FirstOrDefault(x => x.DisplayName == item).Id;
categoryList.Add(categoryInfo);
}
catch (Exception ex)
{
_logger.Log(Logging.Enums.LogCategory.Error, ex);
}
}
}
else if (categories != null && categories.Count() == 0 && query.PlaceId == 0)
{
var categoryInfo = eventCategoriesRepositoryData.FirstOrDefault(x => x.DisplayName == query.Categories).Id;
categoryList.Add(categoryInfo);
}
var cityLists = query.CityIds != null?_cityRepository.GetByCityIds(query.CityIds) : null;
var itineraryPlaces = query.PlaceId == 0 ? _eventRepository.GetAllItineraryPlaces(cityLists.Select(s => s.Id).ToList(), categoryList).GroupBy(x => x.Id, (key, group) => group.First()) :
_eventRepository.GetItinerarySearchPlaces(query.PlaceId).GroupBy(x => x.Id, (key, group) => group.First());
var placeWeekOpenDayList = _placeWeekOpenDaysRepository.GetByEventIds(itineraryPlaces.Select(s => (long)s.Id).Distinct().ToList());
var dayTimeMappingLists = _dayTimeMappingsRepository.GetAllByPlaceWeekOpenDays(placeWeekOpenDayList.Select(s => (long)s.Id).Distinct().ToList());
var placeHolidayDatesRepositoryLists = _placeHolidayDatesRepository.GetAllByEventIds(itineraryPlaces.Select(s => (long)s.Id).Distinct().ToList());
var placeVisitDurationRepositoryLists = _PlaceVisitDurationRepository.GetByEventIds(itineraryPlaces.Select(s => (long)s.Id).Distinct().ToList());
var eventDetails = _eventDetailRepository.GetByEventIds(itineraryPlaces.Select(s => (long)s.Id).Distinct().ToList()).Where(s => s.IsEnabled == true);
var eventTicketDetails = _eventTicketDetailRepository.GetByEventDetailIds(eventDetails.Select(s => (long)s.Id).Distinct().ToList()).Where(s => s.IsEnabled == true);
var eventTicketAttributes = _eventTicketAttributeRepository.GetByEventTicketDetailIds(eventTicketDetails.Select(s => (long)s.Id).Distinct().ToList()).Where(s => s.IsEnabled == true);
var ticketCategories = _ticketCategoryRepository.GetByTicketCategoryIds(eventTicketDetails.Select(s => (long)s.TicketCategoryId).Distinct().ToList());
var Days = _daysRepository.GetAll();
foreach (var currentPlace in itineraryPlaces)
{
var PlaceVisitDuration = placeVisitDurationRepositoryLists.FirstOrDefault(x => x.EventId == currentPlace.Id);
var placeWeekOpenDays = placeWeekOpenDayList.Where(x => x.EventId == currentPlace.Id);
var dayTimeMappings = dayTimeMappingLists.Where(s => placeWeekOpenDays.Any(p => p.Id == s.PlaceWeekOpenDayId));
SearchVenue searchVenue = new SearchVenue();
searchVenue.CategoryName = currentPlace.Category;
searchVenue.EventId = currentPlace.Id;
searchVenue.CityId = currentPlace.CityId;
searchVenue.EventSource = currentPlace.EventSource;
searchVenue.CityName = currentPlace.CityName;
searchVenue.CountryName = currentPlace.CountryName;
searchVenue.Currency = currentPlace.Currency;
searchVenue.EventName = currentPlace.Name;
searchVenue.EventAltId = currentPlace.AltId;
searchVenue.EventSlug = currentPlace.Slug;
searchVenue.Address = (currentPlace.AddressLineOne == null ? string.Empty : currentPlace.AddressLineOne) + "," + (currentPlace.AddressLineTwo == null ? string.Empty : currentPlace.AddressLineTwo);
searchVenue.Id = currentPlace.Id;
searchVenue.PlaceWeekOpenDays = placeWeekOpenDays.ToList();
searchVenue.DayTimeMappings = dayTimeMappings.ToList();
searchVenue.PlaceHolidaysList = placeHolidayDatesRepositoryLists.Where(x => x.EventId == currentPlace.Id).ToList();
searchVenue.EventDescription = currentPlace.EventDescription;
searchVenue.EventDetails = eventDetails.Where(x => x.EventId == currentPlace.Id).ToList();
searchVenue.EventTicketDetails = eventTicketDetails.Where(x => searchVenue.EventDetails.Any(s => s.Id == x.EventDetailId)).ToList();
searchVenue.EventTicketAttributes = eventTicketAttributes.Where(x => searchVenue.EventTicketDetails.Any(s => s.Id == x.EventTicketDetailId)).ToList();
searchVenue.ticketCategories = ticketCategories.Where(x => searchVenue.EventTicketDetails.Any(s => s.TicketCategoryId == x.Id)).ToList();
if (currentPlace.Latitude != null)
{
var latArr = currentPlace.Latitude.Split("E");
var longArr = currentPlace.Longitude.Split("E");
searchVenue.Latitude = latArr[0];
searchVenue.Longitude = longArr[0];
}
else
{
searchVenue.Latitude = null;
searchVenue.Longitude = null;
}
VenueResult.Add(searchVenue);
}
return(new SearchVenueQueryResult()
{
Venues = VenueResult.Distinct().ToList(), Days = Days.ToList()
});
}
catch (Exception e)
{
return(new SearchVenueQueryResult()
{
Venues = VenueResult.Distinct().ToList()
});
}
}
public RecommendationQueryResult Handle(RecommendationQuery query)
{
var sessionResponseIA = _initSession.GetSession().Result;
RecommendationModel model = new RecommendationModel
{
ClientType = "web_site",
Count = 4,
SessionId = sessionResponseIA.Result.SessionId,
SitePageType = "product_detail",
siteProductId = query.Id,
};
var recommendations = _getRecommendation.GetRecommendations(model).Result;
var recomendationResult = AutoMapper.Mapper.Map <List <RecommendationItem> >(recommendations.Result.Data[0].Items);
var recommendationIds = recomendationResult.Select(e => e.SiteProductId);
var siteEvents = _eventSiteIdMappingRepository.GetBySiteId(query.SiteId).OrderBy(o => o.SortOrder);
var categoryEvents = _eventRepository.GetByCategoryId(query.EventCategoryId).Where(e => e.IsEnabled == true);
var categoryEventsForSite = categoryEvents.Where(ce => recommendationIds.Any(se => se == (ce.Id)));
var eventIds = categoryEventsForSite.Select(ce => ce.Id);
var eventMapping = _eventRepository.GetByEventIds(eventIds).Where(e => e.IsEnabled == true).ToDictionary(e => e.Id);
var allEventDetails = _eventDetailRepository.GetByEventIds(eventIds).Where(ed => ed.IsEnabled == true);
var venueMapping = _venueRepository.GetByVenueIds(allEventDetails.Select(ed => ed.VenueId).Distinct())
.ToDictionary(v => v.Id);
var eventDetailsMapping = allEventDetails.GroupBy(ed => ed.EventId)
.ToDictionary(g => g.Key, g => g.ToList());
var cityIds = venueMapping.Values.Select(s => s.CityId).Distinct();
var cityMapping = _cityRepository.GetByCityIds(cityIds)
.ToDictionary(c => c.Id);
var stateId = cityMapping.Values.Select(c => c.StateId).Distinct();
var stateMapping = _stateRepository.GetByStateIds(stateId)
.ToDictionary(s => s.Id);
var countryIdList = stateMapping.Values.Select(s => s.CountryId).Distinct();
var countryMapping = _countryRepository.GetByCountryIds(countryIdList)
.ToDictionary(c => c.Id);
var CategoryEventData = categoryEventsForSite.Select(ce =>
{
var eventObj = eventMapping[ce.Id];
var eventDetails = eventDetailsMapping[ce.Id];
var eventDetailIdList = eventDetails.Select(s => s.Id).Distinct();
var venues = eventDetails.Select(s => s.VenueId).Distinct().Select(v => venueMapping[v]);
var cities = venues.Select(s => s.CityId).Distinct().Select(c => cityMapping[c]);
var states = cities.Select(s => s.StateId).Distinct().Select(s => stateMapping[s]);
var countries = states.Select(s => s.CountryId).Distinct().Select(c => countryMapping[c]);
var eventTicketAttributeMapping = new List <Contracts.DataModels.EventTicketAttribute>
{
_eventTicketAttributeRepository.GetMaxPriceByEventDetailId(eventDetailIdList),
_eventTicketAttributeRepository.GetMinPriceByEventDetailId(eventDetailIdList)
};
var currencyMapping = _currencyTypeRepository.GetByCurrencyId(eventTicketAttributeMapping.First().CurrencyId);
return(new CategoryEventContainer
{
CategoryEvent = Mapper.Map <Contracts.Models.CategoryEvent>(ce),
EventType = eventObj.EventTypeId.ToString(),
City = Mapper.Map <IEnumerable <City> >(cities),
State = Mapper.Map <IEnumerable <State> >(states),
Country = Mapper.Map <IEnumerable <Country> >(countries),
Event = Mapper.Map <Event>(eventObj),
EventDetail = Mapper.Map <IEnumerable <EventDetail> >(eventDetails),
CurrencyType = Mapper.Map <CurrencyType>(currencyMapping),
Venue = Mapper.Map <IEnumerable <Venue> >(venues),
EventTicketAttribute = Mapper.Map <IEnumerable <EventTicketAttribute> >(eventTicketAttributeMapping),
});
});
return(new RecommendationQueryResult
{
CategoryEvents = CategoryEventData.ToList()
});
}
public FeelCategoryEventQueryResult Handle(FeelCategoryEventQuery query)
{
try
{
query.SiteId = FIL.Contracts.Enums.Site.feelaplaceSite;
var countryDescription = new FIL.Contracts.DataModels.CountryDescription();
var cityDescription = new FIL.Contracts.DataModels.CityDescription();
var countryContents = new List <FIL.Contracts.DataModels.CountryContentMapping>();
var indexEventId = eventIdProvider(query);
var siteEvents = _eventSiteIdMappingRepository
.GetBySiteId(query.SiteId)
.OrderBy(o => o.SortOrder).ToList();
var categoryEvents = _eventRepository.GetByAllEventIds(indexEventId)
.Where(e => e.IsEnabled)
.ToList();
var eventMapping = categoryEvents.ToDictionary(e => e.Id);
var eventIds = eventMapping.Keys;
var eventCategoryMappings = _eventCategoryMappingRepository.GetByEventIds(eventIds).Where(ed => ed.IsEnabled == true);
var allEventDetails = _eventDetailRepository.GetByEventIds(eventIds).Where(ed => ed.IsEnabled == true);
var allEventAttributes = _eventAttributeRepository.GetByEventDetailIds(allEventDetails.Select(s => s.Id));
var allEventTicketDetails = _eventTicketDetailRepository.GetAllByEventDetailIds(allEventDetails.Select(s => s.Id));
var allEventTicketDetailTicketCategoryTypeMapping = _eventTicketDetailTicketCategoryTypeMappingRepository.GetByEventTicketDetails(allEventTicketDetails.Select(s => s.Id).ToList()).Where(s => s.TicketCategoryTypeId == 2);
allEventTicketDetails = allEventTicketDetails.Where(s => allEventTicketDetailTicketCategoryTypeMapping.All(p => p.EventTicketDetailId != s.Id));
var allLiveEventDetails = _liveEventDetailRepository.GetAllByEventIds(eventIds.ToList());
var allEventRatings = _ratingRepository.GetByEventIds(eventIds);
var venueMapping = _venueRepository.GetByVenueIds(allEventDetails.Select(ed => ed.VenueId).Distinct())
.ToDictionary(v => v.Id);
var eventDetailsMapping = allEventDetails.GroupBy(ed => ed.EventId)
.ToDictionary(g => g.Key, g => g.ToList());
var eventCategoryMapping = eventCategoryMappings.GroupBy(ed => ed.EventId)
.ToDictionary(g => g.Key, g => g.ToList());
var eventRatingMapping = allEventRatings.GroupBy(ed => ed.EventId)
.ToDictionary(g => g.Key, g => g.ToList());
var cityIds = venueMapping.Values.Select(s => s.CityId).Distinct();
var allCities = _cityRepository.GetByCityIds(cityIds);
var cityMapping = allCities.ToDictionary(c => c.Id);
var stateId = cityMapping.Values.Select(c => c.StateId).Distinct();
var stateMapping = _stateRepository.GetByStateIds(stateId)
.ToDictionary(s => s.Id);
var countryIdList = stateMapping.Values.Select(s => s.CountryId).Distinct();
var countryMapping = _countryRepository.GetByCountryIds(countryIdList)
.ToDictionary(c => c.Id);
if (query.IsCountryLandingPage)
{
if (countryIdList.ToList().Any())
{
countryDescription = _countryDescriptionRepository.GetByCountryId(countryIdList.ToList().ElementAt(0));
countryContents = _countryContentMappingRepository.GetByCountryId(countryIdList.ToList().ElementAt(0)).ToList();
}
}
if (query.IsCityLandingPage)
{
if (cityIds.ToList().Any())
{
var cities = _cityRepository.GetAllByName(allCities.ElementAt(0).Name);
foreach (var currentCity in allCities)
{
cityDescription = _cityDescriptionRepository.GetBycityId(currentCity.Id);
if (cityDescription != null)
{
break;
}
}
}
}
var eventsBySortOrder = new List <FIL.Contracts.DataModels.Event>();
foreach (var item in siteEvents)
{
var events = categoryEvents.FirstOrDefault(w => w.Id == item.EventId);
if (events != null)
{
eventsBySortOrder.Add(AutoMapper.Mapper.Map <FIL.Contracts.DataModels.Event>(events));
}
}
eventsBySortOrder = eventsBySortOrder.Where(s => !s.IsTokenize).ToList();
var CategoryEventData = eventsBySortOrder.Select(ce =>
{
try
{
var eventObj = eventMapping[ce.Id];
var EventCategory = eventObj.EventCategoryId.ToString();
var parentCategory = "";
var eventDetails = eventDetailsMapping[ce.Id];
var eventAttribute = allEventAttributes.Where(s => s.EventDetailId == eventDetails.FirstOrDefault().Id).FirstOrDefault();
var eventTicketDetails = allEventTicketDetails.Where(s => eventDetails.Exists(p => p.Id == s.EventDetailId));
var eventCategoryMap = eventCategoryMapping[ce.Id];
if (eventCategoryMap.Any())
{
var eventCategory = _eventCategoryRepository.Get(eventCategoryMap.FirstOrDefault().EventCategoryId);
if (eventCategory != null)
{
EventCategory = eventCategory.Slug;
var parentCategoryModel = _eventCategoryRepository.Get(eventCategory.EventCategoryId);
parentCategory = parentCategoryModel.Slug;
}
}
List <FIL.Contracts.DataModels.Rating> eventRatings;
if (eventRatingMapping.ContainsKey(ce.Id))
{
eventRatings = eventRatingMapping[ce.Id];
}
else
{
eventRatings = null;
}
var eventDetailIdList = eventDetails.Select(s => s.Id).Distinct().ToList();
var eventTicketDetailIdList = eventTicketDetails.Select(s => s.Id).Distinct().ToList();
var venues = eventDetails.Select(s => s.VenueId).Distinct().Select(v => venueMapping[v]);
var cities = venues.Select(s => s.CityId).Distinct().Select(c => cityMapping[c]);
var states = cities.Select(s => s.StateId).Distinct().Select(s => stateMapping[s]);
var countries = states.Select(s => s.CountryId).Distinct().Select(c => countryMapping[c]);
var eventTicketAttributeMapping = new List <Contracts.DataModels.EventTicketAttribute>
{
_eventTicketAttributeRepository.GetMaxPriceByEventTicketDetailId(eventTicketDetailIdList),
_eventTicketAttributeRepository.GetMinPriceByEventTicketDetailId(eventTicketDetailIdList)
};
var currencyMapping = _currencyTypeRepository.GetByCurrencyId(eventTicketAttributeMapping.Where(s => s.IsEnabled == true).ToList().First().CurrencyId);
List <string> eventCatMappings = new List <string>();
var eventCategoryDataModel = _eventCategoryRepository.GetByIds(eventCategoryMap.Select(s => s.EventCategoryId));
foreach (var eventCat in eventCategoryDataModel)
{
eventCatMappings.Add(eventCat.DisplayName);
}
var localDateTime = eventDetails.FirstOrDefault().StartDateTime.DayOfWeek + ", " + eventDetails.FirstOrDefault().StartDateTime.ToString(@"MMM dd, yyyy HH:mm", new CultureInfo("en-US")).ToUpper();
if (eventAttribute != null)
{
localDateTime = eventDetails.FirstOrDefault().StartDateTime.DayOfWeek + ", " + _localTimeZoneConvertProvider.ConvertToLocal(eventDetails.FirstOrDefault().StartDateTime, eventAttribute.TimeZone).ToString(@"MMM dd, yyyy HH:mm", new CultureInfo("en-US")).ToUpper();
}
return(new CategoryEventContainer
{
CategoryEvent = Mapper.Map <Contracts.Models.CategoryEvent>(ce),
EventType = eventObj.EventTypeId.ToString(),
EventCategory = EventCategory,
City = Mapper.Map <IEnumerable <City> >(cities),
State = Mapper.Map <IEnumerable <State> >(states),
Country = Mapper.Map <IEnumerable <Country> >(countries),
Event = Mapper.Map <Event>(eventObj),
EventDetail = Mapper.Map <IEnumerable <EventDetail> >(eventDetails),
Rating = Mapper.Map <IEnumerable <Rating> >(eventRatings),
CurrencyType = Mapper.Map <CurrencyType>(currencyMapping),
Venue = Mapper.Map <IEnumerable <Venue> >(venues),
EventTicketAttribute = Mapper.Map <IEnumerable <EventTicketAttribute> >(eventTicketAttributeMapping),
EventCategories = eventCatMappings,
LocalStartDateTime = localDateTime,
TimeZoneAbbrivation = eventAttribute != null ? eventAttribute.TimeZoneAbbreviation : "UTC",
EventFrequencyType = eventDetails.FirstOrDefault().EventFrequencyType,
ParentCategory = parentCategory,
LiveEventDetail = allLiveEventDetails.Where(s => s.EventId == ce.Id).FirstOrDefault()
});
}
catch (Exception e)
{
return(new CategoryEventContainer
{
});
}
});
return(new FeelCategoryEventQueryResult
{
CategoryEvents = CategoryEventData.ToList(),
CountryDescription = Mapper.Map <Contracts.Models.CountryDescription>(countryDescription),
CityDescription = cityDescription,
CountryContentMapping = Mapper.Map <List <CountryContentMapping> >(countryContents)
});
}
catch (Exception e)
{
return(new FeelCategoryEventQueryResult
{
});
}
}