private void CreateTestData(NYCLandmarkContext dbContext) { var i = 0; var boroughs = EnumHelper.EnumToList <Borough>().Select(e => e.GetDescription()); var boroughCodes = EnumHelper.EnumToList <Borough>().Select(e => e.GetAttribute <BoroughId>().Value); var objectTypes = EnumHelper.EnumToList <ObjectType>().Select(e => e.GetDescription()); GenFu.GenFu.Configure <LPCReport>() .Fill(l => l.Id, () => ++ i) .Fill(l => l.LPNumber, () => string.Format("LP-{0,5:D5}", i)) .Fill(l => l.LPCId, () => string.Format("{0,5:D5}", i)) .Fill(l => l.Borough, () => BaseValueGenerator.GetRandomValue(boroughs)) .Fill(l => l.ObjectType, () => BaseValueGenerator.GetRandomValue(objectTypes)); var lpcReports = GenFu.GenFu.ListOf <LPCReport>(20); dbContext.LPCReports.AddRange(lpcReports); var j = 0; GenFu.GenFu.Configure <Landmark>() .Fill(m => m.Id, () => ++ j) .Fill(l => l.LM_TYPE, () => BaseValueGenerator.GetRandomValue(objectTypes)) .Fill(l => l.BoroughID, () => BaseValueGenerator.GetRandomValue(boroughCodes)) .Fill(m => m.LP_NUMBER, () => string.Format("LP-{0,5:D5}", j)); var landmarks = GenFu.GenFu.ListOf <Landmark>(20); dbContext.Landmarks.AddRange(landmarks); dbContext.SaveChanges(); }
public LPCReportServiceTest() { var services = new ServiceCollection(); var builder = new ConfigurationBuilder(); builder.SetBasePath(Directory.GetCurrentDirectory()); builder.AddJsonFile("appsettings.json").Build(); var connectionStringConfig = builder.Build(); var dbonnection = connectionStringConfig.GetConnectionString("SqlServer"); services.AddDbContext <NYCLandmarkContext>(options => options.UseSqlServer(dbonnection)); services.AddScoped <ILPCReportRepository, LPCReportRepository>(); services.AddScoped <ILPCReportService, LPCReportService>(); serviceProvider = services.BuildServiceProvider(); dbContext = serviceProvider.GetRequiredService <NYCLandmarkContext>(); lpcReportRepository = serviceProvider.GetRequiredService <ILPCReportRepository>(); lbcReportService = serviceProvider.GetRequiredService <ILPCReportService>(); AutoMapperConfiguration.Configure(); }
public LPCReportRepositoryTest() { var services = new ServiceCollection(); services.AddDbContext <NYCLandmarkContext>(options => options.UseNpgsql(@"User ID=nyclandmarks;Password=nyclandmarks;Server=192.168.99.100;Port=5432;Database=nyclandmarks;Integrated Security=true;Pooling=true;")); services.AddScoped <ILPCReportRepository, LPCReportRepository>(); serviceProvider = services.BuildServiceProvider(); dbContext = serviceProvider.GetRequiredService <NYCLandmarkContext>(); lpcReportRepository = serviceProvider.GetRequiredService <ILPCReportRepository>(); }
public LandmarkRepositoryTest() { var builder = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json") .Build(); var dbonnection = builder.GetConnectionString("SqlServer"); var serviceProvider = new ServiceCollection() .AddDbContext <NYCLandmarkContext>(options => options.UseSqlServer(dbonnection)) .AddScoped <ILandmarkRepository, LandmarkRepository>() .BuildServiceProvider(); serviceProvider.GetRequiredService <SqlServer.NYCLandmarkContext>(); _dbContext = serviceProvider.GetRequiredService <NYCLandmarkContext>(); _landmarkRepository = serviceProvider.GetRequiredService <ILandmarkRepository>(); }
public LandmarkRepository(NYCLandmarkContext context) : base(context) { }