private void SaveVitals()
{
string sUserName = Session["User"].ToString();
PatientVitalsDAL vitalDAL = new PatientVitalsDAL();
PatientVitalsModel vitalModel = new PatientVitalsModel();
vitalModel.EncounterNo = EncounterNo.Value;
vitalModel.PatientNo = PatientNo.Value;
vitalModel.Temperature = Convert.ToDouble(txtTemperature.Value);
vitalModel.Systolic = Convert.ToDouble(txtSystolic.Value);
vitalModel.Diastolic = Convert.ToDouble(txtDiastolic.Value);
vitalModel.PulseRate = Convert.ToDouble(txtPulseRate.Value);
vitalModel.Height = Convert.ToDouble(txtHeight.Value);
vitalModel.Weight = Convert.ToDouble(txtWeight.Value);
vitalModel.BloodSugar = Convert.ToDouble(txtBloodSugar.Value);
vitalModel.Notes = txtOther.Value;
string id = "";// EncounterID.Value;
if (id == "")
{
vitalDAL.InsertData(sUserName, vitalModel);
//lblMsg.Text = "New Record has been saved";
}
else
{
oClass.ID = Convert.ToInt16(id);
vitalDAL.UpdateData(sUserName, vitalModel);
// lblMsg.Text = "Record has been updated";
}
}
public DataSet SeachData(PatientVitalsModel 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));
}
public void InsertData(string currUser, PatientVitalsModel oClass)
{
strSql = strSql + "INSERT INTO " + TABLE_NAME + " (" +
COLUMN_ENCOUNTER_NO + ", " +
COLUMN_PATIENT_NO + ", " +
COLUMN_TEMPERATURE + ", " +
COLUMN_SYSTOLIC + ", " +
COLUMN_DIASTOLIC + ", " +
COLUMN_PULSE_RATE + ", " +
COLUMN_HEIGHT + ", " +
COLUMN_WEIGHT + ", " +
COLUMN_BLOOD_SUGAR + ", " +
COLUMN_NOTES + ", " +
"created_by, created_date, updated_by, updated_date) ";
strSql = strSql + "values ('" +
oClass.EncounterNo + "', '" +
oClass.PatientNo + "', '" +
oClass.Temperature + "', '" +
oClass.Systolic + "', '" +
oClass.Diastolic + "', '" +
oClass.PulseRate + "', '" +
oClass.Height + "', '" +
oClass.Weight + "', '" +
oClass.BloodSugar + "', '" +
oClass.Notes.Replace("'", "") + "', '" +
currUser + "', " +
"CurDate(), '" +
currUser + "', " +
"CurDate() " +
") ";
SaveData(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 SelectByID(PatientVitalsModel oClass)
{
strSql = "SELECT * " +
"FROM " + TABLE_NAME + " " +
"WHERE " + COLUMN_ID + " = '" + oClass.ID + "' ";
return(Select(strSql));
}
public DataSet SelectByEncounterNo(PatientVitalsModel oClass)
{
strSql = "SELECT * " +
"FROM " + TABLE_NAME + " " +
"WHERE " + COLUMN_ENCOUNTER_NO + " = '" + oClass.EncounterNo + "' ";
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, PatientVitalsModel 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, PatientVitalsModel oClass)
{
strSql = "UPDATE " + TABLE_NAME + " SET " +
COLUMN_PATIENT_NO + " = '" + oClass.PatientNo + "', " +
COLUMN_TEMPERATURE + " = '" + oClass.Temperature + "', " +
COLUMN_SYSTOLIC + " = '" + oClass.Systolic + "', " +
COLUMN_DIASTOLIC + " = '" + oClass.Diastolic + "', " +
COLUMN_PULSE_RATE + " = '" + oClass.PulseRate + "', " +
COLUMN_HEIGHT + " = '" + oClass.Height + "', " +
COLUMN_WEIGHT + " = '" + oClass.Weight + "', " +
COLUMN_BLOOD_SUGAR + " = '" + oClass.BloodSugar + "', " +
COLUMN_NOTES + " = '" + oClass.Notes.Replace("'", "''") + "', " +
" updated_by = '" + user + "', " +
" updated_date = '" + DateTime.Now.ToString("yyyy-MM-d HH:MM:ss") + "' " +
" WHERE " + COLUMN_ENCOUNTER_NO + " = '" + oClass.EncounterNo + "' ";
SaveData(strSql);
}
private void PopulateVitals(string encounterNo)
{
PatientVitalsDAL vitalDAL = new PatientVitalsDAL();
PatientVitalsModel vitalModel = new PatientVitalsModel();
oDs = new DataSet();
vitalModel.EncounterNo = encounterNo;
oDs = vitalDAL.SelectByEncounterNo(vitalModel);
hfVitalsID.Value = oDs.Tables[0].Rows[0]["id"].ToString();
txtTemperature.Value = (oDs.Tables[0].Rows[0]["Temperature"].ToString() == "0.00") ? "" : oDs.Tables[0].Rows[0]["Temperature"].ToString();
txtSystolic.Value = (oDs.Tables[0].Rows[0]["Systolic"].ToString() == "0.00") ? "" : oDs.Tables[0].Rows[0]["Systolic"].ToString();
txtDiastolic.Value = (oDs.Tables[0].Rows[0]["Diastolic"].ToString() == "0.00") ? "" : oDs.Tables[0].Rows[0]["Diastolic"].ToString();
txtPulseRate.Value = (oDs.Tables[0].Rows[0]["PulseRate"].ToString() == "0.00") ? "" : oDs.Tables[0].Rows[0]["PulseRate"].ToString();
txtHeight.Value = (oDs.Tables[0].Rows[0]["Height"].ToString() == "0.00") ? "" : oDs.Tables[0].Rows[0]["Height"].ToString();
txtWeight.Value = (oDs.Tables[0].Rows[0]["Weight"].ToString() == "0.00") ? "" : oDs.Tables[0].Rows[0]["Weight"].ToString();
txtBloodSugar.Value = (oDs.Tables[0].Rows[0]["BloodSugar"].ToString() == "0.00") ? "" : oDs.Tables[0].Rows[0]["BloodSugar"].ToString();
txtOther.Value = oDs.Tables[0].Rows[0]["notes"].ToString();
}
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);
}
