public void Patient_Report_Info(OTPT_DAO obj_OTPT_DAO)
{
sqlCon = new SqlConnection(strConn);
try
{
sqlCon.Open();
sqlCmd = new SqlCommand("SP_TXN_OTPT_REPORT_INFO", sqlCon);
sqlCmd.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString());
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@SZ_PATIENT_ID", obj_OTPT_DAO.SZ_PATIENT_ID);
sqlCmd.Parameters.AddWithValue("@SZ_CASE_ID", obj_OTPT_DAO.SZ_CASE_ID);
sqlCmd.Parameters.AddWithValue("@SZ_BILL_NO", obj_OTPT_DAO.SZ_BILL_NO);
sqlCmd.Parameters.AddWithValue("@BT_OCCUPATIOANL_THERP_REPORT", obj_OTPT_DAO.SZ_BT_OCCUPATIONAL);
sqlCmd.Parameters.AddWithValue("@BT_PHYSICAL_THERP_REPORT", obj_OTPT_DAO.SZ_BT_PHYSICAL);
sqlCmd.Parameters.AddWithValue("@BT_48HR_INI_REPORT", obj_OTPT_DAO.SZ_BT_48_HOUR);
sqlCmd.Parameters.AddWithValue("@BT_15DAY_INI_REPORT", obj_OTPT_DAO.SZ_BT_15_DAY);
sqlCmd.Parameters.AddWithValue("@BT_90DAY_PRO_REPORT", obj_OTPT_DAO.SZ_BT_90_DAY);
sqlCmd.Parameters.AddWithValue("@BT_PPO", obj_OTPT_DAO.SZ_BT_PPO);
sqlCmd.Parameters.AddWithValue("@SZ_COMPANY_ID", obj_OTPT_DAO.SZ_COMPANY_ID);
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());
}
obj_OTPT_DAO = new OTPT_DAO();
objOTPT = new OTPT();
string sz_bt_occup = "0";
string sz_bt_physical = "0";
string sz_bt_48Hour = "0";
string sz_bt_15Day = "0";
string sz_bt_90Day = "0";
string sz_bt_PPO = "2";
try
{
if (chkOCCUPATIONAL.Checked == true)
{
sz_bt_occup = "1";
}
if (chkPHYSICAL.Checked == true)
{
sz_bt_physical = "1";
}
if (chk48Hour.Checked == true)
{
sz_bt_48Hour = "1";
}
if (chk15Day.Checked == true)
{
sz_bt_15Day = "1";
}
if (chk90Day.Checked == true)
{
sz_bt_90Day = "1";
}
//if (rdlstPPO.SelectedValue=="0")
//{
// sz_bt_PPO = "0";
//}
//else if (rdlstPPO.SelectedValue == "1")
//{
// sz_bt_PPO = "1";
//}
//else if (rdlstPPO.SelectedValue == "2")
//{
// sz_bt_PPO = "2";
//}
obj_OTPT_DAO.SZ_CASE_ID = txtCaseID.Text;
obj_OTPT_DAO.SZ_PATIENT_ID = txtPatientID.Text;
obj_OTPT_DAO.SZ_BILL_NO = txtBillNumber.Text;
obj_OTPT_DAO.SZ_BT_OCCUPATIONAL = sz_bt_occup;
obj_OTPT_DAO.SZ_BT_PHYSICAL = sz_bt_physical;
obj_OTPT_DAO.SZ_BT_48_HOUR = sz_bt_48Hour;
obj_OTPT_DAO.SZ_BT_15_DAY = sz_bt_15Day;
obj_OTPT_DAO.SZ_BT_90_DAY = sz_bt_90Day;
obj_OTPT_DAO.SZ_BT_PPO = rdlstPPO.SelectedValue;
obj_OTPT_DAO.SZ_COMPANY_ID = txtCompanyID.Text;
objOTPT.Patient_Report_Info(obj_OTPT_DAO);
}
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());
}
}
