public BindingList <ClientModel> GetClientBi(string ClientName, string ClientSurname, string ClientCode, int?ClientId, int?skip_page, int?take_page)
        {
            DAClient  dac = new DAClient();
            DataTable dt  = new DataTable();

            dt = dac.GetClients(ClientName, ClientSurname, ClientCode, ClientId, skip_page, take_page);

            BindingList <ClientModel> list = new BindingList <ClientModel>();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                ClientModel client = new ClientModel();
                client.ClientId      = Convert.ToInt32(dt.Rows[i]["ClientId"].ToString());
                client.ClientName    = dt.Rows[i]["ClientName"].ToString();
                client.ClientSurname = dt.Rows[i]["ClientSurname"].ToString();
                client.ClientCode    = dt.Rows[i]["ClientCode"].ToString();
                client.PhoneNo       = dt.Rows[i]["PhoneNo"].ToString();
                client.Email         = dt.Rows[i]["Email"].ToString();

                list.Add(client);
            }

            return(list);
        }