public Customer GetItem(int key)
{
Customer customer = null;
using (var ctx = new OrderTakerDataContext(Database.OrderTakerConnection))
{
var dataCustomer = (from c in ctx.DataCustomers
where c.Id == key
select c).FirstOrDefault();
customer = ModelConverters.GetCustomerFromDataCustomer(dataCustomer);
}
return(customer);
}
public IEnumerable <Customer> GetItems()
{
var customers = new List <Customer>();
using (var ctx = new OrderTakerDataContext(Database.OrderTakerConnection))
{
var dataCustomers = from c in ctx.DataCustomers
select c;
foreach (var dataCustomer in dataCustomers)
{
customers.Add(ModelConverters.GetCustomerFromDataCustomer(dataCustomer));
}
}
return(customers);
}
public IEnumerable <Customer> SearchByName(string searchString)
{
var customers = new List <Customer>();
using (var ctx = new OrderTakerDataContext(Database.OrderTakerConnection))
{
var dataCustomers = from c in ctx.DataCustomers
where c.FirstName.Contains(searchString) ||
c.LastName.Contains(searchString)
select c;
foreach (var dataCustomer in dataCustomers)
{
customers.Add(ModelConverters.GetCustomerFromDataCustomer(dataCustomer));
}
}
return(customers);
}
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);
}
