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