public override bool Equals(System.Object otherPony) { if (!(otherPony is Pony)) { return(false); } else { Pony newPony = otherPony as Pony; bool nameEquality = (this.GetName() == newPony.GetName()); bool typeEquality = (this.GetPonyType() == newPony.GetPonyType()); bool cutieMarkEquality = (this.GetCutieMark() == newPony.GetCutieMark()); bool productTypeEquality = (this.GetProductType() == newPony.GetProductType()); bool allEquality; if (nameEquality && typeEquality && cutieMarkEquality && productTypeEquality) { allEquality = true; } else { allEquality = false; } return(allEquality); } }
public static List <Pony> GetAll() { List <Pony> allPonys = new List <Pony> { }; MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM pony;"; MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int ponyId = rdr.GetInt32(0); string ponyName = rdr.GetString(1); string ponyType = rdr.GetString(2); string ponyCutieMark = rdr.GetString(3); string ponyProductType = rdr.GetString(4); Pony newPony = new Pony(ponyName, ponyType, ponyCutieMark, ponyProductType, ponyId); allPonys.Add(newPony); } conn.Close(); if (conn != null) { conn.Dispose(); } return(allPonys); }