public JsonResult GetCourseInfo(int courseId)
 {
     var course = db.Courses.Find(courseId);
     Course aCourse = new Course
     {
         CourseName = course.CourseName,
         Cradit = course.Cradit
     };
     return Json(aCourse, 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);
        }