//Constructs Course Object, using name it queries the database and gets the information for the class
//Class lacks exception handling and does not account for the class name entered being invalid
public Course(string name, bool taken)
{
Taken = taken;
DataTable result = GraduationPlanningSystem.db.find(name, "course");
DataRow[] rows = result.Select();
Object[] rowArray = rows[0].ItemArray;
Name = (String)rowArray[1];
UID = (String)rowArray[0];
CourseNumber = (String)rowArray[2];
Department = (String)rowArray[4];
Hours = (Int64)rowArray[3];
SemOffered = (String)rowArray[9];
String entry = (String)rowArray[5]; //gets list of reqs and parses them into nodes for a list
if (entry.Equals(""))
{
CoReq = null;
}
else
{
CoReq = ParseGPS.parseReqs(entry);
}
entry = (String)rowArray[6];
if (entry.Equals(""))
{
Prereq = null;
}
else
{
Prereq = ParseGPS.parseReqs(entry);
}
entry = (String)rowArray[7];
if (entry.Equals(""))
{
PrereqOrCoreq = null;
}
else
{
PrereqOrCoreq = ParseGPS.parseReqs(entry);
}
}
//Constructs Course Object, using name it queries the database and gets the information for the class
//Class lacks exception handling and does not account for the class name entered being invalid
public Course(string nameorUID, AcademicStatus taken)
{
Depth = -1;
if (nameorUID != "")
{
//Populate the course.
this.Prereq = new List <string>();
this.CoReq = new List <string>();
this.PrereqOrCoreq = new List <string>();
Status = taken;
//SemesterTaken = -1;
DataTable result = GraduationPlanningSystem.db.find(nameorUID, "course");
if (result.Rows.Count == 0)
{
result = GraduationPlanningSystem.db.find(nameorUID, "uid");
}
if (result.Rows.Count > 0)
{
DataRow[] rows = result.Select();
Object[] rowArray = rows[0].ItemArray;
Name = (String)rowArray[1];
UID = (String)rowArray[0];
CourseNumber = (String)rowArray[2];
Department = (String)rowArray[4];
Hours = (Int64)rowArray[3];
SemOffered = (String)rowArray[9];
String entry = (String)rowArray[6]; //gets list of reqs and parses them into nodes for a list
if (entry.Equals(""))
{
CoReq = new List <string>();
}
else
{
CoReq = ParseGPS.parseReqs(entry);
}
entry = (String)rowArray[5];
if (entry.Equals(""))
{
Prereq = new List <string>();
}
else
{
Prereq = ParseGPS.parseReqs(entry);
}
entry = (String)rowArray[7];
if (entry.Equals(""))
{
PrereqOrCoreq = new List <string>();
}
else
{
PrereqOrCoreq = ParseGPS.parseReqs(entry);
}
}
}
}
