public Order GetItem(int key)
{
Order order = null;
using (var ctx = new OrderTakerDataContext(Database.OrderTakerConnection))
{
var dataOrder = (from o in ctx.DataOrders
select o).FirstOrDefault();
if (dataOrder != null)
{
order = ModelConverters.GetOrderFromDataOrder(dataOrder);
order.Customer = ModelConverters.GetCustomerFromDataCustomer(dataOrder.DataCustomer);
order.ShippingAddress = ModelConverters.GetAddressFromDataAddress(dataOrder.DataAddress);
order.OrderItems = orderItemRepo.GetItems(order.Id).ToList();
}
}
return(order);
}
public IEnumerable <Order> GetItems()
{
var orders = new List <Order>();
using (var ctx = new OrderTakerDataContext(Database.OrderTakerConnection))
{
var dataOrders = from o in ctx.DataOrders
select o;
foreach (var dataOrder in dataOrders)
{
var order = ModelConverters.GetOrderFromDataOrder(dataOrder);
order.Customer = ModelConverters.GetCustomerFromDataCustomer(dataOrder.DataCustomer);
order.ShippingAddress = ModelConverters.GetAddressFromDataAddress(dataOrder.DataAddress);
order.OrderItems = orderItemRepo.GetItems(order.Id).ToList();
orders.Add(order);
}
}
return(orders);
}
public IEnumerable <Order> SearchByName(string searchString)
{
var orders = new List <Order>();
using (var ctx = new OrderTakerDataContext(Database.OrderTakerConnection))
{
var dataOrders = from o in ctx.DataOrders
where o.DataCustomer.FirstName.Contains(searchString) ||
o.DataCustomer.LastName.Contains(searchString)
select o;
foreach (var dataOrder in dataOrders)
{
var order = ModelConverters.GetOrderFromDataOrder(dataOrder);
order.Customer = ModelConverters.GetCustomerFromDataCustomer(dataOrder.DataCustomer);
order.ShippingAddress = ModelConverters.GetAddressFromDataAddress(dataOrder.DataAddress);
order.OrderItems = orderItemRepo.GetItems(order.Id).ToList();
orders.Add(order);
}
}
return(orders);
}
