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);
}
