using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace StacjaProb
{
    public partial class motorsCatalogue : Form
    {
        public motorsCatalogue()
        {
            InitializeComponent();
        }

        private void LoadCurrentData(string motorName = null)
        {
            //Dla RAMBu
            buttonDodajSilnik.Visible = false;

            motorName = textBoxSearchMotor.Text;

            mySqlFunctions.initConnection();
            if (mySqlFunctions.OpenConnection())
            {
                dataGridMotorCatalogue.Rows.Clear();

                dataGridMotorCatalogue.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
                dataGridMotorCatalogue.ColumnCount = 5;
                dataGridMotorCatalogue.Columns[0].Name = vGlobal.vLng_dataGridMotorCatalogue_001;
                dataGridMotorCatalogue.Columns[1].Name = vGlobal.vLng_dataGridMotorCatalogue_002;
                dataGridMotorCatalogue.Columns[2].Name = vGlobal.vLng_dataGridMotorCatalogue_003;
                dataGridMotorCatalogue.Columns[3].Name = vGlobal.vLng_dataGridMotorCatalogue_004;
                dataGridMotorCatalogue.Columns[4].Visible = false;

                dataGridMotorCatalogue.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
                dataGridMotorCatalogue.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
                dataGridMotorCatalogue.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
                dataGridMotorCatalogue.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;

                MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("select * from seg_engines left join seg_manufacturers on ENG_MCF_ID=MCF_ID where ENG_STATUS='1' and ENG_NAME like '%" + motorName + "%' or ENG_POWER like '%" + motorName + "%' order by ENG_NAME,ENG_POWER", mySqlFunctions.connection);
                MySql.Data.MySqlClient.MySqlDataReader dataReader = cmd.ExecuteReader();
                while (dataReader.Read())
                {
                    dataGridMotorCatalogue.Rows.Add(
                        dataReader["ENG_NAME"], 
                        dataReader["ENG_VOLTAGE"], 
                        dataReader["ENG_POWER"], 
                        dataReader["MCF_NAME"], 
                        dataReader["ENG_ID"]);
                }

                mySqlFunctions.CloseConnection();
            }
        }


        private void motorsCatalogue_Load(object sender, EventArgs e)
        {
                LoadCurrentData();
                if (!vGlobal.tst_login_admin_priv)
                {
                    buttonDodajSilnik.Visible = false;
                    buttonDodajSilnik.Enabled = false;
                }

        }

        private void buttonDodajSilnik_Click(object sender, EventArgs e)
        {
            motorsCatalogueAdd formmotorsCatalogueAdd = new motorsCatalogueAdd();
            formmotorsCatalogueAdd.FormClosed += new FormClosedEventHandler(formmotorsCatalogueAdd_FormClosed);
            formmotorsCatalogueAdd.ShowDialog();
        }

        void formmotorsCatalogueAdd_FormClosed(object sender, FormClosedEventArgs e)
        {
            LoadCurrentData();
        }


        private void buttonClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void dataGridMotorCatalogue_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            motorsCatalogueAdd form = new motorsCatalogueAdd();
            form.silnID = Convert.ToInt32(this.dataGridMotorCatalogue.CurrentRow.Cells[4].Value.ToString());
            //form.comboBoxProd.Text = this.dataGridMotorCatalogue.CurrentRow.Cells[3].Value.ToString();
            form.selectedProd = this.dataGridMotorCatalogue.CurrentRow.Cells[3].Value.ToString();
            form.FormClosed += new FormClosedEventHandler(formmotorsCatalogueAdd_FormClosed);
            form.ShowDialog();
        }

        private void textBoxSearchMotor_TextChanged(object sender, EventArgs e)
        {
            LoadCurrentData(textBoxSearchMotor.Text);
        }
    }
}