public override bool Equals(System.Object otherCard) { if (!(otherCard is MagicCard)) { return(false); } else { MagicCard newCard = otherCard as MagicCard; bool nameEquality = (this.GetName() == newCard.GetName()); bool colorEquality = (this.GetColor() == newCard.GetColor()); bool rarityEquality = (this.GetRarity() == newCard.GetRarity()); bool typeEquality = (this.GetCardType() == newCard.GetCardType()); bool setEquality = (this.GetSet() == newCard.GetSet()); bool allEquality; if (nameEquality && colorEquality && rarityEquality && typeEquality && setEquality) { allEquality = true; } else { allEquality = false; } return(allEquality); } }
public static List <MagicCard> GetAll() { List <MagicCard> allMagicCards = new List <MagicCard> { }; MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM magic_card;"; MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int magicCardId = rdr.GetInt32(0); string magicCardName = rdr.GetString(1); string magicCardColor = rdr.GetString(2); string magicCardRarity = rdr.GetString(3); string magicCardType = rdr.GetString(4); string magicCardSet = rdr.GetString(5); MagicCard newMagicCard = new MagicCard(magicCardName, magicCardColor, magicCardRarity, magicCardType, magicCardSet, magicCardId); allMagicCards.Add(newMagicCard); } conn.Close(); if (conn != null) { conn.Dispose(); } return(allMagicCards); }
public static MagicCard Find(int id) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM inventory WHERE id = @thisId;"; MySqlParameter thisId = new MySqlParameter(); thisId.ParameterName = "@thisId"; thisId.Value = id; cmd.Parameters.Add(thisId); var rdr = cmd.ExecuteReader() as MySqlDataReader; int MagicCardId = 0; string MagicCardName = ""; string MagicCardColor = ""; string MagicCardRarity = ""; string MagicCardType = ""; string MagicCardSet = ""; int magicCardCategoryId = 0; while (rdr.Read()) { MagicCardId = rdr.GetInt32(0); MagicCardName = rdr.GetString(1); MagicCardColor = rdr.GetString(2); MagicCardRarity = rdr.GetString(3); MagicCardType = rdr.GetString(4); MagicCardSet = rdr.GetString(5); magicCardCategoryId = rdr.GetInt32(6); } MagicCard foundMagicCard = new MagicCard(MagicCardName, MagicCardColor, MagicCardRarity, MagicCardType, MagicCardSet, magicCardCategoryId, MagicCardId); conn.Close(); if (conn != null) { conn.Dispose(); } return(foundMagicCard); }
public List <MagicCard> GetMagicCards() { List <MagicCard> allCategoryMagicCards = new List <MagicCard> { }; MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM magic_card WHERE category_id = @category_id;"; MySqlParameter categoryId = new MySqlParameter(); categoryId.ParameterName = "@category_id"; categoryId.Value = this._id; cmd.Parameters.Add(categoryId); var rdr = cmd.ExecuteReader() as MySqlDataReader; while (rdr.Read()) { int magicCardId = rdr.GetInt32(0); string magicCardName = rdr.GetString(1); string magicCardColor = rdr.GetString(2); string magicCardRarity = rdr.GetString(3); string magicCardType = rdr.GetString(4); string magicCardSet = rdr.GetString(5); int magicCardCategoryId = rdr.GetInt32(6); MagicCard newMagicCard = new MagicCard(magicCardName, magicCardColor, magicCardRarity, magicCardType, magicCardSet, magicCardCategoryId, magicCardId); allCategoryMagicCards.Add(newMagicCard); } conn.Close(); if (conn != null) { conn.Dispose(); } return(allCategoryMagicCards); }
public void AddCard(MagicCard cardList) { _cards.Add(cardList); }