public void GetAllRating()
{
var schedule = new List <int>()
{
};
var connection = new DBConnection();
var eval = new Evaluator();
var scheduleQuery = $"select GeneratedPlanId from GeneratedPlan where GeneratedPlanId > 600";
var schedules = connection.ExecuteToDT(scheduleQuery);
foreach (DataRow schedulesRow in schedules.Rows)
{
schedule.Add((int)schedulesRow["GeneratedPlanId"]);
}
foreach (int scheduleId in schedule)
{
var parameterQuery = $"select ParameterSetId from GeneratedPlan where GeneratedPlanId={scheduleId}";
var parameterId = (int)connection.ExecuteToDT(parameterQuery).Rows[0]["ParameterSetId"];
var parameterSetQuery = $"select ParameterSet.MajorID, SchoolID, TimePeriod, MaxNumberOfQuarters, NumberCoreCoursesPerQuarter, CreditsPerQuarter, SummerPreference, DepartmentId from ParameterSet join Major on ParameterSet.MajorID = Major.MajorID" +
$" join TimePreference on TimePreference.TimePreferenceID = ParameterSet.TimePreferenceID" +
$" where ParameterSetId = {parameterId}";
var parameterSetResult = connection.ExecuteToDT(parameterSetQuery);
var parameters = Preferences.ConvertFromDatabase(parameterSetResult, parameterId);
var query = "select CourseNumber, QuarterID, YearID, Course.CourseId, Course.DepartmentID from StudyPlan" +
" join course on Course.CourseID = StudyPlan.CourseID" +
$" where GeneratedPlanID = {scheduleId}";
var results = connection.ExecuteToDT(query);
var model = ScheduleModel.ConvertFromDatabase(results, scheduleId, parameters);
var rating = eval.evalaute(model);
RatingHelper.UpdateWeakLabelScore(scheduleId, rating);
}
}
public string Get(int id)
{
var connection = new DBConnection();
var parameterQuery = $"select ParameterSetId from GeneratedPlan where GeneratedPlanId={id}";
var parameterId = (int)connection.ExecuteToDT(parameterQuery).Rows[0]["ParameterSetId"];
var parameterSetQuery = $"select ParameterSet.MajorID, SchoolID, TimePeriod, MaxNumberOfQuarters, NumberCoreCoursesPerQuarter, CreditsPerQuarter, SummerPreference, DepartmentId from ParameterSet join Major on ParameterSet.MajorID = Major.MajorID" +
$" join TimePreference on TimePreference.TimePreferenceID = ParameterSet.TimePreferenceID" +
$" where ParameterSetId = {parameterId}";
var parameterSetResult = connection.ExecuteToDT(parameterSetQuery);
var parameters = Preferences.ConvertFromDatabase(parameterSetResult, parameterId);
var query = "select CourseNumber, QuarterID, YearID, Course.CourseId, DepartmentId from StudyPlan" +
" join course on Course.CourseID = StudyPlan.CourseID" +
$" where GeneratedPlanID = {id}";
var results = connection.ExecuteToDT(query);
var model = ScheduleModel.ConvertFromDatabase(results, id, parameters);
var response = JsonConvert.SerializeObject(model);
return(response);
}