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); }