protected override void Seed(LeaveManagement.DataAccessLayer.Entities.EmployeeDbContext 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.
CountrySeed.Seed(context);
EducationTypeSeed.Seed(context);
}
public void Configure(EntityTypeBuilder <Country> builder)
{
builder.HasKey(d => d.Id);
builder.Property(d => d.Name)
.HasMaxLength(250)
.IsRequired(true);
builder.HasData(CountrySeed.SeedData());
}
private static void AddCountries(ModelBuilder modelBuilder)
{
List <Country> countries = CountrySeed.GetCountries();
foreach (Country country in countries)
{
modelBuilder.Entity <Model.Domain.Lookup.Country>().HasData
(
country
);
}
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Entity <Store>().HasOne(x => x.Address).WithOne(x => x !.Store !).HasForeignKey <Address>(x => x.StoreId);
modelBuilder.Entity <Country>().HasData(CountrySeed.Get());
modelBuilder.Entity <Company>().HasData(CompanySeed.Get());
modelBuilder.Entity <Address>().HasData(AddressSeed.Get());
modelBuilder.Entity <Store>().HasData(StoreSeed.Get());
modelBuilder.Entity <Product>().HasData(ProductSeed.Get());
}
//This class tells Entity Framework where our seed files are,
//and to use them to add records to our operational database.
//We do them in this order so that foreign keys can be established.
protected override async void Seed(OracleContext context)
{
//System-specific
context.Users.AddOrUpdate(UserSeed.ToArray());
await context.SaveChangesAsync();
context.Permissions.AddOrUpdate(PermissionSeed.ToArray());
await context.SaveChangesAsync();
//Operational
context.Campuses.AddOrUpdate(CampusSeed.ToArray());
await context.SaveChangesAsync();
context.Countries.AddOrUpdate(CountrySeed.ToArray());
await context.SaveChangesAsync();
context.AcademicYears.AddOrUpdate(AcademicYearSeed.ToArray());
await context.SaveChangesAsync();
context.Modules.AddOrUpdate(ModuleSeed.ToArray());
await context.SaveChangesAsync();
context.Courses.AddOrUpdate(CourseSeed.ToArray());
await context.SaveChangesAsync();
context.CourseModules.AddOrUpdate(CourseModuleSeed.ToArray());
await context.SaveChangesAsync();
context.Lecturers.AddOrUpdate(LecturerSeed.ToArray());
await context.SaveChangesAsync();
context.ModuleRuns.AddOrUpdate(ModuleRunSeed.ToArray());
await context.SaveChangesAsync();
context.Students.AddOrUpdate(StudentSeed.ToArray());
await context.SaveChangesAsync();
context.Enrollments.AddOrUpdate(EnrollmentSeed.ToArray());
await context.SaveChangesAsync();
context.Assignments.AddOrUpdate(AssignmentSeed.ToArray());
await context.SaveChangesAsync();
context.Results.AddOrUpdate(ResultSeed.ToArray());
await context.SaveChangesAsync();
context.Graduations.AddOrUpdate(GraduationSeed.ToArray());
await context.SaveChangesAsync();
context.Complaints.AddOrUpdate(ComplaintSeed.ToArray());
await context.SaveChangesAsync();
}
protected override void Seed(TestDbContext context)
{
base.Seed(context);
var companies = CompanySeed.Get();
context.Addresses.AddRange(AddressSeed.Get());
context.Countries.AddRange(CountrySeed.Get());
context.Companies.AddRange(CompanySeed.Get());
context.Products.AddRange(ProductSeed.Get());
context.Stores.AddRange(StoreSeed.Get());
context.SaveChanges();
}
protected override void OnModelCreating(ModelBuilder builder)
{
base.OnModelCreating(builder);
builder.Entity <AppUser>().HasMany <Chat>().WithOne(m => m.GetUser_1).OnDelete(DeleteBehavior.Restrict);
builder.Entity <AppUser>().HasMany <Chat>().WithOne(m => m.GetUser_2).OnDelete(DeleteBehavior.Restrict);
builder.Entity <Chat>().HasOne <AppUser>().WithMany(m => m.GetChates_1).OnDelete(DeleteBehavior.Restrict);
builder.Entity <Chat>().HasOne <AppUser>().WithMany(m => m.GetChates_2).OnDelete(DeleteBehavior.Restrict);
RoleSeed.Seed(builder);
UserSeed.Seed(builder);
UserRoleSeed.Seed(builder);
CountrySeed.Seed(builder);
CitySeed.Seed(builder);
}
public static List <Model.Domain.Calculator.Calculator> GetCalculators()
{
List <Model.Domain.Calculator.Calculator> results = new List <Model.Domain.Calculator.Calculator>();
var calculatorSettings = CalculatorSettingsSeed.GetCalculatorSettings();
int index = 1;
foreach (CalculatorSetting calculatorSetting in calculatorSettings.Where(x => x.CountryIso != null))
{
results.Add(new Model.Domain.Calculator.Calculator()
{
CalculatorId = index,
CountryIso = calculatorSetting.CountryIso,
CalculatorSettingId = calculatorSetting.CalculatorSettingId
});
++index;
}
// for all other countries add a calculator with default settings
foreach (Enumerations.CountryEnum countryIso in (Enumerations.CountryEnum[])Enum.GetValues(
typeof(Enumerations.CountryEnum)))
{
String name = Enum.GetName(typeof(Enumerations.CountryEnum), countryIso);
Country country = CountrySeed.GetCountries().FirstOrDefault(x => x.Iso == name.ToUpper());
int calculatorSettingId = country?.RegionId == Enumerations.RegionEnum.Europe ? 2 : 1;
if (results.All(x => x.CountryIso != name.ToString()))
{
results.Add(new Model.Domain.Calculator.Calculator()
{
CalculatorId = index,
CountryIso = name.ToUpper(),
CalculatorSettingId = calculatorSettingId
});
}
++index;
}
return(results);
}
public static void Main(string[] args)
{
var host = CreateHostBuilder(args).Build();
using (var scope = host.Services.CreateScope())
{
var services = scope.ServiceProvider;
try
{
var context = services.GetRequiredService <DataContext>();
context.Database.Migrate();
CountrySeed.SeedCountryData(context).Wait();
RecipeSeed.SeedRecipeData(context).Wait();
}
catch (Exception ex)
{
var logger = services.GetRequiredService <ILogger <Program> >();
logger.LogError(ex, "An error occured during migration");
}
}
host.Run();
}
protected override void Seed(EmployeeDbContext context)
{
CountrySeed.Seed(context);
base.Seed(context);
}
