public Address GetItem(int key) { Address address = null; using (var ctx = new OrderTakerDataContext(Database.OrderTakerConnection)) { var dataAddress = (from a in ctx.DataAddresses where a.Id == key select a).FirstOrDefault(); if (dataAddress != null) { address = ModelConverters.GetAddressFromDataAddress(dataAddress); } } return(address); }
public IEnumerable <Address> GetItems() { var addresses = new List <Address>(); using (var ctx = new OrderTakerDataContext(Database.OrderTakerConnection)) { var dataAddresses = from a in ctx.DataAddresses select a; foreach (var dataAddress in dataAddresses) { addresses.Add(ModelConverters.GetAddressFromDataAddress(dataAddress)); } } return(addresses); }
public IEnumerable <Address> SearchByName(string searchString) { var addresses = new List <Address>(); using (var ctx = new OrderTakerDataContext(Database.OrderTakerConnection)) { var dataAddresses = from a in ctx.DataAddresses where a.DataCustomer.FirstName.Contains(searchString) || a.DataCustomer.LastName.Contains(searchString) select a; foreach (var dataAddress in dataAddresses) { addresses.Add(ModelConverters.GetAddressFromDataAddress(dataAddress)); } } return(addresses); }
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); }