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