public static List<JobModel> GetJobsForReleasingResultForInterviewer(Models.User user)
        {
            SqlConnection con = DBUtils.getDBConnection();
            con.Open();

            SqlCommand command = new SqlCommand(" SELECT j.job_id, j.job_description, j.job_role_id, j.skill_set, j.vacancies, " +
                "j.min_experience, j.max_experience, j.age_limit, j.posted_by, j.posted_on, j.status " +
                " FROM dbo.Job j inner join dbo.InterviewerJob i on j.job_id = i.job_id" +
                " WHERE i.interviewer_username='******';", con);

            SqlDataReader reader = command.ExecuteReader();
            List<JobModel> jobs = new List<JobModel>();
            while (reader.Read())
            {
                JobModel job = new JobModel();
                job.JobId = reader.GetInt32(0);
                job.JobDesc = reader.GetString(1);
                job.JobRole = reader.GetInt32(2);
                job.Skills = new List<string>(reader.GetString(3).Split(','));
                job.Vacancies = reader.GetInt32(4);
                job.MinExperience = reader.GetInt32(5);
                job.MaxExperience = reader.GetInt32(6);
                job.AgeLimit = reader.GetInt32(7);
                job.PostedBy = reader.GetInt32(8);
                job.PostedOn = reader.GetDateTime(9);
                job.Status = reader.GetString(10);

                //jobs.Add(job);
                if (job.Status.Equals("S"))
                {
                    jobs.Add(job);
                }
            }

            con.Close();
            return jobs;
        }
        private static List<JobModel> getJobs()
        {
            SqlConnection con = DBUtils.getDBConnection();
            con.Open();

            SqlCommand command = new SqlCommand(" select job_id, job_description, job_role_id, skill_set, vacancies, " +
                "min_experience, max_experience, age_limit, posted_by, posted_on, status from dbo.Job ", con);
            command.ExecuteNonQuery();

            SqlDataReader reader = command.ExecuteReader();
            List<JobModel> jobs = new List<JobModel>();
            while (reader.Read())
            {
                JobModel job = new JobModel();
                job.JobId = reader.GetInt32(0);
                job.JobDesc = reader.GetString(1);
                job.JobRole = reader.GetInt32(2);
                job.Skills = new List<string>(reader.GetString(3).Split(','));
                job.Vacancies = reader.GetInt32(4);
                job.MinExperience = reader.GetInt32(5);
                job.MaxExperience = reader.GetInt32(6);
                job.AgeLimit = reader.GetInt32(7);
                job.PostedBy = reader.GetInt32(8);
                job.PostedOn = reader.GetDateTime(9);
                job.Status = reader.GetString(10);

                jobs.Add(job);
            }

            con.Close();
            return jobs;
        }
        public static JobModel getJobForWhichUserIsSelected(int candidate_id)
        {
            SqlConnection con = DBUtils.getDBConnection();
            con.Open();

            SqlCommand command = new SqlCommand(" select a.job_id, j.job_description " +
                "from dbo.Application a inner join job j on j.job_id = a.job_id where status_code = 'S' and candidate_id = " + candidate_id, con);
            command.ExecuteNonQuery();

            JobModel job = new JobModel();
            SqlDataReader reader = command.ExecuteReader();
            if (reader.Read())
            {
                job.JobId = reader.GetInt32(0);
                job.JobDesc = reader.GetString(1);
            }

            con.Close();
            return job;
        }
 public JobSelectModel(JobModel job)
 {
     this.JobId = job.JobId;
     this.JobDesc = job.JobDesc;
     this.JobRole = job.JobRole;
     this.MinExperience = job.MinExperience;
     this.MaxExperience = job.MaxExperience;
     this.PostedBy = job.PostedBy;
     this.PostedOn = job.PostedOn;
     this.Skills = job.Skills;
     this.Status = job.Status;
     this.Vacancies = job.Vacancies;
     this.AgeLimit = job.AgeLimit;
 }
 public ActionResult ScheduleInterviewDialog(JobModel jobModel)
 {
     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");
     }
     InterviewModel model = new InterviewModel();
     model.JobId = jobModel.JobId;
     model.JobDesc = jobModel.JobDesc.Replace(Environment.NewLine, "");
     @ViewBag.Layout = "~/Views/Shared/_LayoutPageManager.cshtml";
     @ViewBag.Controller = "Admin";
     return PartialView("../Staff/_PartialScheduleInterview", model);
 }
 public ActionResult ReleaseResultsDialog(JobModel jobModel)
 {
     if (!Navigator.IsUserLoggedIn(Session))
     {
         @ViewBag.Message = "Sorry! You need to login to view this page.";
         return View("Message");
         //return RedirectToAction("Login", "Account");
     }
     else if (!Navigator.UserRoleValidation(Session, "manager"))
     {
         @ViewBag.Message = "Access Denied !   You are not allowed to visit this page.";
         return View("Message");
         //return RedirectToAction("Login", "Account");
     }
     ResultModel model = new ResultModel();
     model.JobId = jobModel.JobId;
     model.JobDesc = jobModel.JobDesc;
     model.Vacancies = jobModel.Vacancies;
     model.Candidates = ASCommonDAL.GetApplicantForTheJob(jobModel.JobId);
     @ViewBag.Layout = "~/Views/Shared/_LayoutPageManager.cshtml";
     @ViewBag.Controller = "Admin";
     return PartialView("../Staff/_PartialReleaseResults", model);
 }
        public ActionResult ReleaseResultsDialog(JobModel jobModel)
        {
            if (!Navigator.IsUserLoggedIn(Session))
            {
                @ViewBag.Message = "Sorry! You need to login to continue.";
                return PartialView("_PartialMessage");
                //return RedirectToAction("Login", "Account");
            }
            else if (!Navigator.UserRoleValidation(Session, "staff"))
            {
                @ViewBag.Message = "Access Denied !   You are not allowed to continue.";
                return PartialView("_PartialMessage");
                //return RedirectToAction("Login", "Account");
            }
            else if (!Navigator.IsStaffAllowed(Session, "RightToPublish"))
            {
                @ViewBag.Message = "User Rights Denied! You don't have permission for this.";
                return PartialView("_PartialMessage");
                //return RedirectToAction("Login", "Account");
            }

            ResultModel model = new ResultModel();
            model.JobId = jobModel.JobId;
            model.JobDesc = jobModel.JobDesc;
            model.Vacancies = jobModel.Vacancies;
            model.Candidates = ASCommonDAL.GetApplicantForTheJob(jobModel.JobId);
            @ViewBag.Layout = "~/Views/Shared/_LayoutPageStaff.cshtml";
            @ViewBag.Controller = "Staff";
            return PartialView("_PartialReleaseResults", model);
        }