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);
}
