checking in between time

Question

Hi guys Can anyone knows how to check time? My problem was: I'm creating scheduling the usage of a certain room. For example someone reserved room1 at 1pm to 3pm. then other one is trying to reserved room1 at 2pm to 5 pm. How can I check that the room1 is not available because it was reserved at 1pm? can someone help me pls.. thanks! annir

Ruzive Mazhandu · Answer

hi yo issue can be addressed in two ways one using SQL code or C# code.using SQL as u retrieve the data(time) from the DB screen by placing the time in the condition part of the SQL.

annir · Answer

thanks I have a database that will handle the time. I just selecting the time from the database.

Manish Dwivedi · Answer

Hi Whenever u allot any room check that room is allotted or not. If that room is alloted then check the input start time not ranging between the allotted range and input end time not ranging between the allotted range.