private void SearchClient()
{
DAL dal = new DAL();
ClientCollection.Clear();
DataTable dt = dal.Read("Select * from bit_client , bit_user_logon where bit_user_logon.account_Type='CLIENT' AND bit_user_logon.account_Ref= bit_client.client_Id and (STATUS='ACTIVE' OR STATUS IS NULL) and " + SelectedClientCols + " like '%" + ClientSearchString + "%'");
int i = 0;
int index = 0;
Client clientFirstRecord = new Client();
foreach (DataRow dr in dt.Rows)
{
index = i;
if (index == 0)
{
clientFirstRecord = new Client(dr);
}
Client client = new Client(dr);
ClientCollection.Add(client);
i++;
}
SelectedClient = clientFirstRecord;
// MessageBox.Show(SelectedClientCols + ClientSearchString);
}
/// <summary>
/// Perform any teardown work required to disconnect
/// </summary>
public virtual void Disconnect()
{
if (_disconnected)
{
return;
}
_disconnected = true;
_clients.Clear();
Log.Info("Disconnected");
}
