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_PATIENT_DAO = new OTPT_PATIENT_DAO(); _objOTPT = new OTPT(); try { _OTPT_PATIENT_DAO.SZ_PATIENT_ID = txtPatientID.Text; _OTPT_PATIENT_DAO.SZ_CASE_ID = txtCaseID.Text; _OTPT_PATIENT_DAO.SZ_BILL_NO = txtBillNumber.Text; _OTPT_PATIENT_DAO.SZ_PATIENT_INJURY_PLACE = txtaddcitytown.Text; string sztimeofenjury = ddlHours.Text + ":" + ddlMinutes.Text; string sztimetype = ddlTime.Text; _OTPT_PATIENT_DAO.SZ_TIME_OF_INJURY = sztimeofenjury; _OTPT_PATIENT_DAO.SZ_TIME_TYPE = sztimetype; _OTPT_PATIENT_DAO.SZ_TREATEMNET_UNDER = rdlstTaxType.SelectedValue; //if (rdlstTaxType.SelectedValue == "0") //{ // _OTPT_PATIENT_DAO.SZ_TREATEMNET_UNDER = rdlstTaxType.SelectedItem.Value; //} //else if (rdlstTaxType.SelectedValue == "1") //{ // _OTPT_PATIENT_DAO.SZ_TREATEMNET_UNDER = rdlstTaxType.SelectedItem.Value; //} //else if (rdlstTaxType.SelectedValue == "2") //{ // _OTPT_PATIENT_DAO.SZ_TREATEMNET_UNDER = rdlstTaxType.SelectedItem.Value; //} _OTPT_PATIENT_DAO.DT_DATE_OF_PRV_HISTROY = txtHistoryInjuryDate.Text; _OTPT_PATIENT_DAO.SZ_COMPANY_ID = txtCompanyID.Text; _OTPT_PATIENT_DAO.SZ_REFFERING_PHYSICIAN = txtReffering.Text; _OTPT_PATIENT_DAO.SZ_REFFERING_PHYSICIAN_ADDRESS = txtrefferingaddress.Text; _OTPT_PATIENT_DAO.SZ_REFFERING_TELEPHONE_NO = txtrefferingtelno.Text; _objOTPT.Save_Patient_Info(_OTPT_PATIENT_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()); } }
public void Save_Patient_Info(OTPT_PATIENT_DAO obj_OTPT_PATIENT_DAO) { sqlCon = new SqlConnection(strConn); try { sqlCon.Open(); sqlCmd = new SqlCommand("SP_TXN_OTPT_PATIENT_INFO", sqlCon); sqlCmd.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString()); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@SZ_PATIENT_ID", obj_OTPT_PATIENT_DAO.SZ_PATIENT_ID); sqlCmd.Parameters.AddWithValue("@SZ_CASE_ID", obj_OTPT_PATIENT_DAO.SZ_CASE_ID); sqlCmd.Parameters.AddWithValue("@SZ_BILL_NO", obj_OTPT_PATIENT_DAO.SZ_BILL_NO); sqlCmd.Parameters.AddWithValue("@SZ_PATIENT_INJURY_PLACE", obj_OTPT_PATIENT_DAO.SZ_PATIENT_INJURY_PLACE); sqlCmd.Parameters.AddWithValue("@SZ_TIME_OF_INJURY", obj_OTPT_PATIENT_DAO.SZ_TIME_OF_INJURY); sqlCmd.Parameters.AddWithValue("@SZ_TREATEMNET_UNDER", obj_OTPT_PATIENT_DAO.SZ_TREATEMNET_UNDER); sqlCmd.Parameters.AddWithValue("@DT_DATE_OF_PRV_HISTROY", obj_OTPT_PATIENT_DAO.DT_DATE_OF_PRV_HISTROY); sqlCmd.Parameters.AddWithValue("@SZ_COMPANY_ID", obj_OTPT_PATIENT_DAO.SZ_COMPANY_ID); sqlCmd.Parameters.AddWithValue("@SZ_TIME_TYPE", obj_OTPT_PATIENT_DAO.SZ_TIME_TYPE); sqlCmd.Parameters.AddWithValue("@SZ_REFFERING_PHYSICIAN", obj_OTPT_PATIENT_DAO.SZ_REFFERING_PHYSICIAN); sqlCmd.Parameters.AddWithValue("@SZ_REFFERING_PHYSICIAN_ADDRESS", obj_OTPT_PATIENT_DAO.SZ_REFFERING_PHYSICIAN_ADDRESS); sqlCmd.Parameters.AddWithValue("@SZ_REFFERING_TELEPHONE_NO", obj_OTPT_PATIENT_DAO.SZ_REFFERING_TELEPHONE_NO); //sqlCmd.Parameters.AddWithValue("@FLAG", "ADD"); sqlCmd.ExecuteNonQuery(); } catch (SqlException ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); } finally { if (sqlCon.State == ConnectionState.Open) { sqlCon.Close(); } } }