identifying schedule already exist or not

Question

0.00/5 (No votes)

See more:

hello friends,

i have query regarding a scheduling scheme.

i have designed a scheduling dashboard for machines in vb.net and sql server.in which a user enters the schedules for machines which he has to use.now the problem is i am able to stop the duplicate scheduling entries but i dont have any idea on how to achieve the following mentioned problem:

suppose a user enters the schedule from 3 AM to 4AM then i am able to stop entries on this schedule but how should i restrict the entries from say: 2AM to 5AM coz the schedule of 3 AM to 4AM is already taken.

i want to restrict and check such entries.

needed help....

thanks.

Posted 28-Sep-13 0:01am

sachin bhise

Add a Solution

Comments

Nelek 28-Sep-13 6:25am

I think you should give a bit more information about the structure of your system or what / how you already did the other tasks. The working solution can be quite different between one option or another or even make things worst if not compatible.

Example:
Do you save the schedule in Time Format? or dou you have a sort of calender where you put the flag "busy" at the reserved hours?
Are there other priorities to be considered or just the first that reserves something gets it?

sachin bhise 28-Sep-13 6:33am

i am entering the time from a combobx in number format like 1 AM,1:15AM,1:30AM,2 AM etc.

RedDk 28-Sep-13 15:40pm

Offhand wouldn't be easy to add a computational column on the fly that identitfies a "subslot" as INUSE, then include that exculpatory info in a WHERE clause to filter viable return?

1 solution

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)

ZurdoDev · Answer 1 · 2013-09-28T10:05:00

There isn't a single piece of code anyone can give you to fix this issue. You need to check for overlapping. Drawing out a diagram may help you see it. You need to make sure your start time of the existing one is not in the range of the new one nor is the end time. Then check the other scenarios but drawing a diagram should help you visualize it.