protected override async Task <ICommandResult> Handle(DeleteTicketCommand command) { try { var eventTicketDetail = _eventTicketDetailRepository.GetByAltId(command.ETDAltId); var etdTicketCategoryMapping = _eventTicketDetailTicketCategoryTypeMappingRepository.GeAlltByEventTicketDetail(eventTicketDetail.Id); var eventTicketAttribute = _eventTicketAttributeRepository.GetByEventTicketDetailId(eventTicketDetail.Id); var ticketFeelDetails = _ticketFeeDetailRepository.GetAllByEventTicketAttributeId(eventTicketAttribute.Id); var eventTicketDetailDiscountDetail = _eventTicketDiscountDetailRepository.GetAllByEventTicketAttributeId(eventTicketAttribute.Id); var transactionDetails = _transactionDetailRepository.GetByEventTicketAttributeId(eventTicketAttribute.Id); if (!transactionDetails.Any()) { foreach (var etdTicketCat in etdTicketCategoryMapping) { _eventTicketDetailTicketCategoryTypeMappingRepository.Delete(etdTicketCat); } foreach (var ticketFeeDetail in ticketFeelDetails) { _ticketFeeDetailRepository.Delete(ticketFeeDetail); } foreach (var etdDiscount in eventTicketDetailDiscountDetail) { _eventTicketDiscountDetailRepository.Delete(etdDiscount); } if (eventTicketAttribute != null) { _eventTicketAttributeRepository.Delete(eventTicketAttribute); } if (eventTicketDetail != null) { _eventTicketDetailRepository.Delete(eventTicketDetail); } var eventStepDetails = _stepProvider.SaveEventStepDetails(command.EventId, command.CurrentStep, command.TicketLength == 1 ? false : true, command.ModifiedBy); return(new DeleteTicketCommandResult { Success = true, CompletedStep = eventStepDetails.CompletedStep, CurrentStep = eventStepDetails.CurrentStep, }); } else { return(new DeleteTicketCommandResult { IsTicketSold = true }); } } catch (Exception e) { _logger.Log(LogCategory.Error, e); return(new DeleteTicketCommandResult { }); } }
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 { }); } }
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); } } } } } } }