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; }