public ResponsePatientCases GetAllPatientCases(string identification)
{
ResponsePatientCases ans = null;
try
{
if (ValidateSecurityAPI())
{
ans = PatientCaseModel.GetAllPatientCases(identification);
}
else
{
ans = new ResponsePatientCases()
{
IsSuccessful = false, ResponseMessage = AppManagement.MSG_API_Validation_Failure
};
}
}
catch (Exception ex)
{
ans = new ResponsePatientCases()
{
IsSuccessful = false, ResponseMessage = AppManagement.MSG_GenericExceptionError
};
}
return(ans);
}
private void PopulateGrid()
{
oDAL = new PatientCaseDAL();
oClass = new PatientCaseModel();
DataSet oDs = new DataSet();
//if (tsbPatName.Text == "")
//{
// oDs = oDAL.SelectAllReferrals();
//}
//else
//{
// oClass.FileName = tsbPatName.Text;
// oDs = oDAL.SelectReferralsByName(oClass);
//}
oDs = oDAL.SelectAll();
if (oDs != null)
{
gvList.DataSource = oDs.Tables[0];
gvList.DataBind();
}
}
private void PopulatePatientCase(string caseNo)
{
oDAL = new PatientCaseDAL();
oClass = new PatientCaseModel();
oDs = new DataSet();
oClass.CaseNo = caseNo;
oDs = oDAL.SelectByCaseNo(oClass);
CaseID.Value = oDs.Tables[0].Rows[0]["ID"].ToString();
RefNo.Value = oDs.Tables[0].Rows[0]["CaseNo"].ToString();
CaseDate.Value = Convert.ToDateTime(oDs.Tables[0].Rows[0]["CaseDate"]).ToShortDateString();
PatientNo.Value = oDs.Tables[0].Rows[0]["PatientNo"].ToString();
PatientName.Value = oDs.Tables[0].Rows[0]["PatientName"].ToString();
DOB.Value = Convert.ToDateTime(oDs.Tables[0].Rows[0]["DOB"]).ToShortDateString();
ddlCompany.SelectedValue = oDs.Tables[0].Rows[0]["InsuranceCompanyID"].ToString();
InsuranceNo.Value = oDs.Tables[0].Rows[0]["InsuranceNo"].ToString();
ddlHospitalName.SelectedValue = oDs.Tables[0].Rows[0]["FacilityID"].ToString();
ServiceType.Value = oDs.Tables[0].Rows[0]["ServiceType"].ToString();
AdmitDate.Value = oDs.Tables[0].Rows[0]["StartDate"].ToString();
DischargeDate.Value = oDs.Tables[0].Rows[0]["EndDate"].ToString();
ddlPhysician.SelectedValue = oDs.Tables[0].Rows[0]["PhysicianID"].ToString();
Remarks.Value = oDs.Tables[0].Rows[0]["Remarks"].ToString();
ddlStatus.SelectedValue = oDs.Tables[0].Rows[0]["StatusID"].ToString();
}
public DataSet SelectByID(PatientCaseModel oClass)
{
strSql = "SELECT * " +
"FROM " + TABLE_NAME + " " +
"WHERE " + COLUMN_ID + " = '" + oClass.ID + "' ";
return(Select(strSql));
}
public void DeleteData(string user, PatientCaseModel 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);
}
protected void Ok_ServerClick(object sender, EventArgs e)
{
oDAL = new PatientCaseDAL();
oClass = new PatientCaseModel();
string sUserName = Session["User"].ToString();
oClass.IsDeleted = true;
oClass.ReasonDelete = itemname.InnerText;
string lbl = lblPatientCase.Text;
oClass.ID = Convert.ToInt32(HiddenFieldPatientCase.Value);
oDAL.DeleteData(sUserName, oClass);
}
public DataSet SelectByCaseNo(PatientCaseModel oClass)
{
strSql = "SELECT A.*, Concat(B.LastName, ', ',B.FirstName) as PatientName, B.dob, Concat(C.LastName, ', ',C.FirstName) as PhysicianName, " +
" d.FacilityName, E.CompanyName, F.dname as Status " +
"FROM " + TABLE_NAME + " A Inner Join " + ConstantConfiguration.TABLE_PATIENT + " B ON A." +
COLUMN_PATIENT_NO + " = B." + COLUMN_PATIENT_NO + " Left Outer Join " +
ConstantConfiguration.TABLE_PHYSICIAN + " C ON C.ID = A." + COLUMN_PHYSICIAN + " Left Outer Join " +
ConstantConfiguration.TABLE_FACILITY + " D ON D.ID = A." + COLUMN_HOSPITAL + " Left Outer Join " +
ConstantConfiguration.TABLE_INSURANCE + " E ON E.ID = A." + COLUMN_INSURANCE + " Left Outer Join " +
ConstantConfiguration.TABLE_CASE_STATUS + " F ON F.ID = A." + COLUMN_STATUS +
" WHERE A." + COLUMN_CASE_NO + " = '" + oClass.CaseNo + "' ";
return(Select(strSql));
}
public void InsertData(string currUser, PatientCaseModel oClass)
{
strSql = "Set @CaseNo = (SELECT Concat(CAST(DATE_FORMAT(curdate(),'%Y') AS CHAR(4)),'-', '0001','0',CAST(DATE_FORMAT(curdate(),'%d') AS CHAR(2)),'0', CAST(DATE_FORMAT(curdate(),'%m') AS CHAR(2)))); " +
"Set @LastCaseNo = (SELECT Concat(CAST(DATE_FORMAT(curdate(),'%Y') AS CHAR(4)),'-',Left(Right(CaseNo,10),4) + 1, '0',CAST(DATE_FORMAT(curdate(),'%d') AS CHAR(2)),'0', CAST(DATE_FORMAT(curdate(),'%m') AS CHAR(2))) FROM " + ConstantConfiguration.TABLE_PATIENT_CASE + " " +
"where CAST(left(CaseNo,4) as CHAR (4)) = CAST(Year(curdate()) as CHAR(4)) " +
"and Left(Right(CaseNo,5),2) = DATE_FORMAT(curdate(),'%d') " +
"and Right(CaseNo,2) = DATE_FORMAT(curdate(),'%m') order by id desc Limit 1); " +
"Set @CaseNo = IF (@LastCaseNo <> '', @LastCaseNo, @CaseNo); ";
strSql = strSql + "INSERT INTO " + TABLE_NAME + " (" +
COLUMN_CASE_NO + ", " +
COLUMN_PATIENT_NO + ", " +
COLUMN_DATE + ", " +
COLUMN_TYPE + ", " +
COLUMN_INSURANCE + ", " +
COLUMN_INSURANCE_NO + ", " +
COLUMN_START_DATE + ", " +
COLUMN_END_DATE + ", " +
COLUMN_PHYSICIAN + ", " +
COLUMN_HOSPITAL + ", " +
COLUMN_STATUS + ", " +
COLUMN_REMARKS + ", " +
"created_by, created_date, updated_by, updated_date) ";
strSql = strSql + "values (@CaseNo,'" +
oClass.PatientNo + "', '" +
oClass.CaseDate.ToString("yyyy-MM-d HH:MM:ss") + "', '" +
oClass.ServiceType + "', '" +
oClass.InsuranceCompanyID + "', '" +
oClass.InsuranceNo.Replace("'", "") + "', '" +
oClass.StartDate + "', '" +
oClass.EndDate + "', '" +
oClass.PhysicianID + "', '" +
oClass.HospitalID + "', '" +
oClass.StatusID + "', '" +
oClass.Remarks.Replace("'", "") + "', '" +
currUser + "', " +
"CurDate(), '" +
currUser + "', " +
"CurDate() " +
") ";
SaveData(strSql);
}
private void SaveData()
{
string sUserName = Session["User"].ToString();
oDAL = new PatientCaseDAL();
oClass = new PatientCaseModel();
oClass.CaseNo = RefNo.Value;
oClass.CaseDate = Convert.ToDateTime(CaseDate.Value);
oClass.PatientNo = PatientNo.Value;
oClass.ServiceType = ServiceType.Value;
oClass.InsuranceCompanyID = Convert.ToInt16(ddlCompany.SelectedValue);
oClass.InsuranceNo = InsuranceNo.Value;
oClass.HospitalID = Convert.ToInt16(ddlHospitalName.SelectedValue);
oClass.PhysicianID = Convert.ToInt16(ddlPhysician.SelectedValue);
if (AdmitDate.Value != "")
{
oClass.StartDate = Convert.ToDateTime(AdmitDate.Value);
}
if (DischargeDate.Value != "")
{
oClass.EndDate = Convert.ToDateTime(DischargeDate.Value);
}
oClass.Remarks = Remarks.Value;
oClass.StatusID = Convert.ToInt16(ddlStatus.SelectedValue);
string id = CaseID.Value;
if (id == "")
{
oDAL.InsertData(sUserName, oClass);
//lblMsg.Text = "New Record has been saved";
}
else
{
oClass.ID = Convert.ToInt16(id);
oDAL.UpdateData(sUserName, oClass);
// lblMsg.Text = "Record has been updated";
}
}
public void UpdateData(string user, PatientCaseModel oClass)
{
strSql = "UPDATE " + TABLE_NAME + " SET " +
COLUMN_PATIENT_NO + " = '" + oClass.PatientNo + "', " +
COLUMN_DATE + " = '" + oClass.CaseDate.ToString("yyyy-MM-d HH:MM:ss") + "', " +
COLUMN_TYPE + " = '" + oClass.ServiceType + "', " +
COLUMN_INSURANCE + " = '" + oClass.InsuranceCompanyID + "', " +
COLUMN_INSURANCE_NO + " = '" + oClass.InsuranceNo.Replace("'", "''") + "', " +
COLUMN_START_DATE + " = '" + oClass.StartDate + "', " +
COLUMN_END_DATE + " = '" + oClass.EndDate + "', " +
COLUMN_PHYSICIAN + " = '" + oClass.PhysicianID + "', " +
COLUMN_HOSPITAL + " = '" + oClass.HospitalID + "', " +
COLUMN_STATUS + " = '" + oClass.StatusID + "', " +
COLUMN_REMARKS + " = '" + oClass.Remarks.Replace("'", "''") + "', " +
" updated_by = '" + user + "', " +
" updated_date = '" + DateTime.Now.ToString("yyyy-MM-d HH:MM:ss") + "' " +
" WHERE " + COLUMN_ID + " = '" + oClass.ID + "' ";
SaveData(strSql);
}
