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