public override DataSet GetReport(ReportFilter filter)
{
DataSet ret = null;
try
{
ret = _LogDatabase.GetReport(filter);
}
catch (Exception exp)
{
_Logger.LogMessage(exp.Message);
}
return ret;
}
public DataSet GetReport(ReportFilter filter)
{
string queryString = string.Empty;
UpdateSelectString(ref queryString, "datetime", filter.DateAndTime, " >= ");
UpdateSelectString(ref queryString, "datetime", filter.ToDateTime, " <= ");
UpdateSelectString(ref queryString, "type", filter.Type);
UpdateSelectString(ref queryString, "computer", filter.ComputerName);
UpdateSelectString(ref queryString, "application", filter.Application);
UpdateSelectString(ref queryString, "description", filter.Description);
UpdateSelectString(ref queryString, "username", filter.UserName);
if (queryString.Length > 0)
{
queryString = " WHERE (" + queryString;
queryString += ")";
}
return base.QueryDatabase(_QuerySelectRowString + queryString);
}
public virtual DataSet GetReport(ReportFilter filter) { return null; }
private DataSet GetFilteredDataSet ()
{
string selectedType = ((ComboBoxItem)TypeSelection.SelectedItem).Content.ToString();
selectedType = (String.IsNullOrWhiteSpace(selectedType)) ? string.Empty : selectedType;
ReportFilter filter = new ReportFilter(selectedType, (DateTime?)ReportdatePickerStart.SelectedDate, (DateTime?)ReportdatePickerEnd.SelectedDate,
ComputerTextBox.Text, ApplicationTextBox.Text, DescriptionTextBox.Text, UserTextBox.Text);
return _logger.GetReport(filter);
}
