public ActionResult Search(statisticsViewModel statisticsView)
        {
            int prisonerid = statisticsView.prisonerid;

            var prisoner = (from item in db.Prisoners
                            where item.prisonerID == prisonerid
                            select item).FirstOrDefault();

            Session["prisonerID"] = prisonerid;

            if (prisoner != null)
            {
                return(Redirect("~/public/ApplyForAvisit"));
            }
            else
            {
                return(Redirect("~/public/index"));
            }
        }
        // GET: Public
        public ActionResult Index()
        {
            int totalOfficers = (from item in db.officers
                                 select item).Count();

            int totalPrisoners = (from item in db.Prisoners
                                  select item).Count();

            int prisonCapacity = (from item in db.prisonerCells
                                  select item.capacity).Sum();

            int availableOfficerJobs = db.Jobs.Where(a => a.workerType == "prisoner")
                                       .Sum(a => a.availablePositionsCount);

            statisticsViewModel viewModel = new statisticsViewModel();

            viewModel.availableOfficersJobs = availableOfficerJobs;
            viewModel.prisonCapacity        = prisonCapacity;
            viewModel.totalOfficers         = totalOfficers;
            viewModel.totalPrisoners        = totalPrisoners;


            return(View(viewModel));
        }