public async Task <IActionResult> ProductSale(ProductPruchaseItemViewModel item) { List <PurchaseItem> pi = new List <PurchaseItem>(); string user = User.FindFirst(ClaimTypes.NameIdentifier).Value; var customer = _context.Customers.Where(c => c.LoginUser == user).FirstOrDefault(); // var rder = _context.Orders.Where(o => o.CustomerId == pi.Contains()).FirstOrDefault(); // double totalamount = pi.Sum(pi => pi.TotalPrice); Order order = new Order() { CustomerId = customer.ID, // TotalAmount = totalamount, }; item.ItemList.ToList().ForEach(a => { var product = _context.Products.Where(c => c.ID == a.ProductId).FirstOrDefault(); pi.Add(new PurchaseItem() { Name = product.Name, Price = a.Price, Qty = a.Qty, TotalPrice = a.TotalPricePerItem, ProductId = a.ProductId, Order = order }); }); _context.AddRange(pi); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(ProductSale))); }
public IActionResult ProductSale() { ProductPruchaseItemViewModel item = new ProductPruchaseItemViewModel(); var product = _context.Products.ToList(); List <Product> p = new List <Product>(); product.ForEach(a => { p.Add(new Product { Name = a.Name, Price = a.Price, ImageName = a.ImageName, Qty = a.Qty, ID = a.ID }); }); item.Products = p; return(View(item)); }
public IActionResult AjaxMethod() { ProductPruchaseItemViewModel item = new ProductPruchaseItemViewModel(); var products = _context.Products.ToList(); List <Product> p = new List <Product>(); products.ForEach(a => { p.Add(new Product() { Name = a.Name, Price = a.Price, ImageName = a.ImageName, Qty = a.Qty, ID = a.ID }); }); //item.Product = p; item.Products = p; item.TotalPrice = p.Sum(p => p.Price * p.Qty); //item.TotalPrice = p.Price * p.Qty; return(View(item)); //List<Product> products = (from product in _context.Products // select product).ToList(); //return View(products); }