public static void AddProductToCart(int productID, int customerID, int quantity)
{
using (var db = new ShopModel())
{
//LINQ & Lambda
var cart =
db.ShoppingCarts.Where(s => s.CustomerID == customerID).FirstOrDefault();
if (cart == null)
{
// Did not find a cart
cart = new ShoppingCart
{
CustomerID = customerID
};
db.ShoppingCarts.Add(cart);
}
var product = db.Products.Where(p => p.ProductID == productID).FirstOrDefault();
if (product != null)
{
var detailEntry = new ShoppingCartDetail
{
ShoppingCartID = cart.ShoppingCartID,
ProductId = product.ProductID,
Quantity = quantity,
SubTotal = quantity * product.Price
};
db.ShoppingCartDetails.Add(detailEntry);
}
db.SaveChanges();
}
}
// public static OrderHeader CreateOrder
public static void AddProductToCart(int productId, int customerId, int quantity)
{
using (var db = new ShopModel())
{
//LING (language integrated Query) & LAMBDA
var cart = db.ShoppingCarts.Where(s => s.CustomerId == customerId).FirstOrDefault();
if (cart == null)
{
//did not find a cart - create one
cart = new ShoppingCart
{
CustomerId = customerId
};
db.ShoppingCarts.Add(cart);
}
var product = db.Products.Where(p => p.ProductId == productId).FirstOrDefault();
if (product != null)
{
var detailEntry = new ShoppingCartDetail
{
ShoppingCartId = cart.ShoppingCartId,
ProductId = product.ProductId,
Quantity = quantity,
SubTotal = quantity * product.Price
};
db.ShoppingCartDetails.Add(detailEntry);
}
db.SaveChanges();
}
}
public static IEnumerable<ShoppingCartDetail> GetShoppingCartDetails(int customerId)
{
var db = new ShopModel();
var shoppingCart = db.ShoppingCarts.Where(s => s.CustomerId == customerId).FirstOrDefault();
if (shoppingCart == null)
{
throw new ArgumentException("Shopping cart not found for the customer");
}
return db.ShoppingCartDetails.Where(d => d.ShoppingCartId == shoppingCart.ShoppingCartId);
}
public static Customer CreateCustomer(string name, int ssn, string address, string emailAdd)
{
using (var db = new ShopModel())
{
var cust = new Customer(); //same //Customer customer = new Customer()
cust.Name = name;
cust.SSN = ssn;
cust.Address = address;
cust.EmailAddress = emailAdd;
db.Customers.Add(cust);
db.SaveChanges();
return cust;
}
}
public static Customer CreateCustomer(string name, int ssn, string address, string email)
{
using (var db = new ShopModel())
{
var c = new Customer();
c.Name = name;
c.SSN = ssn;
c.Address = address;
c.EmailAddress = email;
db.Customers.Add(c);
db.SaveChanges();
return c;
}
}
public static Product CreateProduct(string name, string description, decimal price, decimal weight, string image)
{
using (var db = new ShopModel())
{
var p = new Product
{
Name = name,
Description = description,
Weight = weight,
Price = price,
Image = image
};
db.Products.Add(p);
db.SaveChanges();
return p;
}
}
public static IEnumerable<Product> GetAllProducts()
{
var db = new ShopModel();
return db.Products;
}
public static IEnumerable<Product> SearchProducts(decimal priceValue)
{
var db =new ShopModel();
return db.Products.Where(p => p.Price <= priceValue);
}
public static void UpdateProduct(Product updatedProduct)
{
using (var db = new ShopModel())
{
var product = db.Products.
Where(p => p.ProductId == updatedProduct.ProductId).FirstOrDefault();
if (product == null)
return;
var originalProduct = product;
product.Name = updatedProduct.Name;
product.Price = updatedProduct.Price;
product.Weight = updatedProduct.Weight;
product.Image = updatedProduct.Image;
product.Description = updatedProduct.Description;
db.Entry(originalProduct).CurrentValues.SetValues(product);
db.SaveChanges();
}
}
public static Product GetProductById(int id)
{
var db = new ShopModel();
return db.Products.Where(p => p.ProductId == id).FirstOrDefault();
}
public static void DeleteProduct(Product product)
{
using (var db = new ShopModel())
{
db.Products.Remove(product);
db.SaveChanges();
}
}
