available time in student schedule

Question

1.00/5 (2 votes)

See more:

Hi I have small scheduling system for students in university
This sysem in asp.net
I want steps that help and guide me how can I find the available time in each student schedule
Based on the available time I can do the meeting with them
This is a part of the DB structre

Teacher’s table ( this consist of the whole info about them e.g ID,name ,email…)
Student’s table (this consist of the whole info about them e.g ID,name ,level …)
courses( teacher_id,courses name and number,begin_time,end_time,section_no )

hope that is clear
Thanks in advance.

Posted 28-Apr-11 5:55am

at all

Updated 28-Apr-11 6:49am

v2

Add a Solution

Comments

Gonzoox 28-Apr-11 14:33pm

your questions leaves me with a ? in my face... I don't know the structure of your DB, besides if you want someone to do it for you, you need to start talking about $$$, post the code that is giving you the problem and we can take a look at it and help you fixing it, but asking us to do it for you is not free

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nish Nishant · Answer 1 · 2011-04-28T06:02:00

Solution 1

It really depends on your DB structure. Can you update your post and give some details on that too? Don't post an answer - instead, update your existing question.

Posted 28-Apr-11 6:02am

Nish Nishant

Comments

at all 28-Apr-11 12:21pm

ok,I will post it now

#realJSOP · Answer 2 · 2011-04-28T06:18:00

Have the one of the programming course instructors do it for you.

Identifying the problem is half the battle. Designing and implementing a solution should be easy at this point because you're the one familiar witrh your existing code - not us.

It's an interesting problem from a programming perspective, nonetheless. The hard part is determining what chunks of time are available during the day, and if any of them are long enough to conduct the desired meeting. The hole in your plan is assuming that the student isn't somehow otherwise occupied by something other than in-class time (doctor's appointment, sex, running errands, etc). The easiest thing to do is to post your schedule on the web site, and let the student pick a date/time. This lets you specify periods of availability, and forces the student to pick something appropriate for their schedule.