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