//Delete Cards Function public void Delete(string name) { CardDetails list = new CardDetails(); using (MySqlConnection msconnection = GetConnection()) { msconnection.Open(); MySqlCommand mscommand = new MySqlCommand("DELETE FROM cards WHERE (cardname = '" + name + "')", msconnection); MySqlCommand mscom = new MySqlCommand("DELETE FROM carddetails WHERE (cardname = '" + name + "')", msconnection); mscom.ExecuteNonQuery(); mscommand.ExecuteNonQuery(); msconnection.Close(); } return; }
//Card Edit Function public void Edit(CardDetails tmp) { using (MySqlConnection msconnection = GetConnection()) { msconnection.Open(); MySqlCommand mscommand = msconnection.CreateCommand(); MySqlCommand mscomm = msconnection.CreateCommand(); mscommand.CommandText = "UPDATE carddetails SET card_id='" + tmp.CardId + "',cardname='" + tmp.CardName + "',playerClass='" + tmp.CardGroup + "',cardtype='" + tmp.CardType + "',cardset='" + tmp.CardSet + "',cardtext='" + tmp.CardText + "',cost='" + tmp.CardCost + "',attack='" + tmp.CardAttack + "',health='" + tmp.CardHealth + "',rarity='" + tmp.CardRare + "',collectible='" + tmp.CardCollect + "',race='" + tmp.CardRace + "',how_to_earn='" + tmp.CardEarn + "',targeting_arrow_text='" + tmp.CardTarget + "' WHERE (card_id = '" + tmp.CardId + "');"; mscomm.CommandText = "UPDATE cards SET card_id='" + tmp.CardId + "',cardname='" + tmp.CardName + "',playerClass='" + tmp.CardGroup + "',cardtype='" + tmp.CardType + "',cardset='" + tmp.CardSet + "',cost='" + tmp.CardCost + "' WHERE (card_id = '" + tmp.CardId + "');"; mscommand.ExecuteNonQuery(); mscomm.ExecuteNonQuery(); msconnection.Close(); } return; }
//Add Cards Function public void Add(CardDetails tmp) { using (MySqlConnection msconnection = GetConnection()) { msconnection.Open(); MySqlCommand mscommand = msconnection.CreateCommand(); MySqlCommand mscomm = msconnection.CreateCommand(); mscommand.CommandText = "insert into carddetails(card_id, cardname, playerClass, cardtype, cardset, cardtext, cost, attack, health, rarity, collectible, race, how_to_earn, targeting_arrow_text, url) values(@CardId, @CardName, @CardGroup, @CardType, @CardSet, @CardText, @CardCost, @CardAttack, @CardHealth, @CardRare, @CardCollect, @CardRace, @CardEarn, @CardTarget, @CardUrl)"; mscomm.CommandText = "insert into cards(card_id, cardname, playerClass, cardtype, cardset, cost) values(@CardId, @CardName, @CardGroup, @CardType, @CardSet, @CardCost)"; mscommand.Parameters.AddWithValue("@CardId", tmp.CardId); mscommand.Parameters.AddWithValue("@CardName", tmp.CardName); mscommand.Parameters.AddWithValue("@CardType", tmp.CardType); mscommand.Parameters.AddWithValue("@CardGroup", tmp.CardGroup); mscommand.Parameters.AddWithValue("@CardSet", tmp.CardSet); mscommand.Parameters.AddWithValue("@CardText", tmp.CardText); mscommand.Parameters.AddWithValue("@CardCost", tmp.CardCost); mscommand.Parameters.AddWithValue("@CardAttack", tmp.CardAttack); mscommand.Parameters.AddWithValue("@CardHealth", tmp.CardHealth); mscommand.Parameters.AddWithValue("@CardRare", tmp.CardRare); mscommand.Parameters.AddWithValue("@CardCollect", tmp.CardCollect); mscommand.Parameters.AddWithValue("@CardRace", tmp.CardRace); mscommand.Parameters.AddWithValue("@CardEarn", tmp.CardEarn); mscommand.Parameters.AddWithValue("@CardTarget", tmp.CardTarget); mscommand.Parameters.AddWithValue("@CardUrl", tmp.CardUrl); mscomm.Parameters.AddWithValue("@CardId", tmp.CardId); mscomm.Parameters.AddWithValue("@CardName", tmp.CardName); mscomm.Parameters.AddWithValue("@CardType", tmp.CardType); mscomm.Parameters.AddWithValue("@CardGroup", tmp.CardGroup); mscomm.Parameters.AddWithValue("@CardSet", tmp.CardSet); mscomm.Parameters.AddWithValue("@CArdCost", tmp.CardCost); mscommand.ExecuteNonQuery(); mscomm.ExecuteNonQuery(); msconnection.Close(); } return; }
//View Card Details public CardDetails GetDetail(string name) { CardDetails list = new CardDetails(); using (MySqlConnection msconnection = GetConnection()) { msconnection.Open(); MySqlCommand mscommand = new MySqlCommand("select * from carddetails where cardname='" + name + "'", msconnection); using (MySqlDataReader reader = mscommand.ExecuteReader()) { if (reader.Read()) { list.CardId = reader.GetString("card_id"); list.CardName = reader.GetString("cardname"); list.CardSet = reader.GetString("cardset"); list.CardText = reader.GetString("cardtext"); list.CardCost = reader.GetInt16("cost"); list.CardType = reader.GetString("cardtype"); list.CardGroup = reader.GetString("playerClass"); list.CardAttack = reader.GetString("attack"); list.CardHealth = reader.GetString("health"); list.CardRare = reader.GetString("rarity"); list.CardCollect = reader.GetString("collectible"); list.CardEarn = reader.GetString("how_to_earn"); list.CardTarget = reader.GetString("targeting_arrow_text"); list.CardUrl = reader.GetString("url"); } else { return(null); } } msconnection.Close(); } return(list); }