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"); }