Example #1
0
        static void Main(string[] args)
        {
            DatabaseInterface db = new DatabaseInterface("BANGAZONCLI_DB");

            db.CheckDatabaseTable("Customer", DbTables.Customer);
            db.CheckDatabaseTable("Product", DbTables.Product);
            db.CheckDatabaseTable("PaymentType", DbTables.PaymentType);
            db.CheckDatabaseTable("[Order]", DbTables.Order);
            db.CheckDatabaseTable("OrderProduct", DbTables.OrderProduct);
            DbInitializer.Initialize(db);

            MainMenu        menu            = new MainMenu();
            CustomerManager customerManager = new CustomerManager(db);
            OrderManager    orderManager    = new OrderManager(db);

            // Choice will hold the number entered by the user
            // after main menu ws displayed
            int choice;

            do
            {
                // Show the main menu
                choice = menu.Show();

                switch (choice)
                {
                case 1:
                    AddCustomer.DoAction(customerManager);
                    break;

                case 2:
                    ChooseActiveCustomer.DoAction(customerManager);
                    break;

                case 3:
                    AddPaymentType.DoAction(customerManager);
                    break;

                case 5:
                    AddProductToCart.DoAction(orderManager);
                    break;

                case 6:
                    CloseOrder.DoAction(orderManager);
                    break;
                }
            } while (choice != 7);
        }
        public static List <Customer> ListOfCustomers()
        {
            DatabaseInterface db = new DatabaseInterface("BANGAZONCLI_DB");

            db.Query("select id, firstname, lastname from customer",
                     (SqliteDataReader reader) => {
                customers.Clear();
                while (reader.Read())
                {
                    customers.Add(new Customer()
                    {
                        id        = reader.GetInt32(0),
                        FirstName = reader[1].ToString(),
                        LastName  = reader[2].ToString()
                    });
                }
            });
            return(customers);
        }
        public static void Initialize(DatabaseInterface dab)
        {
            bool customersExist = false;

            dab.Query($"select id from customer",
                      (SqliteDataReader reader) => {
                while (reader.Read())
                {
                    customersExist = true;
                }
                if (customersExist == false)
                {
                    dab.BulkInsert($@"
                        insert into customer values(null, 'Bobby', 'Schmurda', 'Rykers Island', 'Brooklyn', 'NY', '12345', '555-555-5555');
                        insert into customer values(null, 'Lil', 'Pump', '2 Main St.', 'Miami', 'FL', '23456', '555-555-5551');
                        insert into customer values(null, 'Smoke', 'Purpp', '3 Main St.', 'Miami', 'FL', '34567', '555-555-5552');

                        insert into paymentType values(null, 'Cash', 1, 12);
                        insert into paymentType values(null, 'Visa', 2, 13);
                        insert into paymentType values(null, 'MasterCard', 3, 13);

                        insert into [order] values (null, 1, 1);
                        insert into [order] values(null, 2, 2);
                        insert into [order] values(null, 3, 3);

                        insert into product values (null, 'Codine Cough Syrup', 3, 12.99, 1, 'Goes great with Sprite!');
                        insert into product values (null, 'SoundCloud Subscription', 2, 9.99, 2, 'Where all the good hip hop is at');
                        insert into product values (null, 'Soccer Ball', 1, 10.99, 3, 'Kick goals with it!');

                        insert into productOrder values (null, 1, 2);
                        insert into productOrder values (null, 2, 1);
                        insert into productOrder values (null, 3, 3);
                    ");
                }
            });
        }
 /* Created by Krissy Caron
  * The New Customer Manager Constructor creates a new db */
 public CustomerManager(DatabaseInterface db)
 {
     _db = db;
 }
        static void Main(string[] args)
        {
            // Create database tables if none exist
            DatabaseInterface dab = new DatabaseInterface("BANGAZONCLI_DB");

            dab.CheckCustomerTable();
            dab.CheckOrderTable();
            dab.CheckProductTable();
            dab.CheckProductOrderTable();
            dab.CheckPaymentTypeTable();
            DbInitializer.Initialize(dab);

            // Seed the database if none exists
            // var db = new DatabaseInitializer();
            // db.VerifyDataExists();

            // Present the main menu from MainMenu.cs file
            MainMenu           menu = new MainMenu();
            CustomerManager    cm   = new CustomerManager(dab);
            OrderManager       om   = new OrderManager(dab);
            PaymentTypeManager ptm  = new PaymentTypeManager(dab);
            ProductManager     pm   = new ProductManager(dab);

            // Read in the user's choice
            int choice;

            // If option 1 was chosen, create a new customer account
            do
            {
                // Show the main menu
                choice = menu.Show();

                switch (choice)
                {
                // Menu option 1: Adding Customer
                case 1:
                    CreateCustomer.DoAction(cm);
                    break;

                // Menu option 2: Choosing Active Customer
                case 2:
                    ChooseCustomer.DoAction(cm);
                    break;

                // Menu option 3: Create Payment Options
                case 3:

                    AddPayment.AddPay(ptm);
                    break;

                // Menu option 4: Add product to sell
                case 4:
                    CreateProduct.DoAction(pm);
                    break;

                // Menu option 5: Add product to shopping cart
                case 5:
                    AddProductCart.DoAction(om, pm, cm);
                    break;

                // Menu option 6: Complete an order
                case 6:

                    break;

                // Menu option 7: Remove customer product
                case 7:

                    break;

                // Menu option 8: Update product information
                case 8:

                    break;

                // Menu option 9: Show stale products
                case 9:

                    break;

                // Menu option 10: Show customer revenue report
                case 10:

                    break;

                // Menu option 11: Show overall product popularity
                case 11:

                    break;
                }
            } while (choice != 12);
        }
        static void Main(string[] args)
        {
            // Seed the database if none exist

            /* Authored by Krissy Caron this creating a new instance of db and creating the folowing tables
             * usign the DatabaseInterface.cs as a blue print. */
            DatabaseInterface db = new DatabaseInterface("BangazonCLI_db");

            db.CheckCustomerTable();
            db.CheckProductTypeTable();
            db.CheckProductTable();
            db.CheckPaymentTypeTable();
            db.CheckOrdersTable();
            db.CheckProductOrderTable();

            // Why does this not need an instance of class DBPopulator?
            DBPopulator.Populate(db);

            //Instance of customer manager.
            CustomerManager manager = new CustomerManager(db);

            // Present the main menu
            Console.WriteLine("*************************************************");
            Console.WriteLine("Welcome to Bangazon! Command Line Ordering System");
            Console.WriteLine("*************************************************");
            Console.WriteLine("1. Create a customer account");
            Console.WriteLine("2. Choose active customer");
            Console.Write("> ");

            // Read in the user's choice
            int choice;

            Int32.TryParse(Console.ReadLine(), out choice);

            /* Authored By Krissy Caron
             * If option 1 was chosen, create a new customer account will trigger the following in the CMD line.
             * A new instance of customer will then be created from each type the user inputs and sent to the db in to the correct columns and table. */
            if (choice == 1)
            {
                Console.WriteLine("Enter customer first name");
                Console.Write("> ");
                string firstName = Console.ReadLine();
                Console.WriteLine("Enter customer last name");
                Console.Write("> ");
                string lastName = Console.ReadLine();
                Console.WriteLine("Enter customer email");
                Console.Write(">");
                string email = Console.ReadLine();
                Console.WriteLine("Enter customer phone number");
                Console.Write("> ");
                string phoneNumber = Console.ReadLine();

                manager.CreateCustomer(firstName, lastName, email, phoneNumber, DateTime.Now);
            }

            /* Authored by Krissy Caron
             * If Option 2 is selected, the list of all customers is displayed to the console in a Numered list.
             * The user can select from the customers which to make active, and that will be stored in the ActiveCustomer. */
            if (choice == 2)
            {
                Console.WriteLine("Which customer will be active?");

                //Displays List of currently avaiable customers
                List <Customer> customersList = manager.GetCustomers();
                foreach (Customer customer in customersList)
                {
                    Console.WriteLine($"{customer.CustomerId}. {customer.FirstName} {customer.LastName}");
                }
                Console.Write("> ");

                //Takes a string of the chosen customer which is a number, and makes it equal to the instance of that customer in the database.
                string chosenCustomer = Console.ReadLine();
                CustomerManager.ActiveCustomer = manager.GetCustomer(int.Parse(chosenCustomer));

                //Takes Active customer and prints their name to console.
                Console.WriteLine("Active Customer is: " + CustomerManager.ActiveCustomer.FirstName + " " + CustomerManager.ActiveCustomer.LastName);
            }
        }
Example #7
0
        public static void MainMenu()
        {
            // Seed the database if none exists
            DatabaseInterface db = new DatabaseInterface("BANGAZONCLI_DB");

            db.CheckCustomerTable();
            AddCustomerMenu _ACSB = new AddCustomerMenu();

            db.CheckProductTable();
            AddProductMenu _APSB = new AddProductMenu();

            db.CheckPaymentTypeTable();
            AddPaymentTypeMenu _APTSB = new AddPaymentTypeMenu();

            db.CheckOrderTable();
            AddOrderMenu _AOM = new AddOrderMenu();

            db.CheckOrderProductTable();
            RemoveProductMenu _RPM = new RemoveProductMenu();



            Console.WriteLine("*************************************************");
            Console.WriteLine("Welcome to Bangazon! Command Line Ordering System");
            Console.WriteLine("*************************************************");
            Console.WriteLine("1. Create a customer account");
            Console.WriteLine("2. Choose active customer");
            Console.WriteLine("3. Create a Payment Type for Active Customer");
            Console.WriteLine("4. Create product for active customer");
            Console.WriteLine("5. Add product to customer order");
            Console.WriteLine("6. See Available Products");
            Console.WriteLine("7. Delete a customer's product");
            Console.Write("> ");


            // Read in the user's choice
            int choice;

            Int32.TryParse(Console.ReadLine(), out choice);

            // If option 1 was chosen, create a new customer account
            if (choice == 1)
            {
                _ACSB.AddCustomerStringBuilder(new CustomerManager(db)); // public void AddCustomerStringBuilder
            }
            if (choice == 2)
            {
                ChooseActiveCustomerManager.ChooseActiveCustomer();
            }
            if (choice == 3)
            {
                _APTSB.AddPaymentTypeStringBuilder(new PaymentTypeManager(db));
            }
            if (choice == 4)
            {
                _APSB.AddProductStringBuilder(new ProductManager(db));  //public void AddProductStringBuilder
            }
            if (choice == 5)
            {
                _AOM.AddOrderStringBuilder(new ProductManager(db));
            }
            if (choice == 6)
            {
                _AOM.AddOrderStringBuilder(new ProductManager(db));
            }
            if (choice == 7)
            {
                _RPM.RemoveAProductStringBuilder(new ProductManager(db));
            }
            else
            {
                MainMenu();
            }
        }
Example #8
0
        public static void Main(string[] args)
        {
            // Seed the database if none exists
            var db = new DatabaseInterface("BANGAZON_TEST_DB");

            db.CheckProdOrderTable();
            db.CheckCustomerTable();
            db.CheckOrderTable();
            db.CheckPaymentTypeTable();
            db.CheckProductTable();
            db.CheckProductTypeTable();

            // Create Instance of MenuManager   T.L.
            MenuManager        menu        = new MenuManager();
            CustomerManager    customer    = new CustomerManager(db);
            ProductTypeManager productType = new ProductTypeManager(db);
            PaymentManager     payment     = new PaymentManager(db);
            ProductTypeManager prodType    = new ProductTypeManager(db);
            ProductManager     product     = new ProductManager(db);
            OrderManager       order       = new OrderManager(db);


            // int will hold active customer T.L.
            int activeCustomer = 0;

            // choice will hold the reference to the number the user selected
            // after the MenuManager was displayed T.L.
            int choice;

            do
            {
                // Display Menu from MenuManager
                // Save selected int to choice  T.L
                choice = menu.ShowMenu();
                Console.Clear();

                switch (choice)
                {
                // if Menu option 1 is selected: Add new Customer
                // Method is called in CreateNewCustomer which calls Method in CustomerManager  T.L.
                case 1:
                    CreateNewCustomer.DoAction(customer);
                    break;

                // if Menu option 2 is selected:
                // Method from GetCustomersAction makes a call to CustomersManager
                // Returns a list of Customers to display in terminal
                // The selected Customer's ID is stored in activeCustomer
                // This variable will then be passed to case 3
                // Authored by : Tamela Lerma & Jason Smith
                case 2:
                    activeCustomer = GetCustomersAction.DoAction(customer);
                    break;

                // User will be prompted to first select a customer
                // once customer is selected
                // a Method in CreatePaymentAction is called which
                // calls a Method in PaymentTypeManager to create a new payment
                // Authored by : Tamela Lerma & Jason Smith
                case 3:
                    if (activeCustomer != 0)
                    {
                        CreatePaymentAction.DoAction(payment, activeCustomer);
                    }
                    else
                    {
                        Warning("Please select customer first.");
                    }
                    break;

                // User will first be prompted to select an active customer
                // after customer is selected, a CreateProductAction Class Method is called
                // this Method accepts 3 arguments: Instance of ProductManager, Instance of ProductTypeManager, and the stored int for CustomerId
                // Authored by : Tamela Lerma
                case 4:
                    if (activeCustomer != 0)
                    {
                        CreateProductAction.DoAction(product, activeCustomer, productType);
                    }
                    else
                    {
                        Warning("Please select customer first.");
                    }
                    break;

                // User will need to first select a active customer
                // once customer is selected
                // a Method in AddProductToCartAction is called which
                // calls a Method in ProductManager to add a product to customers order
                // Authored by : Azim
                case 5:
                    if (activeCustomer != 0)
                    {
                        AddProductToCartAction.DoAction(order, product, activeCustomer);
                    }
                    else
                    {
                        Warning("Please select customer first.");
                    }
                    break;

                // User will be prompted to first choose active customer
                // then will call Method in CompleteOrderAction which
                // References PaymentManager and OrderManager
                // checks that payment exists for customer
                // payment is added to an order
                // Authored by : Jason Smith & Tamela Lerma
                case 6:
                    if (activeCustomer != 0)
                    {
                        CompleteOrderAction.DoAction(activeCustomer, payment, order);
                    }
                    else
                    {
                        Warning("Please select customer first.");
                    }
                    break;

                // User will first be prompted to select a customer
                // after customer is selected, a DeleteProductAction Class Method is called
                // this Method accepts 2 arguments: Instance of ProductManager and the stored int for CustomerId
                // Will Delete Customer Products in DB
                // Authored by : Tamela Lerma
                case 7:
                    if (activeCustomer != 0)
                    {
                        DeleteProductAction.DoAction(product, activeCustomer);
                    }
                    else
                    {
                        Warning("Please select customer first.");
                    }
                    break;

                // User will need to first select a active customer
                // once customer is selected
                // a Method in UpdateProduct is called which
                // calls a Method in ProductManager update the product of the customer
                // Authored by : Azim
                case 8:
                    if (activeCustomer != 0)
                    {
                        UpdateProduct.DoAction(product, activeCustomer);
                    }
                    else
                    {
                        Warning("Please select customer first.");
                    }
                    break;

                case 9:
                    GetStaleProducts.DoAction(product);
                    break;

                // User will need to first select active customer
                // once customer is selected
                // a method in GetCustomerReport is called which
                // calls a method in OrderManger to return a report of active customer's sales
                // Authored by : Jason Smith
                case 10:
                    if (activeCustomer != 0)
                    {
                        GetCustomerReport.DoAction(activeCustomer, customer, order);
                    }
                    else
                    {
                        Warning("Please select customer first.");
                    }
                    break;

                case 11:
                    GetPopularProducts.DoAction(product);
                    break;

                // Return, exiting program
                case 12:
                    return;
                }
            } while(choice != 0);
        }