public Order GetOrderByID(int ID)
{
using (var context = new OMContext())
{
return(context.Orders.Where(x => x.OrderId == ID).Include(x => x.OrderItems).Include("OrderItems.Product").FirstOrDefault());
}
}
public List <Product> GetProducts(List <int> ids)
{
using (var context = new OMContext())
{
return(context.Products.Where(product => ids.Contains(product.Id)).ToList());
}
}
public Product GetProduct(int id)
{
using (var context = new OMContext())
{
return(context.Products.Where(x => x.Id == id).Include(x => x.Category).FirstOrDefault());
}
}
public void DeleteProduct(int id)
{
using (var context = new OMContext())
{
var product = context.Products.Find(id);
context.Products.Remove(product ?? throw new InvalidOperationException());
context.SaveChanges();
}
}
public void UpdateProduct(Product product)
{
using (var context = new OMContext())
{
//context.Categories.AddOrUpdate(category);
context.Entry(product).State = EntityState.Modified;
context.SaveChanges();
}
}
public void ProductSave(Product product)
{
using (var context = new OMContext())
{
context.Entry(product.Category).State = EntityState.Unchanged;
context.Products.Add(product);
context.SaveChanges();
}
}
public bool UpdateOrderStatus(int ID, string status)
{
using (var context = new OMContext())
{
var order = context.Orders.Find(ID);
order.Status = status;
context.Entry(order).State = EntityState.Modified;
return(context.SaveChanges() > 0);
}
}
public int SearchOrdersCount(string userId, string status)
{
using (var context = new OMContext())
{
var orders = context.Orders.ToList();
if (!string.IsNullOrEmpty(userId))
{
orders = orders.Where(x => x.UserId.ToLower().Contains(userId.ToLower())).ToList();
}
if (!string.IsNullOrEmpty(status))
{
orders = orders.Where(x => x.Status.ToLower().Contains(status.ToLower())).ToList();
}
return(orders.Count);
}
}
public List <Order> SearchOrders(string userId, string status, int pageNo, int pageSize)
{
using (var context = new OMContext())
{
var orders = context.Orders.ToList();
if (!string.IsNullOrEmpty(userId))
{
orders = orders.Where(x => x.UserId.ToLower().Contains(userId.ToLower())).ToList();
}
if (!string.IsNullOrEmpty(status))
{
orders = orders.Where(x => x.Status.ToLower().Contains(status.ToLower())).ToList();
}
return(orders.Skip((pageNo - 1) * pageSize).Take(pageSize).ToList());
}
}
public ShopService(OMContext context)
{
_context = context;
}
protected ProductService(OMContext context)
{
_context = context;
}
protected CategoryService(OMContext context)
{
//Dogrudan _context kullanılmalı (using() tekrarı gereksiz.)
_context = context;
}
