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 manufacturersForm : Form
    {
        public manufacturersForm()
        {
            InitializeComponent();
        }


        private void manufacturersForm_Load(object sender, EventArgs e)
        {
            //Dla RAMBu
            buttonDodajPompe.Visible = false;

            LoadCurrentData();
            if (!vGlobal.tst_login_admin_priv)
            {
                buttonDodajPompe.Visible = false;
                buttonDodajPompe.Enabled = false;
            }

        }

        private void LoadCurrentData()
        {
            mySqlFunctions.initConnection();
            if (mySqlFunctions.OpenConnection())
            {

                dataGridmanuMacturers.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
                dataGridmanuMacturers.ColumnCount = 7;
                dataGridmanuMacturers.Columns[0].Name = vGlobal.vLng_dataGridmanuMacturers_001;
                dataGridmanuMacturers.Columns[1].Name = vGlobal.vLng_dataGridmanuMacturers_002;
                dataGridmanuMacturers.Columns[2].Name = vGlobal.vLng_dataGridmanuMacturers_003;
                dataGridmanuMacturers.Columns[3].Name = vGlobal.vLng_dataGridmanuMacturers_004;
                dataGridmanuMacturers.Columns[4].Name = vGlobal.vLng_dataGridmanuMacturers_005;
                dataGridmanuMacturers.Columns[5].Name = vGlobal.vLng_dataGridmanuMacturers_006;
                dataGridmanuMacturers.Columns[6].Visible = false;


                dataGridmanuMacturers.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
                dataGridmanuMacturers.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
                dataGridmanuMacturers.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
                dataGridmanuMacturers.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
                dataGridmanuMacturers.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
                dataGridmanuMacturers.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;

                MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("select MCF_ID,MCF_NAME,MCF_CATEGORY,MCF_ADDRESS,MCF_POST,MCF_CITY,MCF_PHONE,MCF_MAIL from seg_manufacturers order by MCF_NAME", mySqlFunctions.connection);
                MySql.Data.MySqlClient.MySqlDataReader dataReader = cmd.ExecuteReader();
                while (dataReader.Read())
                {
                    dataGridmanuMacturers.Rows.Add(dataReader["MCF_NAME"], dataReader["MCF_CATEGORY"], dataReader["MCF_ADDRESS"], dataReader["MCF_POST"].ToString() + " " + dataReader["MCF_CITY"].ToString(), dataReader["MCF_PHONE"], dataReader["MCF_MAIL"], dataReader["MCF_ID"]);
                }

                mySqlFunctions.CloseConnection();
            }
        }



        private void buttonDodajPompe_Click(object sender, EventArgs e)
        {
            manufacturersFormAdd formmanufacturersFormAdd = new manufacturersFormAdd();
            formmanufacturersFormAdd.FormClosed += new FormClosedEventHandler(formmanufacturersFormAdd_FormClosed);
            formmanufacturersFormAdd.ShowDialog();
        }

        void formmanufacturersFormAdd_FormClosed(object sender, FormClosedEventArgs e)
        {
            dataGridmanuMacturers.Rows.Clear();
            LoadCurrentData();
        }


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

        private void dataGridmanuMacturers_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            manufacturersFormAdd form = new manufacturersFormAdd();
            form.prodID = Convert.ToInt32(this.dataGridmanuMacturers.CurrentRow.Cells[6].Value.ToString());
            form.FormClosed += new FormClosedEventHandler(formmanufacturersFormAdd_FormClosed);
            form.ShowDialog();
        }
    }
}