/// <summary>
/// Use Entity Framework In outpostDB to lookup playerid
/// </summary>
/// <param name="CLSID"></param>
/// <returns></returns>
public static int LookupPlayerIDbyCSLID(string CLSID)
{
outpostwarsEntities entities = new outpostwarsEntities();
Player player = (Player)entities.Players
.Where(b => b.CLSID == CLSID)
.FirstOrDefault();
return(player.id);
}
public bool CreatePlayer(Player newPlayer)
{
// Build a generic character name
if (newPlayer.characterName == null)
{
newPlayer.characterName = "Monkey" + CommonTools.RandomString(9); // Max 15
}
// Set First Name / Last name
newPlayer.firstName = "Space";
newPlayer.lastName = "Monkey";
// Random String - not implemented
if (newPlayer.passwordResetHash == null)
{
newPlayer.passwordResetHash = CommonTools.RandomString(64);
}
// Set Current Time
newPlayer.createdAtTimestamp = DateTime.Now;
// Set Last Update Time
newPlayer.updatedAtTimestamp = DateTime.Now;
// Set Last Login Time
newPlayer.lastLoginTimestamp = DateTime.Now;
if (newPlayer.enabled == null)
{
newPlayer.enabled = true;
}
// Not In Alliance = -1
if (newPlayer.allianceID == 0)
{
newPlayer.allianceID = -1;
}
try
{
outpostwarsdb.outpostwarsEntities entities = new outpostwarsEntities();
// Add tew New Player into the player Collection
entities.Players.Add(newPlayer);
return(entities.SaveChanges() == 1);
}
catch (DbEntityValidationException ex)
{
LogCriticalError(ex);
}
// Only hapens if problem
return(false);
}
public bool CreateStatType(StatType statType)
{
outpostwarsEntities entities = new outpostwarsEntities();
try
{
// Add tew New Player into the player Collection
entities.StatTypes.Add(statType);
// Save changes
return(entities.SaveChanges() == 1);
}
catch (DbEntityValidationException ex)
{
LogCriticalError(ex);
}
return(false);
}
public bool CreateShipsRemainingLineItem(ShipsRemainingLineItem shipsRemainingLineItem)
{
outpostwarsEntities entities = new outpostwarsEntities();
try
{
// Add tew New Player into the player Collection
entities.ShipsRemainingLineItems.Add(shipsRemainingLineItem);
// Save changes
return(entities.SaveChanges() == 1);
}
catch (DbEntityValidationException ex)
{
LogCriticalError(ex);
}
return(false);
}
public bool CreateAllianceMember(AllianceMember allianceMember)
{
outpostwarsEntities entities = new outpostwarsEntities();
try
{
// Add tew New Player into the player Collection
entities.AllianceMembers.Add(allianceMember);
// Save changes
return(entities.SaveChanges() == 1);
}
catch (DbEntityValidationException ex)
{
LogCriticalError(ex);
}
return(false);
}
public bool CreateResearchCompleted(ResearchCompleted researchCompleted)
{
outpostwarsEntities entities = new outpostwarsEntities();
try
{
// Add tew New Player into the player Collection
entities.ResearchCompleteds.Add(researchCompleted);
// Save changes
return(entities.SaveChanges() == 1);
}
catch (DbEntityValidationException ex)
{
LogCriticalError(ex);
}
return(false);
}
public bool CreateFleetBuilding(FleetBuilding fleetBuilding)
{
outpostwarsEntities entities = new outpostwarsEntities();
try
{
// Add tew New Player into the player Collection
entities.FleetBuildings.Add(fleetBuilding);
// Save changes
return(entities.SaveChanges() == 1);
}
catch (DbEntityValidationException ex)
{
LogCriticalError(ex);
}
return(false);
}
public bool CreateBannedUserAgent(BannedUserAgent bannedUserAgent)
{
outpostwarsEntities entities = new outpostwarsEntities();
try
{
// Add tew New Player into the player Collection
entities.BannedUserAgents.Add(bannedUserAgent);
// Save changes
return(entities.SaveChanges() == 1);
}
catch (DbEntityValidationException ex)
{
LogCriticalError(ex);
}
return(false);
}
/// <summary>
/// A Common Method for Passing Critical Errors to Database
///
/// </summary>
/// <param name="ex">DbEntityValidationException</param>
public void LogCriticalError(DbEntityValidationException ex)
{
// Create an entity of error
outpostwarsEntities entities = new outpostwarsEntities();
CriticalError error = new CriticalError();
if (ex.Data != null)
{
error.Data = (string)ex.Data.ToString();
}
else
{
error.Data = " ";
}
if (error.HelpLink != null)
{
error.HelpLink = (string)ex.HelpLink.ToString();
}
else
{
error.HelpLink = " ";
}
if (error.EntityValidationErrors != null)
{
error.EntityValidationErrors = (string)ex.EntityValidationErrors.ToString();
}
else
{
error.EntityValidationErrors = " ";
}
if (error.InnerException != null)
{
error.InnerException = (string)ex.InnerException.ToString();
}
else
{
error.InnerException = " ";
}
if (error.Message != null)
{
error.Message = (string)ex.Message.ToString();
}
else
{
error.Message = " ";
}
if (error.Source != null)
{
error.Source = (string)ex.Source.ToString();
}
else
{
error.Source = " ";
}
if (error.StackTrace != null)
{
error.StackTrace = (string)ex.StackTrace.ToString();
}
else
{
error.StackTrace = " ";
}
if (error.TargetSite != null)
{
error.TargetSite = (string)ex.TargetSite.ToString();
}
else
{
error.TargetSite = " ";
}
// Add it to be saved
entities.CriticalErrors.Add(error);
// Now to save it
entities.SaveChanges();
}
