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); } }