Разработка информационной системы «Автопарковка» с использованием клиент-серверной технологи

            textBox15.Text = "";

            textBox16.Text = "";

            textBox17.Text = "";

            textBox18.Text = "";

            textBox19.Text = "";

            textBox20.Text = "";

            textBox21.Text = "";

            textBox22.Text = "";

        } 

        private void button8_Click(object sender, EventArgs e)

        {

            //Показать все записи таблицы

            tRANSPORTBindingSource.Filter = "";

        } 

        private void button21_Click(object sender, EventArgs e)

        {

            //Поиск записи

            mESTOPARKINGBindingSource.Filter = "CLASS like '" + textBox32.Text + "%'"; 

        } 

        private void button18_Click(object sender, EventArgs e)

        {

            //Удаление записи

            mESTOPARKINGBindingSource.Filter = "";

            OleDbConnection con = new OleDbConnection

           ("Provider=LCPI.IBProvider.3; Data Source=localhost:T:\\home\\localhost\\G140705_SAFONOVA.FDB; Persist Security Info=True;Password=masterkey;User ID=sysdba; ctype=WIN1251;auto_commit=True");

            con.Open();

            OleDbTransaction trans = con.BeginTransaction();

            OleDbCommand com = new OleDbCommand("EXECUTE PROCEDURE DEL_MESTO(:rn)", con, trans);

            com.Parameters.Add("rn", OleDbType.Char);

            com.Parameters["rn"].Value = textBox24.Text;

            trans.Commit();

            com.ExecuteScalar();

            this.mESTO_PARKINGTableAdapter.Fill(this.dataSet1.MESTO_PARKING);

            con.Close();

            textBox24.Text = ""; 

        } 

        private void button20_Click(object sender, EventArgs e)

        {

            //Добавление записи

            mESTOPARKINGBindingSource.Filter = "";

            OleDbConnection con = new OleDbConnection

           ("Provider=LCPI.IBProvider.3; Data Source=localhost:T:\\home\\localhost\\G140705_SAFONOVA.FDB; Persist Security Info=True;Password=masterkey;User ID=sysdba; ctype=WIN1251;auto_commit=True");

            con.Open();

            OleDbTransaction trans = con.BeginTransaction();

            OleDbCommand com = new OleDbCommand("EXECUTE PROCEDURE INS_MESTO_PARKING (:CLASS)", con, trans);

            com.Parameters.Add("CLASS", OleDbType.Char);

            com.Parameters["CLASS"].Value = textBox31.Text;

            trans.Commit();

            com.ExecuteScalar();

            this.mESTO_PARKINGTableAdapter.Fill(this.dataSet1.MESTO_PARKING);

            con.Close();

            textBox3.Text = ""; 

        } 

        private void button15_Click(object sender, EventArgs e)

        {

            //Показать все записи таблицы

            mESTOPARKINGBindingSource.Filter = "";

        } 

        private void button16_Click(object sender, EventArgs e)

        {

            //Очистка всех полей

            textBox24.Text = "";

            textBox23.Text = "";

            textBox25.Text = "";

            textBox28.Text = "";

            textBox31.Text = "";

            textBox32.Text = ""; 

        } 

        private void button17_Click(object sender, EventArgs e)

        {

            //Фильтрация записи

                if (radioButton3.Checked == true)

                mESTOPARKINGBindingSource.Filter = "CLASS like '%" + textBox23.Text + "%'"; 

        } 

        private void button19_Click(object sender, EventArgs e)

        {

            //Изменение записи

            mESTOPARKINGBindingSource.Filter = "";

            OleDbConnection con = new OleDbConnection

           ("Provider=LCPI.IBProvider.3; Data Source=localhost:T:\\home\\localhost\\G140705_SAFONOVA.FDB; Persist Security Info=True;Password=masterkey;User ID=sysdba; ctype=WIN1251;auto_commit=True");

            con.Open();

            OleDbTransaction trans = con.BeginTransaction();

            OleDbCommand com = new OleDbCommand("EXECUTE PROCEDURE UPD_MESTO_PARKING (:rn, :CLASS)", con, trans);

            com.Parameters.Add("rn", OleDbType.Char);

            com.Parameters["rn"].Value = textBox25.Text;

            com.Parameters.Add("CLASS", OleDbType.Char);

            com.Parameters["CLASS"].Value = textBox28.Text;

            trans.Commit();

            com.ExecuteScalar();

            this.mESTO_PARKINGTableAdapter.Fill(this.dataSet1.MESTO_PARKING);

            con.Close();

            textBox25.Text = "";

            textBox28.Text = ""; 

        } 

        private void button49_Click(object sender, EventArgs e)

        {

            //Поиск записи

            eMPLOYERSBindingSource.Filter = "SURNAME like '" + textBox70.Text + "%'";

        } 

        private void button46_Click(object sender, EventArgs e)

        {

            //Удаление записи

            eMPLOYERSBindingSource.Filter = "";

            OleDbConnection con = new OleDbConnection

           ("Provider=LCPI.IBProvider.3; Data Source=localhost:T:\\home\\localhost\\G140705_SAFONOVA.FDB; Persist Security Info=True;Password=masterkey;User ID=sysdba; ctype=WIN1251;auto_commit=True");

            con.Open();

            OleDbTransaction trans = con.BeginTransaction();

            OleDbCommand com = new OleDbCommand("EXECUTE PROCEDURE DEL_EMPLOYERS(:rn)", con, trans);

            com.Parameters.Add("rn", OleDbType.Char);

            com.Parameters["rn"].Value = textBox60.Text;

            trans.Commit();