create dynamic time slots

Question

1.00/5 (2 votes)

See more:

I need to create time slots using start time and end time as 8 to 5 with 20 minutes intervals,i WANT to get start time and endtime from the database table which has datetime datatype.and then i want to create timeslots for 20 minutes interval based on that starttime and end time thn those timeslots i want to store in another database table which is created in sql server. I am using c#.net.

Does anybody have solution to this problem?

Thank you

Reply

Posted 12-Sep-12 8:37am

Member 9413472

Updated 12-Sep-12 9:09am

v3

Add a Solution

Comments

Sergey Alexandrovich Kryukov 12-Sep-12 14:40pm

Go ahead and create them -- you got my approval. This is not a question.
--SA

Member 9413472 12-Sep-12 14:54pm

thank you so much for your advice do you hsve any solution for my question?

Sergey Alexandrovich Kryukov 12-Sep-12 15:22pm

I just don't see a problem. I just told you: this is not a question. Perhaps if I take a look at your code...
--SA

[no name] 12-Sep-12 14:40pm

What have you tried?

Member 9413472 12-Sep-12 14:45pm

for (int i = 0; i < lsbcrlocation.Items.Count; i++)
{
for (int j = 0; j < lsbcrprovider.Items.Count; j++)
{

if (lsbcrlocation.Items[i].Selected == true && lsbcrprovider.Items[j].Selected == true)
{
//string facility_name = ((Label)gvdisplaytimeslots.SelectedRow.FindControl("lblLocation")).Text;
//string provider_name = ((Label)gvdisplaytimeslots.SelectedRow.FindControl("lblProvider")).Text;
//HiddenField hfid = ((HiddenField)gvdisplaytimeslots.SelectedRow.FindControl("hfid"));
DataTable dttimeslot = (DataTable)cnt.GetRecord("Select day_start_time,day_end_time,facility_name,duration,provider_name from tblTimeSlots where facility_name='" + lsbcrlocation.Items[i].Text + "' and provider_name='" + lsbcrprovider.Items[j].Text + "'");

string stime = dttimeslot.Rows[0]["day_start_time"].ToString();
string etime = dttimeslot.Rows[0]["day_end_time"].ToString();
string duration = dttimeslot.Rows[0]["duration"].ToString();
//Datetime stattime= Convert.ToDateTime()
DateTime startTime = DateTime.Today.AddHours(Convert.ToInt16(stime));

// System.Diagnostics.Debug.Print(startTime.ToShortTimeString());

DateTime endTime = DateTime.Today.AddHours(Convert.ToInt16(etime)).AddMinutes(00);
//System.Diagnostics.Debug.Print(endTime.ToShortTimeString());

int inc = Convert.ToInt16(duration);
List<string> timeList = new List<string>();
lbltimeslots.Text = "";

while (startTime < endTime)
{
timeList.Add(startTime.ToShortTimeString());
startTime = startTime.AddMinutes(inc);
lbltimeslots.Text += startTime.ToShortTimeString();
hrcls.upindel("insert into tblValidAppointmentTime(facility_name,provider_name,first_appointment_time) values('" + lsbcrlocation.Items[i].Text + "','" + lsbcrprovider.Items[j].Text + "','" + lbltimeslots.Text + "')");

//.ToShortTimeString();

}
timeList.Add(endTime.ToShortTimeString());
}
}
}
}
I have tried with this in the above code i want to store calculated time slots in the tblvalidappointmenttime table which i have created in sql server

[no name] 12-Sep-12 14:49pm

And WTF is this and what does it have to do with storing anything in a database? You have not created a connection to any database, a command, or exectued the command anywhere.

Member 9413472 12-Sep-12 14:53pm

i have created an object of class file which hrcls.upindel that will contain connectionstring and all.

[no name] 12-Sep-12 14:58pm

And that means exactly nothing. Let's do this from another angle... what specific question related to a specific programming problem do you have? Do you not know how to add 20 minutes to a time? Do you not know how to define a connection string to whatever database you are using? Do you not know how to create a connection to whatever database you are using? Do you not know how to define an INSERT statement to whatever database you are using? What?

Member 9413472 12-Sep-12 15:03pm

we are trying to create time slots based on the starttime and endtime given in the textbox in asp.net.we need time interval of 20 minutes.andi need those timeslots get stored in the sql server database table.i am using c#

[no name] 12-Sep-12 15:18pm

And so? You have already said that. Since you cannot or will not state what your problem actually is, I will answer your "question" as best as I can with the information that you have supplied... Get the start time from the database, add 20 minutes, save back into the data base. Repeat until you get to the end time. Now I will go on vacation for a time to let my blood pressure subside.

Sergey Alexandrovich Kryukov 12-Sep-12 15:24pm

Could you please post it to the question where you can format it with "pre" tags, for better readability? Using "Improve question" above.
--SA

Sergey Alexandrovich Kryukov 12-Sep-12 15:44pm

Just one note for now:
As "Selected" is a Boolean property,
if (lsbcrlocation.Items[i].Selected == true && lsbcrprovider.Items[j].Selected == true) { ...
should be
if (lsbcrlocation.Items[i].Selected && lsbcrprovider.Items[j].Selected) { ...

Not really a mistake, just nonsense...
--SA

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)