Esempio n. 1
0
        public override DataSet GetReport(ReportFilter filter)
        {
            DataSet ret = null;

            try
            {
                ret = _LogDatabase.GetReport(filter);
            }
            catch (Exception exp)
            {
                _Logger.LogMessage(exp.Message);
            }

            return ret;
        }
Esempio n. 2
0
        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);
        }
Esempio n. 3
0
 public virtual DataSet GetReport(ReportFilter filter) { return null; }
Esempio n. 4
0
        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);
        }