private ProductSubcategory GetProductSubcategoryById(int subcategoryId)
{
using (var db = new AdventureWorks2008R2Entities())
{
return db.ProductSubcategories.Single<ProductSubcategory>(cat => cat.ProductSubcategoryID == subcategoryId);
}
}
public JsonResult GetCartItems()
{
using (var db = new AdventureWorks2008R2Entities())
{
var cartItems =
GetCartItemsByID(this.HttpContext.User.Identity.Name, db).AsEnumerable();
var dataRows = (cartItems.Select(cartItem => new
{
product = new
{
Id = cartItem.ProductID,
cartItem.Product.Name,
LargeUrl =
VirtualPathUtility.ToAbsolute(
"~/Image/ProductThumbnail?productPhotoID=" +
cartItem.Product.ProductProductPhotoes
.FirstOrDefault<ProductProductPhoto>()
.ProductPhotoID)
},
date = cartItem.DateCreated,
quantity = cartItem.Quantity
})).ToArray();
return Json(dataRows, JsonRequestBehavior.AllowGet);
}
}
private IList<ProductCategory> GetProductCategories()
{
using (var db = new AdventureWorks2008R2Entities())
{
return db.ProductCategories.Include("ProductSubcategories").ToList();
}
}
public void AddToCart(string shoppingCartID, int productID, int quantity)
{
using (var db = new AdventureWorks2008R2Entities())
{
ShoppingCartItem myItem =
(from c in db.ShoppingCartItems
where c.ShoppingCartID == shoppingCartID && c.ProductID == productID
select c).FirstOrDefault();
if (myItem == null)
{
var cartadd = new ShoppingCartItem
{
ShoppingCartID = shoppingCartID,
Quantity = quantity,
ProductID = productID,
DateCreated = DateTime.Now,
ModifiedDate = DateTime.Now
};
db.ShoppingCartItems.AddObject(cartadd);
}
else
{
myItem.Quantity += quantity;
}
db.SaveChanges();
}
}
public void CreateProductInDatabase(Product product)
{
using (var db = new AdventureWorks2008R2Entities())
{
db.Products.AddObject(product);
db.SaveChanges();
}
}
public IQueryable<ShoppingCartItem> GetCartItemsByID(string shoppingCartID, AdventureWorks2008R2Entities db)
{
var cartItems = from cart in db.ShoppingCartItems
where cart.ShoppingCartID == shoppingCartID
select cart;
return cartItems;
}
public IQueryable<Product> GetTop100Products()
{
using (var db = new AdventureWorks2008R2Entities())
{
return db.Products.Top("100");
}
}
//
// GET: /ShoppingCart/
public ActionResult Index()
{
using (var db = new AdventureWorks2008R2Entities())
{
var cartItems =
GetCartItemsByID(this.HttpContext.User.Identity.Name, db).AsEnumerable();
ViewBag.CartTotal = GetTotal(this.HttpContext.User.Identity.Name);
return View(cartItems);
}
}
public Product GetProductById(int productID)
{
using (var db = new AdventureWorks2008R2Entities())
{
Product product = db.Products.Where<Product>(p => p.ProductID == productID).FirstOrDefault<Product>();
return product;
}
}
private int RemoveFromCart(string shoppingCartId, int cartItemId)
{
using (var db = new AdventureWorks2008R2Entities())
{
int itemCount = 0;
//Get the cart
var cartItem = db.ShoppingCartItems.Single(
cart => cart.ShoppingCartID == shoppingCartId
&& cart.ShoppingCartItemID == cartItemId);
if (cartItem != null)
{
if (cartItem.Quantity > 1)
{
cartItem.Quantity--;
itemCount = cartItem.Quantity;
}
else
{
db.ShoppingCartItems.DeleteObject(cartItem);
}
db.SaveChanges();
}
return itemCount;
}
}
private decimal GetTotal(string shoppingCartID)
{
using (var db = new AdventureWorks2008R2Entities())
{
decimal? total =
(from cartItems in db.ShoppingCartItems
where cartItems.ShoppingCartID == shoppingCartID
select (int?)cartItems.Quantity * cartItems.Product.ListPrice)
.Sum();
return total ?? decimal.Zero;
}
}
private int GetCount(string shoppingCartID)
{
using (var db = new AdventureWorks2008R2Entities())
{
int? count = (from cartItems in db.ShoppingCartItems
where cartItems.ShoppingCartID == shoppingCartID
select (int?) cartItems.Quantity).Sum();
return count ?? 0;
}
}