protected void Page_Load(object sender, EventArgs e) { try { PatientListGridView.ForceDataRowType(typeof(ClarityDBSet.PatientDSRow)); gvAssignedQuestionnaire.ForceDataRowType(typeof(ClarityDBSet.PatientAssignedQuestionnaireRow)); if (!IsPostBack && !IsCallback) { PatientListGridView.DataBind(); } } catch (Exception ex) { CommonHelpers.writeLogToFile("Page_Load: PatientList.aspx", ex.Message); } }
protected void PatientListGridView_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { try { DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]); DBAgent.AddParameter("@ParamPatientID", 0); DBAgent.AddParameter("@ParamFirstName", e.NewValues["PatientFirstName"]); DBAgent.AddParameter("@ParamLastName", e.NewValues["PatientLastName"]); DBAgent.AddParameter("@ParamAccount", e.NewValues["PatientAccountNumber"]); DBAgent.AddParameter("@ParamDOB", e.NewValues["PatientDOB"]); DBAgent.AddParameter("@ParamPrimaryPhysicianID", e.NewValues["PhysicianName"]); DBAgent.AddParameter("@ParamLoginID", Session["LoginID"]); DBAgent.ExecuteNonQuery("spAddEditPatient"); e.Cancel = true; PatientListGridView.CancelEdit(); } catch (Exception ex) { CommonHelpers.writeLogToFile("PatientListGridView_RowInserting: PatientList.aspx", ex.Message); } }