public void TestExample() { var dbOptions = new DbContextOptionsBuilder <FoodDbContext>() .UseInMemoryDatabase(databaseName: "MyTestDatabase") .Options; using (var context = new FoodDbContext(dbOptions)) { context.FoodItems.Add(new FoodEntity() { Id = 999, Calories = 1300, Type = "Starter", Name = "Pizza", Created = DateTime.Now }); context.SaveChanges(); var host = new WebHostBuilder() .UseContentRoot(GetApplicationRoot()) .UseStartup <StartupFake>() .ConfigureServices(services => { services.AddSingleton(context); }); using (var server = new TestServer(host)) { var httpClient = server.CreateClient(); var response = httpClient.GetAsync("/api/v1/foods/999").Result; response.EnsureSuccessStatusCode(); } } }
public async Task Initialize(FoodDbContext context) { context.FoodItems.Add(new FoodItem() { Calories = 2000, Name = "pie", Weight = 100, Created = DateTime.Now }); context.FoodItems.Add(new FoodItem() { Calories = 1000, Name = "Lasagne", Weight = 50, Created = DateTime.Now }); context.FoodItems.Add(new FoodItem() { Calories = 1100, Name = "Hamburger", Weight = 60, Created = DateTime.Now }); context.FoodItems.Add(new FoodItem() { Calories = 1200, Name = "Spaghetti", Weight = 75, Created = DateTime.Now }); context.FoodItems.Add(new FoodItem() { Calories = 1300, Name = "Pizza", Weight = 80, Created = DateTime.Now }); await context.SaveChangesAsync(); }
private static void ClearDatabase(FoodDbContext _context) { var productCategories = _context.Products.ToList(); _context.Products.RemoveRange(productCategories); var productItems = _context.ProductItems.ToList(); _context.ProductItems.RemoveRange(productItems); var orderItems = _context.OrderItems.ToList(); _context.OrderItems.RemoveRange(orderItems); var orders = _context.Orders.ToList(); _context.Orders.RemoveRange(orders); var customers = _context.Customers.ToList(); _context.Customers.RemoveRange(customers); //var users = _context.Users.ToList(); //var userRoles = _context.UserRoles.ToList(); //foreach (var user in users) //{ // if (!userRoles.Any(r => r.UserId == user.Id)) // { // _context.Users.Remove(user); // } //} _context.SaveChanges(); }
public static void Initialize(FoodDbContext context, IServiceProvider service) { context.Database.EnsureCreated(); var roleManager = service.GetRequiredService <RoleManager <IdentityRole> >(); var userManager = service.GetRequiredService <UserManager <IdentityUser> >(); //ClearDatabase(context); CreateAdminRole(context, roleManager, userManager); //SeedDatabase(context); }
public FoodService( FoodDbContext dbContext, IMapper mapper, IBus bus, ICurrentUserService currentUserService) : base(dbContext) { this.mapper = mapper; this.bus = bus; this.currentUserService = currentUserService; }
public EnsureDatabaseDataService( UserManager <IdentityUser> userManager, RoleManager <IdentityRole> roleManager, ILoggerFactory loggerFactory, FoodDbContext context) { _userManager = userManager; _roleManager = roleManager; _logger = loggerFactory.CreateLogger <EnsureDatabaseDataService>(); _context = context; }
public ActionResult Index() { FoodDbContext db = new FoodDbContext(); var lunchFoodList = db.foods.SqlQuery("Select * from tbl_food where menu_id = 1").ToList <Food>(); var dinnerFoodList = db.foods.SqlQuery("Select * from tbl_food where menu_id = 2").ToList <Food>(); var all_food = db.foods.SqlQuery("select * from tbl_food where active = 1").ToList <Food>(); ViewData["LUNCH_FOOD"] = lunchFoodList; ViewData["DINNER_FOOD"] = dinnerFoodList; ViewData["ALL_FOOD"] = all_food; return(View()); }
public IdentityController( UserManager <IdentityUser> userManager, RoleManager <IdentityRole> roleManager, SignInManager <IdentityUser> signInManager, ILoggerFactory loggerFactory, FoodDbContext context) { _userManager = userManager; _roleManager = roleManager; _signInManager = signInManager; _logger = loggerFactory.CreateLogger <IdentityController>(); _context = context; }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IWebHostEnvironment env, FoodDbContext foodDbContext) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } app.UseHttpsRedirection(); app.UseStaticFiles(); app.UseRouting(); app.UseAuthentication(); app.UseAuthorization(); foodDbContext.Database.EnsureCreated(); app.UseEndpoints(endpoints => { endpoints.MapControllers(); }); }
public async Task Initialize(FoodDbContext context) { context.FoodItems.Add(new FoodEntity() { Calories = 1000, Type = "Starter", Name = "Lasagne", Created = DateTime.Now }); context.FoodItems.Add(new FoodEntity() { Calories = 1100, Type = "Main", Name = "Hamburger", Created = DateTime.Now }); context.FoodItems.Add(new FoodEntity() { Calories = 1200, Type = "Dessert", Name = "Spaghetti", Created = DateTime.Now }); context.FoodItems.Add(new FoodEntity() { Calories = 1300, Type = "Starter", Name = "Pizza", Created = DateTime.Now }); await context.SaveChangesAsync(); }
private static void CreateAdminRole(FoodDbContext context, RoleManager <IdentityRole> _roleManager, UserManager <IdentityUser> _userManager) { bool roleExists = _roleManager.RoleExistsAsync("Admin").Result; if (roleExists) { return; } var role = new IdentityRole() { Name = "Admin" }; _roleManager.CreateAsync(role).Wait(); var userRole = new IdentityRole() { Name = "User" }; _roleManager.CreateAsync(userRole).Wait(); var user = new IdentityUser() { UserName = "******", Email = "*****@*****.**" }; string adminPassword = "******"; var userResult = _userManager.CreateAsync(user, adminPassword).Result; if (userResult.Succeeded) { _userManager.AddToRoleAsync(user, "Admin").Wait(); } context.SaveChanges(); }
public async Task EnsureSeedData(FoodDbContext context) { context.Database.EnsureCreated(); context.FoodItems.Add(new FoodItem() { Calories = 1000, Name = "Lasagne", Type = "Main", Created = DateTime.Now }); context.FoodItems.Add(new FoodItem() { Calories = 1100, Name = "Hamburger", Type = "Main", Created = DateTime.Now }); context.FoodItems.Add(new FoodItem() { Calories = 1200, Name = "Spaghetti", Type = "Main", Created = DateTime.Now }); context.FoodItems.Add(new FoodItem() { Calories = 1300, Name = "Pizza", Type = "Main", Created = DateTime.Now }); await context.SaveChangesAsync(); }
public async Task Initialize(FoodDbContext context) { context.FoodItems.Add(new FoodItem() { Calories = 1000, Name = "Lasagne", Created = DateTime.Now }); context.FoodItems.Add(new FoodItem() { Calories = 1100, Name = "Hamburger", Created = DateTime.Now }); context.FoodItems.Add(new FoodItem() { Calories = 1200, Name = "Spaghetti", Created = DateTime.Now }); context.FoodItems.Add(new FoodItem() { Calories = 1300, Name = "Pizza", Created = DateTime.Now }); #pragma warning disable CA2007 // Do not directly await a Task await context.SaveChangesAsync(); #pragma warning restore CA2007 // Do not directly await a Task }
public SqlRestaurantData(FoodDbContext dbContext) { _dbContext = dbContext; }
public OrderLineService(FoodDbContext db) { this.db = db; }
public EfRecipeRepository(FoodDbContext context) : base(context) { }
public UserSubscriptionsController(FoodDbContext dbContext) { _dbContext = dbContext; }
public CategoriesController(FoodDbContext dbContext) { _dbContext = dbContext; }
public VendorItemsController(FoodDbContext dbContext) { _dbContext = dbContext; }
public EfFoodRepository(FoodDbContext foodDbContext) { _foodDbContext = foodDbContext; }
public MarqueeBannersController(FoodDbContext dbContext) { _dbContext = dbContext; }
public ShoppingCartItemsController(FoodDbContext dbContext) { _dbContext = dbContext; }
public ShoppingCartRepository(FoodDbContext context) : base(context) { _context = context; }
public OrderLineController(FoodDbContext db) { this.db = db; }
public ItemAddOnsController(FoodDbContext dbContext) { _dbContext = dbContext; }
public async Task EnsureSeedData(UserManager <IdentityUser> userManager, RoleManager <IdentityRole> roleManager, ILoggerFactory loggerFactory, FoodDbContext context) { context.Database.EnsureCreated(); context.Users.RemoveRange(context.Users); context.SaveChanges(); if (context.Users.Any()) { return; // Db has been seeded. } // Creates Roles. await roleManager.CreateAsync(new IdentityRole("administrator")); await roleManager.CreateAsync(new IdentityRole("user")); // Adds Roles to Role Claims. var adminRole = await roleManager.FindByNameAsync("administrator"); var userRole = await roleManager.FindByNameAsync("user"); await roleManager.AddClaimAsync(adminRole, new Claim(JwtClaimTypes.Role, "administrator")); await roleManager.AddClaimAsync(userRole, new Claim(JwtClaimTypes.Role, "user")); // Seeds an admin user. var user = new IdentityUser { AccessFailedCount = 0, Email = "*****@*****.**", EmailConfirmed = false, LockoutEnabled = true, NormalizedEmail = "*****@*****.**", NormalizedUserName = "******", TwoFactorEnabled = false, UserName = "******" }; var result = await userManager.CreateAsync(user, "admin"); if (result.Succeeded) { var adminUser = await userManager.FindByNameAsync(user.UserName); // Assigns the 'administrator' role. await userManager.AddToRoleAsync(adminUser, "administrator"); // Assigns claims. var claims = new List <Claim> { new Claim(type: JwtClaimTypes.Name, value: user.UserName), new Claim(type: JwtClaimTypes.Email, value: user.Email), }; await userManager.AddClaimsAsync(adminUser, claims); } context.FoodItems.Add(new FoodItem() { Calories = 1000, Name = "Lasagne", Created = DateTime.Now }); context.FoodItems.Add(new FoodItem() { Calories = 1100, Name = "Hamburger", Created = DateTime.Now }); context.FoodItems.Add(new FoodItem() { Calories = 1200, Name = "Spaghetti", Created = DateTime.Now }); context.FoodItems.Add(new FoodItem() { Calories = 1300, Name = "Pizza", Created = DateTime.Now }); }
public AddCustomerCommandHandler(FoodDbContext foodDbContext) { _foodDbContext = foodDbContext; }
public UserService(FoodDbContext db) { this.db = db; }
public AccountsController(FoodDbContext dbContext, IConfiguration configuration) { _configuration = configuration; _auth = new AuthService(_configuration); _dbContext = dbContext; }
public OrderRepository(FoodDbContext context) : base(context) { _context = context; }