Seat Booking need example with code

RAVI 956 Reputation points
2021-08-28T06:58:50.113+00:00

Hello

We have 3 seats available each 8 hrs and we run two shifts

first shifts = 09:00 = 17:00
second shift = 17:30 = 01:30

For Example : 1 Todays Date Is 01-AUG-2021 and user enter In Textbox1 and Textbox2 like this below

Rajesh 22
Mohan 40
Priya 23

On button click i want to save like this below in MS SQL BOOKING_TABLE

Date Booking_shift seat1 seat2 seat3
01-Aug-2021 09:00 = 17:00 Rajesh-22 Mohan-40 Priya-23

For Example : 2 Now one more user coming On 01-Aug-2021 he is giving data like this

Johar 18
Rani 22

On button click i want to save like this below in MS SQL BOOKING_TABLE

Date Booking_shift seat1 seat2 seat3
01-Aug-2021 09:00 = 17:00 Rajesh-22 Mohan-40 Priya-23
01-Aug-2021 17:30 = 01:30 Johar-18 Rani-22

For Example : 3 02-AUg-2021 no is coming next one more user coming 03-AUG-2021 he is giving data like this

Arshad 25
John 19

On button click i want to save like this below in MS SQL BOOKING_TABLE

Date Booking_shift seat1 seat2 seat3
01-Aug-2021 09:00 = 17:00 Rajesh-22 Mohan-40 Priya-23
01-Aug-2021 17:30 = 01:30 Johar-18 Rani-22
03-Aug-2021 09:00 = 17:00 Arhsad-25 John-19

how to do this in old asp.net 2.0 C#
thank you

ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,375 questions
{count} votes

2 answers

Sort by: Most helpful
  1. RAVI 956 Reputation points
    2021-09-09T07:02:50.477+00:00

    Hello

    Simple Way To Say Instert In MS SQL TABLE Like Movie Ticket Booking IF seat available it has to say already plan if not then have to move next available slot per day the movie run in theater in two times slot first shifts = 09:00 = 17:00
    second shift = 17:30 = 01:30


  2. RAVI 956 Reputation points
    2021-09-15T09:02:53.883+00:00

    Thank you

    Please give me one small example complete code with aspx and c# code page.. Thanks