public void loadSchedule()
{
clearSchedule();
DataTable Datatb = new DataTable();
Schedule_User_Data SheduleUserData = new Schedule_User_Data();
try
{
string newLine = Environment.NewLine;
Datatb = SheduleUserData.getListShedule_User(User.UserName, FirstDayOfWeek(Date), LastDayOfWeek(Date));
//MessageBox.Show(Datatb.Rows[1].Field<string>("SlotID"));
foreach (DataRow row in Datatb.Rows)
{
DateTime dateValue = DateTime.Parse(row["Date"].ToString());
if (dateValue.ToString("ddd").Equals("Mon"))
{
if (row["SlotID"].ToString().Equals("Slot1"))
{
txtSlot1MonT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot2"))
{
txtSlot2MonT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot3"))
{
txtSlot3MonT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot4"))
{
txtSlot4MonT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot5"))
{
txtSlot5MonT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot6"))
{
txtSlot6MonT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
}
else if (dateValue.ToString("ddd").Equals("Tue"))
{
if (row["SlotID"].ToString().Equals("Slot1"))
{
txtSlot1TueT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot2"))
{
txtSlot2TueT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot3"))
{
txtSlot3TueT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot4"))
{
txtSlot4TueT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot5"))
{
txtSlot5TueT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot6"))
{
txtSlot6TueT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
}
else if (dateValue.ToString("ddd").Equals("Wed"))
{
if (row["SlotID"].ToString().Equals("Slot1"))
{
txtSlot1WedT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot2"))
{
txtSlot2WedT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot3"))
{
txtSlot3WedT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot4"))
{
txtSlot4WedT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot5"))
{
txtSlot5WedT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot6"))
{
txtSlot6WedT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
}
else if (dateValue.ToString("ddd").Equals("Thu"))
{
if (row["SlotID"].ToString().Equals("Slot1"))
{
txtSlot1ThuT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot2"))
{
txtSlot2ThuT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot3"))
{
txtSlot3ThuT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot4"))
{
txtSlot4ThuT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot5"))
{
txtSlot5ThuT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot6"))
{
txtSlot6ThuT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
}
else if (dateValue.ToString("ddd").Equals("Fri"))
{
if (row["SlotID"].ToString().Equals("Slot1"))
{
txtSlot1FriT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot2"))
{
txtSlot2FriT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot3"))
{
txtSlot3FriT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot4"))
{
txtSlot4FriT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot5"))
{
txtSlot5FriT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot6"))
{
txtSlot6FriT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
}
else if (dateValue.ToString("ddd").Equals("Sat"))
{
if (row["SlotID"].ToString().Equals("Slot1"))
{
txtSlot1SatT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot2"))
{
txtSlot2SatT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot3"))
{
txtSlot3SatT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot4"))
{
txtSlot4SatT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot5"))
{
txtSlot5SatT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot6"))
{
txtSlot6SatT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
}
else if (dateValue.ToString("ddd").Equals("Sun"))
{
if (row["SlotID"].ToString().Equals("Slot1"))
{
txtSlot1SunT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot2"))
{
txtSlot2SunT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot3"))
{
txtSlot3SunT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot4"))
{
txtSlot4SunT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot5"))
{
txtSlot5SunT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
else if (row["SlotID"].ToString().Equals("Slot6"))
{
txtSlot6SunT.Text = row["GroupID"].ToString() + newLine + row["CourseID"].ToString() + newLine + dateValue.ToString("dd-MM-yyyy");
}
}
}
}
catch
{
MessageBox.Show("Loi");
}
}
