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;
}
