public static async Task <csgoAccount> getAccountById(int id)
{
if (csgo.accountsManager.csgoAccounts.Count == 0)
{
csgo.accountsManager.csgoAccounts = await csgo.accountsManager.loadAccounts();
}
return(csgo.accountsManager.csgoAccounts.Find(a => a.id == id));
csgoAccount account = new csgoAccount();
await databaseManager.selectQuery($"SELECT * FROM csgoaccounts WHERE id = @id LIMIT 1", delegate(DbDataReader reader) {
account.id = (int)reader["id"];
account.username = (string)reader["username"];
account.password = (string)reader["password"];
account.seller = (string)reader["seller"];
account.date = (DateTime)reader["date"];
account.status = (status)(int)reader["status"];
account.rank = (int)reader["rank"];
account.prime = (bool)reader["prime"];
account.email = (string)reader["email"];
account.emailPassword = (string)reader["emailPassword"];
account.price = (decimal)reader["price"];
account.image = (string)reader["image"];
account.hours = (int)reader["hours"];
account.wins = (int)reader["wins"];
account.description = (string)reader["description"];
account.sellerid = (int)reader["sellerid"];
account.buyer = (string)reader["buyer"];
account.buyerid = (int)reader["buyerid"];
account.image = (string)reader["image"];
account.disputed = (bool)reader["disputed"];
account.ticketId = (int)reader["ticketId"];
}).addValue("@id", id).Execute();
return(account);
}
public static async Task <List <csgoAccount> > loadUserAccounts(string username)
{
if ((DateTime.Now - lastUpdate).TotalSeconds < 15 && !firstTime)
{
return(csgoAccounts.FindAll(account => account.seller == username));
}
await databaseManager.selectQuery($"SELECT * FROM csgoaccounts WHERE seller = @seller", delegate(DbDataReader reader) {
csgoAccount account = new csgoAccount();
account.id = (int)reader["id"];
account.username = (string)reader["username"];
account.password = (string)reader["password"];
account.seller = (string)reader["seller"];
account.date = (DateTime)reader["date"];
account.status = (status)(int)reader["status"];
account.rank = (int)reader["rank"];
account.prime = (bool)reader["prime"];
account.email = (string)reader["email"];
account.emailPassword = (string)reader["emailPassword"];
account.price = (decimal)reader["price"];
account.hours = (int)reader["hours"];
account.disputed = (bool)reader["disputed"];
account.wins = (int)reader["wins"];
account.sellerid = (int)reader["sellerid"];
account.buyer = (string)reader["buyer"];
account.disputed = (bool)reader["disputed"];
account.ticketId = (int)reader["ticketId"];
account.buyerid = (int)reader["buyerid"];
var index = csgoAccounts.FindIndex(a => a.id == account.id);
if (index != -1)
{
csgoAccounts[index] = account;
}
else
{
csgoAccounts.Add(account);
}
}).addValue("@seller", username).Execute();
lastUpdate = DateTime.Now;
firstTime = false;
return(csgoAccounts.FindAll(account => account.seller == username));
}
public static async Task addAccount(csgoAccount account)
{
await databaseManager.updateQuery($"INSERT INTO csgoaccounts (type, seller, sellerid, username, password, rank, price,prime,email, emailPassword, image, steamid64, description, hours,wins)" +
$"VALUES (@type, @seller," +
$" @sellerid," +
$" @username," +
$" @password," +
$" @rank," +
$" @price," +
$" @prime," +
$" @email ," +
$" @emailPassword," +
$" @image, " +
$" @steamid64, " +
$" @description, " +
$" @hours," +
$" @wins)").
addValue("@seller", account.seller)
.addValue("@sellerid", account.sellerid)
.addValue("@username", account.username)
.addValue("@password", account.password)
.addValue("@rank", account.rank)
.addValue("@price", account.price)
.addValue("@prime", account.prime)
.addValue("@email", account.email)
.addValue("@emailPassword", account.emailPassword)
.addValue("@image", account.image)
.addValue("@steamid64", account.steamId64)
.addValue("@description", account.description)
.addValue("@hours", account.hours)
.addValue("@wins", account.wins)
.addValue("@negativeRates", account.negativeRates)
.addValue("@positiveRates", account.positiveRates)
.addValue("@type", (int)account.type)
.Execute();
accountsManager.csgoAccounts.Add(account);
}
public static async Task addRevokedAccount(csgoAccount account, string reason)
{
revokedAccount revokedAccount = new revokedAccount();
revokedAccount.sellerId = account.sellerid;
revokedAccount.seller = account.seller;
revokedAccount.email = account.email;
revokedAccount.username = account.username;
revokedAccount.date = DateTime.Now;
revokedAccount.reason = reason;
await databaseManager.updateQuery($"INSERT INTO revokedaccounts (sellerId, seller, username, email, reason)" +
$"VALUES (@sellerId, @seller, @username, @email, @reason )")
.addValue("@sellerId", account.sellerid)
.addValue("@seller", account.seller)
.addValue("@username", account.username)
.addValue("@email", account.email)
.addValue("@reason", reason)
.Execute();
revokedAccounts.Add(revokedAccount);
lastUpdateRevoked = DateTime.Now;
}
public static async Task <List <csgoAccount> > loadAccounts(bool shop = false, bool admin = false)
{
if (admin)
{
var temp = new List <csgoAccount> ();
await databaseManager.selectQuery($"SELECT * FROM csgoaccounts", delegate(DbDataReader reader) {
csgoAccount account = new csgoAccount();
account.id = (int)reader["id"];
account.username = (string)reader["username"];
account.password = (string)reader["password"];
account.seller = (string)reader["seller"];
account.date = (DateTime)reader["date"];
account.status = (status)(int)reader["status"];
account.rank = (int)reader["rank"];
account.image = (string)reader["image"];
account.prime = (bool)reader["prime"];
account.price = (decimal)reader["price"];
account.sellerid = (int)reader["sellerid"];
account.buyer = (string)reader["buyer"];
account.disputed = (bool)reader["disputed"];
account.ticketId = (int)reader["ticketId"];
account.buyerid = (int)reader["buyerid"];
account.image = (string)reader["image"];
account.steamId64 = (string)reader["steamid64"];
account.description = (string)reader["description"];
temp.Add(account);
}).Execute();
return(temp);
}
if ((DateTime.Now - lastUpdate).TotalSeconds < 15 && !firstTime)
{
return(csgoAccounts);
}
csgoAccounts.Clear();
await databaseManager.selectQuery($"SELECT * FROM csgoaccounts", delegate(DbDataReader reader) {
csgoAccount account = new csgoAccount();
account.id = (int)reader["id"];
account.username = (string)reader["username"];
account.password = (string)reader["password"];
account.seller = (string)reader["seller"];
account.sellerid = (int)reader["sellerid"];
account.date = (DateTime)reader["date"];
account.status = (status)(int)reader["status"];
account.rank = (int)reader["rank"];
account.hours = (int)reader["hours"];
account.wins = (int)reader["wins"];
account.prime = (bool)reader["prime"];
account.price = (decimal)reader["price"];
account.description = (string)reader["description"];
account.image = (string)reader["image"];
account.email = (string)reader["email"];
account.emailPassword = (string)reader["emailPassword"];
account.steamId64 = (string)reader["steamid64"];
account.lastUpdate = DateTime.Now;
account.buyer = (string)reader["buyer"];
account.buyerid = (int)reader["buyerid"];
account.disputed = (bool)reader["disputed"];
account.image = (string)reader["image"];
account.positiveRates = (int)reader["positiveRates"];
account.negativeRates = (int)reader["negativeRates"];
account.gameList = (string)reader["gameList"];
account.title = (string)reader["title"];
account.type = (csgo.type)(int) reader["type"];
account.ticketId = (int)reader["ticketId"];
var index = csgoAccounts.FindIndex(a => a.id == account.id);
if (index != -1)
{
csgoAccounts[index] = account;
}
else
{
csgoAccounts.Add(account);
}
}).Execute();
lastUpdate = DateTime.Now;
firstTime = false;
return(csgoAccounts);
}
