public static string Show_tradings(string i_username)
{
if (DBManagment.has_session(i_username))
{
if (Count_Trading())
{
string result = "";
int i = 1;
using var con = new NpgsqlConnection(DBManagment.cs);
string sql = "Select trading_erea_offer.username, trading_erea_offer.offer_id, all_user_cards.name, elementar_type, damage, all_user_cards.card_type, min_damage, trading_erea_req.card_type FROM all_user_cards, trading_erea_offer, trading_erea_req where trading_erea_offer.card_id = all_user_cards.card_id and trading_erea_offer.username not in (@username)";
using var cmd = new NpgsqlCommand(sql, con);
con.Open();
cmd.Parameters.AddWithValue("username", i_username);
cmd.Prepare();
using NpgsqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
result += i + ") TradeID: " + rdr.GetInt32(1) + " - Owner: " + rdr.GetString(0) + "\r\n" + "Card to give:\r\n" +
"Name: " + rdr.GetString(2) + " - Type: " + rdr.GetString(5) + " - Element: " + rdr.GetValue(3) + " - Damage: " + rdr.GetDouble(4)
+ "\r\n" + "Requested Card: \r\n" + " MinDamage: " + rdr.GetDouble(6) + " - Type: " + rdr.GetString(7) + "\r\n";
i++;
}
return(result);
}
else
{
return("No tradings available");
}
}
else
{
return("User doesn't have a session / invalid Token!");
}
}
public static string Show_Players_Data(string i_username)
{
if (DBManagment.has_session(i_username))
{
string result = "";
int i = 1;
using var con = new NpgsqlConnection(DBManagment.cs);
string sql = "Select username, name, email, bio from game_user where username = @username";
using var cmd = new NpgsqlCommand(sql, con);
con.Open();
cmd.Parameters.AddWithValue("username", i_username);
cmd.Prepare();
using NpgsqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
result += i + ") Username: "******" - Name: " + rdr.GetString(1) + " - E-Mail: " +
rdr.GetString(2) + " - Bio: " + rdr.GetString(3) + "\r\n";
i++;
}
return(result);
}
else
{
return("Error: User doesn't have a session / invalid Token!");
}
}
public static int Delete_Trade(string i_username, int offer_id)
{
if (DBManagment.has_session(i_username))
{
if (Has_deal(i_username, offer_id) == 1)
{
using var con = new NpgsqlConnection(DBManagment.cs);
con.Open();
string sql = "DELETE FROM trading_erea_offer where offer_id = @offer_id";
using var cmd = new NpgsqlCommand(sql, con);
cmd.Parameters.AddWithValue("offer_id", offer_id);
cmd.Prepare();
cmd.ExecuteNonQuery();
con.Close();
return(0);
}
else
{
//User doesnt own the card he wanna delete from offer
return(2);
}
}
else
{
//invalid token, doesnt have session
return(1);
}
}
public static string Show_Deck(string i_username)
{
if (DBManagment.has_session(i_username))
{
if (Has_Deck(i_username))
{
string result = "";
int i = 1;
using var con = new NpgsqlConnection(DBManagment.cs);
string sql = "Select deck.card_id, name, card_type, elementar_type, damage from deck, all_user_cards where deck.card_id = all_user_cards.card_id and deck.username = @username";
using var cmd = new NpgsqlCommand(sql, con);
con.Open();
cmd.Parameters.AddWithValue("username", i_username);
cmd.Prepare();
using NpgsqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
result += i + ") CardID: " + rdr.GetString(0) + " Name: " + rdr.GetString(1) + "Type: " +
rdr.GetString(2) + " Element: " + rdr.GetValue(3) + " Damage: " + rdr.GetDouble(4) + "\r\n";
i++;
}
return(result);
}
else
{
return("No deck found!");
}
}
else
{
return("Error: User doesn't have a session / invalid Token!");
}
}
public static bool Decreasing_coins_from_user(string i_username)
{
if (DBManagment.has_session(i_username) == true)
{
//getting the players coins
var con = new NpgsqlConnection(DBManagment.cs);
string sql = "Select coins from game_user where username = @username";
var cmd = new NpgsqlCommand(sql, con);
con.Open();
cmd.Parameters.AddWithValue("username", i_username);
cmd.Prepare();
NpgsqlDataReader rdr = cmd.ExecuteReader();
rdr.Read();
int player_coins = rdr.GetInt32(0);
rdr.Close();
//updating players coins#
sql = "update game_user set coins = @coins where username = @username";
var cmd2 = new NpgsqlCommand(sql, con);
cmd2.Parameters.AddWithValue("coins", player_coins - 5);
cmd2.Parameters.AddWithValue("username", i_username);
cmd2.Prepare();
cmd2.ExecuteNonQuery();
con.Close();
return(true);
}
else
{
return(false);
}
}
public static int ReadyUpForFight(string i_username)
{
if (DBManagment.has_session(i_username))
{
if (DBManagmentDeck.Has_Deck(i_username))
{
string id = "";
string name = "";
string type = "";
string element = "";
double damage = 0;
List <Card> cards = new List <Card>();
using var con = new NpgsqlConnection(DBManagment.cs);
string sql = "Select deck.card_id, name, card_type, elementar_type, damage from deck, all_user_cards where deck.card_id = all_user_cards.card_id and deck.username = @username";
using var cmd = new NpgsqlCommand(sql, con);
con.Open();
cmd.Parameters.AddWithValue("username", i_username);
cmd.Prepare();
using NpgsqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
id = rdr.GetString(0);
name = rdr.GetString(1);
type = rdr.GetString(2);
element = Convert.ToString(rdr.GetValue(3));
damage = rdr.GetDouble(4);
Card new_card = new Card
{
ID = id,
Name = name,
Damage = damage,
Type = type,
Element = element
};
cards.Add(new_card);
}
User user = new User
{
Username = i_username,
Deck = cards
};
FightSystem.InitFight(user);
FightSystem.ResetEvent.WaitOne();
return(0);
}
else
{
return(2);
}
}
else
{
return(1);
}
}
public static int Create_Trading_Deal(string i_username, TreadingDeal td)
{
if (DBManagment.has_session(i_username))
{
if (DBManagment.Has_Specific_Card(i_username, td.CardToTrade) == 1) //check if user owns the card
{
if (CheckIfCardNotInDeck(i_username, td.CardToTrade) == true)
{
//insert into trading_erea_offer
using var con = new NpgsqlConnection(DBManagment.cs);
con.Open();
string sql = "Insert into trading_erea_offer (offer_id, username, card_id) values (@id, @username, @card_id)";
using var cmd = new NpgsqlCommand(sql, con);
cmd.Parameters.AddWithValue("username", i_username);
cmd.Parameters.AddWithValue("id", td.ID);
cmd.Parameters.AddWithValue("card_id", td.CardToTrade);
cmd.Prepare();
cmd.ExecuteNonQuery();
con.Close();
//insert into trading_erea_req
con.Open();
sql = "Insert into trading_erea_req (offer_id, min_damage, card_type) values (@id, @min_damage, @card_type)";
using var cmd2 = new NpgsqlCommand(sql, con);
cmd2.Parameters.AddWithValue("id", td.ID);
cmd2.Parameters.AddWithValue("min_damage", td.MinimumDamage);
cmd2.Parameters.AddWithValue("card_type", td.Type);
cmd2.Prepare();
cmd2.ExecuteNonQuery();
con.Close();
return(0);
}
else
{
// card is in users deck
return(3);
}
}
else
{
//User doesnt own the card he wanna sell
return(2);
}
}
else
{
//invalid token, doesnt have session
return(1);
}
}
public static string Show_acquired_cards(string i_username)
{
try
{
if (DBManagment.has_session(i_username) == true)
{
if (Has_Cards(i_username))
{
string result = "";
int i = 0;
using var con = new NpgsqlConnection(DBManagment.cs);
string sql = "Select * from all_user_cards where username = @username";
using var cmd = new NpgsqlCommand(sql, con);
con.Open();
cmd.Parameters.AddWithValue("username", i_username);
cmd.Prepare();
using NpgsqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
result += i + ") CardID: " + rdr.GetString(4) + " Name: " + rdr.GetString(1) + "Type: " +
rdr.GetString(5) + " Element: " + rdr.GetValue(2) + " Damage: " + rdr.GetDouble(3) + "\n";
i++;
}
return(result);
}
else
{
return("User doesn't have any Cards!");
}
}
else
{
return("Error: User is not logged in / Invalid Token!");
}
}
catch (Exception e)
{
return("Exception caught: " + e);
}
}
public static bool SignOut(string i_username)
{
if (DBManagment.has_session(i_username) == true)
{
var con = new NpgsqlConnection(DBManagment.cs);
con.Open();
var sql = "DELETE from session where username = @username";
var cmd = new NpgsqlCommand(sql, con);
cmd.Parameters.AddWithValue("username", i_username);
cmd.Prepare();
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
else
{
//user is not logged in
return(false);
}
}
public static bool Edit_data(string i_username, string i_name, string i_bio, string i_email)
{
if (DBManagment.has_session(i_username) == true)
{
using var con = new NpgsqlConnection(DBManagment.cs);
con.Open();
string sql = "Update game_user set name = @name, bio = @bio, email=@email where username = @username";
using var cmd = new NpgsqlCommand(sql, con);
cmd.Parameters.AddWithValue("username", i_username);
cmd.Parameters.AddWithValue("name", i_name);
cmd.Parameters.AddWithValue("bio", i_bio);
cmd.Parameters.AddWithValue("email", i_email);
cmd.Prepare();
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
else
{
return(false);
}
}
public static string Show_stats(string i_username)
{
if (DBManagment.has_session(i_username) == true)
{
using var con = new NpgsqlConnection(DBManagment.cs);
string result = "";
string sql = "Select elo, wins, defeats, draws from game_user where username = @username";
using var cmd = new NpgsqlCommand(sql, con);
con.Open();
cmd.Parameters.AddWithValue("username", i_username);
cmd.Prepare();
using NpgsqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
result += "Elo: " + rdr.GetInt32(0) + " - Wins: " + rdr.GetInt32(1) + " - Defeats: " + rdr.GetInt32(2) + " - Draws: " + rdr.GetInt32(3);
}
return(result);
}
else
{
return("Error: User is not logged in / Invalid Token!");
}
}
public static void UpdatePlayerStats(string i_username, string result)
{
if (DBManagment.has_session(i_username) == true)
{
//fetching elo, wins, defeats, draws of player
using var con = new NpgsqlConnection(DBManagment.cs);
con.Open();
string sql = "SELECT elo, wins, defeats, draws from game_user where username = @username";
using var cmd = new NpgsqlCommand(sql, con);
cmd.Parameters.AddWithValue("username", i_username);
cmd.Prepare();
using NpgsqlDataReader rdr = cmd.ExecuteReader();
rdr.Read();
int elo = rdr.GetInt32(0);
int wins = rdr.GetInt32(1);
int defeats = rdr.GetInt32(2);
int draws = rdr.GetInt32(3);
rdr.Close();
//////////
string sql2 = "Update game_user set elo = @elo, wins = @wins, defeats=@defeats, draws = @draws where username = @username";
using var cmd2 = new NpgsqlCommand(sql2, con);
cmd.Parameters.AddWithValue("username", i_username);
if (result == "winner")
{
cmd2.Parameters.AddWithValue("username", i_username);
cmd2.Parameters.AddWithValue("elo", elo + 3);
cmd2.Parameters.AddWithValue("wins", wins + 1);
cmd2.Parameters.AddWithValue("defeats", defeats);
cmd2.Parameters.AddWithValue("draws", draws);
}
else if (result == "looser")
{
cmd2.Parameters.AddWithValue("username", i_username);
cmd2.Parameters.AddWithValue("elo", elo - 5);
cmd2.Parameters.AddWithValue("wins", wins);
cmd2.Parameters.AddWithValue("defeats", defeats + 1);
cmd2.Parameters.AddWithValue("draws", draws);
}
else if (result == "draw")
{
cmd2.Parameters.AddWithValue("username", i_username);
cmd2.Parameters.AddWithValue("elo", elo);
cmd2.Parameters.AddWithValue("wins", wins);
cmd2.Parameters.AddWithValue("defeats", defeats);
cmd2.Parameters.AddWithValue("draws", draws + 1);
}
else
{
return;
}
cmd2.Prepare();
cmd2.ExecuteNonQuery();
con.Close();
return;
}
else
{
return;
}
}
public static int Trade(string i_username, int trading_id, string card_id)
{
if (DBManagment.has_session(i_username))
{
if (DBManagment.Has_Specific_Card(i_username, card_id) == 1)
{
if (Check_trade_exists(trading_id) == 1)
{
//fetching min damage and type from request
double req_min_damage = 0;
string req_card_type = "";
using var con = new NpgsqlConnection(DBManagment.cs);
string sql = "Select min_damage, card_type from trading_erea_req where offer_id = @offer_id";
using var cmd = new NpgsqlCommand(sql, con);
con.Open();
cmd.Parameters.AddWithValue("offer_id", trading_id);
cmd.Prepare();
using NpgsqlDataReader rdr = cmd.ExecuteReader();
rdr.Read();
req_min_damage = rdr.GetDouble(0);
req_card_type = rdr.GetString(1);
rdr.Close();
////////////////
//Fetching the data from the offered card
double offered_card_damage = 0;
string offered_card_type = "";
string offered_card_id = "";
string owner = "";
sql = "Select card_type, damage, trading_erea_offer.username, trading_erea_offer.card_id from all_user_cards, trading_erea_offer where trading_erea_offer.offer_id = @offer_id";
using var cmd2 = new NpgsqlCommand(sql, con);
cmd2.Parameters.AddWithValue("card_id", card_id);
cmd2.Parameters.AddWithValue("offer_id", trading_id);
cmd2.Prepare();
using NpgsqlDataReader rdr2 = cmd2.ExecuteReader();
rdr2.Read();
offered_card_damage = rdr2.GetDouble(1);
offered_card_type = rdr2.GetString(0);
owner = rdr2.GetString(2);
offered_card_id = rdr2.GetString(3);
rdr2.Close();
//fetching the card that is given to trade
double given_card_damage = 0;
string given_card_type = "";
sql = "Select damage, card_type from all_user_cards WHERE card_id = @card_id";
using var cmd3 = new NpgsqlCommand(sql, con);
cmd3.Parameters.AddWithValue("card_id", card_id);
cmd3.Prepare();
using NpgsqlDataReader rdr3 = cmd3.ExecuteReader();
rdr3.Read();
given_card_damage = rdr3.GetDouble(0);
given_card_type = rdr3.GetString(1);
rdr3.Close();
if (owner != i_username)
{
if (given_card_damage > req_min_damage && given_card_type == req_card_type)
{
sql = "UPDATE all_user_cards set username = @username where card_id = @card_id";
using var cmd4 = new NpgsqlCommand(sql, con);
cmd4.Parameters.AddWithValue("card_id", card_id);
cmd4.Parameters.AddWithValue("username", owner);
cmd4.Prepare();
cmd4.ExecuteNonQuery();
Delete_Trade(owner, trading_id);
sql = "UPDATE all_user_cards set username = @username where card_id = @card_id";
using var cmd5 = new NpgsqlCommand(sql, con);
cmd5.Parameters.AddWithValue("card_id", offered_card_id);
cmd5.Parameters.AddWithValue("username", i_username);
cmd5.Prepare();
cmd5.ExecuteNonQuery();
Delete_Trade(owner, trading_id);
return(0);
}
else
{
return(5);
//doesn't have the correct card
}
}
else
{
//can't trade with yourself
return(4);
}
}
else
{
//trade doesnt exists
return(3);
}
}
else
{
//You dont own the card
return(2);
}
}
else
{
//doesnt have session / invalid token
return(1);
}
}
public static int Configure_Deck(string i_username, List <string> cards_id)
{
if (DBManagment.has_session(i_username))
{
Stack <int> has_added_deck = new Stack <int>()
{
}; //here it will store the return value of each card from the method has_specific card to see if the player has the card
if (cards_id.Count == 4)
{
foreach (string card in cards_id)
{
has_added_deck.Push(DBManagment.Has_Specific_Card(i_username, card));
}
if (!has_added_deck.Contains(0))
{
if (!Has_Deck(i_username)) // if he doesn't have a deck, just inserting the 4 cards in the deck
{
foreach (string card in cards_id)
{
using var con = new NpgsqlConnection(DBManagment.cs);
con.Open();
var sql_insert = "Insert into deck (card_id, username) values (@card_id, @username)";
using var cmd = new NpgsqlCommand(sql_insert, con);
//prepared statment
cmd.Parameters.AddWithValue("card_id", card);
cmd.Parameters.AddWithValue("username", i_username);
cmd.Prepare();
//
cmd.ExecuteNonQuery();
con.Close();
}
return(0);
}
else // if he has a deck, the old one is getting deleted and the new ones are getting inserted
{
//Delete the old cards
using var con = new NpgsqlConnection(DBManagment.cs);
con.Open();
var sql_delete = "delete from deck where username = @username";
using var cmd2 = new NpgsqlCommand(sql_delete, con);
//prepared statment
cmd2.Parameters.AddWithValue("username", i_username);
cmd2.Prepare();
//
cmd2.ExecuteNonQuery();
con.Close();
//////////////////////////
//insert the new cards
foreach (string card in cards_id)
{
using var con2 = new NpgsqlConnection(DBManagment.cs);
con.Open();
var sql_insert2 = "Insert into deck (card_id, username) values (@card_id, @username)";
using var cmd3 = new NpgsqlCommand(sql_insert2, con);
//prepared statment
cmd3.Parameters.AddWithValue("card_id", card);
cmd3.Parameters.AddWithValue("username", i_username);
cmd3.Prepare();
//
cmd3.ExecuteNonQuery();
con.Close();
}
return(0);
}
}
else
{
//one or more cards is not obtained by the user
return(3);
}
}
else
{
//must be 4 Cards to create or replace deck!
return(2);
}
}
else
{
// NO session / invalid Token
return(1);
}
}
public static int Add_cards_to_shop(string i_username, string card_id, string card_name, double damage)
{
try
{
if (DBManagment.has_session(i_username) == false) //check if token is valid / has session
{
//throw new Exception("Not logged in / Invalid token");
return(1);
}
if (DBManagment.Check_admin(i_username) == false) // check if has permission (admin)
{
//throw new Exception("Not authorized, please contact an Admin!");
return(2);
}
int count_cards = 0;
var con = new NpgsqlConnection(DBManagment.cs);
con.Open();
var sql_count = "SELECT count (*) from store where card_id = @card_id";
var cmd = new NpgsqlCommand(sql_count, con);
//prepared statments
cmd.Parameters.AddWithValue("card_id", card_id);
cmd.Prepare();
//
NpgsqlDataReader GetCount = cmd.ExecuteReader(); //curser
GetCount.Read();
count_cards = GetCount.GetInt32(0);
GetCount.Close();
if (count_cards == 0) //check if name is unique(no one else with the same name)
{
Card_Type_Elemnt new_cte = Get_type_element(card_name);
var sql_insert = "Insert into store (card_id, name, card_type, elementar_type, damage) values (@card_id, @name, @card_type, @elementar_type, @damage)";
var cmd2 = new NpgsqlCommand(sql_insert, con);
//prepared statment
cmd2.Parameters.AddWithValue("card_id", card_id);
cmd2.Parameters.AddWithValue("name", card_name);
cmd2.Parameters.AddWithValue("card_type", new_cte.type);
cmd2.Parameters.AddWithValue("elementar_type", (ElementarType)Enum.Parse(typeof(ElementarType), new_cte.element));
cmd2.Parameters.AddWithValue("damage", damage);
cmd2.Prepare();
//
cmd2.ExecuteNonQuery();
return(0);
}
else
{
//throw new Exception("Error: Card already exists!");
return(3);
}
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
return(4);
}
}
public static int Acquire_Card(string i_username)
{
try
{
if (DBManagment.has_session(i_username) == false) //check if token is valid / has session
{
//throw new Exception("Not logged in / Invalid token");
return(1);
}
var con = new NpgsqlConnection(DBManagment.cs);
string sql = "Select coins from game_user where username = @username";
var cmd = new NpgsqlCommand(sql, con);
con.Open();
cmd.Parameters.AddWithValue("username", i_username);
cmd.Prepare();
NpgsqlDataReader rdr = cmd.ExecuteReader();
rdr.Read();
int player_coins = rdr.GetInt32(0);
rdr.Close();
if (player_coins >= 5)
{
if (Check_enough_cards_store() == true)
{
//select the store table and creating random numbers that are smaller than the number of cards in store
int number_of_available_cards = 0; // available cards in store
Random rnd = new Random();
int rnum = 0;
for (int i = 0; i < 5; i++) //5 random numbers are generated and the card with the same rownumer is added to the stack of the player (5 as a package)
{
number_of_available_cards = Get_number_of_card_store(); //getting the number of avalable cards each time after deleting one
rnum = rnd.Next(number_of_available_cards);
sql = "select row_number() OVER (ORDER BY card_id) AS row_id, st.* from store st limit 1 offset @num";
var cmd2 = new NpgsqlCommand(sql, con);
cmd2.Parameters.AddWithValue("num", rnum);
NpgsqlDataReader rdr2 = cmd2.ExecuteReader();
//the specific random card
rdr2.Read();
string card_id = rdr2.GetString(4);
string name = rdr2.GetString(1);
string card_type = rdr2.GetString(5);
ElementarType elementar_type = (ElementarType)Enum.Parse(typeof(ElementarType), Convert.ToString(rdr2.GetValue(2)));
double damage = rdr2.GetDouble(3);
rdr2.Close();
//add card to users stack
sql = "insert into all_user_cards (card_id, username, name, card_type, elementar_Type, damage) values (@card_id, @username, @name, @card_type, @elementar_type, @damage)";
var cmd3 = new NpgsqlCommand(sql, con);
cmd3.Parameters.AddWithValue("card_id", card_id);
cmd3.Parameters.AddWithValue("username", i_username);
cmd3.Parameters.AddWithValue("name", name);
cmd3.Parameters.AddWithValue("card_type", card_type);
cmd3.Parameters.AddWithValue("elementar_type", elementar_type);
cmd3.Parameters.AddWithValue("damage", damage);
cmd3.Prepare();
cmd3.ExecuteNonQuery();
////////
//delete from store beacause card is already sold
sql = "Delete from store where card_id = @id";
var cmd4 = new NpgsqlCommand(sql, con);
cmd4.Parameters.AddWithValue("id", card_id);
cmd4.Prepare();
cmd4.ExecuteNonQuery();
}
if (Decreasing_coins_from_user(i_username) == true)
{
return(0);
}
else
{
//throw new Exception("Error: can't decrease users coins");
return(3);
}
}
else
{
//throw new Exception("Error: not enough Cards in Store!");
return(2);
}
}
else
{
//throw new Exception("Error: Not enough Coins!");
return(4);
}
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
return(5);
}
}
