//get offices weekly schedule from the database public List <WeeklySchedule> GetScheduleData() { var sd = new ScheduleData(); List <WeeklySchedule> weeklySchedule = sd.GetOfficeWeeklySchedule(); return(weeklySchedule); }
public void LoadWeeklyOfficeSchedule() { var sd = new ScheduleData(); List <Controller.DataStructures.Schedule.WeeklySchedule> weeklyOfficeSchedule = sd.GetOfficeWeeklySchedule(); foreach (var day in weeklyOfficeSchedule) { string scheduleDay = day.Day; DateTime open = DateTime.Today.Add(day.OpenTime); DateTime close = DateTime.Today.Add(day.CloseTime); string openTime = open.ToString("hh:mm tt").ToLower(); string closeTime = close.ToString("hh:mm tt").ToLower(); switch (day.Day) { case "Monday": DisplayDaysSchedule(lblMonday, scheduleDay, openTime, closeTime); break; case "Tuesday": DisplayDaysSchedule(lblTuesday, scheduleDay, openTime, closeTime); break; case "Wednesday": DisplayDaysSchedule(lblWednesday, scheduleDay, openTime, closeTime); break; case "Thursday": DisplayDaysSchedule(lblThursday, scheduleDay, openTime, closeTime); break; case "Friday": DisplayDaysSchedule(lblFriday, scheduleDay, openTime, closeTime); break; case "Saturday": DisplayDaysSchedule(lblSaturday, scheduleDay, openTime, closeTime); break; case "Sunday": DisplayDaysSchedule(lblSunday, scheduleDay, openTime, closeTime); break; } } }