protected void addSchedule()
{
try
{
int UserID;
UserID = (lstUsers.SelectedIndex == -1 ? Convert.ToInt16(Session["UserID"]) : lstUsers.SelectedValue == "0" ? Convert.ToInt16(Session["UserID"]) : Convert.ToInt16(lstUsers.SelectedValue));
TimeSpan tsDiff;
double dHours;
string StartTime, EndTime;
DateTime dStart, dEnd;
dStart = TimeStart.Date;
dEnd = TimeEnd.Date;
if (dStart >= dEnd)
{
lblmsg2.Text = "Start time cannot be equal or greater than the end time";
mpeMsg.Show();
return;
}
tsDiff = dEnd - dStart;
dHours = tsDiff.TotalHours;
StartTime = TimeStart.Date.ToString();
StartTime = StartTime.Substring(11, 11);
EndTime = TimeEnd.Date.ToString();
EndTime = EndTime.Substring(11, 11);
openconnection();
SqlParameter pmUserID = new SqlParameter("@iPKUser", UserID);
SqlParameter pmDate = new SqlParameter("@Date", txtDate.Text);
SqlParameter pmClientID = new SqlParameter("@iPKClient", ddlClient.SelectedValue);
SqlParameter pmVenueID = new SqlParameter("@iPKVenue", ddlVenue.SelectedValue);
SqlParameter pmTimeStart = new SqlParameter("@sStartTime", StartTime);
SqlParameter pmTimeEnd = new SqlParameter("@sEndTime", EndTime);
SqlParameter pmHours = new SqlParameter("@fHours", dHours);
//SqlParameter pmBookingCritical = new SqlParameter("@BookingCritical", CheckBoxBookingCritical.Checked ? 1 : 0);
//SqlParameter pmBookingTentative = new SqlParameter("@BookingTentative", CheckBoxBookingTentative.Checked ? 1 : 0);
//SqlParameter pmComment = new SqlParameter("@Comment", TextBoxComment.Text);
SqlHelper.ExecuteNonQuery(cn, System.Data.CommandType.StoredProcedure, "PI_Schedule", pmUserID, pmDate, pmClientID, pmVenueID, pmTimeStart, pmTimeEnd, pmHours /*, pmBookingCritical, pmBookingTentative, pmComment*/);
}
catch (Exception ex)
{
lblmsg2.Text = ex.Message;
lblmsg.ForeColor = System.Drawing.Color.Red;
mpeMsg.Show();
}
finally
{
cn.Close();
}
}
private void CreatePlannerButton_Click(object sender, RoutedEventArgs e)
{
try
{
DataView value = PlannerDataGrid.ItemsSource as DataView;
DataTable dataTable = value.ToTable();
DataTable result = new DataTable("Result");
result.Columns.Add("task", typeof(string));
result.Columns.Add("day", typeof(string));
result.Columns.Add("time", typeof(string));
StartTime = "05:00";
StopTime = "00:00";
TimeSpan = "00:30";
int counter = 0;
string day;
string hour;
//value, day, hour
int startHour = Int32.Parse(StartTime.Substring(0, 2));
int startMinute = Int32.Parse(StartTime.Substring(3, 2));
int stopHour = Int32.Parse(StopTime.Substring(0, 2));
int stopMinute = Int32.Parse(StopTime.Substring(3, 2));
int timeSpanHour = Int32.Parse(TimeSpan.Substring(0, 2));
int timeSpanMinute = Int32.Parse(TimeSpan.Substring(3, 2));
int actualHour = startHour;
int actualMinute = startMinute;
while (actualHour != stopHour)
{
while (actualMinute != 60)
{
string time = $"{actualHour.ToString("D2")}:{actualMinute.ToString("D2")}";
result.Rows.Add(dataTable.Rows[counter]["Monday"], "Monday", time);
result.Rows.Add(dataTable.Rows[counter]["Tuesday"], "Tuesday", time);
result.Rows.Add(dataTable.Rows[counter]["Wedneday"], "Wednesday", time);
result.Rows.Add(dataTable.Rows[counter]["Thursday"], "Thursday", time);
result.Rows.Add(dataTable.Rows[counter]["Friday"], "Friday", time);
result.Rows.Add(dataTable.Rows[counter]["Saturday"], "Saturday", time);
result.Rows.Add(dataTable.Rows[counter]["Sunday"], "Sunday", time);
actualMinute += timeSpanMinute;
counter++;
if (counter == 38)
{
int s = 1;
}
}
actualMinute = 0;
actualHour++;
if (actualHour == 24)
{
actualHour = 0;
}
}
EditTask(this.plannerName, result);
//GetDataGridRows();
Color();
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
}
