/// <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;
}