/// <summary>
/// Saves the specified player in the specified database.
/// </summary>
/// <param name="Player">The player.</param>
/// <param name="DBMS">The DBMS.</param>
internal void Save(Player Player, DBMS DBMS = Constants.Database)
{
return;
switch (DBMS)
{
case DBMS.MySQL:
{
using (GRS_MySQL Database = new GRS_MySQL())
{
Core.Database.Models.Players Data = Database.Players.Find(Player.HighID, Player.LowID);
if (Data != null)
{
Data.HighID = Player.HighID;
Data.LowID = Player.LowID;
Data.Data = JsonConvert.SerializeObject(Player, this.Settings);
}
Database.SaveChangesAsync();
}
break;
}
case DBMS.Redis:
{
Redis.Players.StringSetAsync(Player.ToString(), JsonConvert.SerializeObject(Player, this.Settings), TimeSpan.FromMinutes(30));
break;
}
case DBMS.Both:
{
this.Save(Player, DBMS.MySQL);
this.Save(Player, DBMS.Redis);
break;
}
case DBMS.File:
{
File.WriteAllText(Directory.GetCurrentDirectory() + "\\Saves\\Players\\" + Player + ".json", JsonConvert.SerializeObject(Player, this.Settings));
break;
}
}
}
/// <summary>
/// Deletes the specified player in the specified database.
/// </summary>
/// <param name="HighID">The high identifier.</param>
/// <param name="LowID">The low identifier.</param>
/// <param name="DBMS">The DBMS.</param>
internal void Delete(int HighID, int LowID, DBMS DBMS = Constants.Database)
{
switch (DBMS)
{
case DBMS.MySQL:
{
using (GBS_MySQL Database = new GBS_MySQL())
{
Core.Database.Models.Players Data = Database.Players.Find(HighID, LowID);
if (Data != null)
{
Database.Players.Remove(Data);
}
else
{
Logging.Error(this.GetType(), "Data was null when deleting a player in the MySQL Database.");
}
Database.SaveChangesAsync();
}
break;
}
case DBMS.Redis:
{
Redis.Players.KeyDeleteAsync(HighID + "-" + LowID);
break;
}
case DBMS.Both:
{
this.Delete(HighID, LowID, DBMS.MySQL);
this.Delete(HighID, LowID, DBMS.Redis);
break;
}
case DBMS.File:
{
File.Delete(Directory.GetCurrentDirectory() + "\\Saves\\Players\\" + HighID + "-" + LowID + ".json");
break;
}
}
}
/// <summary>
/// Deletes the specified player in the specified database.
/// </summary>
/// <param name="Player">The player.</param>
/// <param name="DBMS">The DBMS.</param>
internal void Delete(Player Player, DBMS DBMS = Constants.Database)
{
switch (DBMS)
{
case DBMS.MySQL:
{
using (GRS_MySQL Database = new GRS_MySQL())
{
Core.Database.Models.Players Data = Database.Players.Find(Player.HighID, Player.LowID);
if (Data != null)
{
Database.Players.Remove(Data);
}
Database.SaveChangesAsync();
}
break;
}
case DBMS.Redis:
{
Redis.Players.KeyDeleteAsync(Player.ToString());
break;
}
case DBMS.Both:
{
this.Delete(Player, DBMS.MySQL);
this.Delete(Player, DBMS.Redis);
break;
}
case DBMS.File:
{
File.Delete(Directory.GetCurrentDirectory() + "\\Saves\\Players\\" + Player + ".json");
break;
}
}
}
/// <summary>
/// Gets the player using the specified identifier in the specified database.
/// </summary>
/// <param name="HighID">The high identifier.</param>
/// <param name="LowID">The low identifier.</param>
/// <param name="DBMS">The DBMS.</param>
/// <param name="Store">if set to <c>true</c> [store].</param>
internal Player Get(int HighID, int LowID, DBMS DBMS = Constants.Database, bool Store = true)
{
if (!this.ContainsKey((HighID, LowID).ToInt64()))
{
Player Player = null;
switch (DBMS)
{
case DBMS.MySQL:
{
using (GRS_MySQL Database = new GRS_MySQL())
{
Core.Database.Models.Players Data = Database.Players.Find(HighID, LowID);
if (Data != null)
{
if (!string.IsNullOrEmpty(Data.Data))
{
Player = new Player(null, HighID, LowID);
JsonConvert.PopulateObject(Data.Data, Player, this.Settings);
if (Store)
{
this.Add(Player);
}
}
}
}
break;
}
case DBMS.Redis:
{
string Data = Redis.Players.StringGet(HighID + "-" + LowID).ToString();
if (!string.IsNullOrEmpty(Data))
{
Player = new Player(null, HighID, LowID);
JsonConvert.PopulateObject(Data, Player, this.Settings);
if (Store)
{
this.Add(Player);
}
}
break;
}
case DBMS.Both:
{
Player = this.Get(HighID, LowID, DBMS.Redis, Store);
if (Player == null)
{
Player = this.Get(HighID, LowID, DBMS.MySQL, Store);
if (Player != null)
{
this.Save(Player, DBMS.Redis);
}
}
break;
}
case DBMS.File:
{
if (File.Exists(Directory.GetCurrentDirectory() + "\\Saves\\Players\\" + HighID + "-" + LowID + ".json"))
{
string JSON = File.ReadAllText(Directory.GetCurrentDirectory() + "\\Saves\\Players\\" + HighID + "-" + LowID + ".json");
if (!string.IsNullOrWhiteSpace(JSON))
{
Player = new Player(null, HighID, LowID);
JsonConvert.PopulateObject(JSON, Player, this.Settings);
}
}
break;
}
}
return(Player);
}
return(this[LowID]);
}
