protected override void Seed(Data.DataModels.CFContext context)
{
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data.
try
{
InitDatabaseProvider.SetupRolesGroups(context);
InitDatabaseProvider.GrantDefaultRolesForGroups(context);
InitDatabaseProvider.CreateSuperUser(context);
//InitDatabaseProvider.CreateSlide(context);
//InitDatabaseProvider.CreatePage(context);
//InitDatabaseProvider.CreateContactDetail(context);
//InitDatabaseProvider.CreateConfigTitle(context);
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
InitDatabaseProvider.CreateStdType();
InitDatabaseProvider.CreateStandard();
InitDatabaseProvider.CreatEquGroup();
InitDatabaseProvider.CreateStatus();
InitDatabaseProvider.CreatCompany();
}
public override void InitializeDatabase(CFContext context)
{
if (!context.Database.Exists())
{
// if database did not exist before - create it
context.Database.Create();
InitDatabaseProvider.SetupRolesGroups(context);
InitDatabaseProvider.GrantDefaultRolesForGroups(context);
InitDatabaseProvider.CreateSuperUser(context);
InitDatabaseProvider.CreateStdType();
InitDatabaseProvider.CreateStandard();
InitDatabaseProvider.CreatEquGroup();
InitDatabaseProvider.CreateStatus();
InitDatabaseProvider.CreateSlide(context);
InitDatabaseProvider.CreatePage(context);
InitDatabaseProvider.CreateContactDetail(context);
InitDatabaseProvider.CreateConfigTitle();
}
else
{
// query to check if MigrationHistory table is present in the database
var migrationHistoryTableExists = ((IObjectContextAdapter)context).ObjectContext.ExecuteStoreQuery <int>(
string.Format(
"SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = '{0}' AND table_name = '__MigrationHistory'",
"dbo"));
// if MigrationHistory table is not there (which is the case first time we run) - create it
if (migrationHistoryTableExists.FirstOrDefault() == 0)
{
context.Database.Delete();
context.Database.Create();
InitDatabaseProvider.SetupRolesGroups(context);
InitDatabaseProvider.GrantDefaultRolesForGroups(context);
InitDatabaseProvider.CreateSuperUser(context);
InitDatabaseProvider.CreateStdType();
InitDatabaseProvider.CreateStandard();
InitDatabaseProvider.CreatEquGroup();
InitDatabaseProvider.CreateStatus();
InitDatabaseProvider.CreateSlide(context);
InitDatabaseProvider.CreatePage(context);
InitDatabaseProvider.CreateContactDetail(context);
InitDatabaseProvider.CreateConfigTitle();
}
}
}