public ActionResult MakeQuestionList2() { var project = from p in _db.Projects orderby p.Id descending select p; Project proj = project.First(); List <string> questions = new List <string>(); List <SubjectQuestions> squestions = new List <SubjectQuestions>();; string[] keys = Request.Form.AllKeys; SubjectQuestions currentSubject = null; QuestionList qlist = new QuestionList(); for (int i = 0; i < Request.Form.Count; i++) { string[] subject = keys[i].Split('-'); int subjectId = int.Parse(subject[0]); string question = Request.Form[i]; SubjectQuestions squestion = _db.SubjectQuestions.Find(subjectId); if (currentSubject == null) { currentSubject = new SubjectQuestions(squestion.Subject, squestion.Enabled) { QuestionList = qlist }; squestions.Add(currentSubject); } else if (!squestion.Subject.Equals(currentSubject.Subject)) { currentSubject = new SubjectQuestions(squestion.Subject, squestion.Enabled) { QuestionList = qlist }; squestions.Add(currentSubject); } Question question1 = new Question(question, proj, currentSubject) { QuestionList = qlist }; qlist.Questions.Add(question1); _db.Questions.Add(question1); } foreach (SubjectQuestions s in squestions) { _db.SubjectQuestions.Add(s); } _db.QuestionLists.Add(qlist); proj.Questionlist = qlist; _db.SaveChanges(); return(RedirectToAction("Index", "Main")); }
public ExaminationEntry(SubjectQuestions subjectQuestions, CharacterData characterData, CharacterQuestions characterQuestions, ReflectionQuestions reflectionQuestions, GameStats gameStats) { SubjectQuestions = subjectQuestions; CharacterData = characterData; CharacterQuestions = characterQuestions; ReflectionQuestions = reflectionQuestions; GameStats = gameStats; }
private void AddGrade(List <int> grades, int subjectQuestionID, int week, int projId, int studentNumber) { int totalGrade = 0; foreach (int g in grades) { totalGrade += g; } int averageGrade = totalGrade / grades.Count(); int currentUserNr = ((OAuth.CurrentUser)Session["currentUser"]).ID; //Pulling data out of the database, any information left stored is outdated and will be duplicated otherwise. var data1 = from sq in _db.SubjectQuestions where sq.Id == subjectQuestionID select sq; SubjectQuestions subjectQuestion = data1.ToList().First(); var data2 = from rd in _db.ReviewDates where rd.Project.Id == projId && rd.Weeknr == week select rd; ReviewDates reviewDate = data2.ToList().First(); var data3 = from p in _db.Projects where p.Id == projId select p; Project project = data3.ToList().First(); StudentGrades studentGrade = new StudentGrades { Project = project, Grade = averageGrade, SubjectQuestion = subjectQuestion, Student = _db.SearchStudentByStudentNumber(studentNumber), Reviewer = _db.SearchStudentByStudentNumber(currentUserNr), ReviewDate = reviewDate }; _db.StudentGrades.Add(studentGrade); }
private bool SendAnswers(TMP_Dropdown[] answerDropdowns, Type questionType) { if (!DropdownsAreValid(answerDropdowns)) { return(false); } object answers = null; if (questionType == typeof(SubjectQuestions)) { answers = new SubjectQuestions ( gender: _subjectQuestions[0].captionText.text, knowsExperimentPurpose: _subjectQuestions[1].value == 1 ); } else if (questionType == typeof(CharacterQuestions)) { answers = new CharacterQuestions ( initialCharacterSatisfaction: _characterQuestions[0].captionText.text, optionAmount: _characterQuestions[1].captionText.text, enjoyedCustomization: _characterQuestions[2].value == 1 ); } else if (questionType == typeof(ReflectionQuestions)) { answers = new ReflectionQuestions ( entertainmentValue: int.Parse(_reflectionQuestions[0].captionText.text), pleasedWithPerformance: _reflectionQuestions[1].captionText.text, finalCharacterSatisfaction: _reflectionQuestions[2].captionText.text ); } DataCollector.Instance.SetData(answers); return(true); }
protected override void Seed(BaroDB context) { //Stub teachers just because Teacher t1 = new Teacher(12, "Marieke", "Versteijlen", TeacherAccess.tutor); Teacher t2 = new Teacher(13, "Jos", "Weert, van", TeacherAccess.mentor); Teacher t3 = new Teacher(14, "Ger", "Saris", TeacherAccess.mentor); Teacher t4 = new Teacher(15, "Angelique", "Boogaard, van den", TeacherAccess.tutor); Teacher t5 = new Teacher(16, "Bob", "Bus", TeacherAccess.mentor); //Everybody admin! Teacher t6 = new Teacher(2053429, "Jeroen", "Broekhuizen", TeacherAccess.admin); Teacher t7 = new Teacher(2059821, "Alexander", "Doorn, van", TeacherAccess.admin); Teacher t8 = new Teacher(2052712, "Benny", "Bijl", TeacherAccess.admin); Teacher t9 = new Teacher(2052387, "Bryan", "Schreuder", TeacherAccess.admin); Teacher t10 = new Teacher(2059370, "Joep", "Broek, van den", TeacherAccess.admin); Teacher t11 = new Teacher(2062810, "Luuk", "Bruin, de", TeacherAccess.admin); Teacher t12 = new Teacher(2063273, "Solo", "Schekermans", TeacherAccess.admin); Teacher t13 = new Teacher(2059071, "Thomas", "Voogt", TeacherAccess.admin); #region questions QuestionList ql1 = new QuestionList("Standaard vragenlijst"); SubjectQuestions sq1 = new SubjectQuestions("Kennis van/over en vaardigheden", true); SubjectQuestions sq2 = new SubjectQuestions("Inzet / motivatie", true); SubjectQuestions sq3 = new SubjectQuestions("Inzicht eigen functioneren", true); SubjectQuestions sq4 = new SubjectQuestions("Leiding geven (n.v.t)", false); SubjectQuestions sq5 = new SubjectQuestions("Samenwerken", true); SubjectQuestions sq6 = new SubjectQuestions("Schriftelijk communiceren", true); SubjectQuestions sq7 = new SubjectQuestions("Mondeling communiceren", true); SubjectQuestions sq8 = new SubjectQuestions("Projectmatig werken", true); Question q11 = new Question("Testplan"); Question q12 = new Question("Technisch Ontwerp Rapport"); Question q13 = new Question("Applicatie bouwen"); Question q14 = new Question("Testen"); Question q15 = new Question("Eindoplevering applicatie"); Question q21 = new Question("Meedoen"); Question q22 = new Question("Afspraken nakomen"); Question q23 = new Question("Op tijd zijn"); Question q31 = new Question("Kritisch op eigen werk"); Question q32 = new Question("Eigen sterktes en zwaktes kennen"); Question q33 = new Question("Besluiten nemen"); Question q34 = new Question("Omgaan met stress"); Question q35 = new Question("Assertief zijn"); Question q41 = new Question("Niet van toepassing"); Question q51 = new Question("Anderen helpen"); Question q52 = new Question("Feedback geven"); Question q53 = new Question("Feedback ontvangen"); Question q54 = new Question("Goede werksfeer in stand houden"); Question q55 = new Question("Informatie, ideen en ervaringen delen"); Question q56 = new Question("Flexibel zijn"); Question q61 = new Question("Notulen"); Question q62 = new Question("Testplan"); Question q63 = new Question("Technisch Ontwerp Rapport"); Question q64 = new Question("Eindoplevering"); Question q71 = new Question("Inzicht hebben in non-verbale communicatie"); Question q72 = new Question("Meedoen tijdens bijeenkomsten"); Question q73 = new Question("Communicatie aanpassen aan de situatie"); Question q74 = new Question("Omgaan met conflicten"); Question q81 = new Question("Overzicht van taken "); Question q82 = new Question("Analyses maken"); Question q83 = new Question("Oplossingen kiezen"); ql1.Subjects.Add(sq1); ql1.Subjects.Add(sq2); ql1.Subjects.Add(sq3); ql1.Subjects.Add(sq4); ql1.Subjects.Add(sq5); ql1.Subjects.Add(sq6); ql1.Subjects.Add(sq7); ql1.Subjects.Add(sq8); sq1.Questions.Add(q11); sq1.Questions.Add(q12); sq1.Questions.Add(q13); sq1.Questions.Add(q14); sq1.Questions.Add(q15); sq2.Questions.Add(q21); sq2.Questions.Add(q22); sq2.Questions.Add(q23); sq3.Questions.Add(q31); sq3.Questions.Add(q32); sq3.Questions.Add(q33); sq3.Questions.Add(q34); sq3.Questions.Add(q35); sq4.Questions.Add(q41); sq5.Questions.Add(q51); sq5.Questions.Add(q52); sq5.Questions.Add(q53); sq5.Questions.Add(q54); sq5.Questions.Add(q55); sq5.Questions.Add(q56); sq6.Questions.Add(q61); sq6.Questions.Add(q62); sq6.Questions.Add(q63); sq6.Questions.Add(q64); sq7.Questions.Add(q71); sq7.Questions.Add(q72); sq7.Questions.Add(q73); sq7.Questions.Add(q74); sq8.Questions.Add(q81); sq8.Questions.Add(q82); sq8.Questions.Add(q83); #endregion context.QuestionLists.AddOrUpdate(ql1); context.Teachers.AddOrUpdate(new Teacher[] { t1, t2, t3, t4, t5, t6, t7, t8, t9, t10, t11, t12, t13 }); context.SaveChanges(); }