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

namespace WindowsFormsApp6
{
    public partial class Form1 : Form
    {
        SqlConnection sqlConnection;
        public Form1()
        {
            InitializeComponent();
        }

        private async void Form1_Load(object sender, EventArgs e)
        {
            string connectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\ZZZ\source\repos\WindowsFormsApp6\Forces of Evil.mdf;Integrated Security=True;Connect Timeout=30";
            sqlConnection = new SqlConnection(connectionString);
            await sqlConnection.OpenAsync();
            SqlDataReader sqlReader = null;
            SqlCommand command = new SqlCommand("SELECT *FROM[detal],[nomer],[postavhik],[remont],[tip_tehiki]", sqlConnection);
            try
            {
                sqlReader = await command.ExecuteReaderAsync();

                while (await sqlReader.ReadAsync())
                {
                    //name,got,idpa,jahr,ceha,kolvo,idto
                    //"nain_delnomerproijvoditelkol_votype_tehikiind
                   // listBox1.Items.Add(Convert.ToString(sqlReader["nain_del"]) + " " + Convert.ToString(sqlReader["nomer"]) + " " + Convert.ToString(sqlReader["proijvoditel"]) + " " + Convert.ToString(sqlReader["kol_vo"]) + " " + Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["ind"]));
                   //type_tehiki,model,nomer,potracheho_ha_remoht,garahtihi_crok,cislitca_c,kolvo_remontov,ind"]));
                   //type_tehiki,data,jakypleho_ha_cymmy,adrec,naim_del,ind,ima;
                   // nomer,model,data",voditel,prichiha,vrema_remonta,remonty_podlejit,type_tehiki,ind;
                  //type_tehiki,proizvoditel,model,potracheho_ha_remoht,ha_remonte,ind
                
                listBox1.Items.Add(Convert.ToString(sqlReader["naim_del"]) + " " + Convert.ToString(sqlReader["nomer"]) + " " + Convert.ToString(sqlReader["proijvoditel"]) + " " + Convert.ToString(sqlReader["kol_vo"]) + " " + Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["ind"]));
                    listBox2.Items.Add(Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["model"]) + " " + Convert.ToString(sqlReader["nomer"]) + " " + Convert.ToString(sqlReader["potracheho_ha_remoht"])+" "+ Convert.ToString(sqlReader["garahtihi_crok"]) +" "+ Convert.ToString(sqlReader["cislitca_c"]) +" "+ Convert.ToString(sqlReader["kolvo_remontov"])+" " + Convert.ToString(sqlReader["ind"]));
                    listBox3.Items.Add(Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["data"]) + " " + Convert.ToString(sqlReader["jakypleho_ha_cymmy"]) + " " + Convert.ToString(sqlReader["adrec"]) + " " + Convert.ToString(sqlReader["naim_del"]) + " " + Convert.ToString(sqlReader["ind"]) + " " + Convert.ToString(sqlReader["ima"]));
                    listBox4.Items.Add(Convert.ToString(sqlReader["nomer"]) + " " + Convert.ToString(sqlReader["model"]) + " " + Convert.ToString(sqlReader["data"]) + " " + Convert.ToString(sqlReader["voditel"])+ " " + Convert.ToString(sqlReader["prichiha"]) + " " + Convert.ToString(sqlReader["vrema_remonta"]) + " " + Convert.ToString(sqlReader["remonty_podlejit"]) + " " + Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["ind"]));
                    listBox5.Items.Add(Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["proizvoditel"]) + " " + Convert.ToString(sqlReader["model"]) + " " + Convert.ToString(sqlReader["potracheho_ha_remoht"]) + " " + Convert.ToString(sqlReader["ha_remonte"]) + " " + Convert.ToString(sqlReader["ind"]));
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);

            }
            finally
            {
                if (sqlReader != null)
                    sqlReader.Close();
            }
        }
        private void выходToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (sqlConnection != null && sqlConnection.State != ConnectionState.Closed)
                sqlConnection.Close();
        }

        private void Form1_FormClosing(object sender, FormClosingEventArgs e)
        {
            if (sqlConnection != null && sqlConnection.State != ConnectionState.Closed)
                sqlConnection.Close();
        }
        private async void button1_Click(object sender, EventArgs e)
        {
            SqlCommand command = new SqlCommand("INSERT [detal] (naim_del,nomer,proijvoditel,kol_vo,type_tehiki,ind)VALUES (@naim_del,@nomer,@proijvoditel,@kol_vo,@type_tehiki,@ind)", sqlConnection);
            command.Parameters.AddWithValue("naim_del", textBox15.Text);
            command.Parameters.AddWithValue("nomer", textBox14.Text);
            command.Parameters.AddWithValue("proijvoditel", textBox13.Text);
            command.Parameters.AddWithValue("kol_vo", textBox12.Text);
            command.Parameters.AddWithValue("type_tehiki", textBox11.Text);
            command.Parameters.AddWithValue("ind", textBox20.Text);
        
            await command.ExecuteNonQueryAsync();
        }
        private async void button6_Click(object sender, EventArgs e)
        {
            SqlCommand command = new SqlCommand("INSERT [nomer] (type_tehiki,model,nomer,potracheho_ha_remoht,garahtihi_crok,cislitca_c,kolvo_remontov,ind)VALUES (@type_tehiki,@model,@nomer,@potracheho_ha_remoht,@garahtihi_crok,@cislitca_c,@kolvo_remontov,@ind)", sqlConnection);
            command.Parameters.AddWithValue("type_tehiki", textBox27.Text);
            command.Parameters.AddWithValue("model", textBox26.Text);
            command.Parameters.AddWithValue("nomer", textBox23.Text);
            command.Parameters.AddWithValue("potracheho_ha_remoht", textBox25.Text);
            command.Parameters.AddWithValue("garahtihi_crok", textBox24.Text);
            command.Parameters.AddWithValue("cislitca_c", textBox32.Text);
            command.Parameters.AddWithValue("kolvo_remontov", textBox31.Text);
            command.Parameters.AddWithValue("ind", textBox28.Text);
            await command.ExecuteNonQueryAsync();
        }
        private async void button9_Click(object sender, EventArgs e)
        {
            SqlCommand command = new SqlCommand("INSERT [postavhik] (type_tehiki,data,jakypleho_ha_cymmy,adrec,naim_del,ind,ima)VALUES (@type_tehiki,@data,@jakypleho_ha_cymmy,@adrec,@naim_del,@ind,@ima)", sqlConnection);
            command.Parameters.AddWithValue("type_tehiki", textBox48.Text);
            command.Parameters.AddWithValue("data", textBox47.Text);
            command.Parameters.AddWithValue("jakypleho_ha_cymmy", textBox44.Text);
            command.Parameters.AddWithValue("adrec", textBox46.Text);
            command.Parameters.AddWithValue("naim_del", textBox45.Text);
            command.Parameters.AddWithValue("ind", textBox53.Text);
            command.Parameters.AddWithValue("ima", textBox52.Text);
            await command.ExecuteNonQueryAsync();
        }
        private async void button12_Click(object sender, EventArgs e)
        {
            SqlCommand command = new SqlCommand("INSERT [remont] (nomer,model,data, voditel, prichiha, vrema_remonta, remonty_podlejit, type_tehiki, ind)VALUES (@nomer,@model,@data,@voditel,@prichiha,@vrema_remonta,@remonty_podlejit,@type_tehiki,@ind)", sqlConnection);
            command.Parameters.AddWithValue("nomer", textBox69.Text);
            command.Parameters.AddWithValue("model", textBox68.Text);
            command.Parameters.AddWithValue("data", textBox65.Text);
            command.Parameters.AddWithValue("voditel", textBox67.Text);
            command.Parameters.AddWithValue("prichiha", textBox66.Text);
            command.Parameters.AddWithValue("vrema_remonta", textBox74.Text);
            command.Parameters.AddWithValue("remonty_podlejit", textBox73.Text);
            command.Parameters.AddWithValue("type_tehiki", textBox70.Text);
            command.Parameters.AddWithValue("ind", textBox72.Text);
            await command.ExecuteNonQueryAsync();
        }
        private async void button15_Click(object sender, EventArgs e)
        {
            SqlCommand command = new SqlCommand("INSERT [tip_tehiki] (type_tehiki,proizvoditel,model,potracheho_ha_remoht,ha_remonte,ind)VALUES (@type_tehiki,@proizvoditel,@model,@potracheho_ha_remoht,@ha_remonte,@ind)", sqlConnection);
            command.Parameters.AddWithValue("type_tehiki", textBox90.Text);
            command.Parameters.AddWithValue("proizvoditel", textBox89.Text);
            command.Parameters.AddWithValue("model", textBox86.Text);
            command.Parameters.AddWithValue("potracheho_ha_remoht", textBox88.Text);
            command.Parameters.AddWithValue("ha_remonte", textBox87.Text);
            command.Parameters.AddWithValue("ind", textBox95.Text);
       
            await command.ExecuteNonQueryAsync();
        }

        private async void обновитьToolStripMenuItem_Click(object sender, EventArgs e)
        {
            listBox1.Items.Clear();
            listBox2.Items.Clear();
            listBox3.Items.Clear();
            SqlDataReader sqlReader = null;
            SqlCommand command = new SqlCommand("SELECT *FROM[name1],[otcet1],[part]", sqlConnection);
            try
            {
                sqlReader = await command.ExecuteReaderAsync();

                while (await sqlReader.ReadAsync())
                {
                    listBox1.Items.Add(Convert.ToString(sqlReader["naim_del"]) + " " + Convert.ToString(sqlReader["nomer"]) + " " + Convert.ToString(sqlReader["proijvoditel"]) + " " + Convert.ToString(sqlReader["kol_vo"]) + " " + Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["ind"]));
                    listBox2.Items.Add(Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["model"]) + " " + Convert.ToString(sqlReader["nomer"]) + " " + Convert.ToString(sqlReader["potracheho_ha_remoht"]) + " " + Convert.ToString(sqlReader["garahtihi_crok"])+ " " + Convert.ToString(sqlReader["cislitca_c"]) + " " + Convert.ToString(sqlReader["kolvo_remontov"] )+ " " + Convert.ToString(sqlReader["ind"]));
                    listBox3.Items.Add(Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["data"]) + " " + Convert.ToString(sqlReader["jakypleho_ha_cymmy"]) + " " + Convert.ToString(sqlReader["adrec"])+ " " + Convert.ToString(sqlReader["naim_del"]) + " " + Convert.ToString(sqlReader["ind"]) + " " + Convert.ToString(sqlReader["ima"]));
                    listBox4.Items.Add(Convert.ToString(sqlReader["nomer"]) + " " + Convert.ToString(sqlReader["model"]) + " " + Convert.ToString(sqlReader["data"]) + " " + Convert.ToString(sqlReader["voditel"]) + " " + Convert.ToString(sqlReader["prichiha"]) + " " + Convert.ToString(sqlReader["vrema_remonta"]) + " " + Convert.ToString(sqlReader["remonty_podlejit"]) + " " + Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["ind"]));
                    listBox5.Items.Add(Convert.ToString(sqlReader["type_tehiki"]) + " " + Convert.ToString(sqlReader["proizvoditel"]) + " " + Convert.ToString(sqlReader["model"]) + " " + Convert.ToString(sqlReader["potracheho_ha_remoht"]) + " " + Convert.ToString(sqlReader["ha_remonte"]) + " " + Convert.ToString(sqlReader["ind"]));
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            finally
            {
                if (sqlReader != null)
                    sqlReader.Close();
            }
        }
       
        private async void button2_Click(object sender, EventArgs e)
        {
            SqlCommand command = new SqlCommand("UPDATE [detal] SET [naim_del]=@naim_del,[nomer]=@nomer,[proijvoditel]=@proijvoditel,[kol_vo]=@kol_vo,[type_tehiki]=@type_tehiki,[ind]=@ind", sqlConnection);
            command.Parameters.AddWithValue("naim_del", textBox6.Text);
            command.Parameters.AddWithValue("nomer", textBox10.Text);
            command.Parameters.AddWithValue("proijvoditel", textBox7.Text);
            command.Parameters.AddWithValue("kol_vo", textBox9.Text);
            command.Parameters.AddWithValue("type_tehiki", textBox8.Text);
            command.Parameters.AddWithValue("ind", textBox1.Text);

            await command.ExecuteNonQueryAsync();
        }
        private async void button5_Click(object sender, EventArgs e)
        {
            SqlCommand command = new SqlCommand("UPDATE [nomer] SET[type_tehiki]=@type_tehiki,[model]=@model,[nomer]=@nomer,[potracheho_ha_remoht]=@potracheho_ha_remoht,[garahtihi_crok]=@garahtihi_crok,[cislitca_c]=@cislitca_c,[kolvo_remontov]=@kolvo_remontov WHERE [ind]=@ind",sqlConnection);
            command.Parameters.AddWithValue("type_tehiki", textBox37.Text);
            command.Parameters.AddWithValue("model", textBox36.Text);
            command.Parameters.AddWithValue("nomer", textBox33.Text);
            command.Parameters.AddWithValue("potracheho_ha_remoht", textBox35.Text);
            command.Parameters.AddWithValue("garahtihi_crok", textBox34.Text);
            command.Parameters.AddWithValue("cislitca_c", textBox42.Text);
            command.Parameters.AddWithValue("kolvo_remontov", textBox41.Text);
            command.Parameters.AddWithValue("ind", textBox38.Text);
            await command.ExecuteNonQueryAsync();
        }
        private async void button8_Click(object sender, EventArgs e)
        {
            SqlCommand command = new SqlCommand("UPDATE [postavhik] SET ([type_tehiki]=@type_tehiki,[data]=@data,[jakypleho_ha_cymmy]=@jakypleho_ha_cymmy,[adrec]=@adrec,[naim_del]=@naim_del,[ima]=@ima WHERE[ind]=@ind", sqlConnection);
            command.Parameters.AddWithValue("type_tehiki", textBox58.Text);
            command.Parameters.AddWithValue("data", textBox57.Text);
            command.Parameters.AddWithValue("jakypleho_ha_cymmy", textBox54.Text);
            command.Parameters.AddWithValue("adrec", textBox56.Text);
            command.Parameters.AddWithValue("naim_del", textBox55.Text);
            command.Parameters.AddWithValue("ind", textBox63.Text);
            command.Parameters.AddWithValue("ima", textBox62.Text);
            await command.ExecuteNonQueryAsync();
        }
        private async void button11_Click(object sender, EventArgs e)
        {
            SqlCommand command = new SqlCommand("UPDATE [remont] SET [nomer]=@nomer,[model]=@model,[data]=@data,[voditel]=@voditel,[prichiha]=@prichiha,[vrema_remonta]=@vrema_remonta,[remonty_podlejit]=@remonty_podlejit,[type_tehiki]=@type_tehiki WHERE[ind]=@ind", sqlConnection);
            command.Parameters.AddWithValue("nomer", textBox79.Text);
            command.Parameters.AddWithValue("model", textBox78.Text);
            command.Parameters.AddWithValue("data", textBox75.Text);
            command.Parameters.AddWithValue("voditel", textBox77.Text);
            command.Parameters.AddWithValue("prichiha", textBox76.Text);
            command.Parameters.AddWithValue("vrema_remonta", textBox84.Text);
            command.Parameters.AddWithValue("remonty_podlejit", textBox83.Text);
            command.Parameters.AddWithValue("type_tehiki", textBox80.Text);
            command.Parameters.AddWithValue("ind", textBox82.Text);
            await command.ExecuteNonQueryAsync();
        }
        private async void button14_Click(object sender, EventArgs e)
        {
            SqlCommand command = new SqlCommand("UPDATE [tip_tehiki] SET[type_tehiki]=@type_tehiki,[proizvoditel]=@proizvoditel,[model]=@model,[potracheho_ha_remoht],[ha_remonte]=@ha_remonte WHERE[ind]=@ind)", sqlConnection);
            command.Parameters.AddWithValue("type_tehiki", textBox100.Text);
            command.Parameters.AddWithValue("proizvoditel", textBox99.Text);
            command.Parameters.AddWithValue("model", textBox96.Text);
            command.Parameters.AddWithValue("potracheho_ha_remoht", textBox98.Text);
            command.Parameters.AddWithValue("ha_remonte", textBox97.Text);
            command.Parameters.AddWithValue("ind", textBox105.Text);

            await command.ExecuteNonQueryAsync();
        }

       private void textBox11_TextChanged(object sender, EventArgs e)
        {

        }
        private void textBox12_TextChanged(object sender, EventArgs e)
        {

        }
        private void textBox13_TextChanged(object sender, EventArgs e)
        {

        }
        private async void button3_Click(object sender, EventArgs e)
        {
            SqlCommand command = new SqlCommand("DELETE FROM [detal][nomer][postavhik][remont][tip_tehiki] WHERE [ind]=@ind", sqlConnection);
            command.Parameters.AddWithValue("idto", textBox21.Text);
            await command.ExecuteNonQueryAsync();
        }

        private void label7_Click(object sender, EventArgs e)
        {

        }

        private void label8_Click(object sender, EventArgs e)
        {

        }

        private void tabPage2_Click(object sender, EventArgs e)
        {

        }

        private void label14_Click(object sender, EventArgs e)
        {

        }
    }
}