using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

​

namespace Assignment3

{

    class Program

    {

        public static int TotalUnitsInStock { get; private set; }

​

        static void Main(string[] args)

        {

            List<Customer> customers = new List<Customer>()

            {

                new Customer(){ID = Guid.NewGuid(), Age = 23, First = "Joe", Last = "Smith"},

                new Customer(){ID = Guid.NewGuid(), Age = 34, First = "Kevin", Last = "Costner"},

                new Customer(){ID = Guid.NewGuid(), Age = 23, First = "Sally", Last = "Smuthers"},

                new Customer(){ID = Guid.NewGuid(), Age = 56, First = "Mary", Last = "Jane"},

                new Customer(){ID = Guid.NewGuid(), Age = 48, First = "Jane", Last = "Kendall"},

                new Customer(){ID = Guid.NewGuid(), Age = 34, First = "Eve", Last = "Shrimp"},

                new Customer(){ID = Guid.NewGuid(), Age = 31, First = "Donna", Last = "Lynn"},

                new Customer(){ID = Guid.NewGuid(), Age = 21, First = "Sarah", Last = "Spicer"},

            };

​

            List<Order> orders = new List<Order>()

            {

                new Order() {CustomerID = customers[0].ID , Description="Shoes", Price=150.23M, Quantity=1},

                new Order() {CustomerID = customers[0].ID, Description="Phone", Price=130.25M, Quantity=2},

                new Order() {CustomerID = customers[0].ID, Description="Jacket", Price=230.14M, Quantity=1},

​

                new Order() {CustomerID = customers[1].ID, Description="Phone", Price=130.25M, Quantity=1},

                new Order() {CustomerID = customers[1].ID, Description="Jacket", Price=230.14M, Quantity=2},

                new Order() {CustomerID = customers[1].ID, Description="Pants", Price=70.56M, Quantity=1},

​

                new Order() {CustomerID = customers[2].ID, Description="Jacket", Price=230.14M, Quantity=1},

                new Order() {CustomerID = customers[2].ID, Description="Pants", Price=70.56M, Quantity=3},

                new Order() {CustomerID = customers[2].ID, Description="Shirt", Price=49.99M, Quantity=1},

​

                new Order() {CustomerID = customers[3].ID, Description="Pants", Price=70.56M, Quantity=1},

                new Order() {CustomerID = customers[3].ID, Description="Shirt", Price=49.99M, Quantity=2},

                new Order() {CustomerID = customers[3].ID, Description="Scarf", Price=23.69M, Quantity=1},

​

                new Order() {CustomerID = customers[4].ID, Description="Shirt", Price=49.99M, Quantity=3},

                new Order() {CustomerID = customers[4].ID, Description="Scarf", Price=23.69M, Quantity=1},

                new Order() {CustomerID = customers[4].ID, Description="Car", Price=24200.15M, Quantity=1},

​

                new Order() {CustomerID = customers[5].ID, Description="Scarf", Price=23.69M, Quantity=2},

                new Order() {CustomerID = customers[5].ID, Description="Car", Price=24200.15M, Quantity=1},

                new Order() {CustomerID = customers[5].ID, Description="Computer", Price=650.00M, Quantity=1},

​

                new Order() {CustomerID = customers[6].ID, Description="Car", Price=24200.15M, Quantity=1},

                new Order() {CustomerID = customers[6].ID, Description="Computer", Price=650.00M, Quantity=1},

                new Order() {CustomerID = customers[6].ID, Description="Shoes", Price=150.23M, Quantity=1},

​

                new Order() {CustomerID = customers[7].ID, Description="Computer", Price=650.00M, Quantity=1},

                new Order() {CustomerID = customers[7].ID, Description="Jacket", Price=230.14M, Quantity=1},

                new Order() {CustomerID = customers[7].ID, Description="Pants", Price=70.56M, Quantity=1},

            };

​

​

            IEnumerable<Customer> cust = customers.OrderBy(n => n.Last);

            Console.WriteLine("Customers and orders sorted by last name:");

            foreach (Customer cus in cust)

            {

                Console.WriteLine(cus.First + cus.Last);

​

                IEnumerable<Order> order = from Order in orders

                                           where Order.CustomerID == cus.ID

                                           orderby Order.Price descending

                                           select Order;

                Console.WriteLine("Orders:");

                foreach (Order ord in order)

                {

                    Console.WriteLine(ord.Description + ",  Price: " + ord.Price + ",  Quantity  " + ord.Quantity);

                }

                Console.WriteLine("========================================================");

            }

            int NoOrders = orders.Count();

            Console.WriteLine("Total No of Orders :{0}", NoOrders);

            int UnderOrder =

                      (from order in orders

                       where order.Price <= 500

                       select order).Count();

​

            Console.WriteLine("The total number of orders $500 and under. :{0}", UnderOrder);

​

​

            int OverOrder =

                    (from order in orders

                     where order.Price > 500

                     select order).Count();

​

            Console.WriteLine("Number of orders over $500 :{0}", OverOrder);

​

          //  var product = orders.Aggregate((price, quantity) => price * quantity);

​

​

​

​

​

            Console.ReadLine();

​

​

​

​

​

​

        }

        public class Customer

        {

            public Guid ID { get; set; }

            public int Age { get; set; }

            public string First { get; set; }

            public string Last { get; set; }

​

​

​

        }

        public class Order

        {

​

            public string Description { get; set; }

            public decimal Price { get; set; }

            public int Quantity { get; set; }

            public Guid CustomerID { get; set; }

​

​

​

​

​

​

        }

    }

}

​