public static Error AddPlayer(String uid, String name, PersonDb db, String steamID = "", int points = 0)
{
CasinoPlayer tempPlayer = new CasinoPlayer {
Id = uid, Name = name, Points = points, SteamID64 = steamID
};
if (IsRegistered(tempPlayer, db).GetAwaiter().GetResult())
{
return(Error.DUPLICATE);
}
if (db.Players.Where(p => p.Name.ToLower() == tempPlayer.Name.ToLower()) == null)
{
return(Error.INVALIDNAME);
}
db.Players.Add(tempPlayer);
int savedCount = db.SaveChanges();
if (savedCount < 1)
{
return(Error.SAVEERROR);
}
//Console.WriteLine("{0} records saved to database", savedCount);
return(Error.OK);
}
public static int GetPlayerCount()
{
using (PersonDb db = new PersonDb())
{
return(db.Players.Count());
}
}
public static Error ChangePlayer(String uid, PersonDb db, String name = "", String steamID = "")
{
CasinoPlayer player = GetPlayer(uid, db);
if (player == null)
{
return(Error.NOTFOUND);
}
if (name != "")
{
player.Name = name;
}
if (steamID != "")
{
player.SteamID64 = steamID;
}
if (db.SaveChanges() < 1)
{
return(Error.SAVEERROR);
}
return(Error.OK);
}
public static Error SaveChanges(PersonDb db)
{
if (db.SaveChanges() < 1)
{
return(Error.SAVEERROR);
}
return(Error.OK);
}
public static bool SetPoints(CasinoPlayer player, int amount, PersonDb db)
{
if (amount < 0)
{
return(false);
}
//db.Players.Find(player.Id).Points = amount;
player.Points = amount;
return(true);
}
public static Error SaveChanges()
{
using (PersonDb db = new PersonDb())
{
if (db.SaveChanges() < 1)
{
return(Error.SAVEERROR);
}
return(Error.OK);
}
}
public static Error UpdateDaily(String uid, int amount, PersonDb db)
{
db.Players.Find(uid).Points += amount;
db.Players.Find(uid).LastDaily = DateTime.Now;
if (db.SaveChanges() < 1)
{
return(Error.SAVEERROR);
}
return(Error.OK);
}
public static List <CasinoPlayer> GetPlayerList(int index = 0, int endIndex = 0, String name = "N/A", bool fuzzy = false, bool hide = true)
{
using (PersonDb db = new PersonDb())
{
List <CasinoPlayer> playerList = new List <CasinoPlayer>();
if (name == "N/A")
{
//PersonDb db = PersonDb.Instance;
List <CasinoPlayer> shittyList = db.Players.ToList().OrderByDescending(p => p.Points).ToList();
endIndex = endIndex > db.Players.Count() - 1 ? db.Players.Count() : endIndex;
for (int i = index; i < (endIndex >= 1 ? endIndex : db.Players.Count()); i++)
{
if (shittyList[i].Id.Length == 28 || !hide)
{
playerList.Add(shittyList[i]);
}
}
return(playerList);
}
else if (!fuzzy)
{
if (hide)
{
return(db.Players.Where(p => p.Name.Equals(name) && p.Id.Length == 28).ToList());
}
else
{
return(db.Players.Where(p => p.Name.Equals(name)).ToList());
}
}
else
{
if (hide)
{
return(db.Players.Where(p => p.Name.Contains(name) && p.Id.Length == 28).ToList());
}
else
{
return(db.Players.Where(p => p.Name.Contains(name)).ToList());
}
}
}
}
public static Error DeletePlayer(String uid, PersonDb db)
{
CasinoPlayer player = GetPlayer(uid, db);
if (player == null)
{
return(Error.NOTFOUND);
}
db.Players.Remove(player);
int savedCount = db.SaveChanges();
if (savedCount < 1)
{
return(Error.SAVEERROR);
}
return(Error.OK);
}
public static ConnectionResult CheckConnection()
{
try
{
using (PersonDb db = new PersonDb())
{
db.Players.Count();
}
}
catch (MySql.Data.MySqlClient.MySqlException e)
{
Console.WriteLine(e.Message);
return(ConnectionResult.SQLERROR);
}
catch (Exception e)
{
Console.WriteLine(e);
return(ConnectionResult.UNKNOWN);
}
return(ConnectionResult.OK);
}
public static CasinoPlayer GetPlayer(String uid, PersonDb db)
{
return(db.Players.Find(uid));
// TODO: Catch "MySql.Data.MySqlClient.MySqlException" and make it known in shit'n'stuff
}
public static async Task <bool> IsRegistered(String uid, PersonDb db)
{
return((await db.Players.FindAsync(uid)) != null);
}
public static async Task <bool> IsRegistered(CasinoPlayer myPlayer, PersonDb db)
{
return((await db.Players.FindAsync(myPlayer.Id)) != null);
}