public ActionResult GetCourseByDepartment(int departmentId)
{
//var course = _courseRepository.AllCourse().Where(c => c.SemesterId == departmentId).FirstOrDefault();
//return Json(course);
var model = new ViewCourseStaticsViewModel();
model.CourseList = _courseRepository.AllCourseTS().Where(c => c.DepartmentId == departmentId).ToList();
//var CAT = model.CourseList.Select(c => new { c.Code, c.Name, c.Semester.SemesterName }).ToList();
return(Json(model.CourseList));
}
public ActionResult ViewCourseStatic()
{
var model = new ViewCourseStaticsViewModel();
model.DepartmentSelectListItems = _courseRepository.AllDepartment()
.Select(c => new SelectListItem()
{
Value = c.Id.ToString(), Text = c.Name
}).ToList();
model.CourseList = _courseRepository.AllCourseTS();
//var CourseList = _courseRepository.AllCourse();
return(View(model));
}
// FOR VIEW COUSE STATICS
// retrive course with teacher assigned by department
public List <ViewCourseStaticsViewModel> GetAllCourseWithTeacherAssigned(int departmentId)
{
Connection.Open();
string query =
"SELECT Course.Code AS CourseCode, Course.Name AS CourseName, Semester.SemesterName AS Semester, Teacher.Name AS AssignTo FROM Course LEFT JOIN AssignCourseToTeacher ON Course.Id = AssignCourseToTeacher.CourseId AND AssignCourseToTeacher.Type='ASSIGNED' LEFT JOIN Teacher ON Teacher.Id = AssignCourseToTeacher.TeacherId LEFT JOIN Semester ON Semester.Id = Course.SemesterId WHERE Course.DepartmentId = @departmentId";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@departmentId", departmentId);
Reader = Command.ExecuteReader();
List <ViewCourseStaticsViewModel> courseStaticsViewModels = new List <ViewCourseStaticsViewModel>();
while (Reader.Read())
{
ViewCourseStaticsViewModel viewCourseStaticsViewModel = new ViewCourseStaticsViewModel();
viewCourseStaticsViewModel.CourseCode = Reader["CourseCode"].ToString();
viewCourseStaticsViewModel.CourseName = Reader["CourseName"].ToString();
viewCourseStaticsViewModel.SemesterName = Reader["Semester"].ToString();
string assignTo = Reader["AssignTo"].ToString();
if (assignTo.Equals(""))
{
viewCourseStaticsViewModel.AssignTo = "Not Assigned";
}
else
{
viewCourseStaticsViewModel.AssignTo = Reader["AssignTo"].ToString();
}
courseStaticsViewModels.Add(viewCourseStaticsViewModel);
}
Reader.Read();
Connection.Close();
return(courseStaticsViewModels);
}
