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