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