//FinancDetailsByIdQueryResults IQueryHandler<FinancDetailsByIdQuery, FinancDetailsByIdQueryResults>.Handle(FinancDetailsByIdQuery query)
public FinancDetailsByIdQueryResults Handle(FinancDetailsByIdQuery query)
{
FIL.Contracts.DataModels.FinanceDetail financeDetails = new FIL.Contracts.DataModels.FinanceDetail();
FIL.Contracts.DataModels.EventDetail eventDetail = new FIL.Contracts.DataModels.EventDetail();
FIL.Contracts.DataModels.Event eventRes = new FIL.Contracts.DataModels.Event();
FIL.Contracts.DataModels.Venue venueDetail = new FIL.Contracts.DataModels.Venue();
FIL.Contracts.DataModels.Venue venueDetailRes = new FIL.Contracts.DataModels.Venue();
FIL.Contracts.DataModels.City cityDetailRes = new Contracts.DataModels.City();
FIL.Contracts.DataModels.State stateDetailRes = new Contracts.DataModels.State();
FIL.Contracts.DataModels.Country countryDetailRes = new Contracts.DataModels.Country();
var eventResult = _eventRepository.GetByAltId(query.EventId);
var eventDetailRes = _eventDetailRepository.GetByEventId(eventResult.Id);
var financedetail = _financeDetailRepository.GetFinanceDetailsByEventId(eventResult.Id);
if (eventDetailRes != null)
{
venueDetailRes = _venueRepository.GetByVenueId((int)eventDetailRes.VenueId);
if (venueDetailRes != null)
{
cityDetailRes = _cityRepository.GetByCityId(venueDetailRes.CityId);
}
if (cityDetailRes != null)
{
stateDetailRes = _stateRepository.GetByStateId(cityDetailRes.StateId);
}
if (stateDetailRes != null)
{
countryDetailRes = _countryRepository.GetByCountryId(stateDetailRes.CountryId);
}
}
var resultdata = new FinancDetailsByIdQueryResults();
if (financedetail != null)
{
resultdata.FirstName = financedetail.FirstName;
resultdata.Id = financedetail.Id;
resultdata.LastName = financedetail.LastName;
resultdata.AccountNickName = financedetail.AccountNickName;
resultdata.BankName = financedetail.BankName;
resultdata.BankAccountType = financedetail.BankAccountType;
resultdata.BankName = financedetail.BankName;
resultdata.PANNo = financedetail.PANNo;
resultdata.RoutingNo = financedetail.RoutingNo;
resultdata.GSTNo = financedetail.GSTNo;
resultdata.AccountNo = financedetail.AccountNo;
resultdata.AccountNickName = financedetail.AccountNickName;
resultdata.CountryId = financedetail.CountryId;
resultdata.StateId = financedetail.StateId;
resultdata.CurrencyId = financedetail.CurrencyId;
resultdata.FinancialsAccountBankAccountGSTInfo = financedetail.FinancialsAccountBankAccountGSTInfo;
}
resultdata.EventId = eventResult.Id;
if (venueDetailRes != null)
{
resultdata.location = venueDetailRes.Name;
resultdata.address1 = venueDetailRes.AddressLineOne;
resultdata.address2 = venueDetailRes.AddressLineOne;
}
if (eventDetailRes != null)
{
resultdata.EventDetailId = (int)(eventDetailRes.Id);
}
if (stateDetailRes != null)
{
resultdata.state = stateDetailRes.Name;
}
if (cityDetailRes != null)
{
resultdata.city = cityDetailRes.Name;
}
if (countryDetailRes != null)
{
resultdata.country = countryDetailRes.Name;
}
return(resultdata);
}
public SavedEventQueryResult Handle(SavedEventQuery query)
{
var eventDataModel = _eventRepository.GetByAltId(query.Id);
var eventModel = AutoMapper.Mapper.Map <Contracts.Models.Event>(eventDataModel);
var placeVisitDuration = _placeVisitDurationRepository.GetBySingleEventId(eventModel.Id);
var galleryImageResponse = _eventGalleryImageRepository.GetByEventId(eventModel.Id);
var galleryImageModel = AutoMapper.Mapper.Map <IEnumerable <EventGalleryImage> >(galleryImageResponse);
var eventcatmapresponse = _eventCategoryMappingRepository.GetByEventId(eventModel.Id);
var eventcatmap = AutoMapper.Mapper.Map <IEnumerable <EventCategoryMapping> >(eventcatmapresponse);
var eventsiteidresponse = _eventSiteIdMappingRepository.GetByEventId(eventModel.Id);
var eventsitemap = AutoMapper.Mapper.Map <EventSiteIdMapping>(eventsiteidresponse);
var eventlearnmoreresponse = _eventLearnMoreAttributeRepository.GetByEventId(eventModel.Id);
var eventlearnmore = AutoMapper.Mapper.Map <IEnumerable <EventLearnMoreAttribute> >(eventlearnmoreresponse);
var eventamenityresponse = _eventAmenityRepository.GetByEventId(eventModel.Id);
var eventamenity = AutoMapper.Mapper.Map <IEnumerable <EventAmenity> >(eventamenityresponse);
var eventdetailresponse = _eventDetailRepository.GetSubeventByEventId(eventModel.Id).FirstOrDefault();
var eventdetail = AutoMapper.Mapper.Map <EventDetail>(eventdetailresponse);
var eventTags = _eventTagMappingRepository.GetByEventId(eventModel.Id);
Country countrydetail = new Country();
City citydetail = new City();
State statedetail = new State();
Zipcode zipcodeDetail = new Zipcode();
Venue venuedetail = new Venue();
if (eventdetail != null)
{
var venuedetailresponse = _venueRepository.GetByVenueId(eventdetail.VenueId);
venuedetail = AutoMapper.Mapper.Map <Venue>(venuedetailresponse);
if (venuedetail != null)
{
var citydetailresponse = _cityRepository.GetByCityId(venuedetail.CityId);
citydetail = AutoMapper.Mapper.Map <City>(citydetailresponse);
var Zip = _zipcodeRepository.GetAllByCityId(citydetail.Id).FirstOrDefault();
zipcodeDetail = AutoMapper.Mapper.Map <Zipcode>(Zip);
}
if (citydetail != null)
{
var statedetailresponse = _stateRepository.GetByStateId(citydetail.StateId);
statedetail = AutoMapper.Mapper.Map <State>(statedetailresponse);
}
if (statedetail != null)
{
var countrydetailresponse = _countryRepository.GetByCountryId(statedetail.CountryId);
countrydetail = AutoMapper.Mapper.Map <Country>(countrydetailresponse);
}
}
var features = Enum.GetValues(typeof(LearnMoreFeatures));
var resultdata = new SavedEventQueryResult();
resultdata.Country = countrydetail.Name;
resultdata.City = citydetail.Name;
resultdata.Address1 = venuedetail.AddressLineOne;
resultdata.Address2 = venuedetail.AddressLineTwo;
resultdata.State = statedetail.Name;
resultdata.Lat = ((venuedetail.Latitude != null && venuedetail.Latitude != "" && venuedetail.Latitude != "NaN") ? venuedetail.Latitude : "18.5204");
resultdata.Long = ((venuedetail.Longitude != null && venuedetail.Longitude != "" && venuedetail.Latitude != "NaN") ? venuedetail.Longitude : "73.8567");
List <string> amenityids = new List <string>();
if (zipcodeDetail != null)
{
if (zipcodeDetail.Id != 0)
{
resultdata.Zip = zipcodeDetail.Postalcode;
}
}
foreach (var ea in eventamenity)
{
amenityids.Add((ea.AmenityId).ToString());
}
if (placeVisitDuration != null)
{
var data = placeVisitDuration.TimeDuration.Split("-");
if (data.Length >= 2)
{
resultdata.HourTimeDuration = placeVisitDuration.TimeDuration;
resultdata.MinuteTimeDuration = "";
}
}
resultdata.AmenityId = string.Join(",", amenityids);
//resultdata.AmenityId = string.Join(",", amenityids);
var archdesc = eventlearnmore.FirstOrDefault(p => p.LearnMoreFeatureId == LearnMoreFeatures.ArchitecturalDetail);
if (archdesc != null)
{
resultdata.Archdetail = archdesc.Description;
resultdata.ArchdetailId = archdesc.Id;
}
var highlightdesc = eventlearnmore.FirstOrDefault(p => p.LearnMoreFeatureId == LearnMoreFeatures.HighlightNugget);
if (highlightdesc != null)
{
resultdata.Highlights = highlightdesc.Description;
resultdata.HighlightsId = highlightdesc.Id;
}
var historydesc = eventlearnmore.FirstOrDefault(p => p.LearnMoreFeatureId == LearnMoreFeatures.History);
if (historydesc != null)
{
resultdata.History = historydesc.Description;
resultdata.HistoryId = historydesc.Id;
}
var immersdesc = eventlearnmore.FirstOrDefault(p => p.LearnMoreFeatureId == LearnMoreFeatures.ImmersiveExperience);
if (immersdesc != null)
{
resultdata.Immersiveexperience = immersdesc.Description;
resultdata.ImmersiveexperienceId = immersdesc.Id;
}
var tilesImages = "";
var galleryImages = galleryImageModel.Where(p => p.Name.Contains("gallery"));
var tilesSliderImages = galleryImageModel.Where(p => p.Name.Contains("Tiles"));
var descPageImages = galleryImageModel.Where(p => p.Name.Contains("DescBanner"));
var inventoryPageImages = galleryImageModel.Where(p => p.Name.Contains("InventoryBanner"));
var placeMapImages = galleryImageModel.Where(p => p.Name.Contains("placemapImages"));
var timelineImages = galleryImageModel.Where(p => p.Name.Contains("timelineImages"));
var immersiveImages = galleryImageModel.Where(p => p.Name.Contains("immersiveImages"));
var architecturalImages = galleryImageModel.Where(p => p.Name.Contains("archdetailImages"));
var galleryImagesList = "";
var tilesSliderImagesList = "";
var descPageList = "";
var inventoryPageList = "";
var plaeMapImagesList = "";
var timelineImagesList = "";
var immerseImagesList = "";
var archImagesList = "";
foreach (EventGalleryImage eventGalleryImage in galleryImages)
{
galleryImagesList += eventGalleryImage.Name + ",";
}
foreach (EventGalleryImage eventGalleryImage in tilesSliderImages)
{
tilesSliderImagesList += eventGalleryImage.Name + ",";
}
foreach (EventGalleryImage eventGalleryImage in descPageImages)
{
descPageList += eventGalleryImage.Name + ",";
}
foreach (EventGalleryImage eventGalleryImage in inventoryPageImages)
{
inventoryPageList += eventGalleryImage.Name + ",";
}
foreach (EventGalleryImage eventGalleryImage in placeMapImages)
{
plaeMapImagesList += eventGalleryImage.Name + ",";
}
foreach (EventGalleryImage eventGalleryImage in timelineImages)
{
timelineImagesList += eventGalleryImage.Name + ",";
}
foreach (EventGalleryImage eventGalleryImage in immersiveImages)
{
immerseImagesList += eventGalleryImage.Name + ",";
}
foreach (EventGalleryImage eventGalleryImage in galleryImages)
{
archImagesList += eventGalleryImage.Name + ",";
}
resultdata.GalleryImages = galleryImagesList;
resultdata.TilesSliderImages = tilesSliderImagesList;
resultdata.DescpagebannerImage = descPageList;
resultdata.InventorypagebannerImage = inventoryPageList;
resultdata.PlacemapImages = plaeMapImagesList;
resultdata.TimelineImages = timelineImagesList;
resultdata.ImmersiveexpImages = immerseImagesList;
resultdata.ArchdetailImages = archImagesList;
resultdata.Description = eventModel.Description;
resultdata.Id = eventModel.Id;
resultdata.AltId = eventModel.AltId;
resultdata.Location = eventModel.Name;
List <int> subcatids = new List <int>();
List <int> tags = new List <int>();
int categoryId = eventModel.EventCategoryId;
foreach (var cat in eventcatmap)
{
categoryId = cat.EventCategoryId;
subcatids.Add(cat.EventCategoryId);
}
foreach (var tag in eventTags)
{
tags.Add((int)tag.TagId);
}
var category = _eventCategoryRepository.Get(categoryId);
resultdata.Subcategoryid = string.Join(",", subcatids);
resultdata.TagIds = string.Join(",", tags);
resultdata.Categoryid = category.EventCategoryId;
//resultdata.Subcategoryid = subcatids.FirstOrDefault();
/*var categorymapobj = eventcatmap.FirstOrDefault();
* if (categorymapobj != null)
* {
* resultdata.Categoryid = eventModel.EventCategoryId;
* }*/
resultdata.Metadescription = eventModel.MetaDetails;
if (resultdata.Metadescription != null)
{
string[] metas = resultdata.Metadescription.Split(new string[] { "<br/>" }, StringSplitOptions.None);
if (metas.Length == 3)
{
resultdata.Metatitle = metas[0].Split("title")[1].Replace(">", "").Replace("</", "");
resultdata.Metadescription = metas[1].Split("content=")[1].Replace(">", "").Replace("\"", "").Replace("</", "");
resultdata.Metatags = metas[2].Split("content=")[1].Replace(">", "").Replace("\"", "").Replace("</", "");
}
}
resultdata.PlaceName = venuedetail.Name;
//resultdata.Subcategoryid = eventcatmap.Select(p => p.EventCategoryId).FirstOrDefault();
//resultdata.Subcategoryid = string.Join(",", eventcatmap.Count() > 0 ? eventcatmap.Select(p => p.EventCategoryId).ToList() : new List<int>());
resultdata.Title = eventModel.Name;
var eventHostMappings = _eventHostMappingRepository.GetAllByEventId(eventModel.Id);
resultdata.EventHostMappings = eventHostMappings.ToList();
return(resultdata);
}
