public ProductListController(CapstoneShoppingListDBContext context, IDBSetup setup, IModelMaker modelMaker, IAddsToCart addsToCart) { _context = context; _dbSetup = setup; _modelMaker = modelMaker; _addsToCart = addsToCart; }
public HomeController(ILogger <HomeController> logger, IDBSetup setup, CapstoneShoppingListDBContext context) { _logger = logger; _DBSetup = setup; _context = context; _DBSetup.createNew(_context); }
ProductList IAddsToCart.AddToCart(CapstoneShoppingListDBContext context, int id) { var _context = context; var Id = id; var product = _context.ProductList.FirstOrDefault(_ => _.Id == Id); var shoppingListDetails = new ShoppingListDetails(); shoppingListDetails.ProductId = product.Id; shoppingListDetails.Quantity = 1; shoppingListDetails.Price = product.Price * shoppingListDetails.Quantity; shoppingListDetails.Product = product; _context.ShoppingListDetails.Add(shoppingListDetails); _context.SaveChanges(); return(product); }
public CheckoutModel MakeModel(CapstoneShoppingListDBContext context) { var cart = context.ShoppingListDetails; var table2 = context.ProductList; var checkout = new CheckoutModel(); var productQuery = (from s in cart join p in table2 on s.ProductId equals p.Id select s.Product).ToList(); checkout.Items = productQuery; checkout.Total = (double)productQuery.Sum(_ => _.Price); checkout.Tax = Math.Round((checkout.Total * .06), 2, MidpointRounding.AwayFromZero); checkout.GrandTotal = checkout.Total + checkout.Tax; return(checkout); }