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