public Product GetItem(int key)
{
Product product = null;
using (var ctx = new OrderTakerDataContext(Database.OrderTakerConnection))
{
var dataProduct = (from p in ctx.DataProducts
where p.Id == key
select p).FirstOrDefault();
if (dataProduct != null)
{
product = ModelConverters.GetProductFromDataProduct(dataProduct);
}
}
return(product);
}
public OrderItem GetItem(int key)
{
OrderItem orderItem = null;
using (var ctx = new OrderTakerDataContext(Database.OrderTakerConnection))
{
var dataOrderItem = (from oi in ctx.DataOrderItems
where oi.Id == key
select oi).FirstOrDefault();
if (dataOrderItem != null)
{
orderItem = ModelConverters.GetOrderItemFromDataOrderItem(dataOrderItem);
orderItem.Product = ModelConverters.GetProductFromDataProduct(dataOrderItem.DataProduct);
}
}
return(orderItem);
}
public IEnumerable <OrderItem> GetItems()
{
var orderItems = new List <OrderItem>();
using (var ctx = new OrderTakerDataContext(Database.OrderTakerConnection))
{
var dataOrderItems = from oi in ctx.DataOrderItems
select oi;
foreach (var dataOrderItem in dataOrderItems)
{
var orderItem = ModelConverters.GetOrderItemFromDataOrderItem(dataOrderItem);
orderItem.Product = ModelConverters.GetProductFromDataProduct(dataOrderItem.DataProduct);
orderItems.Add(orderItem);
}
}
return(orderItems);
}
public IEnumerable <Product> SearchByName(string searchString)
{
var products = new List <Product>();
using (var ctx = new OrderTakerDataContext(Database.OrderTakerConnection))
{
var dataProducts = from p in ctx.DataProducts
where p.ProductName.Contains(searchString) &&
p.Active
select p;
foreach (var dataProduct in dataProducts)
{
products.Add(ModelConverters.GetProductFromDataProduct(dataProduct));
}
}
return(products);
}
public IEnumerable <Product> GetItems()
{
var products = new List <Product>();
using (var ctx = new OrderTakerDataContext(Database.OrderTakerConnection))
{
var dataProducts = from p in ctx.DataProducts
where p.Active
orderby p.ProductName
select p;
foreach (var dataProduct in dataProducts)
{
products.Add(ModelConverters.GetProductFromDataProduct(dataProduct));
}
}
return(products);
}
public IEnumerable <OrderItem> SearchByName(string searchString)
{
var orderItems = new List <OrderItem>();
using (var ctx = new OrderTakerDataContext(Database.OrderTakerConnection))
{
var dataOrderItems = from oi in ctx.DataOrderItems
where oi.DataProduct.ProductName.Contains(searchString)
select oi;
foreach (var dataOrderItem in dataOrderItems)
{
var orderItem = ModelConverters.GetOrderItemFromDataOrderItem(dataOrderItem);
orderItem.Product = ModelConverters.GetProductFromDataProduct(dataOrderItem.DataProduct);
orderItems.Add(orderItem);
}
}
return(orderItems);
}
