2 Replies - 2619 Views - Last Post: 11 December 2012 - 09:07 PM Rate Topic: -----

#1 TooMuchViagra  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 28-February 12

calendar control scheduling application

Posted 11 December 2012 - 02:45 PM

Hi,

I'm using a calendar control in my page to allow clients to pick a date and schedule an appointment. I have a simple database for now that consists of two tables: Clients and Appointments and I'm using Linq to Entities.

I want to disable the date in the calendar where there are 5 appointments scheduled for already so that clients can't select it. I know how to manipulate the calendar with the day_render event and how to disable hardcoded dates, What I'm having problem with is how to approach and implement this requirement.

Another table in the db?(I'm really bad at db design) Linq Count function?

Basically I'm looking for suggestions, tips, code help c# or vb.

Thanks

Is This A Good Question/Topic? 0
  • +

Replies To: calendar control scheduling application

#2 Nakor  Icon User is offline

  • Professional Lurker
  • member icon

Reputation: 446
  • View blog
  • Posts: 1,501
  • Joined: 28-April 09

Re: calendar control scheduling application

Posted 11 December 2012 - 05:30 PM

you already have a table storing the appointments, you should just need to get a count of the current/active appointments for the client. I can't see where you would need another database table unless I'm just not understanding something
Was This Post Helpful? 0
  • +
  • -

#3 TooMuchViagra  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 28-February 12

Re: calendar control scheduling application

Posted 11 December 2012 - 09:07 PM

View PostNakor, on 11 December 2012 - 05:30 PM, said:

you already have a table storing the appointments, you should just need to get a count of the current/active appointments for the client. I can't see where you would need another database table unless I'm just not understanding something


I figured it out. Count function did the trick.
thank you
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1