private void deleteSelectedRow(string table, string index) // not working
        {
            packages.databaseDelete deleteSelRow = new packages.databaseDelete(table, index, dataGrid);
        }

        private void removeSelRow_Click(object sender, EventArgs e) // not working
        {
            #region in development
            switch (dir)
            {
                case 1:
                    deleteSelectedRow("product_dir", "PRODUCT_CODE");
                    btnProductDir_Click(sender, e);
                    break;
                case 2:
                    deleteSelectedRow("sub_dir", "SUB_CODE");
                    btnSubDir_Click(sender, e);
                    break;
                case 3:
                    deleteSelectedRow("employee_dir", "EMPLOYEE_CODE");
                    btnEmployeeDir_Click(sender, e);
                    break;
                case 4:
                    deleteSelectedRow("equipment_dir", "EQUIPMENT_CODE");
                    btnEquipmentDir_Click(sender, e);
                    break;
                case 5:
                    deleteSelectedRow("production_plan", "PERIOD_CODE");
                    btnProductionPlan_Click(sender, e);
                    break;
                case 6:
                    deleteSelectedRow("routemap", "ROUTEMAP_CODE");
                    btnRoutemap_Click(sender, e);
                    break;
            }
            #endregion
        }

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data;
using MySql.Data.MySqlClient;

namespace coursework_db.packages
{
    class databaseDelete
    {
        private string table { get; set; }

        private string nameOfIdRow { get; set; }

        private DataGridView dgv { get; set; }

        public databaseDelete(string table, string nameOfIdRow, DataGridView dgv)
        {
            this.table = table;
            this.nameOfIdRow = nameOfIdRow;
            this.dgv = dgv;

            deleteSelected();
        }

        private void deleteSelected()
        {
            /*packages.databaseSettings database = new packages.databaseSettings();

            DataRow row = (operationGrid.SelectedRows[0].DataBoundItem as DataRowView).Row;
            string query = String.Format("DELETE FROM {1} WHERE {2} = {3}",
                packages.databaseSettings.dbSchema,
                table,
                mainID,
                row[mainID]
            );
            using (MySqlConnection conn = new MySqlConnection("SERVER=localhost;DATABASE=testcs;username=root;PASSWORD=fcdk97"))
            {

                using (MySqlCommand cmd = new MySqlCommand(query, conn))
                {
                    conn.Open();
                    dataGrid.DataSource = database.getData(query);
                }
                conn.Close();
            }*/
            databaseSettings database = new databaseSettings();

            DataRow row = (dgv.SelectedRows[0].DataBoundItem as DataRowView).Row;

            string query = String.Format("DELETE FROM testcs.{0} WHERE {1} = {2}",
                table,
                nameOfIdRow,
                row[nameOfIdRow]
            );
            using (MySqlConnection conn = new MySqlConnection("SERVER=localhost;DATABASE=testcs;username=root;PASSWORD=fcdk97"))
            {

                using (MySqlCommand cmd = new MySqlCommand(query, conn))
                {
                    conn.Open();
                    dgv.DataSource = database.getData(query);
                }
                conn.Close();
            }
        }
    }
}