DECLARE @Id UNIQUEIDENTIFIER = '2d586358-5f12-4a4f-8909-c4db933fd748';
DECLARE @Provider NVARCHAR(50) = 'TourVisio';
DECLARE @ParentId UNIQUEIDENTIFIER = '1a79d357-83fe-4c4d-97d7-99ee9927862a';
DECLARE @Market NVARCHAR(50) = 'BIH';
DECLARE @Agency NVARCHAR(50) = 'AVIO';
DECLARE @AgencyUser NVARCHAR(50) = 'AIDA';
DECLARE @ProductType NVARCHAR(50) = '3';
DECLARE @ExpireDate DATETIME = GETDATE();
DECLARE @CreateDate DATETIME = GETDATE();
DECLARE @Data NVARCHAR(MAX) = '{"ResMain":{"RefNo":1,"ResNo":"be253347-3","Market":"BIH","Operator":"AVIOEXPRES","Office":"AVIO","PLOperator":"AVIOEXPRES","PLMarket":"BIH","Agency":"AVIO","AgencyUser":"AIDA","ResDate":"2024-08-15T00:00:00","ResTime":"2024-08-15T14:26:19","ResLock":0,"SaleResource":1,"DepCity":6,"ArrCity":2,"BegDate":"2024-09-27T00:00:00","EndDate":"2024-09-27T00:00:00","Days":0,"PriceSource":0,"Adult":1,"Child":0,"ResNote":"","ResStat":0,"ConfStat":1,"PaymentStat":"U","EBPasChk":0,"EBAgencyChk":0,"PLSpoChk":0,"AllowDocPrint":"N","InvoiceTo":0,"ConfToAgency":"N","RecCrtDate":"2024-08-15T14:26:19","RecCrtUser":"AIDA","RecChgUser":"","SendInComing":"W","SalePrice":332.49,"SaleCur":"BAM","NetPrice":332.49,"NetCur":"BAM","AgencyComMan":"N","AgencyCom":0.00,"AgencyComPer":0.00,"AgencyComSup":0.00,"AgencyComSupPer":0.00,"EBAgency":0.00,"EBAgencyPer":0.00,"EBPas":0.00,"EBPasPer":0.00,"BrokerCom":0.00,"BrokerComPer":0.00,"Broker":"","AgencyDisPasVal":0.00,"AgencyDisPasPer":0.00,"Tax":0.00,"EB":"N","AgencyPayable":332.49,"Discount":0.00,"EBSupID":0,"EBSupMaxPer":0.00,"Balance":332.49,"PasSupDis":0.00,"AgencySupDis":0.00,"PasPayable":332.49,"TotalPrice":332.49,"PriceToPay":332.49,"AgencyPriceToPay":332.49,"PassengerPriceToPay":332.49,"PasBalance":0.00,"PasDiscBase":332.49,"AgencyDiscBase":332.49,"AgencyComPayAmount":0.00,"SendAgency":"N","AllDocPrint":"N","Code1":"","Code2":"","Code3":"","Code4":"","Code5":"","Code6":"","Code7":"","Code8":"","SendToAcc":"N","Ballon":"N","ReceiveDate":"2024-08-15T14:26:19","SendToAce":false,"PasPayRule":0,"PaymentFrom":0,"PasAmount":332.49,"Credit":"N","CreditExpenseCur":"","InvoiceIssued":"N","AgencyEarnBonus":0,"UserEarnBonus":0,"PasEarnBonus":0,"AgencyBonus":0.00,"AgencyBonusAmount":0.00,"UserBonus":0.00,"UserBonusAmount":0.00,"PasBonusAmount":0.00,"Complete":0,"PromoAmount":0.00,"ContractIssued":false,"CalcErrNo":0,"PLSpoVal":0.00,"ChgDate":"2024-08-15T13:26:35.433","ChgUser":"","TokenId":2869224,"SaleChannelId":1,"ResMainE":{"RecID":0,"AdditionalFields":"{\u0022SmsLimit\u0022:\u00223\u0022,\u0022PriceChanged\u0022:\u00220\u0022,\u0022AllowSalePriceEdit\u0022:\u00220\u0022}","SearchCriterias":"{\u0022ProductType\u0022:3,\u0022ServiceTypes\u0022:[\u00221\u0022],\u0022CheckIn\u0022:\u00222024-09-27T00:00:00\u0022,\u0022CheckInTo\u0022:\u00222024-09-27T00:00:00\u0022,\u0022IncludeSubLocations\u0022:false,\u0022DepartureLocations\u0022:[{\u0022Code\u0022:\u0022AYT\u0022,\u0022Name\u0022:\u0022ANTALYA\u0022,\u0022InternationalName\u0022:\u0022ANTALYA\u0022,\u0022Type\u0022:2,\u0022ParentId\u0022:\u00223\u0022,\u0022CountryId\u0022:\u00223\u0022,\u0022IsProductLocation\u0022:true,\u0022Provider\u0022:1,\u0022IsTopRegion\u0022:false,\u0022OwnLocation\u0022:false,\u0022Id\u0022:\u00226\u0022}],\u0022ArrivalLocations\u0022:[{\u0022Type\u0022:5,\u0022Provider\u0022:1,\u0022IsTopRegion\u0022:false,\u0022OwnLocation\u0022:false,\u0022Id\u0022:\u00222\u0022}],\u0022Adult\u0022:1,\u0022ChildAges\u0022:[],\u0022CheckAllotment\u0022:true,\u0022CheckStopSale\u0022:true,\u0022ShowAllotment\u0022:true,\u0022ShowStopSale\u0022:false,\u0022GetOnlyDiscountedPrice\u0022:false,\u0022GetOnlyBestOffers\u0022:false,\u0022GetTransportations\u0022:false,\u0022PagingOption\u0022:{\u0022ProductType\u0022:0,\u0022PageRowCount\u0022:0,\u0022CurrentPage\u0022:1,\u0022Sort\u0022:0,\u0022GetFilters\u0022:false,\u0022IsNewPagingRequest\u0022:false,\u0022GetOnlyDefaultProducts\u0022:false,\u0022GetPagingCount\u0022:false},\u0022ShowOnlyNonStopFlight\u0022:false,\u0022ForceFlightBundlePackage\u0022:false,\u0022SearchBrandedFares\u0022:true,\u0022DisablePackageOfferTotalPrice\u0022:true,\u0022SupportedFlightReponseListTypes\u0022:[2,3],\u0022Compulsory\u0022:false,\u0022AdditionalParameters\u0022:{\u0022GetOptionsParameters\u0022:{\u0022GetWithoutMedia\u0022:false,\u0022GetThirdPartyProviderAccomCodes\u0022:false},\u0022GetCountry\u0022:false,\u0022GetTransferLocation\u0022:true},\u0022Passengers\u0022:[{\u0022Type\u0022:1,\u0022Ages\u0022:[],\u0022Count\u0022:1}],\u0022PriceSearchResponseDetails\u0022:{\u0022FlightResponseType\u0022:4,\u0022FlightResponseListType\u0022:1},\u0022Customer\u0022:{},\u0022AcceptPendingProviders\u0022:true,\u0022TargetProvider\u0022:0,\u0022Id\u0022:\u0022978a4c19-23a2-4b6e-9cc0-59db37623ffb\u0022,\u0022DataSource\u0022:0,\u0022WebRequestDetail\u0022:{\u0022ClientAddress\u0022:\u0022::1\u0022,\u0022Domain\u0022:\u0022localhost:3332\u0022,\u0022UserAgent\u0022:\u0022Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36\u0022,\u0022Referrer\u0022:\u0022http://localhost:5000/\u0022},\u0022Currency\u0022:\u0022BAM\u0022,\u0022Culture\u0022:\u0022de-DE\u0022,\u0022Provider\u0022:7}"},"FullPaidPreCancel":false,"ReservationExistingStatus":0,"HasAvailablePromotionCode":false},"ResCust":[{"ResNo":"be253347-3","SeqNo":1,"CustNo":1,"TravellerType":1,"Title":1,"Name":"","Surname":"","Leader":"Y","HasPassport":true,"ppSalePrice":332.49,"ppPasPayable":332.49,"ppPasEB":0.00,"RealRecord":false,"RequiredFields":[],"AdditionalFields":{"BirthDateFrom":"1925-09-28T00:00:00.0000000","BirthDateTo":"2008-09-27T00:00:00.0000000"},"InsertFields":[],"IsAdult":true,"IsChild":false,"IsInfant":false}],"ResCustInfo":[{"SeqNo":1,"ResNo":"be253347-3","CustNo":1}],"ResService":[{"RecID":1,"ResNo":"be253347-3","SeqNo":1,"IsMainService":true,"ServiceType":"FLIGHT","AdditionalServiceType":0,"Service":"VF835","ServiceName":"VF835","DepLocation":6,"ArrLocation":2,"DepCountry":3,"ArrCountry":1,"BegDate":"2024-09-27T00:00:00","BegTime":"1899-12-30T08:45:00","EndTime":"1899-12-30T10:10:00","EndDate":"2024-09-27T00:00:00","Duration":0,"Supplier":"FIBULA","Unit":1,"Adult":1,"Child":0,"FlgClass":"Y","PriceSource":0,"NetPrice":170.00,"NetCur":"EUR","SalePrice":332.49,"SalePricePreRound":332.49,"SaleCur":"BAM","StatConf":1,"StatSer":0,"PayCom":"Y","CanDiscount":true,"SendSupplier":"W","AllotType":"H","ResMainStat":0,"IncPack":"N","Tax":0.00,"TaxPer":0.00,"ChkSel":true,"PriceID":4007,"ThirdPartyRecord":false,"Provider":1,"Reservable":false,"Bundle":false,"FPType":0,"ServiceDetail":{},"CancellationPolicy":[],"ResServiceE":{"RecID":0,"ServiceID":0},"ServiceId":"4007","UniqueID":1,"Handicaps":[],"ExistingStatus":0,"IsThirdPartyServiceSetAfterCommit":false,"AdditionalData":{"SupplierCancellationPolicies":[]}}],"ResCon":[{"RecID":1,"ResNo":"be253347-3","CustNo":1,"ServiceID":1,"Unit":0,"DocStat":0,"ChkSel":true}],"ResServiceExt":[],"ResConExt":[],"ResCustPrice":[{"RecID":1,"CustNo":1,"ResNo":"be253347-3","ServiceID":1,"ExtServiceID":0,"PriceType":0,"NetPrice":170.00,"NetCur":"EUR","SalePrice":332.49,"SaleCur":"BAM","PLSpoVal":0,"ChkSel":true}],"ResSupDis":[],"ResPromo":[],"ResSerSPO":[],"ResPayPlan":[{"RecID":1,"ResNo":"be253347-3","PayNo":1,"DueDate":"2024-08-16T00:00:00","Amount":99.75,"Cur":"BAM","IsEb":false,"Status":1},{"RecID":2,"ResNo":"be253347-3","PayNo":2,"DueDate":"2024-09-17T00:00:00","Amount":232.74,"Cur":"BAM","IsEb":false,"Status":1}],"PromotionList":[],"SerSPOList":[],"InvoiceList":[],"Storage":{"Main":{"SalePrice":332.49,"AgencyComMan":"N","AgencyCom":0.00,"AgencyComPer":0.00,"AgencyDisPasPer":0.00,"AgencyDisPasVal":0.00},"ResServices":[{"UniqueID":1,"SalePrice":332.49,"PriceSource":0}],"ResServiceExtras":[],"WillBeAssignedFlightSeats":[],"TravellerInsertFields":{},"WillBeAssignedTransportSeats":[],"ServiceHandicaps":[],"Handicaps":[]}}';
DECLARE @TotalPaxCount INT = 1;
DECLARE @AdultCount INT = 1;
DECLARE @ChildCount INT = 0;
DECLARE @TokenId NVARCHAR(50) = '2869224';
DECLARE @Status TINYINT = 4;
DECLARE @MasterBookingTransactionId UNIQUEIDENTIFIER = NULL;
DECLARE @SearchId UNIQUEIDENTIFIER =NULL;
DECLARE @ReservationNumber NVARCHAR(50) = NULL;
DECLARE @AllocatedReservationNumber NVARCHAR(50) = NULL;
DECLARE @ProviderReservationNumber NVARCHAR(50) = NULL;
DECLARE @AgencyName NVARCHAR(100) = 'AVIO EXPRESS TRAVEL';
DECLARE @AgencyUserName NVARCHAR(100) = 'AIDA SMAILOVIC';
DECLARE @TransactionType NVARCHAR(50) = 0;
DECLARE @OprOffice NVARCHAR(50) = 'AVIO';
DECLARE @OprOfficeName NVARCHAR(100) = 'AVIO MAINOFFICE';

INSERT INTO BookingTransactions
	(Id, Provider, ParentId, Name, Market, Agency, AgencyUser, ProductType, [ExpireDate], [CreateDate], Data, TotalPaxCount, AdultCount, ChildCount,TokenId,Status,MasterBookingTransactionId,SearchId,ReservationNumber,AllocatedReservationNumber,ProviderReservationNumber,AgencyName,AgencyUserName,TransactionType,OprOffice,OprOfficeName)
VALUES
	(@Id, @Provider, @ParentId, @Name, @Market, @Agency, @AgencyUser, @ProductType, @ExpireDate, @CreateDate, @Data, @TotalPaxCount, @AdultCount, @ChildCount,@TokenId,@Status,@MasterBookingTransactionId,@SearchId,@ReservationNumber,@AllocatedReservationNumber,@ProviderReservationNumber,@AgencyName,@AgencyUserName,@TransactionType,@OprOffice,@OprOfficeName);