static public void Delete(System.Int32 autoKey, esSqlAccessType sqlAccessType) { var obj = new CustomFieldsServer(); obj.AutoKey = autoKey; obj.AcceptChanges(); obj.MarkAsDeleted(); obj.Save(sqlAccessType); }
public void ServerSide() { int keyId = -1; CustomFieldsServerCollection coll = new CustomFieldsServerCollection(); switch (coll.es.Connection.ProviderSignature.DataProviderName) { case "EntitySpaces.EffiProzProvider": Assert.Ignore("Not implemented"); break; default: using (esTransactionScope scope = new esTransactionScope()) { // Setup CustomFieldsServer entity = new CustomFieldsServer(); entity = new CustomFieldsServer(); entity.FirstName = "Test"; entity.LastName = "One"; // Insert entity.Save(); keyId = entity.AutoKey.Value; Assert.AreEqual(entity.FirstName, "Test"); Assert.AreEqual(entity.LastName, "One"); Assert.AreEqual(entity.Age.Value, 10); Assert.AreEqual(entity.DateAdded.Value.Day, DateTime.UtcNow.Day); Assert.AreEqual(entity.DateModified.Value.Day, DateTime.UtcNow.Day); Assert.AreEqual(entity.AddedBy, "CustomUser"); Assert.AreEqual(entity.ModifiedBy, "CustomUser"); Assert.AreEqual(entity.EsVersion.Value, 1); // Update entity = new CustomFieldsServer(); entity.LoadByPrimaryKey(keyId); Assert.AreEqual(entity.FirstName, "Test"); Assert.AreEqual(entity.LastName, "One"); Assert.AreEqual(entity.Age.Value, 10); Assert.AreEqual(entity.DateAdded.Value.Day, DateTime.UtcNow.Day); Assert.AreEqual(entity.DateModified.Value.Day, DateTime.UtcNow.Day); Assert.AreEqual(entity.AddedBy, "CustomUser"); Assert.AreEqual(entity.ModifiedBy, "CustomUser"); Assert.AreEqual(entity.EsVersion.Value, 1); DateTime modified = entity.DateModified.Value; entity.LastName = "Two"; System.Threading.Thread.Sleep(4); entity.Save(); Assert.AreEqual(entity.FirstName, "Test"); Assert.AreEqual(entity.LastName, "Two"); Assert.AreEqual(entity.Age.Value, 10); Assert.AreEqual(entity.DateAdded.Value.Day, DateTime.UtcNow.Day); Assert.AreEqual(entity.DateModified.Value.Day, DateTime.UtcNow.Day); Assert.Greater(entity.DateModified.Value, modified); Assert.AreEqual(entity.AddedBy, "CustomUser"); Assert.AreEqual(entity.ModifiedBy, "CustomUser"); Assert.AreEqual(entity.EsVersion.Value, 2); // No Update entity = new CustomFieldsServer(); entity.LoadByPrimaryKey(keyId); DateTime added = entity.DateAdded.Value; modified = entity.DateModified.Value; entity.Save(); Assert.AreEqual(entity.FirstName, "Test"); Assert.AreEqual(entity.LastName, "Two"); Assert.AreEqual(entity.Age.Value, 10); Assert.AreEqual(entity.DateAdded.Value, added); Assert.AreEqual(entity.DateModified.Value, modified); Assert.AreEqual(entity.AddedBy, "CustomUser"); Assert.AreEqual(entity.ModifiedBy, "CustomUser"); Assert.AreEqual(entity.EsVersion.Value, 2); // Clean up entity = new CustomFieldsServer(); entity.LoadByPrimaryKey(keyId); Assert.AreEqual(entity.FirstName, "Test"); Assert.AreEqual(entity.LastName, "Two"); Assert.AreEqual(entity.Age.Value, 10); Assert.AreEqual(entity.DateAdded.Value, added); Assert.AreEqual(entity.DateModified.Value, modified); Assert.AreEqual(entity.AddedBy, "CustomUser"); Assert.AreEqual(entity.ModifiedBy, "CustomUser"); Assert.AreEqual(entity.EsVersion.Value, 2); entity.MarkAsDeleted(); entity.Save(); entity = new CustomFieldsServer(); if (entity.LoadByPrimaryKey(keyId)) { Assert.Fail("Not deleted"); } } break; } }