public ActionResult Create(CreateTicketViewModel vm) { if (ModelState.IsValid) { var newTicket = new Ticket { TicketCategoryId = vm.TicketCategoryId, TicketSubCategoryId = vm.TicketSubCategoryId, Title = vm.Title, Description = vm.Description, DueDate = vm.DueDate, Status = vm.Status, AssignedToUserId = vm.AssignedToUserId, CreatedByUserId = WebUser.Id }; // Assign to Default point of contact. var selectedCategory = _ticketCategoryRepository.Get(vm.TicketCategoryId); var pointOfContact = _ticketService.GetPointOfContact(selectedCategory.Title); newTicket.AssignedToUserId = pointOfContact; _ticketRepository.Create(newTicket); _unitOfWork.Commit(); #if !DEBUG _emailComposerService.TicketCreated(newTicket.Id); #endif return(RedirectToAction("Index")); } // Special Case where the sub categories should be based on the category var categories = _ticketCategoryRepository.GetAll().ToList(); var subCategories = _ticketSubCategoryRepository.GetAllBy(s => s.TicketCategoryId == vm.TicketCategoryId); ViewBag.TicketCategoryId = new SelectList(categories, "Id", "Title", vm.TicketCategoryId); ViewBag.TicketSubCategoryId = new SelectList(subCategories, "Id", "Title", vm.TicketSubCategoryId); return(View()); }
public BarcodeQueryResult Handle(BarcodeQuery query) { try { var eventTicketDetails = _eventTicketDetailRepository.GetRASVRideEventTicketDetails() .ToDictionary(k => k.Id, k => k); var matchSeatTicketDetail = _matchSeatTicketDetailRepository.GetByBarcodeNumberAndEventTicketDetailIds(query.BarcodeNumber, eventTicketDetails.Keys); if (matchSeatTicketDetail != null) { var transaction = _transactionRepository.Get((long)matchSeatTicketDetail.TransactionId); var eventTicketDetail = eventTicketDetails[matchSeatTicketDetail.EventTicketDetailId]; var additionalInfo = _eventTicketAttributeRepository.GetByEventTicketDetailId(eventTicketDetail.Id).AdditionalInfo; var value = JsonConvert.DeserializeObject <TicketValue>(additionalInfo).value; var ticketCategoryId = eventTicketDetail.TicketCategoryId; var ticketCategoryName = _ticketCategoryRepository.Get((int)ticketCategoryId).Name.ToString(); var currencyId = transaction.CurrencyId; var transactionUTC = transaction.CreatedUtc; var currencyCode = _currencyTypeRepository.GetById(currencyId).Code.ToString(); var userAltId = transaction.CreatedBy; var userId = _userRepository.GetByAltId(userAltId).Id; var userAddressDetail = _userAddressDetailRepository.GetByUser(userId); var zipcodeId = userAddressDetail != null ? userAddressDetail.Zipcode : 9; var postalcode = _zipcodeRepository.Get(zipcodeId).Postalcode; var barcodeDetailsContainer = new BarcodeDetailsContainer() { AltId = (System.Guid)matchSeatTicketDetail.AltId, BarcodeNumber = matchSeatTicketDetail.BarcodeNumber, CurrencyCode = currencyCode, TicketCategoryId = ticketCategoryId, TicketCategory = ticketCategoryName, Value = value, Postalcode = postalcode, IsConsumed = matchSeatTicketDetail.IsConsumed, ConsumedDateTime = matchSeatTicketDetail.ConsumedDateTime, TransactionUTC = transactionUTC, }; return(new BarcodeQueryResult { BarcodeDetailsContainer = barcodeDetailsContainer, IsValid = true }); } var offlineBarcodeDetail = _offlineBarcodeDetailRepository.GetByBarcodeNumberAndEventTicketDetailIds(query.BarcodeNumber, eventTicketDetails.Keys); if (offlineBarcodeDetail != null) { var ticketCategoryId = _eventTicketDetailRepository.Get(offlineBarcodeDetail.EventTicketDetailId) .TicketCategoryId; var ticketCategoryName = _ticketCategoryRepository.Get((int)ticketCategoryId).Name; var currencyCode = _currencyTypeRepository.GetById(offlineBarcodeDetail.CurrencyId).Code; var barcodeDetailsContainer = new BarcodeDetailsContainer { AltId = offlineBarcodeDetail.AltId, BarcodeNumber = offlineBarcodeDetail.BarcodeNumber, CurrencyCode = currencyCode, TicketCategoryId = ticketCategoryId, TicketCategory = ticketCategoryName, Value = offlineBarcodeDetail.Price, Postalcode = "", IsConsumed = offlineBarcodeDetail.IsConsumed, ConsumedDateTime = offlineBarcodeDetail.ConsumedDateTime, }; return(new BarcodeQueryResult { BarcodeDetailsContainer = barcodeDetailsContainer, IsValid = true }); } } catch (Exception ex) { _logger.Log(Logging.Enums.LogCategory.Error, ex); } return(new BarcodeQueryResult { BarcodeDetailsContainer = null, IsValid = false }); }
public List <PAHDetail> GetPAHDetails(long transactionId) { var transactionDetail = _transactionDetailRepository.GetByTransactionId(transactionId); try { var feelBarcodeMapping = _feelBarcodeMappingRepository.GetByTransactionDetailIds(transactionDetail.Select(s => s.Id)).ToList(); List <PAHDetail> listPAHDetails = new List <PAHDetail>(); List <CategoryWiseTickets> categoryWiseTicketsList = new List <CategoryWiseTickets>(); long[] transactionDetailIds = new long[feelBarcodeMapping.Count]; if (feelBarcodeMapping.Count() > 0) { int i = 0, totalTickets = 0; decimal grptotalPrice = 0; foreach (FeelBarcodeMapping currentBarcode in feelBarcodeMapping) { i++; PAHDetail pAHDetail = new PAHDetail(); CategoryWiseTickets categoryWiseTickets = new CategoryWiseTickets(); var currentTransaction = _transactionRepository.Get(transactionId); // check for hoho timeslot var citySightSeeingTransaction = _citySightSeeingTransactionDetailRepository.GetByTransactionId(currentTransaction.Id); if (citySightSeeingTransaction.HasTimeSlot && citySightSeeingTransaction.TimeSlot != null) { var formatTimeSlot = citySightSeeingTransaction.TimeSlot.Split(":"); pAHDetail.TimeSlot = formatTimeSlot[0] + ":" + formatTimeSlot[1]; } var currentTransactionDetail = _transactionDetailRepository.Get(currentBarcode.TransactionDetailId); 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); var flag = true; var ticketCatName = currentTicketCategory.Name; grptotalPrice += currentEventTicketAttributes.Price; totalTickets += currentTransactionDetail.TotalTickets; categoryWiseTickets.CategoryName = currentTicketCategory.Name; categoryWiseTickets.TotalTickets = currentTransactionDetail.TotalTickets; if (currentBarcode.GroupCodeExist) { flag = false; if (!transactionDetailIds.Contains(currentBarcode.TransactionDetailId)) { transactionDetailIds[i - 1] = currentBarcode.TransactionDetailId; categoryWiseTicketsList.Add(categoryWiseTickets); } } if (currentBarcode.GroupCodeExist && feelBarcodeMapping.Count == i) { flag = true; ticketCatName = "Group"; } if (flag) { pAHDetail.EventId = currentEvent.Id; pAHDetail.EventName = currentEvent.Name; pAHDetail.EventStartTime = (DateTime)currentTransactionDetail.VisitDate; pAHDetail.EventsourceId = (long)(EventSource)Enum.Parse(typeof(EventSource), currentEvent.EventSourceId.ToString()); pAHDetail.Price = currentBarcode.GroupCodeExist ? grptotalPrice : currentEventTicketAttributes.Price; pAHDetail.TicketCategoryName = ticketCatName; pAHDetail.TotalTickets = currentBarcode.GroupCodeExist ? totalTickets : currentTransactionDetail.TotalTickets; pAHDetail.EventDetailsName = currentEventDetails.Name; pAHDetail.VenueId = curretVenue.Id; pAHDetail.VenueName = curretVenue.Name; pAHDetail.CityName = currentCity.Name; pAHDetail.CountryName = currentcountry.Name; pAHDetail.BarcodeNumber = currentBarcode.Barcode; pAHDetail.CurrencyName = currentCurrencyType.Code; pAHDetail.EventDeatilId = currentEventDetails.Id; pAHDetail.FirstName = currentTransaction.FirstName; pAHDetail.LastName = currentTransaction.LastName; pAHDetail.EmailId = currentTransaction.EmailId; pAHDetail.PhoneNumber = currentTransaction.PhoneNumber; pAHDetail.TransactionId = currentTransaction.Id; pAHDetail.CategoryWiseTickets = AutoMapper.Mapper.Map <List <CategoryWiseTickets> >(categoryWiseTicketsList); listPAHDetails.Add(pAHDetail); } } return(listPAHDetails); } else { return(listPAHDetails); } } catch (Exception ex) { _logger.Log(Logging.Enums.LogCategory.Error, new Exception(ex.Message)); return(null); } }
public GetPlaceInventoryQueryResult Handle(GetPlaceInventoryQuery query) { try { var eventData = _eventRepository.GetByAltId(query.PlaceAltId); var eventModel = AutoMapper.Mapper.Map <FIL.Contracts.Models.Event>(eventData); List <string> TicketValidityTypes = new List <string>(); List <string> DeliveryTypes = new List <string>(); foreach (FIL.Contracts.Enums.TicketValidityTypes ticketValidity in Enum.GetValues(typeof(FIL.Contracts.Enums.TicketValidityTypes))) { TicketValidityTypes.Add(ticketValidity.ToString()); } foreach (FIL.Contracts.Enums.DeliveryTypes DeliveryType in Enum.GetValues(typeof(FIL.Contracts.Enums.DeliveryTypes))) { DeliveryTypes.Add(DeliveryType.ToString()); } var eventDetail = _eventDetailRepository.GetAllByEventId(eventData.Id); var eventDetailModel = AutoMapper.Mapper.Map <List <FIL.Contracts.Models.EventDetail> >(eventDetail).Where(s => s.IsEnabled == true).ToList(); var eventTicketDetils = _eventTicketDetail.GetByEventDetailId(eventDetail.ElementAt(0).Id).Where(s => s.IsEnabled == true); var eventAttribute = _eventAttributeRepository.GetByEventDetailId(eventDetail.FirstOrDefault().Id); var EventTicketDetailTicketCategoryTypeMappingDataModel = _eventTicketDetailTicketCategoryTypeMappingRepository.GetByEventTicketDetails(eventTicketDetils.Select(s => s.Id).ToList()).Where(s => s.IsEnabled == true); var EventTicketDetailTicketCategoryTypeMappingModel = AutoMapper.Mapper.Map <List <FIL.Contracts.Models.EventTicketDetailTicketCategoryTypeMapping> >(EventTicketDetailTicketCategoryTypeMappingDataModel); var ticketCategories = _ticketCategoryRepository.GetByTicketCategoryIds(eventTicketDetils.Select(s => s.TicketCategoryId)).Where(s => s.IsEnabled == true); var placeCustomerDocumentTypes = _placeCustomerDocumentTypeMappingRepository.GetAllByEventId(eventData.Id); var placeCustomerDocumentTypeModel = AutoMapper.Mapper.Map <List <FIL.Contracts.Models.PlaceCustomerDocumentTypeMapping> >(placeCustomerDocumentTypes); var placeTicketRedemptionDetails = _placeTicketRedemptionDetailRepository.GetAllByEventDetailIds(eventDetail.Select(s => s.Id)); var placeTicketRedemptionDetailModel = AutoMapper.Mapper.Map <List <FIL.Contracts.Models.PlaceTicketRedemptionDetail> >(placeTicketRedemptionDetails); var placeDeliveryTypes = _eventDeliveryTypeDetailRepository.GetByEventDetailId(eventDetail.ElementAt(0).Id); var placeDeliveryTypesModel = AutoMapper.Mapper.Map <List <FIL.Contracts.Models.EventDeliveryTypeDetail> >(placeDeliveryTypes); var customerDoumentType = _customerDocumentTypeRepository.GetAll(); var customerDoumentTypeModel = AutoMapper.Mapper.Map <List <FIL.Contracts.Models.CustomerDocumentType> >(customerDoumentType); var placeHolidayDates = _placeHolidydates.GetAllByEventId(eventData.Id); var placeHolidayDatesModel = AutoMapper.Mapper.Map <List <FIL.Contracts.Models.PlaceHolidayDate> >(placeHolidayDates); var placeWeekOffs = _placeWeekOffRepository.GetAllByEventId(eventData.Id); var placeWeekOffsModel = AutoMapper.Mapper.Map <List <FIL.Contracts.Models.PlaceWeekOff> >(placeWeekOffs); var customerInformationMapping = _customerInformationRepository.GetAll(); var customerInformationMappingModel = AutoMapper.Mapper.Map <List <FIL.Contracts.Models.CustomerInformation> >(customerInformationMapping); var eventCustomerInformationMapping = _eventCustomerInformationMappingRepository.GetAllByEventID(eventModel.Id).ToList(); List <FIL.Contracts.Models.EventCustomerInformationMapping> eventCustomerInformationMappingModel = new List <Contracts.Models.EventCustomerInformationMapping>();; if (eventCustomerInformationMapping.Count() > 0) { eventCustomerInformationMappingModel = AutoMapper.Mapper.Map <List <FIL.Contracts.Models.EventCustomerInformationMapping> >(eventCustomerInformationMapping); } List <FIL.Contracts.DataModels.EventTicketDetail> etdList = new List <FIL.Contracts.DataModels.EventTicketDetail>(); foreach (FIL.Contracts.DataModels.EventTicketDetail currentTicketCat in eventTicketDetils.ToList()) { /*--------------- Add those ETD whose eventticketdetail and ETA exists */ var etaData = _eventTicketAttribute.GetByEventTicketDetailIdFeelAdmin(currentTicketCat.Id); if (etaData != null) { etdList.Add(currentTicketCat); } } var ticketCategoryContainer = etdList.Select(td => { try { var ticketDetailModel = AutoMapper.Mapper.Map <FIL.Contracts.Models.EventTicketDetail>(td); var ticketCategory = _ticketCategoryRepository.Get((int)td.TicketCategoryId); var ticketCategoryModel = AutoMapper.Mapper.Map <FIL.Contracts.Models.TicketCategory>(ticketCategory); var eventTicketAttributes = _eventTicketAttribute.GetByEventTicketDetailIdFeelAdmin(td.Id); var eventTicketAttributeModel = AutoMapper.Mapper.Map <FIL.Contracts.Models.EventTicketAttribute>(eventTicketAttributes); var TicketCategoryTypeTypeMapping = _eventTicketDetailTicketCategoryTypeMappingRepository.GetByEventTicketDetail(td.Id); var ticketFeeDetail = _ticketFeeDetailRepository.GetAllByEventTicketAttributeId(eventTicketAttributeModel.Id); var ticketFeeDetailModel = AutoMapper.Mapper.Map <List <FIL.Contracts.Models.TicketFeeDetail> >(ticketFeeDetail); return(new TicketCategoryInfo { TicketCategory = ticketCategoryModel, EventTicketAttribute = eventTicketAttributeModel, EventTicketDetail = ticketDetailModel, TicketCategorySubTypeId = (TicketCategoryTypeTypeMapping != null ? TicketCategoryTypeTypeMapping.TicketCategorySubTypeId : 1), TicketCategoryTypeId = (TicketCategoryTypeTypeMapping != null ? TicketCategoryTypeTypeMapping.TicketCategoryTypeId : 1), TicketFeeDetails = ticketFeeDetailModel }); } catch (Exception e) { return(new TicketCategoryInfo { }); } }).ToList(); var data = _calendarProvider.GetCalendarData(eventData.Id); return(new GetPlaceInventoryQueryResult { Event = eventModel, EventDetails = eventDetailModel, TicketCategoryContainer = ticketCategoryContainer, PlaceCustomerDocumentTypeMappings = placeCustomerDocumentTypeModel, DeliveryTypes = DeliveryTypes, eventDeliveryTypeDetails = placeDeliveryTypesModel, EventTicketDetailTicketCategoryTypeMappings = EventTicketDetailTicketCategoryTypeMappingModel, PlaceTicketRedemptionDetails = placeTicketRedemptionDetailModel, TicketValidityTypes = TicketValidityTypes, CustomerDocumentTypes = customerDoumentTypeModel, PlaceHolidayDates = placeHolidayDatesModel, PlaceWeekOffs = placeWeekOffsModel, CustomerInformations = customerInformationMappingModel, EventCustomerInformationMappings = eventCustomerInformationMappingModel, RegularTimeModel = data.RegularTimeModel, SeasonTimeModel = data.SeasonTimeModel, SpecialDayModel = data.SpecialDayModel, EventAttribute = eventAttribute }); } catch (Exception e) { return(new GetPlaceInventoryQueryResult { }); } }
public async Task <ASIBookingResponse> saveASIData(ASIBooking aSIBooking) { var transactionData = _transactionRepository.Get(aSIBooking.TransactionId); var transactionDetails = _transactionDetailRepository.GetByTransactionId(aSIBooking.TransactionId); List <Visitor> visitors = new List <Visitor>(); List <ASIHash> aSIHashes = new List <ASIHash>(); RootObject rootObject = new RootObject(); foreach (FIL.Contracts.DataModels.TransactionDetail currentTransactionDetail in transactionDetails) { var clientETAData = aSIBooking.EventTicketAttributeList.Where(s => s.Id == currentTransactionDetail.EventTicketAttributeId && (TicketType)currentTransactionDetail.TicketTypeId == s.TicketType).FirstOrDefault(); if (clientETAData != null) { foreach (FIL.Contracts.Commands.Transaction.GuestUserDetail currentGuestDetail in clientETAData.GuestDetails) { _saveGuestUserProvider.SaveGuestUsers(currentGuestDetail, currentTransactionDetail); } _aSITransactionDetailTimeSlotIdMappingRepository.Save(new FIL.Contracts.DataModels.ASI.ASITransactionDetailTimeSlotIdMapping { EventTimeSlotMappingId = (long)clientETAData.VisitTimeId, TransactionDetailId = currentTransactionDetail.Id, IsEnabled = true, CreatedUtc = DateTime.UtcNow, UpdatedUtc = DateTime.UtcNow }); _transactionDeliveryDetailRepository.Save(new TransactionDeliveryDetail { TransactionDetailId = currentTransactionDetail.Id, DeliveryTypeId = DeliveryTypes.PrintAtHome, PickupBy = 1, SecondaryName = "Zoonga", SecondaryContact = "Zoonga", SecondaryEmail = transactionData.EmailId, PickUpAddress = "Zoonga" }); } } // This is separate loop for API request payload..... I don't think we need to manage data from above loop... Better to keep it separate foreach (FIL.Contracts.DataModels.TransactionDetail currentTransactionDetail in transactionDetails) { var guestData = _guestDetailRepository.GetByTransactionDetailId(currentTransactionDetail.Id); var asiTicketAttribute = aSIBooking.EventTicketAttributeList.Where(s => s.Id == currentTransactionDetail.EventTicketAttributeId).FirstOrDefault(); if (guestData.Any()) { var currentETA = _eventTicketAttributeRepository.Get(currentTransactionDetail.EventTicketAttributeId); var currentETD = _eventTicketDetailRepository.Get(currentETA.EventTicketDetailId); var currentTc = _ticketCategoryRepository.Get((int)currentETD.TicketCategoryId); var currentED = _eventDetailRepository.Get(currentETD.EventDetailId); var currentE = _eventRepository.Get(currentED.EventId); var asiETableMapping = _aSIMonumentEventTableMappingRepository.GetByEventId(currentE.Id); var asiMonument = _aSIMonumentRepository.Get(asiETableMapping.ASIMonumentId); var asiMonumentDetail = _aSIMonumentDetailRepository.GetByNameAndMonumentId(currentED.Name, asiMonument.Id); var asiTimeSlot = _aSITransactionDetailTimeSlotIdMappingRepository.GetByTransactionDetailId(currentTransactionDetail.Id); var eventTimeSlot = _eventTimeSlotMappingRepository.Get(asiTimeSlot.EventTimeSlotMappingId); //api.key |[monument.code | optional | date | age | country | amount] |[monument.code | optional | date | age | country | amount] | api.salt foreach (FIL.Contracts.DataModels.GuestDetail currentGuestDetail in guestData) { Visitor visitor = new Visitor(); ASIHash aSIHash = new ASIHash(); Identity indentity = new Identity(); Monument monument = new Monument(); Nationality nationality = new Nationality(); Timeslot timeslot = new Timeslot(); visitor.Identity = indentity; visitor.Monument = monument; visitor.Monument.Timeslot = timeslot; visitor.Nationality = nationality; var custerDocType = _customerDocumentTypeRepository.Get(currentGuestDetail.CustomerDocumentTypeId); visitor.Age = Convert.ToInt32(currentGuestDetail.Age); visitor.VisitorId = currentGuestDetail.Id.ToString(); visitor.Amount = currentTransactionDetail.PricePerTicket; visitor.Gender = currentGuestDetail.GenderId.ToString(); visitor.Name = currentGuestDetail.FirstName + " " + currentGuestDetail.LastName; visitor.Date = ((System.DateTime)currentTransactionDetail.VisitDate).ToString("yyyy'-'MM'-'dd'T'HH':'mm':'ss'.'fff'Z'"); visitor.Identity.Type = custerDocType.DocumentType; visitor.Identity.No = currentGuestDetail.DocumentNumber; visitor.Monument.Code = "TAJ"; visitor.Monument.Optional = asiMonumentDetail.IsOptional; visitor.Monument.Main = true; visitor.Monument.Timeslot.Id = eventTimeSlot.TimeSlotId; visitor.Nationality.Group = currentTc.Name; visitor.Nationality.Country = asiTicketAttribute == null ? "India" : asiTicketAttribute.ASIUserSelectedCountry; visitors.Add(visitor); aSIHash.Code = asiMonument.Code; aSIHash.IsOptional = asiMonumentDetail.IsOptional; aSIHash.Date = (System.DateTime)currentTransactionDetail.VisitDate; aSIHash.Nationality = currentTc.Name; aSIHash.Age = Convert.ToInt32(currentGuestDetail.Age); aSIHash.Amount = currentTransactionDetail.PricePerTicket; aSIHash.IdentityType = "Passport"; aSIHash.IdentityNumber = "SADFG"; aSIHash.VisitorId = currentGuestDetail.Id.ToString(); aSIHashes.Add(aSIHash); } } } var ticketHash = ""; foreach (FIL.Contracts.Models.ASI.ASIHash currentHash in aSIHashes) { TimeZoneInfo INDIAN_ZONE; try { INDIAN_ZONE = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time"); } catch (Exception e) { INDIAN_ZONE = TimeZoneInfo.FindSystemTimeZoneById("Asia/Kolkata"); } DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(currentHash.Date, INDIAN_ZONE); var time = indianTime.ToUniversalTime().ToString("yyyy'-'MM'-'dd'T'HH':'mm':'ss'.'fff'Z'"); ticketHash = ticketHash + "[" + currentHash.Code + "|" + (!currentHash.IsOptional).ToString().ToLower() + "|" + currentHash.IsOptional.ToString().ToLower() + "|" + indianTime.ToString("yyyy-MM-dd") + "|" + currentHash.Age + "|" + currentHash.Nationality + "|" + currentHash.Amount.ToString("0.00") + "]" + "|"; //ticketHash = ticketHash + "[" + "TAJ" + "|" + time + "|" + currentHash.IdentityType + "|" + currentHash.IdentityNumber + "|" + currentHash.Age + "|" + currentHash.Nationality + "|" + currentHash.Amount.ToString("0.00") + "|" + currentHash.VisitorId + "]" + "|"; } var bookingHashRequestData = _settings.GetConfigSetting <string>(SettingKeys.Integration.ASI.APIKey) + "|" + ticketHash + _settings.GetConfigSetting <string>(SettingKeys.Integration.ASI.APISalt); var bookingHash = GenerateSHA512Hash(bookingHashRequestData); rootObject.TransactionId = aSIBooking.TransactionId.ToString(); rootObject.Hash = bookingHash.ToLower(); rootObject.Visitors = visitors; rootObject.Email = transactionData.EmailId == "*****@*****.**" ? transactionData.PhoneNumber : transactionData.EmailId; UserCardDetail userCardDetail = _userCardDetailRepository.GetByUserCardNumber(string.Empty, aSIBooking.UserId); if (userCardDetail == null) { UserCardDetail obj = new UserCardDetail { UserId = aSIBooking.UserId, AltId = new Guid(), NameOnCard = string.Empty, CardNumber = string.Empty, ExpiryMonth = 12, ExpiryYear = 2020, CardTypeId = CardType.None }; userCardDetail = _userCardDetailRepository.Save(obj); } _transactionPaymentDetailRepository.Save(new TransactionPaymentDetail // Create transaction payment request before calling booking POST API request... { TransactionId = aSIBooking.TransactionId, PaymentOptionId = PaymentOptions.None, PaymentGatewayId = PaymentGateway.Payu, UserCardDetailId = userCardDetail.Id, RequestType = "Charge Posting", Amount = transactionData.NetTicketAmount.ToString(), PayConfNumber = "", PaymentDetail = "{\"Request\":" + Newtonsoft.Json.JsonConvert.SerializeObject(rootObject) + "{\"hashparameter\":" + bookingHashRequestData + "}}", }); var baseAddress = _settings.GetConfigSetting <string>(SettingKeys.Integration.ASI.IntegrationRoot).ToString() + "" + _settings.GetConfigSetting <string>(SettingKeys.Integration.ASI.APIKey).ToString(); return(new ASIBookingResponse { RootObject = rootObject, ReturnUrl = baseAddress }); }
protected override async Task Handle(SaveEventScheduleCommand command) { foreach (var eventDetail in command.SubEventList) { var eventDetailData = new EventDetail(); if (eventDetail.id == 0) // check for create or edit insert if 0 { eventDetailData = new FIL.Contracts.DataModels.EventDetail { Name = eventDetail.name, EventId = eventDetail.eventId, AltId = Guid.NewGuid(), VenueId = eventDetail.venueId, MetaDetails = null, Description = eventDetail.Description, GroupId = 1, StartDateTime = DateTime.Parse(eventDetail.startDateTime), EndDateTime = DateTime.Parse(eventDetail.endDateTime), IsEnabled = false, CreatedUtc = DateTime.UtcNow, ModifiedBy = command.userAltId }; _eventDetailRepository.Save(eventDetailData); } else // update sub event { eventDetailData = _eventDetailRepository.Get(eventDetail.id); eventDetailData.Name = eventDetail.name; eventDetailData.EventId = eventDetail.eventId; eventDetailData.VenueId = eventDetail.venueId; eventDetailData.Description = eventDetail.Description; eventDetailData.StartDateTime = DateTime.Parse(eventDetail.startDateTime); eventDetailData.EndDateTime = DateTime.Parse(eventDetail.endDateTime); eventDetailData.ModifiedBy = command.userAltId; _eventDetailRepository.Save(eventDetailData); } //check for existing delivery type details var deliveryTypeData = _eventDeliveryTypeDetailRepository.GetByEventDetailId(eventDetailData.Id); if (deliveryTypeData.Count() > 0) { foreach (var newDeliveryType in deliveryTypeData) { //update existing delivery type details if (Convert.ToInt16(newDeliveryType.DeliveryTypeId) != command.DeliveryValue) { var deliveryValue = _eventDeliveryTypeDetailRepository.Get(newDeliveryType.Id); deliveryValue.DeliveryTypeId = (DeliveryTypes)command.DeliveryValue; _eventDeliveryTypeDetailRepository.Save(deliveryValue); } } } else // insert new deliveryType { var deliveryType = new FIL.Contracts.DataModels.EventDeliveryTypeDetail { EventDetailId = eventDetailData.Id, DeliveryTypeId = (DeliveryTypes)command.DeliveryValue, Notes = "<p><strong>Delivery<br /></strong>Ticket packages are shipped to your preferred address (signature upon receival required), or are arranged for a secure pickup location at or near the circuit.</p>", EndDate = DateTime.UtcNow, IsEnabled = true, CreatedUtc = DateTime.UtcNow, ModifiedBy = command.userAltId, }; _eventDeliveryTypeDetailRepository.Save(deliveryType); } var matchAttributeData = _matchAttributeRepository.GetByEventDetailId(eventDetail.id); if (matchAttributeData.Count() > 0) { foreach (var oldMatchAttribute in matchAttributeData) { foreach (var newMatchAttribute in eventDetail.matches) { if (oldMatchAttribute.Id == newMatchAttribute.id) { var updatedMatchAttribute = _matchAttributeRepository.Get(newMatchAttribute.id); updatedMatchAttribute.TeamA = newMatchAttribute.teamA; updatedMatchAttribute.TeamB = newMatchAttribute.teamB; updatedMatchAttribute.MatchNo = newMatchAttribute.matchNo; updatedMatchAttribute.MatchDay = newMatchAttribute.matchDay; updatedMatchAttribute.MatchStartTime = DateTime.Parse(newMatchAttribute.startDateTime); _matchAttributeRepository.Save(updatedMatchAttribute); } } } } else { //check for not null if (eventDetail.matches.Count > 0) { foreach (var match in eventDetail.matches) { //check for if team is exits if not insert new var teamA = match.teamA != 0 ? _teamRepository.Get(match.teamA) : _teamRepository.Save( new Team { Name = match.teamAName, AltId = Guid.NewGuid(), IsEnabled = true, Description = "", CreatedUtc = DateTime.UtcNow, UpdatedUtc = DateTime.UtcNow, CreatedBy = command.userAltId, UpdatedBy = command.userAltId } ); var teamB = match.teamB != 0 ? _teamRepository.Get(match.teamB) : _teamRepository.Save( new Team { Name = match.teamBName, AltId = Guid.NewGuid(), IsEnabled = true, Description = "", CreatedUtc = DateTime.UtcNow, UpdatedUtc = DateTime.UtcNow, CreatedBy = command.userAltId, UpdatedBy = command.userAltId } ); var matchAttribute = new FIL.Contracts.DataModels.MatchAttribute { EventDetailId = eventDetailData.Id, TeamA = teamA.Id, TeamB = teamB.Id, MatchNo = match.matchNo, MatchDay = match.matchDay, IsEnabled = true, MatchStartTime = DateTime.Parse(match.startDateTime), CreatedUtc = DateTime.UtcNow, CreatedBy = command.userAltId, ModifiedBy = command.userAltId }; _matchAttributeRepository.Save(matchAttribute); } } } var TicketDetailData = _eventTicketDetailRepository.GetByEventDetailId(eventDetail.id); if (TicketDetailData.Count() > 0) { foreach (var oldTicketCategory in TicketDetailData) { var newEventTicketDetail = eventDetail.ticketCategories.Where(s => s.id == oldTicketCategory.Id).FirstOrDefault(); if (newEventTicketDetail != null) { //update existing eventTicketDetail var updatedEventTicketDetail = _eventTicketDetailRepository.Get(newEventTicketDetail.id); updatedEventTicketDetail.TicketCategoryId = newEventTicketDetail.ticketCategoryId; _eventTicketDetailRepository.Save(updatedEventTicketDetail); //update event ticket attributes var updatedTicketAttibutesData = _eventTicketAttributeRepository.GetByEventTicketDetailId(updatedEventTicketDetail.Id); updatedTicketAttibutesData.AvailableTicketForSale = newEventTicketDetail.capacity; updatedTicketAttibutesData.RemainingTicketForSale = newEventTicketDetail.capacity; updatedTicketAttibutesData.Price = newEventTicketDetail.price; updatedTicketAttibutesData.LocalPrice = newEventTicketDetail.price; updatedTicketAttibutesData.CurrencyId = newEventTicketDetail.currencyId; updatedTicketAttibutesData.LocalCurrencyId = newEventTicketDetail.currencyId; _eventTicketAttributeRepository.Save(updatedTicketAttibutesData); //get exisiting ticket fee details var oldticketFeeDetailData = _ticketFeeDetailRepository.GetAllByEventTicketAttributeId(updatedTicketAttibutesData.Id).ToList(); foreach (var feeType in command.FeeTypes) { if (feeType.id == 0) { var ticketFeeDetailData = new FIL.Contracts.DataModels.TicketFeeDetail { EventTicketAttributeId = updatedTicketAttibutesData.Id, FeeId = (Int16)feeType.feeId, DisplayName = feeType.displayName, ValueTypeId = (Int16)feeType.valueTypeId, Value = feeType.value, IsEnabled = true, CreatedUtc = DateTime.UtcNow, CreatedBy = command.userAltId }; _ticketFeeDetailRepository.Save(ticketFeeDetailData); } } if (oldticketFeeDetailData.Count() > 0) { foreach (var oldTicketFeeDetail in oldticketFeeDetailData) { var newTicketFeeDetail = command.FeeTypes.Where(s => s.id == oldTicketFeeDetail.Id).FirstOrDefault(); if (newTicketFeeDetail != null) { var updatedTicketFeeDetail = _ticketFeeDetailRepository.Get(oldTicketFeeDetail.Id); updatedTicketFeeDetail.FeeId = Convert.ToInt16(newTicketFeeDetail.feeId); updatedTicketFeeDetail.ValueTypeId = Convert.ToInt16(newTicketFeeDetail.valueTypeId); updatedTicketFeeDetail.Value = newTicketFeeDetail.value; _ticketFeeDetailRepository.Save(updatedTicketFeeDetail); } else { var updatedTicketFeeDetail = _ticketFeeDetailRepository.Get(oldTicketFeeDetail.Id); updatedTicketFeeDetail.IsEnabled = false; _ticketFeeDetailRepository.Save(updatedTicketFeeDetail); } } } } else { var updatedEventTicketDetail = _eventTicketDetailRepository.Get(oldTicketCategory.Id); updatedEventTicketDetail.IsEnabled = false; _eventTicketDetailRepository.Save(updatedEventTicketDetail); } } } if (eventDetail.ticketCategories.Count > 0) { foreach (var eventTicketDetail in eventDetail.ticketCategories) { if (eventTicketDetail.id == 0) // insert new category { //check for if ticket category is exits if not insert new var ticketCategory = eventTicketDetail.ticketCategoryId != 0 ? _ticketCategoryRepository.Get(eventTicketDetail.ticketCategoryId) : _ticketCategoryRepository.Save( new TicketCategory { Name = eventTicketDetail.ticketCategoryName, IsEnabled = true, CreatedUtc = DateTime.UtcNow, UpdatedUtc = DateTime.UtcNow, CreatedBy = command.userAltId, UpdatedBy = command.userAltId } ); //insert new ticket detail data var eventTicketDetailData = new FIL.Contracts.DataModels.EventTicketDetail { EventDetailId = eventDetailData.Id, TicketCategoryId = ticketCategory.Id, IsEnabled = true, CreatedUtc = DateTime.UtcNow, CreatedBy = command.userAltId, ModifiedBy = command.userAltId, IsBOEnabled = false }; _eventTicketDetailRepository.Save(eventTicketDetailData); //save event ticket attributes var eventTicketAttibutesData = new FIL.Contracts.DataModels.EventTicketAttribute { EventTicketDetailId = eventTicketDetailData.Id, CurrencyId = eventTicketDetail.currencyId, TicketTypeId = FIL.Contracts.Enums.TicketType.Adult, ChannelId = FIL.Contracts.Enums.Channels.Website, AvailableTicketForSale = eventTicketDetail.capacity, RemainingTicketForSale = eventTicketDetail.capacity, Price = eventTicketDetail.price, LocalPrice = eventTicketDetail.price, CreatedUtc = DateTime.UtcNow, CreatedBy = command.userAltId, IsEnabled = true, IsEMIApplicable = false, IsInternationalCardAllowed = false, IsSeatSelection = false, ViewFromStand = "", TicketCategoryDescription = "", LocalCurrencyId = eventTicketDetail.currencyId, SalesStartDateTime = DateTime.UtcNow, SalesEndDatetime = DateTime.UtcNow, }; _eventTicketAttributeRepository.Save(eventTicketAttibutesData); if (command.FeeTypes.Count > 0) { foreach (var feeType in command.FeeTypes) { //save ticket fee details var ticketFeeDetailData = new FIL.Contracts.DataModels.TicketFeeDetail { EventTicketAttributeId = eventTicketAttibutesData.Id, FeeId = (Int16)feeType.feeId, DisplayName = feeType.displayName, ValueTypeId = (Int16)feeType.valueTypeId, Value = feeType.value, IsEnabled = true, CreatedUtc = DateTime.UtcNow, CreatedBy = command.userAltId }; _ticketFeeDetailRepository.Save(ticketFeeDetailData); } } } } } } }
public CheckoutCommandResult SaveTransaction(CheckoutCommand checkoutCommand, IEnumerable <Contracts.Models.EventTicketAttribute> eventTicketAttributeModel, FIL.Contracts.DataModels.User user) { try { var isPaymentBypass = false; var StripeAccount = FIL.Contracts.Enums.StripeAccount.None; List <TransactionDetail> transactionDetailList = new List <TransactionDetail>(); List <FIL.Contracts.Models.CartItemModel> lstEventDetailId = new List <FIL.Contracts.Models.CartItemModel>(); FIL.Contracts.DataModels.Transaction transaction = new FIL.Contracts.DataModels.Transaction(); decimal grossTicketAmount = 0; long eventDetailId = 0, ticketCategoryId = 0; decimal netTicketAmount = 0; decimal totalDiscountAmount = 0; if (checkoutCommand.IsASI == null) { checkoutCommand.IsASI = false; } var allETD = _eventTicketDetailRepository.GetByEventTicketDetailsIds(eventTicketAttributeModel.Select(s => s.EventTicketDetailId).Distinct()).Distinct(); var allED = _eventDetailRepository.GetByIds(allETD.Select(s => s.EventDetailId).Distinct()).Distinct(); foreach (Contracts.Commands.Transaction.EventTicketAttribute ticketAttributes in checkoutCommand.EventTicketAttributeList) { var currentTA = ticketAttributes; var transactionType = checkoutCommand.IsQrTransaction ? TransactionType.QRCode : checkoutCommand.TransactionType == TransactionType.Itinerary ? TransactionType.Itinerary : ticketAttributes.TicketType == TicketType.SeasonPackage ? TransactionType.Season : ticketAttributes.TransactionType == TransactionType.LiveOnline ? TransactionType.LiveOnline : ticketAttributes.TransactionType == TransactionType.AddOns ? TransactionType.AddOns : TransactionType.Regular; decimal discountAmount = 0, donationAmount = 0; if (ticketAttributes.DiscountedPrice > 0) { discountAmount = ticketAttributes.DiscountedPrice; } if (ticketAttributes.DonationAmount != null && ticketAttributes.DonationAmount > 0) { donationAmount = (decimal)ticketAttributes.DonationAmount; } Contracts.Models.EventTicketAttribute checkoutCommandEventTicketAttribute = eventTicketAttributeModel.Where(w => w.Id == ticketAttributes.Id).FirstOrDefault(); decimal pricePerTicket = checkoutCommandEventTicketAttribute.Price; EventTicketDetail eventTicketDetail = allETD.Where(s => s.Id == checkoutCommandEventTicketAttribute.EventTicketDetailId && s.IsEnabled).FirstOrDefault(); if (eventTicketDetail != null) { EventDetail eventDetail = allED.Where(s => s.Id == eventTicketDetail.EventDetailId && s.IsEnabled).FirstOrDefault(); if (eventDetail != null) { var visitStartDate = ticketAttributes.VisitDate; var visitEndDate = ticketAttributes.VisitDate; if (checkoutCommand.TransactionType == TransactionType.Itinerary) { visitStartDate = ticketAttributes.VisitStartTime.Split(":").Count() > 1 ? new DateTime(visitStartDate.Year, visitStartDate.Month, visitStartDate.Day, Convert.ToInt32(ticketAttributes.VisitStartTime.Split(":")[0]), Convert.ToInt32(ticketAttributes.VisitStartTime.Split(":")[1]), 0) : visitStartDate; visitEndDate = ticketAttributes.VisitEndTime.Split(":").Count() > 1 ? new DateTime(visitEndDate.Year, visitEndDate.Month, visitEndDate.Day, Convert.ToInt32(ticketAttributes.VisitEndTime.Split(":")[0]), Convert.ToInt32(ticketAttributes.VisitEndTime.Split(":")[1]), 0) : visitEndDate; } visitStartDate = visitStartDate < new DateTime(1753, 1, 1) ? DateTime.UtcNow : visitStartDate; visitEndDate = visitEndDate < new DateTime(1753, 1, 1) ? DateTime.UtcNow : visitEndDate; if ((bool)checkoutCommand.IsASI) { pricePerTicket = ticketAttributes.TicketType == TicketType.Child ? 0 : checkoutCommandEventTicketAttribute.Price; } if (ticketAttributes.OverridedAmount != null && checkoutCommand.IsBSPUpgrade && ticketAttributes.OverridedAmount != 0) { pricePerTicket = (decimal)ticketAttributes.OverridedAmount; } if (ticketAttributes.TicketType == TicketType.SeasonPackage) { eventDetailId = eventTicketDetail.EventDetailId; lstEventDetailId.Add(new FIL.Contracts.Models.CartItemModel { EventDetailId = eventDetailId }); ticketCategoryId = eventTicketDetail.TicketCategoryId; IEnumerable <EventDetail> seasonEventDetails = _eventDetailRepository.GetSeasonEventDetails(eventDetail.EventId, eventDetail.VenueId).Where(s => s.IsEnabled == true); IEnumerable <EventTicketDetail> seasonEventTicketDetails = _eventTicketDetailRepository.GetByEventDetailIds(seasonEventDetails.Select(s => s.Id).Distinct()).Where(w => w.TicketCategoryId == eventTicketDetail.TicketCategoryId); List <Contracts.DataModels.EventTicketAttribute> seasonEventTicketAttributes = _eventTicketAttributeRepository.GetByEventTicketDetailIds(seasonEventTicketDetails.Select(s => s.Id).Distinct()).Where(W => W.IsEnabled == true && W.SeasonPackage == true).ToList(); var seasonPrice = seasonEventTicketAttributes[0].SeasonPackagePrice; pricePerTicket = seasonPrice / seasonEventTicketAttributes.Count; } else { eventDetailId = eventDetail.Id; lstEventDetailId.Add(new FIL.Contracts.Models.CartItemModel { EventDetailId = eventTicketDetail.EventDetailId }); ticketCategoryId = eventTicketDetail.TicketCategoryId; } if (Convert.ToInt16(ticketAttributes.TotalTickets) <= checkoutCommandEventTicketAttribute.RemainingTicketForSale) { TransactionDetail transactionDetail = new TransactionDetail(); transactionDetail.EventTicketAttributeId = ticketAttributes.Id; transactionDetail.TotalTickets = Convert.ToInt16(ticketAttributes.TotalTickets); transactionDetail.PricePerTicket = checkoutCommand.TransactionType == TransactionType.Itinerary ? ticketAttributes.Price : pricePerTicket; transactionDetail.DiscountAmount = discountAmount; transactionDetail.VisitDate = visitStartDate; transactionDetail.VisitEndDate = visitEndDate; transactionDetail.TransactionType = transactionType; transactionDetail.TicketTypeId = checkoutCommand.TransactionType == TransactionType.Itinerary ? (short)(ticketAttributes.IsAdult ? 10 : 2) : (short)(TicketType)ticketAttributes.TicketType; if (checkoutCommand.ReferralId != null) { var referral = _referralProvider.GetReferral(checkoutCommand.ReferralId, eventDetail.EventId, checkoutCommand.ModifiedBy); if (referral != null && referral.Id != 0) { transactionDetail.ReferralId = referral.Id; } } if (checkoutCommand.ChannelId == Channels.Feel && checkoutCommand.TransactionType != TransactionType.Itinerary) { _geoCurrency.UpdateTransactionUpdates(transactionDetail, checkoutCommand.TargetCurrencyCode, checkoutCommandEventTicketAttribute.CurrencyId); } if (donationAmount > 0) // Donation doesn't need the local currency as the amount itself in the local currency { transactionDetail.PricePerTicket = transactionDetail.PricePerTicket + donationAmount; } netTicketAmount += ((ticketAttributes.TotalTickets * (decimal)transactionDetail.PricePerTicket) - ((decimal)transactionDetail.DiscountAmount)); grossTicketAmount += ((ticketAttributes.TotalTickets * transactionDetail.PricePerTicket)); totalDiscountAmount += (decimal)transactionDetail.DiscountAmount; transactionDetail.MembershipId = ticketAttributes.MembershipId; transactionDetailList.Add(transactionDetail); } else { EventDetail eventDetails = _eventDetailRepository.Get(eventDetailId); Contracts.DataModels.TicketCategory ticketCategory = _ticketCategoryRepository.Get((int)ticketCategoryId); return(new CheckoutCommandResult { Id = 0, Success = false, EventName = eventDetails.Name, TicketCategoryName = ticketAttributes.TicketType == TicketType.SeasonPackage ? "Season - " + ticketCategory.Name : ticketCategory.Name, IsTransactionLimitExceed = false, IsTicketCategorySoldOut = true }); } } else { EventDetail eventDetails = _eventDetailRepository.Get(eventDetailId); Contracts.DataModels.TicketCategory ticketCategory = _ticketCategoryRepository.Get((int)ticketCategoryId); return(new CheckoutCommandResult { Id = 0, Success = false, EventName = eventDetails.Name, TicketCategoryName = ticketAttributes.TicketType == TicketType.SeasonPackage ? "Season - " + ticketCategory.Name : ticketCategory.Name, IsTransactionLimitExceed = false, IsTicketCategorySoldOut = true }); } } else { EventDetail eventDetails = _eventDetailRepository.Get(eventDetailId); Contracts.DataModels.TicketCategory ticketCategory = _ticketCategoryRepository.Get((int)ticketCategoryId); return(new CheckoutCommandResult { Id = 0, Success = false, EventName = eventDetails.Name, TicketCategoryName = ticketAttributes.TicketType == TicketType.SeasonPackage ? "Season - " + ticketCategory.Name : ticketCategory.Name, IsTransactionLimitExceed = false, IsTicketCategorySoldOut = true }); } } var intialCurrencyId = eventTicketAttributeModel.Select(s => s.CurrencyId).FirstOrDefault(); var currencyId = eventTicketAttributeModel.Select(s => s.CurrencyId).FirstOrDefault(); if (checkoutCommand.ChannelId == Channels.Feel) // Update the currencyId { if (checkoutCommand.TransactionType == TransactionType.Itinerary) { currencyId = _geoCurrency.GetCurrencyID(checkoutCommand.TransactionCurrency).Id; } else { currencyId = _geoCurrency.GetCurrencyID(checkoutCommand.TargetCurrencyCode).Id; } } /*if (checkoutCommand.ISRasv) // NAB test bed * { * var splitprice = netTicketAmount.ToString("0.00").Split("."); * var price = splitprice[0] + ".00"; * netTicketAmount = Convert.ToDecimal(netTicketAmount); * }*/ transaction.ChannelId = checkoutCommand.ChannelId; transaction.CurrencyId = currencyId; transaction.TotalTickets = Convert.ToInt16(checkoutCommand.EventTicketAttributeList.Sum(s => s.TotalTickets)); transaction.GrossTicketAmount = grossTicketAmount; transaction.NetTicketAmount = netTicketAmount; transaction.DiscountAmount = totalDiscountAmount; transaction.TransactionStatusId = TransactionStatus.UnderPayment; transaction.FirstName = user.FirstName; transaction.LastName = user.LastName; transaction.PhoneCode = user.PhoneCode; transaction.PhoneNumber = user.Email == "*****@*****.**" ? checkoutCommand.GuestUser.PhoneNumber : user.PhoneNumber; transaction.EmailId = user.Email == "*****@*****.**" ? checkoutCommand.GuestUser.PhoneNumber : user.Email; transaction.CountryName = !string.IsNullOrWhiteSpace(user.PhoneCode) ? _countryRepository.GetByPhoneCode(user.PhoneCode).Name : "India"; transaction.CreatedBy = user.AltId; transaction.CreatedUtc = DateTime.UtcNow; try { var ipDetail = _saveIPProvider.SaveIp(checkoutCommand.Ip); if (ipDetail != null && ipDetail.Id > 0) { transaction.IPDetailId = ipDetail.Id; } } catch (Exception e) { _logger.Log(Logging.Enums.LogCategory.Error, e); transaction.IPDetailId = 1; } transaction.ModifiedBy = user.AltId; transaction.AltId = Guid.NewGuid(); if (transaction.CurrencyId != 7) { transaction.OTP = checkoutCommand.OTPCode; } if (checkoutCommand.DonationAmount != null && checkoutCommand.DonationAmount != 0) { transaction.DonationAmount = checkoutCommand.DonationAmount; } FIL.Contracts.DataModels.Transaction transactionResult = _transactionRepository.Save(transaction); foreach (TransactionDetail transactionDetail in transactionDetailList) { transactionDetail.TransactionId = transactionResult.Id; var currentTransactionDetail = _transactionDetailRepository.Save(transactionDetail); FIL.Contracts.DataModels.EventTicketAttribute eventTicketAttribute = AutoMapper.Mapper.Map <FIL.Contracts.DataModels.EventTicketAttribute>(_eventTicketAttributeRepository.Get(transactionDetail.EventTicketAttributeId)); FIL.Contracts.DataModels.EventTicketDetail eventTicketDetail = AutoMapper.Mapper.Map <FIL.Contracts.DataModels.EventTicketDetail>(_eventTicketDetailRepository.Get(eventTicketAttribute.EventTicketDetailId)); if (Convert.ToInt16(transactionDetail.TotalTickets) <= eventTicketAttribute.RemainingTicketForSale) { eventTicketAttribute.RemainingTicketForSale -= transactionDetail.TotalTickets; _eventTicketAttributeRepository.Save(eventTicketAttribute); if (checkoutCommand.ChannelId == Channels.Website) { if (eventTicketDetail.InventoryTypeId == InventoryType.Seated || eventTicketDetail.InventoryTypeId == InventoryType.SeatedWithSeatSelection || eventTicketDetail.InventoryTypeId == InventoryType.NoneSeated) { List <Contracts.Models.TMS.SeatDetail> seatDetail = new List <Contracts.Models.TMS.SeatDetail>(); if (checkoutCommand.SeatDetails != null) { seatDetail = AutoMapper.Mapper.Map <List <Contracts.Models.TMS.SeatDetail> >(checkoutCommand.SeatDetails.Where(w => w.EventTicketDetailId == eventTicketDetail.Id)); } else { seatDetail = null; } var seatBlock = _seatBlockingProvider.BlockSeat(seatDetail, transactionDetail, eventTicketAttribute, eventTicketDetail, user.AltId, Channels.Website); if (!seatBlock.Success && seatBlock.IsSeatSoldOut) { return(new CheckoutCommandResult { Success = false, Id = 0, TransactionAltId = Guid.NewGuid(), IsTransactionLimitExceed = false, IsTicketCategorySoldOut = false, IsSeatSoldOut = true }); } } } } else { EventDetail eventDetails = _eventDetailRepository.Get(eventDetailId); Contracts.DataModels.TicketCategory ticketCategory = _ticketCategoryRepository.Get((int)ticketCategoryId); return(new CheckoutCommandResult { Id = 0, Success = false, EventName = eventDetails.Name, TicketCategoryName = transactionDetail.TicketTypeId == (short)TicketType.SeasonPackage ? "Season - " + ticketCategory.Name : ticketCategory.Name, IsTransactionLimitExceed = false, IsTicketCategorySoldOut = true }); } /* Save Transaction Schedule Detail */ var currentTicket = checkoutCommand.EventTicketAttributeList.Where(s => s.Id == currentTransactionDetail.EventTicketAttributeId).FirstOrDefault(); if (currentTicket.ScheduleDetailId != null && currentTicket.ScheduleDetailId != 0) { _saveTransactionScheduleDetailProvider.SaveTransactionScheduleDetail(currentTransactionDetail.Id, (long)currentTicket.ScheduleDetailId); } } try { if (checkoutCommand.ChannelId == Channels.Feel || checkoutCommand.ChannelId == Channels.Website) // If Live Online Transaction with 0.00 price { var @event = _eventRepository.Get(allED.FirstOrDefault().EventId); if (@event != null) { if (@event.MasterEventTypeId == Contracts.Enums.MasterEventType.Online && transaction.NetTicketAmount == 0) { _zoomMeetingProvider.CreateMeeting(transaction, true); isPaymentBypass = true; } else if (@event.MasterEventTypeId == Contracts.Enums.MasterEventType.Online) { StripeAccount = _eventStripeConnectAccountProvider.GetEventStripeAccount(allED.FirstOrDefault().EventId, checkoutCommand.ChannelId); } } } } catch (Exception e) { _logger.Log(Logging.Enums.LogCategory.Error, e); } try { /*Check if referred transactionId already upgraded to BSP or successfull transaction, if yes then don't allow another transaction using same referral/ transaction id*/ if (checkoutCommand.IsBSPUpgrade && checkoutCommand.ReferralId != null) { var transactions = _transactionRepository.GetAllSuccessfulTransactionByReferralId(checkoutCommand.ReferralId); if (transactions.Any()) { return(new CheckoutCommandResult { Id = 0, Success = false, IsBSPUpgraded = true }); } } } catch (Exception e) { _logger.Log(Logging.Enums.LogCategory.Error, e); } return(new CheckoutCommandResult { Id = transactionResult.Id, CartBookingModel = lstEventDetailId, Transaction = transactionResult, IsPaymentByPass = isPaymentBypass, Success = true, StripeAccount = StripeAccount, }); } catch (Exception e) { _logger.Log(Logging.Enums.LogCategory.Error, e); return(new CheckoutCommandResult { }); } }
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); }
public ActionResult Get(int id) { var apiResult = TryExecute(() => _ticketCategoryRepository.Get(id), "Ticket Category fetched sucessfully"); return(Json(apiResult, JsonRequestBehavior.AllowGet)); }