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

        private void PumpStockHistoryForm_Load(object sender, EventArgs e)
        {
            mySqlFunctions.initConnection();
            if (mySqlFunctions.OpenConnection())
            {

                try
                {
                    dataGridViewPumpHistory.Rows.Clear();

                    dataGridViewPumpHistory.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
                    dataGridViewPumpHistory.ColumnCount = 5;
                    dataGridViewPumpHistory.Columns[0].Name = "Numer pompy";
                    dataGridViewPumpHistory.Columns[1].Name = "Status";
                    dataGridViewPumpHistory.Columns[2].Name = "Kontrahent";
                    dataGridViewPumpHistory.Columns[3].Name = "Opis";
                    dataGridViewPumpHistory.Columns[4].Name = "Data aktualizacji";

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

                    MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("select PUP_NAME,DRS_SN_NUMBER,SUBSTRING(DRS_BUY_DATE,1,10) DRS_BUY_DATE,(select DIC_POL_LANG from sys_dictionaries where DIC_ID=DRS_STATUS_DIC_ID) DIC_POL_LANG,(select PRT_DESCRIPTION from sys_participants where PRT_ID=DRS_AUDIT_USR) PRT_DESCRIPTION,DRS_DEV_DESCRIPTION,DRS_AUDIT_DATE from seg_dev_resources_his,seg_pumps where DRS_DEV_TYPE=10 and DRS_DEV_ID=PUP_ID and DRS_ID=" + devID.ToString() + " order by DRS_AUDIT_DATE desc", mySqlFunctions.connection);
                    MySql.Data.MySqlClient.MySqlDataReader dataReader = cmd.ExecuteReader();
                    while (dataReader.Read())
                    {
                        dataGridViewPumpHistory.Rows.Add(
                            dataReader["DRS_SN_NUMBER"],
                            dataReader["DIC_POL_LANG"],
                            dataReader["PRT_DESCRIPTION"],
                            dataReader["DRS_DEV_DESCRIPTION"],
                            dataReader["DRS_AUDIT_DATE"]
                            );

                        labelName.Text = dataReader["PUP_NAME"].ToString();

                        if (dataReader["DRS_BUY_DATE"].ToString().Length>0)
                            labelDate.Text = dataReader["DRS_BUY_DATE"].ToString();
                    }
                    dataReader.Close();


                    dataGridViewAggHistory.Rows.Clear();

                    dataGridViewAggHistory.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
                    dataGridViewAggHistory.ColumnCount = 5;
                    dataGridViewAggHistory.Columns[0].Name = "Numer pompy";
                    dataGridViewAggHistory.Columns[1].Name = "Silnik";
                    dataGridViewAggHistory.Columns[2].Name = "Numer silnika";
                    dataGridViewAggHistory.Columns[3].Name = "Kontrahent";
                    dataGridViewAggHistory.Columns[4].Name = "Data";

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

                    MySql.Data.MySqlClient.MySqlCommand cmd1 = new MySql.Data.MySqlClient.MySqlCommand("select APE_PUP_NO,APE_ENG_NAME,APE_ENG_NO,(select PRT_DESCRIPTION from sys_participants where PRT_ID=APE_PRT_ID) PRT_DESCRIPTION,SUBSTRING(APE_AUDIT_CD,1,10) APE_AUDIT_CD from seg_aggregate_pup_eng_his where APE_PUP_DRS_ID=" + devID.ToString() + " order by APE_AUDIT_CD desc", mySqlFunctions.connection);
                    MySql.Data.MySqlClient.MySqlDataReader dataReader1 = cmd1.ExecuteReader();
                    while (dataReader1.Read())
                    {
                        dataGridViewAggHistory.Rows.Add(
                            dataReader1["APE_PUP_NO"],
                            dataReader1["APE_ENG_NAME"],
                            dataReader1["APE_ENG_NO"],
                            dataReader1["PRT_DESCRIPTION"],
                            dataReader1["APE_AUDIT_CD"]
                            );
                    }
                    dataReader1.Close();

                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }

                mySqlFunctions.CloseConnection();
            }
        }


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