static public void AcquirePackage(RequestContext request)
{
int userstate = UserHandler.AuthUser(request);
if (userstate == 1 || userstate == 2) //eingeloggt
{
User user = UserHandler.GetUserDataByToken(request);
if (user.coins < 5)
{
Output.WriteConsole(Output.InsufficientCoins);
return;
}
try
{
CardsPacksDatabaseHandler.AcquirePackage(user);
user.coins -= 5;
UserHandler.UpdateCoins(user);
Output.WriteConsole(Output.PackageTransactionSuccess);
}
catch (Exception e)
{
Output.WriteConsole(e.Message);
}
return;
}
Output.WriteConsole(Output.AuthError);
}
static public void SellCard(string cardId, User user)
{
using var conn = new NpgsqlConnection(connString);
conn.Open();
string updateString = String.Format("UPDATE cards_users SET userid = 0 WHERE id = '{0}'", cardId);
using (var cmd = new NpgsqlCommand(updateString, conn))
{
cmd.Prepare();
cmd.ExecuteNonQuery();
}
conn.Close();
user.coins++;
UserHandler.UpdateCoins(user);
}
