public JsonResult GetCourseStatics(int departmentId)
{
var courseDetails = courseManager.GetAllCourseWithSemester();
var courseWithAssignedTeachersData = teacherManager.GetAllCourseWithAssignedTeachers();
List <CourseDetailsWithTDS> courseData = new List <CourseDetailsWithTDS>();
foreach (var course in courseDetails)
{
if (course.DepatmentId == departmentId)
{
CourseDetailsWithTDS courseDetailsWithTds = new CourseDetailsWithTDS();
courseDetailsWithTds.CourseCode = course.CourseCode;
courseDetailsWithTds.CourseName = course.CourseName;
courseDetailsWithTds.Semester = course.Semester;
courseDetailsWithTds.TeacherName = "Not assigned yet";
foreach (var data in courseWithAssignedTeachersData)
{
if (course.CourseId == data.CourseId)
{
courseDetailsWithTds.TeacherName = data.TeacherName;
break;
}
else
{
courseDetailsWithTds.TeacherName = "Not assigned yet";
}
}
courseData.Add(courseDetailsWithTds);
}
}
return(Json(courseData));
}
public List <CourseDetailsWithTDS> GetAllAssignedCourses()
{
Qurey = "SELECT * FROM AssignCourses WHERE status=@status";
Command = new SqlCommand(Qurey, Connection);
Command.Parameters.AddWithValue("@status", "active");
List <CourseDetailsWithTDS> courseDetails = new List <CourseDetailsWithTDS>();
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
CourseDetailsWithTDS course = new CourseDetailsWithTDS();
course.CourseId = Convert.ToInt32(Reader["courseId"]);
course.TeacherId = Convert.ToInt32(Reader["teacherId"]);
courseDetails.Add(course);
}
Reader.Close();
Connection.Close();
return(courseDetails);
}
public List <CourseDetailsWithTDS> GetCourseDetails()
{
Qurey = "SELECT * FROM courseDetailsWithTeacherSemesterDepartment";
Command = new SqlCommand(Qurey, Connection);
List <CourseDetailsWithTDS> coursesdata = new List <CourseDetailsWithTDS>();
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
CourseDetailsWithTDS courseDetails = new CourseDetailsWithTDS();
courseDetails.CourseCode = Reader["courseCode"].ToString();
courseDetails.CourseName = Reader["courseName"].ToString();
courseDetails.CourseId = Convert.ToInt32(Reader["courseId"]);
if (Reader["teacherName"] == DBNull.Value)
{
courseDetails.TeacherName = "Not Assigned Yet";
}
else
{
courseDetails.TeacherName = Reader["teacherName"].ToString();
}
if (Reader["teacherId"] == DBNull.Value)
{
courseDetails.TeacherId = 0;
}
else
{
courseDetails.TeacherId = Convert.ToInt32(Reader["teacherId"]);
}
courseDetails.Semester = Reader["semester"].ToString();
courseDetails.DepatmentId = Convert.ToInt32(Reader["departmentId"]);
coursesdata.Add(courseDetails);
}
Reader.Close();
Connection.Close();
return(coursesdata);
}
public List <CourseDetailsWithTDS> GetAllCourseWithSemester()
{
Qurey = "SELECT * FROM courseWithSemester";
Command = new SqlCommand(Qurey, Connection);
List <CourseDetailsWithTDS> courseDetails = new List <CourseDetailsWithTDS>();
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
CourseDetailsWithTDS course = new CourseDetailsWithTDS();
course.CourseId = Convert.ToInt32(Reader["id"]);
course.CourseCode = Reader["courseCode"].ToString();
course.CourseName = Reader["courseName"].ToString();
course.Semester = Reader["semester"].ToString();
course.DepatmentId = Convert.ToInt32(Reader["departmentId"]);
courseDetails.Add(course);
}
Reader.Close();
Connection.Close();
return(courseDetails);
}
