public ActionResult ViewJobApplicationStatus(ApplicantListModel model)
 {
     if (!Navigator.IsUserLoggedIn(Session))
     {
         @ViewBag.Message = "Sorry! You need to login to view this page.";
         return PartialView("_PartialMessage");
         //return RedirectToAction("Login", "Account");
     }
     else if (!Navigator.UserRoleValidation(Session, "manager"))
     {
         @ViewBag.Message = "Access Denied !   You are not allowed to visit this page.";
         return PartialView("_PartialMessage");
         //return RedirectToAction("Login", "Account");
     }
     IEnumerable<ApplicationModel> data = CandidateDAL.GetApplicationDetails(model.CandidateId);
     @ViewBag.Controller = "Admin";
     @ViewBag.Layout = "~/Views/Shared/_LayoutPageManager.cshtml";
     return PartialView("../Staff/_PartialJobApplicationStatus", data);
 }
        public static ApplicantListModel getApplicantList()
        {
            SqlConnection con = DBUtils.getDBConnection();
            con.Open();

            SqlCommand command = new SqlCommand("select candidate_id from dbo.Applicant;", con);
            SqlDataReader reader = command.ExecuteReader();

            if (reader == null || !reader.Read())
            {
                return null;
            }

            //Creating a JobRole List
            List<int> listApplicant = new List<int>();
            do
            {
                listApplicant.Add(Convert.ToInt32(reader[0]));
            }
            while (reader.Read());

            con.Close();
            ApplicantListModel model = new ApplicantListModel();
            model.CandidateIdList = listApplicant;
            return model;
        }
 public ActionResult ViewJobApplicationStatus(ApplicantListModel model)
 {
     if (!Navigator.IsUserLoggedIn(Session))
     {
         @ViewBag.Message = "Sorry! You need to login to view this page.";
         return PartialView("_PartialMessage");
         //return RedirectToAction("Login", "Account");
     }
     else if (!Navigator.UserRoleValidation(Session, "staff"))
     {
         @ViewBag.Message = "Access Denied !   You are not allowed to visit this page.";
         return PartialView("_PartialMessage");
         //return RedirectToAction("Login", "Account");
     }
     IEnumerable<ApplicationModel> data = CandidateDAL.GetApplicationDetails(model.CandidateId);
     return PartialView("_PartialJobApplicationStatus", data);
 }