Click here to Skip to main content
15,885,278 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: If else condition fails, in VB.net Pin
Vimalsoft(Pty) Ltd12-Jan-15 3:42
professionalVimalsoft(Pty) Ltd12-Jan-15 3:42 
GeneralRe: If else condition fails, in VB.net Pin
sudevsu12-Jan-15 4:32
sudevsu12-Jan-15 4:32 
GeneralRe: If else condition fails, in VB.net Pin
Vimalsoft(Pty) Ltd12-Jan-15 5:12
professionalVimalsoft(Pty) Ltd12-Jan-15 5:12 
AnswerRe: If else condition fails, in VB.net Pin
ZurdoDev7-Jan-15 9:11
professionalZurdoDev7-Jan-15 9:11 
QuestionError on clicking Linkbutton of Gridview Pin
sudevsu7-Jan-15 6:47
sudevsu7-Jan-15 6:47 
AnswerRe: Error on clicking Linkbutton of Gridview Pin
sudevsu7-Jan-15 7:15
sudevsu7-Jan-15 7:15 
AnswerRe: Error on clicking Linkbutton of Gridview Pin
Atish K. Singh26-Jan-15 21:58
professionalAtish K. Singh26-Jan-15 21:58 
QuestionSimple Table Reservation Pin
Vmortis7-Jan-15 2:26
Vmortis7-Jan-15 2:26 
So i got this module "Internet Programming" where we should learn ASP.NET and some C#. But what we really learn is some drag and drop functionalities of Visual Studio 2013.
As we don't learn any hard code I do post this thinking its a simple question.

All i need is to insert (if possible) reservations for restaurant tables (a given number of requested seats will require a number of tables to be reserved).

Here are the DB tables i use:

<img src="http://imgur.com/bUPF4sB"> </img>

Link To Tables[^]
Steps:

1- Add restaurant Tables, the sum of seats of all tables its the total seats at the restaurant. DONE

2- Make reservation:
2.1- Get client info: Name, Contact, number of seats to be reserved and date (day, month, year, hour) DONE
2.2- Check availability. If number of available seats for that time is lower than the number of seats requested show massage to user.
3- ...


At 2.2 i don't know how to see if there are seats available to make the reservation.
In some other programming language i would search the seats already reserved for that time and subtract that number to the total seats of the restaurant. Then just by compering the result with the seats requested for the new reservation i could tell if its possible to reserve or not... easy...
But not so easy in the way I'm dealing with ASP.NET on visual studio and using built-in DB manager wit IIS express Server.

Thx in advance for any help Smile | :)
AnswerRe: Simple Table Reservation Pin
sudevsu7-Jan-15 6:50
sudevsu7-Jan-15 6:50 
GeneralRe: Simple Table Reservation Pin
Vmortis12-Jan-15 6:14
Vmortis12-Jan-15 6:14 
GeneralRe: Simple Table Reservation Pin
Richard Deeming12-Jan-15 7:04
mveRichard Deeming12-Jan-15 7:04 
GeneralRe: Simple Table Reservation Pin
Vmortis12-Jan-15 8:07
Vmortis12-Jan-15 8:07 
GeneralRe: Simple Table Reservation Pin
Richard Deeming12-Jan-15 8:55
mveRichard Deeming12-Jan-15 8:55 
QuestionCan i use this scheduler for my app? Pin
Namith Krishnan E6-Jan-15 17:59
professionalNamith Krishnan E6-Jan-15 17:59 
AnswerRe: Can i use this scheduler for my app? Pin
Anurag Gandhi10-Jan-15 1:55
professionalAnurag Gandhi10-Jan-15 1:55 
QuestionCan anyone look at Quick questions. I don't want to Repost the question. Pin
sudevsu6-Jan-15 9:12
sudevsu6-Jan-15 9:12 
AnswerRe: Can anyone look at Quick questions. I don't want to Repost the question. Pin
ZurdoDev6-Jan-15 10:44
professionalZurdoDev6-Jan-15 10:44 
AnswerRe: Can anyone look at Quick questions. I don't want to Repost the question. Pin
Richard MacCutchan7-Jan-15 0:48
mveRichard MacCutchan7-Jan-15 0:48 
GeneralRe: Can anyone look at Quick questions. I don't want to Repost the question. Pin
sudevsu7-Jan-15 2:29
sudevsu7-Jan-15 2:29 
QuestionDate picker & text box Pin
Member 113538205-Jan-15 7:39
Member 113538205-Jan-15 7:39 
AnswerRe: Date picker & text box Pin
ZurdoDev5-Jan-15 8:23
professionalZurdoDev5-Jan-15 8:23 
AnswerRe: Date picker & text box Pin
Swinkaran5-Jan-15 10:38
professionalSwinkaran5-Jan-15 10:38 
GeneralRe: Date picker & text box Pin
Richard MacCutchan5-Jan-15 22:57
mveRichard MacCutchan5-Jan-15 22:57 
GeneralRe: Date picker & text box Pin
sudevsu6-Jan-15 2:52
sudevsu6-Jan-15 2:52 
GeneralRe: Date picker & text box Pin
Richard MacCutchan6-Jan-15 4:39
mveRichard MacCutchan6-Jan-15 4:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.