public List <string> GetDataFromDatabaseCourses(ScheduleContext db, int programId) { List <string> data = new List <string>(); var courses = db.Courses.Where(x => x.ProgramId == programId).ToList(); foreach (var c in courses) { data.Add(c.CourseCode); data.Add(c.CourseName); var courseIDs = db.PrerequisiteCourses.Where(x => x.ActualCourseId == c.Id).ToList().Select(x => x.RequiredCourseId).ToList(); string prerequsites = ""; for (int i = 0; i < courseIDs.Count(); i++) { var courseRetrived = db.Courses.Find(courseIDs[i]); prerequsites += courseRetrived.CourseName + " , "; } data.Add(prerequsites); data.Add(c.Instructor); data.Add(c.ContactHours.ToString()); data.Add(c.HoursPerDay.ToString()); data.Add(c.NumberOfDays.ToString()); var schedule = db.TeachingDays.Find(c.ScheduleTypeId); data.Add(schedule.DayOption); string sd = c.StartDate.Value.Month.ToString(); sd += "-"; sd += c.StartDate.Value.Day.ToString(); sd += "-"; sd += c.StartDate.Value.Year.ToString(); data.Add(sd); sd = ""; sd = c.EndDate.Value.Month.ToString(); sd += "-"; sd += c.EndDate.Value.Day.ToString(); sd += "-"; sd += c.EndDate.Value.Year.ToString(); data.Add(sd); } return(data); }
public List <TimeAllocationHelper> GetAllDayInstances(ProgramDetails program, ScheduleContext db) { var PreselectedHolidayDates = db.Calendars.Where(x => x.ProgramId == program.Id && x.IsHoliday == true).ToList().Select(x => x.Date); if (PreselectedHolidayDates == null) { PreselectedHolidayDates = new List <DateTime>(); } char[] days = new char[] { 'M', 'T', 'W', 'R', 'F' }; // getting program time length List <TimeAllocationHelper> daysOfStudy = new List <TimeAllocationHelper>(); int pId = program.Id; int totalDaysOfEducation = program.CalculateTotalDaysOfEducation(program); DateTime startD = program.ProgramStartDate.Value.Date; for (int k = 0; k < totalDaysOfEducation; k++) { if (PreselectedHolidayDates.Contains(startD) == false && startD.DayOfWeek != DayOfWeek.Saturday && startD.DayOfWeek != DayOfWeek.Sunday) { TimeAllocationHelper dayInstance = new TimeAllocationHelper(); dayInstance.RemainingTime = program.TotalTeachingHoursOfDay; dayInstance.Date = startD; int a = (int)startD.DayOfWeek - 1; dayInstance.Day = days[a]; dayInstance.ProgramId = pId; daysOfStudy.Add(dayInstance); } startD = startD.AddDays(1); } return(daysOfStudy); }