public void TestInit() { surveydb = Database.GetConnection(); surveyDal = new SurveyDAL(); userDAL = new UserDAL(); questionDAL = new QuestionDAL(); user = new users(); user.User_name = userName; user.User_password = password; HelperDAL.AddUser(user); survey = new surveys(); survey.Name = surveyName; //survey.users = user; survey.User_name = userName; SurveyCode = HelperDAL.GenerateRandomSurveyCode(); survey.Survey_code = SurveyCode; HelperDAL.AddSurvey(survey); question = new questions(); question.Question_name = questionName; question.Surveys_id = survey.Id; question.Input_type_id = 2; this.questionDAL.AddQuestion(question); this.optionChoicesDAL = new OptionChoicesDAL(); this.optionChoice = new option_choices(); this.optionChoice.Question_id = question.Id; this.optionChoice.Option_choices_name = OptionChoiceName; }
public static void AddOptionChoicesToDataBase(option_choices optionChoice) { for (int i = 1; i <= 3; i++) { optionChoice.Option_choices_name += i; optionChoicesDAL.AddOptionChoice(optionChoice); } }
public void UpdatingOptionChoicesNameShouldBeSuccessful() { optionChoicesDAL.AddOptionChoice(optionChoice); optionChoicesDAL.UpdateOptionsChoice(optionChoice, NewOptionChoiceName); option_choices optionChoices = this.surveydb.option_choices.Where(x => x.Id == optionChoice.Id).FirstOrDefault(); optionChoicesDAL.DeleteOptionChoice(optionChoice); Assert.That(optionChoices.Option_choices_name, Is.EqualTo(NewOptionChoiceName)); }
/// <summary> /// Take all the questions created by the user and add the survey to the database /// </summary> private void buttonCreateSurvey_Click(object sender, EventArgs e) { //Check if the previous question or title has the correct inputs if (CheckInputs()) { return; } //If there are 0 questions the survey won't be created if (question_text_counter + question_option_counter == 0) { MessageBox.Show("Please create atleast one question."); return; } //Create the survey and add it to the database CreateSurvey(); b.AddSurvey(survey); //For each question, the 'for'cycle adds it to the database for (int i = 1; i < question_text_counter + question_option_counter + 1; i++) { questions question = new questions(); TextBox title = panelCreateSurvey.Controls.Find(i + "title", false).First() as TextBox; //If the question is a text answer, add it to the database if (title.Tag.ToString() == "text") { question.Surveys_id = b.GetSurveyIdBySurveyCode(survey.Survey_code); question.Question_name = title.Text; question.Input_type_id = 1; b.AddQuestion(question); } //If the question is a option choice, add it to the database along with its options else { question.Surveys_id = b.GetSurveyIdBySurveyCode(survey.Survey_code); question.Question_name = title.Text; question.Input_type_id = 2; b.AddQuestion(question); //Add the options to the database for (int j = 1; j < 4; j++) { option_choices option = new option_choices(); TextBox optionChoice = panelCreateSurvey.Controls.Find(i + "option" + j, false).First() as TextBox; option.Question_id = question.Id; option.Option_choices_name = optionChoice.Text; b.AddOptionChoice(option); } } } MessageBox.Show("Survey succesfully created!"); //Clear the panel ClearPanelCreateSurvey(); }
public void UpdateOptionChoiceName(option_choices option, string newOptionChoiceName) { optionChoiceDAL.UpdateOptionsChoice(option, newOptionChoiceName); }
//OptionChoicesDAL public void AddOptionChoice(option_choices option) { optionChoiceDAL.AddOptionChoice(option); }
public static void DeleteOptionChoice(option_choices optionChoices) { optionChoicesDAL.DeleteOptionChoice(optionChoices); }
public void UpdateOptionsChoice(option_choices optionChoice, string newOptionChoiceName) { optionChoice.Option_choices_name = newOptionChoiceName; surveyDBcontext.SaveChanges(); }
public void DeleteOptionChoice(option_choices option) { surveyDBcontext.option_choices.Attach(option); surveyDBcontext.option_choices.Remove(option); surveyDBcontext.SaveChanges(); }
public void AddOptionChoice(option_choices option) { surveyDBcontext.option_choices.Add(option); surveyDBcontext.SaveChanges(); }