Ejemplo n.º 1
0
        public CompletedSurvey BuildCompletedSurvey(string answersJson, int studentID)
        {
            CompletedSurvey completedSurvey = new CompletedSurvey();

            JObject jObject = JObject.Parse(answersJson);
            JToken  jModule = jObject["ModuleID"];

            completedSurvey.ModuleID      = (string)jObject["ModuleID"];
            completedSurvey.DateCompleted = DateTime.Now;
            completedSurvey.StudentID     = studentID;

            JToken[]      jTokenAnswers = jObject["Answers"].ToArray();
            List <Answer> answers       = new List <Answer>();

            foreach (JToken jAnswer in jTokenAnswers)
            {
                Answer answer = new Answer();
                answer.QuestionID = Convert.ToDouble(jAnswer["QuestionID"]);
                answer.Rating     = Convert.ToInt32(jAnswer["Rating"]);
                answer.Comment    = Convert.ToString(jAnswer["Comment"]);
                answers.Add(answer);
            }
            completedSurvey.Answers = answers;

            return(completedSurvey);
        }
Ejemplo n.º 2
0
        public void SaveAnswers(List <Answer> answers, string userID)
        {
            var survey    = GetActiveSurvey(userID);
            var questions = survey.Questions.ToList();

            for (int i = 0; i < questions.Count; i++)
            {
                answers[i].QuestionId = questions[i].Id;
            }

            var completedSurvey = new CompletedSurvey()
            {
                Answers        = answers,
                DateOfComplete = DateTime.Now,
                SurveyId       = survey.Id
            };

            using (ApplicationDbContext db = new ApplicationDbContext())
            {
                var user = db.Students.FirstOrDefault(x => x.Id == userID);

                if (user != null)
                {
                    user.CompletedSurveys.Add(completedSurvey);

                    user.SurveyIsStarted = true;
                    db.SaveChanges();
                }
            }
        }
Ejemplo n.º 3
0
        public IHttpActionResult Get(string content)
        {
            AuthenticatedUser user = authenticate.confirmToken();

            if (user.UserID != 0)
            {
                ObjectBuilder   builder         = new ObjectBuilder();
                SurveyQueries   query           = new SurveyQueries();
                CompletedSurvey completedSurvey = builder.BuildCompletedSurvey(content, user.UserID);
                query.PostAnswers(completedSurvey);

                return(Ok("success"));
            }
            else
            {
                return(Unauthorized());
            }
        }
Ejemplo n.º 4
0
        public void PostAnswers(CompletedSurvey completedSurvey)
        {
            HttpContext context           = HttpContext.Current;
            int         completedSurveyID = PostCompletedSurvey(completedSurvey.ModuleID, completedSurvey.StudentID);
            string      valueString       = "";

            foreach (Answer answer in completedSurvey.Answers)
            {
                string addValue = string.Format("({0}, {1}, {2}, '{3}')", completedSurveyID, answer.QuestionID, answer.Rating, answer.Comment);
                if (!string.IsNullOrEmpty(valueString))
                {
                    valueString += ",";
                }
                valueString += addValue;
            }
            if (!string.IsNullOrEmpty(valueString))
            {
                con.Open();
                SqlCommand cmd = new SqlCommand(string.Format("INSERT INTO Answer(CompletedSurveyID, QuestionID, Rating, Comment) " +
                                                              "VALUES {0}", valueString), con);
                SqlDataReader reader = cmd.ExecuteReader();
                con.Close();
            }
        }
Ejemplo n.º 5
0
 public CompletedQuestion(Question question, string answer, CompletedSurvey completedSurvey = null)
 {
     Question        = question;
     Answer          = answer;
     CompletedSurvey = completedSurvey;
 }
Ejemplo n.º 6
0
 public void Add(CompletedSurvey survey)
 {
     _context.CompletedSurveys.Add(survey);
 }