private void buttonDisplayUpdateTimetableBack_Click(object sender, EventArgs e)
{
FormTimetableMainMenu tmm = new FormTimetableMainMenu();
this.Hide();
tmm.ShowDialog();
this.Close();
}
private void buttonTimetable_Click(object sender, EventArgs e)
{
FormTimetableMainMenu tm = new FormTimetableMainMenu();
this.Hide();
tm.ShowDialog();
this.Close();
//this.Close();
}
private void buttonNext_Click(object sender, EventArgs e)
{
string[] times = new string[] { "6:30 - 7:30", "7:30 - 8:30", "8:30 - 9:30", "9:30 - 10:30", "10:30 - 11:30", "11:30 - 12:30", "12:30 - 13:30",
"13:30 - 14:30", "14:30 - 15:30", "16:30 - 17:30", "17:30 - 18:30", "18:30 - 19:30", "19:30 - 20:30" };
ComboBox[] dayTimetable = new ComboBox[] { comboBox630To730, comboBox730To830, comboBox830To930, comboBox930To1030, comboBox1030To1130, comboBox1130To1230,
comboBox1230To1330, comboBox1330To1430, comboBox1430To1530, comboBox1530To1630, comboBox1630To1730, comboBox1730To1830,
comboBox1830To1930, comboBox1930To2030 };
TextBox[] timesOfDay = new TextBox[] { textBox630To730, textBox730To830, textBox830To930, textBox930To1030, textBox1030To1130, textBox1130To1230, textBox1230To1330,
textBox1330To1430, textBox1430To1530, textBox1530To1630, textBox1630To1730, textBox1730To1830, textBox1830To1930,
textBox1930To2030 };
string[] items = new string[] { "Breakfast", "Lunch", "Dinner", "School", "Work", "Exercise", "Free Time" };
string sqlFormattedDate = today.Date.ToString("yyyy-MM-dd");
DateTime currentDay = today.AddDays(n++);
string sqlCurrentDay = currentDay.Date.ToString("yyyy-MM-dd");
string unfilledTimes = "";
for (int i = 0; i < dayTimetable.Length; i++)
{
if (dayTimetable[i].SelectedItem == null)
{
unfilledTimes = unfilledTimes + " " + times[i]; //Adds onto this string
}
}
if (unfilledTimes != "")
{
MessageBox.Show("No items selected at " + unfilledTimes + " - Please ensure to click all the boxes and select an option"); //This will now show where it is unfilled in one place
return;
}
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = Conn;
for (int i = 0; i < dayTimetable.Length; i++)
{
cmd.CommandText = $"insert into activity_timetable values('{UserDetails.userID}', '{today.AddDays(dayCount).Date.ToString("yyyy-MM-dd")}' , '{timesOfDay[i].Text}','{dayTimetable[i].Text}')";
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
for (int i = 0; i < dayTimetable.Length - 1; i++)
{
if (dayTimetable[i].SelectedItem == null)
{
MessageBox.Show("No item selected at " + times[i]);
return;
}
}
MessageBox.Show("Success");
labelDays.Text = today.AddDays(dayCount++).DayOfWeek.ToString();
if (dayCount == 8)
{
UserDetails.doneSetTimetable = done;
Conn.Close();
buttonNext.Enabled = false;
UserDetails.doneSetTimetable = true;
FormTimetableMainMenu tm = new FormTimetableMainMenu();
this.Hide();
tm.ShowDialog();
this.Close();
//(this.Owner as FormTimetableMainMenu).
}
//for (int i = 0; i < dayTimetable.Length; i++)
//{
// dayTimetable[i].SelectedItem = null;
//}
}