public bool Equals(Quiz other)
{
if (ReferenceEquals(null, other))
{
return false;
}
if (ReferenceEquals(this, other))
{
return true;
}
return base.Equals(other) && Answer.Equals(other.Answer) && Question.Equals(other.Question);
}
public void SetQuestion(Quiz q)
{
_view.Question.Text = q.Question;
_view.Answer.Text = q.Answer;
}
private Citizen PriLoadCitizen(int id)
{
Contract.Requires(this.Transacting(), "This method must be performed in a transaction.");
Contract.Requires(PriExistsWithId("person", id), "Person must exist in the database to be loaded.");
Contract.Requires(HasValidCpr(id), "A citizen must have a valid CPR number");
Contract.Ensures(Contract.Result<Citizen>() != null);
MySqlCommand command = Prepare("SELECT " +
" *, v.name venue_name, v.address venue_address " +
"FROM " +
" person p " +
" LEFT JOIN " +
" voting_venue v " +
" ON " +
" v.id=p.voting_venue_id " +
"WHERE " +
" p.id=@id");
command.Parameters.AddWithValue("@id", id);
Citizen c = null;
Query(command, rdr =>
{
rdr.Read();
c = new Citizen(id, rdr.GetString("cpr"), rdr.GetInt32("has_voted") != 0);
c.EligibleToVote = rdr.GetInt16("eligible_to_vote") == 1;
DoIfNotDbNull(rdr, "voting_venue_id", label =>
{
c.VotingPlace = new VotingVenue(
rdr.GetInt32(label),
rdr.GetString("venue_name"),
rdr.GetString("venue_address"));
});
DoIfNotDbNull(rdr, "name", lbl => { c.Name = rdr.GetString(lbl); });
DoIfNotDbNull(rdr, "address", lbl => { c.Address = rdr.GetString(lbl); });
DoIfNotDbNull(rdr, "place_of_birth", lbl => { c.PlaceOfBirth = rdr.GetString(lbl); });
DoIfNotDbNull(rdr, "passport_number", lbl => { c.PassportNumber = rdr.GetString(lbl); });
});
MySqlCommand findQuestions = Prepare("SELECT * FROM quiz WHERE person_id=@id");
findQuestions.Parameters.AddWithValue("@id", id);
Query(findQuestions, rdr =>
{
while (rdr.Read())
{
Quiz q = new Quiz(rdr.GetString("question"), rdr.GetString("answer"));
c.SecurityQuestions.Add(q);
}
});
return c;
}