public ActionResult CourseAssignTeacher()
{
var model = new CourseAssignTeacherViewModel();
model.DepartmentSelectListItems = _courseRepository.AllDepartment()
.Select(c => new SelectListItem()
{
Value = c.Id.ToString(), Text = c.Name
}).ToList();
model.TeacherSelectListItems = _courseRepository.AllTeacher()
.Select(c => new SelectListItem()
{
Value = c.Id.ToString(), Text = c.Name
}).ToList();
model.CourseSelectListItems = _courseRepository.AllCourse()
.Select(c => new SelectListItem()
{
Value = c.Id.ToString(), Text = c.Name
}).ToList();
//ViewBag.dpl = _courseRepository.AllDepartment().ToList();
//ViewBag.tl = _courseRepository.AllTeacher().ToList();
//ViewBag.cl = _courseRepository.AllCourse().ToList();
ViewBag.Sm = TempData["Sm"];
ViewBag.Em = TempData["Em"];
return(View(model));
}
public List <CourseAssignTeacherViewModel> GetAllCoursesStatics()
{
string query = "SELECT * FROM CourseAssignTeacherViewModel";
_command = new SqlCommand(query, _connection);
_connection.Open();
_reader = _command.ExecuteReader();
List <CourseAssignTeacherViewModel> courseAssignTeacherViewModels = new List <CourseAssignTeacherViewModel>();
while (_reader.Read())
{
CourseAssignTeacherViewModel assignTeacherViewModel = new CourseAssignTeacherViewModel();
assignTeacherViewModel.CourseCode = _reader["CourseCode"].ToString();
assignTeacherViewModel.CourseName = _reader["CourseName"].ToString();
assignTeacherViewModel.SemesterName = _reader["SemesterName"].ToString();
assignTeacherViewModel.TeacherName = _reader["TeacherName"].ToString();
if (assignTeacherViewModel.TeacherName.IsEmpty())
{
assignTeacherViewModel.TeacherName = "Not Assigned To";
}
assignTeacherViewModel.DepartmentId = Convert.ToInt32(_reader["Id"]);
courseAssignTeacherViewModels.Add(assignTeacherViewModel);
}
_reader.Close();
_connection.Close();
return(courseAssignTeacherViewModels);
}
