public IActionResult RegisterNewIntake() { PatientProgram pp = IntakeModel.Program; pp.ArtStartedOn = DateTime.Parse(IntakeModel.ArtStartedOn); pp.CptStartedOn = DateTime.Parse(IntakeModel.CptStartedOn); pp.UpdateIntake(); PatientRegimen pr = IntakeModel.Regimen; pr.Program = pp; pr.Save(HttpContext); PatientExamination px = IntakeModel.Examination; px.Program = pp; px.Visit = new Visit(1); px.LabNo = pp.LaboratoryNumber; px.SputumSmearDate = DateTime.Parse(IntakeModel.SputumSmearDate); px.GeneXpertDate = DateTime.Parse(IntakeModel.GeneXpertDate); px.HivExamDate = DateTime.Parse(IntakeModel.HivExamDate); px.XrayExamDate = DateTime.Parse(IntakeModel.XrayExamDate); px.Save(HttpContext); return(LocalRedirect("/patients/profile/" + pp.Patient.GetUuid())); }
public IActionResult AddVisits() { PatientProgram pp = VisitModel.Program; pp.ArtStartedOn = DateTime.Parse(VisitModel.ArtStartedOn); pp.CptStartedOn = DateTime.Parse(VisitModel.CptStartedOn); pp.UpdateVisit(); //Test If Regimen has Changed, then Update PatientRegimen pr = VisitModel.Regimen; pr.Program = pp; pr.Save(HttpContext); //Post Visit PatientExamination px = VisitModel.Examination; px.Program = pp; px.LabNo = pp.LaboratoryNumber; px.SputumSmearDate = DateTime.Parse(VisitModel.SputumSmearDate); px.GeneXpertDate = DateTime.Parse(VisitModel.GeneXpertDate); px.HivExamDate = DateTime.Parse(VisitModel.HivExamDate); px.XrayExamDate = DateTime.Parse(VisitModel.XrayExamDate); px.Save(HttpContext); return(LocalRedirect("/patients/profile/" + pp.Patient.GetUuid())); }
public PatientRegimen GetPatientRegimen(PatientProgram pp) { PatientRegimen regimen = null; SqlServerConnection conn = new SqlServerConnection(); SqlDataReader dr = conn.SqlServerConnect("SELECT pr_idnt, pr_default, pr_program, pr_started_on, pr_added_on, pr_added_by, pr_notes, rg_idnt, rg_name, rg_description, prg_idnt, prg_description FROM PatientRegimens INNER JOIN Regimen ON pr_regimen=rg_idnt INNER JOIN Program ON rg_program=prg_idnt WHERE pr_default=1 AND pr_program=" + pp.Id); if (dr.Read()) { regimen = new PatientRegimen { Id = Convert.ToInt64(dr[0]), Default = Convert.ToBoolean(dr[1]), Program = new PatientProgram(Convert.ToInt64(dr[2])), StartedOn = Convert.ToDateTime(dr[3]), CreatedOn = Convert.ToDateTime(dr[4]), CreatedBy = new Users(Convert.ToInt64(dr[5])), Notes = dr[6].ToString() }; regimen.Regimen = new Regimen { Id = Convert.ToInt64(dr[7]), Name = dr[8].ToString(), Description = dr[9].ToString(), Program = new Programs(Convert.ToInt64(dr[10]), dr[11].ToString()) }; } return(regimen); }
public PatientProfileViewModel() { Transfer = new PatientTransfer(); Patient = new Patient(); Program = new PatientProgram(); Regimen = new PatientRegimen(); Examination = new PatientExamination(); DateOfBirth = DateTime.Now.ToString("dd/MM/yyyy"); RegimenDate = DateTime.Now.ToString("dd/MM/yyyy"); OutcomeDate = DateTime.Now.ToString("dd/MM/yyyy"); TransferDate = DateTime.Now.ToString("dd/MM/yyyy"); Centers = new List <SelectListItem>(); Facility = new List <SelectListItem>(); Outcomes = new List <SelectListItem>(); ExamOpts = new List <SelectListItem>(); Regimens = new List <SelectListItem>(); LatestVitals = new Vitals(); Examinations = new List <Examinations>(); Contacts = new List <Contacts>(); Gender = new PatientService().InitializeGender(); }
public IActionResult UpdatePatientRegimen() { DateTime date = DateTime.ParseExact(ProfileModel.RegimenDate, "dd/MM/yyyy", CultureInfo.InvariantCulture); PatientRegimen rx = ProfileModel.Regimen; rx.CreatedOn = date; rx.Save(HttpContext); return(LocalRedirect("/patients/profile/" + ProfileModel.Patient.GetUuid())); }
public PatientRegimen SavePatientRegimen(PatientRegimen pr) { SqlServerConnection conn = new SqlServerConnection(); pr.Id = conn.SqlServerUpdate("DECLARE @prid INT=" + pr.Id + ", @prog INT=" + pr.Program.Id + ", @regm INT=" + pr.Regimen.Id + ", @user INT=" + Actor + ", @date DATE='" + pr.StartedOn.Date + "'; IF NOT EXISTS (SELECT pr_idnt FROM PatientRegimens WHERE pr_idnt=@prid AND pr_regimen=@regm) BEGIN INSERT INTO PatientRegimens (pr_program, pr_regimen, pr_started_on, pr_added_by) output INSERTED.pr_idnt VALUES (@prog, @regm, @date, @user) END ELSE BEGIN UPDATE PatientRegimens SET pr_started_on=@date output INSERTED.pr_idnt WHERE pr_idnt=@prid AND pr_regimen=@regm END"); conn = new SqlServerConnection(); conn.SqlServerUpdate("DECLARE @prid INT=" + pr.Id + ", @prog INT=" + pr.Program.Id + "; UPDATE PatientRegimens SET pr_default=0 WHERE pr_program=@prog AND pr_idnt<>@prid"); return(pr); }
public PatientIntakeViewModel() { Program = new PatientProgram(); Patient = new Patient(); Regimen = new PatientRegimen(); Examination = new PatientExamination(); RegimenStartedOn = DateTime.Now.ToString("d MMMM, yyyy"); SputumSmearDate = DateTime.Now.ToString("d MMMM, yyyy"); GeneXpertDate = DateTime.Now.ToString("d MMMM, yyyy"); HivExamDate = DateTime.Now.ToString("d MMMM, yyyy"); XrayExamDate = DateTime.Now.ToString("d MMMM, yyyy"); ArtStartedOn = DateTime.Now.ToString("d MMMM, yyyy"); CptStartedOn = DateTime.Now.ToString("d MMMM, yyyy"); InitiazeBoolOpts(); }
public PatientVisitsViewModel() { Patient = new Patient(); Program = new PatientProgram(); Visits = new List <SelectListItem>(); Regimens = new List <SelectListItem>(); HivRecent = new Examinations(); Regimen = new PatientRegimen(); Examination = new PatientExamination(); RegimenStartedOn = DateTime.Now.ToString("d MMMM, yyyy"); SputumSmearDate = DateTime.Now.ToString("d MMMM, yyyy"); GeneXpertDate = DateTime.Now.ToString("d MMMM, yyyy"); HivExamDate = DateTime.Now.ToString("d MMMM, yyyy"); XrayExamDate = DateTime.Now.ToString("d MMMM, yyyy"); ArtStartedOn = DateTime.Now.ToString("d MMMM, yyyy"); CptStartedOn = DateTime.Now.ToString("d MMMM, yyyy"); InitiazeBoolOpts(); }