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