public void Save_Psy_Info(Bill_Sys_Psyinfo _Bill_Sys_Psyinfo)
{
SqlConnection sqlCon = new SqlConnection(strConn);
try
{
sqlCon.Open();
comm = new SqlCommand("sp_txn_update_psy_patient_info", conn);
comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString());
comm.CommandType = CommandType.StoredProcedure;
comm.Connection = sqlCon;
comm.Parameters.AddWithValue("@i_attending_psy", _Bill_Sys_Psyinfo.RBATTENDING);
comm.Parameters.AddWithValue("@bt_service_provider", _Bill_Sys_Psyinfo.SERVICEPROVIDER);
comm.Parameters.AddWithValue("@sz_incident_description", _Bill_Sys_Psyinfo.INCIDENT);
comm.Parameters.AddWithValue("@sz_preexisting_psy", _Bill_Sys_Psyinfo.HISTORY);
comm.Parameters.AddWithValue("@bt_referal_for", _Bill_Sys_Psyinfo.BREFERAL);
comm.Parameters.AddWithValue("@sz_evalution", _Bill_Sys_Psyinfo.EVALUATION);
comm.Parameters.AddWithValue("@sz_patient_condition", _Bill_Sys_Psyinfo.CONDITION);
comm.Parameters.AddWithValue("@bt_authentication_req", _Bill_Sys_Psyinfo.CHK_TREATEMENT);
comm.Parameters.AddWithValue("@sz_authentication_req", _Bill_Sys_Psyinfo.TREATEMENTTEXT);
comm.Parameters.AddWithValue("@dt_dateof_visited", _Bill_Sys_Psyinfo.VISITEDDATE);
comm.Parameters.AddWithValue("@dt_first_dateof_visit", _Bill_Sys_Psyinfo.FIRSTVISITEDDATE);
comm.Parameters.AddWithValue("@bt_will_patient_see_again", _Bill_Sys_Psyinfo.PATIANTSEEN);
comm.Parameters.AddWithValue("@dt_yes_seen", _Bill_Sys_Psyinfo.NOPATIENTSEEN);
comm.Parameters.AddWithValue("@i_no_seen", _Bill_Sys_Psyinfo.PATIANTATTENDING_DOCTOR);
comm.Parameters.AddWithValue("@i_is_patient_working", _Bill_Sys_Psyinfo.PATIANT_WORKING);
comm.Parameters.AddWithValue("@sz_yes_patient_working", _Bill_Sys_Psyinfo.LIMITEDWORK);
comm.Parameters.AddWithValue("@sz_patient_regular_work", _Bill_Sys_Psyinfo.REGULARWORK);
comm.Parameters.AddWithValue("@i_sustained", _Bill_Sys_Psyinfo.SUSTAINED);
comm.Parameters.AddWithValue("@sz_additional_info", _Bill_Sys_Psyinfo.ADDITIONALINFO);
comm.Parameters.AddWithValue("@i_vfbl_or_vawbl", _Bill_Sys_Psyinfo.VLBF);
comm.Parameters.AddWithValue("@sz_patient_acc_number", _Bill_Sys_Psyinfo.PATIANTACCNO);
comm.Parameters.AddWithValue("@i_case_id", _Bill_Sys_Psyinfo.CASEID);
comm.Parameters.AddWithValue("@sz_company_id", _Bill_Sys_Psyinfo.COMPANYID);
comm.Parameters.AddWithValue("@dt_historyof_injury", _Bill_Sys_Psyinfo.DATEOFFORTH);
comm.ExecuteNonQuery();
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
finally { 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());
}
//rdbreferral
try
{
Bill_Sys_Psyinfo _objBill_Sys_Psyinfo = new Bill_Sys_Psyinfo();
Bill_save _obj_Bill_save = new Bill_save();
_objBill_Sys_Psyinfo.RBATTENDING = rbattenting_psy.SelectedValue;
_objBill_Sys_Psyinfo.SERVICEPROVIDER = rbserviceprovider.SelectedValue;
_objBill_Sys_Psyinfo.INCIDENT = txtincident.Text;
_objBill_Sys_Psyinfo.HISTORY = txthistory.Text;
_objBill_Sys_Psyinfo.BREFERAL = rdbreferral.SelectedValue;
_objBill_Sys_Psyinfo.EVALUATION = txtEvaluation.Text;
_objBill_Sys_Psyinfo.CONDITION = txtcondition.Text;
_objBill_Sys_Psyinfo.TREATEMENTTEXT = txtTreatment.Text;
_objBill_Sys_Psyinfo.VISITEDDATE = txtVisitDate.Text;
_objBill_Sys_Psyinfo.FIRSTVISITEDDATE = txtFirstVisitDate.Text;
_objBill_Sys_Psyinfo.PATIANTSEEN = rdnpatientseen.Text;
_objBill_Sys_Psyinfo.NOPATIENTSEEN = txtPatientSeen.Text;
_objBill_Sys_Psyinfo.PATIANTATTENDING_DOCTOR = rbpatientAttendingDoctor.SelectedValue;
_objBill_Sys_Psyinfo.PATIANT_WORKING = rbPatientWorking.SelectedValue;
_objBill_Sys_Psyinfo.LIMITEDWORK = txtlimitedwork.Text;
_objBill_Sys_Psyinfo.REGULARWORK = txtregularwork.Text;
_objBill_Sys_Psyinfo.SUSTAINED = rbsustained.SelectedValue;
_objBill_Sys_Psyinfo.ADDITIONALINFO = txtadditionalinfo.Text;
_objBill_Sys_Psyinfo.VLBF = rbvfblorvawbl.SelectedValue;
_objBill_Sys_Psyinfo.DATEOFFORTH = txtdateof_forth_history.Text;
_objBill_Sys_Psyinfo.CASEID = txtCaseID.Text;
_objBill_Sys_Psyinfo.PATIANTACCNO = txtPatientAccNo.Text;
_objBill_Sys_Psyinfo.COMPANYID = txtCompanyID.Text;
if (chkTreatment.Checked)
{
_objBill_Sys_Psyinfo.CHK_TREATEMENT = "1";
}
else
{
_objBill_Sys_Psyinfo.CHK_TREATEMENT = "0";
}
_obj_Bill_save.Save_Psy_Info(_objBill_Sys_Psyinfo);
}
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());
}
}
