// GET: Study
        public ActionResult Index()
        {
            CRUDModels cm = new CRUDModels();

            ModelState.Clear();
            return(View(cm.GetStudyList()));
        }
        public ActionResult GetPersonByPSCID(string pscId, string studyId)
        {
            CRUDModels cm = new CRUDModels();
            DataSet    ds = cm.GetPersonByPSCID(pscId, studyId);
            //List<StudyPersonSample> person = new List<StudyPersonSample>();
            List <StudyPerson> person = new List <StudyPerson>();

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                person.Add(new StudyPerson
                {
                    PSCID        = dr["PSCID"].ToString(),
                    StudyID      = dr["StudyID"].ToString(),
                    PersonResult = dr["PersonResult"].ToString(),
                    PersonExists = dr["PersonExists"].ToString()
                });
            }

            return(Json(person, JsonRequestBehavior.AllowGet));
        }
        public ActionResult GetStudyFormByID(string formBarcode, string pscId, string studyId)
        {
            //Check if PSCID is registered on Biobank system

            //
            CRUDStudyPerson csp    = new CRUDStudyPerson();
            int             Exists = csp.ExistsPersonByPSCIDAndStudy(pscId, studyId);

            if (Exists == 1)
            {
                CRUDModels       cm   = new CRUDModels();
                DataSet          ds   = cm.GetStudyFormByID(formBarcode);
                List <StudyForm> form = new List <StudyForm>();
                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    form.Add(new StudyForm
                    {
                        FormID   = dr["FormID"].ToString(),
                        ViewName = dr["ViewName"].ToString()
                    });
                }

                return(Json(form, JsonRequestBehavior.AllowGet));
            }
            else
            {
                //Person not on database, then return view AddStudyPerson form

                List <StudyForm> form = new List <StudyForm>();
                form.Add(new StudyForm
                {
                    FormID   = "",
                    ViewName = "AddStudyPerson"
                });

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