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();
}
