Esempio n. 1
0
        public IActionResult Index()
        {
            CustomerAdapter       adapter        = new CustomerAdapter();
            List <Customer>       customers      = adapter.GetAll();
            AllCustomersModel     model          = new AllCustomersModel();
            List <CustomerModels> customerModels = new List <CustomerModels>();

            foreach (Customer customer in customers)
            {
                CustomerModels customerModel = new CustomerModels();
                customerModel.CustomerId = customer.CustomerId;
                customerModel.FirstName  = customer.FirstName;
                customerModel.LastName   = customer.LastName;
                customerModel.Country    = customer.Country;
                customerModel.Email      = customer.Email;
                customerModels.Add(customerModel);
            }
            model.Customers = customerModels;
            return(View(model));
        }
Esempio n. 2
0
        static void Main(string[] args)
        {
            CustomerAdapter adapter   = new CustomerAdapter();
            List <Customer> customers = adapter.GetAll();

            foreach (Customer customer in customers)
            {
                Console.WriteLine("CustomerID: " + customer.CustomerId + ", First Name: " + customer.FirstName + ", Last Name: " + customer.LastName + ", Country: " + customer.Country + ", Email: " + customer.Email);
            }

            /*InvoiceAdapter adapter2 = new InvoiceAdapter();
             * List<Invoice> invoices = adapter2.GetAll();
             *
             * foreach (Invoice invoice in invoices)
             * {
             *  Console.WriteLine("InvoiceID: " +invoice.InvoiceId + ", CustomerID: " + invoice.CustomerId + ", Invoice Date: " + invoice.InvoiceDate + ", Invoice Total: " + invoice.Total);
             * }*/

            Console.WriteLine("Please enter a new customer into the Database...");
            Customer newcustomer = new Customer();

            Console.WriteLine("First Name: ");
            newcustomer.FirstName = Console.ReadLine();
            Console.WriteLine("Last Name:");
            newcustomer.LastName = Console.ReadLine();
            Console.WriteLine("Country: ");
            newcustomer.Country = Console.ReadLine();
            Console.WriteLine("Email: ");
            newcustomer.Email = Console.ReadLine();

            CustomerAdapter addcustomer = new CustomerAdapter();

            addcustomer.InsertCustomer(newcustomer);
            Console.WriteLine("Customer added...");

            Console.ReadLine();
        }
        void CustomerPage_LoadAsync(object sender, DoWorkEventArgs e)
        {
            CustomerAdapter ca = LocalContext.Default.CreateAdapter <CustomerAdapter>();

            customerBindingSource.DataSource = ca.GetAll();
        }