private async Task CreateDbSeedAsync(IServiceProvider serviceProvider)
{
_logger.LogInformation("Creating DB seed");
try
{
_logger.LogInformation("Creating users");
await DbSeed.CreateTestingUserAsync(serviceProvider);
_logger.LogInformation("Users created");
_logger.LogInformation("Creating courses");
await DbSeed.LoadTestingCoursesAsync(serviceProvider);
_logger.LogInformation("Courses created");
_logger.LogInformation("Creating exchanges");
await DbSeed.CreateTestingExchangesAsync(serviceProvider);
_logger.LogInformation("Exchanges created.");
_logger.LogInformation("Creating notifications");
await DbSeed.CreateTestingNotifications(serviceProvider);
_logger.LogInformation("Notifications created.");
}
catch (Exception e)
{
_logger.LogError($"Exception during creating DB seed :\n{e.Message}");
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, AppDbContext context)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
app.UseHsts();
}
//Seed de data inicial
DbSeed.SeedData(context);
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseCookiePolicy();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Noticias}/{action=Index}/{id?}");
});
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, DbSeed seed)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
app.UseDatabaseErrorPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseCookiePolicy();
app.UseAuthentication();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "area",
template: "{area:exists}/{controller=Home}/{action=Index}/{id?}");
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
});
seed.Seed();
}
public async Task DeleteProperProductSaleRecords_WhenValidSaleIdIsPassed()
{
//Arrange
var databaseName = System.Reflection.MethodBase.GetCurrentMethod().Name;
var options = DbSeed.GetOptions(databaseName);
DbSeed.SeedDatabase(options);
Sale sale;
int totalRecordsInProductSale;
using (var getContext = new StoreSystemDbContext(options))
{
sale = getContext.Sales.Include(x => x.ProductsInSale).First();
totalRecordsInProductSale = getContext.ProductSales.Count();
}
int validSaleId = sale.SaleID;
var countOfProductsInSale = sale.ProductsInSale.Count();
using (var context = new StoreSystemDbContext(options))
{
var dateTimeNowProvider = new Mock <IDateTimeNowProvider>();
var sut = new SaleService(context, dateTimeNowProvider.Object);
//Act
var isExecxuted = await sut.DeleteSaleAsync(validSaleId);
//Assert
Assert.IsTrue(isExecxuted);
Assert.AreEqual(totalRecordsInProductSale - countOfProductsInSale, context.ProductSales.Count());
}
}
public static void Main(string[] args)
{
var host = BuildWebHost(args);
using (var scope = host.Services.CreateScope())
{
var services = scope.ServiceProvider;
try
{
// TwoNoteContext Seed.
var context = services.GetService <TwoNoteContext>();
DbSeed.SeedAsync(context).Wait();
// AppIdentityDbContext Seed.
var userManager = services.GetRequiredService <UserManager <ApplicationUser> >();
AppIdentityDbContextSeed.SeedAsync(userManager).Wait();
}
catch (Exception ex)
{
var logger = services.GetRequiredService <ILogger <Program> >();
logger.LogError(ex, "An error occured while seeding the database");
}
}
host.Run();
}
private static void InitializeMigrations(IApplicationBuilder app)
{
using (var serviceScope = app.ApplicationServices.GetService <IServiceScopeFactory>().CreateScope())
{
DbSeed.DbInit(serviceScope);
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ApplicationDbContext context, UserManager <ApplicationUser> userManager, RoleManager <IdentityRole> roleManager)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
app.UseBrowserLink();
app.UseDatabaseErrorPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
}
app.UseStaticFiles();
app.UseAuthentication();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Products}/{action=Index}/{id?}/{slug?}");
});
DbSeed.Seed(context, userManager, roleManager);
}
public void Configure(IApplicationBuilder app, IHostingEnvironment env)
{
using (var context = new TicketingSystemDbContext())
{
context.Database.Migrate();
if (!context.Users.Any())
{
DbSeed.SeedUsers(context);
}
}
if (env.IsDevelopment())
{
app.UseBrowserLink();
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
}
app.UseAuthentication();
app.UseStaticFiles();
app.UseMvcWithDefaultRoute();
}
public async Task ShouldReturnTotalSumOfFiltredSales_WhenValidDatesArePassed()
{
//Arrange
var databaseName = System.Reflection.MethodBase.GetCurrentMethod().Name;
var options = DbSeed.GetOptions(databaseName);
DbSeed.SeedDatabase(options);
var validStartDate = new DateTime(2019, 2, 2);
var validEndDate = new DateTime(2019, 4, 4);
decimal expectedTotal = (decimal)((1 * 1 + 1 * 3 * 2) * (1 - 0.1 / 100));
using (var context = new StoreSystemDbContext(options))
{
var dateTimeNowProvider = new Mock <IDateTimeNowProvider>();
var sut = new SaleService(context, dateTimeNowProvider.Object);
//Act
var actualTotal = await sut.GetSaleQuantityAsync(startDate : validStartDate, endDate : validEndDate);
//Assert
Assert.AreEqual(expectedTotal, actualTotal);
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ApplicationDbContext dBcontext)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
app.UseBrowserLink();
app.UseDatabaseErrorPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
}
app.UseStaticFiles();
app.UseAuthentication();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
});
DbSeed.Seed(dBcontext);
}
public static void ConfigureServices(IServiceCollection services, string connString)
{
DbSeed.ConfigureContext(services, connString);
services.AddScoped(typeof(ICRUD <Cinema>), typeof(CinemaService));
services.AddScoped(typeof(ICRUD <Hall>), typeof(HallService));
services.AddScoped(typeof(ICRUD <Movie>), typeof(MovieService));
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory)
{
loggerFactory.AddConsole(Configuration.GetSection("Logging"));
loggerFactory.AddDebug();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
app.UseDatabaseErrorPage();
app.UseBrowserLink();
}
else
{
app.UseExceptionHandler("/Home/Error");
}
app.UseStaticFiles();
app.UseIdentity();
DbSeed.Seed(app);
// Add external authentication middleware below. To configure them please see https://go.microsoft.com/fwlink/?LinkID=532715
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
});
}
public async Task CreateAndAddNewSaleInDB_WhenValidParametersArePassed()
{
var databaseName = System.Reflection.MethodBase.GetCurrentMethod().Name;
using (var context = new StoreSystemDbContext(DbSeed.GetOptions(databaseName)))
{
var dateTimeNowProvider = new Mock <IDateTimeNowProvider>();
var validDate = new DateTime(2019, 4, 1);
var validClientName = "Pesho";
dateTimeNowProvider.Setup(x => x.Now).Returns(validDate);
var sut = new SaleService(context, dateTimeNowProvider.Object);
var client = new Client()
{
Name = validClientName
};
var address = new Address();
var city = new City();
var country = new Country();
await sut.CreateSaleAsync(client, 0.15m, 3, address, city, country);
Assert.AreEqual(1, context.Sales.Count());
Assert.AreEqual(validClientName, context.Sales.Single(x => x.Client == client).Client.Name);
}
}
public async Task CreateAndAddNewSaleWithIDsInDB_WhenValidParametersArePassed()
{
var databaseName = System.Reflection.MethodBase.GetCurrentMethod().Name;
using (var context = new StoreSystemDbContext(DbSeed.GetOptions(databaseName)))
{
//Arrange
var dateTimeNowProvider = new Mock <IDateTimeNowProvider>();
var validDate = new DateTime(2019, 1, 1);
dateTimeNowProvider.Setup(x => x.Now).Returns(validDate);
var sut = new SaleService(context, dateTimeNowProvider.Object);
var client = 1;
var address = 1;
var city = 1;
var country = 1;
var deadline = new DateTime(2019, 5, 10);
var discount = 0.10m;
//Act
await sut.CreateSaleAsync(client, discount, deadline, address, city, country);
//Assert
Assert.AreEqual(1, context.Sales.Count());
Assert.AreEqual(client, context.Sales.Single(x => x.ClientID == client).ClientID);
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ApplicationDbContext dbContext, ApplicationDbContext context)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
app.UseBrowserLink();
app.UseDatabaseErrorPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
}
app.Use((request, next) =>
{
var sv = new CultureInfo("sv-SE");
System.Threading.Thread.CurrentThread.CurrentCulture = sv;
System.Threading.Thread.CurrentThread.CurrentUICulture = sv;
return(next());
});
app.UseStaticFiles();
app.UseAuthentication();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=People}/{action=Index}/{id?}/{slug?}");
});
// DbSeed.Seed(context);
DbSeed.Seed(dbContext);
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, UserManager <ApplicationUser> userManager, RoleManager <IdentityRole> roleManager)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
app.UseDatabaseErrorPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
//app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseRouting();
app.UseAuthentication();
app.UseAuthorization();
DbSeed.SeedData(userManager, roleManager);
app.UseEndpoints(endpoints =>
{
endpoints.MapControllerRoute(
name: "default",
pattern: "{controller=Home}/{action=Index}/{id?}");
endpoints.MapRazorPages();
});
}
public async Task CreateSaleFromOffer_WhenValidOfferIdIsPassed()
{
//Arrange
var databaseName = System.Reflection.MethodBase.GetCurrentMethod().Name;
var options = DbSeed.GetOptions(databaseName);
DbSeed.SeedDatabase(options);
Offer validOffer;
using (var getContext = new StoreSystemDbContext(options))
{
validOffer = getContext.Offers.Include(x => x.Client).First();
}
using (var context = new StoreSystemDbContext(options))
{
var dateTimeNowProvider = new Mock <IDateTimeNowProvider>();
var validDate = new DateTime(2019, 4, 1);
var sut = new SaleService(context, dateTimeNowProvider.Object);
//Act
var saleActual = await sut.CreateSaleByOfferIDAsync(validOffer.OfferID);
//Assert
Assert.AreEqual(validOffer.OfferID, saleActual.OfferID);
Assert.AreEqual(validOffer.ClientID, context.Sales.FirstOrDefault(x => x.OfferID == validOffer.OfferID).ClientID);
Assert.AreEqual(validOffer.AddressID, context.Sales.FirstOrDefault(x => x.OfferID == validOffer.OfferID).AddressID);
Assert.AreEqual(validOffer.CityID, context.Sales.FirstOrDefault(x => x.OfferID == validOffer.OfferID).CityID);
Assert.AreEqual(validOffer.CountryID, context.Sales.FirstOrDefault(x => x.OfferID == validOffer.OfferID).CountryID);
}
}
public async Task ThrowsArgumentException_WhenInvalidSaleIdIsPassed()
{
//Arrange
var databaseName = System.Reflection.MethodBase.GetCurrentMethod().Name;
var options = DbSeed.GetOptions(databaseName);
DbSeed.SeedDatabase(options);
int invalidSaleID = 100;
using (var context = new StoreSystemDbContext(options))
{
var dateTimeNowProvider = new Mock <IDateTimeNowProvider>();
var validDate = new DateTime(2019, 4, 1);
var sut = new SaleService(context, dateTimeNowProvider.Object);
ProductIdQuantityDto[] products = new ProductIdQuantityDto[0];
var errorText = string.Format(
Consts.ObjectIDNotExist,
nameof(Sale),
invalidSaleID);
//Act
//Assert
Assert.AreEqual(
errorText,
(await Assert.ThrowsExceptionAsync <ArgumentException>(() => sut.AddProductsByIdToSaleAsync(invalidSaleID, products))).Message);
}
}
public void Configure(IApplicationBuilder app, IHostingEnvironment env)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
app.UseHsts();
}
DbSeed.Seed(app.ApplicationServices);
app.UseStaticFiles();
app.UseHttpsRedirection();
app.UseAuthentication();
app.UseCookiePolicy();
app.UseStatusCodePages();
container.AutoCrossWireAspNetComponents(app);
container.RegisterPageModels(app);
container.Verify();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
});
}
public static void Main(string[] args)
{
var host = CreateWebHostBuilder(args);
var env = Environment.GetEnvironmentVariable("ASPNETCORE_ENVIRONMENT");
if (env.Equals("Development", StringComparison.InvariantCultureIgnoreCase))
{
using (var scope = host.Services.CreateScope())
{
var services = scope.ServiceProvider;
try
{
DbSeed.SeedAsync(services)
.Wait();
}
catch (Exception ex)
{
var logger = services.GetRequiredService <ILogger <Program> >();
logger.LogError(ex, "An error occurred seeding the DB.");
}
}
}
host.Run();
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseHttpsRedirection();
app.UseRouting();
app.UseSwagger();
app.UseSwaggerUI(s =>
{
s.SwaggerEndpoint("/swagger/v1/swagger.json", "Api v1");
s.RoutePrefix = string.Empty;
});
app.UseAuthentication();
app.UseAuthorization();
app.UseCors();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
});
DbSeed.PrepDb(app);
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env,
PortfolioContext context)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseCookiePolicy();
/* Seed projects */
DbSeed.SeedDatabase(context).Wait();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
});
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, Context context)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
app.UseBrowserLink();
}
else
{
app.UseExceptionHandler("/Home/Error");
}
app.UseStaticFiles();
app.UseAuthentication();
app.UseCors(builder => builder.AllowAnyOrigin().AllowAnyHeader().AllowAnyMethod());
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
});
DbSeed.Seed(context);
}
public static void Main(string[] args)
{
Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
var host = CreateWebHostBuilder(args).Build();
using (var scope = host.Services.CreateScope())
{
var services = scope.ServiceProvider;
var loggerFactory = services.GetRequiredService <ILoggerFactory>();
try
{
// 从 system.IServicec提供程序获取 T 类型的服务。
var myContext = services.GetRequiredService <KCDBContext>();
if (myContext.Database.GetPendingMigrations().Any())
{
myContext.Database.Migrate(); //执行迁移
}
DbSeed.SeedAsync(myContext).Wait();
}
catch (Exception e)
{
var logger = loggerFactory.CreateLogger <Program>();
logger.LogError(e, "Error occured seeding the Database.");
}
}
host.Run();
}
public async Task DeleteProperSale_WhenValidSaleIdIsPassed()
{
//Arrange
var databaseName = System.Reflection.MethodBase.GetCurrentMethod().Name;
var options = DbSeed.GetOptions(databaseName);
DbSeed.SeedDatabase(options);
int validSaleId;
int totalCountOfSales;
using (var getContext = new StoreSystemDbContext(options))
{
validSaleId = getContext.Sales.First().SaleID;
totalCountOfSales = getContext.Sales.Count();
}
using (var context = new StoreSystemDbContext(options))
{
var dateTimeNowProvider = new Mock <IDateTimeNowProvider>();
var sut = new SaleService(context, dateTimeNowProvider.Object);
//Act
var isExecxuted = await sut.DeleteSaleAsync(validSaleId);
//Assert
Assert.IsTrue(isExecxuted);
Assert.IsTrue(context.Sales.Find(validSaleId) == null);
Assert.AreEqual(totalCountOfSales - 1, context.Sales.Count());
}
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
DbSeed.SeedRolesAndUsers();
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.ApplyConfiguration(new CategoryConfiguration());
DbSeed.Seed(modelBuilder);
}
public void TryLogIn_NullInput_ShouldReturnNull()
{
DbSeed.Seed(this.fixture.Context);
UserViewModel input = null;
UserRepository repository = new UserRepository(fixture.Context);
Assert.Null(repository.TryLogIn(input));
}
public static void Main(string[] args)
{
using (var seed = new DbSeed(new Context(options: new DbContextOptionsBuilder().UseSqlite(@"Data Source=.\Data\Data.db").Options)))
{
seed.Seed();
}
CreateHostBuilder(args).Build().Run();
}
protected void Application_Start()
{
CultureInfo.DefaultThreadCurrentCulture = new CultureInfo("es-US");
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
DbSeed.SeedRolesAndUsers();
DbSeed.SeedMovies().GetAwaiter().GetResult();
}
