Check if a row exists, otherwise insert

I need to write a T-SQL stored procedure that updates a row in a table. If the row doesn't exist, insert it. All this steps wrapped by a transaction. This is for a booking system, so it must be...

django date filter gte and lte

I need to find data within a certain set of parameters I am building a small booking system, that lets user see what vehicles are available for booking for their little safari trip. The system has...

Connecting to QuickBooks using API

I need some guidelines here. I am creating an online booking system for my client that interfaces with QuickBooks on their internal network (desktop QuickBooks, not online). Do I need to go the...

How do I refresh a HTML table after editing it?

I am making a very simple system that records bookings, everything is editable other than the 'booking number' and 'price' sections which are static. The booking number is pre-defined and the...

Data Flow/Process Diagram Query

I'm looking to depict a flow of data which shows the following: Booking made into Reservations sytem by customer Data is then transformed, validated and merged in the Reservations system It is...

Is it possible to generate PayPal payment links that are valid for a certain amount of time?

Let's say we have a hotel booking system and we want to receive payments via PayPal. When user goes through the booking process he / she ends up on the page that says "complete your payment here"...

Data structure to be used for implementing online booking system

It was asked by a interviewer. The target is to Design a train tickets Reservation system. If the train go through 5 stations(e.g. A,B,C,D,E). We could sell tickets from A-E or A-B, if a ticket...

javax.xml.ws.WebServiceException when invoking WSDL service

I was looking to use the Travelport Universal API to develop a Flight Booking System, so i have used this Travelport Developers official link as reference: Getting Started for Travelport...

How to check if a booking exists within the time frame?

Im working on a meeting room booking system and i am having trouble figuring out if a room is taken within a set timeframe, i am using the current format for dates and have the type set to...

Copy A form to use in the same project

I need to have 8 forms of the same format within the same project I dont really want to specifically place all the buttons etc in each of them Is there a way i could copy and paste the format and...

add event to an ical calendar from a website

For a assignment i need to make a booking system for a bnb. It needs to sync to a airbnb calendar which can be exported using ical. but i need to make a new event from the website and i don't know...

MS SQL Trigger for a Booking Cancellation

Novice At SQL trying to teach myself so apologies if question seems basic. I need to create a trigger to be actioned when a booking is cancelled. This will also need to check if the party that has...

Laravel - query from database and save to another

Welcome! I try to find a solution for my problem but it's hard for fresh laravel user. I try to do some simple booking system. I have 2 tables: schedule, and bids. What I want to do is display...

Print the index of the array in his toString method

Hi all and sorry for my English, I'm not very good at writing. I am actually programming a booking system for a cinema (it is an University project). I have a LinkedList of Users and inside i put...

Parsing date format of mmm dd yyyy to excel date format

We use a booking system at work that exports reports where the date is entered in the format mmm dd yyyy (for example "Jun 01 2018"). Excel does not recognise this and the usual date formatting...

UML use case diagram - depicting relationships correctly?

I wondered if anyone could let me know whether this diagram is approximately correct? I am depicting a database booking system and am very confused about the relationships between some of these...

Django Reservation System

I need to build a web-based reservation system, for example, for a restaurant. Where users will be able to make a table reservation up to a week in advance. This is my first own web project and...

How do I allow a iframe with a content security policy (CSP)

I am setting up a content security policy (CSP)for my website. I have been using it for a few websites for the last weeks without any issue. External scripts and various other things I have...

Setting global timezone in Angular

Does anyone know how to set the default timezone app wide? I need to fix it to 'Europe/London'. Even if your browser thinks you are in another country. My dates are in all in UTC from the...

how can i use the Postgres DateRange type with TypeOrm

i try to implement basic Hotel booking system with Nest.js framework. i use TypeOrm and Postgres Database. i have a booking Entity (room reservation in the hotel) and Booking should have a...

Validate data inserted based on other data in the same table (Oracle)

I am doing a project in SQL Oracle and have found a problem, as far as I am quite new to SQL. I have a system that administrates booked rooms, in a table called bookings. Some of the attributes...

How to get sum of values from a ManyToMany relation in Django REST Framework

I am trying to create a system were a user can make a booking for a flight. I have two models named Item and Booking. class Item(models.Model): item_name = models.CharField(max_length=100) ...

Check date range is not already booked in Laravel 6?

I am working in an online bike booking system where the customer can book a bike for a particular date-time range. If another customer books the same bike for a specified date-time range, I have...

How can I make a Hashmap assign multiple values for a key?

Hi the code you see below is based on a train booking system interface, I have included one of the methods called addCustomer,which prompts a textfield to request customer name(Hashmap Key), then...

Different set of authentications for different apps in the same firebase project

I am building a booking system and I am using firebase as the backend. The system has two parts: the customer end which is an app. the business end which is a website. I am using the same...

SyntaxError: Unexpected token v in JSON at position 0 at JSON.parse (<anonymous>) at XMLHttpRequest.onLoad

I'm new to Angular.I have some problems regarding the passing data between back-end and front-end.I have a system which passes booking data to the back-end to be saved in the database.Here is my...

In WordPress I use a Plugin for Appointment Booking (amelia), why the javascript doesn't fetch the selector with .find() function from jQuery,

On this Site: aufschalten.ch I try to implement a javascript for the use of geonames.org data, for the form fields PLZ and Ort. Outside of the Plugin it does work. See on the Start Page Bottom....

Exception in thread "main" java.lang.ClassCastException: class com.sun.proxy.$Proxy0 cannot be cast to class crewcut

As per stated in the title, as I were to continue to next supposed section in the coding. The RMI system did not the display the action based on my input. I want it to display the next part of...

How to install and publish github rinvex / laravel-bookings

I would like to install and publish https://github.com/rinvex/laravel-bookings on my localhost. I have done the following steps: Clone the repository...

how to logout on blazor server side?

I have a problem with programming a logout in Blazor using HttpContextAccessor. I tried to logout but it didn't do anything. What I want is just to delete some cookies in my browser and redirect...

Relevant tags