private void LoadData()
 {
     dtgvSuppliers.DataSource = Supplier.GetSupplierList().Tables[0].DefaultView;
 }
        private void cbTable_SelectedIndexChanged(object sender, EventArgs e)
        {
            string category = cbTable.SelectedItem.ToString();

            switch (category)
            {
            case "Customers":
            {
                DisplayTable(cbSearchAttr, dtgvTable, Customers, Customer.GetCustomerList());
                break;
            }

            case "Drinks":
            {
                DisplayTable(cbSearchAttr, dtgvTable, Drinks, Drink.GetDrinkList());
                break;
            }

            case "Elements":
            {
                DisplayTable(cbSearchAttr, dtgvTable, Elements, Element.GetElementList());
                break;
            }

            case "Employees":
            {
                DisplayTable(cbSearchAttr, dtgvTable, Employees, Employee.GetEmployeeList());
                break;
            }

            case "ImportBills":
            {
                DisplayTable(cbSearchAttr, dtgvTable, ImportBills, ImportBill.GetAllBills());
                break;
            }

            case "ExportBills":
            {
                DisplayTable(cbSearchAttr, dtgvTable, ExportBills, ExportBill.GetAllBills());
                break;
            }

            case "Jobs":
            {
                DisplayTable(cbSearchAttr, dtgvTable, Jobs, Job.GetJobList());
                break;
            }

            case "Suppliers":
            {
                DisplayTable(cbSearchAttr, dtgvTable, Suppliers, Supplier.GetSupplierList());
                break;
            }

            case "Accounts":
            {
                DisplayTable(cbSearchAttr, dtgvTable, Accounts, Account.GetAccountList());
                break;
            }
            }
        }