public void TestSurveyData()
{
Assert.IsNull(GetTestSurveyFromDb());
Survey survey = CreateTestSurvey();
using (var db = new TestSurveyContext())
{
db.SaveSurvey(survey);
db.SaveChanges();
}
using (var db = new TestSurveyContext())
{
Survey[] res = db.getSurveysFor("TEST");
Assert.IsTrue(res.Length == 1);
}
Survey fromDb;
using (var db = new TestSurveyContext())
{
fromDb = db.Surveys.Where(s => s.Question == Title).FirstOrDefault <Survey>();
Assert.IsNotNull(fromDb);
Assert.IsTrue(fromDb.Question == Title);
Assert.IsTrue(fromDb.Answers.Count == 3);
Assert.IsTrue(fromDb.Answers.Where <Answer>(a => a.AnswerText == "Answer 2").Count() == 1);
db.DeleteSurvey(fromDb);
db.SaveChanges();
}
Assert.IsNull(GetTestSurveyFromDb());
}
private Survey GetTestSurveyFromDb()
{
// Check that test question is not
using (var db = new TestSurveyContext())
{
return(db.Surveys.Where(s => s.Question == Title).FirstOrDefault <Survey>());
}
}
public void TestUserGenSave()
{
User u = User.GenerateNewUser();
using (var db = new TestSurveyContext())
{
db.SaveUser(u);
db.SaveChanges();
}
}
public void TestSavePanic()
{
User u = User.GenerateNewUser();
Panic p = new Panic("testCourse", u);
Panic p2 = new Panic("testCourse", u);
using (var db = new TestSurveyContext())
{
db.SaveUser(u);
db.SavePanic(p);
db.SavePanic(p2);
db.SaveChanges();
}
}
public void TestSavePanic()
{
User u = User.GenerateNewUser();
Panic p = new Panic("testCourse", u);
Panic p2 = new Panic("testCourse", u);
using (var db = new TestSurveyContext())
{
db.SaveUser(u);
db.SavePanic(p);
db.SavePanic(p2);
db.SaveChanges();
}
}
public void TestResultComputation()
{
Assert.IsNull(GetTestSurveyFromDb());
Survey s = CreateTestSurvey();
Survey s2 = CreateTestSurvey();
s2.Question += "2";
using (var db = new TestSurveyContext())
{
db.Surveys.Add(s);
db.Surveys.Add(s2);
db.SaveChanges();
Vote v1 = new Vote(new User() { Code = "User1", Created = DateTime.Now }, s, s.Answers.ElementAt(0));
db.Votes.Add(v1);
Vote v2 = new Vote(new User() { Code = "User2", Created = DateTime.Now }, s, s.Answers.ElementAt(2));
db.Votes.Add(v2);
Vote v3 = new Vote(new User() { Code = "User3", Created = DateTime.Now }, s, s.Answers.ElementAt(0));
db.Votes.Add(v3);
Vote v4 = new Vote(new User() { Code = "User3", Created = DateTime.Now }, s2, s2.Answers.ElementAt(0));
db.Votes.Add(v4);
db.SaveChanges();
}
using (var db = new TestSurveyContext())
{
Result[] res = db.getResultsFor(s);
Assert.IsNotNull(res);
Assert.IsTrue(res.Length == 2);
Assert.IsTrue(res[0].Answer.AnswerText == "Answer 1");
Assert.IsTrue(res[0].Count == 2);
Assert.IsTrue(res[1].Answer.AnswerText == "Answer 3");
Assert.IsTrue(res[1].Count == 1);
Vote[] votes = db.Votes.Where(v => v.Survey.Id == s.Id || v.Survey.Id == s2.Id).ToArray<Vote>();
foreach (Vote v in votes)
{
db.Votes.Remove(v);
}
db.SaveChanges();
}
using (var db = new TestSurveyContext())
{
db.Surveys.Attach(s);
db.Surveys.Remove(s);
db.Surveys.Attach(s2);
db.Surveys.Remove(s2);
db.SaveChanges();
}
}
public void TestVoteData()
{
Assert.IsNull(GetTestSurveyFromDb());
Survey survey = CreateTestSurvey();
using (var db = new TestSurveyContext())
{
db.SaveSurvey(survey);
Vote v1 = new Vote(new User()
{
Code = "User1", Created = DateTime.Now
}, survey, survey.Answers.ElementAt(0));
db.SaveVote(v1);
Vote v2 = new Vote(new User()
{
Code = "User2", Created = DateTime.Now
}, survey, survey.Answers.ElementAt(2));
db.SaveVote(v2);
Vote v3 = new Vote(new User()
{
Code = "User3", Created = DateTime.Now
}, survey, survey.Answers.ElementAt(0));
db.SaveVote(v3);
db.SaveChanges();
}
using (var db = new TestSurveyContext())
{
db.Surveys.Attach(survey);
var query = db.Votes.Where(v => v.Survey.Id == survey.Id);
Assert.IsNotNull(query);
Assert.IsTrue(query.Count() == 3);
Assert.IsTrue(query.Where(v => v.User.Code == "User3").Count() == 1);
foreach (Vote v in query)
{
db.Votes.Remove(v);
}
db.Surveys.Remove(survey);
db.SaveChanges();
}
Assert.IsNull(GetTestSurveyFromDb());
}
public void TestResultComputation()
{
Assert.IsNull(GetTestSurveyFromDb());
Survey s = CreateTestSurvey();
Survey s2 = CreateTestSurvey();
s2.Question += "2";
using (var db = new TestSurveyContext())
{
db.Surveys.Add(s);
db.Surveys.Add(s2);
db.SaveChanges();
Vote v1 = new Vote(new User()
{
Code = "User1", Created = DateTime.Now
}, s, s.Answers.ElementAt(0));
db.Votes.Add(v1);
Vote v2 = new Vote(new User()
{
Code = "User2", Created = DateTime.Now
}, s, s.Answers.ElementAt(2));
db.Votes.Add(v2);
Vote v3 = new Vote(new User()
{
Code = "User3", Created = DateTime.Now
}, s, s.Answers.ElementAt(0));
db.Votes.Add(v3);
Vote v4 = new Vote(new User()
{
Code = "User3", Created = DateTime.Now
}, s2, s2.Answers.ElementAt(0));
db.Votes.Add(v4);
db.SaveChanges();
}
using (var db = new TestSurveyContext())
{
Result[] res = db.getResultsFor(s);
Assert.IsNotNull(res);
Assert.IsTrue(res.Length == 2);
Assert.IsTrue(res[0].Answer.AnswerText == "Answer 1");
Assert.IsTrue(res[0].Count == 2);
Assert.IsTrue(res[1].Answer.AnswerText == "Answer 3");
Assert.IsTrue(res[1].Count == 1);
Vote[] votes = db.Votes.Where(v => v.Survey.Id == s.Id || v.Survey.Id == s2.Id).ToArray <Vote>();
foreach (Vote v in votes)
{
db.Votes.Remove(v);
}
db.SaveChanges();
}
using (var db = new TestSurveyContext())
{
db.Surveys.Attach(s);
db.Surveys.Remove(s);
db.Surveys.Attach(s2);
db.Surveys.Remove(s2);
db.SaveChanges();
}
}
public void TestSurveyData()
{
Assert.IsNull(GetTestSurveyFromDb());
Survey survey = CreateTestSurvey();
using (var db = new TestSurveyContext())
{
db.SaveSurvey(survey);
db.SaveChanges();
}
using (var db = new TestSurveyContext())
{
Survey[] res = db.getSurveysFor("TEST");
Assert.IsTrue(res.Length == 1);
}
Survey fromDb;
using (var db = new TestSurveyContext())
{
fromDb = db.Surveys.Where(s => s.Question == Title).FirstOrDefault<Survey>();
Assert.IsNotNull(fromDb);
Assert.IsTrue(fromDb.Question == Title);
Assert.IsTrue(fromDb.Answers.Count == 3);
Assert.IsTrue(fromDb.Answers.Where<Answer>(a => a.AnswerText == "Answer 2").Count() == 1);
db.DeleteSurvey(fromDb);
db.SaveChanges();
}
Assert.IsNull(GetTestSurveyFromDb());
}
private Survey GetTestSurveyFromDb()
{
// Check that test question is not
using (var db = new TestSurveyContext())
{
return db.Surveys.Where(s => s.Question == Title).FirstOrDefault<Survey>();
}
}
public void TestVoteData()
{
Assert.IsNull(GetTestSurveyFromDb());
Survey survey = CreateTestSurvey();
using (var db = new TestSurveyContext())
{
db.SaveSurvey(survey);
Vote v1 = new Vote(new User() { Code = "User1", Created = DateTime.Now }, survey, survey.Answers.ElementAt(0));
db.SaveVote(v1);
Vote v2 = new Vote(new User() { Code = "User2", Created = DateTime.Now }, survey, survey.Answers.ElementAt(2));
db.SaveVote(v2);
Vote v3 = new Vote(new User() { Code = "User3", Created = DateTime.Now }, survey, survey.Answers.ElementAt(0));
db.SaveVote(v3);
db.SaveChanges();
}
using (var db = new TestSurveyContext())
{
db.Surveys.Attach(survey);
var query = db.Votes.Where(v => v.Survey.Id == survey.Id);
Assert.IsNotNull(query);
Assert.IsTrue(query.Count() == 3);
Assert.IsTrue(query.Where(v => v.User.Code == "User3").Count() == 1);
foreach(Vote v in query) {
db.Votes.Remove(v);
}
db.Surveys.Remove(survey);
db.SaveChanges();
}
Assert.IsNull(GetTestSurveyFromDb());
}
public void TestUserGenSave()
{
User u = User.GenerateNewUser();
using (var db = new TestSurveyContext())
{
db.SaveUser(u);
db.SaveChanges();
}
}
