Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Brainstorm on booking system

Avatar of DanishCoder
DanishCoderFlag for Denmark asked on
ASPjQuery
3 Comments1 Solution294 ViewsLast Modified:
Dear experts,

I am about to develop a booking system in ASP, jQuery, and SQL.
I would like to hear opinions, warnings, and of course code and sql examples are welcome.

The task is:

Administrator:
- Sign up/approve, block, edit users, and delete them again.
- Create and modify booking calendars (room)
- Overrule users, and do the same as the users
- Be able to enter days where you can't reserve (days closed).

User:
- Book a specific item (spinbike) in a specific calendar (room), one hour at a time.
- Book more than one item (spinbike) in the same specific calendar (room), one hour at a time.
- Make the booking reocurr (e.g. each Monday) every week until a specific date.
- Is only able to reserve already free spaces (you book one hour at a time)
- See a list of bookings (date, time, item)

To do the booking, a datepicker in jQuery would be good, but it should also match with the dates blocked by the administrator. I am not sure how to handle this.

I am still in the beginning of this process - maybe a lot more ideas will come up in near future and a long the way! That also makes it difficult to give out points, but I will give points to the most qualified and reasoned posts.
ASKER CERTIFIED SOLUTION
Avatar of tobzzz
tobzzzFlag of Spain image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answers