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