private void BtnFilter_Click(object sender, EventArgs e)
        {
            BLClient bl = new BLClient();

            this.total_row  = bl.BLGetTotalRow(txtName.Text, txtSurName.Text, txtClientCode.Text);
            this.total_page = (this.total_row / this.take_page) + 1;
            this.final_page = this.total_row % this.take_page;
            dataPartners.Rows.Clear();
            this.currentpage = 1;
            this.skip_page   = 0;
            PaginationDataGridView();
        }
        private void PartnersForm_Load(object sender, EventArgs e)
        {
            dataPartners.Columns.Add("clientId", "clientId");
            dataPartners.Columns.Add("clientName", "Nume");
            dataPartners.Columns.Add("clientSurname", "Prenume");
            dataPartners.Columns.Add("clientCode", "Cod Client");
            dataPartners.Columns.Add("phoneNo", "Telefon");
            dataPartners.Columns.Add("clientEmail", "Email");
            dataPartners.AutoGenerateColumns = false;
            dataPartners.Columns[0].Visible  = false;
            BLClient bl = new BLClient();

            this.total_row  = bl.BLGetTotalRow("", "", "");
            this.total_page = (this.total_row / this.take_page) + 1;
            this.final_page = this.total_row % this.take_page;
            PaginationDataGridView();
        }