public static List<Department> GetAll()
{
List<Department> allDepartments = new List<Department> {};
SqlConnection conn = DB.Connection();
SqlDataReader rdr = null;
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM departments;", conn);
rdr = cmd.ExecuteReader();
while(rdr.Read())
{
string courseName = rdr.GetString(0);
int courseId = rdr.GetInt32(1);
Department newDepartment = new Department(courseName, courseId);
allDepartments.Add(newDepartment);
}
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return allDepartments;
}
public static Department Find(int id)
{
SqlConnection conn = DB.Connection();
SqlDataReader rdr = null;
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM departments WHERE id = @DepartmentId;", conn);
SqlParameter courseIdParameter = new SqlParameter();
courseIdParameter.ParameterName = "@DepartmentId";
courseIdParameter.Value = id.ToString();
cmd.Parameters.Add(courseIdParameter);
rdr = cmd.ExecuteReader();
int foundDepartmentId = 0;
string foundDepartmentName = null;
while(rdr.Read())
{
foundDepartmentName = rdr.GetString(0);
foundDepartmentId = rdr.GetInt32(1);
}
Department foundDepartment = new Department(foundDepartmentName, foundDepartmentId);
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return foundDepartment;
}
public void Test_Equal_ReturnsTrueIfNamesAndEnrollmentDatesAreTheSame()
{
//Arrange, Act
Department firstDepartment = new Department("History");
Department secondDepartment = new Department("History");
//Assert
Assert.Equal(firstDepartment, secondDepartment);
}
public void Test_Find_FindsDepartmentInDatabase()
{
//Arrange
Department testDepartment = new Department("History");
testDepartment.Save();
//Act
Department foundDepartment = Department.Find(testDepartment.GetId());
//Assert
Assert.Equal(testDepartment, foundDepartment);
}
public void Test_AddMajor_DisplaysAddedMajors()
{
Student testStudent = new Student("Bob", enrollmentDate);
testStudent.Save();
Department testDepartment = new Department("History");
testDepartment.Save();
testStudent.AddMajor(testDepartment.GetId());
List<Department> resultList = testStudent.GetMajors();
List<Department> expectedList= new List<Department>{testDepartment};
Assert.Equal(expectedList, resultList);
}
public void Test_Save_AssignsIdToObject()
{
//Arrange
Department testDepartment = new Department("History");
//Act
testDepartment.Save();
Department savedDepartment = Department.GetAll()[0];
int result = savedDepartment.GetId();
int testId = testDepartment.GetId();
//Assert
Assert.Equal(testId, result);
}
public void Test_DropMajor_DropsSelectedMajor()
{
Student testStudent = new Student("Bob", enrollmentDate);
testStudent.Save();
Department testDepartment1 = new Department("Chinese");
testDepartment1.Save();
testStudent.AddMajor(testDepartment1.GetId());
Department testDepartment2 = new Department("Spanish");
testDepartment2.Save();
testStudent.AddMajor(testDepartment2.GetId());
testStudent.DropMajor(testDepartment1.GetId());
List<Department> resultList = testStudent.GetMajors();
List<Department> expectedList= new List<Department>{testDepartment2};
Assert.Equal(expectedList, resultList);
}
public HomeModule()
{
Get["/"]=_=>View["index.cshtml"];
Get["/courses"]=_=>
{
List<Course> allCourses = Course.GetAll();
return View["courses.cshtml", allCourses];
};
Get["/courses/new"]=_=>{
List<Department> departments = Department.GetAll();
return View["course_new.cshtml" , departments];
};
Post["/courses/new"]=_=>
{
Course newCourse = new Course(Request.Form["course-name"], Request.Form["department"]);
newCourse.Save();
List<Course> allCourses = Course.GetAll();
return View["courses.cshtml", allCourses];
};
// Get["courses/{id}"] = parameters =>
// {
// Course course = Course.Find(parameters.id);
// return View["course.cshtml", course];
// };
Get["students/{id}"] = parameters =>
{
Student student = Student.Find(parameters.id);
return View["student.cshtml", student];
};
Get["/students"]=_=>
{
List<Student> allStudents = Student.GetAll();
return View["students.cshtml", allStudents];
};
Get["/students/new"]=_=>View["student_new.cshtml"];
Post["/students/new"]=_=>
{
Student newStudent = new Student(Request.Form["student-name"], Request.Form["enrollment-date"]);
newStudent.Save();
List<Student> allStudents = Student.GetAll();
return View["students.cshtml", allStudents];
};
Post["/students/{id}/addCourse"] = parameters =>
{
Student student = Student.Find(parameters.id);
student.AddCourse(Request.Form["course"]);
return View["student.cshtml", student];
};
Post["/students/{id}/deleteCourse"] = parameters =>
{
Student student = Student.Find(parameters.id);
student.DropCourse(Request.Form["course"]);
return View["student.cshtml", student];
};
Post["/students/{id}/updatemajors"]=parameters=>
{
Student student = Student.Find(parameters.id);
int majorCount = student.GetMajors().Count;
if(majorCount == 0 && Request.Form["new-major"] !=0)
{
student.AddMajor(Request.Form["new-major"]);
}
else if(majorCount == 1)
{
if(Request.Form["current-major"]==0)
{
student.DropMajor(Request.Form["current-major"]);
}
else if(Request.Form["current-major"]!=student.GetMajors()[0].GetId())
{
student.DropMajor(student.GetMajors()[0].GetId());
student.AddMajor(Request.Form["current-major"]);
}
if(Request.Form["additional-major"] !=0)
{
student.AddMajor(Request.Form["additonal-major"]);
}
}
else
{
if(Request.Form["first-major"]==0)
{
student.DropMajor(Request.Form["first-major"]);
}
else if(Request.Form["first-major"]!=student.GetMajors()[0].GetId())
{
student.DropMajor(student.GetMajors()[0].GetId());
student.AddMajor(Request.Form["first-major"]);
}
if(Request.Form["second-major"]==0)
{
student.DropMajor(Request.Form["second-major"]);
}
else if(Request.Form["second-major"]!=student.GetMajors()[1].GetId())
{
student.DropMajor(student.GetMajors()[1].GetId());
student.AddMajor(Request.Form["second-major"]);
}
}
return View["student.cshtml", student];
};
Get["/departments"]=_=>
{
List<Department> departments = Department.GetAll();
return View["departments.cshtml", departments];
};
Get["/departments/new"]=_=>View["department_new.cshtml"];
Post["/departments/new"]=_=>
{
Department department = new Department(Request.Form["department-name"]);
department.Save();
List<Department> departments = Department.GetAll();
return View["departments.cshtml", departments];
};
Get["/departments/{id}"]=parameters=>
{
Department department = Department.Find(parameters.id);
return View["department.cshtml", department];
};
}
public void Test_Save_SavesToDatabase()
{
//Arrange
Department testDepartment = new Department("History");
//Act
testDepartment.Save();
List<Department> result = Department.GetAll();
List<Department> testList = new List<Department>{testDepartment};
//Assert
Assert.Equal(testList, result);
}
public List<Department> GetMajors()
{
SqlConnection conn = DB.Connection();
SqlDataReader rdr;
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT departments.* FROM students JOIN majors ON (students.id = majors.student_id) JOIN departments ON (majors.department_id = departments.id) WHERE students.id = @StudentId;", conn);
SqlParameter idParameter = new SqlParameter();
idParameter.ParameterName = "@StudentId";
idParameter.Value = _id;
cmd.Parameters.Add(idParameter);
rdr = cmd.ExecuteReader();
List<Department> foundMajors = new List<Department>{};
string foundMajorName = null;
int foundDepartmentId = 0;
while(rdr.Read())
{
foundMajorName = rdr.GetString(0);
foundDepartmentId = rdr.GetInt32(1);
Department foundMajor = new Department(foundMajorName, foundDepartmentId);
foundMajors.Add(foundMajor);
}
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return foundMajors;
}
