I'm currently developing a system for booking of discussion room in a college. This system will allow the staff to help the students to make booking in advanced as well as for instant walk in usage.
I've got a table to keep track of bookings, another for walk in and one for time slot.
For the time slot table, it includes start time slot and end time slot, which is 30 minutes interval for each.
What i'm currently facing is that the system could not display the correct available time slot. I think it's the formula problem which I still can't get it solved.
If the booking time is 8.30am - 9.00am, I have no problem showing the 1st slot as N/A.
But if the time is 8.45am - 9.15am, the system only update the 1st slot as N/A while the 2nd slot still remain as AVAILABLE which is wrong. Because since the time ends at 9.15, I would like the slot 9.00am - 9.30am to be N/A as well.
This would be my code:
for (int x = 0; x < countTimeSlot; x++)
if (int.Parse(arrEndTimeSlot[x].ToString()) > intBookedStartTime && int.Parse(
View Complete Post