public List <Course> GetAllcourses(ViewStudentInformation aViewStudentInformation)
{
int flag;
CourseGateway aCourseGateway = new CourseGateway();
List <Course> courseList = new List <Course>();
List <Course> courses = new List <Course>();
List <Course> newCourses = new List <Course>();
courses = GetStudentCourses(aViewStudentInformation.RegistationNo);
courseList = aCourseGateway.GetCoursesByDepartment(aViewStudentInformation);
foreach (Course deptCourse in courseList)
{
flag = 0;
foreach (Course course in courses)
{
if (deptCourse.CourseCode == course.CourseCode)
{
flag = 1;
}
}
if (flag == 0)
{
newCourses.Add(deptCourse);
}
}
return(newCourses);
}
public AllocateClassRoomManager()
{
allocateClassRoomGateway = new AllocateClassRoomGateway();
courseGateway = new CourseGateway();
classRoomGateway = new ClassRoomGateway();
courseManager = new CourseManager();
}
public List <Course> GetAllUnscheduledCourses(Course aCourse)
{
List <Course> unscheduleCourseList = new List <Course>();
aCourseGateway = new CourseGateway();
List <Course> courseList = new List <Course>();
courseList = aCourseGateway.GetAllCoursesByDepartment(aCourse.ADepartment.DepartmentId,
aCourse.ASemester.SemesterId);
List <int> coursesId = new List <int>();
int status;
coursesId = aCourseGateway.GetScheduleCoursesId(aCourse);
foreach (Course course in courseList)
{
status = 0;
foreach (int courseId in coursesId)
{
if (courseId == course.CourseId)
{
status = 1;
}
}
if (status == 0)
{
unscheduleCourseList.Add(course);
}
}
return(unscheduleCourseList);
}
public ViewResult Create(Course course)
{
CourseViewModel viewModel = new CourseViewModel
{
Departments = DepartmentGateway.GetAllDepartments(),
Semesters = SemesterGateway.GetAllSemseters()
};
if (!ModelState.IsValid)
{
viewModel.Course = course;
return(View(viewModel));
}
int rowAffected = CourseGateway.Save(course);
if (rowAffected > 0)
{
ViewBag.message = "Course Saved";
viewModel.Course = new Course();
return(View(viewModel));
}
return(View("~/Views/Shared/BadRequest.cshtml"));
}
public List <Course> GetStudentMinorCourses(string departmentCode, string regNo)
{
int flag;
CourseGateway aCourseGateway = new CourseGateway();
List <Course> courseList = new List <Course>();
List <Course> courses = new List <Course>();
List <Course> newCourses = new List <Course>();
courses = GetStudentCourses(regNo);
courseList = aCourseGateway.GetCoursesByDepartment();
foreach (Course deptCourse in courseList)
{
flag = 0;
foreach (Course course in courses)
{
if (deptCourse.CourseCode == course.CourseCode)
{
flag = 1;
}
}
if (flag == 0)
{
newCourses.Add(deptCourse);
}
}
return(newCourses);
}
public List <Course> GetAllCourses()
{
aCourseGateway = new CourseGateway();
List <Course> courses = new List <Course>();
courses = aCourseGateway.GetAllCourses();
return(courses);
}
public JsonResult GetCourseById(int courseId)
{
Course course = CourseGateway.GetCourseById(courseId);
if (course == null)
{
return(Json("Course was not found by this Id", JsonRequestBehavior.AllowGet));
}
return(Json(course, JsonRequestBehavior.AllowGet));
}
public JsonResult GetTeachersAndCoursesByDepartment(int departmentId)
{
if (departmentId <= 0)
{
return(Json("Department Id cannot be null or less than zero"));
}
IEnumerable <Teacher> teachers = TeacherGateway.GetTeachersByDepartmentId(departmentId);
IEnumerable <Course> courses = CourseGateway.GetCoursesByDepartment(departmentId);
return(Json(new { teachers, courses }, JsonRequestBehavior.AllowGet));
}
public string SaveIntoDataBase(Course aCourse)
{
if (aCourse.Code != string.Empty && aCourse.Name != string.Empty)
{
aCourseGateway = new CourseGateway();
int isAffected = aCourseGateway.SaveIntoDataBase(aCourse);
if (isAffected == 1)
{
return("Successfully Inserted");
}
return("Invalid Insertion");
}
return("Please Fill Up All The Text Boxes");
}
public string SaveCourse(Course aCourse)
{
aCourseGateway = new CourseGateway();
if (!DoesThisCourseNameExist(aCourse))
{
if (!DoesThisCourseCodeExist(aCourse))
{
return(aCourseGateway.SaveCourse(aCourse));
}
else
{
return("This Course Code already Exist");
}
}
else
{
return("This Course Name already Exist");
}
}
public JsonResult SaveCourseAssign(CourseAssign courseAssign)
{
var checkCourseAssign =
db.CourseAssigns.Where(x => x.CourseID == courseAssign.CourseID && x.Course.CourseStatus == true).ToList();
if (checkCourseAssign.Count > 0)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
else
{
db.CourseAssigns.Add(courseAssign);
db.SaveChanges();
var teacher = db.Teachers.Single(x => x.Id == courseAssign.TeacherId);
if (teacher != null)
{
teacher.CreditLeft = courseAssign.CreditLeft;
db.Teachers.AddOrUpdate(teacher);
db.SaveChanges();
var course = db.Courses.Single(x => x.Id == courseAssign.CourseID);
if (course != null)
{
course.CourseStatus = true;
course.CourseAssignTo = teacher.TeacherName;
CourseGateway courseGateway = new CourseGateway();
courseGateway.UpdateCourseStatus(course);
return(Json(true, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
}
public ViewResult Assign(CourseAssignment courseAssignment)
{
CourseAssignmentViewModel viewModel = new CourseAssignmentViewModel
{
Departments = DepartmentGateway.GetAllDepartments()
};
if (!ModelState.IsValid)
{
return(View(viewModel));
}
int rowAffected = CourseGateway.Assign(courseAssignment);
if (rowAffected > 0)
{
return(View(viewModel));
}
return(View("~/Views/Shared/BadRequest.cshtml"));
}
public string ResetCourseScheduleAndUnassignedAllCourse()
{
aCourseGateway = new CourseGateway();
return(aCourseGateway.ResetCourseScheduleAndUnassignedAllCourse());
}
public JsonResult GetStatics(int departmentId)
{
return(Json(CourseGateway.GetCourseStatics(departmentId), JsonRequestBehavior.AllowGet));
}
public AssignCourseManager()
{
assignCourseGataway = new AssignCourseGataway();
courseGateway = new CourseGateway();
teacherGateway = new TeacherGateway();
}
public List <Course> GetAllUnassignedCourses(Course aCourse)
{
aCourseGateway = new CourseGateway();
return(aCourseGateway.GetAllUnassignedCourses(aCourse));
}
public CourseController(CourseGateway courseGateway)
{
_courseGateway = courseGateway;
}
public List <ShowCourse> GetScheduleCoursesByDepartmentId(int departmentId)
{
aCourseGateway = new CourseGateway();
return(aCourseGateway.GetScheduleCoursesByDepartmentId(departmentId));
}
public string Save(Course aCourse)
{
aCourseGateway = new CourseGateway();
return(aCourseGateway.Save(aCourse));
}
public CourseManager()
{
courseGateway = new CourseGateway();
teacherAssaignGateway = new TeacherAssaignGateway();
}
public JsonResult GetCoursesByDepartment(int departmentId)
{
IEnumerable <Course> courses = CourseGateway.GetCoursesByDepartment(departmentId);
return(Json(courses, JsonRequestBehavior.AllowGet));
}
public List <ShowCourse> GetScheduleCoursesByDepartmentIdAndSemester(int departmentId, int semesterId)
{
aCourseGateway = new CourseGateway();
return(aCourseGateway.GetScheduleCoursesByDepartmentIdAndSemester(departmentId, semesterId));
}
public CourseManager()
{
courseGateway = new CourseGateway();
}
public CourseAssignToTeacherManager()
{
courseAssignToTeacherGateway = new CourseAssignToTeacherGateway();
teacherGateway = new TeacherGateway();
courseGateway = new CourseGateway();
}
public List <Course> GetAllCourses()
{
aCourseGateway = new CourseGateway();
return(aCourseGateway.GetAllCourses());
}
public List <Course> GetAllCoursesByDepartment(int departmentId, int semesteId)
{
aCourseGateway = new CourseGateway();
return(aCourseGateway.GetAllCoursesByDepartment(departmentId, semesteId));
}
public EnrollCourseManager()
{
_courseGateway = new CourseGateway();
aStudentRegistrationGateway = new StudentRegistrationGateway();
aEnrollCourseGateway = new EnrollCourseGateway();
}
