protected void Page_Load(object sender, EventArgs e)
{
CurrentQuestionLabel.Text = "Question " + AppSession.getquestionnumberLabel();
int currentQuestion = AppSession.getCurrentQuestionID();
//extrl question setting
List <int> extraQuestion = AppSession.getExtraQuestionsList();
using (SqlConnection connection = GetConnection())
{
string commandStr = "select * from question where question.qid = " + currentQuestion;
SqlCommand command = new SqlCommand(commandStr, connection);
SqlDataReader reader = command.ExecuteReader();
//read question type and question label from question DB
if (reader.Read())
{
string questionText = (string)reader["qdescription"];
string questionType = (string)reader["qtype"].ToString().ToLower();
if (questionType.Equals("text"))
{
TextBoxControl textBoxControl = (TextBoxControl)LoadControl("~/TextBoxControl.ascx");
textBoxControl.ID = TEXTBOX_ID;
textBoxControl.QuestionLabel.Text = questionText;
questionPlaceHolder.Controls.Add(textBoxControl);
}
else if (questionType.Equals("check"))
{
CheckBoxControl checkBoxControl = (CheckBoxControl)LoadControl("~/CheckBoxControl.ascx"); //需要手动导入
checkBoxControl.ID = CHECKBOX_ID;
checkBoxControl.QuestionLabel.Text = questionText;
//
try {
SqlCommand optionCommand = new SqlCommand("select * from options Where qid=" + currentQuestion, connection);
//find all the options in option table with same question id
SqlDataReader optionReader = optionCommand.ExecuteReader();
while (optionReader.Read())
{
ListItem item = new ListItem(optionReader["description"].ToString(), optionReader["oid"].ToString());
checkBoxControl.QuestionCheckBoxList.Items.Add(item);
}
//
questionPlaceHolder.Controls.Add(checkBoxControl);
}
catch (SqlException ex)
{
Console.WriteLine("Error: " + ex);
}
}
else if (questionType.Equals("radio"))
{
RadioContrell radioBoxCoontrol = (RadioContrell)LoadControl("~/RadioControl.ascx");
radioBoxCoontrol.ID = RADIOBOX_ID;
radioBoxCoontrol.QuestionLabel.Text = questionText;
try {
SqlCommand optionCommand = new SqlCommand("select * from options Where qid=" + currentQuestion, connection);
//find all the options in option table with same question id
SqlDataReader optionReader = optionCommand.ExecuteReader();
while (optionReader.Read())
{
ListItem item = new ListItem(optionReader["description"].ToString(), optionReader["oid"].ToString());
radioBoxCoontrol.QuestionRadioList.Items.Add(item);
}
//
questionPlaceHolder.Controls.Add(radioBoxCoontrol);
}
catch (SqlException ex)
{
Console.WriteLine("Error: " + ex);
}
}
}
}
}
// private string questionID;
protected void Page_Load(object sender, EventArgs e)
{
CurrentQuestionLabel.Text = "Question " + AppSession.getQuestionID();
int currentQuestion = AppSession.getCurrentQuestionID();
using (SqlConnection connection = GetConnection())
{
//Console.WriteLine("I am here using");
string commandStr = "SELECT * FROM Question, Type " +
"WHERE Question.type = Type.ID AND Question.ID = " + currentQuestion;
SqlCommand command = new SqlCommand(commandStr, connection);
//run command, collect results into reader
SqlDataReader reader = command.ExecuteReader();
//see if we have at least 1 result
if (reader.Read())
{
//read basic info from result row
string questionText = (string)reader["text"];
string questionType = reader["Name"].ToString().ToLower();
if (questionType.Equals("textbox"))
{
//load up control
TextBoxControl textBoxControl = (TextBoxControl)LoadControl("~/TextBoxControl.ascx");
//set it up
textBoxControl.ID = TEXTBOX_ID;
textBoxControl.QuestionLabel.Text = questionText;
//add to placeholder
questionPlaceHolder.Controls.Add(textBoxControl);
}
else if (questionType.Equals("checkbox"))
{
CheckBoxControl checkBoxControl = (CheckBoxControl)LoadControl("~/CheckBoxControl.ascx");
checkBoxControl.ID = CHECKBOX_ID;
checkBoxControl.QuestionLabel.Text = questionText;
//ask DB for options associated with this question
SqlCommand optionCommand = new SqlCommand("SELECT * FROM Options WHERE questionID = " + currentQuestion, connection);
//execute into reader
SqlDataReader optionReader = optionCommand.ExecuteReader();
//loop through results(1 row at a time
while (optionReader.Read())
{
//build list items from results
ListItem item = new ListItem(optionReader["text"].ToString(), optionReader["ID"].ToString());
checkBoxControl.QuestionCheckBoxList.Items.Add(item);
}
//add loaded control to the placeholder
questionPlaceHolder.Controls.Add(checkBoxControl);
}
else if (questionType.Equals("radiochecklist"))
{
Console.WriteLine("I am here");
RadioBoxControl radioBoxControl = (RadioBoxControl)LoadControl("~/RadioBoxControl.ascx");
radioBoxControl.ID = RADIOBOX_ID;
radioBoxControl.QuestionLabel.Text = questionText;
SqlCommand optionCommand = new SqlCommand("SELECT * FROM Options WHERE questionID = " + currentQuestion, connection);
SqlDataReader optionReader = optionCommand.ExecuteReader();
//loop through results(1 row at a time
while (optionReader.Read())
{
ListItem item = new ListItem(optionReader["text"].ToString(), optionReader["ID"].ToString());
radioBoxControl.QuestionRadioBoxList.Items.Add(item);
}
questionPlaceHolder.Controls.Add(radioBoxControl);
}
}
}//closes db connection for us here
}
protected void NextButton_Click(object sender, EventArgs e)
{
int currentQuestion = AppSession.getCurrentQuestionID();
List <int> extraQuestion = AppSession.getExtraQuestionsList();
//save Answers in session
//setup DB connection
using (SqlConnection connection = GetConnection())
{
//check for answers user has filled in on the form
//check t osee if previously a textbox conto the screen
TextBoxControl textBoxControl = (TextBoxControl)questionPlaceHolder.FindControl(TEXTBOX_ID);
if (textBoxControl != null)
{
string typeAnswer = textBoxControl.QuestionTextBox.Text;
Answer answer = new Answer();
answer.UserID = AppSession.getSavedUserId();
answer.questionType = "text";
answer.answerText = typeAnswer;
answer.questionID = currentQuestion;
AppSession.SaveAnswersInSession(answer);
}
CheckBoxControl checkBoxControl = (CheckBoxControl)questionPlaceHolder.FindControl(CHECKBOX_ID);
if (checkBoxControl != null)
{
foreach (ListItem item in checkBoxControl.QuestionCheckBoxList.Items)
{
if (item.Selected)
{
try
{
SqlCommand optionCommand = new SqlCommand("select * from options Where oid=" + item.Value, connection);
//find all the options in option table with same option id
SqlDataReader optionReader = optionCommand.ExecuteReader();
int optionindex = optionReader.GetOrdinal("next_question");
if (optionReader.Read())
{
if (!optionReader.IsDBNull(optionindex))
{
int extraquestionID = int.Parse(optionReader["next_question"].ToString());
if (!extraQuestion.Contains(extraquestionID))
{
extraQuestion.Add(extraquestionID);
}
}
}
}
catch (SqlException ex) {
Console.WriteLine("Error: " + ex);
}
Answer answer = new Answer();
answer.UserID = AppSession.getSavedUserId();
answer.questionType = "check";
answer.optionID = int.Parse(item.Value);
answer.questionID = currentQuestion;
AppSession.SaveAnswersInSession(answer);
}
}
}
RadioContrell radioContrell = (RadioContrell)questionPlaceHolder.FindControl(RADIOBOX_ID);
if (radioContrell != null)
{
foreach (ListItem item in radioContrell.QuestionRadioList.Items)
{
if (item.Selected)
{
try
{
SqlCommand optionCommand = new SqlCommand("select * from options Where oid=" + item.Value, connection);
//find all the options in option table with same option id
SqlDataReader optionReader = optionCommand.ExecuteReader();
int optionindex = optionReader.GetOrdinal("next_question");
if (optionReader.Read())
{
if (!optionReader.IsDBNull(optionindex))
{
int extraquestionID = int.Parse(optionReader["next_question"].ToString());
if (!extraQuestion.Contains(extraquestionID))
{
extraQuestion.Add(extraquestionID);
}
}
}
Answer answer = new Answer();
answer.UserID = AppSession.getSavedUserId();
answer.questionType = "radio";
answer.optionID = int.Parse(item.Value);
answer.questionID = currentQuestion;
AppSession.SaveAnswersInSession(answer);
}
catch (SqlException ex)
{
Console.WriteLine("Error: " + ex);
}
}
}
}
//if (currentQuestion == 1) {
// extraQuestion.Add(3);
// extraQuestion.Add(4);
//}
if (extraQuestion.Count > 0)
{
int nextQuestion = extraQuestion[0];
extraQuestion.Remove(nextQuestion);
AppSession.setExtraQuestionsList(extraQuestion);
AppSession.setCurrentQuestionID(nextQuestion);
Response.Redirect("QuestionPage.aspx");
}
//use sql comd to get next question
//Go to next question 18510862276
SqlCommand command = new SqlCommand("SELECT * FROM question WHERE qid = " + currentQuestion, connection);
SqlDataReader reader = command.ExecuteReader();
//read first row (dont care if ,ultiple are returned
if (reader.Read())
{
//get index of column want tot check
int nextQuestionColumnIndex = reader.GetOrdinal("next_question");
//check if this column's value is null
if (reader.IsDBNull(nextQuestionColumnIndex))
{
//读取答案 要改
List <Answer> useranswers = AppSession.getAnswerList();
foreach (Answer item in useranswers)
{
if (item.questionType == "text")
{
try {
SqlCommand answerinsertCommmand = new SqlCommand("INSERT INTO answer (answer, qid, uid) VALUES (@answertext,@Qid,@Uid);", connection);
SqlParameter answertext = new SqlParameter();
answertext.ParameterName = "@answertext";
answertext.Value = item.answerText;
SqlParameter QuestionID = new SqlParameter();
QuestionID.ParameterName = "@Qid";
QuestionID.Value = item.questionID;
SqlParameter userID = new SqlParameter();
userID.ParameterName = "@Uid";
userID.Value = item.UserID;
answerinsertCommmand.Parameters.Add(answertext);
answerinsertCommmand.Parameters.Add(QuestionID);
answerinsertCommmand.Parameters.Add(userID);
answerinsertCommmand.ExecuteNonQuery();
}
catch (SqlException ex)
{
Console.WriteLine("Error: " + ex);
}
}
else if (item.questionType == "check" || item.questionType == "radio")
{
if (item.questionID == 8)
{
if (item.optionID == null)
{
try {
SqlCommand answerinsertCommmand = new SqlCommand("INSERT INTO answer (qid, uid) VALUES (@Qid,@Uid);", connection);
SqlParameter QuestionID = new SqlParameter();
QuestionID.ParameterName = "@Qid";
QuestionID.Value = item.questionID;
SqlParameter userID = new SqlParameter();
userID.ParameterName = "@Uid";
userID.Value = item.UserID;
answerinsertCommmand.Parameters.Add(QuestionID);
answerinsertCommmand.Parameters.Add(userID);
answerinsertCommmand.ExecuteNonQuery();
}
catch (SqlException ex)
{
Console.WriteLine("Error: " + ex);
}
}
}
else
{
try {
SqlCommand answerinsertCommmand = new SqlCommand("INSERT INTO answer (oid, qid, uid) VALUES (@Optionid,@Qid,@Uid);", connection);
SqlParameter answertext = new SqlParameter();
answertext.ParameterName = "@Optionid";
answertext.Value = item.optionID;
SqlParameter QuestionID = new SqlParameter();
QuestionID.ParameterName = "@Qid";
QuestionID.Value = item.questionID;
SqlParameter userID = new SqlParameter();
userID.ParameterName = "@Uid";
userID.Value = item.UserID;
answerinsertCommmand.Parameters.Add(answertext);
answerinsertCommmand.Parameters.Add(QuestionID);
answerinsertCommmand.Parameters.Add(userID);
answerinsertCommmand.ExecuteNonQuery();
}
catch (SqlException ex)
{
Console.WriteLine("Error: " + ex);
}
}
}
}
Server.Transfer("FinishPage.aspx");
}
else
{
//next question
AppSession.setCurrentQuestionID((int)reader["next_question"]);
//reload the page so that pageLoad loads correct new question up
AppSession.setquestionnumberlabel();
Response.Redirect("QuestionPage.aspx");
}
}
else
{
//exceptions
}
}
}
protected void NextButton_Click(object sender, EventArgs e)
{
int currentQuestion = AppSession.getCurrentQuestionID();
AppSession.incrementLabelNumber();
List <int> extraQuestions = AppSession.getExtraQuestionsList();
if (HttpContext.Current.Session["answer"] == null)
{
List <Answer> answerList = new List <Answer>();
HttpContext.Current.Session["answer"] = answerList;
}
//setup DB connection
using (SqlConnection connection = GetConnection())
{
//check for answers user has filled in on the form
//check to see if previously a textbox control was dynamically added to the screen
TextBoxControl textBoxControl = (TextBoxControl)questionPlaceHolder.FindControl(TEXTBOX_ID);//find control is looking for id of something
if (textBoxControl != null)
{
//tring typedAnswer = textBoxControl.QuestionTextBox.Text;
//TODO: store in session so that later it can be stored into the DB
List <Answer> answerList = (List <Answer>)HttpContext.Current.Session["answer"];
Answer answer = new Answer();
answer.QuestionID = AppSession.getCurrentQuestionID();
answer.MyAnswer = textBoxControl.QuestionTextBox.Text;
answerList.Add(answer);
HttpContext.Current.Session["answer"] = answerList;
}
RadioBoxControl radioBoxControl = (RadioBoxControl)questionPlaceHolder.FindControl(RADIOBOX_ID);
if (radioBoxControl != null)
{
foreach (ListItem item in radioBoxControl.QuestionRadioBoxList.Items)
{
if (item.Selected)
{
//store in session and break the loop coz only one radio can be selected.
List <Answer> answerList = (List <Answer>)HttpContext.Current.Session["answer"];
Answer answer = new Answer();
answer.QuestionID = AppSession.getCurrentQuestionID();
answer.MyAnswer = item.Value;
answerList.Add(answer);
HttpContext.Current.Session["answer"] = answerList;
string commandStr = "Select * From Options Where ID = " + item.Value;
SqlCommand command = new SqlCommand(commandStr, connection);
//run command, collect results into reader
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
if (reader["extraQuestionID"] != System.DBNull.Value)
{
extraQuestions.Add((int)reader["extraQuestionID"]);
}
}
break;
}
}
}
//check to see if it was a checkbox question
CheckBoxControl checkBoxControl = (CheckBoxControl)questionPlaceHolder.FindControl(CHECKBOX_ID);
if (checkBoxControl != null)
{
//loop through the checkboxes
foreach (ListItem item in checkBoxControl.QuestionCheckBoxList.Items)
{
if (item.Selected)
{
//TODO: store item.Value(which is the optionID) in session to store later in DB
//TODO: if selected option leads to extra questions, here is where to check that
// check this option against DB table and see if it has a foreign key to next question
// if it does, add it to extra questions
//item.Value
List <Answer> answerList = (List <Answer>)HttpContext.Current.Session["answer"];
Answer answer = new Answer();
answer.QuestionID = AppSession.getCurrentQuestionID();
answer.MyAnswer = item.Value;
answerList.Add(answer);
HttpContext.Current.Session["answer"] = answerList;
string commandStr = "Select * From Options Where ID = " + item.Value;
SqlCommand command = new SqlCommand(commandStr, connection);
//run command, collect results into reader
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
if (reader["extraQuestionID"] != System.DBNull.Value)
{
if (!extraQuestions.Contains((int)reader["extraQuestionID"]))
{
extraQuestions.Add((int)reader["extraQuestionID"]);
}
}
}
}
}
}
//TODO: Dont hard code extra questions like this, this is purely for example
/*
* if(currentQuestion == 1)
* {
* extraQuestions.Add(3);
* extraQuestions.Add(4);
* }
*/
//GO TO NEXT QUESTION
//===================
if (extraQuestions.Count > 0)
{
//use first question in list
int nextQuestion = extraQuestions[0];
//erase from list
extraQuestions.Remove(nextQuestion);
//store list of extra questions
AppSession.setExtraQuestionsList(extraQuestions);
//set currentQuestion in session to this value
AppSession.setCurrentQuestionID(nextQuestion);
//reload page
Response.Redirect("QuestionPage.aspx");
}
else
{
//use default navigation from 1 question to the next
SqlCommand command = new SqlCommand("SELECT * FROM Question WHERE ID = " + currentQuestion, connection);
SqlDataReader reader = command.ExecuteReader();
//read first row (dont care if multiple are returned)
if (reader.Read())
{
//get column index(ordinal) of nextQuestion
int nextQuestionColumnIndex = reader.GetOrdinal("nextQuestion");
//check if the value inside this column for this row of results is NULL or not
if (reader.IsDBNull(nextQuestionColumnIndex))
{
//its the end of the survey, go to thank you page or registration
//maybe store all answers in DB
// Console.WriteLine("all good yea!!!");
Response.Redirect("registration.aspx");
}
else
{
//if not null, use this value to help navigate to next question
AppSession.setCurrentQuestionID((int)reader["nextQuestion"]);
//reload the page so that pageLoad loads correct new question up
Response.Redirect("QuestionPage.aspx");
}
}
else
{
//cant find this question in the DB??!!??!
}
reader.Close();
}
}
}