public CurrentOrderDataQueryResult Handle(CurrentOrderDataQuery query)
{
var transaction = _transactionRepository.GetByAltId(query.TransactionAltId);
if (transaction == null)
{
return(new CurrentOrderDataQueryResult
{
});
}
var transactionDetails = _transactionDetailRepository.GetByTransactionId(transaction.Id);
var transactionDetailModel = AutoMapper.Mapper.Map <List <Contracts.Models.TransactionDetail> >(transactionDetails);
var eventTicketAttributeDetails = _eventTicketAttributeRepository.GetByEventTicketAttributeIds(transactionDetails.Select(s => s.EventTicketAttributeId));
var eventTicketDetails = _eventTicketDetailRepository.GetByEventTicketDetailIds(eventTicketAttributeDetails.Select(s => s.EventTicketDetailId));
var eventTicketDetailModel = AutoMapper.Mapper.Map <List <Contracts.Models.EventTicketDetail> >(eventTicketDetails);
var ticketCategories = _ticketCategoryRepository.GetByTicketCategoryIds(eventTicketDetails.Select(s => s.TicketCategoryId));
var eventDetails = _eventDetailRepository.GetByEventDetailIds(eventTicketDetails.Select(s => s.EventDetailId).Distinct());
var eventAttribute = _eventAttributeRepository.GetByEventDetailIds(eventTicketDetails.Select(s => s.EventDetailId).Distinct());
var eventDetailModel = AutoMapper.Mapper.Map <List <Contracts.Models.EventDetail> >(eventDetails);
var venues = _venueRepository.GetByVenueIds(eventDetailModel.Select(s => s.VenueId));
var city = _cityRepository.GetByCityIds(venues.Select(s => s.CityId));
var state = _stateRepository.GetByStateIds(city.Select(s => s.StateId));
var country = _countryRepository.GetByCountryIds(state.Select(s => s.CountryId));
List <FIL.Contracts.DataModels.Event> events = events = _eventRepository.GetByAllEventIds(eventDetails.Select(s => s.EventId).Distinct()).ToList();
var currencyDetail = _currencyTypeRepository.GetByCurrencyId(transaction.CurrencyId);
var orderConfirmationSubContainer = events.Select(eId =>
{
var tEvent = events.Where(s => s.Id == eId.Id).FirstOrDefault();
var tEventDetail = _eventDetailRepository.GetByEventIdAndEventDetailId(eId.Id, eventDetails.Select(edId => edId.Id)).OrderBy(s => s.StartDateTime).OrderByDescending(od => od.Id);
var subEventContainer = tEventDetail.Select(edetail =>
{
var teventCategory = new FIL.Contracts.DataModels.EventCategory();
var eventCategotyMappings = _eventCategoryMappingRepository.GetByEventId(tEvent.Id).FirstOrDefault();
if (eventCategotyMappings != null)
{
teventCategory = _eventCategoryRepository.Get(eventCategotyMappings.EventCategoryId);
}
var tEventDetails = eventDetails.Where(s => s.Id == edetail.Id).FirstOrDefault();
var tEventAttributes = eventAttribute.Where(s => s.EventDetailId == tEventDetails.Id).FirstOrDefault();
var tVenue = venues.Where(s => s.Id == edetail.VenueId).FirstOrDefault();
var tCity = city.Where(s => s.Id == tVenue.CityId).FirstOrDefault();
var tState = state.Where(s => s.Id == tCity.StateId).FirstOrDefault();
var tCountry = country.Where(s => s.Id == tState.CountryId).FirstOrDefault();
var tEventTicketDetail = _eventTicketDetailRepository.GetByEventDetailIdsAndIds(tEventDetail.Where(w => w.Id == edetail.Id).Select(s => s.Id), eventTicketDetailModel.Select(s => s.Id));
var tEventTicketAttribute = eventTicketAttributeDetails.Where(x => tEventTicketDetail.Any(y => y.Id == x.EventTicketDetailId));
var tTicketCategory = ticketCategories.Where(x => tEventTicketDetail.Any(y => y.TicketCategoryId == x.Id));
var tTransactionDetail = transactionDetails.Where(x => tEventTicketAttribute.Any(y => y.Id == x.EventTicketAttributeId)).ToList();
var tEventDeliveryTypeDetail = _eventDeliveryTypeDetailRepository.GetByEventDetailIds(tEventDetail.Select(s => s.Id));
var tTransactionDeliveryDetail = _transactionDeliveryDetailRepository.GetByTransactionDetailIds(tTransactionDetail.Select(s => s.Id));
var tUser = _userRepository.GetByAltId(transaction.CreatedBy);
var tUserAddress = (dynamic)null;
if (tUser != null)
{
tUserAddress = _userAddressDetailRepository.GetByUserId(tUser.Id).LastOrDefault();
}
var tZipCode = (dynamic)null;
if (tUserAddress != null)
{
tZipCode = _zipcodeRepository.Get(tUserAddress.Zipcode);
}
return(new SubEventContainer
{
Event = AutoMapper.Mapper.Map <Contracts.Models.Event>(tEvent),
EventCategory = AutoMapper.Mapper.Map <Contracts.Models.EventCategory>(teventCategory),
EventAttribute = AutoMapper.Mapper.Map <Contracts.Models.EventAttribute>(tEventAttributes),
EventDetail = AutoMapper.Mapper.Map <Contracts.Models.EventDetail>(tEventDetails),
Venue = AutoMapper.Mapper.Map <Contracts.Models.Venue>(tVenue),
City = AutoMapper.Mapper.Map <Contracts.Models.City>(tCity),
State = AutoMapper.Mapper.Map <Contracts.Models.State>(tState),
Country = AutoMapper.Mapper.Map <Contracts.Models.Country>(tCountry),
Zipcode = AutoMapper.Mapper.Map <Contracts.Models.Zipcode>(tZipCode),
EventTicketDetail = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.EventTicketDetail> >(tEventTicketDetail),
EventTicketAttribute = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.EventTicketAttribute> >(tEventTicketAttribute),
EventDeliveryTypeDetail = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.EventDeliveryTypeDetail> >(tEventDeliveryTypeDetail),
TicketCategory = AutoMapper.Mapper.Map <IEnumerable <FIL.Contracts.Models.TicketCategory> >(tTicketCategory),
TransactionDetail = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.TransactionDetail> >(tTransactionDetail),
TransactionDeliveryDetail = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.TransactionDeliveryDetail> >(tTransactionDeliveryDetail),
});
});
return(new OrderConfirmationSubContainer
{
Event = AutoMapper.Mapper.Map <Contracts.Models.Event>(tEvent),
subEventContainer = subEventContainer.ToList()
});
});
return(new CurrentOrderDataQueryResult
{
Transaction = AutoMapper.Mapper.Map <Contracts.Models.Transaction>(transaction),
CurrencyType = AutoMapper.Mapper.Map <FIL.Contracts.Models.CurrencyType>(currencyDetail),
orderConfirmationSubContainer = orderConfirmationSubContainer.ToList(),
TicketQuantity = eventTicketAttributeDetails.ToArray().Length,
});
}
protected override Task <ICommandResult> Handle(UpdateTransactionCommand command)
{
List <TransactionDetail> transactionDetailList = new List <TransactionDetail>();
var transaction = _transactionRepository.Get(command.TransactionId);
if (transaction != null && transaction.CreatedBy != null && transaction.ChannelId != Channels.Feel)
{
var user = _userRepository.GetByAltId(transaction.CreatedBy);
user.PhoneCode = command.DeliveryDetail[0].PhoneCode;
user.PhoneNumber = command.DeliveryDetail[0].PhoneNumber;
User upadateUserResult = _userRepository.Save(user);
}
var transactionDetails = AutoMapper.Mapper.Map <IEnumerable <FIL.Contracts.DataModels.TransactionDetail> >(_transactionDetailRepository.GetByTransactionId(command.TransactionId));
var eventTicketAttributeIds = transactionDetails.Select(s => s.EventTicketAttributeId).Distinct();
var eventTicketAttributes = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.EventTicketAttribute> >(_eventTicketAttributeRepository.GetByIds(eventTicketAttributeIds));
var ticketFeeDetails = AutoMapper.Mapper.Map <IEnumerable <Contracts.Models.TicketFeeDetail> >(_ticketFeeDetailRepository.GetByEventTicketAttributeIds(eventTicketAttributeIds));
var isItinerary = TransactionType.Regular;
decimal totalConvenienceCharge = 0, smsCharges = 0, totalServiceCharge = 0, totalDeliveryCharge = 0, grossTicketAmount = 0, transactionFee = 0, transactionFeeValue = 0, transactionFeeValueTypeId = 0, creditCardSurcharge = 0, creditCardSurchargeValue = 0, creditCardSurchargeValueTypeId = 0;
Channels ChannelID = transaction.ChannelId;
foreach (var transactionDetail in transactionDetails)
{
TransactionDetail transactionDetailMapper = transactionDetail;
var eventTicketAttribute = eventTicketAttributes.Where(w => w.Id == transactionDetail.EventTicketAttributeId).FirstOrDefault();
var ticketFeeDetailList = ticketFeeDetails.Where(w => w.EventTicketAttributeId == eventTicketAttribute.Id);
var commandDeliveryDetail = command.DeliveryDetail.Where(w => w.EventTicketAttributeId == eventTicketAttribute.Id).FirstOrDefault();
grossTicketAmount += transactionDetail.PricePerTicket * transactionDetail.TotalTickets;
}
foreach (var transactionDetail in transactionDetails)
{
TransactionDetail transactionDetailMapper = transactionDetail;
if (transactionDetail.TransactionType == TransactionType.Itinerary)
{
isItinerary = TransactionType.Itinerary;
}
var eventTicketAttribute = eventTicketAttributes.Where(w => w.Id == transactionDetail.EventTicketAttributeId).FirstOrDefault();
var ticketFeeDetailList = ticketFeeDetails.Where(w => w.EventTicketAttributeId == eventTicketAttribute.Id).OrderBy(o => o.FeeId);
// Convert TicketFeeDetails into geo currency...
if (ChannelID == Channels.Feel)
{
_geoCurrency.UpdateTicketFeeDetails(ticketFeeDetailList.ToList(), command.TargetCurrencyCode, eventTicketAttribute.CurrencyId);
}
var commandDeliveryDetail = command.DeliveryDetail.Where(w => w.EventTicketAttributeId == eventTicketAttribute.Id).FirstOrDefault();
decimal prevConvenienceCharges = 0;
decimal DeliveryCharge = 0, ServiceCharge = 0, ConvenienceCharge = 0;
decimal convenienceCharges = 0, serviceCharge = 0, pahCharge = 0, unitLevelSMSCharge = 0, unitLevelTransactionFee = 0;
foreach (var ticketFeeDetail in ticketFeeDetailList)
{
if (ticketFeeDetail.FeeId == (int)FeeType.ConvenienceCharge)
{
if (ticketFeeDetail.ValueTypeId == (int)ValueTypes.Percentage)
{
convenienceCharges = ((ticketFeeDetail.Value * (transactionDetail.PricePerTicket * transactionDetail.TotalTickets)) / 100);
prevConvenienceCharges = convenienceCharges;
}
else if (ticketFeeDetail.ValueTypeId == (int)ValueTypes.Flat)
{
convenienceCharges = ticketFeeDetail.Value * transactionDetail.TotalTickets;
prevConvenienceCharges = convenienceCharges;
}
}
if (ticketFeeDetail.FeeId == (int)FeeType.SMSCharge)
{
smsCharges = ticketFeeDetail.Value;
}
if (ticketFeeDetail.FeeId == (int)FeeType.TransactionFee)
{
transactionFeeValue = ticketFeeDetail.Value;
transactionFeeValueTypeId = ticketFeeDetail.ValueTypeId;
}
if (ticketFeeDetail.FeeId == (int)FeeType.CreditCardSurcharge)
{
creditCardSurchargeValue = ticketFeeDetail.Value;
creditCardSurchargeValueTypeId = ticketFeeDetail.ValueTypeId;
}
if (transactionFeeValueTypeId == (int)ValueTypes.Percentage)
{
transactionFee = ((transactionFeeValue * (totalConvenienceCharge + smsCharges)) / 100);
}
else if (transactionFeeValueTypeId == (int)ValueTypes.Flat)
{
transactionFee = transactionFeeValue;
}
if (creditCardSurchargeValueTypeId == (int)ValueTypes.Percentage)
{
creditCardSurcharge = ((creditCardSurchargeValue * (grossTicketAmount + transactionFee)) / 100);
}
else if (creditCardSurchargeValue == (int)ValueTypes.Flat)
{
creditCardSurcharge = creditCardSurchargeValue;
}
unitLevelSMSCharge = (smsCharges / transactionDetails.Count());
unitLevelTransactionFee = ((transactionFee + creditCardSurcharge) / transactionDetails.Count());
ConvenienceCharge = convenienceCharges + unitLevelSMSCharge + unitLevelTransactionFee;
if (ticketFeeDetail.FeeId == (int)FeeType.ServiceCharge)
{
if (ticketFeeDetail.ValueTypeId == (int)ValueTypes.Percentage)
{
serviceCharge = ((ticketFeeDetail.Value * prevConvenienceCharges) / 100);
prevConvenienceCharges = 0;
}
else if (ticketFeeDetail.ValueTypeId == (int)ValueTypes.Flat)
{
serviceCharge = ticketFeeDetail.Value * transactionDetail.TotalTickets;
}
}
ServiceCharge = serviceCharge;
if (commandDeliveryDetail.DeliveryTypeId == DeliveryTypes.PrintAtHome && ticketFeeDetail.FeeId == (int)FeeType.PrintAtHomeCharge)
{
pahCharge = ticketFeeDetail.Value;
}
DeliveryCharge = pahCharge;
}
transactionDetailMapper.ConvenienceCharges = ConvenienceCharge;
transactionDetailMapper.ServiceCharge = ServiceCharge;
transactionDetailMapper.DeliveryCharges = DeliveryCharge;
totalDeliveryCharge += DeliveryCharge;
totalServiceCharge += ServiceCharge;
totalConvenienceCharge += ConvenienceCharge;
transactionDetailList.Add(transactionDetailMapper);
}
if (transactionFeeValueTypeId == (int)ValueTypes.Percentage)
{
transactionFee = ((transactionFeeValue * (totalConvenienceCharge + smsCharges)) / 100);
}
else if (transactionFeeValueTypeId == (int)ValueTypes.Flat)
{
transactionFee = transactionFeeValue;
}
if (creditCardSurchargeValueTypeId == (int)ValueTypes.Percentage)
{
creditCardSurcharge = ((creditCardSurchargeValue * (grossTicketAmount + transactionFee)) / 100);
}
else if (creditCardSurchargeValue == (int)ValueTypes.Flat)
{
creditCardSurcharge = creditCardSurchargeValue;
}
if (transactionFee > 0)
{
transaction.ConvenienceCharges = transactionFee + creditCardSurcharge;
transaction.ServiceCharge = totalServiceCharge;
transaction.DeliveryCharges = totalDeliveryCharge;
transaction.GrossTicketAmount = grossTicketAmount;
transaction.NetTicketAmount = ((grossTicketAmount + transactionFee + creditCardSurcharge) - transaction.DiscountAmount);
}
else
{
transaction.ConvenienceCharges = totalConvenienceCharge + transactionFee + creditCardSurcharge;
transaction.ServiceCharge = totalServiceCharge;
transaction.DeliveryCharges = totalDeliveryCharge;
transaction.GrossTicketAmount = grossTicketAmount;
transaction.NetTicketAmount = ((grossTicketAmount + totalConvenienceCharge + totalServiceCharge + totalDeliveryCharge + transactionFee + creditCardSurcharge) - transaction.DiscountAmount);
}
if (ChannelID == Channels.Feel)
{
_geoCurrency.UpdateTransactionUpdates(transaction, command.TargetCurrencyCode);
}
FIL.Contracts.DataModels.Transaction transactionResult = _transactionRepository.Save(transaction);
foreach (var transactionDetail in transactionDetailList)
{
TransactionDetail transactionDetailResult = _transactionDetailRepository.Save(transactionDetail);
try
{
if (ChannelID == Channels.Feel)
{
var currentETA = command.EventTicketAttributeList.Where(s => s.Id == transactionDetail.EventTicketAttributeId && (transactionDetail.TicketTypeId != null ? (TicketType)transactionDetail.TicketTypeId : TicketType.Regular) == s.TicketType).FirstOrDefault();
if (currentETA != null && currentETA.GuestDetails != null)
{
foreach (FIL.Contracts.Commands.Transaction.GuestUserDetail currentGuestDetail in currentETA.GuestDetails)
{
_saveGuestUserProvider.SaveGuestUsers(currentGuestDetail, transactionDetail);
}
}
}
}
catch (Exception e)
{
_logger.Log(Logging.Enums.LogCategory.Error, e);
}
}
var transactionDeliveryDetails = _transactionDeliveryDetailRepository.GetByTransactionDetailIds(transactionDetails.Select(s => s.Id).Distinct());
foreach (var deliveryDetail in command.DeliveryDetail)
{
var transactionDeliveryDetail = transactionDeliveryDetails.Where(w => w.TransactionDetailId == transactionDetails.Where(c => c.EventTicketAttributeId == deliveryDetail.EventTicketAttributeId).Select(s => s.Id).FirstOrDefault()).FirstOrDefault();
if (transactionDeliveryDetail == null)
{
_transactionDeliveryDetailRepository.Save(new TransactionDeliveryDetail
{
TransactionDetailId = transactionDetails.Where(w => w.EventTicketAttributeId == deliveryDetail.EventTicketAttributeId).Select(s => s.Id).FirstOrDefault(),
DeliveryTypeId = deliveryDetail.DeliveryTypeId,
PickupBy = Convert.ToInt16(string.IsNullOrWhiteSpace(deliveryDetail.RepresentativeFirstName) ? 0 : 1),
SecondaryName = $"{deliveryDetail.FirstName} {deliveryDetail.LastName}",
SecondaryContact = $"{deliveryDetail.PhoneCode}-{deliveryDetail.PhoneNumber}",
SecondaryEmail = deliveryDetail.DeliveryTypeId == DeliveryTypes.Courier ? deliveryDetail.Email : deliveryDetail.Email,
PickUpAddress = command.PickUpAddress
});
}
else
{
transactionDeliveryDetail.SecondaryName = $"{deliveryDetail.FirstName} {deliveryDetail.LastName}";
transactionDeliveryDetail.SecondaryContact = $"{deliveryDetail.PhoneCode}-{deliveryDetail.PhoneNumber}";
transactionDeliveryDetail.SecondaryEmail = deliveryDetail.DeliveryTypeId == DeliveryTypes.Courier ? deliveryDetail.Email : deliveryDetail.Email;
transactionDeliveryDetail.PickUpAddress = command.PickUpAddress;
_transactionDeliveryDetailRepository.Save(transactionDeliveryDetail);
}
}
var transactionresult = _transactionRepository.Get(command.TransactionId);
UpdateTransactionCommandResult updateTransactionCommandResult = new UpdateTransactionCommandResult();
updateTransactionCommandResult.Id = transactionresult.Id;
updateTransactionCommandResult.CurrencyId = transactionresult.CurrencyId;
updateTransactionCommandResult.GrossTicketAmount = transactionresult.GrossTicketAmount;
updateTransactionCommandResult.DeliveryCharges = transactionresult.DeliveryCharges;
updateTransactionCommandResult.ConvenienceCharges = transactionresult.ConvenienceCharges;
updateTransactionCommandResult.ServiceCharge = transactionresult.ServiceCharge;
updateTransactionCommandResult.DiscountAmount = transactionresult.DiscountAmount;
updateTransactionCommandResult.NetTicketAmount = transactionresult.NetTicketAmount;
return(Task.FromResult <ICommandResult>(updateTransactionCommandResult));
}
public OrderConfirmationQueryResult Get(
long transactionId,
bool isConfirmationFromMyOrders,
FIL.Contracts.Enums.Channels channel)
{
var transactionScheduleDetails = new List <FIL.Contracts.DataModels.TransactionScheduleDetail>();
var scheduleDetails = new List <FIL.Contracts.DataModels.ScheduleDetail>();
var transaction = _transactionRepository.GetSuccessfulTransactionDetails(transactionId);
var transactionModel = AutoMapper.Mapper.Map <FIL.Contracts.Models.Transaction>(transaction);
var IsASI = false; var IsHoho = false;
if (transactionModel == null)
{
return(new OrderConfirmationQueryResult());
}
var transactionDetails = _transactionDetailsRepository.GetByTransactionId(transactionModel.Id);
var transactionDetailModel = AutoMapper.Mapper.Map <List <TransactionDetail> >(transactionDetails);
var eventTicketAttributeDetails = _eventTicketAttributeRepository.GetByEventTicketAttributeIds(transactionDetails.Select(s => s.EventTicketAttributeId));
var eventTicketDetails = _eventTicketDetailRepository.GetByEventTicketDetailIds(eventTicketAttributeDetails.Select(s => s.EventTicketDetailId));
var eventTicketDetailModel = AutoMapper.Mapper.Map <List <EventTicketDetail> >(eventTicketDetails);
var ticketCategories = _ticketCategoryRepository.GetByTicketCategoryIds(eventTicketDetails.Select(s => s.TicketCategoryId));
var eventDetails = _eventDetailRepository.GetByEventDetailIds(eventTicketDetails.Select(s => s.EventDetailId).Distinct());
var eventAttribute = _eventAttributeRepository.GetByEventDetailIds(eventTicketDetails.Select(s => s.EventDetailId).Distinct());
var eventDetailModel = AutoMapper.Mapper.Map <List <EventDetail> >(eventDetails);
var venues = _venueRepository.GetByVenueIds(eventDetailModel.Select(s => s.VenueId));
var city = _cityRepository.GetByCityIds(venues.Select(s => s.CityId));
var state = _stateRepository.GetByStateIds(city.Select(s => s.StateId));
var country = _countryRepository.GetByCountryIds(state.Select(s => s.CountryId));
if (channel == Contracts.Enums.Channels.Feel && eventDetailModel.FirstOrDefault().EventFrequencyType == Contracts.Enums.EventFrequencyType.Recurring)
{
transactionScheduleDetails = _transactionScheduleDetail.GetAllByTransactionDetails(transactionDetailModel.Select(s => s.Id).ToList()).ToList();
scheduleDetails = _scheduleDetailRepository.GetAllByIds(transactionScheduleDetails.Select(s => s.ScheduleDetailId).ToList()).ToList();
}
List <FIL.Contracts.DataModels.Event> events = new List <FIL.Contracts.DataModels.Event>();
if (isConfirmationFromMyOrders == true)
{
events = _eventRepository.GetByAllEventIds(eventDetails.Select(s => s.EventId).Distinct()).ToList();
}
else
{
events = _eventRepository.GetByAllTypeEventIds(eventDetails.Select(s => s.EventId).Distinct()).ToList();
}
var transactionPaymentDetails = _transactionPaymentDetailRepository.GetAllByTransactionId(transactionId);
var transactionPaymentDetail = transactionPaymentDetails.Where(s => s.UserCardDetailId != null).FirstOrDefault();
var currencyDetail = _currencyTypeRepository.GetByCurrencyId(transactionModel.CurrencyId);
var paymentOption = (dynamic)null;
var userCardDetail = (dynamic)null;
if (transactionPaymentDetail != null)
{
paymentOption = transactionPaymentDetail.PaymentOptionId.ToString();
userCardDetail = _userCardDetailRepository.GetByUserCardDetailId(transactionPaymentDetail.UserCardDetailId);
}
var cardTypes = (dynamic)null;
if (userCardDetail != null)
{
cardTypes = userCardDetail.CardTypeId.ToString();
}
var orderConfirmationSubContainer = events.Select(eId =>
{
var tEvent = events.Where(s => s.Id == eId.Id).FirstOrDefault();
var tEventDetail = _eventDetailRepository.GetByEventIdAndEventDetailId(eId.Id, eventDetails.Select(edId => edId.Id)).OrderBy(s => s.StartDateTime).OrderByDescending(od => od.Id);
var subEventContainer = tEventDetail.Select(edetail =>
{
var teventCategory = new FIL.Contracts.DataModels.EventCategory();
if (channel == FIL.Contracts.Enums.Channels.Feel)
{
var eventCategotyMappings = _eventCategoryMappingRepository.GetByEventId(tEvent.Id).FirstOrDefault();
if (eventCategotyMappings != null)
{
teventCategory = _eventCategoryRepository.Get(eventCategotyMappings.EventCategoryId);
}
}
else
{
teventCategory = _eventCategoryRepository.Get(tEvent.EventCategoryId);
}
var tEventDetails = eventDetails.Where(s => s.Id == edetail.Id).FirstOrDefault();
var tEventAttributes = eventAttribute.Where(s => s.EventDetailId == tEventDetails.Id).FirstOrDefault();
var tVenue = venues.Where(s => s.Id == edetail.VenueId).FirstOrDefault();
var tCity = city.Where(s => s.Id == tVenue.CityId).FirstOrDefault();
var tState = state.Where(s => s.Id == tCity.StateId).FirstOrDefault();
var tCountry = country.Where(s => s.Id == tState.CountryId).FirstOrDefault();
var tEventTicketDetail = _eventTicketDetailRepository.GetByEventDetailIdsAndIds(tEventDetail.Where(w => w.Id == edetail.Id).Select(s => s.Id), eventTicketDetailModel.Select(s => s.Id));
var tEventTicketAttribute = eventTicketAttributeDetails.Where(x => tEventTicketDetail.Any(y => y.Id == x.EventTicketDetailId));
var tTicketCategory = ticketCategories.Where(x => tEventTicketDetail.Any(y => y.TicketCategoryId == x.Id));
var tTransactionDetail = transactionDetails.Where(x => tEventTicketAttribute.Any(y => y.Id == x.EventTicketAttributeId)).ToList();
List <MatchLayoutSectionSeat> tMatchLayoutSectionSeats = new List <MatchLayoutSectionSeat>();
List <FIL.Contracts.DataModels.MatchLayoutCompanionSeatMapping> tMatchLayoutCompanionSeatMapping = new List <FIL.Contracts.DataModels.MatchLayoutCompanionSeatMapping>();
var tMatchSeatTicketDetails = _matchSeatTicketDetailRepository.GetByTransactionIdAndTicketDetailIds(tTransactionDetail.Select(w => w.TransactionId).FirstOrDefault(), tEventTicketDetail.Select(w => w.Id));
if (tMatchSeatTicketDetails.Any())
{
var matchSeatTicketDetails = tMatchSeatTicketDetails.Where(w => w.MatchLayoutSectionSeatId != null).FirstOrDefault();
if (matchSeatTicketDetails != null)
{
tMatchLayoutSectionSeats = AutoMapper.Mapper.Map <List <MatchLayoutSectionSeat> >(_matchLayoutSectionSeatRepository.GetByIds(tMatchSeatTicketDetails.Select(s => (long)s.MatchLayoutSectionSeatId).Distinct()));
tMatchLayoutCompanionSeatMapping = AutoMapper.Mapper.Map <List <FIL.Contracts.DataModels.MatchLayoutCompanionSeatMapping> >(_matchLayoutCompanionSeatMappingRepository.GetByWheelChairSeatIds(tMatchLayoutSectionSeats.Select(s => s.Id).Distinct()));
}
}
var taSITransactionDetailTimeSlotIdMapping = _aSITransactionDetailTimeSlotIdMappingRepository.GetByTransactionDetailIds(tTransactionDetail.Select(s => s.Id));
var tGuestDetails = _guestDetailRepository.GetByTransactionDetailIds(tTransactionDetail.Select(s => s.Id));
var taSIPaymentResponseDetailTicketMappings = _aSIPaymentResponseDetailTicketMappingRepository.GetByVisitorIds(tGuestDetails.Select(s => (long)s.Id).ToList());
var teventTimeSlotMapping = _eventTimeSlotMappingRepository.GetByIds(taSITransactionDetailTimeSlotIdMapping.Select(s => s.EventTimeSlotMappingId));
if (tEvent.EventSourceId == Contracts.Enums.EventSource.ASI)
{
IsASI = true;
foreach (FIL.Contracts.DataModels.TransactionDetail currentTransacitionDetail in tTransactionDetail)
{
var visitDate = (DateTime)currentTransacitionDetail.VisitDate;
currentTransacitionDetail.VisitDate = visitDate.AddHours(5).AddMinutes(30);
}
}
if (tEvent.EventSourceId == Contracts.Enums.EventSource.CitySightSeeing)
{
IsHoho = true;
}
var tEventDeliveryTypeDetail = _eventDeliveryTypeDetailRepository.GetByEventDetailIds(tEventDetail.Select(s => s.Id));
var tTransactionDeliveryDetail = _transactionDeliveryDetailRepository.GetByTransactionDetailIds(tTransactionDetail.Select(s => s.Id));
var tUser = _userRepository.GetByAltId(transaction.CreatedBy);
var tUserAddress = (dynamic)null;
if (tUser != null)
{
tUserAddress = _userAddressDetailRepository.GetByUserId(tUser.Id).LastOrDefault();
}
var tZipCode = (dynamic)null;
if (tUserAddress != null)
{
tZipCode = _zipcodeRepository.Get(tUserAddress.Zipcode);
}
var transctionScheduleDetails = transactionScheduleDetails.Where(s => tTransactionDetail.Any(x => x.Id == s.TransactionDetailId)).ToList();
var scheduleDetail = scheduleDetails.Where(s => transctionScheduleDetails.Any(x => x.ScheduleDetailId == s.Id)).ToList();
return(new SubEventContainer
{
Event = AutoMapper.Mapper.Map <Event>(tEvent),
EventCategory = AutoMapper.Mapper.Map <EventCategory>(teventCategory),
EventAttribute = AutoMapper.Mapper.Map <EventAttribute>(tEventAttributes),
EventDetail = AutoMapper.Mapper.Map <EventDetail>(tEventDetails),
Venue = AutoMapper.Mapper.Map <Venue>(tVenue),
City = AutoMapper.Mapper.Map <City>(tCity),
State = AutoMapper.Mapper.Map <State>(tState),
Country = AutoMapper.Mapper.Map <Country>(tCountry),
Zipcode = AutoMapper.Mapper.Map <Zipcode>(tZipCode),
EventTicketDetail = AutoMapper.Mapper.Map <IEnumerable <EventTicketDetail> >(tEventTicketDetail),
EventTicketAttribute = AutoMapper.Mapper.Map <IEnumerable <EventTicketAttribute> >(tEventTicketAttribute),
EventDeliveryTypeDetail = AutoMapper.Mapper.Map <IEnumerable <EventDeliveryTypeDetail> >(tEventDeliveryTypeDetail),
TicketCategory = AutoMapper.Mapper.Map <IEnumerable <FIL.Contracts.Models.TicketCategory> >(tTicketCategory),
TransactionDetail = AutoMapper.Mapper.Map <IEnumerable <TransactionDetail> >(tTransactionDetail),
MatchSeatTicketDetail = AutoMapper.Mapper.Map <IEnumerable <MatchSeatTicketDetail> >(tMatchSeatTicketDetails),
MatchLayoutSectionSeat = AutoMapper.Mapper.Map <IEnumerable <MatchLayoutSectionSeat> >(tMatchLayoutSectionSeats),
MatchLayoutCompanionSeatMappings = AutoMapper.Mapper.Map <IEnumerable <FIL.Contracts.DataModels.MatchLayoutCompanionSeatMapping> >(tMatchLayoutCompanionSeatMapping),
TransactionDeliveryDetail = AutoMapper.Mapper.Map <IEnumerable <TransactionDeliveryDetail> >(tTransactionDeliveryDetail),
EventTimeSlotMappings = AutoMapper.Mapper.Map <IEnumerable <FIL.Contracts.Models.ASI.EventTimeSlotMapping> >(teventTimeSlotMapping),
ASITransactionDetailTimeSlotIdMappings = AutoMapper.Mapper.Map <IEnumerable <FIL.Contracts.Models.ASI.ASITransactionDetailTimeSlotIdMapping> >(taSITransactionDetailTimeSlotIdMapping),
ASIPaymentResponseDetailTicketMappings = AutoMapper.Mapper.Map <IEnumerable <FIL.Contracts.Models.ASI.ASIPaymentResponseDetailTicketMapping> >(taSIPaymentResponseDetailTicketMappings),
TransactionScheduleDetails = transctionScheduleDetails,
ScheduleDetails = scheduleDetail
});
});
return(new OrderConfirmationSubContainer
{
Event = AutoMapper.Mapper.Map <Event>(tEvent),
subEventContainer = subEventContainer.ToList()
});
});
decimal TotalGst = 0;
decimal GST = 0;
decimal AdditionalGST = 0;
try
{
if (transactionModel != null)
{
if (orderConfirmationSubContainer.Any() && orderConfirmationSubContainer.ToList().ElementAt(0).Event.AltId.ToString().ToUpper() == "1F0257FA-EEA6-4469-A7BC-B878A215C8A9") //RASV Email
{
TotalGst = (decimal)transactionModel.ConvenienceCharges / 11;
}
}
}
catch (Exception e)
{
}
return(new OrderConfirmationQueryResult
{
Transaction = transactionModel,
TransactionPaymentDetail = AutoMapper.Mapper.Map <FIL.Contracts.Models.TransactionPaymentDetail>(transactionPaymentDetail),
UserCardDetail = AutoMapper.Mapper.Map <FIL.Contracts.Models.UserCardDetail>(userCardDetail),
CurrencyType = AutoMapper.Mapper.Map <FIL.Contracts.Models.CurrencyType>(currencyDetail),
PaymentOption = paymentOption,
GoodsAndServiceTax = TotalGst,
cardTypes = cardTypes,
orderConfirmationSubContainer = orderConfirmationSubContainer.ToList(),
TicketQuantity = eventTicketAttributeDetails.ToArray().Length,
IsASI = IsASI,
IsHoho = IsHoho
});
}