public ActionResult Show(int?id)
{
//if there is nothing to show
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Career_Job career_Job = db.Career_Jobs.SqlQuery("select * from Career_Job where job_id=@job_id", new SqlParameter("@job_id", id)).FirstOrDefault();
if (career_Job == null)
{
return(HttpNotFound());
}
//database query to select data from jobs and candidates table .
string query = "select * from Career_Candidate inner join Career_JobCareer_Candidate on Career_Candidate.candidate_id= Career_JobCareer_Candidate. Career_Candidate_candidate_id where Career_Job_job_id = @id";
SqlParameter param = new SqlParameter("@id", id);
List <Career_Candidate> candidates_job = db.Career_Candidates.SqlQuery(query, param).ToList();
//using view model for showing the jobs where the candidates are displayed for one job.
showCareer_Job viewmodel = new showCareer_Job();
viewmodel.Career_Jobs = career_Job;
viewmodel.Career_Candidates = candidates_job;
return(View(viewmodel));
}
//here it is asking for confirmation from the user if they want to delete this particular id
public ActionResult DeleteConfirm(int id)
{
string query = "select * from Career_Job where job_id=@id";
SqlParameter param = new SqlParameter("@id", id);
Career_Job selectedjob = db.Career_Jobs.SqlQuery(query, param).FirstOrDefault();
return(View(selectedjob));
}
