private static async Task LoadCategories(hipagesDbContext databaseContext) { if (await databaseContext.Categories.CountAsync() <= 0) { for (int i = 1; i <= 5; i++) { databaseContext.Categories.Add(new Categories() { Id = i, Name = $"category_{i}", ParentCategoryId = i * 10 }); } await databaseContext.SaveChangesAsync(); } }
private static async Task LoadSuburbs(hipagesDbContext databaseContext) { if (await databaseContext.Suburbs.CountAsync() <= 0) { for (int i = 1; i <= 5; i++) { databaseContext.Suburbs.Add(new Suburbs() { Id = i, Name = $"suburb_{i}", Postcode = $"200{i}" }); } await databaseContext.SaveChangesAsync(); } }
public static async Task <hipagesDbContext> GetDatabaseContext() { if (databaseContext == null) { var options = new DbContextOptionsBuilder <hipagesDbContext>() .UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString()) .Options; databaseContext = new hipagesDbContext(options); databaseContext.Database.EnsureCreated(); await LoadCategories(databaseContext); await LoadSuburbs(databaseContext); await LoadJobs(databaseContext); } return(databaseContext); }
private static async Task LoadJobs(hipagesDbContext databaseContext) { if (await databaseContext.Jobs.CountAsync() <= 0) { for (int i = 1; i <= 5; i++) { databaseContext.Jobs.Add(new Jobs() { Id = i, Status = "New", SuburbId = i, CategoryId = i, ContactName = $"First{i} Last{i}", ContactPhone = $"045012300{i}", ContactEmail = $"contact{i}@expample.com", Price = i * 101, Description = $"Description {i}", CreatedAt = DateTime.Now }); } for (int i = 6; i <= 8; i++) { databaseContext.Jobs.Add(new Jobs() { Id = i, Status = "Accepted", SuburbId = i % 5, CategoryId = i % 5, ContactName = $"First{i} Last{i}", ContactPhone = $"045012300{i}", ContactEmail = $"contact{i}@expample.com", Price = i * 101, Description = $"Description {i}", CreatedAt = DateTime.Now }); } await databaseContext.SaveChangesAsync(); } }
public LeadHandlerRepository(hipagesDbContext context) { _context = context; }