protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                if (!IsPostBack && !IsCallback)
                {
                    int QuestionnaireID = 0;
                    securityAgent = new CryptoProvider();
                    if (Request.QueryString.Count > 0)
                    {
                        QuestionnaireID = int.Parse(securityAgent.decryptText(Request.QueryString["QID"].Replace(' ', '+')));
                        //QuestionnaireID = int.Parse(Request.QueryString["QID"]);
                        ViewState["CurrentQuestionnaire"] = QuestionnaireID;
                    }

                    LoadQuestionnaireList();
                    AnswerListGridView.DataBind();

                    if (QuestionnaireID > 0)
                    {
                        ConfigGridView.DataBind();
                        QuestionsGridView.DataBind();
                    }
                }
            }
            catch (Exception ex)
            {
                CommonHelpers.writeLogToFile("Page_Load: EditQuestionnaire.aspx", ex.Message);
            }
        }
 protected void AnswerListGridView_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
 {
     try
     {
         e.Cancel = true;
         DBAgent  = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]);
         DBAgent.AddParameter("@ParamAnswerText", e.NewValues[0]);
         object o = DBAgent.ExecuteScalar("dbo.spAddAnswer");
         if (o != null)
         {
             ViewState["NewAnswerID"] = o;
         }
         AnswerListGridView.CancelEdit();
     }
     catch (Exception ex)
     {
         CommonHelpers.writeLogToFile("AnswerListGridView_RowInserting: EditQuestionnaire.aspx", ex.Message);
     }
 }
 protected void AnswerListGridView_DataBinding(object sender, EventArgs e)
 {
     try
     {
         DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]);
         string  data = DBAgent.ExecuteStoredProcedure("dbo.spGetAllAnswers");
         DataSet ds   = CommonHelpers.GetDataSetFromXml(data);
         if (ds.Tables.Count > 0)
         {
             AnswerListGridView.DataSource = ds.Tables[0];
         }
         else
         {
             AnswerListGridView.ForceDataRowType(typeof(AnswerListClass));
         }
     }
     catch (Exception ex)
     {
         CommonHelpers.writeLogToFile("AnswerListGridView_DataBinding: EditQuestionnaire.aspx", ex.Message);
     }
 }
 protected void AnswerListGridView_RowInserted(object sender, DevExpress.Web.Data.ASPxDataInsertedEventArgs e)
 {
     AnswerListGridView.DataBind();
 }