public ActionResult GetPrisonerDetails(int id) { Prisoner prisoner = (from item in db.Prisoners where item.prisonerID == id select item).FirstOrDefault(); prisonerSatyIn cell = (from item in db.prisonerSatyIns where item.prisonerid == id select item).FirstOrDefault(); PrisonerWorkA work = (from item in db.PrisonerWorkAs where item.prisonerid == id select item).FirstOrDefault(); prisonerDetails prisonerDetails = new prisonerDetails(); prisonerDetails.prisoner = prisoner; if (cell != null) { prisonerDetails.cell = cell.prisonerCell; } if (work != null) { prisonerDetails.job = work.Job; } return(View(prisonerDetails)); }
public ActionResult AssignAjobPost(int id) { var job = (from item in db.Jobs where item.jobID == id select item).FirstOrDefault(); int prisonerID = Convert.ToInt32(Session["prisonerID"]); var prisoner = (from item in db.Prisoners where item.prisonerID == prisonerID select item).FirstOrDefault(); var query = (from item in db.PrisonerWorkAs where item.prisonerid == prisoner.prisonerID select item).FirstOrDefault(); //updating the job if (query != null) { query.Prisoner = prisoner; query.Job = job; query.jobid = job.jobID; query.prisonerid = prisoner.prisonerID; query.since = DateTime.Now.Date; db.Entry(query).State = EntityState.Modified; db.SaveChanges(); } else { //creating new job-prisoner relation PrisonerWorkA relation = new PrisonerWorkA(); relation.Prisoner = prisoner; relation.Job = job; relation.jobid = job.jobID; relation.prisonerid = prisoner.prisonerID; relation.since = DateTime.Now.Date; db.Entry(relation).State = EntityState.Added; db.SaveChanges(); job.availablePositionsCount--; db.Entry(job).State = EntityState.Modified; db.SaveChanges(); } return(Redirect("~/Prisoners/GetPrisonersData")); }