public JsonResult GetTeacherInfo(int teacherId)
{
Teacher teacher = db.Teachers.Find(teacherId);
Teacher aTeacher = new Teacher
{
TeacherCraditLimit = teacher.TeacherCraditLimit,
RemainingCradit = teacher.RemainingCradit
};
return Json(aTeacher, JsonRequestBehavior.AllowGet);
}
public JsonResult GetTeacherByDepartmentId(int departmentId)
{
var teachers = db.Teachers.Include(d => d.Department).Include(d => d.Designation).Where(d => d.DepartmentId == departmentId);
List<Teacher> teacher = teachers.ToList();
List<Teacher> jsonList = new List<Teacher>();
foreach (Teacher teac in teacher)
{
Teacher aTeacher = new Teacher();
Designation aDesignation = new Designation();
Department aDepartment = new Department();
aTeacher.TeacherId = teac.TeacherId;
aDepartment.DepartmentCode = teac.Department.DepartmentCode;
aDesignation.DesignationName = teac.Designation.DesignationName;
aTeacher.Department = aDepartment;
aTeacher.Designation = aDesignation;
aTeacher.TeacherName = teac.TeacherName;
aTeacher.Email = teac.Email;
aTeacher.ContactNo = teac.ContactNo;
jsonList.Add(aTeacher);
}
return jsonList.Count == 0 ? Json(0, JsonRequestBehavior.AllowGet) : new JsonResult{Data = jsonList, JsonRequestBehavior = JsonRequestBehavior.AllowGet};
}
public JsonResult GetAssignInfo(int departmentId)
{
var assignInfo =
db.AssiginCourseToTeachers.Include(a => a.Department)
.Include(a => a.Course)
.Include(a => a.Teacher)
.Where(a => a.DepartmentId == departmentId);
var listedAssign = assignInfo.ToList();
List<AssiginCourseToTeacher> assiginCourse = new List<AssiginCourseToTeacher>();
foreach (AssiginCourseToTeacher assignResult in listedAssign)
{
Semister aSemister = new Semister();
Course aCourse = new Course();
Teacher aTeacher = new Teacher();
AssiginCourseToTeacher assigin = new AssiginCourseToTeacher();
//Semister semister =
// db.Semisters.FirstOrDefault(
// s => db.Courses.Find(assignResult.CourseId).SemisterId == s.SemisterId);
aSemister.SemisterName = assignResult.Course.Semister.SemisterName;
aCourse.CourseCode = assignResult.Course.CourseCode;
aCourse.CourseName = assignResult.Course.CourseName;
aCourse.Semister = aSemister;
assigin.Course = aCourse;
aTeacher.TeacherName = assignResult.Teacher.TeacherName;
assigin.Teacher = aTeacher;
assiginCourse.Add(assigin);
}
return Json(assiginCourse.OrderBy(a => a.Course.CourseCode), JsonRequestBehavior.AllowGet);
}
