public JsonResult GetTeachersByDepartmentId(int departmentId)
{
//var teachers = aCourseAssignManager.GetAllTeachers();
//var teacherList = teachers.Where(a => a.DepartmentId == departmentId).ToList();
//return Json(teacherList);
var teacherDetails = aCourseAssignManager.GetTeacherByDepartmentId(departmentId);
var courseDetails = aCourseAssignManager.GetCourseByDepartmentId(departmentId);
Departmentmustafa departmentmustafa = new Departmentmustafa();
departmentmustafa.Courses = courseDetails;
departmentmustafa.Teachers = teacherDetails;
return(Json(departmentmustafa));
}
public List <Departmentmustafa> GetAllDepartments()
{
Query = "SELECT * FROM Department";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <Departmentmustafa> departments = new List <Departmentmustafa>();
while (Reader.Read())
{
Departmentmustafa aDepartmentmustafa = new Departmentmustafa();
aDepartmentmustafa.Id = (int)Reader["Id"];
aDepartmentmustafa.Name = Reader["Name"].ToString();
departments.Add(aDepartmentmustafa);
}
Reader.Close();
Connection.Close();
return(departments);
}
