Exemple #1
0
        public void AlterCustomersDemo()
        {
            using (ISalesUnitOfWork unitOfWork = new SalesUnitOfWorkEF())
            {
                const string CustomerIdentity = "93061151423";
                var          cusomerToDelete  = unitOfWork.Customers.GetByIdentityNumber(CustomerIdentity);
                var          newCustomer      = new Customer {
                    FirstName = "Merry", LastName = "Jane", Age = 27, Gender = Gender.Female, IdentityNumber = CustomerIdentity
                };

                if (cusomerToDelete != null)
                {
                    unitOfWork.Customers.Remove(cusomerToDelete);
                }
                else
                {
                    unitOfWork.Customers.Add(newCustomer);
                }

                var customerToModify = unitOfWork.Customers.GetByIdentityNumber("92112444243");
                customerToModify.FirstName = "Natalia";

                unitOfWork.Commit();
            }
        }
Exemple #2
0
        public void ReadFromDatabaseDemo()
        {
            using (ISalesUnitOfWork unitOfWork = new SalesUnitOfWorkEF())
            {
                var elderMales        = unitOfWork.Customers.GetElderly(Gender.Male);
                var youngAdultFemales = unitOfWork.Customers.GetYoungAdults(Gender.Female);
                var allAdults         = unitOfWork.Customers.GetAdults(Gender.Female | Gender.Male | Gender.Undefined);

                var allProducts = unitOfWork.Products.GetAll();
                var gpuList     = unitOfWork.Products.GetProductsByCategory(ProductCategory.GPU);

                const string customerIdentityNumber = "92112444243";
                var          customer             = unitOfWork.Customers.GetByIdentityNumber(customerIdentityNumber);
                var          customerTransactions = unitOfWork.Transactions.GetTransactionsByCustomer(customer);
                PresentTransactions(customerTransactions);

                Console.WriteLine("\n******************************\n");

                var productTransactions = unitOfWork.Transactions.GetTransactionLinessByProduct("C0001");
                PresentTransactionLines(productTransactions);

                Console.ReadKey();
            }
        }