public IEnumerable <Category> GetAllCategories() { using (var dc = new EcommerceDataContext(_connectionString)) { return(dc.Categories.ToList()); } }
public IEnumerable <Image> GetAllImagesByProduct(int productId) { using (var dc = new EcommerceDataContext(_connectionString)) { return(dc.Images.Where(i => i.ProductId == productId).ToList()); } }
public IEnumerable <Image> GetAllImages() { using (var dc = new EcommerceDataContext(_connectionString)) { return(dc.Images.ToList()); } }
public Image GetFirstImageByProduct(int productId) { using (var dc = new EcommerceDataContext(_connectionString)) { return(dc.Images.Where(i => i.ProductId == productId).FirstOrDefault()); } }
public void AddImages(IEnumerable <Image> images) { using (var dc = new EcommerceDataContext(_connectionString)) { dc.Images.InsertAllOnSubmit(images); dc.SubmitChanges(); } }
public void AddProduct(Product product) { using (var dc = new EcommerceDataContext(_connectionString)) { dc.Products.InsertOnSubmit(product); dc.SubmitChanges(); } }
public void AddCategory(Category category) { using (var dc = new EcommerceDataContext(_connectionString)) { dc.Categories.InsertOnSubmit(category); dc.SubmitChanges(); } }
public void AddCartItems(CartItem c) { using (var dc = new EcommerceDataContext(_connectionString)) { dc.CartItems.InsertOnSubmit(c); dc.SubmitChanges(); } }
public void AddNewShopCart(ShoppingCart s) { using (var dc = new EcommerceDataContext(_connectionString)) { dc.ShoppingCarts.InsertOnSubmit(s); dc.SubmitChanges(); } }
public IEnumerable <Product> GetProductsByCategory(int?categoryId) { using (var dc = new EcommerceDataContext(_connectionString)) { var loadOptions = new System.Data.Linq.DataLoadOptions(); loadOptions.LoadWith <Product>(p => p.Images); dc.LoadOptions = loadOptions; return(dc.Products.Where(p => p.Categoryid == categoryId).ToList()); } }
public Product GetProduct(int id) { using (var dc = new EcommerceDataContext(_connectionString)) { var loadOptions = new System.Data.Linq.DataLoadOptions(); loadOptions.LoadWith <Product>(p => p.Images); loadOptions.LoadWith <Product>(p => p.Category); dc.LoadOptions = loadOptions; return(dc.Products.First(p => p.Id == id)); } }
public int GetTotalQuantityByShoppingCartId(int id) { using (var dc = new EcommerceDataContext(_connectionString)) { DataLoadOptions options = new System.Data.Linq.DataLoadOptions(); options.LoadWith <CartItem>(cartItem => cartItem.Product); options.LoadWith <Product>(product => product.Images); dc.LoadOptions = options; return(dc.CartItems.AsEnumerable().Where(c => c.ShoppingCartId == id).Sum(c => c.Quantity));//// } }
///needs more work - done; public List <CartItem> GetCartItemsByShoppingCartId(int id) { using (var dc = new EcommerceDataContext(_connectionString)) { DataLoadOptions options = new System.Data.Linq.DataLoadOptions(); options.LoadWith <CartItem>(cartItem => cartItem.Product); options.LoadWith <Product>(product => product.Images); dc.LoadOptions = options; return(dc.CartItems.Where(c => c.ShoppingCartId == id).ToList()); } }