private static void SetDateColumn(string colName, DateTime value)
{
user u = new user();
u.ExecuteNonQuery("UPDATE system_options SET " + colName + " = '" + CommonFunctions.ToMySQLDate(value) + "'");
}
/// <summary>
/// Doesn't work if the form is in loading mode
/// </summary>
private void Search()
{
if (_loading == false)
{
string SQL = "SELECT * FROM user_action_log WHERE ";
user_action_log ual = new user_action_log();
if (cmbUsers.SelectedIndex > 0)
{
SQL += "user_id = " + ((user)cmbUsers.SelectedItem).id;
}
else
{
SQL += "1 = 1";
}
if (chkSearchDateRange.Checked)
{
SQL += " AND action_taken_time > '" + CommonFunctions.ToMySQLDate(dtpStartDate.Value) +
"' AND action_taken_time < '" + CommonFunctions.ToMySQLDate(dtpEndDate.Value.AddDays(1)) + "'";
}
if (!chkShowLogins.Checked)
{
SQL += " AND action_id NOT IN(" + (int)ActiveUser.ActionTypes.Login + "," +
(int)ActiveUser.ActionTypes.Logout + ")";
}
SQL += " ORDER BY order_id desc";
DataTable matches = ual.Search(SQL);
dgvMain.Rows.Clear();
foreach (DataRow anAction in matches.Rows)
{
ual = new user_action_log();
ual.Load(anAction);
object[] toAdd;
if (((ActiveUser.ActionTypes)ual.action_id == ActiveUser.ActionTypes.ViewClaim) ||
((ActiveUser.ActionTypes)ual.action_id == ActiveUser.ActionTypes.ResendClaim) ||
((ActiveUser.ActionTypes)ual.action_id == ActiveUser.ActionTypes.SubmitClaim) ||
((ActiveUser.ActionTypes)ual.action_id == ActiveUser.ActionTypes.ReviewClaim))
{
toAdd = new object[] { ual.LinkedUser.username, ual.action_taken_time.ToString("MM-dd-yy HH:mm"), ((ActiveUser.ActionTypes)ual.action_id).ToString(),
ual.additional_notes, "Claim" };
}
else if ((ActiveUser.ActionTypes)ual.action_id == ActiveUser.ActionTypes.StartCall)
{
toAdd = new object[] { ual.LinkedUser.username, ual.action_taken_time.ToString("MM-dd-yy HH:mm"), ((ActiveUser.ActionTypes)ual.action_id).ToString(),
ual.additional_notes, "Call" };
}
else
{
toAdd = new object[] { ual.LinkedUser.username, ual.action_taken_time.ToString("MM-dd-yy HH:mm"), ((ActiveUser.ActionTypes)ual.action_id).ToString(),
ual.additional_notes, "" };
}
dgvMain.Rows.Add(toAdd);
dgvMain.Rows[dgvMain.Rows.Count - 1].Tag = ual;
}
}
}
