public Order CreateOrderModelFromCart(Guid id)
{
using (var db = new SimpleEcommerceContext())
{
return(db.Carts.FirstOrDefault(x => x.SessionId.Equals(id)).MapToOrder());
}
}
public Product Get(int id)
{
using (var db = new SimpleEcommerceContext())
{
return(db.Products.FirstOrDefault(x => x.ID.Equals(id)));
}
}
public CartViewModel GetViewModel(Guid id)
{
using (var db = new SimpleEcommerceContext())
{
return(db.Carts.FirstOrDefault(x => x.SessionId.Equals(id)).Map());
}
}
public OrderViewModel GetViewModel(int id)
{
using (var db = new SimpleEcommerceContext())
{
return(db.Orders.FirstOrDefault(x => x.ID == id).Map());
}
}
public Order Get(int id)
{
using (var db = new SimpleEcommerceContext())
{
return(db.Orders.FirstOrDefault(x => x.ID == id));
}
}
public IList <OrderRow> GetFromCartId(int id)
{
using (var db = new SimpleEcommerceContext())
{
return(db.OrderRows.Where(x => x.CartID.Value.Equals(id)).ToList());
}
}
public List <ProductViewModel> GetAll()
{
using (var db = new SimpleEcommerceContext())
{
var products = db.Products.ToList();
return(products.Select(x => x.Map()).ToList());
}
}
public void Create(Cart cart)
{
using (var db = new SimpleEcommerceContext())
{
db.Carts.Add(cart);
db.SaveChanges();
}
}
public void PlaceOrder(Order order)
{
using (var db = new SimpleEcommerceContext())
{
db.Orders.Add(order);
db.SaveChanges();
}
}
public void Create(OrderRow orderRow)
{
using (var db = new SimpleEcommerceContext())
{
db.OrderRows.Add(orderRow);
db.SaveChanges();
}
}
public void AddOne(OrderRow orderRow)
{
using (var db = new SimpleEcommerceContext())
{
var orderRowPersisted = db.OrderRows.FirstOrDefault(x => x.ID.Equals(orderRow.ID));
orderRowPersisted.Quantity++;
db.SaveChanges();
}
}
public void Clear(Guid id)
{
using (var db = new SimpleEcommerceContext())
{
var cart = db.Carts.FirstOrDefault(x => x.SessionId.Equals(id));
foreach (var orderRow in db.OrderRows.Where(x => x.CartID == cart.ID))
{
orderRow.CartID = null;
}
db.SaveChanges();
}
}
