public List <CourseTeacherVM> GetCourseStatics()
{
SqlConnection connection = new SqlConnection(connectionStrings);
SqlCommand command = new SqlCommand("GetCourseStatics", connection);
command.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(command);
DataTable dt = new DataTable();
connection.Open();
da.Fill(dt);
connection.Close();
var courses = new List <CourseTeacherVM>();
for (int i = 0; i < dt.Rows.Count; i++)
{
var course = new CourseTeacherVM();
course.DepartmentId = Convert.ToInt32(dt.Rows[i]["DepartmentId"]);
course.CourseName = dt.Rows[i]["CName"].ToString();
course.Code = dt.Rows[i]["Code"].ToString();
course.Semester = course.Semester;
course.TeacherName = dt.Rows[i]["TName"].ToString();
courses.Add(course);
}
return(courses);
}
// GET: Courses
public async Task <IActionResult> Index(string coursetitle, string coursesemester, string courseprogramme)
{
IQueryable <Course> courses = _context.Course.AsQueryable();
if (!string.IsNullOrEmpty(coursetitle))
{
courses = courses.Where(s => s.Title.Contains(coursetitle));
}
if (!string.IsNullOrEmpty(coursesemester))
{
courses = courses.Where(s => s.Semester.ToString().Contains(coursesemester));
}
if (!string.IsNullOrEmpty(courseprogramme))
{
courses = courses.Where(s => s.Programme.Contains(courseprogramme));
}
var courseTeacherVM = new CourseTeacherVM
{
Courses = await courses.ToListAsync()
};
var eduMVCContext = _context.Course.Include(c => c.FirstTeacher).Include(c => c.SecondTeacher);
return(View(courseTeacherVM));
}
