public DataSet SeachData(PatientEncounterLogModel oClass)
{
string fname = "";
string lname = "";
string patientNo = oClass.PatientNo;
string encounterNo = 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 (encounterNo != "")
{
strSql = strSql + "AND A." + COLUMN_ENCOUNTER_NO + " like '%" + encounterNo + "%' ";
}
return(Select(strSql));
}
public DataSet SelectByID(PatientEncounterLogModel oClass)
{
strSql = "SELECT * " +
"FROM " + TABLE_NAME + " " +
"WHERE " + COLUMN_ID + " = '" + oClass.ID + "' ";
return(Select(strSql));
}
public DataSet SelectByEncounterNo(PatientEncounterLogModel oClass)
{
strSql = "SELECT A.*, B.dname as Status " +
"FROM " + TABLE_NAME + " A left outer Join " + TABLE_STATUS + " B " +
"ON A.StatusID = B.ID " +
"WHERE " + COLUMN_ENCOUNTER_NO + " = '" + oClass.EncounterNo + "' ";
return(Select(strSql));
}
public void DeleteData(string user, PatientEncounterLogModel 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);
}
private void PopulateLog(string encounterNo)
{
PatientEncounterLogDAL logDAL = new PatientEncounterLogDAL();
PatientEncounterLogModel logModel = new PatientEncounterLogModel();
oDs = new DataSet();
logModel.EncounterNo = encounterNo;
oDs = logDAL.SelectByEncounterNo(logModel);
gvEncounterLog.DataSource = oDs.Tables[0];
gvEncounterLog.DataBind();
}
private void SaveEncounterLog(int statusID)
{
var logModel = new PatientEncounterLogModel();
var logDal = new PatientEncounterLogDAL();
string sUserName = Session["User"].ToString();
logModel.EncounterNo = EncounterNo.Value;
logModel.PatientNo = PatientNo.Value;
logModel.LogDate = DateTime.Now;
logModel.StatusID = statusID;
logDal.InsertData(sUserName, logModel);
}
public void UpdateData(string user, PatientEncounterLogModel oClass)
{
strSql = "UPDATE " + TABLE_NAME + " SET " +
COLUMN_ENCOUNTER_NO + " = '" + oClass.EncounterNo + "', " +
COLUMN_PATIENT_NO + " = '" + oClass.PatientNo + "', " +
COLUMN_DATE + " = '" + oClass.LogDate.ToString("yyyy-MM-d HH:MM:ss") + "', " +
COLUMN_STATUS_ID + " = '" + oClass.StatusID + "', " +
" updated_by = '" + user + "', " +
" updated_date = '" + DateTime.Now.ToString("yyyy-MM-d HH:MM:ss") + "' " +
" WHERE " + COLUMN_ID + " = '" + oClass.ID + "' ";
SaveData(strSql);
}
private void SaveEncounterLog(string encounterno)
{
var logModel = new PatientEncounterLogModel();
var logDal = new PatientEncounterLogDAL();
string sUserName = Session["User"].ToString();
logModel.EncounterNo = encounterno;
logModel.PatientNo = PatientNo.Value;
logModel.LogDate = DateTime.Now;
logModel.StatusID = Convert.ToInt16(ddlStatus.SelectedValue);
logDal.InsertData(sUserName, logModel);
}
public void InsertData(string currUser, PatientEncounterLogModel oClass)
{
strSql = strSql + "INSERT INTO " + TABLE_NAME + " (" +
COLUMN_ENCOUNTER_NO + ", " +
COLUMN_PATIENT_NO + ", " +
COLUMN_DATE + ", " +
COLUMN_STATUS_ID + ", " +
"created_by, created_date, updated_by, updated_date) ";
strSql = strSql + "values ('" +
oClass.EncounterNo + "', '" +
oClass.PatientNo + "', '" +
oClass.LogDate.ToString("yyyy-MM-d HH:MM:ss") + "', '" +
oClass.StatusID + "', '" +
currUser + "', " +
"CurDate(), '" +
currUser + "', " +
"CurDate() " +
") ";
SaveData(strSql);
}
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);
}
