/// <summary>
/// Add a Department to the Instutite
/// </summary>
/// <param name="dept">The Department to add</param>
public void addDepartment(Department dept)
{
if (deptList == null)
{
deptList = new LinkedList();
}
deptList.addAtTail(dept);
}
public void Process_NewDepartmentEvent_SetsNAmeAndId()
{
var id = Guid.NewGuid();
var @event = new NewDepartmentEvent(id, "Test Department");
var department = new Department();
department.Process(@event);
Assert.Equal(id, department.Id);
Assert.Equal("Test Department", department.Name);
}
public Department GetById(Guid id)
{
var stream = _eventStore.Load(id);
var department = new Department();
foreach (var ev in stream)
{
department.Process(ev);
}
return department;
}
private Department GetTestDepartment()
{
var id = Guid.Parse(departmentId);
var department = new Department()
{
Id = id,
Name = "Test Department"
};
return department;
}
public void Process_NewCommitteeEvent_SetsCommitteeProperties()
{
var id = Guid.NewGuid();
var @event = new NewCommitteeEvent(id, "Test Committee", "mandate");
var department = new Department();
department.Process(@event);
var committee = department.Committees.First();
Assert.Equal(id, committee.Id);
Assert.Equal("Test Committee", committee.Name);
}
public void ShouldGetAllStudents()
{
var departmentFromDb = new Department { Id = 2, Code = "Code" };
var studentsFromDb = new List<Student> { new Student { Id = 1, Department = departmentFromDb } };
this.mockStudentRepository.Setup(repository => repository.GetAll()).Returns(studentsFromDb);
var students = studentService.GetAll();
Assert.That(students, Is.Not.Null);
Assert.That(students.Count, Is.EqualTo(1));
//TODO:to be fixed
//Assert.That(students.Select(x => x.Id), Is.EqualTo(studentsFromDb.Select(x => x.Id)));
//Assert.That(students[0].Department.Id, Is.EqualTo(departmentFromDb.Id));
}
public Department Build()
{
var department = new Department { Code = this.Code, Name = this.Name, };
return department;
}
public IActionResult Create()
{
var department = new Department();
var vm = Mapper.Map<DepartmentViewModel>(department);
return View(vm);
}
/// <summary>
/// load all the depts from the database
/// </summary>
private void loadDepartmentList()
{
Department tempDept ;
string sqlStatment = "SELECT * FROM Department";
try
{
OpenConection();
cmd = new OleDbCommand(sqlStatment, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
if (reader["Deleted"].ToString().Equals("False"))
{
tempDept = new Department(
reader["ID"].ToString(),
reader["Dept_Name"].ToString());
deptList.addAtTail(tempDept);
}
}
CloseConnection();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
}
/// <summary>
/// Insert a department into the database
/// </summary>
/// <param name="dept">The Department to be inserted</param>
public void insertDept(Department dept)
{
string sql = "INSERT INTO Department VALUES('"+ dept.name + "')";
excuteNonQuery(sql);
}
/// <summary>
/// Update a Department
/// </summary>
/// <param name="dept">The updated Department</param>
public void updateDept(Department dept)
{
string sql;
sql = "Update Department Dept_Name=";
sql += "'" + dept.name + "'";
excuteNonQuery(sql);
}
/// <summary>
/// Update a Department
/// </summary>
/// <param name="dept">The updated Department</param>
private void updateDept(Department dept)
{
string sql;
sql = "Update Department Dept_Name=";
sql += "'" + dept.getName() + "'";
excuteNonQuery(sql);
}
/// <summary>
/// Insert a department into the database
/// </summary>
/// <param name="dept">The Department to be inserted</param>
private void insertDept(Department dept)
{
string sql = "INSERT INTO Department VALUES('"+ dept.getName() + "')";
excuteNonQuery(sql);
}
/// <summary>
/// Load all the Lecturers for a given Department
/// </summary>
/// <param name="dept">The Department the Lecturers are in</param>
/// <returns>LinkedList of Lecturer</returns>
public LinkedList loadLectuerList(Department dept)
{
LinkedList lectureList = new LinkedList();
Lecturer newLec;
string sqlStatment = "SELECT Lec_Name, Initials, Email, MaxHours, MaxConsecHours, MinSlotsPerDays, SlotsOff, Deleted";
sqlStatment += "FROM Lecturer WHERE Lecturer.Dept_ID LIKE" + dept.getID();
try
{
OpenConection();
cmd = new OleDbCommand(sqlStatment, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
if (reader["Deleted"].ToString().Equals("False"))
{
newLec = new Lecturer();
newLec.setId(reader["ID"].ToString());
newLec.setName(reader["Lec_Name"].ToString());
newLec.setInitials(reader["Initials"].ToString());
newLec.setEmail(reader["Email"].ToString());
newLec.setMaxHours(Convert.ToInt32(reader["MaxHours"]));
newLec.setMaxConsecHours(Convert.ToInt32(reader["MaxConsecHours"]));
newLec.setMinSlotsPerDay(Convert.ToInt32(reader["MinSlotsPerDays"]));
newLec.setSlotsOff(reader["SlotsOff"].ToString());
lectureList.addAtTail(newLec);
}
}
CloseConnection();
}
catch
{
// MessageBox.Show("Failed to get data from source");
}
return lectureList;
}
/// <summary>
/// Returns a list of Departments
/// </summary>
/// <param name="institute">The Institute the Departments are in</param>
/// <returns>A LinkedList of Departments</returns>
public LinkedList loadDepartmentList(Institute institute)
{
LinkedList deptList = new LinkedList();
Department tempDept ;
string sqlStatment = "SELECT * FROM Department";
try
{
OpenConection();
cmd = new OleDbCommand(sqlStatment, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
if (reader["Deleted"].ToString().Equals("False"))
{
tempDept = new Department();
tempDept.setId(reader["ID"].ToString());
tempDept.setName(reader["Dept_Name"].ToString());
tempDept.setLecturerList(loadLectuerList(tempDept));
tempDept.setCourseList(loadCourseList(tempDept));
deptList.addAtTail("tempDept");
}
}
CloseConnection();
}
catch
{
}
return deptList;
}
/// <summary>
/// Load LinkedList of Course for a Department
/// </summary>
/// <param name="dept">The Department the Courses are in</param>
/// <returns>A LinkedList of Course</returns>
public LinkedList loadCourseList(Department dept)
{
LinkedList courses = new LinkedList();
Course tempCourse ;
string sqlStatment = "SELECT ID, Code, CourseName, NumOfStudents FROM Course WHERE DeptId Like " + dept.getID();
try
{
OpenConection();
cmd = new OleDbCommand(sqlStatment, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
if (reader["Deleted"].ToString().Equals("False"))
{
tempCourse = new Course();
tempCourse.setID(reader["ID"].ToString());
tempCourse.setCourseCode(reader["Code"].ToString());
tempCourse.setName(reader["CourseName"].ToString());
tempCourse.setNumOfStudents(Convert.ToInt32(reader["NumOfStudents"]));
tempCourse.setModuleList(LoadModuleList(tempCourse));
courses.addAtTail(tempCourse);
}
}
CloseConnection();
}
catch
{
// MessageBox.Show("Failed to get data from source");
}
return courses ;
}
