//------------------------------------------------------------------------------
//
// initiates Andrue Cashman's network
//
//------------------------------------------------------------------------------
private void InitNetwork()
{
string rawcourses = File.ReadAllText("../../AllCourses.json");
string rawpreqs = File.ReadAllText("../../PrereqNetwork.json");
network = new CourseNetwork(rawcourses, rawpreqs);
network.BuildNetwork();
}
//------------------------------------------------------------------------------
//
// initiates Andrue Cashman's network
//
//------------------------------------------------------------------------------
private void InitNetwork()
{
//VARIABLES
string rawpreqs = DBPlugin.ExecuteToString("Select CourseID, GroupID, PrerequisiteID from Prerequisite for JSON AUTO");
string rawcourses = DBPlugin.ExecuteToString("select CourseID from Course for JSON AUTO;");
//NETWORK BUILD
network = new CourseNetwork(rawcourses, rawpreqs);
network.BuildNetwork();
}
//------------------------------------------------------------------------------
// initiates Andrue Cashman's network
//------------------------------------------------------------------------------
private void InitNetwork()
{
//VARIABLES
// These queries are so general and non-specific >:(
// TODO: Going to have to do a join on courses to receive the Maxcredits so we can store in the course object and then in turn store in the job.
// This requires changing the file of the CourseObject and on lines: 498 and around it.
// Also gives you a chance to fix this damn query.
//string rawpreqs = DBPlugin.ExecuteToString("Select CourseID, GroupID, PrerequisiteID, PrerequisiteCourseID from Prerequisite for JSON AUTO");
string rawpreqs = DBPlugin.ExecuteToString("SELECT p.CourseID, MaxCredit as credits, GroupID, PrerequisiteID, PrerequisiteCourseID " +
"FROM Prerequisite as p " +
"LEFT JOIN Course as c ON c.CourseID = p.CourseID " +
"FOR JSON PATH");
string rawcourses = DBPlugin.ExecuteToString("SELECT CourseID, MaxCredit as credits " +
"FROM Course " +
"FOR JSON PATH");
//NETWORK BUILD
network = new CourseNetwork(rawcourses, rawpreqs);
network.BuildNetwork();
}
