public List<SavedReport> GetCustomReports()
{
List<SavedReport> list = new List<SavedReport>();
OleDbConnection connection = new OleDbConnection(DatabaseData.Instance.AccessConnectionString);
using (connection)
{
connection.Open();
try
{
OleDbCommand command = new OleDbCommand(@"Select ID, DisplayName, ReportOptions, aspnet_users.UserName, UpdatedAt, CreatedAt, c.UserName as CreatedBy from
((CustomReports INNER JOIN aspnet_users on CustomReports.UpdatedById = aspnet_users.userid)
INNER JOIN aspnet_users c on CustomReports.CreatedById = c.userid)
WHERE IsDeleted=0", connection);
using (OleDbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
var report = new SavedReport
{
Id = reader.GetValueOrDefault<int>("ID"),
DisplayName = reader.GetValueOrDefault<string>("DisplayName"),
UpdatedBy = GetAuditInfo(reader)
};
report.Deserialize(reader.GetValueOrDefault<string>("ReportOptions"));
list.Add(report);
}
reader.Close();
}
}
catch (Exception)
{
throw;
}
}
return list;
}
