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