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 Page_Load(object sender, EventArgs e)
{
//get connection string from web config.
string connectionString = ConfigurationManager.ConnectionStrings["TestConnection"].ConnectionString;
//Create sql Connection and open it
using (SqlConnection connection = new SqlConnection(connectionString))
{
//other way connection.ConnectionString = connectionString;
connection.Open();
//select all from testQUestion table;
SqlCommand command = new SqlCommand("SELECT * FROM TestQuestion", connection);
//store the data temporary
SqlDataReader reader = command.ExecuteReader();
//has colums and rows
DataTable dt = new DataTable();
dt.Columns.Add("ID", typeof(int));
//create column headers based on data and fill it with data from the reader
dt.Load(reader);
//Display into a grid view UI
QuestionsGridView.DataSource = dt;
QuestionsGridView.DataBind();
}// will call dispose on my connection here, which will close my db connection
}
protected void ConfigGridView_CustomCallback(object sender, DevExpress.Web.ASPxGridViewCustomCallbackEventArgs e)
{
ListEditItem listItem = cmbQuestionnaireList.SelectedItem;
txtQuestionnaireName.Text = listItem.Text;
RefreshForm();
ConfigGridView.DataBind();
QuestionsGridView.DataBind();
}
protected void cmbQuestionnaireList_SelectedIndexChanged(object sender, EventArgs e)
{
ListEditItem listItem = cmbQuestionnaireList.SelectedItem;
txtQuestionnaireName.Text = listItem.Text;
RefreshForm();
ConfigGridView.DataBind();
QuestionsGridView.DataBind();
}
protected void QuestionsGridView_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
e.Cancel = true;
try
{
DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]);
DBAgent.AddParameter("@ParamQuestionnaireID", cmbQuestionnaireList.SelectedItem.Value);
DBAgent.AddParameter("@ParamQID", e.Keys[0]);
DBAgent.AddParameter("@ParamLoginID", Session["LoginID"]);
DBAgent.ExecuteNonQuery("dbo.spDeleteQuestionForQuestionnaire");
QuestionsGridView.DataBind();
}
catch (Exception ex)
{
CommonHelpers.writeLogToFile("QuestionsGridView_DataBinding: EditQuestionnaire.aspx", ex.Message);
}
}
protected void cmdSaveQuestion_Click(object sender, EventArgs e)
{
try
{
int QuestionID = 0;
DBAgent = new DataAccessProvider(DataAccessProvider.ParamType.ServerCredentials, ConfigurationManager.AppSettings["DBServerName"], ConfigurationManager.AppSettings["DBUserName"], ConfigurationManager.AppSettings["DBPassword"]);
DBAgent.AddParameter("@ParamQuestionText", txtQuestion.Text);
object o = DBAgent.ExecuteScalar("dbo.spAddQuestion");
if (o != null)
{
QuestionID = int.Parse(o.ToString());
if (QuestionID > 0)
{
int AnswerSortOrder = 1;
foreach (ListEditItem li in lbSelectedAnswers.Items)
{
DBAgent.ClearParams();
DBAgent.AddParameter("@ParamQuestionID", QuestionID);
DBAgent.AddParameter("@ParamAnswerID", li.Value);
DBAgent.AddParameter("@ParamAnswerSortOrder", AnswerSortOrder);
DBAgent.ExecuteNonQuery("dbo.spAddQuestionAnswerMapping");
AnswerSortOrder++;
}
DBAgent.ClearParams();
DBAgent.AddParameter("@ParamQuestionnaireID", cmbQuestionnaireList.SelectedItem.Value);
DBAgent.AddParameter("@ParamQuestionID", QuestionID);
DBAgent.ExecuteNonQuery("dbo.spAddQuestionnaireQuestionMapping");
QuestionsGridView.DataBind();
RefreshForm();
}
}
QuestionsGridView.DataBind();
}
catch (Exception ex)
{
CommonHelpers.writeLogToFile("cmdSaveQuestion_Click: EditQuestionnaire.aspx", ex.Message);
}
}
protected void BindQuestionsGrid()
{
QuestionsGridView.DataSource = HccApp.MembershipServices.UserQuestions.FindAll();
QuestionsGridView.DataKeyNames = new[] { "bvin" };
QuestionsGridView.DataBind();
}
protected void cmbQuestionnaireList_SelectedIndexChanged(object sender, EventArgs e)
{
QuestionsGridView.DataBind();
}
