public List <CourseStatisticsViewModel> GetAllInformation(int departmentId)
{
Query = "SELECT * FROM CourseAssigned WHERE DepartmentId='" + departmentId + "'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <CourseStatisticsViewModel> aCourseStatisticsViewModelscourses = new List <CourseStatisticsViewModel>();
while (Reader.Read())
{
CourseStatisticsViewModel aCourse = new CourseStatisticsViewModel();
aCourse.CourseCode = Reader["Code"].ToString();
aCourse.CourseName = Reader["CourseName"].ToString();
aCourse.SemesterName = Reader["Semester"].ToString();
if (Reader["AssignFlag"] == DBNull.Value || Convert.ToInt32(Reader["AssignFlag"]) == 0)
{
aCourse.AssignedTo = "Not Assigned yet";
}
else
{
aCourse.AssignedTo = Reader["AssignTo"].ToString();
}
aCourseStatisticsViewModelscourses.Add(aCourse);
}
Reader.Close();
Connection.Close();
return(aCourseStatisticsViewModelscourses);
}
public ActionResult ViewInformation(CourseStatisticsViewModel aCourseStatisticsViewModel)
{
ViewStatisticsManager aViewStatisticsManager = new ViewStatisticsManager();
ViewBag.Departments = aViewStatisticsManager.GetAllDepartments();
return(View());
}
public List <CourseStatisticsViewModel> ViewCourseStatistics(int departmentId)
{
string query = @"SELECT c.Code AS CourseCode, c.Name AS CourseName, c.DepartmentId DepartmentId, Semester.Name AS SemesterName,Teacher.Name AS TeacherName,A.TeacherId AS TeacherId
FROM Course AS c LEFT JOIN
Semester ON c.SemesterId = Semester.SemesterId LEFT JOIN AssignCourseToTeacher AS a ON C.CourseId=A.CourseId LEFT JOIN Teacher ON a.TeacherId=Teacher.TeacherId WHERE c.DepartmentId=" + departmentId;
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <CourseStatisticsViewModel> courseStatisticsViewModels = new List <CourseStatisticsViewModel>();
while (Reader.Read())
{
CourseStatisticsViewModel courseStatistics = new CourseStatisticsViewModel();
courseStatistics.DepartmentId = Convert.ToInt32(Reader["DepartmentId"]);
courseStatistics.CourseCode = (Reader["CourseCode"]).ToString();
courseStatistics.CourseName = (Reader["CourseName"]).ToString();
courseStatistics.SemesterName = (Reader["SemesterName"]).ToString();
if (Reader["TeacherName"].ToString() != "")
{
courseStatistics.TeacherName = Reader["TeacherName"].ToString();
}
else
{
courseStatistics.TeacherName = "Not Assigned Yet";
}
//courseStatistics.TeacherName = (Reader["TeacherName"]).ToString();
courseStatisticsViewModels.Add(courseStatistics);
}
Reader.Close();
Connection.Close();
return(courseStatisticsViewModels);
}
