public IActionResult Edit(int ProductTypeId)
{
DbContext _context = new WeLoveCoffeeDbContext();
var _product = _context.Set <ProductType>().Where(p => p.ProductTypeId == ProductTypeId).FirstOrDefault();
return(View(_product));
}
public async Task <IActionResult> SignIn(LoginModel loginModel)
{
Console.WriteLine("Creating Claims");
DbContext _context = new WeLoveCoffeeDbContext();
var user = _context.Set <User>().Where(u => u.Name == loginModel.Username && u.Password == loginModel.Password).Select(o => o).FirstOrDefault();
if (user is null)
{
return(Unauthorized());
}
var userClaims = JsonSerializer.Deserialize <xClaim>(user.Claims);
var claims = new List <System.Security.Claims.Claim>
{
new System.Security.Claims.Claim(ClaimTypes.NameIdentifier, userClaims.NameIdentifier),
new System.Security.Claims.Claim(ClaimTypes.Name, user.Name)
};
foreach (var claim in userClaims.Role)
{
claims.Add(new System.Security.Claims.Claim(ClaimTypes.Role, claim));
}
var identity = new ClaimsIdentity(claims, CookieAuthenticationDefaults.AuthenticationScheme);
var principal = new ClaimsPrincipal(identity);
await HttpContext.SignInAsync(
CookieAuthenticationDefaults.AuthenticationScheme,
principal,
new AuthenticationProperties { IsPersistent = true }
);
return(LocalRedirect(loginModel.ReturnUrl));
}
public IActionResult Edit(int RoastId)
{
DbContext _context = new WeLoveCoffeeDbContext();
var _roast = _context.Set <Roast>().Where(p => p.RoastId == RoastId).FirstOrDefault();
return(View(_roast));
}
public IActionResult Add()
{
DbContext _context = new WeLoveCoffeeDbContext();
ViewBag.ProductTypes = _context.Set <ProductType>().ToList();
ViewBag.Roasts = _context.Set <Roast>().ToList();
return(View());
}
public IActionResult Add([Bind("RoastId", "Name", "Price", "CurrentRoast", "Strength", "ImagePath")] Roast roast)
{
DbContext _context = new WeLoveCoffeeDbContext();
var _roast = _context.Add(roast);
_context.SaveChanges();
return(Redirect("/Roast"));
}
public IActionResult Add([Bind("Id", "Name", "Price", "ProductTypeId", "RoastId", "ImagePath")] Product product)
{
DbContext _context = new WeLoveCoffeeDbContext();
_context.Add(product);
_context.SaveChanges();
return(Redirect("/Product"));
}
public IActionResult Index()
{
DbContext _context = new WeLoveCoffeeDbContext();
var users = _context.Set <User>().ToList();
ViewBag.User = users;
return(View());
}
public IActionResult Add([Bind("Type")] ProductType productType)
{
DbContext _context = new WeLoveCoffeeDbContext();
_context.Add <ProductType>(productType);
_context.SaveChanges();
return(Redirect("/ProductType"));
}
public IActionResult Index()
{
DbContext _context = new WeLoveCoffeeDbContext();
ViewBag.ProductType = _context
.Set <ProductType>()
.ToList();
return(View());
}
public IActionResult Delete(int productId)
{
DbContext _context = new WeLoveCoffeeDbContext();
var dbProduct = _context.Set <Product>().Where(id => id.Id == productId).FirstOrDefault();
_context.Remove <Product>(dbProduct);
_context.SaveChanges();
return(LocalRedirect("/Product"));
}
public static void BuyProduct(string userId, string productId)
{
DbContext _context = new WeLoveCoffeeDbContext();
var dbUser = _context.Set <User>().Where(u => u.Id == userId).FirstOrDefault();
var dbProductPrice = _context.Set <Product>().Where(p => p.ProductTypeId == Convert.ToInt32(productId)).Select(pr => pr.Price).FirstOrDefault();
dbUser.AccountBalance += dbProductPrice;
_context.SaveChanges();
}
public IActionResult Update([Bind("ProductTypeId", "Type")] ProductType productType)
{
DbContext _context = new WeLoveCoffeeDbContext();
var _dbProduct = _context.Set <ProductType>().Where(p => p.ProductTypeId == productType.ProductTypeId).FirstOrDefault();
_dbProduct.Type = productType.Type;
_context.SaveChanges();
return(Redirect("Index"));
}
public IActionResult Delete(int roastId)
{
DbContext _context = new WeLoveCoffeeDbContext();
var dbRoast = _context.Set <Roast>().Where(id => id.RoastId == roastId).FirstOrDefault();
_context.Remove <Roast>(dbRoast);
_context.SaveChanges();
return(Redirect("/Roast"));
}
public IActionResult Index()
{
DbContext _context = new WeLoveCoffeeDbContext();
ViewBag.Roast = _context
.Set <Roast>()
.ToList();
return(View());
}
public IActionResult Edit(int productId)
{
DbContext _context = new WeLoveCoffeeDbContext();
var _product = _context.Set <Product>().Where(p => p.Id == productId).FirstOrDefault();
ViewBag.ProductTypes = _context.Set <ProductType>().ToList();
ViewBag.Roasts = _context.Set <Roast>().ToList();
return(View(_product));
}
public IActionResult Index()
{
DbContext _context = new WeLoveCoffeeDbContext();
ViewBag.Product = _context
.Set <Product>()
.Include(r => r.Roast)
.Include(p => p.ProductType)
.ToList();
return(View());
}
public IActionResult Index()
{
DbContext _context = new WeLoveCoffeeDbContext();
var products = _context.Set <Product>()
.Include(p => p.ProductType)
.OrderBy(n => n.Name)
.ToList();
ViewBag.Roast = _context.Set <Roast>().Where(c => c.CurrentRoast == true).Select(n => n).FirstOrDefault();
ViewBag.Users = _context.Set <User>().ToList();
return(View(products));
}
public IActionResult Update([Bind("Id", "Name", "Price", "ProductTypeId", "RoastId", "ImagePath")] Product _product)
{
DbContext _context = new WeLoveCoffeeDbContext();
var _dbProduct = _context.Set <Product>().Where(p => p.Id == _product.Id).FirstOrDefault();
_dbProduct.Name = _product.Name;
_dbProduct.Price = _product.Price;
_dbProduct.ProductTypeId = Convert.ToInt32(Request.Form["ProductType"]);
_dbProduct.RoastId = Convert.ToInt32(Request.Form["RoastId"]);
_dbProduct.ImagePath = _product.ImagePath;
_context.SaveChanges();
return(Redirect("/Product"));
}
public IActionResult Update([Bind("RoastId", "Name", "Price", "CurrentRoast", "Strength", "ImagePath")] Roast roast)
{
DbContext _context = new WeLoveCoffeeDbContext();
var _dbRoast = _context.Set <Roast>().Where(p => p.RoastId == roast.RoastId).FirstOrDefault();
_dbRoast.Name = roast.Name;
_dbRoast.Price = roast.Price;
_dbRoast.CurrentRoast = roast.CurrentRoast;
_dbRoast.Strength = roast.Strength;
_dbRoast.ImagePath = roast.ImagePath;
_context.SaveChanges();
return(Redirect("Index"));
}
public static void Main(string[] args)
{
System.IO.File.Delete(".\\WeLoveCoffee.db");
DbContext _context = new WeLoveCoffeeDbContext();
_context.Database.EnsureCreated();
Preset.SetProductTypes(_context);
Preset.SetUsers(_context);
Preset.SetRoasts(_context);
Preset.SetProducts(_context);
CreateHostBuilder(args).Build().Run();
}
public IActionResult Edit(string userId)
{
DbContext _context = new WeLoveCoffeeDbContext();
var user = _context.Set <User>().Where(id => id.Id == userId).FirstOrDefault();
if (user is null)
{
return(StatusCode(400));
}
var claims = JsonSerializer.Deserialize <xClaim>(user.Claims);
ViewBag.Claims = claims.Role;
return(View(user));
}
public IActionResult Delete(string userId)
{
DbContext _context = new WeLoveCoffeeDbContext();
var user = _context.Set <User>().Where(id => id.Id == userId).FirstOrDefault();
if (user is null)
{
return(StatusCode(400));
}
if (!xClaim.GetClaims(user).Contains("Admin"))
{
_context.Remove <User>(user);
_context.SaveChanges();
return(LocalRedirect("/User"));
}
return(StatusCode(403, Json("Cant remove admin. Remove role 'Admin' first")));
}
public IActionResult Delete(int productTypeId)
{
if (productTypeId == 1)
{
return(StatusCode(403, Json("Cannot Remove 'None' frome Database.")));
}
DbContext _context = new WeLoveCoffeeDbContext();
var _dbProductType = _context.Set <ProductType>().Where(p => p.ProductTypeId == productTypeId).FirstOrDefault();
_context.Remove(_dbProductType);
try
{
_context.SaveChanges();
}
catch
{
return(StatusCode(403, Json("You cannot delete associated items")));
}
return(Redirect("Index"));
}
