public EventDetail SaveToEventDetails(Event @event, EventVenueMapping eventVenueMapping)
{
try
{
var eventDetail = _eventDetailRepository.GetSubeventByEventId(eventVenueMapping.EventId).FirstOrDefault();
if (eventDetail == null)
{
eventDetail = _eventDetailRepository.Save(new EventDetail
{
Name = @event.Name,
EventId = eventVenueMapping.EventId,
VenueId = eventVenueMapping.VenueId,
StartDateTime = DateTime.UtcNow,
EndDateTime = DateTime.UtcNow.AddYears(1),
GroupId = 1,
AltId = Guid.NewGuid(),
TicketLimit = 4,
ModifiedBy = eventVenueMapping.ModifiedBy,
IsEnabled = true,
MetaDetails = "",
HideEventDateTime = false,
CustomDateTimeMessage = "",
});
}
var eventDeliveryType = _eventDeliveryTypeDetailRepository.GetByEventDetailId(eventDetail.Id).FirstOrDefault();
if (eventDeliveryType == null)
{
_eventDeliveryTypeDetailRepository.Save(new EventDeliveryTypeDetail
{
EventDetailId = eventDetail.Id,
DeliveryTypeId = DeliveryTypes.MTicket,
Notes = "<table><tr><td valign=''top''>1. </td><td valign=''top''>Ticket pickup location and timing will be announced in the “Customer Update” sectionof our website closer to the event. Please check that regularly.</td></tr><tr><td valign=''top''>2. </td><td valign=''top''>The following documents are compulsory for ticket pickup:<br /><table><tr> <td valign=''top''> a. </td> <td colspan=''2'' valign=''top''> The card / bank account owner’s original Govt. issued photo ID, along with a clean, fully legible, photocopy of the same ID </td></tr><tr> <td valign=''top''> b. </td> <td colspan=''2'' valign=''top''> When a debit or credit card has been used for purchase, we also need the original debit/credit card, along with a clean, fully legible, photocopy of the same card </td></tr><tr> <td valign=''top''> c. </td> <td colspan=''2'' valign=''top''> If sending someone else on behalf of the card holder / bank account owner, then we need numbers 2.a. and 2.b above (originals and photocopies as mentioned) along with the following below. This is required even if the representative’s name has been entered into the system when buying: </td></tr><tr> <td valign=''top''> </td> <td valign=''top''> i. </td> <td> An authorization letter with the name of the representative, signed by the card holder/bank account owner </td></tr><tr> <td valign=''top''> </td> <td valign=''top''> ii. </td> <td> A Govt issued photo ID of the representative, along with a clean and legible photocopy of the same photo identification </td></tr></table></td></tr><tr><td valign=''top''>3. </td><td valign=''top''>Please note, absence of any one of the documents above can result in the ticketsbeing refused at the ticket pickup window</td></tr> </table>",
EndDate = DateTime.UtcNow.AddYears(2),
RefundPolicy = 1,
ModifiedBy = eventVenueMapping.ModifiedBy,
IsEnabled = true
});
}
return(eventDetail);
}
catch (Exception ex)
{
_logger.Log(LogCategory.Error, ex);
return(new EventDetail());
}
}
public EventDetail CreateEventDetail(string placeName, Guid guid, long placeId, int venueId, DateTime From, DateTime To, bool isCreateEventTicketDetail)
{
var existedEventDetail = _eventDetailRepository.GetSubeventByEventId((int)placeId).FirstOrDefault();
EventDetail placeDetails = new EventDetail();
placeDetails.Name = placeName;
placeDetails.AltId = guid;
placeDetails.EventId = placeId;
placeDetails.VenueId = venueId;
placeDetails.IsEnabled = true;
placeDetails.GroupId = 1;
placeDetails.StartDateTime = From;
placeDetails.EndDateTime = To;
placeDetails.CreatedUtc = DateTime.UtcNow;
placeDetails.CreatedBy = Guid.NewGuid();
var currentEventDetail = _eventDetailRepository.Save(placeDetails);
try
{
if (isCreateEventTicketDetail && existedEventDetail != null) // if new time
{
var eventTicketDetailData = _eventTicketDetail.GetByEventDetailId(existedEventDetail.Id);
foreach (FIL.Contracts.DataModels.EventTicketDetail current in eventTicketDetailData)
{
var eventTicketAttributes = _eventTicketAttribute.GetByEventTicketDetailsId(current.Id);
if (eventTicketAttributes != null)
{
var createdEventTicketDetail = CreateEventTicketDetails(currentEventDetail.Id, (int)current.TicketCategoryId);
CreateEventTicketAttributes(createdEventTicketDetail.Id, eventTicketAttributes.TicketCategoryNotes, eventTicketAttributes.CurrencyId,
eventTicketAttributes.AvailableTicketForSale, eventTicketAttributes.TicketCategoryDescription, (float)eventTicketAttributes.Price,
true, "", "", "", new DateTime());
}
}
}
}
catch (Exception e)
{
}
return(placeDetails);
}
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);
}