public async Task FindWhere_FindAnswersByExpression_ShouldFindTheCorrectQuestions()
{
var poll = await DataAccessHelpers.AddPollAsync(_pollRepo, "Event 2", "Short description", DateTimeOffset.Now.AddDays(9.0));
var qType = await DataAccessHelpers.AddQuestionTypeAsync(_questionTypeRepo, "Simple");
var question = await DataAccessHelpers.AddQuestionAsync(_questionRepo, "Are you mad?", qType, poll);
var afirmativeAnswer = new Answer {
Name = "Yes",
Question = question
};
var negativeAnswer = new Answer {
Name = "No",
Question = question
};
afirmativeAnswer = await _answerRepo.AddAsync(afirmativeAnswer);
negativeAnswer = await _answerRepo.AddAsync(negativeAnswer);
var answersFound = await _answerRepo.FindWhere(answer => answer.Question.Id == question.Id)
.ToListAsync();
Assert.That(answersFound.Count, Is.EqualTo(2));
}
public async Task RemoveAsync_RemoveAnswerFromQuestion_ShouldRemoveIt()
{
var poll = await DataAccessHelpers.AddPollAsync(_pollRepo, "Event 14", "Short description", DateTimeOffset.Now.AddDays(9.0));
var qType = await DataAccessHelpers.AddQuestionTypeAsync(_questionTypeRepo, "Simple");
var question = await DataAccessHelpers.AddQuestionAsync(_questionRepo, "Where do you want to go?", qType, poll);
var answer1 = new Answer {
Name = "New York?",
Question = question
};
var answer2 = new Answer {
Name = "Chicago",
Question = question
};
answer1 = await _answerRepo.AddAsync(answer1);
answer2 = await _answerRepo.AddAsync(answer2);
await _answerRepo.RemoveAsync(answer2, answer2.Id);
var result = await _answerRepo.FindWhere(answer => answer.Question.Id == question.Id).ToListAsync();
Assert.That(result.Count, Is.EqualTo(1));
}
public async Task AddAsync_AddNewQuestionToPoll_ShouldInsertQuestionIntoDatabase()
{
var poll = await DataAccessHelpers.AddPollAsync(_pollRepo, "Event 1", "Short description", DateTimeOffset.Now.AddDays(5.0));
var qType = await DataAccessHelpers.AddQuestionTypeAsync(_questionType, "Simple");
var question = new Question {
Name = "Do you want to hang out this afternoon?",
Type = qType,
Poll = poll
};
var insertedQuestion = await _questionRepo.AddAsync(question);
Assert.That(insertedQuestion.Name, Is.EqualTo(question.Name));
}
public async Task AddAsync_AddAnswerToQuestion_ShouldAddQuestions()
{
var poll = await DataAccessHelpers.AddPollAsync(_pollRepo, "Event 1", "Short description", DateTimeOffset.Now.AddDays(5.0));
var qType = await DataAccessHelpers.AddQuestionTypeAsync(_questionTypeRepo, "Simple");
var question = await DataAccessHelpers.AddQuestionAsync(_questionRepo, "Do you want to sleep?", qType, poll);
var afirmativeAnswer = new Answer {
Name = "Yes",
Question = question
};
var result = await _answerRepo.AddAsync(afirmativeAnswer);
Assert.That(result, Is.Not.Null);
}
public async Task FindByIdAsync_FindById_ShouldReturnTheCorrectItem()
{
var poll = await DataAccessHelpers.AddPollAsync(_pollRepo, "Summer event 2020", "Short description", DateTimeOffset.Now.AddDays(6.0));
var qType = await DataAccessHelpers.AddQuestionTypeAsync(_questionType, "Simple");
var questionOne = new Question {
Name = "What do you want to do on Saint John the Baptist Day?",
Type = qType,
Poll = poll
};
var questionAdded = await _questionRepo.AddAsync(questionOne);
var questionFound = await _questionRepo.GetByIdAsync(questionAdded.Id);
Assert.That(questionFound, Is.Not.Null);
}
public async Task FindByAsync_FindItemByExpression_ShouldReturnTheCorrectItem()
{
var poll = await DataAccessHelpers.AddPollAsync(_pollRepo, "Event 2", "Short description", DateTimeOffset.Now.AddDays(6.0));
var qType = await DataAccessHelpers.AddQuestionTypeAsync(_questionType, "Simple");
var question = new Question {
Name = "Do you want to come to my pool tonight?",
Type = qType,
Poll = poll
};
var insertedQuestion = await _questionRepo.AddAsync(question);
var questionFound = await _questionRepo.FindByAsync(q => q.Id == insertedQuestion.Id);
Assert.That(questionFound.Name, Is.EqualTo(insertedQuestion.Name));
}
public async Task FindByAsync_FindItemByExpression_ShouldReturnTheCorrectItem()
{
var poll = await DataAccessHelpers.AddPollAsync(_pollRepo, "Event 1", "Short description", DateTimeOffset.Now.AddDays(5.0));
var qType = await DataAccessHelpers.AddQuestionTypeAsync(_questionTypeRepo, "Simple");
var question = await DataAccessHelpers.AddQuestionAsync(_questionRepo, "Do you want to eat?", qType, poll);
var negativeAnswer = new Answer {
Name = "No",
Question = question
};
var answerResult = await _answerRepo.AddAsync(negativeAnswer);
var answerFound = await _answerRepo.FindByAsync(answer => answer.Id == answerResult.Id);
Assert.That(answerFound.Name, Is.EqualTo("No"));
}
public async Task UpdateAync_UpdateQuestion_ShouldUpdateIt()
{
var poll = await DataAccessHelpers.AddPollAsync(_pollRepo, "Summer event 2022", "Short description", DateTimeOffset.Now.AddDays(6.0));
var qType = await DataAccessHelpers.AddQuestionTypeAsync(_questionType, "Simple");
var questionOne = new Question {
Name = "What do you want to do on Saint John the Baptist Day?",
Type = qType,
Poll = poll
};
var questionAdded = await _questionRepo.AddAsync(questionOne);
questionAdded.Name = "Fake Name";
var questionResult = await _questionRepo.UpdateAsync(questionAdded, questionAdded.Id);
Assert.That(questionResult.Name, Is.EqualTo("Fake Name"));
}
public async Task FindByIdAsync_FindById_ShouldReturnTheCorrectItem()
{
var poll = await DataAccessHelpers.AddPollAsync(_pollRepo, "Event 12", "Short description", DateTimeOffset.Now.AddDays(9.0));
var qType = await DataAccessHelpers.AddQuestionTypeAsync(_questionTypeRepo, "Simple");
var question = await DataAccessHelpers.AddQuestionAsync(_questionRepo, "Are you serious?", qType, poll);
var answer = new Answer {
Name = "WTF?",
Question = question
};
answer = await _answerRepo.AddAsync(answer);
var answerFound = await _answerRepo.GetByIdAsync(answer.Id);
Assert.That(answer, Is.Not.Null);
}
public async Task UpdateAync_UpdateQuestion_ShouldUpdateIt()
{
var poll = await DataAccessHelpers.AddPollAsync(_pollRepo, "Event 24", "Short description", DateTimeOffset.Now.AddDays(9.0));
var qType = await DataAccessHelpers.AddQuestionTypeAsync(_questionTypeRepo, "Simple");
var question = await DataAccessHelpers.AddQuestionAsync(_questionRepo, "Where do you want to go?", qType, poll);
var answer1 = new Answer {
Name = "New York?",
Question = question
};
answer1 = await _answerRepo.AddAsync(answer1);
answer1.Name = "South Portland Maine";
var result = await _answerRepo.UpdateAsync(answer1, answer1.Id);
Assert.That(result.Name, Is.EqualTo("South Portland Maine"));
}
public async Task FindWhere_FindQuestionsByExpression_ShouldFindTheCorrectQuestions()
{
var poll = await DataAccessHelpers.AddPollAsync(_pollRepo, "Summer event 2019", "Short description", DateTimeOffset.Now.AddDays(6.0));
var qType = await DataAccessHelpers.AddQuestionTypeAsync(_questionType, "Simple");
var questionOne = new Question {
Name = "What do you want to do on Saint John the Baptist Day?",
Type = qType,
Poll = poll
};
var questionTwo = new Question {
Name = "What do you want to do for your birthday?",
Type = qType,
Poll = poll
};
await _questionRepo.AddAsync(questionOne);
await _questionRepo.AddAsync(questionTwo);
var questionsFound = await _questionRepo.FindWhere(q => q.Poll.Id == poll.Id).ToListAsync();
Assert.That(questionsFound.Count, Is.GreaterThan(1));
}
