public void Save(List <Level> avatars)
{
Debugger.WriteLine("[M] Starting saving players from memory to database at " + DateTime.Now.ToString());
try
{
using (var context = new Database.ucsdbEntities(m_vConnectionString))
{
context.Configuration.AutoDetectChangesEnabled = false;
context.Configuration.ValidateOnSaveEnabled = false;
int transactionCount = 0;
foreach (Level pl in avatars)
{
lock (pl)
{
var p = context.player.Find(pl.GetPlayerAvatar().GetId());
if (p != null)
{
p.LastUpdateTime = pl.GetTime();
p.AccountStatus = pl.GetAccountStatus();
p.AccountPrivileges = pl.GetAccountPrivileges();
p.Avatar = pl.GetPlayerAvatar().SaveToJSON();
p.GameObjects = pl.SaveToJSON();
context.Entry(p).State = EntityState.Modified;
}
else
{
context.player.Add(
new Database.player
{
PlayerId = pl.GetPlayerAvatar().GetId(),
AccountStatus = pl.GetAccountStatus(),
AccountPrivileges = pl.GetAccountPrivileges(),
LastUpdateTime = pl.GetTime(),
Avatar = pl.GetPlayerAvatar().SaveToJSON(),
GameObjects = pl.SaveToJSON()
}
);
}
}
transactionCount++;
if (transactionCount >= 500)
{
context.SaveChanges();
transactionCount = 0;
}
}
context.SaveChanges();
}
Debugger.WriteLine("[D] Finished saving players from memory to database at " + DateTime.Now.ToString());
}
catch (Exception ex)
{
Console.ForegroundColor = ConsoleColor.Red;
Debugger.WriteLine("[W] An exception occured during Save processing for avatars:", ex);
Console.ResetColor();
}
}
public void Save(List <Alliance> alliances)
{
Debugger.WriteLine("[M] Starting saving alliances from memory to database at " + DateTime.Now.ToString());
try
{
using (var context = new Database.ucsdbEntities(m_vConnectionString))
{
context.Configuration.AutoDetectChangesEnabled = false;
context.Configuration.ValidateOnSaveEnabled = false;
int transactionCount = 0;
foreach (Alliance alliance in alliances)
{
lock (alliance)
{
var c = context.clan.Find((int)alliance.GetAllianceId());
if (c != null)
{
c.LastUpdateTime = DateTime.Now;
c.Data = alliance.SaveToJSON();
context.Entry(c).State = EntityState.Modified;
}
else
{
context.clan.Add(
new Database.clan
{
ClanId = alliance.GetAllianceId(),
LastUpdateTime = DateTime.Now,
Data = alliance.SaveToJSON()
}
);
}
}
transactionCount++;
if (transactionCount >= 500)
{
context.SaveChanges();
transactionCount = 0;
}
}
context.SaveChanges();
}
Debugger.WriteLine("[D] Finished saving alliances from memory to database at " + DateTime.Now.ToString());
}
catch (Exception ex)
{
Console.ForegroundColor = ConsoleColor.Red;
Debugger.WriteLine("[W] An exception occured during Save processing for alliances:", ex);
Console.ResetColor();
}
}
public void CreateAccount(Level l)
{
try
{
Debugger.WriteLine("Saving new account to database (player id: " + l.GetPlayerAvatar().GetId() + ")");
using (var db = new Database.ucsdbEntities(m_vConnectionString))
{
db.player.Add(
new Database.player
{
PlayerId = l.GetPlayerAvatar().GetId(),
AccountStatus = l.GetAccountStatus(),
AccountPrivileges = l.GetAccountPrivileges(),
LastUpdateTime = l.GetTime(),
Avatar = l.GetPlayerAvatar().SaveToJSON(),
GameObjects = l.SaveToJSON()
}
);
db.SaveChanges();
}
}
catch (Exception ex)
{
Debugger.WriteLine("An exception occured during CreateAccount processing:", ex);
}
}
public void CreateAccount(Level l)
{
try
{
Debugger.WriteLine("Saving new account to database (player id: " + l.GetPlayerAvatar().GetId() + ")");
using (var db = new Database.ucsdbEntities(m_vConnectionString))
{
db.player.Add(
new Database.player
{
PlayerId = l.GetPlayerAvatar().GetId(),
AccountStatus = l.GetAccountStatus(),
AccountPrivileges = l.GetAccountPrivileges(),
LastUpdateTime = l.GetTime(),
Avatar = l.GetPlayerAvatar().SaveToJSON(),
GameObjects = l.SaveToJSON()
}
);
db.SaveChanges();
}
}
catch (Exception ex)
{
Debugger.WriteLine("An exception occured during CreateAccount processing:", ex);
}
}
public void CreateAlliance(Alliance a)
{
try
{
Debugger.WriteLine("Saving new Alliance to database (alliance id: " + a.GetAllianceId() + ")");
using (var db = new Database.ucsdbEntities(m_vConnectionString))
{
db.clan.Add(
new Database.clan
{
ClanId = a.GetAllianceId(),
LastUpdateTime = DateTime.Now,
Data = a.SaveToJSON()
}
);
db.SaveChanges();
}
}
catch (Exception ex)
{
Debugger.WriteLine("An exception occured during CreateAlliance processing:", ex);
}
}
public void CreateAlliance(Alliance a)
{
try
{
Debugger.WriteLine("Saving new Alliance to database (alliance id: " + a.GetAllianceId() + ")");
using (var db = new Database.ucsdbEntities(m_vConnectionString))
{
db.clan.Add(
new Database.clan
{
ClanId = a.GetAllianceId(),
LastUpdateTime = DateTime.Now,
Data = a.SaveToJSON()
}
);
db.SaveChanges();
}
}
catch (Exception ex)
{
Debugger.WriteLine("An exception occured during CreateAlliance processing:", ex);
}
}
public void Save(List<Alliance> alliances)
{
Debugger.WriteLine("[M] Starting saving alliances from memory to database at " + DateTime.Now.ToString());
try
{
using (var context = new Database.ucsdbEntities(m_vConnectionString))
{
context.Configuration.AutoDetectChangesEnabled = false;
context.Configuration.ValidateOnSaveEnabled = false;
int transactionCount = 0;
foreach (Alliance alliance in alliances)
{
lock (alliance)
{
var c = context.clan.Find((int)alliance.GetAllianceId());
if (c != null)
{
c.LastUpdateTime = DateTime.Now;
c.Data = alliance.SaveToJSON();
context.Entry(c).State = EntityState.Modified;
}
else
{
context.clan.Add(
new Database.clan
{
ClanId = alliance.GetAllianceId(),
LastUpdateTime = DateTime.Now,
Data = alliance.SaveToJSON()
}
);
}
}
transactionCount++;
if (transactionCount >= 500)
{
context.SaveChanges();
transactionCount = 0;
}
}
context.SaveChanges();
}
Debugger.WriteLine("[D] Finished saving alliances from memory to database at " + DateTime.Now.ToString());
}
catch (Exception ex)
{
Console.ForegroundColor = ConsoleColor.Red;
Debugger.WriteLine("[W] An exception occured during Save processing for alliances:", ex);
Console.ResetColor();
}
}
public void Save(List<Level> avatars)
{
Debugger.WriteLine("[M] Starting saving players from memory to database at " + DateTime.Now.ToString());
try
{
using (var context = new Database.ucsdbEntities(m_vConnectionString))
{
context.Configuration.AutoDetectChangesEnabled = false;
context.Configuration.ValidateOnSaveEnabled = false;
int transactionCount = 0;
foreach (Level pl in avatars)
{
lock (pl)
{
var p = context.player.Find(pl.GetPlayerAvatar().GetId());
if (p != null)
{
p.LastUpdateTime = pl.GetTime();
p.AccountStatus = pl.GetAccountStatus();
p.AccountPrivileges = pl.GetAccountPrivileges();
p.Avatar = pl.GetPlayerAvatar().SaveToJSON();
p.GameObjects = pl.SaveToJSON();
context.Entry(p).State = EntityState.Modified;
}
else
{
context.player.Add(
new Database.player
{
PlayerId = pl.GetPlayerAvatar().GetId(),
AccountStatus = pl.GetAccountStatus(),
AccountPrivileges = pl.GetAccountPrivileges(),
LastUpdateTime = pl.GetTime(),
Avatar = pl.GetPlayerAvatar().SaveToJSON(),
GameObjects = pl.SaveToJSON()
}
);
}
}
transactionCount++;
if (transactionCount >= 500)
{
context.SaveChanges();
transactionCount = 0;
}
}
context.SaveChanges();
}
Debugger.WriteLine("[D] Finished saving players from memory to database at " + DateTime.Now.ToString());
}
catch (Exception ex)
{
Console.ForegroundColor = ConsoleColor.Red;
Debugger.WriteLine("[W] An exception occured during Save processing for avatars:", ex);
Console.ResetColor();
}
}
