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