public JsonResult GetCourses(int progId, int deptId, int levelId)
{
List <COURSE> courses = new List <COURSE>();
List <SelectListItem> courseSelectList = new List <SelectListItem>();
try
{
if (progId > 0 && deptId > 0 && levelId > 0)
{
CourseLogic courseLogic = new CourseLogic();
courses = courseLogic.GetEntitiesBy(c => c.Department_Id == deptId && c.Level_Id == levelId && c.Programme_Id == progId && c.Active);
if (User.IsInRole("Lecturer"))
{
UserLogic userLogic = new UserLogic();
USER user = userLogic.GetEntityBy(u => u.Username == User.Identity.Name);
StaffLogic staffLogic = new StaffLogic();
StaffCourseLogic staffCourseLogic = new StaffCourseLogic();
STAFF staff = staffLogic.GetEntitiesBy(s => s.Person_Id == user.Person_Id).LastOrDefault();
if (staff != null)
{
List <STAFF_COURSE> staffCourses = staffCourseLogic.GetEntitiesBy(s => s.Staff_Id == staff.Person_Id);
if (staffCourses != null)
{
courses = staffCourses.Select(s => s.COURSE).ToList();
}
else
{
courses = new List <COURSE>();
}
}
}
SelectListItem list = new SelectListItem();
list.Value = "";
list.Text = "-- Select Course --";
courseSelectList.Add(list);
courses.ForEach(c =>
{
SelectListItem myList = new SelectListItem();
myList.Value = c.Id.ToString();
myList.Text = c.Code + " - " + c.Name;
courseSelectList.Add(myList);
});
}
}
catch (Exception ex)
{
}
return(Json(courseSelectList, JsonRequestBehavior.AllowGet));
}
public ActionResult CourseAllocation()
{
_viewModel = new SetupViewModel();
_staffCourseLogic = new StaffCourseLogic();
try
{
ViewBag.Courses = _viewModel.CourseSelectList;
ViewBag.Staff = _viewModel.LecturerSelectList;
_viewModel.StaffCourseList = _staffCourseLogic.GetAll();
}
catch (Exception)
{
throw;
}
return(View(_viewModel));
}
public JsonResult AllocateCourse(long courseId, long staffId)
{
JsonResponseModel result = new JsonResponseModel();
try
{
if (courseId > 0 && staffId > 0)
{
_staffCourseLogic = new StaffCourseLogic();
STAFF_COURSE existingStaffCourse = _staffCourseLogic.GetEntitiesBy(c => c.Course_Id == courseId).LastOrDefault();
if (existingStaffCourse == null)
{
existingStaffCourse = new STAFF_COURSE();
existingStaffCourse.Course_Id = courseId;
existingStaffCourse.Staff_Id = staffId;
_staffCourseLogic.Create(existingStaffCourse);
}
else
{
existingStaffCourse.Staff_Id = staffId;
_staffCourseLogic.Modify(existingStaffCourse);
}
result.IsError = false;
result.Message = "Operation Successful!";
}
else
{
result.IsError = true;
result.Message = "Invalid parameter";
}
}
catch (Exception ex)
{
result.IsError = true;
result.Message = ex.Message;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
