public void CreateEF7DBContext()
{
using (var db = new EntityFramework7DBContext(Ef.Configuration["Data:DefaultConnection:ConnectionString"]))
{
}
}
public void PrepareEF7Database()
{
TempItems.Clear();
TempEntity.Clear();
TempField.Clear();
using (var db = new EntityFramework7DBContext(Configuration["Data:DefaultConnection:ConnectionString"]))
using (db.BeginTransaction())
{
Core.Models.Db.Item NewItem = new Core.Models.Db.Item()
{
ItemTypeID = TestItemType.User.Value,
IsDeleted = false,
Guid = Guid.NewGuid(),
TenantID = 1,
};
db.Items.Add(NewItem);
db.SaveChanges();
Entity NewEntity1 = new Entity()
{
EffectiveDate = new DateTime(2015, 1, 1),
EndEffectiveDate = null,
ItemID = NewItem.ItemID.Value,
EntityTypeID = TestEntityType.General_Info,
IsDeleted = false,
Guid = Guid.NewGuid(),
CreateDate = DateTime.Now,
TenantID = 1,
};
Entity NewEntity2 = new Entity()
{
EffectiveDate = new DateTime(2015, 1, 1),
EndEffectiveDate = new DateTime(2015, 2, 1),
ItemID = NewItem.ItemID.Value,
EntityTypeID = TestEntityType.User_Role,
IsDeleted = false,
Guid = Guid.NewGuid(),
CreateDate = DateTime.Now,
TenantID = 1,
};
Entity NewEntity3 = new Entity()
{
EffectiveDate = new DateTime(2015, 2, 1),
EndEffectiveDate = null,
ItemID = NewItem.ItemID.Value,
EntityTypeID = TestEntityType.User_Role,
IsDeleted = false,
Guid = Guid.NewGuid(),
CreateDate = DateTime.Now,
TenantID = 1,
};
db.Entities.Add(NewEntity1);
db.Entities.Add(NewEntity2);
db.Entities.Add(NewEntity3);
db.SaveChanges();
Field NewField1 = new Field()
{
EntityID = NewEntity1.EntityID,
FieldTypeID = TestFieldType.User_Start_Date.Value,
IsDeleted = false,
ValueDate = new DateTime(2015, 1, 1),
Guid = Guid.NewGuid(),
CreateDate = DateTime.Now,
TenantID = 1,
};
Field NewField4 = new Field()
{
EntityID = NewEntity1.EntityID,
FieldTypeID = TestFieldType.First_Name.Value,
IsDeleted = false,
ValueText = "John",
Guid = Guid.NewGuid(),
CreateDate = DateTime.Now,
TenantID = 1,
};
Field NewField5 = new Field()
{
EntityID = NewEntity1.EntityID,
FieldTypeID = TestFieldType.Last_Name.Value,
IsDeleted = false,
ValueText = "Smith",
Guid = Guid.NewGuid(),
CreateDate = DateTime.Now,
TenantID = 1,
};
Field NewField2 = new Field()
{
EntityID = NewEntity2.EntityID,
FieldTypeID = TestFieldType.User_Type.Value,
IsDeleted = false,
ValueText = "Subscriber",
Guid = Guid.NewGuid(),
CreateDate = DateTime.Now,
TenantID = 1,
};
Field NewField3 = new Field()
{
EntityID = NewEntity3.EntityID,
FieldTypeID = TestFieldType.User_Type.Value,
IsDeleted = false,
ValueText = "Editor",
Guid = Guid.NewGuid(),
CreateDate = DateTime.Now,
TenantID = 1,
};
db.Fields.Add(NewField1);
db.Fields.Add(NewField2);
db.Fields.Add(NewField3);
db.Fields.Add(NewField4);
db.Fields.Add(NewField5);
db.SaveChanges();
db.Commit();
TempItems.Add(NewItem);
}
}
public void TearDownEF7Database()
{
using (var db = new EntityFramework7DBContext(Configuration["Data:DefaultConnection:ConnectionString"]))
using (db.BeginTransaction())
{
var AllEntities = db.Entities.Where(e => TempItems.Select(i => i.ItemID).Contains(e.ItemID)).ToList();
var AllFields = db.Fields.Where(f => AllEntities.Select(e => e.EntityID).Contains(f.EntityID)).ToList();
foreach (var Field in AllFields)
{
db.Fields.Remove(Field);
}
db.SaveChanges();
foreach (var Entity in AllEntities)
{
var OtherFields = db.Fields.Where(f => f.EntityID == Entity.EntityID);
foreach (var Field in OtherFields)
{
db.Fields.Remove(Field);
}
db.Entities.Remove(Entity);
}
db.SaveChanges();
foreach (var Item in TempItems)
{
var OtherEntities = db.Entities.Where(e => e.ItemID == Item.ItemID);
foreach (var Entity in OtherEntities)
{
var OtherFields = db.Fields.Where(f => f.EntityID == Entity.EntityID);
foreach (var Field in OtherFields)
{
db.Fields.Remove(Field);
}
db.Entities.Remove(Entity);
}
db.Items.Remove(Item);
}
db.SaveChanges();
db.Commit();
TempField.Clear();
TempItems.Clear();
TempEntity.Clear();
}
}
public void SavingFields()
{
Core.Models.Db.Item Item = Ef.TempItems.Last();
User NewUser = new User(Item.ItemID.Value);
NewUser.EffectiveDate = new DateTime(2015, 1, 1);
FieldString UserType = NewUser.EffectiveRecord.GetFirstEntityOrDefault<UserTypeEntity>().UserType;
Assert.False(UserType.Dirty);
UserType.Value = "Code Monkey";
Assert.True(UserType.Dirty);
UserType.PersistToDatabase();
Assert.False(UserType.Dirty);
using (var db = new EntityFramework7DBContext(Ef.Configuration["Data:DefaultConnection:ConnectionString"]))
{
Field Field = db.Fields.Single(ef => ef.FieldID == UserType.FieldID.Value);
Assert.Equal(Field.Guid, UserType.Guid);
Assert.Equal("Code Monkey", UserType.Value);
}
UserType.Value = "Subscriber";
Assert.True(UserType.Dirty);
UserType.PersistToDatabase();
Assert.False(UserType.Dirty);
}
public void SaveNewField()
{
Core.Models.Db.Item Item = Ef.TempItems.First();
User NewUser = new User(Item.ItemID.Value);
NewUser.EffectiveDate = new DateTime(2015, 1, 1);
UserTypeEntity Job = NewUser.EffectiveRecord.GetFirstEntityOrDefault<UserTypeEntity>();
Job.JobStartDate.Value = new DateTime(2015, 1, 1);
Job.PersistToDatabase();
using (var db = new EntityFramework7DBContext(Ef.Configuration["Data:DefaultConnection:ConnectionString"]))
{
Ef.TempField.Add(db.Fields.Single(f => f.FieldID == Job.JobStartDate.FieldID.Value));
}
NewUser = new User(Item.ItemID.Value);
NewUser.EffectiveDate = new DateTime(2015, 1, 1);
Job = NewUser.EffectiveRecord.GetFirstEntityOrDefault<UserTypeEntity>();
Assert.Equal(new DateTime(2015, 1, 1), Job.JobStartDate.Value);
}