Exemplo n.º 1
0
 public void AddProduct(Product product)
 {
     products.Add(product);
 }
Exemplo n.º 2
0
        /// <summary>
        /// Main method.
        /// </summary>
        public static void Main()
        {
            var pr1 = new Product("Chai1", -1, 5);
            var pr2 = new Product("Chai2", 99, 5);
            var pr3 = new Product("Chai3", 100, 124);
            var pr4 = new Product("Chai4", 4, 102);
            var pr5 = new Product("Chai5", 5, 101);
            List<Product> products = new List<Product>() { pr1, pr2, pr3, pr4, pr5 };

            var c1 = new Category(5, "name1");
            var c2 = new Category(125, "name2");
            var c3 = new Category(124, "name3");
            var c4 = new Category(102, "name4");
            var c5 = new Category(100, "name5");
            var c6 = new Category(101, "name6");
            List<Category> categories = new List<Category>() { c1, c2, c3, c4, c5, c6 };

            List<int> prl1 = new List<int>() { 99, 4, 100, -1 };
            List<int> prl2 = new List<int>() { 4, 5, -1, 100 };
            List<int> prl3 = new List<int>() { 99, 4, 5 };
            List<int> prl4 = new List<int>() { 100, 91, 5 };

            var or1 = new Order("order 1", 1, prl1, new DateTime(2001, 1, 1));
            var or2 = new Order("order 2", 2, prl2, new DateTime(2000, 1, 2));
            var or3 = new Order("order 3", 3, prl3, new DateTime(2000, 1, 3));
            var or4 = new Order("order 4", 4, prl4, new DateTime(2000, 1, 8));
            var or5 = new Order("order 5", 5, prl4, new DateTime(2000, 1, 7));
            var or6 = new Order("order 6", 6, prl4, new DateTime(2000, 1, 6));
            var or7 = new Order("order 7", 7, prl4, new DateTime(2000, 1, 14));
            var or8 = new Order("order 8", 8, prl4, new DateTime(2000, 1, 24));
            var or9 = new Order("order 9", 9, prl4, new DateTime(2000, 6, 4));
            var or10 = new Order("order 14", 14, prl4, new DateTime(2000, 2, 4));
            var or11 = new Order("order 24", 24, prl4, new DateTime(2000, 6, 4));
            var or12 = new Order("order 34", 34, prl4, new DateTime(2000, 1, 5));
            var or13 = new Order("order 44", 44, prl4, new DateTime(2000, 3, 4));
            var or14 = new Order("order 54", 54, prl4, new DateTime(2000, 2, 4));
            var or15 = new Order("order 64", 64, prl4, new DateTime(2000, 2, 4));
            List<Order> orders = new List<Order>() { or1, or2, or3, or4, or5, or6, or7, or8, or9, or10, or11, or12, or13, or14, or15 };

            DataStore ds1 = new DataStore(orders, categories, products);

            // returns all products with ids between 15 and 30
            var prods = ds1.GetProducts().Where(x => x.CategoryId > 15 && x.CategoryId < 30).ToList();

            // returns all categories with ids between 105 and 125
            var cats = ds1.GetCategories().Where(x => x.CategoryId > 105 && x.CategoryId < 125).ToList();

            // returns first 15 orders sorted by order name
            var ords = ds1.GetOrders().OrderBy(x => x.Name).Take(15);

            // returns first 3 orders which contains a specific productId  (-1)
            var newprods = ds1.GetOrders().Where(x => x.Products.Contains(-1)).OrderBy(x => x.OrderDate).ToList();

            // returns all product with the name of the category which they belong to
            var prodCats = from prod in ds1.GetProducts() orderby prod.Name select new { Name = prod.Name };

            // returns all categories together with their products
            var catsAndProds = from cat in categories
                               join prod in products on cat.CategoryId equals prod.CategoryId
                               select new { Category = cat.CategoryName, Prod = prod.Name };

            // All orders together with their products and then print it to the screen.
            // For every product print its category name as well. Sort the result by orderDate.
            var ress = orders.OrderBy(x => x.OrderDate).SelectMany(
                x => x.Products.Select(
                    y => products.Where(
                        z => z.Id == y).Select(
                        z => new
                        {
                            Order = x.Id,
                            Product = z.Name
                        }).FirstOrDefault())).Where(x => x != null).ToList();
        }