private void GetBookingReferenceSetting(ConnectionInfo connectionInfo, BookingReference bookingReference) { using (VRArcadeDataAccessModel m = new VRArcadeDataAccessModel()) { VRBookingReference vbr = m.VRBookingReferences.Where(x => x.Reference == bookingReference.Reference && x.BookingDeleted == null && x.NumberOfBookingLeft > 0).FirstOrDefault(); if (vbr != null) { bookingReference.IsNonTimedTiming = vbr.IsNonTimedTiming; bookingReference.IsTimedTiming = vbr.IsTimedTiming; bookingReference.Duration = vbr.Duration; bookingReference.NumberOfBookingLeft = vbr.NumberOfBookingLeft; bookingReference.NumberOfBookingTotal = vbr.NumberOfBookingTotal; bookingReference.BookingStartTime = (vbr.BookingStartTime != null) ? (DateTime)vbr.BookingStartTime : DateTime.MinValue; bookingReference.BookingEndTime = (vbr.BookingEndTime != null) ? (DateTime)vbr.BookingEndTime : DateTime.MinValue; } else { bookingReference.Reference = ""; } VRCommandServer vcs = new VRCommandServer(VRGameSelectorServerDTO.Enums.ControlMessage.GET_BOOKING_REF_SETTING, bookingReference); SendCommandToPeer(connectionInfo, vcs); } }
public void MarkSeatsAsReserved(string trainId, BookingReference bookingReference, Seats seats) { // the place where we should adapt the domain format into the // json whatever needed by the external service to call (here, we'll call an // in-memory stub trainDataService.MarkSeatsAsReserved(trainId, bookingReference, seats); }
private void _dtClientList_RowChanged(object sender, DataRowChangeEventArgs e) { if ((bool)e.Row["UPD_REQ"] == true) { BookingReference br = new BookingReference() { ID = (int)e.Row["ID"], Reference = (string)e.Row["Reference"], Duration = _sessionLength }; NetworkFunction.GetBookingReferenceSetting(br); } }
private void NetworkFunction_OnIncommingBookingReference(object sender, EventArgs e) { BookingReference br = ((BookingReferenceEvent)e).BookingReference; this.InvokeUI(() => { DataRow[] dr = _dtClientList.Select("ID = " + br.ID); dr[0]["UPD_REQ"] = false; if (br.Reference.Length > 0 && br.NumberOfBookingLeft > 0) { DataRow[] dr2 = _dtClientList.Select("Reference = '" + br.Reference + "'"); if (dr2.Length <= br.NumberOfBookingLeft) { if (br.IsNonTimedTiming) { ((ClientActionType)dr[0]["Data"]).StartType = ClientActionType.ClientStartType.NON_TIMED_START; } else if (br.IsTimedTiming) { ((ClientActionType)dr[0]["Data"]).StartType = ClientActionType.ClientStartType.TIMED_START; ((ClientActionType)dr[0]["Data"]).Duration = br.Duration; } dr[0]["SessionStartTime"] = br.BookingStartTime.ToString("G"); } else { br.Reference = ""; ((ClientActionType)dr[0]["Data"]).StartType = ClientActionType.ClientStartType.NONE; dr[0]["SessionStartTime"] = ""; this.ShowAlertBox("Waiver Process", "Over Booking Limit!"); } } else { br.Reference = ""; ((ClientActionType)dr[0]["Data"]).StartType = ClientActionType.ClientStartType.NONE; dr[0]["SessionStartTime"] = ""; this.ShowAlertBox("Waiver Process", "Invalid Reference Number!"); } dr[0]["Reference"] = br.Reference; }); }
public void MarkSeatsAsReserved(string trainId, BookingReference bookingReference, Seats seats) { var formerSnapshot = trainSnapshots[trainId]; var newSeatsConfiguration = new List <SeatWithBookingReference>(formerSnapshot.OverallTrainCapacity); foreach (var seatWithBookingReference in formerSnapshot.SeatsWithBookingReferences) { if (seats.Contains(seatWithBookingReference.Seat)) { // must keep the new reservation id for this seat var newBookingReference = new SeatWithBookingReference(seatWithBookingReference.Seat, bookingReference); newSeatsConfiguration.Add(newBookingReference); } else { // keep the former value newSeatsConfiguration.Add(seatWithBookingReference); } } var updatedSnapshot = new TrainSnapshot(trainId, newSeatsConfiguration); trainSnapshots[trainId] = updatedSnapshot; }
public async Task <IHttpActionResult> ResetPinCode(BookingReference booking) { try { Tuple <string, string> result = await _usersController.ResetPinCode(booking.Reference); return(Ok(new BookingResult { Reference = result.Item1, Password = result.Item2 })); } catch (NotFoundException) { return(NotFound()); } catch (InvalidOperationException ex) { return(BadRequest(ex.Message)); } catch (Exception ex) { _log.Error(ex, "An unexpected exception occurred while trying to change a user's password."); throw; } }
public static void GetBookingReferenceSetting(BookingReference bookingReference) { VRCommandServer cmd = new VRCommandServer(Enums.ControlMessage.GET_BOOKING_REF_SETTING, bookingReference); SendCommandToServer(cmd); }
public async Task <EMDDetailsbyDocumentNumberRS> RetrieveEMDDetailsbyDocumentNumberItem(RetrieveEMDDetailsbyDocumentNumber query) { Stopwatch stopWatch = new Stopwatch(); stopWatch.Start(); query.filteredQueries = Program.listOfQueries["RetrieveEMDDetailsbyDocumentNumber"].ToDictionary(p => p.Key, p => p.Value); var reworkedQueries = new Dictionary <string, string>(); foreach (var kvp in query.filteredQueries) { var item = kvp.Value; item = StringOperations.ParametrizeQuery(query.EMDDetailsbyDocumentNumberRQ, item); reworkedQueries.Add(kvp.Key, item); } AmountDetail AmountDetail = new AmountDetail(); AmountDetailGroup AmountDetailGroup = new AmountDetailGroup(); BaseFareAmount BaseFareAmount = new BaseFareAmount(); BaseFareAmountGroup BaseFareAmountGroup = new BaseFareAmountGroup(); BookingReference BookingReference = new BookingReference(); BookingReferenceGroup BookingReferenceGroup = new BookingReferenceGroup(); CarrierFee CarrierFee = new CarrierFee(); CarrierFeeAmount CarrierFeeAmount = new CarrierFeeAmount(); CarrierFeeFormofPayment CarrierFeeFormofPayment = new CarrierFeeFormofPayment(); CarrierFeeFormofPaymentGroup CarrierFeeFormofPaymentGroup = new CarrierFeeFormofPaymentGroup(); CarrierFeeTaxFeeCharges CarrierFeeTaxFeeCharges = new CarrierFeeTaxFeeCharges(); CarrierFeeTaxFeeChargesGroup CarrierFeeTaxFeeChargesGroup = new CarrierFeeTaxFeeChargesGroup(); Commission Commission = new Commission(); ConstructionPrinciple ConstructionPrinciple = new ConstructionPrinciple(); CouponAttributes CouponAttributes = new CouponAttributes(); CouponSegments CouponSegments = new CouponSegments(); CustomerLoyalty CustomerLoyalty = new CustomerLoyalty(); EMDBooklets EMDBooklets = new EMDBooklets(); EMDCoupons EMDCoupons = new EMDCoupons(); EMDDetailsbyDocumentNumberRS EMDDetailsbyDocumentNumberRS = new EMDDetailsbyDocumentNumberRS(); EMDDocumentDetail EMDDocumentDetail = new EMDDocumentDetail(); EMDItinerary EMDItinerary = new EMDItinerary(); Equipment Equipment = new Equipment(); EquivalentFareAmount EquivalentFareAmount = new EquivalentFareAmount(); EquivalentFareAmountGroup EquivalentFareAmountGroup = new EquivalentFareAmountGroup(); ExchangedCoupon ExchangedCoupon = new ExchangedCoupon(); ExchangedCouponGroup ExchangedCouponGroup = new ExchangedCouponGroup(); FareCategory FareCategory = new FareCategory(); FareComponentCouponSeq FareComponentCouponSeq = new FareComponentCouponSeq(); FareComponentDetail FareComponentDetail = new FareComponentDetail(); FarePenalty FarePenalty = new FarePenalty(); FareWaiver FareWaiver = new FareWaiver(); FormOfPaymentAttribute FormOfPaymentAttribute = new FormOfPaymentAttribute(); FormofPaymentGroup FormofPaymentGroup = new FormofPaymentGroup(); FormofPayments FormofPayments = new FormofPayments(); FormOfRefund FormOfRefund = new FormOfRefund(); IntermediateStop IntermediateStop = new IntermediateStop(); MessageResult MessageResult = new MessageResult(); Passenger Passenger = new Passenger(); POS POS = new POS(); PriceableUnit PriceableUnit = new PriceableUnit(); PurchaseTransaction PurchaseTransaction = new PurchaseTransaction(); RefundExchange RefundExchange = new RefundExchange(); RefundExchangeCoupon RefundExchangeCoupon = new RefundExchangeCoupon(); RefundTaxFeeCharges RefundTaxFeeCharges = new RefundTaxFeeCharges(); RefundTaxFeeChargesGroup RefundTaxFeeChargesGroup = new RefundTaxFeeChargesGroup(); Remark Remark = new Remark(); TaxFeeCharges TaxFeeCharges = new TaxFeeCharges(); TaxFeeChargesGroup TaxFeeChargesGroup = new TaxFeeChargesGroup(); TicketDesignator TicketDesignator = new TicketDesignator(); TotalConstructionAmount TotalConstructionAmount = new TotalConstructionAmount(); TotalConstructionAmountGroup TotalConstructionAmountGroup = new TotalConstructionAmountGroup(); TotalFareAmount TotalFareAmount = new TotalFareAmount(); TotalFareAmountGroup TotalFareAmountGroup = new TotalFareAmountGroup(); TransactionHistory TransactionHistory = new TransactionHistory(); TransactionHistoryCoupons TransactionHistoryCoupons = new TransactionHistoryCoupons(); TravelDocumentFormofPayments TravelDocumentFormofPayments = new TravelDocumentFormofPayments(); TravelIdentifier TravelIdentifier = new TravelIdentifier(); TravelSegments TravelSegments = new TravelSegments(); UnstructuredFareCalcInfo UnstructuredFareCalcInfo = new UnstructuredFareCalcInfo(); foreach (var loop1 in await _context.EMDDocumentDetail.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail"]).AsNoTracking().ToListAsync()) { { foreach (var loop2 in await _context.PurchaseTransaction.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.PurchaseTransaction"]).AsNoTracking().ToListAsync()) { if ((loop2.PURCHASE_TXN_ID == loop1.PURCHASE_TXN_ID)) { loop1.PurchaseTransaction.Add(loop2); foreach (var loop3 in await _context.FormofPaymentGroup.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.PurchaseTransaction.FormofPaymentGroup"]).AsNoTracking().ToListAsync()) { if ((loop3.FOP_GROUP_ID == loop2.FOP_GROUP_ID)) { loop2.FormofPaymentGroup.Add(loop3); foreach (var loop4 in await _context.FormofPayments.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.PurchaseTransaction.FormofPaymentGroup.FormofPayments"]).AsNoTracking().ToListAsync()) { if ((loop4.FOP_GROUP_ID == loop3.FOP_GROUP_ID)) { loop3.FormofPayments.Add(loop4); foreach (var loop5 in await _context.AmountDetailGroup.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.PurchaseTransaction.FormofPaymentGroup.FormofPayments.AmountDetailGroup"]).AsNoTracking().ToListAsync()) { if ((loop5.AMOUNT_DETAIL_GROUP_ID == loop4.AMOUNT_DETAIL_GROUP_ID)) { loop4.AmountDetailGroup.Add(loop5); foreach (var loop6 in await _context.AmountDetail.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.PurchaseTransaction.FormofPaymentGroup.FormofPayments.AmountDetailGroup.AmountDetail"]).AsNoTracking().ToListAsync()) { if ((loop6.AMOUNT_DETAIL_GROUP_ID == loop5.AMOUNT_DETAIL_GROUP_ID)) { loop5.AmountDetail.Add(loop6); } } } } foreach (var loop5 in await _context.FormOfPaymentAttribute.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.PurchaseTransaction.FormofPaymentGroup.FormofPayments.FormOfPaymentAttribute"]).AsNoTracking().ToListAsync()) { if ((loop5.FOP_GROUP_ID == loop4.FOP_GROUP_ID) && (loop5.FOP_SEQ == loop4.FOP_SEQ)) { loop4.FormOfPaymentAttribute.Add(loop5); } } foreach (var loop5 in await _context.ExchangedCouponGroup.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.PurchaseTransaction.FormofPaymentGroup.FormofPayments.ExchangedCouponGroup"]).AsNoTracking().ToListAsync()) { if ((loop5.EXCH_DOC_CPN_GROUP_ID == loop4.EXCH_DOC_CPN_GROUP_ID)) { loop4.ExchangedCouponGroup.Add(loop5); foreach (var loop6 in await _context.ExchangedCoupon.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.PurchaseTransaction.FormofPaymentGroup.FormofPayments.ExchangedCouponGroup.ExchangedCoupon"]).AsNoTracking().ToListAsync()) { if ((loop6.EXCH_DOC_CPN_GROUP_ID == loop5.EXCH_DOC_CPN_GROUP_ID)) { loop5.ExchangedCoupon.Add(loop6); } } } } } } } } } } foreach (var loop2 in await _context.EMDBooklets.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.EMDBooklets"]).AsNoTracking().ToListAsync()) { if ((loop2.PRIMARY_AIRLINE_CD == loop1.PRIMARY_AIRLINE_CD) && (loop2.PRIMARY_DOCUMENT_NBR == loop1.PRIMARY_DOCUMENT_NBR) && (loop2.PRIMARY_ISSUE_DT == loop1.PRIMARY_ISSUE_DT)) { loop1.EMDBooklets.Add(loop2); foreach (var loop3 in await _context.EMDCoupons.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.EMDBooklets.EMDCoupons"]).AsNoTracking().ToListAsync()) { if ((loop3.BOOKLET_DOCUMENT_NBR == loop2.BOOKLET_DOCUMENT_NBR) && (loop3.PRIMARY_AIRLINE_CD == loop2.PRIMARY_AIRLINE_CD) && (loop3.PRIMARY_DOCUMENT_NBR == loop2.PRIMARY_DOCUMENT_NBR) && (loop3.PRIMARY_ISSUE_DT == loop2.PRIMARY_ISSUE_DT)) { loop2.EMDCoupons.Add(loop3); foreach (var loop4 in await _context.CouponAttributes.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.EMDBooklets.EMDCoupons.CouponAttributes"]).AsNoTracking().ToListAsync()) { if ((loop4.BOOKLET_DOCUMENT_NBR == loop3.BOOKLET_DOCUMENT_NBR) && (loop4.CPN_NBR == loop3.CPN_NBR) && (loop4.PRIMARY_AIRLINE_CD == loop3.PRIMARY_AIRLINE_CD) && (loop4.PRIMARY_DOCUMENT_NBR == loop3.PRIMARY_DOCUMENT_NBR) && (loop4.PRIMARY_ISSUE_DT == loop3.PRIMARY_ISSUE_DT)) { loop3.CouponAttributes.Add(loop4); } } foreach (var loop4 in await _context.CouponSegments.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.EMDBooklets.EMDCoupons.CouponSegments"]).AsNoTracking().ToListAsync()) { if ((loop4.BOOKLET_DOCUMENT_NBR == loop3.BOOKLET_DOCUMENT_NBR) && (loop4.CPN_NBR == loop3.CPN_NBR) && (loop4.PRIMARY_AIRLINE_CD == loop3.PRIMARY_AIRLINE_CD) && (loop4.PRIMARY_DOCUMENT_NBR == loop3.PRIMARY_DOCUMENT_NBR) && (loop4.PRIMARY_ISSUE_DT == loop3.PRIMARY_ISSUE_DT)) { loop3.CouponSegments.Add(loop4); } } foreach (var loop4 in await _context.TaxFeeChargesGroup.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.EMDBooklets.EMDCoupons.TaxFeeChargesGroup"]).AsNoTracking().ToListAsync()) { if ((loop4.TFC_GROUP_ID == loop3.TFC_GROUP_ID)) { loop3.TaxFeeChargesGroup.Add(loop4); foreach (var loop5 in await _context.TaxFeeCharges.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.EMDBooklets.EMDCoupons.TaxFeeChargesGroup.TaxFeeCharges"]).AsNoTracking().ToListAsync()) { if ((loop5.TFC_GROUP_ID == loop4.TFC_GROUP_ID)) { loop4.TaxFeeCharges.Add(loop5); } } } } } } } } foreach (var loop2 in await _context.EMDItinerary.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.EMDItinerary"]).AsNoTracking().ToListAsync()) { if ((loop2.ITINERARY_ID == loop1.ITINERARY_ID)) { loop1.EMDItinerary.Add(loop2); foreach (var loop3 in await _context.TaxFeeChargesGroup.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.EMDItinerary.TaxFeeChargesGroup"]).AsNoTracking().ToListAsync()) { if ((loop3.TFC_GROUP_ID == loop2.TFC_GROUP_ID)) { loop2.TaxFeeChargesGroup.Add(loop3); foreach (var loop4 in await _context.TaxFeeCharges.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.EMDItinerary.TaxFeeChargesGroup.TaxFeeCharges"]).AsNoTracking().ToListAsync()) { if ((loop4.TFC_GROUP_ID == loop3.TFC_GROUP_ID)) { loop3.TaxFeeCharges.Add(loop4); } } } } foreach (var loop3 in await _context.TravelSegments.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.EMDItinerary.TravelSegments"]).AsNoTracking().ToListAsync()) { if ((loop3.ITINERARY_ID == loop2.ITINERARY_ID)) { loop2.TravelSegments.Add(loop3); foreach (var loop4 in await _context.Equipment.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.EMDItinerary.TravelSegments.Equipment"]).AsNoTracking().ToListAsync()) { if ((loop4.ITINERARY_ID == loop3.ITINERARY_ID) && (loop4.SEG_SEQ == loop3.SEG_SEQ)) { loop3.Equipment.Add(loop4); } } foreach (var loop4 in await _context.IntermediateStop.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.EMDItinerary.TravelSegments.IntermediateStop"]).AsNoTracking().ToListAsync()) { if ((loop4.ITINERARY_ID == loop3.ITINERARY_ID) && (loop4.SEG_SEQ == loop3.SEG_SEQ)) { loop3.IntermediateStop.Add(loop4); } } } } } } foreach (var loop2 in await _context.Passenger.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger"]).AsNoTracking().ToListAsync()) { if ((loop2.PAX_ID == loop1.PAX_ID)) { loop1.Passenger.Add(loop2); foreach (var loop3 in await _context.TravelIdentifier.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.TravelIdentifier"]).AsNoTracking().ToListAsync()) { if ((loop3.PAX_ID == loop2.PAX_ID)) { loop2.TravelIdentifier.Add(loop3); } } foreach (var loop3 in await _context.FareCategory.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.FareCategory"]).AsNoTracking().ToListAsync()) { if ((loop3.PAX_ID == loop2.PAX_ID)) { loop2.FareCategory.Add(loop3); } } foreach (var loop3 in await _context.FarePenalty.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.FarePenalty"]).AsNoTracking().ToListAsync()) { if ((loop3.PAX_ID == loop2.PAX_ID)) { loop2.FarePenalty.Add(loop3); } } foreach (var loop3 in await _context.FareWaiver.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.FareWaiver"]).AsNoTracking().ToListAsync()) { if ((loop3.PAX_ID == loop2.PAX_ID)) { loop2.FareWaiver.Add(loop3); } } foreach (var loop3 in await _context.BaseFareAmountGroup.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.BaseFareAmountGroup"]).AsNoTracking().ToListAsync()) { if ((loop3.AMOUNT_DETAIL_GROUP_ID == loop2.BASE_FARE_AD_GROUP_ID)) { loop2.BaseFareAmountGroup.Add(loop3); foreach (var loop4 in await _context.BaseFareAmount.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.BaseFareAmountGroup.BaseFareAmount"]).AsNoTracking().ToListAsync()) { if ((loop4.AMOUNT_DETAIL_GROUP_ID == loop3.AMOUNT_DETAIL_GROUP_ID)) { loop3.BaseFareAmount.Add(loop4); } } } } foreach (var loop3 in await _context.EquivalentFareAmountGroup.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.EquivalentFareAmountGroup"]).AsNoTracking().ToListAsync()) { if ((loop3.AMOUNT_DETAIL_GROUP_ID == loop2.EQUIVALENT_FARE_AD_GROUP_ID)) { loop2.EquivalentFareAmountGroup.Add(loop3); foreach (var loop4 in await _context.EquivalentFareAmount.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.EquivalentFareAmountGroup.EquivalentFareAmount"]).AsNoTracking().ToListAsync()) { if ((loop4.AMOUNT_DETAIL_GROUP_ID == loop3.AMOUNT_DETAIL_GROUP_ID)) { loop3.EquivalentFareAmount.Add(loop4); } } } } foreach (var loop3 in await _context.CarrierFee.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.CarrierFee"]).AsNoTracking().ToListAsync()) { if ((loop3.PAX_ID == loop2.PAX_ID)) { loop2.CarrierFee.Add(loop3); foreach (var loop4 in await _context.CarrierFeeAmount.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.CarrierFee.CarrierFeeAmount"]).AsNoTracking().ToListAsync()) { if ((loop4.CARRIER_FEE_SEQ == loop3.CARRIER_FEE_SEQ) && (loop4.PAX_ID == loop3.PAX_ID)) { loop3.CarrierFeeAmount.Add(loop4); } } } } foreach (var loop3 in await _context.TotalFareAmountGroup.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.TotalFareAmountGroup"]).AsNoTracking().ToListAsync()) { if ((loop3.AMOUNT_DETAIL_GROUP_ID == loop2.TOTAL_FARE_AD_GROUP_ID)) { loop2.TotalFareAmountGroup.Add(loop3); foreach (var loop4 in await _context.TotalFareAmount.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.TotalFareAmountGroup.TotalFareAmount"]).AsNoTracking().ToListAsync()) { if ((loop4.AMOUNT_DETAIL_GROUP_ID == loop3.AMOUNT_DETAIL_GROUP_ID)) { loop3.TotalFareAmount.Add(loop4); } } } } foreach (var loop3 in await _context.CarrierFeeFormofPaymentGroup.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.CarrierFeeFormofPaymentGroup"]).AsNoTracking().ToListAsync()) { if ((loop3.FOP_GROUP_ID == loop2.CARRIER_FEE_FOP_GROUP_ID)) { loop2.CarrierFeeFormofPaymentGroup.Add(loop3); foreach (var loop4 in await _context.CarrierFeeFormofPayment.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.CarrierFeeFormofPaymentGroup.CarrierFeeFormofPayment"]).AsNoTracking().ToListAsync()) { if ((loop4.FOP_GROUP_ID == loop3.FOP_GROUP_ID)) { loop3.CarrierFeeFormofPayment.Add(loop4); foreach (var loop5 in await _context.AmountDetailGroup.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.CarrierFeeFormofPaymentGroup.CarrierFeeFormofPayment.AmountDetailGroup"]).AsNoTracking().ToListAsync()) { if ((loop5.AMOUNT_DETAIL_GROUP_ID == loop4.AMOUNT_DETAIL_GROUP_ID)) { loop4.AmountDetailGroup.Add(loop5); foreach (var loop6 in await _context.AmountDetail.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.CarrierFeeFormofPaymentGroup.CarrierFeeFormofPayment.AmountDetailGroup.AmountDetail"]).AsNoTracking().ToListAsync()) { if ((loop6.AMOUNT_DETAIL_GROUP_ID == loop5.AMOUNT_DETAIL_GROUP_ID)) { loop5.AmountDetail.Add(loop6); } } } } foreach (var loop5 in await _context.FormOfPaymentAttribute.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.CarrierFeeFormofPaymentGroup.CarrierFeeFormofPayment.FormOfPaymentAttribute"]).AsNoTracking().ToListAsync()) { if ((loop5.FOP_GROUP_ID == loop4.FOP_GROUP_ID) && (loop5.FOP_SEQ == loop4.FOP_SEQ)) { loop4.FormOfPaymentAttribute.Add(loop5); } } foreach (var loop5 in await _context.ExchangedCouponGroup.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.CarrierFeeFormofPaymentGroup.CarrierFeeFormofPayment.ExchangedCouponGroup"]).AsNoTracking().ToListAsync()) { { loop4.ExchangedCouponGroup.Add(loop5); foreach (var loop6 in await _context.ExchangedCoupon.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.CarrierFeeFormofPaymentGroup.CarrierFeeFormofPayment.ExchangedCouponGroup.ExchangedCoupon"]).AsNoTracking().ToListAsync()) { if ((loop6.EXCH_DOC_CPN_GROUP_ID == loop5.EXCH_DOC_CPN_GROUP_ID)) { loop5.ExchangedCoupon.Add(loop6); } } } } } } } } foreach (var loop3 in await _context.Commission.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.Commission"]).AsNoTracking().ToListAsync()) { if ((loop3.COMMISSION_ID == loop2.COMMISSION_ID)) { loop2.Commission.Add(loop3); } } foreach (var loop3 in await _context.CarrierFeeTaxFeeChargesGroup.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.CarrierFeeTaxFeeChargesGroup"]).AsNoTracking().ToListAsync()) { if ((loop3.TFC_GROUP_ID == loop2.CARRIER_FEE_TFC_GROUP_ID)) { loop2.CarrierFeeTaxFeeChargesGroup.Add(loop3); foreach (var loop4 in await _context.CarrierFeeTaxFeeCharges.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.CarrierFeeTaxFeeChargesGroup.CarrierFeeTaxFeeCharges"]).AsNoTracking().ToListAsync()) { if ((loop4.TFC_GROUP_ID == loop3.TFC_GROUP_ID)) { loop3.CarrierFeeTaxFeeCharges.Add(loop4); } } } } foreach (var loop3 in await _context.CustomerLoyalty.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.CustomerLoyalty"]).AsNoTracking().ToListAsync()) { if ((loop3.PAX_ID == loop2.PAX_ID)) { loop2.CustomerLoyalty.Add(loop3); } } foreach (var loop3 in await _context.PriceableUnit.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.PriceableUnit"]).AsNoTracking().ToListAsync()) { if ((loop3.PAX_ID == loop2.PAX_ID)) { loop2.PriceableUnit.Add(loop3); foreach (var loop4 in await _context.FareComponentDetail.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.PriceableUnit.FareComponentDetail"]).AsNoTracking().ToListAsync()) { if ((loop4.PAX_ID == loop3.PAX_ID) && (loop4.PRICEABLE_UNIT_SEQ == loop3.PRICEABLE_UNIT_SEQ)) { loop3.FareComponentDetail.Add(loop4); foreach (var loop5 in await _context.FareComponentCouponSeq.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.PriceableUnit.FareComponentDetail.FareComponentCouponSeq"]).AsNoTracking().ToListAsync()) { if ((loop5.FARE_COMPONENT_DETAIL_SEQ == loop4.FARE_COMPONENT_DETAIL_SEQ) && (loop5.PAX_ID == loop4.PAX_ID) && (loop5.PRICEABLE_UNIT_SEQ == loop4.PRICEABLE_UNIT_SEQ)) { loop4.FareComponentCouponSeq.Add(loop5); } } foreach (var loop5 in await _context.TicketDesignator.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.PriceableUnit.FareComponentDetail.TicketDesignator"]).AsNoTracking().ToListAsync()) { if ((loop5.FARE_COMPONENT_DETAIL_SEQ == loop4.FARE_COMPONENT_DETAIL_SEQ) && (loop5.PAX_ID == loop4.PAX_ID) && (loop5.PRICEABLE_UNIT_SEQ == loop4.PRICEABLE_UNIT_SEQ)) { loop4.TicketDesignator.Add(loop5); } } foreach (var loop5 in await _context.ConstructionPrinciple.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.PriceableUnit.FareComponentDetail.ConstructionPrinciple"]).AsNoTracking().ToListAsync()) { if ((loop5.FARE_COMPONENT_DETAIL_SEQ == loop4.FARE_COMPONENT_DETAIL_SEQ) && (loop5.PAX_ID == loop4.PAX_ID) && (loop5.PRICEABLE_UNIT_SEQ == loop4.PRICEABLE_UNIT_SEQ)) { loop4.ConstructionPrinciple.Add(loop5); } } foreach (var loop5 in await _context.BaseFareAmountGroup.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.PriceableUnit.FareComponentDetail.BaseFareAmountGroup"]).AsNoTracking().ToListAsync()) { if ((loop5.AMOUNT_DETAIL_GROUP_ID == loop4.BASE_AMOUNT_ID)) { loop4.BaseFareAmountGroup.Add(loop5); foreach (var loop6 in await _context.BaseFareAmount.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.PriceableUnit.FareComponentDetail.BaseFareAmountGroup.BaseFareAmount"]).AsNoTracking().ToListAsync()) { if ((loop6.AMOUNT_DETAIL_GROUP_ID == loop5.AMOUNT_DETAIL_GROUP_ID)) { loop5.BaseFareAmount.Add(loop6); } } } } } } } } foreach (var loop3 in await _context.TotalConstructionAmountGroup.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.TotalConstructionAmountGroup"]).AsNoTracking().ToListAsync()) { if ((loop3.AMOUNT_DETAIL_GROUP_ID == loop2.TOTAL_CONST_AD_GROUP_ID)) { loop2.TotalConstructionAmountGroup.Add(loop3); foreach (var loop4 in await _context.TotalConstructionAmount.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.TotalConstructionAmountGroup.TotalConstructionAmount"]).AsNoTracking().ToListAsync()) { if ((loop4.AMOUNT_DETAIL_GROUP_ID == loop3.AMOUNT_DETAIL_GROUP_ID)) { loop3.TotalConstructionAmount.Add(loop4); } } } } foreach (var loop3 in await _context.UnstructuredFareCalcInfo.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Passenger.UnstructuredFareCalcInfo"]).AsNoTracking().ToListAsync()) { if ((loop3.PAX_ID == loop2.PAX_ID)) { loop2.UnstructuredFareCalcInfo.Add(loop3); } } } } foreach (var loop2 in await _context.TravelDocumentFormofPayments.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.TravelDocumentFormofPayments"]).AsNoTracking().ToListAsync()) { if ((loop2.PRIMARY_AIRLINE_CD == loop1.PRIMARY_AIRLINE_CD) && (loop2.PRIMARY_DOCUMENT_NBR == loop1.PRIMARY_DOCUMENT_NBR) && (loop2.PRIMARY_ISSUE_DT == loop1.PRIMARY_ISSUE_DT)) { loop1.TravelDocumentFormofPayments.Add(loop2); } } foreach (var loop2 in await _context.TransactionHistory.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.TransactionHistory"]).AsNoTracking().ToListAsync()) { if ((loop2.PRIMARY_AIRLINE_CD == loop1.PRIMARY_AIRLINE_CD) && (loop2.PRIMARY_DOCUMENT_NBR == loop1.PRIMARY_DOCUMENT_NBR)) { loop1.TransactionHistory.Add(loop2); foreach (var loop3 in await _context.POS.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.TransactionHistory.POS"]).AsNoTracking().ToListAsync()) { if ((loop3.TXN_HISTORY_ID == loop2.TXN_HISTORY_ID)) { loop2.POS.Add(loop3); } } foreach (var loop3 in await _context.TransactionHistoryCoupons.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.TransactionHistory.TransactionHistoryCoupons"]).AsNoTracking().ToListAsync()) { if ((loop3.TXN_HISTORY_ID == loop2.TXN_HISTORY_ID)) { loop2.TransactionHistoryCoupons.Add(loop3); } } foreach (var loop3 in await _context.RefundExchange.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.TransactionHistory.RefundExchange"]).AsNoTracking().ToListAsync()) { if ((loop3.TXN_HISTORY_ID == loop2.TXN_HISTORY_ID)) { loop2.RefundExchange.Add(loop3); foreach (var loop4 in await _context.FormOfRefund.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.TransactionHistory.RefundExchange.FormOfRefund"]).AsNoTracking().ToListAsync()) { if ((loop4.TXN_HISTORY_ID == loop3.TXN_HISTORY_ID)) { loop3.FormOfRefund.Add(loop4); } } foreach (var loop4 in await _context.RefundTaxFeeChargesGroup.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.TransactionHistory.RefundExchange.RefundTaxFeeChargesGroup"]).AsNoTracking().ToListAsync()) { if ((loop4.RFND_EXCH_TFC_GROUP_ID == loop3.RFND_EXCH_EMD_TFC_GROUP_ID)) { loop3.RefundTaxFeeChargesGroup.Add(loop4); foreach (var loop5 in await _context.RefundTaxFeeCharges.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.TransactionHistory.RefundExchange.RefundTaxFeeChargesGroup.RefundTaxFeeCharges"]).AsNoTracking().ToListAsync()) { if ((loop5.RFND_EXCH_TFC_GROUP_ID == loop4.RFND_EXCH_TFC_GROUP_ID)) { loop4.RefundTaxFeeCharges.Add(loop5); } } } } foreach (var loop4 in await _context.RefundExchangeCoupon.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.TransactionHistory.RefundExchange.RefundExchangeCoupon"]).AsNoTracking().ToListAsync()) { if ((loop4.TXN_HISTORY_ID == loop3.TXN_HISTORY_ID)) { loop3.RefundExchangeCoupon.Add(loop4); foreach (var loop5 in await _context.RefundTaxFeeChargesGroup.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.TransactionHistory.RefundExchange.RefundExchangeCoupon.RefundTaxFeeChargesGroup"]).AsNoTracking().ToListAsync()) { if ((loop5.RFND_EXCH_TFC_GROUP_ID == loop4.RFND_EXCH_CPN_TFC_GROUP_ID)) { loop4.RefundTaxFeeChargesGroup.Add(loop5); foreach (var loop6 in await _context.RefundTaxFeeCharges.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.TransactionHistory.RefundExchange.RefundExchangeCoupon.RefundTaxFeeChargesGroup.RefundTaxFeeCharges"]).AsNoTracking().ToListAsync()) { if ((loop6.RFND_EXCH_TFC_GROUP_ID == loop5.RFND_EXCH_TFC_GROUP_ID)) { loop5.RefundTaxFeeCharges.Add(loop6); } } } } } } } } } } foreach (var loop2 in await _context.Remark.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Remark"]).AsNoTracking().ToListAsync()) { { loop1.Remark.Add(loop2); } } foreach (var loop2 in await _context.BookingReferenceGroup.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.BookingReferenceGroup"]).AsNoTracking().ToListAsync()) { if ((loop2.BOOKING_REF_GROUP_ID == loop1.BOOKING_REF_GROUP_ID)) { loop1.BookingReferenceGroup.Add(loop2); foreach (var loop3 in await _context.BookingReference.FromSqlRaw(reworkedQueries["EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.BookingReferenceGroup.BookingReference"]).AsNoTracking().ToListAsync()) { if ((loop3.BOOKING_REF_GROUP_ID == loop2.BOOKING_REF_GROUP_ID)) { loop2.BookingReference.Add(loop3); } } } } } EMDDetailsbyDocumentNumberRS.EMDDocumentDetail.Add(loop1); } stopWatch.Stop(); MessageResult.ResponseTime = stopWatch.ElapsedMilliseconds.ToString(); EMDDetailsbyDocumentNumberRS.MessageResult.Add(MessageResult); return(EMDDetailsbyDocumentNumberRS ?? null); }
private void GetPendingWaiverList(ConnectionInfo connectionInfo) { using (VRArcadeDataAccessModel m = new VRArcadeDataAccessModel()) { List <VRWaiverLog> lWaiverLog = m.VRWaiverLogs.Where(x => x.IsNewEntry == true && !x.IsDeleted).ToList(); List <VRGameSelectorServerDTO.WaiverInfo> lwi = new List <VRGameSelectorServerDTO.WaiverInfo>(); Dictionary <string, int> bookingNumLeftDict = new Dictionary <string, int>(); foreach (VRWaiverLog waiverLog in lWaiverLog) { if (waiverLog.BookingReference != null && !bookingNumLeftDict.ContainsKey(waiverLog.BookingReference.Reference)) { bookingNumLeftDict.Add(waiverLog.BookingReference.Reference, waiverLog.BookingReference.NumberOfBookingLeft); } } foreach (VRWaiverLog waiverLog in lWaiverLog) { BookingReference bookingRef = null; if (waiverLog.BookingReference != null && waiverLog.BookingReference.BookingDeleted == null && waiverLog.BookingReference.NumberOfBookingLeft > 0) { int bNumLeft = bookingNumLeftDict[waiverLog.BookingReference.Reference]; if (bNumLeft > 0) { bookingRef = new BookingReference() { ID = waiverLog.BookingReference.ID, Reference = waiverLog.BookingReference.Reference, IsNonTimedTiming = waiverLog.BookingReference.IsNonTimedTiming, IsTimedTiming = waiverLog.BookingReference.IsTimedTiming, TimeCreated = waiverLog.BookingReference.TimeStampCreate, Duration = waiverLog.BookingReference.Duration, NumberOfBookingLeft = waiverLog.BookingReference.NumberOfBookingLeft, NumberOfBookingTotal = waiverLog.BookingReference.NumberOfBookingTotal, BookingStartTime = (DateTime)waiverLog.BookingReference.BookingStartTime, BookingEndTime = (DateTime)waiverLog.BookingReference.BookingEndTime }; bookingNumLeftDict[waiverLog.BookingReference.Reference] = bNumLeft - 1; } } lwi.Add(new VRGameSelectorServerDTO.WaiverInfo() { ID = waiverLog.ID, FirstName = waiverLog.FirstName, LastName = waiverLog.LastName, Address = waiverLog.Address, City = waiverLog.City, Postcode = waiverLog.Postcode, Province = waiverLog.Province, Cell = waiverLog.Cell, DOB = waiverLog.DOB, Email = waiverLog.Email, SignFileName = waiverLog.SignFileName, TimeCreated = waiverLog.TimeStampCreate, BookingReference = bookingRef }); } VRCommandServer vcs = new VRCommandServer(VRGameSelectorServerDTO.Enums.ControlMessage.GET_PENDING_WAIVER, lwi); SendCommandToPeer(connectionInfo, vcs); } }