コード例 #1
0
        public static CityActivity FindById(int searchId)
        {
            int             id         = 0;
            int             cityID     = 0;
            int             activityID = 0;
            MySqlConnection conn       = DB.Connection();

            conn.Open();
            MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;

            cmd.CommandText = @"SELECT * FROM cities_activities WHERE id = @idMatch;";
            MySqlParameter parameterId = new MySqlParameter();

            parameterId.ParameterName = "@idMatch";
            parameterId.Value         = searchId;
            cmd.Parameters.Add(parameterId);
            MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;

            while (rdr.Read())
            {
                id         = rdr.GetInt32(0);
                cityID     = rdr.GetInt32(1);
                activityID = rdr.GetInt32(2);
            }
            CityActivity foundCityActivity = new CityActivity(cityID, activityID, id);

            conn.Close();
            if (conn != null)
            {
                conn.Dispose();
            }
            return(foundCityActivity);
        }
コード例 #2
0
        public static List <CityActivity> GetAll()
        {
            List <CityActivity> newCityActivities = new List <CityActivity> {
            };
            MySqlConnection conn = DB.Connection();

            conn.Open();
            MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;

            cmd.CommandText = @"SELECT * FROM cities_activities;";
            MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;

            while (rdr.Read())
            {
                int          id              = rdr.GetInt32(0);
                int          cityID          = rdr.GetInt32(1);
                int          activityID      = rdr.GetInt32(2);
                CityActivity newCityActivity = new CityActivity(cityID, activityID, id);
                newCityActivities.Add(newCityActivity);
            }
            conn.Close();
            if (conn != null)
            {
                conn.Dispose();
            }
            return(newCityActivities);
        }
コード例 #3
0
 public override bool Equals(System.Object otherCityActivity)
 {
     if (!(otherCityActivity is CityActivity))
     {
         return(false);
     }
     else
     {
         CityActivity newCityActivity    = (CityActivity)otherCityActivity;
         bool         idEquality         = (this.GetId() == newCityActivity.GetId());
         bool         cityIDEquality     = (this.GetCityID() == newCityActivity.GetCityID());
         bool         activityIDEquality = (this.GetActivityID() == newCityActivity.GetActivityID());
         return(idEquality && cityIDEquality && activityIDEquality);
     }
 }