public static List <SelectListItem> PopulateLecturerSelectListItem()
{
try
{
StaffLogic staffLogic = new StaffLogic();
List <STAFF> users = staffLogic.GetEntitiesBy(p => p.Is_Lecturer);
if (users == null || users.Count <= 0)
{
return(new List <SelectListItem>());
}
List <SelectListItem> userList = new List <SelectListItem>();
SelectListItem list = new SelectListItem();
list.Value = "";
list.Text = Select;
userList.Add(list);
foreach (STAFF user in users)
{
SelectListItem selectList = new SelectListItem();
selectList.Value = user.Person_Id.ToString();
selectList.Text = user.PERSON.Last_Name + " " + user.PERSON.First_Name + " " + user.PERSON.Other_Name;
userList.Add(selectList);
}
return(userList);
}
catch (Exception)
{
throw;
}
}
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));
}