/// <summary> /// Update the account information area. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dataGridView1_SelectionChanged(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count != 1) { textBoxCharacters.Text = ""; richTextBoxBanReason.Text = ""; return; } string accDir = (string)dataGridView1.SelectedRows[0].Cells[accDirDataGridViewTextBoxColumn.Index].Value; string query = "(AccDir = '" + FLUtility.EscapeEqualsExpressionString(accDir) + "') AND (IsDeleted = 'false')"; DamDataSet.CharacterListRow[] charRecords = (DamDataSet.CharacterListRow[])dataSet.CharacterList.Select(query); string charStr = ""; foreach (DamDataSet.CharacterListRow charRecord in charRecords) { charStr += charRecord.CharName + ", "; } textBoxCharacters.Text = charStr; richTextBoxBanReason.Text = (string)dataGridView1.SelectedRows[0].Cells[banReasonDataGridViewTextBoxColumn.Index].Value; }
/// <summary> /// Update the filter applied to the character list data grid view. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void TimerFilterUpdate(object sender, EventArgs e) { timerFilter.Stop(); string filter = ""; if (textBoxFilter.Text.Length > 2) { string filterText = textBoxFilter.Text; if (filter != "") { filter += " AND "; } filter += "((AccID = '" + FLUtility.EscapeEqualsExpressionString(filterText) + "') " + " OR (AccDir = '" + FLUtility.EscapeLikeExpressionString(filterText) + "') " + " OR (BanReason LIKE '%" + FLUtility.EscapeLikeExpressionString(filterText) + "%'))"; } if (checkBoxShowExpiredBans.Checked) { if (filter != "") { filter += " AND "; } filter += "(BanEnd < #" + String.Format("{0:s}", DateTime.Now.ToUniversalTime()) + "#)"; } banListBindingSource.Filter = filter; }