public ActionResult CreateDepartmentCourse(DepartmentCourseViewModel model)
{
if (ModelState.IsValid)
{
//DepartmentService departmentService = new DepartmentService();
Departments dept = new Departments();
dept.Name = model.DepartmentName;
dept.Budget = Convert.ToDouble(model.DepartmentBudget);
dept.StartDate = model.StartDate;
dept.CreatedDate = model.CreatedDate;
dept.CreatedBy = model.CreatedBy;
dept.UpdatedDate = model.UpdatedDate;
dept.UpdatedBy = model.UpdatedBy;
dept.InstructorId = model.InstructorId;
_departmentService.CreateDepartment(dept);
CourseService courseService = new CourseService();
Courses course = new Courses();
course.Title = model.CourseName;
course.DepartmentId = model.DepartmentId;
course.CreatedDate = model.CreatedDate;
course.CreatedBy = model.CreatedBy;
course.UpdatedDate = model.UpdatedDate;
course.UpdatedBy = model.UpdatedBy;
courseService.CreateCourse(course);
return(RedirectToAction("Index"));
//return View(model);
}
else
{
return(View(model));
}
}
public List <DepartmentCourseViewModel> GetCoursesUnderDept(int registrationId)
{
string query = "SELECT * FROM DepartmentCourseViewModel WHERE Id = @Id";
_command = new SqlCommand(query, _connection);
_command.Parameters.AddWithValue("@Id", registrationId);
_connection.Open();
_reader = _command.ExecuteReader();
List <DepartmentCourseViewModel> departmentCourseViewModels = new List <DepartmentCourseViewModel>();
while (_reader.Read())
{
DepartmentCourseViewModel aDepartmentCourseViewModel = new DepartmentCourseViewModel();
aDepartmentCourseViewModel.Id = Convert.ToInt32(_reader["Id"]);
aDepartmentCourseViewModel.CourseId = Convert.ToInt32(_reader["CourseId"]);
aDepartmentCourseViewModel.CourseCode = _reader["CourseCode"].ToString();
aDepartmentCourseViewModel.CourseName = _reader["CourseName"].ToString();
aDepartmentCourseViewModel.DeptCode = _reader["DeptCode"].ToString();
aDepartmentCourseViewModel.DeptName = _reader["DeptName"].ToString();
departmentCourseViewModels.Add(aDepartmentCourseViewModel);
}
_reader.Close();
_connection.Close();
return(departmentCourseViewModels);
}
public ActionResult CreateDepartmentCourse(DepartmentCourseViewModel model)
{
Department dept = new Department();
dept.Name = model.DepartmentName;
dept.Budget = model.DepartmentBudget;
departmentService.AddDepartment(dept);
CourseService courseService = new CourseService();
Course course = new Course();
course.Title = model.CourseName;
courseService.AddCourse(course);
return(View());
}
public IActionResult NestedDDL()
{
var departments =
new SelectList(database.Departments.ToList(), "DepartmentID", "DepartmentName");
var courses =
new SelectList(database.Courses.ToList(), "CourseID", "CourseName");
var viewModel = new DepartmentCourseViewModel();
viewModel.Departments = departments;
viewModel.Courses = courses;
return View(viewModel);
}
public ActionResult CreateDepartmentAndCourse(DepartmentCourseViewModel model)
{
DepartmentService departmentService = new DepartmentService();
Departments department = new Departments();
department.Name = model.DepartmentName;
department.Budget = Convert.ToDouble(model.DepartmentBudget);
departmentService.AddDepartments(department);
CourseService courseService = new CourseService();
Courses course = new Courses();
course.Title = model.CourseName;
courseService.AddCourses(course);
return(View());
}
public ActionResult CreateDepartmentCourse(DepartmentCourseViewModel model)
{
DepartmentService departmentService = new DepartmentService();
Department dept = new Department();
dept.Name = model.DepartmentName;
dept.Budget = Convert.ToDecimal(model.DepartmentBudget);
CourseService courseService = new CourseService();
Course course = new Course();
course.Title = model.CourseName;
courseService.CreateCourse(course);
return(View());
}
public void NestedDDL(DepartmentCourseViewModel model)
{
int departmentID = model.DepartmentID;
int courseID = model.CourseID;
}
