public void InsertData(string currUser, PatientAssessmentModel oClass)
{
strSql = strSql + "INSERT INTO " + TABLE_NAME + " (" +
COLUMN_ENCOUNTER_NO + ", " +
COLUMN_PATIENT_NO + ", " +
COLUMN_CHIEF_COMPLAINT + ", " +
COLUMN_HPI + ", " +
COLUMN_ROS + ", " +
COLUMN_PFSH + ", " +
COLUMN_PHYSICAL_EXAM + ", " +
COLUMN_PHYSICIAN_NOTE + ", " +
"created_by, created_date, updated_by, updated_date) ";
strSql = strSql + "values ('" +
oClass.EncounterNo + "', '" +
oClass.PatientNo + "', '" +
oClass.ChiefComplaint.Replace("'", "") + "', '" +
oClass.HPI.Replace("'", "") + "', '" +
oClass.ROS.Replace("'", "") + "', '" +
oClass.PFSC.Replace("'", "") + "', '" +
oClass.PhysicalExam.Replace("'", "") + "', '" +
oClass.PhysicianNote.Replace("'", "") + "', '" +
currUser + "', " +
"CurDate(), '" +
currUser + "', " +
"CurDate() " +
") ";
SaveData(strSql);
}
public DataSet SeachData(PatientAssessmentModel oClass)
{
string fname = "";
string lname = "";
string patientNo = oClass.PatientNo;
string caseNo = oClass.EncounterNo;
strSql = "SELECT A.*, Concat(B.FirstName, ' ', B.LastName) as PatientName " +
"FROM " + TABLE_NAME + " A INNER JOIN " + TABLE_PATIENT + " B on A.PatientNo = B.PatientNo Where 1=1 and A.IsDeleted = 0 ";
if (fname != "")
{
strSql = strSql + "AND B." + COLUMN_FIRSTNAME + " like '%" + fname + "%' ";
}
if (lname != "")
{
strSql = strSql + "AND B." + COLUMN_LASTNAME + " like '%" + lname + "%' ";
}
if (patientNo != "")
{
strSql = strSql + "AND A." + COLUMN_PATIENT_NO + " = '" + patientNo + "' ";
}
if (caseNo != "")
{
strSql = strSql + "AND A." + COLUMN_ENCOUNTER_NO + " like '%" + caseNo + "%' ";
}
return(Select(strSql));
}
private void SaveEncounterData(int statusID)
{
string sUserName = Session["User"].ToString();
oDAL = new PatientEncounterDAL();
oClass = new PatientEncounterModel();
oClass.ID = Convert.ToInt16(EncounterID.Value);
oClass.EncounterNo = EncounterNo.Value;
oClass.DispositionID = Convert.ToInt16(ddlDisposition.SelectedValue);
if (RestDays.Value != "")
{
oClass.NoOfDays = Convert.ToInt16(RestDays.Value);
}
if (FollowUpDate.Value != "")
{
oClass.FollowUpDate = Convert.ToDateTime(FollowUpDate.Value);
}
oClass.WorkRestriction = Recommendation.InnerHtml;
oClass.StatusID = statusID;
oDAL.UpdateEncounterDoctorData(sUserName, oClass);
PatientVitalsModel vitalModel = new PatientVitalsModel();
PatientVitalsDAL vitalDAL = new PatientVitalsDAL();
vitalModel.ID = Convert.ToInt16(hfVitalsID.Value);
vitalModel.PatientNo = PatientNo.Value;
vitalModel.EncounterNo = EncounterNo.Value;
vitalModel.Temperature = VitalValue(txtTemperature.Value);
vitalModel.Systolic = VitalValue(txtSystolic.Value);
vitalModel.Diastolic = VitalValue(txtDiastolic.Value);
vitalModel.PulseRate = VitalValue(txtPulseRate.Value);
vitalModel.Height = VitalValue(txtHeight.Value);
vitalModel.Weight = VitalValue(txtWeight.Value);
vitalModel.BloodSugar = VitalValue(txtBloodSugar.Value);
vitalModel.Notes = txtOther.Value;
vitalDAL.UpdateData(sUserName, vitalModel);
PatientAssessmentModel assessmentModel = new PatientAssessmentModel();
PatientAssessmentDAL assessmentDAL = new PatientAssessmentDAL();
assessmentModel.ID = Convert.ToInt16(hfAssessmentID.Value);
assessmentModel.EncounterNo = EncounterNo.Value;
assessmentModel.PatientNo = PatientNo.Value;
assessmentModel.ChiefComplaint = txtCC.InnerText;
assessmentModel.HPI = txtHPI.InnerText;
assessmentModel.ROS = txtROS.InnerText;
assessmentModel.PFSC = txtPFSC.InnerText;
assessmentModel.PhysicalExam = txtPhysicalExam.InnerText;
assessmentModel.PhysicianNote = txtDoctorNote.InnerText;
assessmentDAL.UpdateData(sUserName, assessmentModel);
}
public DataSet SelectByEncounterNo(PatientAssessmentModel oClass)
{
strSql = "SELECT * " +
"FROM " + TABLE_NAME + " " +
"WHERE " + COLUMN_ENCOUNTER_NO + " = '" + oClass.EncounterNo + "' ";
return(Select(strSql));
}
public DataSet SelectByID(PatientAssessmentModel oClass)
{
strSql = "SELECT * " +
"FROM " + TABLE_NAME + " " +
"WHERE " + COLUMN_ID + " = '" + oClass.ID + "' ";
return(Select(strSql));
}
private void SaveEncounterData()
{
string sUserName = Session["User"].ToString();
oDAL = new PatientEncounterDAL();
oClass = new PatientEncounterModel();
oClass.EncounterNo = EncounterNo.Value;
oClass.EncounterDate = Convert.ToDateTime(EncounterDate.Value);
oClass.PatientNo = PatientNo.Value;
oClass.EncounterType = ServiceType.Value;
oClass.InsuranceCompanyID = Convert.ToInt16(ddlCompany.SelectedValue);
oClass.InsuranceNo = InsuranceNo.Value;
oClass.HospitalID = 0;//Convert.ToInt16(ddlHospitalName.SelectedValue);
oClass.PhysicianID = Convert.ToInt16(ddlPhysician.SelectedValue);
oClass.Remarks = Remarks.InnerText;
oClass.StatusID = Convert.ToInt16(ddlStatus.SelectedValue);
PatientVitalsModel vitalModel = new PatientVitalsModel();
vitalModel.PatientNo = PatientNo.Value;
vitalModel.Temperature = VitalValue(txtTemperature.Value);
vitalModel.Systolic = VitalValue(txtSystolic.Value);
vitalModel.Diastolic = VitalValue(txtDiastolic.Value);
vitalModel.PulseRate = VitalValue(txtPulseRate.Value);
vitalModel.Height = VitalValue(txtHeight.Value);
vitalModel.Weight = VitalValue(txtWeight.Value);
vitalModel.BloodSugar = VitalValue(txtBloodSugar.Value);
vitalModel.Notes = txtOther.Value;
PatientAssessmentModel assessmentModel = new PatientAssessmentModel();
assessmentModel.EncounterNo = EncounterNo.Value;
assessmentModel.PatientNo = PatientNo.Value;
assessmentModel.ChiefComplaint = txtCC.InnerText;
string id = Request.QueryString["id"].ToString();
if (id == "")
{
oDAL.InsertNewEncounterData(sUserName, oClass, assessmentModel, vitalModel);
}
else
{
oDAL.UpdateEncounterData(sUserName, oClass);
var patientVitalDAL = new PatientVitalsDAL();
vitalModel.EncounterNo = EncounterNo.Value;
patientVitalDAL.UpdateDataByEncounter(sUserName, vitalModel);
var patientAssessmentDAL = new PatientAssessmentDAL();
patientAssessmentDAL.UpdateDataByEncounter(sUserName, assessmentModel);
}
}
private void SaveEncounterData()
{
string sUserName = Session["User"].ToString();
oDAL = new PatientEncounterDAL();
oClass = new PatientEncounterModel();
oClass.ID = Convert.ToInt16(EncounterID.Value);
oClass.EncounterNo = EncounterNo.Value;
oClass.EncounterDate = Convert.ToDateTime(EncounterDate.Value);
oClass.PatientNo = PatientNo.Value;
oClass.EncounterType = ServiceType.Value;
oClass.InsuranceCompanyID = Convert.ToInt16(ddlCompany.SelectedValue);
oClass.InsuranceNo = InsuranceNo.Value;
oClass.HospitalID = 0;// Convert.ToInt16(ddlHospitalName.SelectedValue);
oClass.PhysicianID = Convert.ToInt16(ddlPhysician.SelectedValue);
oClass.Remarks = Remarks.InnerText;
oClass.StatusID = Convert.ToInt16(ddlStatus.SelectedValue);
oDAL.UpdateData(sUserName, oClass);
PatientVitalsModel vitalModel = new PatientVitalsModel();
PatientVitalsDAL vitalDAL = new PatientVitalsDAL();
vitalModel.ID = Convert.ToInt16(hfVitalsID.Value);
vitalModel.PatientNo = PatientNo.Value;
vitalModel.EncounterNo = EncounterNo.Value;
vitalModel.Temperature = VitalValue(txtTemperature.Value);
vitalModel.Systolic = VitalValue(txtSystolic.Value);
vitalModel.Diastolic = VitalValue(txtDiastolic.Value);
vitalModel.PulseRate = VitalValue(txtPulseRate.Value);
vitalModel.Height = VitalValue(txtHeight.Value);
vitalModel.Weight = VitalValue(txtWeight.Value);
vitalModel.BloodSugar = VitalValue(txtBloodSugar.Value);
vitalModel.Notes = txtOther.Value;
vitalDAL.UpdateData(sUserName, vitalModel);
PatientAssessmentModel assessmentModel = new PatientAssessmentModel();
PatientAssessmentDAL assessmentDAL = new PatientAssessmentDAL();
assessmentModel.ID = Convert.ToInt16(hfAssessmentID.Value);
assessmentModel.EncounterNo = EncounterNo.Value;
assessmentModel.PatientNo = PatientNo.Value;
assessmentModel.ChiefComplaint = txtCC.InnerText;
assessmentModel.HPI = txtHPI.InnerText;
assessmentModel.ROS = txtROS.InnerText;
assessmentModel.PFSC = txtPFSC.InnerText;
assessmentModel.PhysicalExam = txtPhysicalExam.InnerText;
assessmentModel.PhysicianNote = txtDoctorNote.InnerText;
assessmentDAL.UpdateData(sUserName, assessmentModel);
}
public void DeleteData(string user, PatientAssessmentModel oClass)
{
strSql = "UPDATE " + TABLE_NAME + " SET " +
" isDeleted = 1, " +
" ReasonDelete = '" + oClass.ReasonDelete.Replace("'", "''") + "', " +
" updated_by = '" + user + "', " +
" updated_date = '" + DateTime.Now.ToString("yyyy-MM-d HH:MM:ss") + "' " +
" WHERE " + COLUMN_ID + " = '" + oClass.ID + "' ";
SaveData(strSql);
}
public void UpdateDataByEncounter(string user, PatientAssessmentModel oClass)
{
strSql = "UPDATE " + TABLE_NAME + " SET " +
COLUMN_PATIENT_NO + " = '" + oClass.PatientNo + "', " +
COLUMN_CHIEF_COMPLAINT + " = '" + oClass.ChiefComplaint + "', " +
" updated_by = '" + user + "', " +
" updated_date = '" + DateTime.Now.ToString("yyyy-MM-d HH:MM:ss") + "' " +
" WHERE " + COLUMN_ENCOUNTER_NO + " = '" + oClass.EncounterNo + "' ";
SaveData(strSql);
}
private void PopulateAssessment(string encounterNo)
{
PatientAssessmentDAL assessmentDAL = new PatientAssessmentDAL();
PatientAssessmentModel assessmemntModel = new PatientAssessmentModel();
oDs = new DataSet();
assessmemntModel.EncounterNo = encounterNo;
oDs = assessmentDAL.SelectByEncounterNo(assessmemntModel);
txtCC.InnerText = oDs.Tables[0].Rows[0]["ChiefComplaint"].ToString();
}
private void PopulateAssessment(string encounterNo)
{
PatientAssessmentDAL assessmentDAL = new PatientAssessmentDAL();
PatientAssessmentModel assessmemntModel = new PatientAssessmentModel();
oDs = new DataSet();
assessmemntModel.EncounterNo = encounterNo;
oDs = assessmentDAL.SelectByEncounterNo(assessmemntModel);
hfAssessmentID.Value = oDs.Tables[0].Rows[0]["id"].ToString();
txtCC.InnerText = oDs.Tables[0].Rows[0]["ChiefComplaint"].ToString();
txtHPI.InnerText = oDs.Tables[0].Rows[0]["hpi"].ToString();
txtROS.InnerText = oDs.Tables[0].Rows[0]["ros"].ToString();
txtPFSC.InnerText = oDs.Tables[0].Rows[0]["pfsh"].ToString();
txtPhysicalExam.InnerText = oDs.Tables[0].Rows[0]["physicalexam"].ToString();
txtDoctorNote.InnerText = oDs.Tables[0].Rows[0]["PhysicianNote"].ToString();
}
public void UpdateData(string user, PatientAssessmentModel oClass)
{
strSql = "UPDATE " + TABLE_NAME + " SET " +
COLUMN_ENCOUNTER_NO + " = '" + oClass.EncounterNo + "', " +
COLUMN_PATIENT_NO + " = '" + oClass.PatientNo + "', " +
COLUMN_CHIEF_COMPLAINT + " = '" + oClass.ChiefComplaint + "', " +
COLUMN_HPI + " = '" + oClass.HPI.Replace("'", "''") + "', " +
COLUMN_ROS + " = '" + oClass.ROS.Replace("'", "''") + "', " +
COLUMN_PFSH + " = '" + oClass.PFSC.Replace("'", "''") + "', " +
COLUMN_PHYSICAL_EXAM + " = '" + oClass.PhysicalExam.Replace("'", "''") + "', " +
COLUMN_PHYSICIAN_NOTE + " = '" + oClass.PhysicianNote.Replace("'", "''") + "', " +
" updated_by = '" + user + "', " +
" updated_date = '" + DateTime.Now.ToString("yyyy-MM-d HH:MM:ss") + "' " +
" WHERE " + COLUMN_ID + " = '" + oClass.ID + "' ";
SaveData(strSql);
}
private void PopulateAssessment(string encounterNo)
{
lblRecomen.Text = "";
PatientAssessmentDAL assessmentDAL = new PatientAssessmentDAL();
PatientAssessmentModel assessmemntModel = new PatientAssessmentModel();
var oDs = new DataSet();
assessmemntModel.EncounterNo = encounterNo;
oDs = assessmentDAL.SelectByEncounterNo(assessmemntModel);
if (oDs != null)
{
if (oDs.Tables[0].Rows.Count > 0)
{
for (int i = 0; i <= oDs.Tables[0].Rows.Count - 1; i++)
{
lblRecomen.Text = oDs.Tables[0].Rows[0]["PhysicianNote"].ToString();
}
}
}
}
private void SaveAssessment()
{
string sUserName = Session["User"].ToString();
PatientAssessmentDAL assessmentDAL = new PatientAssessmentDAL();
PatientAssessmentModel assessmentModel = new PatientAssessmentModel();
assessmentModel.EncounterNo = EncounterNo.Value;
assessmentModel.PatientNo = PatientNo.Value;
assessmentModel.ChiefComplaint = txtCC.InnerText;
string id = "";// EncounterID.Value;
if (id == "")
{
assessmentDAL.InsertData(sUserName, assessmentModel);
//lblMsg.Text = "New Record has been saved";
}
else
{
oClass.ID = Convert.ToInt16(id);
assessmentDAL.UpdateData(sUserName, assessmentModel);
// lblMsg.Text = "Record has been updated";
}
}
public void InsertNewEncounterData(string currUser, PatientEncounterModel oClass, PatientAssessmentModel assessmentModel, PatientVitalsModel vitalsModel)
{
strSql = "Set @EncounterNo = (SELECT Concat('EN',CAST(DATE_FORMAT(curdate(),'%Y%m') AS CHAR(6)), '0001')); " +
"Set @LastNo = (SELECT Concat('EN', Cast(right(EncounterNo,10) + 1 AS CHAR(10))) From " + TABLE_NAME + " " +
"where CAST(left(right(" + COLUMN_ENCOUNTER_NO + ",10) ,6) as CHAR (4)) = CAST(Year(curdate()) as CHAR(4)) " +
"and right(left(right(" + COLUMN_ENCOUNTER_NO + ",10) ,6), 2) = DATE_FORMAT(curdate(),'%m') " +
"order by id desc Limit 1);" +
"Set @EncounterNo = IF (@LastNo <> '', @LastNo, @EncounterNo); ";
strSql = strSql + "INSERT INTO " + TABLE_NAME + " (" +
COLUMN_ENCOUNTER_NO + ", " +
COLUMN_CASE_NO + ", " +
COLUMN_PATIENT_NO + ", " +
COLUMN_DATE + ", " +
COLUMN_TYPE + ", " +
COLUMN_INSURANCE + ", " +
COLUMN_INSURANCE_NO + ", " +
COLUMN_PHYSICIAN + ", " +
COLUMN_HOSPITAL + ", " +
COLUMN_STATUS + ", " +
COLUMN_REMARKS + ", " +
"created_by, created_date, updated_by, updated_date) ";
strSql = strSql + "values (@EncounterNo,'" +
oClass.CaseNo + "', '" +
oClass.PatientNo + "', '" +
oClass.EncounterDate.ToString("yyyy-MM-d HH:MM:ss") + "', '" +
oClass.EncounterType + "', '" +
oClass.InsuranceCompanyID + "', '" +
oClass.InsuranceNo.Replace("'", "") + "', '" +
oClass.PhysicianID + "', '" +
oClass.HospitalID + "', '" +
oClass.StatusID + "', '" +
oClass.Remarks.Replace("'", "") + "', '" +
currUser + "', " +
"CurDate(), '" +
currUser + "', " +
"CurDate() " +
"); ";
var patientVitalDAL = new PatientVitalsDAL();
strSql = strSql + patientVitalDAL.InsertData();
strSql = strSql + "values (@EncounterNo,'" +
vitalsModel.PatientNo + "', '" +
vitalsModel.Temperature + "', '" +
vitalsModel.Systolic + "', '" +
vitalsModel.Diastolic + "', '" +
vitalsModel.PulseRate + "', '" +
vitalsModel.Height + "', '" +
vitalsModel.Weight + "', '" +
vitalsModel.BloodSugar + "', '" +
vitalsModel.Notes.Replace("'", "") + "', '" +
currUser + "', " +
"CurDate(), '" +
currUser + "', " +
"CurDate() " +
"); ";
var patientAssessmentDAL = new PatientAssessmentDAL();
strSql = strSql + patientAssessmentDAL.InsertData();
strSql = strSql + "values (@EncounterNo,'" +
assessmentModel.PatientNo + "', '" +
assessmentModel.ChiefComplaint.Replace("'", "") + "', '" +
currUser + "', " +
"CurDate(), '" +
currUser + "', " +
"CurDate() " +
"); ";
var logModel = new PatientEncounterLogModel();
var logDal = new PatientEncounterLogDAL();
strSql = strSql + logDal.InsertData();
strSql = strSql + "values (@EncounterNo,'" +
oClass.PatientNo + "', '" +
DateTime.Now.ToString("yyyy-MM-d HH:MM:ss") + "', '" +
oClass.StatusID + "', '" +
currUser + "', " +
"CurDate(), '" +
currUser + "', " +
"CurDate() " +
"); ";
SaveData(strSql);
}
