protected override async Task <ICommandResult> Handle(ReserveTimeSlotCommand command)
{
ReserveTimeSlotCommandResult results = new ReserveTimeSlotCommandResult();
ReserveTimeSlotReqestModel reserveTimelotRequestModel = new ReserveTimeSlotReqestModel();
IEnumerable <long> eventTicketAttributeIds = command.EventTicketAttributeList.Select(s => s.Id).Distinct();
IEnumerable <Contracts.Models.EventTicketAttribute> eventTicketAttributes = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.EventTicketAttribute> >(_eventTicketAttributeRepository.GetByIds(eventTicketAttributeIds));
var allETD = _eventTicketDetailRepository.GetByEventTicketDetailsIds(eventTicketAttributes.Select(s => s.EventTicketDetailId).Distinct()).Distinct();
var allTC = _ticketCategoryRepository.GetByTicketCategoryIds(allETD.Select(s => s.TicketCategoryId).Distinct()).Distinct();
var allED = _eventDetailRepository.GetByIds(allETD.Select(s => s.EventDetailId).Distinct()).Distinct().FirstOrDefault();
var citySightEventDetails = _citySightSeeingEventDetailMappingRepository.GetByEventDetailId(allED.Id);
var citySightSeeingTickets = _citySightSeeingTicketRepository.Get(citySightEventDetails.CitySightSeeingTicketId);
var citySightSeeingTicketDetails = _citySightSeeingTicketDetailRepository.GetByTicketId(citySightSeeingTickets.TicketId);
var citySightSeeingLocations = _citySightSeeingLocationRepository.Get(citySightSeeingTickets.CitySightSeeingLocationId);
var locationDetail = await _googleMapApi.GetLatLongFromAddress(citySightSeeingLocations.Name);
string tz = ""; DateTime fromDate = DateTime.Now;; var offset = "";
if (locationDetail.Success)
{
double lat = Convert.ToDouble(locationDetail.Result.lat);
double lng = Convert.ToDouble(locationDetail.Result.lng);
tz = TimeZoneLookup.GetTimeZone(lat, lng).Result;
TimeZoneInfo tzi = TZConvert.GetTimeZoneInfo(tz);
var visitDate = command.EventTicketAttributeList[0].VisitDate;
var timeSlot = command.EventTicketAttributeList[0].TimeSlot;
var utcOffset = tzi.BaseUtcOffset.ToString().Split(":")[0];
var minutes = Convert.ToInt64(tzi.BaseUtcOffset.ToString().Split(":")[1]);
if (utcOffset.Contains("-"))
{
var hours = Convert.ToInt64((tzi.BaseUtcOffset.ToString().Split(":")[0]).Split("-")[1]);
visitDate = visitDate.AddHours(hours).AddMinutes(minutes);
offset = utcOffset;
}
else
{
var hours = Convert.ToInt64((tzi.BaseUtcOffset.ToString().Split(":")[0]));
visitDate = visitDate.AddHours(-hours).AddMinutes(-minutes);
offset = "+" + utcOffset;
}
var formattedDateTime = visitDate.Year + "-" + visitDate.Month + "-" + visitDate.Day + "T" + timeSlot;
fromDate = Convert.ToDateTime(formattedDateTime);
}
var duration = citySightSeeingTicketDetails.Duration;
reserveTimelotRequestModel.request_type = "reserve";
TimeSlotData timeSlotData = new TimeSlotData();
timeSlotData.distributor_id = _settings.GetConfigSetting <string>(SettingKeys.Integration.CitySightSeeing.DistributorId);
timeSlotData.ticket_id = citySightSeeingTickets.TicketId;
timeSlotData.pickup_point_id = (citySightSeeingTicketDetails.PickupPoints != null && citySightSeeingTicketDetails.PickupPoints != "") ? citySightSeeingTicketDetails.PickupPoints : "";
DateTime endDate = DateTime.Now;
List <BookingTimeSlotDetail> bookingTimeSlotDetailList = new List <BookingTimeSlotDetail>();
foreach (Contracts.Commands.Transaction.EventTicketAttribute ticketAttributes in command.EventTicketAttributeList)
{
BookingTimeSlotDetail bookingTimeSlotDetail = new BookingTimeSlotDetail();
var currentTA = ticketAttributes;
Contracts.Models.EventTicketAttribute checkoutCommandEventTicketAttribute = eventTicketAttributes.Where(w => w.Id == ticketAttributes.Id).FirstOrDefault();
EventTicketDetail eventTicketDetail = allETD.Where(s => s.Id == checkoutCommandEventTicketAttribute.EventTicketDetailId).FirstOrDefault();
var ticketCategoryId = allTC.Where(s => s.Id == eventTicketDetail.TicketCategoryId).FirstOrDefault();
bookingTimeSlotDetail.count = ticketAttributes.TotalTickets;
var formattedTicketCat = ticketCategoryId.Name.Split("(");
bookingTimeSlotDetail.ticket_type = formattedTicketCat[0].ToUpper();
bookingTimeSlotDetail.extra_options = null;
bookingTimeSlotDetailList.Add(bookingTimeSlotDetail);
}
if (duration.Contains("day"))
{
string[] day = duration.Split("day");
endDate = fromDate.AddDays(Convert.ToDouble(day[0]));
}
if (duration.Contains("hour"))
{
string[] hour = duration.Split("hour");
endDate = fromDate.AddHours(Convert.ToDouble(hour[0]));
}
var fromDate_with_time_slot = Convert.ToDateTime(fromDate.ToString() + offset);
var endDate_with_time_slot = Convert.ToDateTime(endDate.ToString() + offset);
timeSlotData.from_date_time = fromDate_with_time_slot;
timeSlotData.to_date_time = endDate_with_time_slot;
timeSlotData.booking_details = bookingTimeSlotDetailList;
reserveTimelotRequestModel.data = timeSlotData;
reserveTimelotRequestModel.data.distributor_reference = RandomDigits(10);
var response = Mapper <TimeSlotResponseModel> .MapFromJson(await ReserveBooking(reserveTimelotRequestModel));
if (response != null && response.data.booking_status == "Reserved")
{
results.Success = true;
results.FromTime = fromDate.ToString() + offset;
results.EndTime = endDate.ToString() + offset;
results.Reservation_reference = response.data.reservation_reference;
results.Reservation_valid_until = response.data.reservation_valid_until;
results.Distributor_reference = response.data.distributor_reference;
results.TicketId = citySightSeeingTicketDetails.TicketId;
results.TimeSlot = command.EventTicketAttributeList[0].TimeSlot;
}
else
{
results.Success = false;
}
return(results);
}
public TicketCategoryQueryResult Handle(TicketCategoryQuery query)
{
try
{
var eventDataModel = _eventRepository.GetByAltId(query.EventAltId);
var eventModel = AutoMapper.Mapper.Map <Contracts.Models.Event>(eventDataModel);
if (eventModel != null)
{
var ASIMonumentMapping = _aSIMonumentEventTableMappingRepository.GetByEventId(eventModel.Id);
var ASIMonument = new Contracts.Models.ASI.Item();
if (ASIMonumentMapping != null)
{
ASIMonument = Mapper.Map <Contracts.Models.ASI.Item>(_aSIMonumentRepository.Get(ASIMonumentMapping.ASIMonumentId));
}
var eventCategoryMappings = _eventCategoryMappingRepository.GetByEventId(eventModel.Id).FirstOrDefault();
var eventDetailModelDataModel = _eventDetailRepository.GetSubEventByEventId(eventModel.Id);
var eventDetailModel = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.EventDetail> >(eventDetailModelDataModel);
List <FIL.Contracts.Models.ASI.EventTimeSlotMapping> eventTimeSlotMappings = new List <Contracts.Models.ASI.EventTimeSlotMapping>();
List <EventVenueMappingTime> eventVenueMappingTimeModel = new List <EventVenueMappingTime>();
FIL.Contracts.Models.EventCategory subCategory = new FIL.Contracts.Models.EventCategory();
FIL.Contracts.Models.EventCategory category = new FIL.Contracts.Models.EventCategory();
try
{
var eventTimeSlot = _eventTimeSlotMappingRepository.GetByEventId(eventModel.Id);
eventTimeSlotMappings = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.ASI.EventTimeSlotMapping> >(eventTimeSlot).ToList();
}
catch (Exception e)
{
}
if (eventCategoryMappings != null)
{
var subCategoryDataModel = _eventCategoryRepository.Get(eventCategoryMappings.EventCategoryId);
if (subCategory != null)
{
subCategory = AutoMapper.Mapper.Map <Contracts.Models.EventCategory>(subCategoryDataModel);
var categoryDataModel = _eventCategoryRepository.Get(subCategory.EventCategoryId);
category = AutoMapper.Mapper.Map <Contracts.Models.EventCategory>(categoryDataModel);
}
}
var ticketCategoryType = _ticketCategoryTypesRepository.GetAll();
var ticketCategorySubType = _ticketCategorySubTypesRepository.GetAll();
var placeHolidyDatesDataModel = _placeHolidayDatesRepository.GetAllByEventId(eventDataModel.Id);
var placeHolidyDatesModel = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.PlaceHolidayDate> >(placeHolidyDatesDataModel);
var placeWeekOffDataModel = _placeWeekOffRepository.GetAllByEventId(eventDataModel.Id);
var placeWeekOffModel = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.PlaceWeekOff> >(placeWeekOffDataModel);
var placeDocumentDataModel = _placeCustomerDocumentTypeMappingRepository.GetAllByEventId(eventDataModel.Id);
var placeDocumentModel = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.PlaceCustomerDocumentTypeMapping> >(placeDocumentDataModel);
var placeOpenDays = _placeWeekOpenDaysRepository.GetByEventId(eventDataModel.Id);
var placeOpenDaysModel = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.PlaceWeekOpenDays> >(placeOpenDays);
var CustomerDocumentTypeDataModel = _customerDocumentTypeRepository.GetAll();
var CustomerDocumentTypeModel = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.CustomerDocumentType> >(CustomerDocumentTypeDataModel);
if (eventDetailModelDataModel != null && eventDetailModelDataModel.Any())
{
var eventDeliveryTypeDetailDataModel = _eventDeliveryTypeDetail.GetByEventDetailId(eventDetailModelDataModel.ElementAt(0).Id);
var eventDeliveryTypeDetailModel = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.EventDeliveryTypeDetail> >(eventDeliveryTypeDetailDataModel);
var RASVTicketTypeMappingsDataModel = _rasvTicketTypeMappingRepository.GetByEventDetailIds(eventDetailModelDataModel.Select(ed => ed.Id)).Where(sed => sed.IsEnabled == true);
var RASVTicketTypeMappingsModel = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.RASVTicketTypeMapping> >(RASVTicketTypeMappingsDataModel);
var venueDetailDataModel = _venueRepository.GetByVenueIds(eventDetailModel.Select(s => s.VenueId));
var venueDetailModel = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.Venue> >(venueDetailDataModel);
//Multiple Venue option for MOVE AROUND category.
var eventVenueMappingDataModel = _eventVenueMappingRepository.GetOneByEventId(eventModel.Id);
var eventVenueMappingModel = Mapper.Map <EventVenueMapping>(eventVenueMappingDataModel);
if (eventVenueMappingModel != null)
{
var eventVenueMappingTimeDataModel = _eventVenueMappingTimeRepository.GetAllByEventVenueMappingId(eventVenueMappingModel.Id);
eventVenueMappingTimeModel = Mapper.Map <IEnumerable <EventVenueMappingTime> >(eventVenueMappingTimeDataModel).ToList();
}
var CityList = venueDetailDataModel.Select(s => s.CityId);
var cityDetailDataModel = _cityRepository.GetByCityIds(CityList);
var cityModel = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.City> >(cityDetailDataModel);
var eventTicketDetailList = eventDetailModelDataModel.Select(s => s.Id);
var eventTicketDetailDataModel = _eventTicketDetailRepository.GetByEventDetailIds(eventTicketDetailList);
var eventTicketDetailModel = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.EventTicketDetail> >(eventTicketDetailDataModel);
// For Getting Pone venue Images
var pOneImageEventDetailMapping = new List <Contracts.Models.POne.POneImageEventDetailMapping>();
if (eventModel.EventSourceId == EventSource.POne)
{
var pOneEventDetailMappings = _pOneEventDetailMappingRepository.GetByEventDetailIds(eventTicketDetailModel.Select(s => s.EventDetailId).Distinct().ToList());
var allTicketCategories = _ticketCategoryRepository.GetByTicketCategoryIds(eventTicketDetailModel.Select(s => s.TicketCategoryId).Distinct().ToList());
var allPoneETD = _pOneEventTicketDetailRepository.GetByManyPOneEventDetail(pOneEventDetailMappings.Select(s => s.POneEventDetailId).Distinct().ToList());
foreach (var item in eventTicketDetailModel)
{
var pOneEventDetailMappingData = pOneEventDetailMappings.Where(s => s.ZoongaEventDetailId == item.EventDetailId).FirstOrDefault();
var tc = allTicketCategories.Where(s => s.Id == item.TicketCategoryId).FirstOrDefault();
var p1tc = _pOneTicketCategoryRepository.GetByName(tc.Name);
if (pOneEventDetailMappingData != null && p1tc != null)
{
var p1etd = allPoneETD.Where(s => (s.POneEventDetailId == pOneEventDetailMappingData.POneEventDetailId && s.POneTicketCategoryId == p1tc.POneId)).FirstOrDefault();
if (p1etd != null)
{
pOneImageEventDetailMapping.Add(new Contracts.Models.POne.POneImageEventDetailMapping
{
EventTicketDetailId = item.Id,
ImageUrl = p1etd.ImageUrl
});
}
}
}
}
var eventTicketDetailTicketCategoryMappings = _eventTicketDetailTicketCategoryTypeMappingRepository.GetByEventTicketDetails(eventTicketDetailModel.Select(s => s.Id).ToList());
var eventTicketDetailTicketCategoryMappingsModel = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.EventTicketDetailTicketCategoryTypeMapping> >(eventTicketDetailTicketCategoryMappings).ToList();
var matchAttribute = _matchAttributeRepository.GetByEventDetailIds(eventDetailModelDataModel.Select(ed => ed.Id).Distinct());
var team = _teamRepository.GetAll();
var data = _calendarProvider.GetCalendarData(eventModel.Id);
if (eventTicketDetailModel != null)
{
var ticketCategoryIdList = eventTicketDetailModel.Select(s => s.TicketCategoryId);
var ticketCategoryDataModel = _ticketCategoryRepository.GetByEventDetailIds(ticketCategoryIdList);
var ticketCategoryModel = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.TicketCategory> >(ticketCategoryDataModel);
var eventTicketDetailIdList = eventTicketDetailModel.Select(s => s.Id);
var eventTicketDetailIdDataModel = _eventTicketAttributeRepository.GetByEventTicketDetailId(eventTicketDetailIdList);
var eventTicketAttributeModel = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.EventTicketAttribute> >(eventTicketDetailIdDataModel);
var eventTicketAttributeIdList = eventTicketAttributeModel.Select(s => s.Id);
var ticketFeeDetailIdDataModel = _ticketFeeDetail.GetByEventTicketAttributeIds(eventTicketAttributeIdList);
var ticketFeeDetailModel = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.TicketFeeDetail> >(ticketFeeDetailIdDataModel);
var currencyList = eventTicketAttributeModel.Select(s => s.CurrencyId).Distinct().FirstOrDefault();
var currencyModel = AutoMapper.Mapper.Map <Contracts.Models.CurrencyType>(_currencyTypeRepository.Get(currencyList));
var days = _daysRepository.GetAll();
var daysModel = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.Days> >(days);
var CountryRegionalOrganisation = _countryRegionalOrganisationMappingRepository.GetAll();
var eventAttribute = _eventAttributeRepository.GetByEventDetailIds(eventDetailModel.Select(s => (long)s.Id).ToList());
var Country = _countryRepository.GetAll();
var Countrymodel = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.Country> >(Country);
List <string> reginalOrganisation = new List <string>();
reginalOrganisation.AddRange(Enum.GetNames(typeof(FIL.Contracts.Enums.RegionalOrganisation)));
// For Tiqet's gettting Checkout Details
TiqetProductCheckoutDetail
tiqetCheckoutDetailsModel = new TiqetProductCheckoutDetail();
List <ValidWithVariantModel> validWithVariantList = new List <ValidWithVariantModel>();
if (eventModel.EventSourceId == EventSource.Tiqets)
{
var tiqetEventDetailMapping = _tiqetEventDetailMappingRepository.GetByEventDetailId(eventDetailModel.ElementAt(0).Id);
var tiqetCheckoutDetails = _tiqetProductCheckoutDetailRepository.GetByProductId(tiqetEventDetailMapping.ProductId);
tiqetCheckoutDetailsModel = Mapper.Map <TiqetProductCheckoutDetail>(tiqetCheckoutDetails);
// for checking valid with tiqetVariant details
var tiqetVariantDetails = _tiqetVariantDetailRepository.GetAllByProductId(tiqetCheckoutDetailsModel.ProductId);
List <long> eventTicketDetailIds = new List <long>();
foreach (var currentVariantDetail in tiqetVariantDetails)
{
if (currentVariantDetail.ValidWithVariantIds != null && currentVariantDetail.ValidWithVariantIds != "")
{
ValidWithVariantModel validWithVariantModel = new ValidWithVariantModel();
var validWithVariantIds = currentVariantDetail.ValidWithVariantIds.Split(",");
foreach (var currentValidvariantId in validWithVariantIds)
{
var currentValidVariantDetail = tiqetVariantDetails.Where(s => s.VariantId == Convert.ToInt64(currentValidvariantId)).FirstOrDefault();
if (currentValidVariantDetail != null)
{
var eventTicketDetailMapping = _tiqetEventTicketDetailMappingRepository.GetByTiqetVariantId(currentValidVariantDetail.Id);
eventTicketDetailIds.Add(eventTicketDetailMapping.EventTicketDetailId);
}
}
var currentEventTicketDetailMapping = _tiqetEventTicketDetailMappingRepository.GetByTiqetVariantId(currentVariantDetail.Id);
validWithVariantModel.EventTicketDetailId = currentEventTicketDetailMapping.EventTicketDetailId;
validWithVariantModel.ValidWithEventTicketDetailId = eventTicketDetailIds;
validWithVariantList.Add(validWithVariantModel);
}
}
}
// Check for Hoho Places if any
FIL.Contracts.DataModels.CitySightSeeingTicketDetail citySightSeeingTicketDetail = new FIL.Contracts.DataModels.CitySightSeeingTicketDetail();
var citySightSeeingEventDetailMapping = _citySightSeeingEventDetailMappingRepository.GetByEventDetailId(eventDetailModel.ElementAt(0).Id);
if (citySightSeeingEventDetailMapping != null)
{
var citySightSeeingTickets = _citySightSeeingTicketRepository.Get(citySightSeeingEventDetailMapping.CitySightSeeingTicketId);
citySightSeeingTicketDetail = _citySightSeeingTicketDetailRepository.GetByTicketId(citySightSeeingTickets.TicketId);
}
//Get Host Details for FIL Online Events
var eventHostMappingList = new List <FIL.Contracts.DataModels.EventHostMapping>();
var formattedDateString = "";
if (eventDataModel.MasterEventTypeId == MasterEventType.Online)
{
eventHostMappingList = _eventHostMappingRepository.GetAllByEventId(eventDataModel.Id).ToList();
var formattedDateTime = _localTimeZoneConvertProvider.ConvertToLocal(eventDetailModel.FirstOrDefault().StartDateTime, eventAttribute.FirstOrDefault().TimeZone);
formattedDateString = formattedDateTime.DayOfWeek + ", " + formattedDateTime.ToString(@"MMM dd, yyyy, hh:mm tt", new CultureInfo("en-US"));
}
//Get Recurrance Schedule
List <FIL.Contracts.Models.CreateEventV1.EventRecurranceScheduleModel> recurranceScheduleModels = new List <Contracts.Models.CreateEventV1.EventRecurranceScheduleModel>();
if (eventDetailModel.FirstOrDefault().EventFrequencyType == EventFrequencyType.Recurring)
{
recurranceScheduleModels = _getScheduleDetailProvider.GetScheduleDetails(eventDataModel.Id, DateTime.UtcNow, DateTime.UtcNow, false, true).Where(s => s.EndDateTime > DateTime.UtcNow).ToList();
}
try
{
return(new TicketCategoryQueryResult
{
Event = eventModel,
EventDetail = eventDetailModel,
EventTicketAttribute = eventTicketAttributeModel,
TicketFeeDetail = ticketFeeDetailModel,
Venue = venueDetailModel,
City = cityModel,
EventTicketDetail = eventTicketDetailModel,
TicketCategory = ticketCategoryModel,
CurrencyType = currencyModel,
RASVTicketTypeMappings = RASVTicketTypeMappingsModel,
EventDeliveryTypeDetails = eventDeliveryTypeDetailModel,
EventCategory = eventModel.EventCategoryId,
MatchAttribute = Mapper.Map <IEnumerable <MatchAttribute> >(matchAttribute),
Team = Mapper.Map <IEnumerable <Team> >(team),
PlaceCustomerDocumentTypeMappings = placeDocumentModel,
PlaceHolidayDates = placeHolidyDatesModel,
PlaceWeekOffs = placeWeekOffModel,
CustomerDocumentTypes = CustomerDocumentTypeModel,
TicketCategorySubTypes = ticketCategorySubType.ToList(),
TicketCategoryTypes = ticketCategoryType.ToList(),
EventTicketDetailTicketCategoryTypeMappings = eventTicketDetailTicketCategoryMappingsModel,
EventCategoryMappings = eventCategoryMappings,
RegularTimeModel = data.RegularTimeModel,
SeasonTimeModel = data.SeasonTimeModel,
SpecialDayModel = data.SpecialDayModel,
EventVenueMappings = eventVenueMappingModel,
EventVenueMappingTimes = eventVenueMappingTimeModel,
EventTimeSlotMappings = eventTimeSlotMappings,
PlaceWeekOpenDays = placeOpenDaysModel,
Days = daysModel,
CountryRegionalOrganisationMappings = CountryRegionalOrganisation.ToList(),
Countries = Countrymodel,
Category = category,
SubCategory = subCategory,
RegionalOrganisation = reginalOrganisation,
TiqetsCheckoutDetails = tiqetCheckoutDetailsModel,
ValidWithVariantModel = validWithVariantList,
CitySightSeeingTicketDetail = Mapper.Map <FIL.Contracts.Models.CitySightSeeing.CitySightSeeingTicketDetail>(citySightSeeingTicketDetail),
POneImageEventDetailMapping = pOneImageEventDetailMapping,
EventHostMapping = eventHostMappingList,
EventAttributes = eventAttribute.ToList(),
eventRecurranceScheduleModels = recurranceScheduleModels,
ASIMonument = ASIMonument,
FormattedDateString = formattedDateString
});
}
catch (Exception e)
{
return(new TicketCategoryQueryResult
{
});
}
}
else
{
return(new TicketCategoryQueryResult
{
Event = eventModel,
EventDetail = eventDetailModel,
EventTicketAttribute = null,
TicketFeeDetail = null,
Venue = venueDetailModel,
City = cityModel,
EventTicketDetail = eventTicketDetailModel,
TicketCategory = null,
CurrencyType = null,
RASVTicketTypeMappings = RASVTicketTypeMappingsModel,
EventDeliveryTypeDetails = eventDeliveryTypeDetailModel,
EventCategory = eventModel.EventCategoryId,
MatchAttribute = null,
Team = null,
CitySightSeeingTicketDetail = null
});
}
}
else
{
return(new TicketCategoryQueryResult {
});
}
}
else
{
return(new TicketCategoryQueryResult {
});
}
}
catch (Exception e)
{
_logger.Log(Logging.Enums.LogCategory.Error, e);
return(new TicketCategoryQueryResult {
});
}
}
protected override async Task <ICommandResult> Handle(CreateBookingCommand command)
{
CreateBookingCommandResult results = new CreateBookingCommandResult();
var transaction = _transactionRepository.Get(command.TransactionId);
var transactionDetail = _transactionDetailRepository.GetByTransactionId(command.TransactionId);
RootObject rootObject = new RootObject();
if (transaction != null)
{
IDictionary <string, long> ticketCategoryValues = new Dictionary <string, long>();
var feelBarcodemapping = _feelBarcodeMappingRepository.GetByTransactionDetailIds(transactionDetail.Select(s => s.Id)).ToList();
if (feelBarcodemapping.Count() == 0)
{
var transactionDetailModel = AutoMapper.Mapper.Map <IEnumerable <TransactionDetail> >(transactionDetail);
GetBarcodeResponseViewModel getBarcodeResponseViewModel = new GetBarcodeResponseViewModel();
FIL.Contracts.Models.FeelBarcode.Data data = new FIL.Contracts.Models.FeelBarcode.Data();
Address address = new Address();
Contact contact = new Contact();
BookingType bookingType = new BookingType();
List <FIL.Contracts.Models.FeelBarcode.BookingDetail> bookingDetails = new List <FIL.Contracts.Models.FeelBarcode.BookingDetail>();
foreach (var transactiondetail in transactionDetailModel)
{
var eventTicketAttributes = _eventTicketAttributeRepository.Get(transactiondetail.EventTicketAttributeId);
var eventTicketDetails = _eventTicketDetailRepository.Get(eventTicketAttributes.EventTicketDetailId);
var eventDetails = _eventDetailRepository.Get(eventTicketDetails.EventDetailId);
var currentTransaction = _transactionRepository.Get(transaction.Id);
var currentTransactionDetail = _transactionDetailRepository.Get(transactiondetail.Id);
var currentEventTicketAttributes = _eventTicketAttributeRepository.Get((int)currentTransactionDetail.EventTicketAttributeId);
var currentEventTicketDetail = _eventTicketDetailRepository.Get(currentEventTicketAttributes.EventTicketDetailId);
var currentTicketCategory = _ticketCategoryRepository.Get((int)currentEventTicketDetail.TicketCategoryId);
var currentEventDetails = _eventDetailRepository.Get(currentEventTicketDetail.EventDetailId);
var curretVenue = _venueRepository.Get(currentEventDetails.VenueId);
var currentCity = _cityRepository.Get(curretVenue.CityId);
var currentstate = _stateRepository.Get(currentCity.StateId);
var currentcountry = _countryRepository.Get(currentstate.CountryId);
var currentEvent = _eventRepository.Get(currentEventDetails.EventId);
var currentCurrencyType = _currencyTypeRepository.Get(currentEventTicketAttributes.CurrencyId);
if (currentEvent.EventSourceId == EventSource.CitySightSeeing)
{
ticketCategoryValues.Add(currentTicketCategory.Name.ToLower(), transactiondetail.Id);
var fromDate = Convert.ToDateTime(transactiondetail.VisitDate).ToUniversalTime();
DateTime localTime1 = fromDate;
DateTime endDate = DateTime.Now;
localTime1 = DateTime.SpecifyKind(localTime1, DateTimeKind.Local);
DateTimeOffset localTime2 = localTime1;
var mystring = localTime2.ToString();
var offset = mystring.Substring(mystring.Length - 6);
var citySightSeeingEventDetailMapping = _citySightSeeingEventDetailMappingRepository.GetByEventDetailId(currentEventDetails.Id);
var citySightSeeingtickets = _citySightSeeingTicketRepository.Get(citySightSeeingEventDetailMapping.CitySightSeeingTicketId);
FIL.Contracts.Models.FeelBarcode.BookingDetail bookingDetail = new FIL.Contracts.Models.FeelBarcode.BookingDetail();
var citySightSeeingTicketDetails = _citySightSeeingTicketDetailRepository.GetByTicketId(citySightSeeingtickets.TicketId);
var bookingDistributorReference = RandomDigits(10);
var citySightSeeingTransactionDetail = new CitySightSeeingTransactionDetail();
if (citySightSeeingTicketDetails.TicketClass != 1)
{
citySightSeeingTransactionDetail = _citySightSeeingTransactionDetailRepository.GetByTransactionId(transactiondetail.TransactionId);
bookingType.from_date_time = citySightSeeingTransactionDetail.FromDateTime;
bookingType.to_date_time = citySightSeeingTransactionDetail.EndDateTime;
data.reservation_reference = citySightSeeingTransactionDetail.ReservationReference;
}
var citySightSeeingLocations = _citySightSeeingLocationRepository.Get(citySightSeeingtickets.CitySightSeeingLocationId);
var locationDetail = await _googleMapApi.GetLatLongFromAddress(citySightSeeingLocations.Name);
string tz = ""; DateTime fromDateTime = DateTime.Now;; var offsetTime = "";
var duration = citySightSeeingTicketDetails.Duration;
double lat = Convert.ToDouble(locationDetail.Result.lat);
double lng = Convert.ToDouble(locationDetail.Result.lng);
tz = TimeZoneLookup.GetTimeZone(lat, lng).Result;
TimeZoneInfo tzi = TZConvert.GetTimeZoneInfo(tz);
var visitDateTime = Convert.ToDateTime(transactiondetail.VisitDate);
var timeSlot = citySightSeeingTicketDetails.TicketClass == 1 ? "00:00" : citySightSeeingTransactionDetail.TimeSlot;
var utcOffset = tzi.BaseUtcOffset.ToString().Split(":")[0];
if (utcOffset.Contains("-"))
{
offset = utcOffset;
}
else
{
offset = "+" + utcOffset;
}
var formattedDateTime = visitDateTime.Year + "-" + visitDateTime.Month + "-" + visitDateTime.Day + "T" + timeSlot;
fromDate = Convert.ToDateTime(formattedDateTime);
if (duration.Contains("day"))
{
string[] day = duration.Split("day");
endDate = fromDate.AddDays(Convert.ToDouble(day[0]));
}
if (duration.Contains("hour"))
{
string[] hour = duration.Split("hour");
endDate = fromDate.AddHours(Convert.ToDouble(hour[0]));
}
var formattedEndDate = endDate.Year + "-" + endDate.Month + "-" + endDate.Day + "T" + endDate.TimeOfDay.ToString();
bookingType.from_date_time = formattedDateTime + offset;
bookingType.to_date_time = formattedEndDate + offset;
bookingDetail.ticket_type = (currentTicketCategory.Name).ToUpper();
bookingDetail.count = currentTransactionDetail.TotalTickets;
bookingDetail.extra_options = null;
bookingDetails.Add(bookingDetail);
bookingType.ticket_id = citySightSeeingTicketDetails.TicketId;
address.street = curretVenue.Name;
address.postal_code = "432243";
address.city = currentCity.Name;
contact.address = address;
contact.phonenumber = currentTransaction.PhoneNumber;
data.currency = currentCurrencyType.Code;
bookingType.booking_details = bookingDetails;
data.distributor_id = _settings.GetConfigSetting <string>(SettingKeys.Integration.CitySightSeeing.DistributorId);
data.booking_type = bookingType;
data.booking_name = transaction.FirstName;
data.booking_email = transaction.EmailId;
data.contact = contact;
data.notes = null;
data.product_language = "en";
data.distributor_reference = bookingDistributorReference;
rootObject.request_type = "booking";
rootObject.data = data;
var responeBooking = await GetBarcodeAsync(rootObject, transaction.Id, ticketCategoryValues);
if (responeBooking.data != null)
{
if (citySightSeeingTicketDetails.TicketClass != 1)
{
citySightSeeingTransactionDetail.BookingReference = responeBooking.data.booking_reference;
citySightSeeingTransactionDetail.BookingDistributorReference = responeBooking.data.distributor_reference;
citySightSeeingTransactionDetail.IsOrderConfirmed = true;
_citySightSeeingTransactionDetailRepository.Save(citySightSeeingTransactionDetail);
}
else
{
_citySightSeeingTransactionDetailRepository.Save(new CitySightSeeingTransactionDetail
{
AltId = Guid.NewGuid(),
FromDateTime = fromDate.ToString() + offset,
EndDateTime = endDate.ToString() + offset,
HasTimeSlot = false,
BookingReference = responeBooking.data.booking_reference,
BookingDistributorReference = bookingDistributorReference,
TicketId = citySightSeeingtickets.TicketId,
TransactionId = command.TransactionId,
IsOrderConfirmed = true,
ModifiedBy = command.ModifiedBy
});
}
results.Success = true;
return(results);
}
else
{
results.Success = false;
return(results);
}
}
}
}
else
{
results.IsExists = true;
return(results);
}
}
else
{
results.Success = false;
return(results);
}
return(results);
}