public IList <OrderDetail> GetOrderLinesbyOrder(int id)
{
using (StoreDbEntities db = new StoreDbEntities())
{
}
throw new NotImplementedException();
}
public IList <Produit> GetProduitByCriterias(string nom)
{
using (StoreDbEntities db = new StoreDbEntities())
{
}
throw new NotImplementedException();
}
public int?ShoppingRemoveFromCart(int id, string ShoppingCartId)
{
using (StoreDbEntities db = new StoreDbEntities())
{
// Get the cart
var cartItem = db.Cart.Single(
cart => cart.CartId == ShoppingCartId &&
cart.RecordId == id);
int?itemCount = 0;
if (cartItem != null)
{
db.Cart.Remove(cartItem);
//if (cartItem.Count > 1)
//{
// cartItem.Count--;
// itemCount = cartItem.Count;
//}
//else
//{
// db.Cart.Remove(cartItem);
//}
//// Save changes
db.SaveChanges();
}
return(itemCount);
}
}
public void ShoppingAddMoreProductToCart(Produit produit, string ShoppingCartId, int number)
{
using (StoreDbEntities db = new StoreDbEntities())
{
// Get the matching cart and produit instances
var cartItem = db.Cart.SingleOrDefault(
c => c.CartId == ShoppingCartId &&
c.ProduitId == produit.ProduitId);
if (cartItem == null)
{
// Create a new cart item if no cart item exists
cartItem = new Cart
{
ProduitId = produit.ProduitId,
CartId = ShoppingCartId,
Count = 1,
DateCreated = DateTime.Now
};
db.Cart.Add(cartItem);
}
else
{
// If the item does exist in the cart,
// then add one to the quantity
cartItem.Count = number;
}
// Save changes
db.SaveChanges();
}
}
public IList <Genre> GetGenres()
{
using (StoreDbEntities db = new StoreDbEntities())
{
var result = db.Genre.ToList();
return(result);
}
}
public IList <Order> GetOrders()
{
using (StoreDbEntities db = new StoreDbEntities())
{
var order = db.Order.ToList();
return(order);
}
}
public IList <Order> GetOrderByCustumer(string email)
{
using (StoreDbEntities db = new StoreDbEntities())
{
var result = (from s in db.Order where s.Email == email & s.OrderDate == s.OrderDate select s).ToList();
return(result);
}
}
public bool ShoppingIsValid(int id, string name)
{
using (StoreDbEntities db = new StoreDbEntities())
{
var result = db.Order.Any(o => o.OrderId == id && o.UserName == name);
return(result);
}
}
public List <Cart> ShoppingGetCartItems(string ShoppingCartId)
{
using (StoreDbEntities db = new StoreDbEntities())
{
return(db.Cart.Include("Produit").Where(
cart => cart.CartId == ShoppingCartId).ToList());
}
}
public Marque GetMarqueByid(int id)
{
using (StoreDbEntities db = new StoreDbEntities())
{
var result = db.Marque.Find(id);
return(result);
}
}
public IList <Marque> GetMarques()
{
using (StoreDbEntities db = new StoreDbEntities())
{
var result = db.Marque.ToList();
return(result);
}
}
public IList <Produit> GetProduitByCategoryId(int id)
{
using (StoreDbEntities db = new StoreDbEntities())
{
return(db.Produit.Where(p => p.GenreId == id).ToList());
}
throw new NotImplementedException();
}
public OrderDetail GetOrderDetailByid(int id)
{
using (StoreDbEntities db = new StoreDbEntities())
{
var result = db.OrderDetail.Find(id);
return(result);
}
}
public Genre GetGenreByid(int id)
{
using (StoreDbEntities db = new StoreDbEntities())
{
var result = db.Genre.Find(id);
return(result);
}
}
public Cart GetCartByid(int id)
{
using (StoreDbEntities db = new StoreDbEntities())
{
var result = db.Cart.Include("Produit").Where(c => c.RecordId == id).FirstOrDefault();
return(result);
}
}
public IList <Cart> GetCarts()
{
using (StoreDbEntities db = new StoreDbEntities())
{
var result = (from s in db.Cart.Include("Produit") select s).OrderBy(p => p.DateCreated).ToList();
return(result);
//var cart = db.Cart.ToList();
//return cart;
}
}
public IList <OrderDetail> GetOrderDetailsCustumer(int OrderID)
{
using (StoreDbEntities db = new StoreDbEntities())
{
var result = (from s in db.OrderDetail.Include("Order").Include("Produit") where s.OrderId == OrderID select s).ToList();
return(result);
//var orderDatail = db.OrderDetail.ToList();
//return orderDatail;
}
}
public void ShoppingUpdateStock(OrderDetail order)
{
using (StoreDbEntities db = new StoreDbEntities())
{
var result = db.Produit.Find(order.ProduitId);
result.Quantite -= order.Quantity;
db.Entry(result).State = EntityState.Modified;
db.SaveChanges();
}
}
public Produit GetProduitByid(int id)
{
using (StoreDbEntities db = new StoreDbEntities())
{
var result = db.Produit.Include(p => p.Marque)
.Include(p => p.Genre)
.FirstOrDefault(p => p.ProduitId == id);
return(result);
}
}
public IList <Produit> GetProduitByMarque(string marque)
{
using (StoreDbEntities db = new StoreDbEntities())
{
var products = (from s in db.Produit.Include("Marque").Include("Genre")
where s.Marque.Name.Equals(marque)
select s).ToList();
return(products);
}
}
public string Add(Image image)
{
if (image == null)
{
return(null);
}
StoreDbEntities.Images.Add(image);
StoreDbEntities.SaveChanges();
return(image.ImagePath);
}
public IList <Produit> GetProduitSearchByCriteria(string search)
{
using (StoreDbEntities db = new StoreDbEntities())
{
var products = (from s in db.Produit.Include("Marque").Include("Genre")
where s.Title.Contains(search) || s.Genre.Name.Contains(search) || s.Marque.Name.Contains(search)
select s).ToList();
return(products);
}
}
public IList <Produit> GetProduits()
{
using (StoreDbEntities db = new StoreDbEntities())
{/*var quizz = (from s in dbContext.Quizzs.Include("Course") select s).ToList();
* return quizz;
* //dbContext.Quizzs.Include(q => q.Course).ToList();
* }*/
var products = (from s in db.Produit.Include("Marque").Include("Genre") select s).ToList();
return(products);
}
}
public Produit AddProduit(Produit produit)
{
using (StoreDbEntities db = new StoreDbEntities())
{
var result = db.Produit.Add(produit);
if (db.SaveChanges() > 0)
{
return(result);
}
return(null);
}
}
public Genre AddGenre(Genre genre)
{
using (StoreDbEntities db = new StoreDbEntities())
{
var result = db.Genre.Add(genre);
if (db.SaveChanges() > 0)
{
return(result);
}
return(null);
}
}
public Marque AddMarque(Marque marque)
{
using (StoreDbEntities db = new StoreDbEntities())
{
var result = db.Marque.Add(marque);
if (db.SaveChanges() > 0)
{
return(result);
}
return(null);
}
}
public int ShoppingGetCount(string ShoppingCartId)
{
using (StoreDbEntities db = new StoreDbEntities())
{
// Get the count of each item in the cart and sum them up
int?count = (from cartItems in db.Cart
where cartItems.CartId == ShoppingCartId
select(int?) cartItems.Count).Sum();
// Return 0 if all entries are null
return(count ?? 0);
}
}
public Cart AddCart(Cart cart)
{
using (StoreDbEntities db = new StoreDbEntities())
{
var result = db.Cart.Add(cart);
if (db.SaveChanges() > 0)
{
return(result);
}
return(null);
}
}
public Order AddOrder(Order order)
{
using (StoreDbEntities db = new StoreDbEntities())
{
var result = db.Order.Add(order);
if (db.SaveChanges() > 0)
{
return(result);
}
return(null);
}
}
public OrderDetail AddOrderDetail(OrderDetail orderDetail)
{
using (StoreDbEntities db = new StoreDbEntities())
{
var result = db.OrderDetail.Add(orderDetail);
if (db.SaveChanges() > 0)
{
return(result);
}
return(null);
}
}
