public void AddItemToCart(int productID, int quantity, int EmployeeId) { using (var context = new eRaceContext()) { var exists = (from item in context.SalesCartItems where item.EmployeeID == EmployeeId && item.ProductID == productID select item).FirstOrDefault(); if (exists == null) { SalesCartItem inCart = new SalesCartItem(); inCart.EmployeeID = EmployeeId; inCart.ProductID = productID; inCart.Quantity = quantity; context.SalesCartItems.Add(inCart); } else { var newQty = context.SalesCartItems.Where(x => x.EmployeeID == EmployeeId && x.ProductID == productID).FirstOrDefault(); newQty.Quantity += quantity; } context.SaveChanges(); } }
public void Add_ItemToCart(int employeid, int productid, int qty) { if (qty < 0) { throw new Exception("Quantity cannot be zero"); } else { //var buyItem = context.SalesCartItems.Add(new SalesCartItem()); //buyItem.ProductID = productid; //buyItem.EmployeeID = employeid; //buyItem.Quantity = qty; using (var context = new eRaceContext()) { Product newProduct = null; int product = 0; Product products = new Product(); Product prdct = (from x in context.Products .Where(x => x.ProductID.Equals(productid)) select x).FirstOrDefault(); SalesCartItem exists = (from x in context.SalesCartItems .Where(x => x.EmployeeID.Equals(employeid) && x.ProductID.Equals(productid)) select x).FirstOrDefault(); if (exists == null) { exists = new SalesCartItem(); exists.EmployeeID = employeid; exists.ProductID = productid; exists.UnitPrice = prdct.ItemPrice; exists.Quantity = qty; exists = context.SalesCartItems.Add(exists); product = 1; } else { newProduct = exists.Product.Category.Products.SingleOrDefault(x => x.ProductID == productid); if (newProduct == null) { product = exists.Product.Category.Products.Count() + 1; } else { product = exists.Quantity++; } } context.SaveChanges(); } } }//end of Add_ItemToCart
}//end of Add_ItemToCart public void Delete_ProductItem(int employeeid, int productid) { using (var context = new eRaceContext()) { SalesCartItem exists = (from x in context.SalesCartItems .Where(x => x.EmployeeID.Equals(employeeid) && x.ProductID.Equals(productid)) select x).FirstOrDefault(); var findItem = context.SalesCartItems.Where(x => x.ProductID == productid).FirstOrDefault(); context.Entry(findItem).State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); } }//end of Delete_ProductItem
public void Payment_Order(int employeeid, decimal total, List <ShoppingCart> info) { using (var context = new eRaceContext()) { Invoice products = new Invoice(); SalesCartItem cartItem = new SalesCartItem(); SalesCartItem exists = (from x in context.SalesCartItems .Where(x => x.EmployeeID.Equals(employeeid)) select x).FirstOrDefault(); var controller = new ShoppingCartController(); var totalCalculate = controller.ShoppingCart_OrderList(); products.InvoiceID = products.InvoiceID; products.EmployeeID = employeeid; products.InvoiceDate = DateTime.Now; products.SubTotal = decimal.Parse(totalCalculate.Sum(x => x.Amount).ToString()); products.GST = decimal.Parse(totalCalculate.Sum(t => t.Quantity * t.Price * decimal.Parse(0.05.ToString())).ToString()); products.Total = total; products = context.Invoices.Add(products); context.SaveChanges(); //InvoiceDetail infoInvoice = new InvoiceDetail(); var invoiceDetails = context.InvoiceDetails.Add(new InvoiceDetail()); foreach (var item in info) { invoiceDetails.InvoiceID = products.InvoiceID; var productfind = context.SalesCartItems.Where(x => x.Product.ProductID == item.ProductID).Single(); productfind.Product.QuantityOnHand = productfind.Product.QuantityOnHand - item.Quantity; invoiceDetails.InvoiceDetailID = invoiceDetails.InvoiceDetailID++; invoiceDetails.ProductID = productfind.ProductID; invoiceDetails.Price = productfind.Product.ItemPrice; invoiceDetails.Quantity = item.Quantity; invoiceDetails = context.InvoiceDetails.Add(invoiceDetails); context.SaveChanges(); } } }
public void ClearButton_Shopping(int employeeid) { using (var context = new eRaceContext()) { SalesCartItem exists = (from x in context.SalesCartItems .Where(x => x.EmployeeID.Equals(employeeid)) select x).FirstOrDefault(); var clearCart = context.SalesCartItems.Where(x => x.EmployeeID == employeeid).ToList(); foreach (var item in clearCart) { context.Entry(item).State = System.Data.Entity.EntityState.Deleted; } context.Entry(exists).State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); } }
}//end of Delete_ProductItem public void Quantity_Refresh(int employeeid, int productid, int quantity) { using (var context = new eRaceContext()) { SalesCartItem exists = (from x in context.SalesCartItems .Where(x => x.EmployeeID.Equals(employeeid) && x.ProductID.Equals(productid)) select x).FirstOrDefault(); exists.EmployeeID = employeeid; exists.ProductID = productid; exists.Quantity = quantity; context.Entry(exists).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }//End of Quantity_Refresh