Пример #1
0
        public static void RunBasketCRUD()
        {
            //connect to the DB
            using CrmDbContext db = new CrmDbContext();
            //to using to xrisomopioume anti gia to dispose (disconnect apo vasi)

            ProductOption prOpt = new ProductOption
            {
                ProductName = "apples",
                Price       = 1.20m,
                Quantity    = 10
            };

            ProductManagement prodMangr = new ProductManagement(db);

            Product product = prodMangr.CreateProduct(prOpt);

            BasketManagement baskMangr = new BasketManagement(db);

            BasketOption baskOption = new BasketOption
            {
                CustomerId = 3
            };

            Basket basket = baskMangr.CreateBasket(baskOption);
            BasketProductOption bskProdOpt = new BasketProductOption
            {
                BasketId  = basket.Id,
                ProductId = 1
            };


            BasketProduct baskProd = baskMangr.AddProduct(bskProdOpt);

            //Console.WriteLine(basket.BasketProducts[0], Product.ProductName);

            basket.BasketProducts.ForEach(p =>
                                          Console.WriteLine(p.Product.ProductName));
        }
Пример #2
0
            public static void Main()
            {
                //CustomerOption custOpt = new CustomerOption
                //{
                //  FirstName = "Tester222",
                //  LastName = "Test",
                //  Address = "TestCity",
                //  Email = "*****@*****.**",
                //};

                using CrmAppDbContext db = new CrmAppDbContext();
                CustomerManagement custMangr = new CustomerManagement(db);

                ////testing the creation of a customer
                //Customer customer = custMangr.CreateCustomer(custOpt);
                //Console.WriteLine(
                //$"Id= {customer.CustomerId} Name= {customer.FirstName} Address= {customer.Address}");



                ////testing reading a customer
                //customer = custMangr.FindCustomerById(2);
                //if (customer != null)
                //  Console.WriteLine(
                //      $"Id= {customer.CustomerId} Name= {customer.FirstName} Address= {customer.Address}");


                ////testing updating
                //CustomerOption custChangingAddress = new CustomerOption
                //{
                //  Address = "Lamia"
                //};
                //customer = custMangr.Update(custChangingAddress, 1);
                //Console.WriteLine(
                //    $"Id= {customer.CustomerId} Name= {customer.FirstName} Address= {customer.Address}");


                ////testing deletion

                //bool result = custMangr.DeleteCustomerById(2);
                //Console.WriteLine($"Result = {result}");
                //customer = custMangr.FindCustomerById(2);
                //if (customer != null)
                //{
                //  Console.WriteLine(
                //  $"Id= {customer.CustomerId} Name= {customer.FirstName} Address= {customer.Address}");

                //}
                //else
                //{
                //  Console.WriteLine("not found");
                //}



                ProductOption prOpt = new ProductOption
                {
                    Name     = "portokalia",
                    Price    = 1.20m,
                    Quantity = 10
                };

                ProductManagement prodMangr = new ProductManagement(db);

                Product product = prodMangr.CreateProduct(prOpt);

                BasketManagement baskMangr = new BasketManagement(db);

                BasketOption baskOption = new BasketOption
                {
                    CustomerId = 5
                };

                Basket basket = baskMangr.CreateBasket(baskOption);
                BasketProductOption bskProdOpt = new BasketProductOption
                {
                    BasketId  = basket.Id,
                    ProductId = 1
                };

                //System.NullReferenceException

                BasketProduct baskProd = baskMangr.AddProduct(bskProdOpt);

                basket.BasketProducts.ForEach(
                    baskProduct =>
                    Console.WriteLine(
                        db.BasketProducts
                        .Include(b => b.Product)
                        .Where(b => b.Id == baskProduct.Id)
                        .First()
                        .Product.Name)
                    );

                Console.ReadLine();
            }
Пример #3
0
        static void Main()
        {
            CustomerOption custOpt = new CustomerOption
            {
                FirstName = "Maria",
                LastName  = "Pentagiotissa",
                Address   = "Athens",
                Email     = "*****@*****.**",
            };

            using CrmDbContext db = new CrmDbContext();
            CustomerManagement custMangr = new CustomerManagement(db);


            // testing the creation of a customer
            Customer customer = custMangr.CreateCustomer(custOpt);

            Console.WriteLine(
                $"Id= {customer.Id} Name= {customer.FirstName} Address= {customer.Address}");


            //testing reading a customer
            customer = custMangr.FindCustomerById(2);
            if (customer != null)
            {
                Console.WriteLine(
                    $"Id= {customer.Id} Name= {customer.FirstName} Address= {customer.Address}");
            }


            //testing updating
            CustomerOption custChangingAddress = new CustomerOption
            {
                Address = "Lamia"
            };

            customer = custMangr.Update(custChangingAddress, 1);
            Console.WriteLine(
                $"Id= {customer.Id} Name= {customer.FirstName} Address= {customer.Address}");


            //testing deletion

            bool result = custMangr.DeleteCustomerById(2);

            Console.WriteLine($"Result = {result}");
            customer = custMangr.FindCustomerById(2);
            if (customer != null)
            {
                Console.WriteLine(
                    $"Id= {customer.Id} Name= {customer.FirstName} Address= {customer.Address}");
            }
            else
            {
                Console.WriteLine("not found");
            }

            ProductOption prOpt = new ProductOption
            {
                Name = "mila", Price = 1.20m, Quantity = 10
            };

            ProductManagement prodMangr = new ProductManagement(db);

            Product product = prodMangr.CreateProduct(prOpt);

            BasketManagement baskMangr = new BasketManagement(db);

            BasketOption baskOption = new BasketOption
            {
                CustomerId = 3
            };

            Basket basket = baskMangr.CreateBasket(baskOption);
            BasketProductOption bskProdOpt = new BasketProductOption
            {
                BasketId  = 1,
                ProductId = 1
            };


            BasketProduct baskProd = baskMangr.AddProduct(bskProdOpt);

            basket.BasketProducts.ForEach(p =>
                                          Console.WriteLine(p.Product.Name));
        }
Пример #4
0
        static void Main2()
        {
            CustomerOption custOpt = new CustomerOption
            {
                FirstName = "John",
                LastName  = "XCV",
                Adress    = "Thessaloniki",
                Email     = "*****@*****.**",
            };

            using CrmDbContext db = new CrmDbContext();
            CustomerManagement custMngr = new CustomerManagement(db);

            Customer customer = custMngr.CreateCustomer(custOpt);

            Console.WriteLine($"Id={customer.Id} Name={customer.FirstName} Adress={customer.Adress}");

            Customer cx = custMngr.FindCustomerById(2);

            Console.WriteLine($"Id={cx.Id} Name={cx.FirstName} Adress={cx.Adress}");

            CustomerOption custChangingAdress = new CustomerOption
            {
                Adress = "Lamia"
            };

            Customer c2 = custMngr.Update(custChangingAdress, 1);

            Console.WriteLine($"Id={c2.Id} Name={c2.FirstName} Adress={c2.Adress}");

            bool result = custMngr.DeleteCustomerById(2);

            Console.WriteLine($"Result={result}");
            Customer cx2 = custMngr.FindCustomerById(2);

            if (cx2 != null)
            {
                Console.WriteLine($"Id={cx2.Id} Name={cx2.FirstName} Adress={cx2.Adress}");
            }

            else
            {
                Console.WriteLine("Not found");
            }

            ProductOption prOpt = new ProductOption
            {
                Name = "apples", Price = 1.20m, Quantity = 10
            };

            ProductManagement prodMngr = new ProductManagement(db);

            Product product = prodMngr.CreateProduct(prOpt);

            BasketManagement baskMngr = new BasketManagement(db);

            BasketOption baskOption = new BasketOption
            {
                CustomerId = 3
            };

            Basket basket = baskMngr.CreateBasket(baskOption);
            BasketProductOption bskProdOpt = new BasketProductOption
            {
                BasketId  = basket.Id,
                ProductId = 1
            };

            BasketProduct baskProd = baskMngr.AddProduct(bskProdOpt);

            basket.BasketProducts.ForEach(p =>
                                          Console.WriteLine(p.Product));
        }