public void AddItem(Order newItem) { var dataOrder = ModelConverters.GetDataOrderFromOrder(newItem); using (var transaction = new TransactionScope()) { try { using (var ctx = new OrderTakerDataContext(Database.OrderTakerConnection)) { if (dataOrder.DataAddress.Id == 0) { ctx.DataAddresses.InsertOnSubmit(dataOrder.DataAddress); } ctx.DataOrders.InsertOnSubmit(dataOrder); ctx.DataOrderItems.InsertAllOnSubmit(dataOrder.DataOrderItems); ctx.SubmitChanges(); transaction.Complete(); } } catch { } } }
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 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 Product GetItem(int key) { Product product = null; using (var ctx = new OrderTakerDataContext(Database.OrderTakerConnection)) { var dataProduct = (from p in ctx.DataProducts where p.Id == key select p).FirstOrDefault(); if (dataProduct != null) { product = ModelConverters.GetProductFromDataProduct(dataProduct); } } return(product); }
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 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 <Product> SearchByName(string searchString) { var products = new List <Product>(); using (var ctx = new OrderTakerDataContext(Database.OrderTakerConnection)) { var dataProducts = from p in ctx.DataProducts where p.ProductName.Contains(searchString) && p.Active select p; foreach (var dataProduct in dataProducts) { products.Add(ModelConverters.GetProductFromDataProduct(dataProduct)); } } return(products); }
public IEnumerable <Product> GetItems() { var products = new List <Product>(); using (var ctx = new OrderTakerDataContext(Database.OrderTakerConnection)) { var dataProducts = from p in ctx.DataProducts where p.Active orderby p.ProductName select p; foreach (var dataProduct in dataProducts) { products.Add(ModelConverters.GetProductFromDataProduct(dataProduct)); } } return(products); }
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 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); }
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); }