Appointment Booking System

supermaitai · July 13th, 2009, 12:33 PM

Is there a way to change the booking hours? Right now its set from 7am to 12pm. I want it to be from 7pm to 3am. How do i turn of military time? I want it to display normal times.

Imar · July 13th, 2009, 01:32 PM

Hi there,

Take a look at page 342. It shows you how to change the booking hours.

If by "military time" you mean the 24 hour clock (called "normal time' in Europe and many countries outside it), and want to use the AM / PM system instead then take a look at page 339. It explains how the current list is filled. It should be easy to adapt the code so it displays the time in your format.

Cheers,

Imar

supermaitai · July 14th, 2009, 03:36 PM

Thanks. I am doing something and I was wondering if it were possible to completely remove the time system to book and just book with dates? I have very little programming knowledge, are there any resource i can use for this?

Imar · July 15th, 2009, 03:21 AM

Hi there,

It's certainly possible but you'll need to do some programming to get it right.

If you don't have a lot of programming experience you may be able to hack you way around it like this:

1. In HourPicker, in the SelectedHour property, always return 0. This way, all times are record at mid night

2. In the sign up wizard hide the TimePicker control.

3. Hide the Duration control

4. When sign up is about to create the appointment, set Duration to 24 hours.

This way, all bookings are booked for a full day.

Note: this is just an idea; I haven't tested it, or confirmed that this will actually work. Also, I don't know exactly how this effects reports. You'll need to do some investigation and see if this works. I'll be more thah happy to help you with follow up questions that may arise.

Cheers,

Imar

supermaitai · July 15th, 2009, 12:01 PM

Quote:

Originally Posted by Imar

Hi there,

It's certainly possible but you'll need to do some programming to get it right.

If you don't have a lot of programming experience you may be able to hack you way around it like this:

1. In HourPicker, in the SelectedHour property, always return 0. This way, all times are record at mid night

2. In the sign up wizard hide the TimePicker control.

3. Hide the Duration control

4. When sign up is about to create the appointment, set Duration to 24 hours.

This way, all bookings are booked for a full day.

Note: this is just an idea; I haven't tested it, or confirmed that this will actually work. Also, I don't know exactly how this effects reports. You'll need to do some investigation and see if this works. I'll be more thah happy to help you with follow up questions that may arise.

Cheers,

Imar

I changed the #1 to 0, but how do i hide the timepicker control? when you're talking about the sign up wizard, are you talking about the wizard in "create appointment.aspx"? sorry I am a total noob when it comes to programming. I am learning as I go.

Imar · July 15th, 2009, 02:00 PM

Hi there,

In CreateAppointment.aspx you should have something like:

<Wrox:HourPicker ID="hpTime" runat="server" ..... />

You can set the Visible property to False to hide the control:

<Wrox:HourPicker ID="hpTime" runat="server" Visible="False" ..... />

This hides the control from the UI but you should still be able to to read its value.

It's probably a good idea (if you don't already have it) to get a good introductionary book on ASP.NET. Incidentally I wrote one called "Beginning ASP.NET 3.5"; may help you get up to speed with this in no-time.

http://www.wrox.com/WileyCDA/WroxTit...47018759X.html

Cheers,

Imar

supermaitai · July 16th, 2009, 05:06 PM

Quote:

Originally Posted by Imar

Hi there,

In CreateAppointment.aspx you should have something like:

<Wrox:HourPicker ID="hpTime" runat="server" ..... />

You can set the Visible property to False to hide the control:

<Wrox:HourPicker ID="hpTime" runat="server" Visible="False" ..... />

This hides the control from the UI but you should still be able to to read its value.

It's probably a good idea (if you don't already have it) to get a good introductionary book on ASP.NET. Incidentally I wrote one called "Beginning ASP.NET 3.5"; may help you get up to speed with this in no-time.

http://www.wrox.com/WileyCDA/WroxTit...47018759X.html

Cheers,

Imar

Thanks. That worked for me. I just purchased the book too. However I have another question. in the program management page, there is a way to create a new conference room but there isn't a way to delete one. How do i allow management to remove a comferece room?

Imar · July 16th, 2009, 06:03 PM

Hi there,

Can you please not quote the entire message when you reply here? Makes things easier to read if you don't. Quoting is typically used to just quote a small piece of text from somebody else's reply.

That said, implementing delete shouldn't be too hard. Here's what you need to do:

1. Write a stored procedure that deletes an item from the database. Have it accept the object's Id and write code similar to:

DELETE FROM BookingObject WHERE Id = @id

2. Write code in the business and Dal layers to support this procedure. Similar to GetItem methods you've seen before you need code that passes the Id of the object into the procedure.

3. Modify the ObjectDataSource to support deleting and choose a Delete method

4. Modify the GridView to support deleting

You may need to delete associated appointments first as they contain related records.

My Beginning book shows you a lot more about this (although it uses SqlDataSources or LINQ, rather than the ObjectDataSource controls used in the appointment booking app.

Hope this helps,

Imar

Appointment Schedule · August 18th, 2009, 04:09 PM

A number of valuable web based software solutions are available online; which can improve the operation of a busy office or practice.

To combat the loss in revenues, resulting from missed meetings and appointments (to both clients and practioners), some professionals have utilized a web based room scheduling software or appointment scheduling software; to monitor client meetings and appointments.

Email reminders will reduce no-shows and self-scheduling clients can book their own meetings or appointments online.

In addition, it frees up time for Professionals to concentrate on other areas of their workload; online or in the office.

Thank you for sharing your knowledge and insight.

Best wishes.

supermaitai · September 1st, 2009, 01:48 PM

Hi Imar,

Thanks for all your help on modifying this. I have one more question. The program requires an "Alphanumeric" password. How do i change the password requirement be 6 digits only?

Thanks.