public bool PutInLists(DbUser dbUser, BaseCards ownCard, TradingObject wantToHave) { bool indicator = false; BaseCards wantedCard = wantToHave.card; //ich selbst string query = DbFunctions.MakeQueryForInsertCard(wantedCard, dbUser); if (ExecuteQuery(query)) { indicator = true; } //der andere dbUser.uid = wantToHave.userUid; query = DbFunctions.MakeQueryForInsertCard(ownCard, dbUser); if (ExecuteQuery(query)) { if (indicator == false) { return(false); } } return(true); }
public static bool ChekTrade(string cardWantToHave, List <TradingObject> cardListToTrade, string choiceToTrade, List <BaseCards> userCardcollection, string answerToTrade) { BaseCards card = userCardcollection[Int32.Parse(choiceToTrade) - 1]; BaseCards checkFromCard = cardListToTrade[Int32.Parse(cardWantToHave) - 1].card; TradingObject tempObject = cardListToTrade[Int32.Parse(cardWantToHave) - 1]; bool indicator = false; int damage = tempObject.requiredDamage; //damage den man will string temp = tempObject.wantedCardType; if (temp.Contains("Spell")) { if (MyEnum.cardTypes.Spell == card.getCardType()) { if (card.getCardDamage() >= damage) { indicator = true; } } } else if (temp.Contains("Monster")) { if (MyEnum.cardTypes.Monster == card.getCardType()) { if (card.getCardDamage() >= damage) { indicator = true; } } } return(indicator); }
public static string ReturnCardsToTradeString() { List <TradingObject> cardsListTrading = new List <TradingObject>(); TradingObject tempObject = new TradingObject(); string query = "SELECT * FROM userdata_cardcollectiontotrade"; int counter = 0; string answer = ""; cardsListTrading = mysql.GetCardsToTrade(query); foreach (TradingObject part in cardsListTrading) { part.card = mysql.GetOneCard(part.cardUid); } foreach (TradingObject part in cardsListTrading) { answer += $"{ counter + 1} : The Player wants a , {cardsListTrading[counter].wantedCardType}, card with min damage , {cardsListTrading[counter].requiredDamage}\n"; answer += $"Offeded is a , {cardsListTrading[counter].card.getCardType()} card with element {cardsListTrading[counter].card.getElementTypes()} "; if (cardsListTrading[counter].card.getCardType() == MyEnum.cardTypes.Monster) { answer += " and Property " + cardsListTrading[counter].card.getCardProperty(); } answer += $"with min damage {cardsListTrading[counter].card.getCardDamage()}\n\n"; counter++; } return(answer); }
public List <TradingObject> GetCardsToTrade(string query) { List <TradingObject> tradingList = new List <TradingObject>(); var commandDatabase = new NpgsqlCommand(query, _databaseConnection); commandDatabase.CommandTimeout = 60; try { _databaseConnection.Open(); var myReader = commandDatabase.ExecuteReader(); //Console.WriteLine(myReader); if (myReader.HasRows) { Console.WriteLine("Query Generated result:"); while (myReader.Read()) { TradingObject temp = new TradingObject(); Console.WriteLine(myReader.GetValue(0) + "-" + myReader.GetString(1) + " - " + myReader.GetString(2) + " - " + myReader.GetValue(3)); //nur zur übersicht //temp += myReader.GetString(0) + "-" + myReader.GetString(1) + "-" + myReader.GetString(2) + "-" + myReader.GetValue(3).ToString() + "\n"; temp.userUid = myReader.GetString(0); temp.cardUid = myReader.GetString(1); temp.wantedCardType = myReader.GetString(2); temp.requiredDamage = myReader.GetInt32(3); //temp.card = GetOneCard(temp.cardUid); tradingList.Add(temp); } } else { Console.WriteLine("Query Error!"); } } catch (Exception e) { Console.WriteLine("Query Error: " + e.Message); } _databaseConnection.Close(); return(tradingList); }
public bool UpdateCardsByTrade(DbUser dbUser, BaseCards card, TradingObject tradingListe) { bool indicator = false; //löschen aus cartencollction string queryDelete = "Delete From userdata_cardcollection where fk_user_uid = '" + dbUser.uid + "' and fk_card_uid = '" + card.getUID() + "'"; if (ExecuteQuery(queryDelete)) { indicator = true; } //löschen aus tauschliste queryDelete = "delete from userdata_cardcollectiontotrade where fk_user_uid = '" + tradingListe.userUid + "' and fk_card_uid = '" + tradingListe.cardUid + "'"; if (ExecuteQuery(queryDelete)) { if (indicator == false) { return(false); } } return(true); }