using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using AdvancedWizardControl.Wizard;
using AdvancedWizardControl.WizardPages;
using AdvancedWizardControl.Enums;
using AdvancedWizardControl.EventArguments;
using AdvancedWizardControl;
using Dapper;
using MySql.Data.MySqlClient;
using System.Diagnostics;
using System.IO;
 
namespace IT_A_stroy
{
    public partial class WizardPageEventArgs : Form
    {
        public int PreviousPage { get; set; }
        //DataSet ds;
        MySqlDataAdapter adapter;
        readonly string connectionString = "server=localhost;user=root;database=a_stroy;password=q1w2e3r4t5y6u7i8o9p0;";
        //string sql_1 = "select Progess, Progress_info from a_stroy.step3 where 1=2";
        public DataTable Execute(string script)
        {
            using (MySqlConnection connection = new MySqlConnection(connectionString))
            {
                DataTable table = new DataTable();
                connection.Open();
                adapter = new MySqlDataAdapter(script, connection);
                adapter.Fill(table);
                return table;
            }
        }
 
        private void СomboBox1_SelectedValueChanged(object sender, EventArgs e)
        {
            dataGridView1.Rows.Clear();
            if (comboBox1.SelectedValue != null)
            {
                column1.DataSource = Execute($"SELECT id_Object, id_customer, Name_object FROM a_stroy.object where id_customer = {comboBox1.SelectedValue};");
                column1.DisplayMember = "Name_object";
                column1.ValueMember = "id_Object";
                int countRow = dataGridView1.RowCount == 1 ? 1 : dataGridView1.RowCount - 1;
                //int DGV1 = comboBox1.SelectedIndex;
                //ds.Tables["step3"].Rows.Add(countRow);
            }
        }
 
        private void DataGridView1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
        {
            ComboBox cbDgv = e.Control as ComboBox;
            cbDgv.SelectedValueChanged -= CbDgv_SelectedValueChanged;
            cbDgv.SelectedValueChanged += CbDgv_SelectedValueChanged;
        }
 
        private void CbDgv_SelectedValueChanged(object sender, EventArgs e)
        {
            ComboBox box = sender as ComboBox;
            Debug.WriteLine(box.SelectedValue);
            column2.DataSource = Execute($"SELECT id_Object, Name_works FROM a_stroy.words_object where id_Object = {box.SelectedValue}");
            column2.DisplayMember = "Name_works";
            column2.ValueMember = "id_Object";
        }
 
        private void DataGridView2_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
           //
        }
 
        public WizardPageEventArgs()
        {
            InitializeComponent();
            //using (MySqlConnection connection = new MySqlConnection(connectionString))
            //{
            //    connection.Open();
            //    ds = new DataSet();
            //    adapter = new MySqlDataAdapter(sql_1, connection);
            //    adapter.Fill(ds);
            //    dataGridView3.DataSource = ds.Tables["step1_1"];
            //}
 
            comboBox1.DataSource = Execute("SELECT id_customer, Name_customer FROM a_stroy.customer;");
            comboBox1.DisplayMember = "Name_customer";
            comboBox1.ValueMember = "id_customer";
            comboBox1.DropDownStyle = ComboBoxStyle.DropDownList;
            comboBox1.SelectedValueChanged += new System.EventHandler(СomboBox1_SelectedValueChanged);
 
            comboBox2.DataSource = Execute("SELECT id_organization, Name_organization FROM a_stroy.organization;");
            comboBox2.DisplayMember = "Name_organization";
            comboBox2.ValueMember = "id_organization";
            comboBox2.DropDownStyle = ComboBoxStyle.DropDownList;
 
            // DataGridView1
            column1 = new DataGridViewComboBoxColumn();
            column1.HeaderText = "Выберите объект(ы)";
            column1.Name = "Column1";
            dataGridView1.Columns.AddRange(new DataGridViewColumn[] { column1 });
            dataGridView1.Columns["Column1"].Width = 332;
 
            Debug.WriteLine(comboBox1.SelectedIndex);
 
            // DataGridView2
            column2 = new DataGridViewComboBoxColumn();
            column3 = new DataGridViewTextBoxColumn();
            column4 = new DataGridViewTextBoxColumn();
            column5 = new DataGridViewButtonColumn();
            column2.HeaderText = "Наименование работы";
            column3.HeaderText = "Выполненный объем";
            column4.HeaderText = "Наименования выбранных файлов";
            column5.HeaderText = "Выберите файл";
            column2.Name = "Column2";
            column3.Name = "Column3";
            column4.Name = "Column4";
            column5.Name = "Column5";
            dataGridView2.Columns.AddRange(new DataGridViewColumn[] { column2, column3, column4, column5 });
            dataGridView2.Columns["Column2"].Width = 200;
            dataGridView2.Columns["Column3"].Width = 141;
            dataGridView2.Columns["Column4"].Width = 240;
            dataGridView2.Columns["Column5"].Width = 100;
            dataGridView2.Columns[2].ReadOnly = true;
            Debug.WriteLine(comboBox2.SelectedIndex);
 
            // DataGridView3
            column6 = new DataGridViewTextBoxColumn();
            column7 = new DataGridViewTextBoxColumn();
            column8 = new DataGridViewTextBoxColumn();
            column6.HeaderText = "Наименование объекта";
            column7.HeaderText = "Наименование достижения";
            column8.HeaderText = "Описание достижения";
            column6.Name = "Column6";
            column7.Name = "Column7";
            column8.Name = "Column8";
            dataGridView3.Columns.AddRange(new DataGridViewColumn[] { column6, column7, column8 });
            dataGridView3.Columns["Column6"].Width = 200;
            dataGridView3.Columns["Column7"].Width = 181;
            dataGridView3.Columns["Column8"].Width = 300;
            dataGridView3.AllowUserToAddRows = false;
            
            // DataGridView4
            column9 = new DataGridViewTextBoxColumn();
            column10 = new DataGridViewTextBoxColumn();
            column11 = new DataGridViewTextBoxColumn();
            column9.HeaderText = "Наименование объекта";
            column10.HeaderText = "Трудности";
            column11.HeaderText = "Комментарий";
            column9.Name = "Column9";
            column10.Name = "Column10";
            column11.Name = "Column11";
            dataGridView4.Columns.AddRange(new DataGridViewColumn[] { column9, column10, column11 });
            dataGridView4.Columns["Column9"].Width = 200;
            dataGridView4.Columns["Column10"].Width = 181;
            dataGridView4.Columns["Column11"].Width = 300;
            dataGridView4.AllowUserToAddRows = false;
 
            // DataGridView5
            column12 = new DataGridViewTextBoxColumn();
            column13 = new DataGridViewTextBoxColumn();
            column14 = new DataGridViewButtonColumn();
            column15 = new DataGridViewTextBoxColumn();
            column12.HeaderText = "Наименование объекта";
            column13.HeaderText = "Выбранная диаграмма (график производства работ)";
            column14.HeaderText = "Выберите файл";
            column15.HeaderText = "Комментарий";
            column12.Name = "Column12";
            column13.Name = "Column13";
            column14.Name = "Column14";
            column15.Name = "Column15";
            dataGridView5.Columns.AddRange(new DataGridViewColumn[] { column12, column13, column14, column15 });
            dataGridView5.Columns["Column12"].Width = 150;
            dataGridView5.Columns["Column13"].Width = 181;
            dataGridView5.Columns["Column14"].Width = 150;
            dataGridView5.Columns["Column15"].Width = 200;
            dataGridView5.AllowUserToAddRows = false;
 
            // DataGridView6
            column16 = new DataGridViewTextBoxColumn();
            column17 = new DataGridViewComboBoxColumn();
            column18 = new DataGridViewTextBoxColumn();
            column19 = new DataGridViewTextBoxColumn();
            column20 = new DataGridViewTextBoxColumn();
            column21 = new DataGridViewComboBoxColumn();
            column22 = new DataGridViewComboBoxColumn();
            column16.HeaderText = "Задача/документ";
            column17.HeaderText = "Ответсвенная сторона";
            column18.HeaderText = "Дата подачи";
            column19.HeaderText = "Плановый срок";
            column20.HeaderText = "Задержка дней";
            column21.HeaderText = "Этап";
            column22.HeaderText = "Статус";
            column16.Name = "Column16";
            column17.Name = "Column17";
            column18.Name = "Column18";
            column19.Name = "Column19";
            column20.Name = "Column20";
            column21.Name = "Column21";
            column22.Name = "Column22";
            dataGridView6.Columns.AddRange(new DataGridViewColumn[] { column16, column17, column18, column19, column20, column21, column22 });
            dataGridView6.Columns["Column16"].Width = 141;
            dataGridView6.Columns["Column17"].Width = 130;
            dataGridView6.Columns["Column18"].Width = 80;
            dataGridView6.Columns["Column19"].Width = 80;
            dataGridView6.Columns["Column20"].Width = 70;
            dataGridView6.Columns["Column21"].Width = 90;
            dataGridView6.Columns["Column22"].Width = 90;
            //Debug.WriteLine(comboBox1.SelectedIndex);
 
            // DataGridView7
            column23 = new DataGridViewComboBoxColumn();
            column24 = new DataGridViewTextBoxColumn();
            column25 = new DataGridViewTextBoxColumn();
            column26 = new DataGridViewTextBoxColumn();
            column27 = new DataGridViewTextBoxColumn();
            column28 = new DataGridViewTextBoxColumn();
            column29 = new DataGridViewTextBoxColumn();
            column23.HeaderText = "Номер договора";
            column24.HeaderText = "Номер недели";
            column25.HeaderText = "Размер аванса";
            column26.HeaderText = "Дата авансового платежа";
            column27.HeaderText = "Оплата выполненных работ";
            column28.HeaderText = "Гарантийное удержание";
            column29.HeaderText = "Дата фактического платежа";
            column23.Name = "Column23";
            column24.Name = "Column24";
            column25.Name = "Column25";
            column26.Name = "Column26";
            column27.Name = "Column27";
            column28.Name = "Column28";
            column29.Name = "Column29";
            dataGridView7.Columns.AddRange(new DataGridViewColumn[] { column23, column24, column25, column26, column27, column28, column29 });
            dataGridView7.Columns["Column23"].Width = 90;
            dataGridView7.Columns["Column24"].Width = 60;
            dataGridView7.Columns["Column25"].Width = 60;
            dataGridView7.Columns["Column26"].Width = 120;
            dataGridView7.Columns["Column27"].Width = 131;
            dataGridView7.Columns["Column28"].Width = 90;
            dataGridView7.Columns["Column29"].Width = 130;
            dataGridView7.AllowUserToAddRows = false;
            //Debug.WriteLine(comboBox1.SelectedIndex);
 
            // DataGridView8
            column30 = new DataGridViewComboBoxColumn();
            column31 = new DataGridViewTextBoxColumn();
            column32 = new DataGridViewTextBoxColumn();
            column33 = new DataGridViewTextBoxColumn();
            column34 = new DataGridViewTextBoxColumn();
            column35 = new DataGridViewComboBoxColumn();
            column30.HeaderText = "Номер договора";
            column31.HeaderText = "Номер акта КС2/КС3";
            column32.HeaderText = "Период";
            column33.HeaderText = "Дата подачи";
            column34.HeaderText = "Дата подписания";
            column35.HeaderText = "Статус";
            column30.Name = "Column30";
            column31.Name = "Column31";
            column32.Name = "Column32";
            column33.Name = "Column33";
            column34.Name = "Column34";
            column35.Name = "Column35";
            dataGridView8.Columns.AddRange(new DataGridViewColumn[] { column30, column31, column32, column33, column34, column35 });
            dataGridView8.Columns["Column30"].Width = 116;
            dataGridView8.Columns["Column31"].Width = 140;
            dataGridView8.Columns["Column32"].Width = 100;
            dataGridView8.Columns["Column33"].Width = 100;
            dataGridView8.Columns["Column34"].Width = 125;
            dataGridView8.Columns["Column35"].Width = 100;
            //Debug.WriteLine(comboBox1.SelectedIndex);
 
            // DataGridView12
            column36 = new DataGridViewTextBoxColumn();
            column37 = new DataGridViewTextBoxColumn();
            column38 = new DataGridViewTextBoxColumn();
            column39 = new DataGridViewTextBoxColumn();
            column40 = new DataGridViewTextBoxColumn();
            column41 = new DataGridViewTextBoxColumn();
            column42 = new DataGridViewTextBoxColumn();
            column36.HeaderText = "Номер договора";
            column37.HeaderText = "Общий журнал";
            column38.HeaderText = "Замечаний всего";
            column39.HeaderText = "Не снятых замечаний";
            column40.HeaderText = "Журналы по ТБ";
            column41.HeaderText = "Журналы выдачи СИЗ";
            column42.HeaderText = "АОСР";
            column36.Name = "Column36";
            column37.Name = "Column37";
            column38.Name = "Column38";
            column39.Name = "Column39";
            column40.Name = "Column40";
            column41.Name = "Column41";
            column42.Name = "Column42";
            dataGridView12.Columns.AddRange(new DataGridViewColumn[] { column36, column37, column38, column39, column40, column41, column42 });
            dataGridView12.Columns["Column36"].Width = 120;
            dataGridView12.Columns["Column37"].Width = 111;
            dataGridView12.Columns["Column38"].Width = 100;
            dataGridView12.Columns["Column39"].Width = 100;
            dataGridView12.Columns["Column40"].Width = 100;
            dataGridView12.Columns["Column41"].Width = 100;
            dataGridView12.Columns["Column42"].Width = 50;
            dataGridView12.AllowUserToAddRows = false;
 
            // DataGridView13
            column43 = new DataGridViewTextBoxColumn();
            column44 = new DataGridViewTextBoxColumn();
            column45 = new DataGridViewTextBoxColumn();
            column46 = new DataGridViewTextBoxColumn();
            column47 = new DataGridViewTextBoxColumn();
            column48 = new DataGridViewComboBoxColumn();
            column49 = new DataGridViewComboBoxColumn();
            column43.HeaderText = "Учаток работ";
            column44.HeaderText = "Объем работ";
            column45.HeaderText = "Место работ";
            column46.HeaderText = "Дата подачи КП";
            column47.HeaderText = "Плановый срок решения";
            column48.HeaderText = "Статус работ";
            column49.HeaderText = "Статус документов";
            column43.Name = "Column43";
            column44.Name = "Column44";
            column45.Name = "Column45";
            column46.Name = "Column46";
            column47.Name = "Column47";
            column48.Name = "Column48";
            column49.Name = "Column49";
            dataGridView13.Columns.AddRange(new DataGridViewColumn[] { column43, column44, column45, column46, column47, column48, column49 });
            dataGridView13.Columns["Column43"].Width = 110;
            dataGridView13.Columns["Column44"].Width = 100;
            dataGridView13.Columns["Column45"].Width = 100;
            dataGridView13.Columns["Column46"].Width = 95;
            dataGridView13.Columns["Column47"].Width = 105;
            dataGridView13.Columns["Column48"].Width = 80;
            dataGridView13.Columns["Column49"].Width = 91;
            //Debug.WriteLine(comboBox1.SelectedIndex);
 
            // DataGridView14
            column50 = new DataGridViewTextBoxColumn();
            column51 = new DataGridViewComboBoxColumn();
            column52 = new DataGridViewTextBoxColumn();
            column53 = new DataGridViewCheckBoxColumn();
            column50.HeaderText = "Обусждаемые вопросы";
            column51.HeaderText = "Ответственный";
            column52.HeaderText = "Результат";
            column53.HeaderText = "Актуальность";
            column50.Name = "Column50";
            column51.Name = "Column51";
            column52.Name = "Column52";
            column53.Name = "Column53";
            dataGridView14.Columns.AddRange(new DataGridViewColumn[] { column50, column51, column52, column53 });
            dataGridView14.Columns["Column50"].Width = 300;
            dataGridView14.Columns["Column51"].Width = 131;
            dataGridView14.Columns["Column52"].Width = 150;
            dataGridView14.Columns["Column53"].Width = 100;
            //Debug.WriteLine(comboBox1.SelectedIndex);
        }
        DataGridViewComboBoxColumn column1;
        DataGridViewComboBoxColumn column2;
        DataGridViewTextBoxColumn column3;
        DataGridViewTextBoxColumn column4;
        DataGridViewButtonColumn column5;
        DataGridViewTextBoxColumn column6;
        DataGridViewTextBoxColumn column7;
        DataGridViewTextBoxColumn column8;
        DataGridViewTextBoxColumn column9;
        DataGridViewTextBoxColumn column10;
        DataGridViewTextBoxColumn column11;
        DataGridViewTextBoxColumn column12;
        DataGridViewTextBoxColumn column13;
        DataGridViewButtonColumn column14;
        DataGridViewTextBoxColumn column15;
        DataGridViewTextBoxColumn column16;
        DataGridViewComboBoxColumn column17;
        DataGridViewTextBoxColumn column18;
        DataGridViewTextBoxColumn column19;
        DataGridViewTextBoxColumn column20;
        DataGridViewComboBoxColumn column21;
        DataGridViewComboBoxColumn column22;
        DataGridViewComboBoxColumn column23;
        DataGridViewTextBoxColumn column24;
        DataGridViewTextBoxColumn column25;
        DataGridViewTextBoxColumn column26;
        DataGridViewTextBoxColumn column27;
        DataGridViewTextBoxColumn column28;
        DataGridViewTextBoxColumn column29;
        DataGridViewComboBoxColumn column30;
        DataGridViewTextBoxColumn column31;
        DataGridViewTextBoxColumn column32;
        DataGridViewTextBoxColumn column33;
        DataGridViewTextBoxColumn column34;
        DataGridViewComboBoxColumn column35;
        DataGridViewTextBoxColumn column36;
        DataGridViewTextBoxColumn column37;
        DataGridViewTextBoxColumn column38;
        DataGridViewTextBoxColumn column39;
        DataGridViewTextBoxColumn column40;
        DataGridViewTextBoxColumn column41;
        DataGridViewTextBoxColumn column42;
        DataGridViewTextBoxColumn column43;
        DataGridViewTextBoxColumn column44;
        DataGridViewTextBoxColumn column45;
        DataGridViewTextBoxColumn column46;
        DataGridViewTextBoxColumn column47;
        DataGridViewComboBoxColumn column48;
        DataGridViewComboBoxColumn column49;
        DataGridViewTextBoxColumn column50;
        DataGridViewComboBoxColumn column51;
        DataGridViewTextBoxColumn column52;
        DataGridViewCheckBoxColumn column53;
 
        private void ДобавитьОрганизациюToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Form a = new Form1();
            a.Show();
        }
 
        private void ДобавитьЗаказчикаToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Form b = new Form2();
            b.Show();
        }
 
        private void ДобавитьОбъектToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Form c = new Form3();
            c.Show();
        }
 
        private void ПротоколСобранияToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Form d = new Form4();
            d.Show();
        }
 
        private void DataGridView5_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            //dataGridView5.Rows[e.RowIndex].Cells[2].Value = "Выберите файл";
        }
 
        private void Form0_Load(object sender, EventArgs e)
        {
            // TODO: данная строка кода позволяет загрузить данные в таблицу "a_stroyDataSet.customer". При необходимости она может быть перемещена или удалена.
            this.customerTableAdapter.Fill(this.a_stroyDataSet.customer);
            // TODO: данная строка кода позволяет загрузить данные в таблицу "a_stroyDataSet5._object". При необходимости она может быть перемещена или удалена.
            this.objectTableAdapter.Fill(this.a_stroyDataSet5._object);
            advancedWizard1.FinishButton = false;
        }
 
        private void AdvancedWizard1_CancelClick(object sender, EventArgs e)
        {
            Close();
        }
 
        private void AdvancedWizard1_Finish(object sender, EventArgs e)
        {
            MessageBox.Show("Введенные данные успешно сохранены!", "Successful");
        }
 
        public WizardPageEventArgs(int Lastpage)
        {
            int a = PreviousPage;
            //int b = LastPage;
            if (a + 1 == Lastpage)
            {
                advancedWizard1.FinishButton = true;
                advancedWizard1.FinishButtonEnabled = true;
                advancedWizard1.NextButtonEnabled = false;
            }
            else
            {
                advancedWizard1.FinishButton = false;
                advancedWizard1.FinishButtonEnabled = false;
                advancedWizard1.NextButtonEnabled = true;
            }
        }
 
    }
}