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