Ejemplo n.º 1
0
 private void RefreshOrders_Click(object sender, RoutedEventArgs e)
 {
     OrdersTable.ItemsSource = null;
     ZP_Orders.allOrders.Clear();
     ZP_Orders.allOrders     = SQL_Calls.Select_OrderInfo();
     OrdersTable.ItemsSource = ZP_Orders.allOrders;
 }
Ejemplo n.º 2
0
 public MainWindow()
 {
     InitializeComponent();
     SQL_Calls.Initialize();
     ZP_Inventory.InvAtLoc.Clear();
     Inventory.ItemsSource = ZP_Inventory.InvAtLoc;
 }
Ejemplo n.º 3
0
 private void RefreshCust_Click(object sender, RoutedEventArgs e)
 {
     CustomerSelect.ItemsSource = null;
     ZP_Customers.CustList      = null;
     ZP_Customers.CustList      = SQL_Calls.Select_Customers();
     CustomerSelect.ItemsSource = ZP_Customers.CustList;
 }
Ejemplo n.º 4
0
        private void Confirm_Click(object sender, RoutedEventArgs e)
        {
            if (selectedAdd == true)
            {
                if (order.customer.custID != null && (order.listOfItems.Count != 0))
                {
                    selectedCust = false;
                    SQL_Calls.AddNewOrder(SQL_Calls.OrderID.ToString(), "2019-12-20", order.customer.custID, "PAID", "000" + Loc.ToString());
                    foreach (InventoryEntry c in order.listOfItems)
                    {
                        SQL_Calls.AddNewProductToOrder(SQL_Calls.OrderID.ToString(), c.SKU, c.quantity);
                    }
                    foreach (InventoryEntry c in LocInventory.Items)
                    {
                        SQL_Calls.UpdateInventory(c.quantity, c.branchID, c.SKU);
                    }
                    Reciept orderReciept = new Reciept(order, Loc);
                    orderReciept.ShowDialog();

                    this.Close();
                }
            }
            else
            {
                MessageBox.Show("Must Add a Select Item First!\n(Click On An Item,\n Select a Quantity From The Dropdown,\n And Click 'Add Selected')");
            }
        }
 public NewCustomer()
 {
     InitializeComponent();
     CustomersView.ItemsSource = null;
     ZP_Customers.CustList.Clear();
     ZP_Customers.CustList     = SQL_Calls.Select_Customers();
     CustomersView.ItemsSource = ZP_Customers.CustList;
 }
Ejemplo n.º 6
0
 private void LocationPicker_SelectionChanged(object sender, SelectionChangedEventArgs e)
 {
     Location = LocationPicker.SelectedIndex + 1;
     ZP_Inventory.InvAtLoc.Clear();
     ZP_Inventory.InvAtLoc = SQL_Calls.Select_Inventory(Location);
     Inventory.ItemsSource = null;
     Inventory.ItemsSource = ZP_Inventory.InvAtLoc;
 }
Ejemplo n.º 7
0
 private void OrdersTable_SelectionChanged(object sender, SelectionChangedEventArgs e)
 {
     foreach (Order temp in OrdersTable.SelectedItems)
     {
         ZP_Orders.contains = SQL_Calls.Select_Product_Order(temp.orderID);
     }
     ContentTable.ItemsSource = null;
     ContentTable.ItemsSource = ZP_Orders.contains;
 }
Ejemplo n.º 8
0
        public static void UpdateInventory(int Quantity, string BranchID, string SKU)
        {
            string query = "UPDATE Inventory SET Quantity = " + Quantity.ToString() + " WHERE BranchID = '" + BranchID + "' and SKU = '" + SKU + "';";

            if (SQL_Calls.OpenConnection() == true)
            {
                MySqlCommand cmd = new MySqlCommand(query, connection);
                var          r   = cmd.ExecuteNonQuery();
            }
            SQL_Calls.CloseConnection();
        }
Ejemplo n.º 9
0
        public static void AddNewOrder(string OrderID, string Order_Date, string CustomerID, string Order_Status, string BranchID)
        {
            string query = "INSERT INTO Orders (OrderID, OrderDate, CustomerID, OrderStatus, BranchID) VALUES('" + OrderID + "','" + Order_Date + "','" + CustomerID + "','" + Order_Status + "','" + BranchID + "');";

            if (SQL_Calls.OpenConnection() == true)
            {
                MySqlCommand cmd = new MySqlCommand(query, connection);
                var          r   = cmd.ExecuteNonQuery();
            }
            SQL_Calls.CloseConnection();
        }
Ejemplo n.º 10
0
        public static void UpdateProductOrder(int Quantity, string OrderID)
        {
            string query = "UPDATE ProductOrder SET Quantity = '" + Quantity + "' WHERE OrderID = '" + OrderID + "';";

            if (SQL_Calls.OpenConnection() == true)
            {
                //create command and assign the query and connection from the constructor
                MySqlCommand cmd = new MySqlCommand(query, connection);

                //Execute command
                var r = cmd.ExecuteNonQuery();
            }
            //close Connection
            SQL_Calls.CloseConnection();
        }
Ejemplo n.º 11
0
        public static void MaxOrderID()
        {
            string query = "SELECT OrderID FROM Orders WHERE OrderID = (SELECT MAX(OrderID) from Orders);";

            if (SQL_Calls.OpenConnection() == true)
            {
                MySqlCommand    cmd        = new MySqlCommand(query, connection);
                MySqlDataReader dataReader = cmd.ExecuteReader();
                dataReader.Read();
                OrderID = dataReader.GetInt32(0);
                OrderID++;
                dataReader.Close();
            }
            SQL_Calls.CloseConnection();
        }
Ejemplo n.º 12
0
        public static void UpdateReturnInventory(int Quantity, string BranchID, string SKU)
        {
            string query = "UPDATE Inventory SET Quantity = Quantity +" + Quantity.ToString() + " WHERE BranchID = '" + BranchID + "' and SKU = '" + SKU + "';";

            if (SQL_Calls.OpenConnection() == true)
            {
                //create command and assign the query and connection from the constructor
                MySqlCommand cmd = new MySqlCommand(query, connection);

                //Execute command
                var r = cmd.ExecuteNonQuery();
            }
            //close Connection
            SQL_Calls.CloseConnection();
        }
Ejemplo n.º 13
0
        public static void UpdateRefundStatus(string OrderID)
        {
            string query = "UPDATE Orders SET OrderStatus = 'RFND' WHERE OrderID = '" + OrderID + "';";

            if (SQL_Calls.OpenConnection() == true)
            {
                //create command and assign the query and connection from the constructor
                MySqlCommand cmd = new MySqlCommand(query, connection);

                //Execute command
                var r = cmd.ExecuteNonQuery();
            }
            //close Connection
            SQL_Calls.CloseConnection();
        }
 private void AddCust_Click(object sender, RoutedEventArgs e)
 {
     name  = NAME.Text;
     lname = LNAME.Text;
     phone = PHONE.Text;
     SQL_Calls.AddNewCustomer(name, lname, phone);
     //clear the text
     NAME.Text  = "";
     LNAME.Text = "";
     PHONE.Text = "";
     //refresh the view
     CustomersView.ItemsSource = null;
     ZP_Customers.CustList.Clear();
     ZP_Customers.CustList     = SQL_Calls.Select_Customers();
     CustomersView.ItemsSource = ZP_Customers.CustList;
 }
Ejemplo n.º 15
0
 public OrderWindow(int Location)
 {
     InitializeComponent();
     Loc = Location;
     //populate the cust select
     CustomerSelect.ItemsSource = null;
     ZP_Customers.CustList      = null;
     ZP_Customers.CustList      = SQL_Calls.Select_Customers();
     CustomerSelect.ItemsSource = ZP_Customers.CustList;
     //populate inventory by branch/loc
     ZP_Inventory.InvAtLoc    = null;
     ZP_Inventory.InvAtLoc    = SQL_Calls.Select_Inventory(Loc);
     LocInventory.ItemsSource = null;
     LocInventory.ItemsSource = ZP_Inventory.InvAtLoc;
     //get new orderID and set to SQL_Calls class for calling the number later
     SQL_Calls.MaxOrderID();
 }
Ejemplo n.º 16
0
        public static void AddNewCustomer(string fname, string lname, string phone)
        {
            int    tempCustID = CustomerID + 1;
            string query      = "INSERT INTO Customer (CustomerID, FirstName, LastName, Telephone) VALUES('" + tempCustID + "','" + fname + "','" + lname + "','" + phone + "');";

            //create command and assign the query and connection from the constructor

            if (SQL_Calls.OpenConnection() == true)
            {
                MySqlCommand cmd = new MySqlCommand(query, connection);
                //Execute command
                var r = cmd.ExecuteNonQuery();
            }

            //close Connection
            SQL_Calls.CloseConnection();
        }
Ejemplo n.º 17
0
        public static void AddNewProductToOrder(string OrderID, string SKU, int Quantity)
        {
            string query = "INSERT INTO ProductOrder (OrderID, SKU, Quantity) VALUES(" +
                           OrderID + "," +
                           SKU + "," +
                           Quantity + ");";

            if (SQL_Calls.OpenConnection() == true)
            {
                //create command and assign the query and connection from the constructor
                MySqlCommand cmd = new MySqlCommand(query, connection);

                //Execute command
                var r = cmd.ExecuteNonQuery();
            }
            //close Connection
            SQL_Calls.CloseConnection();
        }
Ejemplo n.º 18
0
 private void Refund_Click(object sender, RoutedEventArgs e)
 {
     foreach (Order temp in OrdersTable.SelectedItems)
     {
         foreach (OrderItems temp2 in ZP_Orders.contains)
         {
             SQL_Calls.UpdateReturnInventory(temp2.quantity, temp.branchID, temp2.SKU);
         }
         SQL_Calls.UpdateProductOrder(0, temp.orderID);
         SQL_Calls.UpdateRefundStatus(temp.orderID);
     }
     ZP_Orders.contains.Clear();
     ContentTable.ItemsSource = null;
     ContentTable.ItemsSource = ZP_Orders.contains;
     OrdersTable.ItemsSource  = null;
     ZP_Orders.allOrders.Clear();
     ZP_Orders.allOrders     = SQL_Calls.Select_OrderInfo();
     OrdersTable.ItemsSource = ZP_Orders.allOrders;
 }
Ejemplo n.º 19
0
        public static List <Order> Select_OrderInfo()
        {
            string query = "SELECT * FROM Orders;";

            //Create a list to store the result
            List <Order> list = new List <Order>();

            //Open connection
            if (SQL_Calls.OpenConnection() == true)
            {
                //Create Command
                MySqlCommand cmd = new MySqlCommand(query, connection);
                //Create a data reader and Execute the command
                MySqlDataReader dataReader = cmd.ExecuteReader();

                //Read the data and store them in the list
                while (dataReader.Read())
                {
                    Order temp = new Order();
                    temp.orderID  = dataReader["OrderID"] + "";
                    temp.date     = dataReader["OrderDate"] + "";
                    temp.custID   = dataReader["CustomerID"] + "";
                    temp.status   = dataReader["OrderStatus"] + "";
                    temp.branchID = dataReader["BranchID"] + "";
                    list.Add(temp);
                }

                //close Data Reader
                dataReader.Close();

                //close Connection
                SQL_Calls.CloseConnection();

                //return list to be displayed
                return(list);
            }
            else
            {
                return(list);
            }
        }
Ejemplo n.º 20
0
        public static List <InventoryEntry> Select_Inventory(int choice)
        {
            string query = "SELECT Inventory.BranchID, Inventory.SKU, Inventory.Quantity, Product.WholesalePrice, Product.ProductName FROM Inventory LEFT JOIN Product ON Inventory.SKU = Product.SKU HAVING BranchID =" + choice + ";";

            //Create a list to store the result
            List <InventoryEntry> list = new List <InventoryEntry>();

            //Open connection
            if (SQL_Calls.OpenConnection() == true)
            {
                //Create Command
                MySqlCommand cmd = new MySqlCommand(query, connection);
                //Create a data reader and Execute the command
                MySqlDataReader dataReader = cmd.ExecuteReader();

                //Read the data and store them in the list
                while (dataReader.Read())
                {
                    InventoryEntry temp = new InventoryEntry();
                    temp.branchID = dataReader["BranchID"] + "";
                    temp.SKU      = dataReader["SKU"] + "";
                    temp.quantity = int.Parse(dataReader["Quantity"] + "");
                    temp.price    = double.Parse(dataReader["WholesalePrice"] + "");
                    temp.pName    = dataReader["ProductName"] + "";
                    list.Add(temp);
                }

                //close Data Reader
                dataReader.Close();

                //close Connection
                SQL_Calls.CloseConnection();

                //return list to be displayed
                return(list);
            }
            else
            {
                return(list);
            }
        }
Ejemplo n.º 21
0
        public static List <CustomerEntry> Select_Customers()
        {
            string query = "SELECT * FROM Customer;";

            //Create a list to store the result
            List <CustomerEntry> list = new List <CustomerEntry>();

            //Open connection
            if (SQL_Calls.OpenConnection() == true)
            {
                //Create Command
                MySqlCommand cmd = new MySqlCommand(query, connection);
                //Create a data reader and Execute the command
                MySqlDataReader dataReader = cmd.ExecuteReader();

                //Read the data and store them in the list
                while (dataReader.Read())
                {
                    CustomerEntry temp = new CustomerEntry();
                    temp.custID  = dataReader["CustomerID"] + "";
                    temp.fName   = dataReader["FirstName"] + "";
                    temp.lName   = dataReader["LastName"] + "";
                    temp.tNumber = dataReader["Telephone"] + "";
                    CustomerID   = int.Parse(temp.custID);
                    list.Add(temp);
                }

                //close Data Reader
                dataReader.Close();

                //close Connection
                SQL_Calls.CloseConnection();

                //return list to be displayed
                return(list);
            }
            else
            {
                return(list);
            }
        }
Ejemplo n.º 22
0
        public static List <OrderItems> Select_Product_Order(string choice)
        {
            string query = "SELECT * FROM ProductOrder WHERE OrderID = '" + choice + "';";

            //Create a list to store the result
            List <OrderItems> list = new List <OrderItems>();

            //Open connection
            if (SQL_Calls.OpenConnection() == true)
            {
                //Create Command
                MySqlCommand cmd = new MySqlCommand(query, connection);
                //Create a data reader and Execute the command
                MySqlDataReader dataReader = cmd.ExecuteReader();

                //Read the data and store them in the list
                while (dataReader.Read())
                {
                    OrderItems temp = new OrderItems();
                    temp.orderID  = dataReader["OrderID"] + "";
                    temp.SKU      = dataReader["SKU"] + "";
                    temp.quantity = int.Parse(dataReader["Quantity"] + "");
                    list.Add(temp);
                }

                //close Data Reader
                dataReader.Close();

                //close Connection
                SQL_Calls.CloseConnection();

                //return list to be displayed
                return(list);
            }
            else
            {
                return(list);
            }
        }