public List <Customer> GetCustomersByCountry(string country) { using (var context = new BAL_NorthwindDataContext()) { List <Customer> customerList = (from c in context.Customers where c.Country == country select c).Distinct().ToList(); return(customerList); } }
//public BAL_Countries(BAL_NorthwindDataContext context) //{ // _context = context; //} public List <string> GetAllCountries() { using (var context = new BAL_NorthwindDataContext()) { List <string> countriesList = (from c in context.Customers select c.Country).Distinct().ToList(); return(countriesList); } }
public List <Order> GetOrdersByDate(DateTime date) { using (var context = new BAL_NorthwindDataContext()) { List <Order> orders = (from order in context.Orders where order.OrderDate == date select order).ToList(); return(orders); } }
public Customer GetCustomer(string CustomerID) { using (var context = new BAL_NorthwindDataContext()) { Customer c = (from cust in context.Customers where cust.CustomerID == CustomerID select cust).SingleOrDefault(); return(c); } }
public List <Product> GetProducts(int id) { using (var context = new BAL_NorthwindDataContext()) { List <Product> products = (from p in context.Products join od in context.Order_Details on p.ProductID equals od.ProductID where od.OrderID == id select p).ToList(); return(products); } }
//Select Product ID, Product Name, Price, Quantity & Discount public object GetCustomedProducts(int id) { using (var context = new BAL_NorthwindDataContext()) { var products = (from p in context.Products join od in context.Order_Details on p.ProductID equals od.ProductID where od.OrderID == id select new { p.ProductID, p.ProductName, od.UnitPrice, od.Quantity, od.Discount }).ToList(); return(products); } }