Ejemplo n.º 1
0
        protected void SubmitButtonClick(object sender, EventArgs e)
        {
            List <questionData> storedAnswers        = new List <questionData>();
            List <String>       followUpQuestionList = new List <string>();

            if (questionType == 1) //text input
            {
                TextQuestionController ch = (TextQuestionController)QuestionPlaceholder.FindControl("TextQuestionController");

                int currentQuestion = (int)HttpContext.Current.Session["questionNumber"];

                if (HttpContext.Current.Session["userAnswers"] != null) //if there are saved answers from previous q's
                {
                    storedAnswers = (List <questionData>)HttpContext.Current.Session["userAnswers"];
                }

                if (ch != null)
                {
                    String textAnswer = ch.QuestionTextBox.Text;

                    questionData saveQuestion = new questionData //instantiate new questionData class to save as listItem
                    {
                        q_Id = currentQuestion.ToString(),
                        a_Id = "",
                        text = textAnswer
                    };

                    storedAnswers.Add(saveQuestion);
                    HttpContext.Current.Session["userAnswers"] = storedAnswers;
                }
            }

            else if (questionType == 2) //checkbox
            {
                CheckBoxQuestionController ch = (CheckBoxQuestionController)QuestionPlaceholder.FindControl("checkBoxQuestionController");
                string value;
                int    currentQuestion = (int)HttpContext.Current.Session["questionNumber"];

                if (HttpContext.Current.Session["userAnswers"] != null) //if there are saved answers from previous q's
                {
                    storedAnswers = (List <questionData>)HttpContext.Current.Session["userAnswers"];
                }
                if (HttpContext.Current.Session["followUpQuestions"] != null) //if there's already follow up questions ready to go
                {
                    followUpQuestionList = (List <string>)HttpContext.Current.Session["followUpQuestions"];
                }

                if (ch != null)
                {
                    foreach (ListItem chk in ch.QuestionCheckBoxList.Items)
                    {
                        if (chk.Selected)                                                                             //if checkbox was selected by user
                        {
                            value = chk.Value;                                                                        //gets the a_Id

                            if (HttpContext.Current.Session[chk.Value] != null)                                       //if there's a follow up question associated with this answer
                            {
                                if (followUpQuestionList.Count > 0)                                                   //if there's already a queue of followUps waiting
                                {
                                    if (followUpQuestionList[0] != HttpContext.Current.Session[chk.Value].ToString()) //if the followUpQuestion isn't already queued (don't duplicate question)
                                    {
                                        followUpQuestionList.Add(HttpContext.Current.Session[chk.Value].ToString());
                                    }
                                }
                                else
                                {
                                    followUpQuestionList.Add(HttpContext.Current.Session[chk.Value].ToString()); //add new followUp
                                }
                            }

                            questionData saveQuestion = new questionData //instantiate new questionData class to save as listItem
                            {
                                q_Id = currentQuestion.ToString(),
                                a_Id = chk.Value,
                                text = ""
                            };

                            storedAnswers.Add(saveQuestion);
                        }
                    }
                    HttpContext.Current.Session["userAnswers"]       = storedAnswers;        //append stored answers session
                    HttpContext.Current.Session["followUpQuestions"] = followUpQuestionList; //append followUp list
                }
            }

            else if (questionType == 3) //dropdown
            {
                DropdownQuestionController ch = (DropdownQuestionController)QuestionPlaceholder.FindControl("dropdownQuestionController");

                int currentQuestion = (int)HttpContext.Current.Session["questionNumber"];

                if (HttpContext.Current.Session["userAnswers"] != null) //if there are saved answers from previous q's
                {
                    storedAnswers = (List <questionData>)HttpContext.Current.Session["userAnswers"];
                }

                if (ch != null)
                {
                    foreach (ListItem chk in ch.DropdownQuestionList.Items)
                    {
                        if (chk.Selected)
                        {
                            string value = chk.Value; //gets the answer_Id

                            questionData saveQuestion = new questionData
                            {
                                q_Id = currentQuestion.ToString(),
                                a_Id = chk.Value,
                                text = ""
                            };
                            storedAnswers.Add(saveQuestion); //push onto saved answers list
                        }
                    }
                    HttpContext.Current.Session["userAnswers"] = storedAnswers;
                }
            }

            else if (questionType == 4) //radio
            {
                RadioQuestionController ch = (RadioQuestionController)QuestionPlaceholder.FindControl("radioQuestionController");

                string value;
                int    currentQuestion = (int)HttpContext.Current.Session["questionNumber"];

                if (HttpContext.Current.Session["userAnswers"] != null) //if there are saved answers from previous q's
                {
                    storedAnswers = (List <questionData>)HttpContext.Current.Session["userAnswers"];
                }

                if (ch != null)
                {
                    foreach (ListItem chk in ch.RadioQuestionList.Items)
                    {
                        if (chk.Selected)
                        {
                            value = chk.Value; //gets the a_Id

                            questionData saveQuestion = new questionData();
                            saveQuestion.q_Id = currentQuestion.ToString();
                            saveQuestion.a_Id = chk.Value;
                            saveQuestion.text = "";

                            storedAnswers.Add(saveQuestion); //save users answer
                        }
                    }
                    HttpContext.Current.Session["userAnswers"] = storedAnswers; //append saved answers list in session
                }
            }


            if ((followUpQuestionList.Count == 0) && ((int)HttpContext.Current.Session["questionNumberTemp"] == 0)) //if no followUps and no next question - end of survey
            {
                SqlConnection connection = ConnectToDatabase();
                string        ipAddress  = GetIPAddress();

                //create user and get u_Id
                string cmd = "INSERT INTO userTable (ipAddress) VALUES ('" + ipAddress + "');SELECT CAST(scope_identity() AS int)";

                SqlCommand insertUser = new SqlCommand(cmd, connection);

                int newUser_Id = (int)insertUser.ExecuteScalar(); //get newly created u_Id

                AppSession.setResponderUserId(newUser_Id);        //store in session

                //save answers from survey
                List <questionData> getAnswers = (List <questionData>)HttpContext.Current.Session["userAnswers"];

                for (int i = 0; i < getAnswers.Count; i++)
                {
                    string qID  = getAnswers[i].q_Id;
                    string aID  = getAnswers[i].a_Id;
                    string text = getAnswers[i].text;
                    //save answer to each question
                    try
                    {
                        string     s        = "INSERT INTO userAnswersTable (u_Id, a_Id, answerText) VALUES ('" + newUser_Id + "','" + aID + "'," + "'" + text + "')";
                        SqlCommand saveData = new SqlCommand("INSERT INTO userAnswersTable (u_Id, a_Id, answerText) VALUES ('" + newUser_Id + "','" + aID + "'," + "'" + text + "')", connection);

                        //run query
                        saveData.ExecuteNonQuery();
                    }
                    catch (Exception err)
                    {
                        Console.Write("Database/network error occurred: " + err);
                    }
                }
                connection.Close();
                Response.Redirect("Register.aspx"); //redirect to register page
            }

            else if (followUpQuestionList.Count == 0)                                      //next normal question
            {
                int nextQuestion = (int)HttpContext.Current.Session["questionNumberTemp"]; //get next question that was set when question was generated
                HttpContext.Current.Session["questionNumber"]     = nextQuestion;
                HttpContext.Current.Session["questionNumberTemp"] = 0;

                Response.Redirect("Question.aspx");
            }

            else //get queued followUps
            {
                List <string> followUpList = (List <string>)HttpContext.Current.Session["followUpQuestions"];
                if (followUpList.Count > 0)
                {
                    int nextQuestion = Convert.ToInt32(followUpList[0]);             //set next question as the first queued follow up
                    HttpContext.Current.Session["questionNumber"] = nextQuestion;    //store it in the session
                    followUpList.RemoveAt(0);                                        //remove this follow up from the queue
                    HttpContext.Current.Session["followUpQuestions"] = followUpList; //append the session-stored followUp list
                }
                Response.Redirect("Question.aspx");
            }
        }
Ejemplo n.º 2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (AppSession.getSurveyCompletedStatus())
            {
                Response.Redirect("~/SurveyCompleted.aspx");
            }

            int           currentQuestion = GetCurrentQuestionNumber();
            SqlConnection connection      = ConnectToDatabase();
            int           nextQuestion    = 0;

            //load question from database
            SqlCommand getQuestion = new SqlCommand("SELECT * FROM questionTable WHERE questionTable.q_Id = " + currentQuestion, connection);

            //run query
            SqlDataReader reader = getQuestion.ExecuteReader();

            while (reader.Read())
            {
                //read questions returned from query
                string questionText = reader["questionText"].ToString();
                questionType = Convert.ToInt32(reader["questionType"]);
                List <String> checkForFollowUps = new List <string>();
                checkForFollowUps = (List <string>)HttpContext.Current.Session["followUpQuestions"];


                if (reader["nextQuestion_Id"] != DBNull.Value) //gets next question if it exists
                {
                    nextQuestion = Convert.ToInt32(reader["nextQuestion_Id"]);
                    HttpContext.Current.Session["questionNumberTemp"] = nextQuestion;
                }
                else //no more standard questions left
                {
                    HttpContext.Current.Session["surveyProgress"] = 1;
                }

                //load the appropriate questionController
                if (questionType == 1)     //textbox
                {
                    //load TexQuestionController
                    TextQuestionController textController = (TextQuestionController)LoadControl("~/TextQuestionController.ascx");

                    //set the ID to reference to it later
                    textController.ID = "TextQuestionController";

                    //Insert the active question into label
                    textController.QuestionLabel.Text = questionText;

                    //Insert controller to the placeholder
                    QuestionPlaceholder.Controls.Add(textController);
                }

                else if (questionType == 2)     //checkbox
                {
                    CheckBoxQuestionController checkBoxController = (CheckBoxQuestionController)LoadControl("~/CheckBoxQuestionController.ascx");

                    checkBoxController.ID = "checkBoxQuestionController";
                    checkBoxController.QuestionLabel.Text = questionText;
                    string followUpID;

                    SqlCommand optionCommand = new SqlCommand("SELECT * FROM answerOptionTable WHERE answerOptionTable.q_Id = " + currentQuestion, connection);

                    //run command
                    try
                    {
                        SqlDataReader optionReader = optionCommand.ExecuteReader();

                        //loop through all results
                        while (optionReader.Read())
                        {
                            ListItem item = new ListItem(optionReader["answerText"].ToString(), optionReader["a_Id"].ToString());

                            if (optionReader["fq_Id"] != DBNull.Value)
                            {
                                string currentA_Id = optionReader["a_Id"].ToString();
                                followUpID = optionReader["fq_Id"].ToString();
                                HttpContext.Current.Session[currentA_Id] = followUpID;     //filthy workaround to store fq_Id's by its answer_Id
                            }

                            int currentAnswerId = Convert.ToInt32(optionReader["a_Id"]);

                            checkBoxController.QuestionCheckBoxList.Items.Add(item); //add answer to list
                        }
                        QuestionPlaceholder.Controls.Add(checkBoxController);        //add all answers to placeholder
                    }
                    catch (Exception err)
                    {
                        Console.Write("Database/connection error" + err);
                    }
                }

                else if (questionType == 3)     // dropdown
                {
                    DropdownQuestionController dropdownController = (DropdownQuestionController)LoadControl("~/DropdownQuestionController.ascx");

                    dropdownController.ID = "dropdownQuestionController";
                    dropdownController.QuestionLabel.Text = questionText;

                    SqlCommand optionCommand = new SqlCommand("SELECT * FROM answerOptionTable WHERE answerOptionTable.q_Id = " + currentQuestion, connection);

                    //run command
                    try
                    {
                        SqlDataReader optionReader = optionCommand.ExecuteReader();

                        //loop through all results
                        while (optionReader.Read())
                        {
                            ListItem item = new ListItem(optionReader["answerText"].ToString(), optionReader["a_Id"].ToString());
                            dropdownController.DropdownQuestionList.Items.Add(item);     //add answer to list
                        }

                        //add all retrieved answers to controller
                        QuestionPlaceholder.Controls.Add(dropdownController);
                    }
                    catch (Exception err)
                    {
                        Console.Write("Database/connection error" + err);
                    }
                }

                else if (questionType == 4)     //radio
                {
                    RadioQuestionController radioController = (RadioQuestionController)LoadControl("~/RadioQuestionController.ascx");

                    radioController.ID = "radioQuestionController";
                    radioController.QuestionLabel.Text = questionText;

                    SqlCommand optionCommand = new SqlCommand("SELECT * FROM answerOptionTable WHERE answerOptionTable.q_Id = " + currentQuestion, connection);

                    //run command
                    try
                    {
                        SqlDataReader optionReader = optionCommand.ExecuteReader();

                        //loop through all results
                        while (optionReader.Read())
                        {
                            ListItem item = new ListItem(optionReader["answerText"].ToString(), optionReader["a_Id"].ToString());
                            radioController.RadioQuestionList.Items.Add(item);
                        }
                        QuestionPlaceholder.Controls.Add(radioController);
                    }
                    catch (Exception err)
                    {
                        Console.Write("Database/connection error: " + err);
                    }
                }
            }
            connection.Close();
        }