private void Initialize(string nameDatBas)
        {
            this.nameDB = nameDatBas;

            readDB = new ReadDB(nameDB, buf);
            write  = new WriteTo_DB(nameDB, buf);

            _DataForInsert = new List <StructDataDeal> ();
            data_ForDB     = new List <StructDataDeal> ();

            TopLineOf_InsertTable();
            TopLineOf_MainTable();


            SetData_ToMainTab(_AllProduct);


            tb_TodeyDate_ForInsert.Text = DateTime.Now.ToString("d");

            List <string> ParametrsForSearchList = new List <string> ();

            ParametrsForSearchList.Add("По Номеру");
            ParametrsForSearchList.Add("По Названию");

            Set_ListOfSearchParams(ParametrsForSearchList);
        }
        private void Initialize(List <StructOfProduct> _ProductsList)
        {
            write = new WriteTo_DB(nameDB, buf);
            read  = new ReadDB(nameDB, buf);

            Clear_CurrentData();
            GetDataFromDB(_ProductsList);
            TopLineOfTable();

            TopLineOfDelteTab();
        }
        //ACTIONS

        protected void OnBnAddItemClicked(object sender, EventArgs e)
        {
            Validation validation = new Validation();

            if (!validation.IsEmpty(tb_CodeProduct.Text) && !validation.IsEmpty(tb_CodeProduct.Text) && !validation.IsEmpty(tb_Producer.Text) &&
                !validation.IsEmpty(tb_TypeCounting.Text) && !validation.IsEmpty(tb_PriceForOne.Text) && !validation.IsEmpty(tb_ParametrProduct.Text) &&
                !validation.IsEmpty(tb_ParametrValue.Text))
            {
                if (!validation.ExistInList(_ExistProduct, tb_CodeProduct.Text))
                {
                    WriteTo_DB writer = new WriteTo_DB(nameDB, buf);

                    StructOfProduct product = new StructOfProduct();

                    product.Number        = tb_CodeProduct.Text;
                    product.Name          = tb_NameProduct.Text;
                    product.Id_producer   = writer.Get_Or_Set_IdOfProducer(tb_Producer.Text);
                    product.Id_typeCount  = writer.Get_Or_Set_IdOfTypeCount(tb_TypeCounting.Text);
                    product.Parametr      = tb_ParametrProduct.Text;
                    product.ValueParametr = tb_ParametrValue.Text;
                    product.PriceForOne   = tb_PriceForOne.Text;

                    if (writer.Write_newProduct(product))
                    {
                        MessageBox.Show("Товар успешно добавлен");
                    }
                    else
                    {
                        MessageBox.Show("повторите попытку");
                    }
                }
                else
                {
                    MessageBox.Show("Товар с таким номером уже есть");
                }
            }
            else
            {
                MessageBox.Show("Не все поля заполнены. Заполните и повторите попытку");
            }
        }