Example #1
0
 public void Patient_Therapist_Info(OTPT_THERAPIST_DAO obj_OTPT_THERAPIST_DAO)
 {
     sqlCon = new SqlConnection(strConn);
     try
     {
         sqlCon.Open();
         sqlCmd = new SqlCommand("SP_TXN_OTPT_THERAPIST_INFO", sqlCon);
         sqlCmd.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString());
         sqlCmd.CommandType    = CommandType.StoredProcedure;
         sqlCmd.Parameters.AddWithValue("@SZ_CASE_ID", obj_OTPT_THERAPIST_DAO.SZ_CASE_ID);
         sqlCmd.Parameters.AddWithValue("@SZ_BILL_NO", obj_OTPT_THERAPIST_DAO.SZ_BILL_NO);
         sqlCmd.Parameters.AddWithValue("@BT_DOCTOR_TYPE", obj_OTPT_THERAPIST_DAO.SZ_BT_SSN_EIN);
         sqlCmd.Parameters.AddWithValue("@SZ_COMPANY_ID", obj_OTPT_THERAPIST_DAO.SZ_COMPANY_ID);
         sqlCmd.ExecuteNonQuery();
     }
     catch (SqlException ex)
     {
         Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
     }
     finally
     {
         if (sqlCon.State == ConnectionState.Open)
         {
             sqlCon.Close();
         }
     }
 }
    public 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());
        }
        _OTPT_THERAPIST_DAO = new OTPT_THERAPIST_DAO();
        obj_OTPT            = new OTPT();

        try
        {
            _OTPT_THERAPIST_DAO.SZ_CASE_ID = txtCaseID.Text;
            _OTPT_THERAPIST_DAO.SZ_BILL_NO = txtBillNo.Text;
            if (rdlstTaxType.SelectedValue == "0")
            {
                _OTPT_THERAPIST_DAO.SZ_BT_SSN_EIN = rdlstTaxType.SelectedValue;
            }
            else if (rdlstTaxType.SelectedValue == "1")
            {
                _OTPT_THERAPIST_DAO.SZ_BT_SSN_EIN = rdlstTaxType.SelectedValue;
            }
            _OTPT_THERAPIST_DAO.SZ_COMPANY_ID = txtCompanyID.Text;
            obj_OTPT.Patient_Therapist_Info(_OTPT_THERAPIST_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());
        }
    }