public GameFamily UpdateOrCreate(GameFamily entity)
{
SetupUpdateOrCreate(entity);
GameFamily existing;
using (var db = new Db())
{
existing = db.Set <GameFamily>().Find(entity.gameFamilyID);
}
if (existing == null)
{
//-- Insert --
entity = Create(entity);
entity.dateAdded = DateTime.UtcNow;
}
else
{
//-- Update --
entity.dateLastUpdated = DateTime.UtcNow;
using (var db = new Db())
{
db.Entry(entity).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
return(entity);
}
public GameFamily UpdateOrCreate(GameFamily I)
{
if (I.gameFamilyID == 0)
{
I.gameFamilyID = 1;
}
return(I);
}
public void TestInitialize()
{
_testTransactionScope = new TransactionScope();
Target = new GameFamiliesAccessor();
CreatedDataContractInstance = new GameFamily();
_record = Staging.CreateTestGameFamily();
}
public static GameFamily CreateTestGameFamily()
{
var returnGameFamily = new GameFamily
{
name = "Test Game Family",
addedBy = "Chris",
isActive = 1
};
return(returnGameFamily);
}
private static ConnectParam WindowsConnecton(GameFamily game)
{
return(new ConnectParam
{
FamilyGame = game,
SshIp = Localhost,
SshPort = 22,
SshUserName = "******",
SshPassword = "******",
Path = "/host"
});
}
public GameFamily Create(GameFamily entity)
{
entity.dateAdded = DateTime.UtcNow;
entity.dateLastUpdated = DateTime.UtcNow;
using (var db = new Db())
{
db.Set <GameFamily>().Add(entity);
db.SaveChanges();
}
return(entity);
}
private static ConnectParam LinuxConnecton(GameFamily game)
{
var res = new ConnectParam
{
FamilyGame = game,
SshIp = LinuxSrvIp,
SshPort = 22,
//SshUserName = "******",
//SshPassword = "******",
Path = "/host",
//SshPort = 20002,
SshUserName = "******",
SshPassword = "******",
GameServerId = "1002"
//Path = "/home/vncuser/host"
};
return(res);
}
public void SetupUpdateOrCreate(GameFamily entity)
{
//Logger.Log(string.Format(Properties.Resources.Accessors_Updating, typeof(ReportRecord).Name, entity.Id), TraceEventType.Verbose);
}
public GameFamily Create(GameFamily I)
{
I.gameFamilyID = 1;
return(I);
}
private void InitRecords()
{
_record = Staging.CreateTestGameFamily();
}
public void RemoveEntities()
{
DbHelper v_DbHelper = DbHelper.Instance;
ILog v_Logger = LogManager.GetLogger("RemoveEntities");
// Create some entries
GameFamily v_TempFamily = new GameFamily("TestGameFamily1");
v_DbHelper.LiveBglDb.GameFamilies.Add(v_TempFamily);
v_DbHelper.LiveBglDb.Games.Add(new Game("TestGame01", 2, 4, DbClasses.Game.GameType.VictoryPoints, v_TempFamily.Id));
v_DbHelper.LiveBglDb.Games.Add(new Game("TestGame02", 2, 4, DbClasses.Game.GameType.VictoryPoints, v_TempFamily.Id));
// Try to remove the referenced GameFamily.
BglDb.EntityInteractionStatus v_ActualEntitiyStatus = v_DbHelper.LiveBglDb.RemoveEntity(v_TempFamily);
Assert.AreEqual(BglDb.EntityInteractionStatus.NotRemoved, v_ActualEntitiyStatus);
// Create another GameFamily but don't reference it.
v_TempFamily = new GameFamily("TestGameFamily2");
v_DbHelper.LiveBglDb.GameFamilies.Add(v_TempFamily);
// By now we expect two GameFamily items.
Assert.AreEqual(2, v_DbHelper.LiveBglDb.GameFamilies.Count);
Assert.AreEqual(2, v_DbHelper.LiveBglDb.GameFamiliesById.Count);
// Remove the unreferenced GameFamily.
v_ActualEntitiyStatus = v_DbHelper.LiveBglDb.RemoveEntity(v_TempFamily);
Assert.AreEqual(BglDb.EntityInteractionStatus.Removed, v_ActualEntitiyStatus);
// There must only be the referenced GameFamily.
Assert.AreEqual(1, v_DbHelper.LiveBglDb.GameFamilies.Count);
Assert.AreEqual(1, v_DbHelper.LiveBglDb.GameFamiliesById.Count);
// Add some new Players.
v_ActualEntitiyStatus = v_DbHelper.LiveBglDb.AddEntity(new Player("P. Layer 01", Player.Genders.Male));
Assert.AreEqual(BglDb.EntityInteractionStatus.Added, v_ActualEntitiyStatus);
v_ActualEntitiyStatus = v_DbHelper.LiveBglDb.AddEntity(new Player("P. Layer 02", Player.Genders.Male));
Assert.AreEqual(BglDb.EntityInteractionStatus.Added, v_ActualEntitiyStatus);
v_ActualEntitiyStatus = v_DbHelper.LiveBglDb.AddEntity(new Player("P. Layer 03", Player.Genders.Male));
Assert.AreEqual(BglDb.EntityInteractionStatus.Added, v_ActualEntitiyStatus);
v_ActualEntitiyStatus = v_DbHelper.LiveBglDb.AddEntity(new Player("P. Layer 04", Player.Genders.Male));
Assert.AreEqual(BglDb.EntityInteractionStatus.Added, v_ActualEntitiyStatus);
v_ActualEntitiyStatus = v_DbHelper.LiveBglDb.AddEntity(new Player("P. Layer 05", Player.Genders.Male));
Assert.AreEqual(BglDb.EntityInteractionStatus.Added, v_ActualEntitiyStatus);
Assert.AreEqual(5, v_DbHelper.LiveBglDb.Players.Count);
Assert.AreEqual(5, v_DbHelper.LiveBglDb.PlayersById.Count);
ObservableCollection <Score> v_Scores = new ObservableCollection <Score>
{
{ new Score(v_DbHelper.LiveBglDb.Players[0].Id, "10", true) },
{ new Score(v_DbHelper.LiveBglDb.Players[1].Id, "8", false) },
{ new Score(v_DbHelper.LiveBglDb.Players[2].Id, "7", false) },
{ new Score(v_DbHelper.LiveBglDb.Players[3].Id, "4", false) }
};
Assert.AreEqual(0, v_DbHelper.LiveBglDb.Locations.Count);
Location v_Location1 = new Location("Test Location 01");
v_DbHelper.LiveBglDb.Locations.Add(v_Location1);
Location v_Location2 = new Location("Test Location 02");
v_DbHelper.LiveBglDb.Locations.Add(v_Location2);
Assert.AreEqual(2, v_DbHelper.LiveBglDb.Locations.Count);
Assert.AreEqual(2, v_DbHelper.LiveBglDb.LocationsById.Count);
v_DbHelper.LiveBglDb.Results.Add(new Result(v_DbHelper.LiveBglDb.Games[0].Id, v_Scores, new DateTime(2017, 08, 22), v_Location2.Id));
v_ActualEntitiyStatus = v_DbHelper.LiveBglDb.RemoveEntity(v_DbHelper.LiveBglDb.Players[0]);
Assert.AreEqual(BglDb.EntityInteractionStatus.NotRemoved, v_ActualEntitiyStatus);
v_ActualEntitiyStatus = v_DbHelper.LiveBglDb.RemoveEntity(v_DbHelper.LiveBglDb.Players[1]);
Assert.AreEqual(BglDb.EntityInteractionStatus.NotRemoved, v_ActualEntitiyStatus);
Assert.AreEqual(5, v_DbHelper.LiveBglDb.Players.Count);
Assert.AreEqual(5, v_DbHelper.LiveBglDb.PlayersById.Count);
v_ActualEntitiyStatus = v_DbHelper.LiveBglDb.RemoveEntity(v_DbHelper.LiveBglDb.Players[4]);
Assert.AreEqual(BglDb.EntityInteractionStatus.Removed, v_ActualEntitiyStatus);
Assert.AreEqual(4, v_DbHelper.LiveBglDb.Players.Count);
Assert.AreEqual(4, v_DbHelper.LiveBglDb.PlayersById.Count);
v_Logger.Info(String.Format("Removing [{0}], expecting [{1}]", v_DbHelper.LiveBglDb.Games[0].Name, BglDb.EntityInteractionStatus.NotRemoved));
v_ActualEntitiyStatus = v_DbHelper.LiveBglDb.RemoveEntity(v_DbHelper.LiveBglDb.Games[0]);
Assert.AreEqual(BglDb.EntityInteractionStatus.NotRemoved, v_ActualEntitiyStatus);
Assert.AreEqual(2, v_DbHelper.LiveBglDb.Games.Count);
Assert.AreEqual(2, v_DbHelper.LiveBglDb.GamesById.Count);
v_Logger.Info(String.Format("Removing [{0}], expecting [{1}]", v_DbHelper.LiveBglDb.Games[1].Name, BglDb.EntityInteractionStatus.Removed));
v_ActualEntitiyStatus = v_DbHelper.LiveBglDb.RemoveEntity(v_DbHelper.LiveBglDb.Games[1]);
Assert.AreEqual(BglDb.EntityInteractionStatus.Removed, v_ActualEntitiyStatus);
Assert.AreEqual(1, v_DbHelper.LiveBglDb.Games.Count);
Assert.AreEqual(1, v_DbHelper.LiveBglDb.GamesById.Count);
v_Logger.Info(String.Format("Removing [{0}], expecting [{1}]", v_Location2.Name, BglDb.EntityInteractionStatus.NotRemoved));
v_ActualEntitiyStatus = v_DbHelper.LiveBglDb.RemoveEntity(v_Location2);
Assert.AreEqual(BglDb.EntityInteractionStatus.NotRemoved, v_ActualEntitiyStatus);
Assert.AreEqual(2, v_DbHelper.LiveBglDb.Locations.Count);
Assert.AreEqual(2, v_DbHelper.LiveBglDb.LocationsById.Count);
v_Logger.Info(String.Format("Removing [{0}], expecting [{1}]", v_Location1.Name, BglDb.EntityInteractionStatus.NotRemoved));
v_ActualEntitiyStatus = v_DbHelper.LiveBglDb.RemoveEntity(v_Location1);
Assert.AreEqual(BglDb.EntityInteractionStatus.Removed, v_ActualEntitiyStatus);
Assert.AreEqual(1, v_DbHelper.LiveBglDb.Locations.Count);
Assert.AreEqual(1, v_DbHelper.LiveBglDb.LocationsById.Count);
}
