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();
}
