public static bool CheckIfAddToDeckIsValide(BaseCards tempCard, DbUser userFromDb) { //nun kann ein benutzer eine karte leider auch mehrmals haben int numbeCardcollection = WieOftHatErDieKarte(userFromDb.cardCollection, tempCard.getUID()); //so oft darf er eine bestimmte karte verwenden int numbeDeck = WieOftHatErDieKarte(userFromDb.cardDeck, tempCard.getUID()); //so oft hat er die karte bereits im deck if (numbeCardcollection > numbeDeck) { return(true); } return(false); }
public static string MakeMessageTradDelete(DbUser userFromDb, BaseCards card) { string temp = "DELETE FROM userdata_cardcollection WHERE "; temp += "fk_user_uid = '" + userFromDb.uid + "' AND fk_card_uid = '" + card.getUID() + "';"; return(temp); }
public static string MakeQueryForInsertCard(BaseCards baseCard, DbUser user) { string temp = "Insert Into UserData_CardCollection\n" + "(fk_user_uid, fk_card_uid)\n" + "VALUES\n" + "('" + user.uid + "', '" + baseCard.getUID() + "');"; return(temp); }
public static string MakeQueryForCreateNewCard(BaseCards baseCard) { string temp = "Insert into cardcollection\n" + "(card_uid, element_type, card_property, card_type, card_name, card_damage)\n" + "VALUES\n" + "('" + baseCard.getUID() + "', '" + baseCard.getElementTypes() + "', '" + baseCard.getCardProperty() + "', '" + baseCard.getCardType() + "', '" + baseCard.getCardName() + "', '" + baseCard.getCardDamage() + "');"; return(temp); }
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); }