public ActionResult SaveMentalHealthClient(MentalHealthCaseNote MentalHealthCaseNote) { bool res = false; try { mHealth = new MentalHealthData(); MentalHealthDashboard dash = new MentalHealthDashboard(); dash.ClientList = new List <MentalHealthClientList>(); // for casenote string name = ""; string casenoteid = ""; RosterNew.CaseNote _caseNote = new RosterNew.CaseNote(); _caseNote.CaseNoteAttachmentList = Fingerprints.Common.FactoryInstance.Instance.CreateInstance <List <RosterNew.Attachment> >(); var ate = Request.Files; var ate2 = ate.AllKeys; for (int i = 0; i < ate2.Length; i++) { RosterNew.Attachment aatt = new RosterNew.Attachment(); aatt.file = ate[i]; if (aatt.file.ContentLength > 0) { _caseNote.CaseNoteAttachmentList.Add(aatt); } } _caseNote.CenterId = EncryptDecrypt.Decrypt64(MentalHealthCaseNote.CenterId); // _caseNote.Classroomid = MentalHealthCaseNote.CaseClassroomId.ToString(); _caseNote.ClientId = EncryptDecrypt.Decrypt64(MentalHealthCaseNote.ClientId.ToString()); _caseNote.CaseNotetags = MentalHealthCaseNote.Tags.Trim(','); _caseNote.CaseNoteTitle = MentalHealthCaseNote.Title; _caseNote.CaseNoteDate = MentalHealthCaseNote.Date; _caseNote.Note = MentalHealthCaseNote.MHcasenote; _caseNote.ClientIds = string.Join(",", MentalHealthCaseNote.ClientIds.ToArray()); // _caseNote.ProgramId = EncryptDecrypt.Decrypt64(MentalHealthCaseNote.CaseProgramId); casenoteid = new RosterData(staff).SaveCaseNotes(ref name, _caseNote, 2); res = mHealth.SaveMentalHealthClient(MentalHealthCaseNote, name); } catch (Exception ex) { clsError.WriteException(ex); } return(RedirectToAction("MentalHealthDashboard")); }
public ActionResult MentalHealthDashboard() { MentalHealthDashboard dash = new MentalHealthDashboard(); mHealth = new MentalHealthData(); dash.ClientList = new List <MentalHealthClientList>(); try { ViewBag.Centerlist = mHealth.GetMentalHealthDashboard(Session["AgencyID"].ToString(), Session["UserID"].ToString()); } catch (Exception ex) { clsError.WriteException(ex); } return(View(dash)); }
public List <MentalHealthDashboard> GetMentalHealthDashboard(string Agencyid, string userid) { List <MentalHealthDashboard> centerList = new List <MentalHealthDashboard>(); try { command.Parameters.Add(new SqlParameter("@Agencyid", Agencyid)); command.Parameters.Add(new SqlParameter("@userid", userid)); command.Connection = Connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = "[SP_MentalHealthDashboard]"; DataAdapter = new SqlDataAdapter(command); _dataset = new DataSet(); DataAdapter.Fill(_dataset); if (_dataset.Tables[0] != null) { if (_dataset.Tables[0].Rows.Count > 0) { foreach (DataRow dr in _dataset.Tables[0].Rows) { MentalHealthDashboard info = new MentalHealthDashboard(); info.CenterId = EncryptDecrypt.Encrypt64(dr["center"].ToString()); info.Name = dr["centername"].ToString(); info.TotalChildren = dr["totalchildren"].ToString(); info.DisabilityPercentage = dr["TotalDisablePercentage"].ToString(); info.Indicated = dr["Indicated"].ToString(); info.Qualified = dr["Qualified"].ToString(); info.Released = dr["Released"].ToString(); centerList.Add(info); } } } DataAdapter.Dispose(); command.Dispose(); } catch (Exception ex) { clsError.WriteException(ex); } finally { DataAdapter.Dispose(); command.Dispose(); } return(centerList); }
public ActionResult GetMentalHealthClientDetails(string clientId, string centerId, string householdId) { MentalHealthDashboard dash = new MentalHealthDashboard(); dash.ClientList = new List <MentalHealthClientList>(); try { mHealth = new MentalHealthData(); // dash.ClientList = mHealth.LoadMentalHealthDashboardList(centerId, mode); } catch (Exception ex) { clsError.WriteException(ex); } return(PartialView("~/Views/Partialviews/MentalHealthClientDetails.cshtml", dash)); }
public ActionResult LoadMentalHealthDashboardList(string centerId, string mode) { MentalHealthDashboard dash = new MentalHealthDashboard(); dash.ClientList = new List <MentalHealthClientList>(); try { mHealth = new MentalHealthData(); dash.Mode = mode; dash.ClientList = mHealth.LoadMentalHealthDashboardList(centerId, mode); } catch (Exception ex) { clsError.WriteException(ex); } return(PartialView("~/Views/Partialviews/MentalHealthClientList.cshtml", dash)); }