Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP.NET
i am a beginner..........
i am doing a asp.net project digital car parking system.the user need to park the car in slots.for booking the slot,enter the Vehicle entry date and exit date.if one user book the slot in between two dates.next another user book the same slot at the same date.i need to prevent the booking at the same dates.please send me the code for checkig the date is between Vehicle Entry date and Vehicle Exit date.
Posted 15-Jan-13 18:38pm
Comments
Vani Kulkarni at 16-Jan-13 0:40am
   
What have you tried till now? Would you post your code?
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

May be it helps you..
 
SELECT  slot_no , entry_date, exit_date
FROM    TBMORDER
WHERE   (entry_date < '10/12/2012') AND (exit_date > '10/12/2012') AND (slot_no = 9;)
 
Using above query you can check for slot no 9 is booked for not and its entry date and exit date also for your given date
 
Thanks
Asp.Net/C#.Net Help[^]
Hemant Singh
  Permalink  
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Guruprasad.K.Basavaraju 490
1 Sergey Alexandrovich Kryukov 316
2 Shai Vashdi 314
3 OriginalGriff 190
4 praveen_07 115
0 Sergey Alexandrovich Kryukov 9,185
1 OriginalGriff 5,315
2 Peter Leow 4,040
3 Maciej Los 3,535
4 Abhinav S 3,308


Advertise | Privacy | Mobile
Web02 | 2.8.140415.2 | Last Updated 16 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid