コード例 #1
0
        /*  public static void checkPasswordAndUserName(string userName,int password, List<suppliers> suppliers, List<customers>cust)
         * {
         *    customerDAO dao1 = new customerDAO();
         *    if (dao1.checkForPassword(userName, cust) == true)
         *    {
         *
         *    }
         * }  */

        // this it the supplier class functions:

        static public customer exsitingCustomer(string userName, int password)
        {
            string   newProduct       = null;
            int      amountOfProducts = 0;
            customer custLogIn        = null;

            customerDAO dao2 = new customerDAO();
            SqlCommand  cmd  = new SqlCommand();

            cmd.Connection = new SqlConnection(@"Data Source=.;Initial Catalog=DBschool;Integrated Security=True");
            cmd.Connection.Open();
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = ($"select * from Customers where password = {password} and user_Name = '{userName}'");

            SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default);

            while (reader.Read() == true)
            {
                custLogIn = new customer
                {
                    cust_id       = (int)reader["cust_id"],
                    user_name     = (string)reader["user_name"],
                    password      = (int)reader["password"],
                    first_name    = (string)reader["first_name"],
                    surname       = (string)reader["surname"],
                    cradit_number = (int)reader["cradit_number"],
                };

                Console.WriteLine("===================menu:============== " +
                                  "\n 1.To view all my shooping list press number 1" +
                                  "\n 2.To watch all products press number 2" +
                                  "\n 3. For new order press number 3");
                cmd.CommandText = ("");

                int answer = Convert.ToInt32(Console.ReadLine());

                if (answer == 1)
                {
                    dao2.viewAllMyShoopingList(custLogIn);
                }
                else if (answer == 2)
                {
                    dao2.watchAllProducts();
                }
                else if (answer == 3)
                {
                    dao2.orderNewProduct(custLogIn);
                }
            }
            cmd.Connection.Close();
            return(custLogIn);
        }
コード例 #2
0
        public List <order> viewAllMyShoopingList(customer c)
        {
            customerDAO dao2 = new customerDAO();

            List <order> results = new List <order>();

            SqlCommand cmd = new SqlCommand();

            cmd.Connection = new SqlConnection(@"Data Source=.;Initial Catalog=DBschool;Integrated Security=True");
            cmd.Connection.Open();
            cmd.CommandType = CommandType.Text;
            cmd.Parameters.Add(new SqlParameter("@custId", c.cust_id));
            cmd.CommandText = ($"select * from orders o join Customers c on o.customer_number = c.cust_id where c.cust_id = @custId");

            SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.Default);

            while (reader.Read() == true)
            {
                Console.WriteLine($"order amount:{reader["orders_amount"]} total price: {reader["total_price"]} product: {reader["prodct_name"]}");

                order e = new order
                {
                    order_number    = (int)reader["order_number"],
                    customer_number = (int)reader["customer_number"],
                    product_number  = (int)reader["product_number"],
                    orders_amount   = (int)reader["orders_amount"],
                    total_price     = (int)reader["total_price"],
                    prodct_name     = (string)reader["prodct_name"],
                };
                results.Add(e);
            }

            cmd.Connection.Close();
            dao2.CalculateTotal(c);
            return(results);
        }
コード例 #3
0
        static void Main(string[] args)
        {
            customerDAO  dao  = new customerDAO();
            suppliersDAO dao1 = new suppliersDAO();

            string supplier_userName = null;
            int    supplier_password = 0;

            string customer_userName = null;
            int    customer_password = 0;

            Console.WriteLine("Supplier or Customer?" +
                              "\n====For customer enter 1 for supplier enter 2====");

            int answer = Convert.ToInt32(Console.ReadLine());

            if (answer == 1)
            {
                Console.WriteLine("===========for new customer press 1==========\n" +
                                  "============for existing customer press 2=========");
                int newOrOld = Convert.ToInt32(Console.ReadLine());

                if (newOrOld == 1)
                {
                    dao.NewCustomer();
                }
                else
                {
                    Console.WriteLine("please enter a user name:");
                    customer_userName = Console.ReadLine();

                    Console.WriteLine("please enter your password:"******"===========for new supplier press 1==========\n" +
                                  "============for existing supplier press 2=========");
                int newOrOld = Convert.ToInt32(Console.ReadLine());

                if (newOrOld == 1)
                {
                    dao1.addNewSupplier();
                }
                else
                {
                    Console.WriteLine("please enter a user name:");
                    supplier_userName = Console.ReadLine();

                    Console.WriteLine("please enter your password:");
                    supplier_password = Convert.ToInt32(Console.ReadLine());

                    exsitingSupplier(supplier_userName, supplier_password);
                }
            }


            // test for suppliers view
            // supliers s = new supliers() ;
            //  List<object> supplierProductView = new List<object>();
            // s.viewAllMyProducts(supplierProductView);


            // checkPasswordAndUserName(userName, password, suppliers, customers);
        }