//get one violation
        public Violation getViolation(int id)
        {
            string sql_stmt;
            sql_stmt = "SELECT " +
                        "   violation_id,violation,description,price,last_modified " +
                        "FROM " +
                        "   violations " +
                        "WHERE " +
                        "   violation_id = @id";

            SqlCeConnection conn = new SqlCeConnection(this.conn_string);
            conn.Open();
            SqlCeCommand cmd = conn.CreateCommand();
            cmd.CommandText = sql_stmt;
            SqlCeResultSet result = cmd.ExecuteResultSet(ResultSetOptions.Insensitive);

            Violation violation = null;

            while (result.Read() != null)
            {
                violation = new Violation();
                violation.ViolationId = result.GetInt32(0);
                violation.ViolationName = result.GetString(1);
                violation.Description = result.GetString(2);
                violation.Price = result.GetDecimal(3);
                violation.LastModified = result.GetDateTime(4);

                break;
            }

            result.Close();
            conn.Close();

            return violation;
        }
        //get violations
        public List<Violation> getAllViolations()
        {
            string sql_stmt;
            sql_stmt =  "SELECT " +
                        "   violation_id,violation,description,price,last_modified " +
                        "FROM " +
                        "   violations";

            SqlCeConnection conn = new SqlCeConnection(this.conn_string);
            conn.Open();
            SqlCeCommand cmd = conn.CreateCommand();
            cmd.CommandText = sql_stmt;
            SqlCeResultSet result = cmd.ExecuteResultSet(ResultSetOptions.Insensitive);

            List<Violation> violations = new List<Violation>();

            while (result.Read() != null)
            {
                Violation violation = new Violation();
                violation.ViolationId = result.GetInt32(0);
                violation.ViolationName = result.GetString(1);
                violation.Description = result.GetString(2);
                violation.Price = result.GetDecimal(3);
                violation.LastModified = result.GetDateTime(4);

                violations.Add(violation);
            }

            result.Close();
            conn.Close();

            return violations;
        }