public void Patient_Treatment_Info(OTPT_TREATMENT_DAO obj_OTPT_Treatment_DAO)
{
sqlCon = new SqlConnection(strConn);
try
{
sqlCon.Open();
sqlCmd = new SqlCommand("SP_TXN_OT_PT_EVALUATION_TREATMENT", sqlCon);
sqlCmd.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString());
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@SZ_PATIENT_ID", obj_OTPT_Treatment_DAO.SZ_PATIENT_ID);
sqlCmd.Parameters.AddWithValue("@SZ_CASE_ID", obj_OTPT_Treatment_DAO.SZ_CASE_ID);
sqlCmd.Parameters.AddWithValue("@SZ_BILL_NO", obj_OTPT_Treatment_DAO.SZ_BILL_NO);
sqlCmd.Parameters.AddWithValue("@BT_REFRERAL_FOR", obj_OTPT_Treatment_DAO.BT_REFRERAL_FOR);
sqlCmd.Parameters.AddWithValue("@SZ_EVALUTION_DESC", obj_OTPT_Treatment_DAO.SZ_EVALUTION_DESC);
sqlCmd.Parameters.AddWithValue("@SZ_PATIENT_CONDITION", obj_OTPT_Treatment_DAO.SZ_PATIENT_CONDITION);
sqlCmd.Parameters.AddWithValue("@SZ_TREATMENT", obj_OTPT_Treatment_DAO.SZ_TREATMENT);
sqlCmd.Parameters.AddWithValue("@BT_TREATMENT_PLAN", obj_OTPT_Treatment_DAO.BT_TREATMENT_PLAN);
sqlCmd.Parameters.AddWithValue("@SZ_FREQUENCY", obj_OTPT_Treatment_DAO.SZ_FREQUENCY);
sqlCmd.Parameters.AddWithValue("@SZ_PERIOD", obj_OTPT_Treatment_DAO.SZ_PERIOD);
sqlCmd.Parameters.AddWithValue("@DT_DATE_OF_VISIT_REPORT", obj_OTPT_Treatment_DAO.DT_DATE_OF_VISIT_REPORT);
sqlCmd.Parameters.AddWithValue("@DT_DATE_OF_FIRST_VISIT", obj_OTPT_Treatment_DAO.DT_DATE_OF_FIRST_VISIT);
sqlCmd.Parameters.AddWithValue("@BT_PATIENT_SEEN_AGAIN", obj_OTPT_Treatment_DAO.BT_PATIENT_SEEN_AGAIN);
sqlCmd.Parameters.AddWithValue("@SZ_PATIENT_SEEN_YES", obj_OTPT_Treatment_DAO.SZ_PATIENT_SEEN_YES);
sqlCmd.Parameters.AddWithValue("@BT_PATIENT_ATTENDING_DOCTOR", obj_OTPT_Treatment_DAO.BT_PATIENT_ATTENDING_DOCTOR);
sqlCmd.Parameters.AddWithValue("@BT_PATIENT_WORKING", obj_OTPT_Treatment_DAO.BT_PATIENT_WORKING);
sqlCmd.Parameters.AddWithValue("@SZ_LIMITED_WORK", obj_OTPT_Treatment_DAO.SZ_LIMITED_WORK);
sqlCmd.Parameters.AddWithValue("@SZ_REGULAR_WORK", obj_OTPT_Treatment_DAO.SZ_REGULAR_WORK);
sqlCmd.Parameters.AddWithValue("@SZ_COMPANY_ID", obj_OTPT_Treatment_DAO.SZ_COMPANY_ID);
sqlCmd.Parameters.AddWithValue("@BT_ADDITIONAL_SPACE", obj_OTPT_Treatment_DAO.BT_ADDITIONAL_SPACE);
sqlCmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
finally
{
if (sqlCon.State == ConnectionState.Open)
{
sqlCon.Close();
}
}
}
private void SaveData()
{
string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url);
using (Utils utility = new Utils())
{
utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod());
}
//rdbreferral
try
{
obj_OTPT_Treatment = new OTPT_TREATMENT_DAO();
obj_OTPT = new OTPT();
obj_OTPT_Treatment.SZ_PATIENT_ID = txtPatientID.Text;
obj_OTPT_Treatment.SZ_CASE_ID = txtCaseID.Text;
obj_OTPT_Treatment.SZ_BILL_NO = txtBillNumber.Text;
obj_OTPT_Treatment.BT_REFRERAL_FOR = rdbreferral.SelectedValue;
obj_OTPT_Treatment.SZ_EVALUTION_DESC = txtEvaluation.Text;
obj_OTPT_Treatment.SZ_PATIENT_CONDITION = txtcondition.Text;
obj_OTPT_Treatment.SZ_TREATMENT = txtTreatment.Text;
obj_OTPT_Treatment.BT_TREATMENT_PLAN = rdlstDiagnosisTestandReferral.SelectedValue;
obj_OTPT_Treatment.SZ_FREQUENCY = txtfrequency.Text;
obj_OTPT_Treatment.SZ_PERIOD = txtPeriod.Text;
obj_OTPT_Treatment.DT_DATE_OF_VISIT_REPORT = txtVisitDate.Text;
obj_OTPT_Treatment.DT_DATE_OF_FIRST_VISIT = txtFirstVisitDate.Text;
obj_OTPT_Treatment.BT_PATIENT_SEEN_AGAIN = rdnpatientseen.SelectedValue;
obj_OTPT_Treatment.SZ_PATIENT_SEEN_YES = txtPatientSeen.Text;
obj_OTPT_Treatment.BT_PATIENT_ATTENDING_DOCTOR = rbpatientAttendingDoctor.SelectedValue;
obj_OTPT_Treatment.BT_PATIENT_WORKING = rbPatientWorking.SelectedValue;
obj_OTPT_Treatment.SZ_LIMITED_WORK = txtlimitedwork.Text;
obj_OTPT_Treatment.SZ_REGULAR_WORK = txtregularwork.Text;
obj_OTPT_Treatment.SZ_COMPANY_ID = txtCompanyID.Text;
if (chkTreatment.Checked)
{
obj_OTPT_Treatment.BT_ADDITIONAL_SPACE = "1";
}
else
{
obj_OTPT_Treatment.BT_ADDITIONAL_SPACE = "0";
}
obj_OTPT.Patient_Treatment_Info(obj_OTPT_Treatment);
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
using (Utils utility = new Utils())
{
utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
}
string str2 = "Error Request=" + id + ".Please share with Technical support.";
base.Response.Redirect("Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2);
}
//Method End
using (Utils utility = new Utils())
{
utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod());
}
}
