protected override void Seed(Context.ContextoBanco context)
{
if (context.PerfilUsuario.Where(x => x.NomePerfil == "Administrador Master").Count() == 0)
{
UserDatabaseInitializer.GetPerfisUsuarios().ForEach(c => context.PerfilUsuario.Add(c));
}
if (context.Usuarios.Where(u => u.IdPerfilUsuario == 1).Count() == 0)
{
UserDatabaseInitializer.GetUsuario().ForEach(d => context.Usuarios.Add(d));
}
// Delete all stored procs, views
foreach (var file in Directory.GetFiles(Path.Combine(AppDomain.CurrentDomain.BaseDirectory.Replace("bin\\Debug", ""), "Sql\\Seed"), "*.sql"))
{
context.Database.ExecuteSqlCommand(File.ReadAllText(file), new object[0]);
}
// Add Stored Procedures
foreach (var file in Directory.GetFiles(Path.Combine(AppDomain.CurrentDomain.BaseDirectory.Replace("bin\\Debug", ""), "Sql\\StoredProcs"), "*.sql"))
{
context.Database.ExecuteSqlCommand(File.ReadAllText(file), new object[0]);
}
}
