public static List <Customer> allCustomers() { using (var context = new CustomersEntities()) { var cust = from c in context.Customers orderby c.last_name, c.first_name select c; return(cust.ToList()); } }
//Gets a list of productst that your company sells. public static List <Order> getOrderByID(int order_number) { using (var context = new CustomersEntities()) { context.ContextOptions.LazyLoadingEnabled = false; var order = from c in context.Orders where c.order_number == order_number select c; return(order.ToList()); } }
//Method #7 //Gets a list of productst that your company sells. public static List <Product> getProducts() { using (var context = new CustomersEntities()) { context.ContextOptions.LazyLoadingEnabled = false; var product_items = from c in context.Products orderby c.product_description select c; return(product_items.ToList()); } }
//Method #3 //Returns an List of customer objects. public static List <Customer> searchByID(int customerID) { using (var context = new CustomersEntities()) { context.ContextOptions.LazyLoadingEnabled = false; var cust = from c in context.Customers where c.CustomerID == customerID orderby c.last_name, c.first_name select c; return(cust.ToList()); } }
//Method #8 //Gets a list of productst that your company sells. public static List <Order_item> getOrderItemsByOrderID(int order_number) { using (var context = new CustomersEntities()) { context.ContextOptions.LazyLoadingEnabled = false; var order_items = from c in context.Order_item where c.order_number == order_number orderby c.item_id select c; return(order_items.ToList()); } }
//Method #2 //Returns an List of customer objects. public static List <Customer> search(Customer myCustomer) { using (var context = new CustomersEntities()) { context.ContextOptions.LazyLoadingEnabled = false; var cust = from c in context.Customers where c.last_name.StartsWith(myCustomer.last_name) && c.first_name.StartsWith(myCustomer.first_name) orderby c.last_name, c.first_name select c; return(cust.ToList()); } }
//Method #5 //Creates an entry in the Items table. public static bool addItemToOrder(Order_item newItem) { using (var context = new CustomersEntities()) { context.ContextOptions.LazyLoadingEnabled = false; context.Order_item.AddObject(newItem); bool sucess = context.SaveChanges() == 1; if (sucess) { return(true); } else { return(false); } } }
//Method #4 //Creates an entry in the order table, which generates an order number public static bool createNewOrderNumber(Order newOrder) { using (var context = new CustomersEntities()) { context.ContextOptions.LazyLoadingEnabled = false; context.Orders.AddObject(newOrder); bool sucess = context.SaveChanges() == 1; if (sucess) { return(true); } else { return(false); } } }
//Method #6 //Creates an entry in the Items table. public static bool removeItemFromOrder(Order_item deleteItem) { using (var context = new CustomersEntities()) { context.ContextOptions.LazyLoadingEnabled = false; context.Attach(deleteItem); context.Order_item.DeleteObject(deleteItem); bool sucess = context.SaveChanges() == 1; if (sucess) { return(true); } else { return(false); } } }