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