public void DisplayEmpAvailability() { var DailyDefaults = UseDB.SelectDailyAvailabilities("DailyDefault"); var Sunday = UseDB.SelectDailyAvailabilities("Sunday"); var Monday = UseDB.SelectDailyAvailabilities("Monday"); var Tuesday = UseDB.SelectDailyAvailabilities("Tuesday"); var Wednesday = UseDB.SelectDailyAvailabilities("Wednesday"); var Thursday = UseDB.SelectDailyAvailabilities("Thursday"); var Friday = UseDB.SelectDailyAvailabilities("Friday"); var Saturday = UseDB.SelectDailyAvailabilities("Saturday"); Console.WriteLine("{0, -15} {1, -15} {2, -15} {3, -15} {4, -15} {5, -15} {6, -15} {7, -15} {8, -15} {9, -15} {10, -15}", "Employee ID", "First Name", "Last Name", "DailyDefault", "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"); for (int i = 0; i < Sunday.Count; i++) { int empID = DailyDefaults[i].EmployeeID; string empFName = DailyDefaults[i].EmpFName; string empLName = DailyDefaults[i].EmpLName; string dailyDefault = DailyDefaults[i].StartTime.ToString("hh") + ":" + DailyDefaults[i].StartTime.ToString("mm") + "-" + DailyDefaults[i].EndTime.ToString("hh") + ":" + DailyDefaults[i].EndTime.ToString("mm"); string sundayStr = Sunday[i].StartTime.ToString("hh") + ":" + Sunday[i].StartTime.ToString("mm") + "-" + Sunday[i].EndTime.ToString("hh") + ":" + Sunday[i].EndTime.ToString("mm"); string mondayStr = Monday[i].StartTime.ToString("hh") + ":" + Monday[i].StartTime.ToString("mm") + "-" + Monday[i].EndTime.ToString("hh") + ":" + Monday[i].EndTime.ToString("mm"); string tuesdayStr = Tuesday[i].StartTime.ToString("hh") + ":" + Tuesday[i].StartTime.ToString("mm") + "-" + Tuesday[i].EndTime.ToString("hh") + ":" + Tuesday[i].EndTime.ToString("mm"); string wednesdayStr = Wednesday[i].StartTime.ToString("hh") + ":" + Wednesday[i].StartTime.ToString("mm") + "-" + Wednesday[i].EndTime.ToString("hh") + ":" + Wednesday[i].EndTime.ToString("mm"); string thursdayStr = Thursday[i].StartTime.ToString("hh") + ":" + Thursday[i].StartTime.ToString("mm") + "-" + Thursday[i].EndTime.ToString("hh") + ":" + Thursday[i].EndTime.ToString("mm"); string fridayStr = Friday[i].StartTime.ToString("hh") + ":" + Friday[i].StartTime.ToString("mm") + "-" + Friday[i].EndTime.ToString("hh") + ":" + Friday[i].EndTime.ToString("mm"); string saturdayStr = Saturday[i].StartTime.ToString("hh") + ":" + Saturday[i].StartTime.ToString("mm") + "-" + Saturday[i].EndTime.ToString("hh") + ":" + Saturday[i].EndTime.ToString("mm"); Console.WriteLine( "{0, -15} " + "{1, -15} " + "{2, -15} " + "{3, -15} " + "{4, -15} " + "{5, -15} " + "{6, -15} " + "{7, -15} " + "{8, -15} " + "{9, -15} " + "{10, -15}", empID, empFName, empLName, dailyDefault, sundayStr, mondayStr, tuesdayStr, wednesdayStr, thursdayStr, fridayStr, saturdayStr); } }