public static IEnumerable<Catalog> FindProductFromCatalog(string searcher, int option)
{
BLHCustomerDbEntities entities = new BLHCustomerDbEntities();
if (option == 1 && searcher != null)
{
IEnumerable<Catalog> display = (from h in entities.Catalogs
where h.ProductName.Contains(searcher)
select h);
return display;
}
if (option == 2 && searcher != null)
{
IEnumerable<Catalog> display = (from h in entities.Catalogs
where h.Category.Contains(searcher)
select h);
return display;
}
if (option == 3 && searcher != null)
{
IEnumerable<Catalog> display = (from h in entities.Catalogs
where h.FullDescription.Contains(searcher)
select h);
return display;
}
return null;
}
public static IEnumerable<Order> FindOrdersByLastZip(string lastName, string zip)
{
BLHCustomerDbEntities customers = new BLHCustomerDbEntities();
IEnumerable<Order> orderByCustomer =
from order in customers.Orders
where order.LastName.Equals(lastName) && order.ZipCode.Equals(zip)
select order;
return orderByCustomer;
}
public static IEnumerable<Order> FindOrdersByCustomer(int customerNumber)
{
BLHCustomerDbEntities customers = new BLHCustomerDbEntities();
IEnumerable<Order> orderByCustomer =
from order in customers.Orders
where order.CustomerNumber == customerNumber
select order;
return orderByCustomer;
}
public static int PlaceOrder(List<LineItem> productList, int customerNumber)
{
BLHCustomerDbEntities entities = new BLHCustomerDbEntities();
CustomerManager manager = new CustomerManager();
BLHCustomer customer = manager.FindCustomer(customerNumber);
Order order = CreateOrder(productList, customer);
entities.Orders.AddObject(order);
entities.SaveChanges();
return GetOrderNumber(order.CustomerNumber, order.FirstName,
order.LastName, order.ZipCode, order.ProductList);
}
private static int GetOrderNumber(int customerNumber, string firstName, string lastName,
string zipCode, string productList)
{
BLHCustomerDbEntities entities = new BLHCustomerDbEntities();
int orderNumber =
(from o in entities.Orders
where customerNumber == o.CustomerNumber && firstName.Equals(o.FirstName) &&
lastName.Equals(o.LastName) && zipCode.Equals(o.ZipCode) && productList.Equals(o.ProductList)
select o.OrderNumber).First();
return orderNumber;
}
public CustomerManager()
{
Customers = new BLHCustomerDbEntities();
}
public FileInput()
{
ZipCodes = new ZipPostalCodeDbEntities();
BLHDb = new BLHCustomerDbEntities();
}
