예제 #1
0
        public static BallotCollection GetBallots(Motion motion)
        {
            var result = new BallotCollection();

            var sql = CreateCommand();

            sql.CommandText = @"SELECT id,motionId,moderatorId,choice FROM ballots WHERE motionId = ?motionId";

            var pId = sql.CreateParameter();

            pId.ParameterName = "?motionId";
            pId.Value         = motion.Id;
            sql.Parameters.Add(pId);

            using (var db = CreateConnection())
            {
                db.Open();
                sql.Connection = db;
                sql.Prepare();
                var rs = sql.ExecuteReader();

                while (rs.Read())
                {
                    result.Add(new Ballot
                    {
                        Id        = rs.GetInt32(0),
                        Motion    = GetMotion(rs.GetInt32(1)),
                        Moderator = GetModerator(rs.GetInt32(2)),
                        Choice    = (Choice)rs.GetInt32(3)
                    });
                }
                db.Close();
            }
            return(result);
        }
예제 #2
0
 public Motion()
 {
     this.Votes   = new BallotCollection();
     this.Text    = "";
     this.PostUrl = "";
 }