public ActionResult ViewRooms()
        {
            if (Convert.ToString(Session["key"]) != "admin")
            {
                return(RedirectToAction("Login", "Home"));
            }

            TreatmentRoom_Api roomApi = new TreatmentRoom_Api();
            var model = roomApi.GetAllTreatmentRoomRecs();

            Patient_Api patientApi = new Patient_Api();
            var         p          = patientApi.GetPaitentsList();

            foreach (var r in model)
            {
                if (r.date > DateTime.Now)
                {
                    r.canEdit = true;
                }
            }
            foreach (var m in model)
            {
                m.patientList = p;
            }
            return(View("~/Views/Administrator/AdminViewRooms.cshtml", model));
        }
        public JsonResult fillPatientList(string text)
        {
            Appointment_Api   app     = new Appointment_Api();
            TreatmentRoom_Api roomApi = new TreatmentRoom_Api();
            var model     = roomApi.GetAllTreatmentRoomRecs().Where(t => (t.date == DateTime.Parse(text) && t.isBooked == true)).GroupBy(g => g.patient_ID).Select(s => s.First()).ToList();
            var allAptmts = app.GetAllAppointments();

            var apps = allAptmts.Where(a => a.appointment_Date > DateTime.Now).GroupBy(g => g.paitent_ID).Select(s => s.First()).ToList();

            TreatmentRoomModel trModelPats = new TreatmentRoomModel();

            TreatmentRoomModel trModel = new TreatmentRoomModel();

            //var allApts = app.GetAllAppointments();

            foreach (var p in model)
            {
                trModelPats.patientDropDown.Add(new SelectListItem
                {
                    Text  = p.patientFirstName,
                    Value = Convert.ToString(p.patient_ID)
                });
            }

            foreach (var p in apps)
            {
                trModel.patientDropDown.Add(new SelectListItem
                {
                    Text  = p.patientName,
                    Value = Convert.ToString(p.paitent_ID)
                });
            }

            trModel.patientDropDown = (from t in trModel.patientDropDown
                                       where trModelPats.patientDropDown.All(o => o.Text != t.Text) select t).ToList();
            List <SelectListItem> patientList = new List <SelectListItem>();

            foreach (var p in trModel.patientDropDown)
            {
                patientList.Add(p);
            }

            foreach (var t in trModel.patientDropDown)
            {
                if ((GetApptsForRooms(Convert.ToInt32(t.Value))).Count() == 0)
                {
                    patientList.Remove(t);
                }
            }

            return(Json(patientList, JsonRequestBehavior.AllowGet));
        }