public Customer SearchCustomersById(int custId) { if (_db.Customer.Any(s => s.Id == custId)) { return(OrderMapper.Map(_db.Customer.Find(custId))); } else { return(null); } }
public Order GetOrderById(int ordId) { if (_db.Cart.Any(s => s.Id == ordId)) { return(OrderMapper.Map(_db.Cart.First(x => x.Id == ordId))); } else { return(null); } }
public Location SearchLocationsById(int locId) { if (_db.Location.Any(s => s.Id == locId)) { return(OrderMapper.Map(_db.Location.Find(locId))); } else { return(null); } }
public Products SearchProductsById(int prodId) { if (_db.Product.Any(s => s.Id == prodId)) { return(OrderMapper.Map(_db.Product.Find(prodId))); } else { return(null); } }
public Customer SearchCustomersByName(string fName, string lName) { if (_db.Customer.Any(s => s.FirstName == fName && s.LastName == lName)) { return(OrderMapper.Map(_db.Customer.First(s => s.FirstName == fName && s.LastName == lName))); } else { return(null); } }
public void AddInventory(Library.Inventory inv) { if (_db.Inventory.Any(s => s.LocationId == inv.LocationId && s.ProdId == inv.ProductId)) { _db.Inventory.First(i => i.ProdId == inv.ProductId && i.LocationId == inv.LocationId).Quant = inv.Quantity; } else { _db.Add(OrderMapper.Map(inv)); } _db.SaveChanges(); }
public void AddProduct(Products prod) { if (_db.Product.Any(i => i.Id == prod.ProdId)) { _db.Product.First(p => p.Id == prod.ProdId).Price = prod.Price; } else { _db.Add(OrderMapper.Map(prod)); } _db.Add(OrderMapper.DualMap(prod)); _db.SaveChanges(); }
public void AddOrder(Order ord) { Order temp = new Order(); int newId = 0; if (_db.Cart.Any()) { temp = OrderMapper.Map(_db.Cart.Last()); newId = temp.OrdId + 1; } ord.OrdId = newId; _db.Add(OrderMapper.Map(ord)); _db.SaveChanges(); }
public IEnumerable <Library.Location> GetLocations() { return(OrderMapper.Map(_db.Location.Include(r => r.Customer))); }
public void RemoveCustomer(Customer cust) { _db.Remove(OrderMapper.Map(cust)); }
public void AddLocation(Location loc) { _db.Add(OrderMapper.Map(loc)); _db.SaveChanges(); }
public IEnumerable <Order> SearchOrdersByStore(int LocId) { return(OrderMapper.Map(_db.Cart.Where(r => r.LocId == LocId))); }
public IEnumerable <Library.Customer> GetCustomers() { return(OrderMapper.Map(_db.Customer)); }
public void AddCustomer(Customer cust) { _db.Add(OrderMapper.Map(cust)); _db.SaveChanges(); }
public IEnumerable <Order> GetAllOrders() { return(OrderMapper.Map(_db.Cart)); }
public IEnumerable <Library.Products> GetProductHistory() { return(OrderMapper.Map(_db.ProdHist)); }
public IEnumerable <Library.Inventory> GetInventory(int LocId) { return(OrderMapper.Map(_db.Inventory.Where(r => r.LocationId == LocId))); }
public IEnumerable <Library.Order> GetCustOrders(int custId) { return(OrderMapper.Map(_db.Cart.Include(r => r.Cust).Where(r => r.Cust.Id == custId))); }