Пример #1
0
        public void Test3()
        {
            var sut      = new LogicStore();
            var customer = new Customer()
            {
                CustomerId = Guid.NewGuid(),
                FirstName  = "Anis",
                Email      = "*****@*****.**"
            };
            var result  = new Customer();
            var result2 = new Customer();

            using (var context = new StoreContext(testOptions))
            {
                context.Database.EnsureDeleted();
                context.Database.EnsureCreated();

                var msr = new LogicStore(context);
                result2 = msr.getSingleCustomer(customer.CustomerId);
            }

            using (var contex2 = new StoreContext(testOptions))
            {
                contex2.Database.EnsureCreated();
                result = contex2.Customers.Find(customer.CustomerId);
            }
            Assert.Equal(result, result2);
        }
Пример #2
0
        public void Test12()
        {
            var product1 = new List <Product>();

            product1.Add(new Product()
            {
                ProductId = Guid.NewGuid(), Name = "TSHIR"
            });
            product1.Add(new Product()
            {
                ProductId = Guid.NewGuid(), Name = "Pant"
            });

            var result  = new List <Product>();
            var result2 = new List <Product>();

            using (var context = new StoreContext(testOptions))
            {
                context.Database.EnsureDeleted();
                context.Database.EnsureCreated();

                var msr = new LogicStore(context);
                result2 = msr.getAllProducts();
            }

            using (var contex2 = new StoreContext(testOptions))
            {
                contex2.Database.EnsureCreated();
                result = contex2.Products.FromSqlRaw("Select * from Products").ToList();
            }
            Assert.Equal(result, result2);
        }
Пример #3
0
        public void Test2()
        {
            var sut      = new LogicStore();
            var product1 = new Product()
            {
                ProductId = Guid.NewGuid(),
                Name      = "Cloths",
                UnitPrice = 45
            };
            var result  = new Product();
            var result2 = new Product();

            using (var context = new StoreContext(testOptions))
            {
                context.Database.EnsureDeleted();
                context.Database.EnsureCreated();

                var msr = new LogicStore(context);
                result2 = msr.getSingleProducts(product1.ProductId);
            }

            using (var contex2 = new StoreContext(testOptions))
            {
                contex2.Database.EnsureCreated();
                result = contex2.Products.Find(product1.ProductId);
            }
            Assert.Equal(result, result2);
        }
Пример #4
0
        public void Test10()
        {
            var order = new Order()
            {
                OrderId  = Guid.NewGuid(),
                Customer = new Customer()
                {
                    FirstName = "Anis"
                },
            };
            var result  = new Order();
            var result2 = new Order();

            using (var context = new StoreContext(testOptions))
            {
                context.Database.EnsureDeleted();
                context.Database.EnsureCreated();

                var msr = new LogicStore(context);
                result2 = msr.getCustomerOrder(order.Customer.FirstName);
            }

            using (var contex2 = new StoreContext(testOptions))
            {
                contex2.Database.EnsureCreated();
                result = contex2.Orders.FirstOrDefault(o => o.Customer.FirstName == order.Customer.FirstName);
            }
            Assert.Equal(result, result2);
        }
Пример #5
0
        public void Test8()
        {
            var sut       = new LogicStore();
            var storeList = new List <Store>();

            storeList.Add(new Store()
            {
                LocationName = "FLORIDA"
            });
            storeList.Add(new Store()
            {
                LocationName = "CANADA"
            });
            var result  = new List <Store>();
            var result2 = new List <Store>();

            using (var context = new StoreContext(testOptions))
            {
                context.Database.EnsureDeleted();
                context.Database.EnsureCreated();

                var msr = new LogicStore(context);
                result2 = msr.getALlStores();
            }

            using (var contex2 = new StoreContext(testOptions))
            {
                contex2.Database.EnsureCreated();
                result = contex2.Stores.FromSqlRaw("Select * From Stores").ToList();
            }
            Assert.Equal(result, result2);
        }
Пример #6
0
        public void Test1()
        {
            var      sut      = new LogicStore();
            Customer customer = new Customer()
            {
                FirstName = "Anis",
                LastName  = "Medini",
                UserName  = "******"
            };
            Customer result  = new Customer();
            Customer result2 = new Customer();

            using (var context = new StoreContext(testOptions))
            {
                context.Database.EnsureDeleted();
                context.Database.EnsureCreated();

                var msr = new LogicStore(context);
                result2 = msr.addCustomer(customer);
                context.SaveChanges();
            }

            using (var contex2 = new StoreContext(testOptions))
            {
                contex2.Database.EnsureCreated();
                result = contex2.Customers.FirstOrDefault(c => c.LastName == customer.LastName);
            }
            Assert.Equal(result.LastName, result2.LastName);
        }
Пример #7
0
        public void Test4()
        {
            var sut   = new LogicStore();
            var store = new Store()
            {
                StoreId      = Guid.NewGuid(),
                LocationName = "Cloths",
            };
            var result  = new Store();
            var result2 = new Store();

            using (var context = new StoreContext(testOptions))
            {
                context.Database.EnsureDeleted();
                context.Database.EnsureCreated();

                var msr = new LogicStore(context);
                result2 = msr.getSingleStore(store.LocationName);
            }

            using (var contex2 = new StoreContext(testOptions))
            {
                contex2.Database.EnsureCreated();
                result = contex2.Stores.FirstOrDefault(s => s.LocationName == store.LocationName);
            }
            Assert.Equal(result, result2);
        }
Пример #8
0
        public void Test7()
        {
            var sut           = new LogicStore();
            var customersList = new List <Customer>();

            customersList.Add(new Customer()
            {
                FirstName = "Anis"
            });
            customersList.Add(new Customer()
            {
                FirstName = "Brad"
            });
            customersList.Add(new Customer()
            {
                FirstName = "John"
            });



            var result  = new List <Customer>();
            var result2 = new List <Customer>();

            using (var context = new StoreContext(testOptions))
            {
                context.Database.EnsureDeleted();
                context.Database.EnsureCreated();

                var msr = new LogicStore(context);
                result2 = msr.getAllCustomers();
            }

            using (var contex2 = new StoreContext(testOptions))
            {
                contex2.Database.EnsureCreated();
                result = contex2.Customers.FromSqlRaw("Select * from Customer").ToList();
            }
            Assert.Equal(result, result2);
        }