public List<DataSelectorEntry> LoadLastModified(DateTime Threshold)
{
List<DataSelectorEntry> Result = new List<DataSelectorEntry>();
List<TableDefinition> TableDefinitionsToProcess = new List<TableDefinition>();
TableDefinitionsToProcess = TableDefinitions.Collection.Where(sel =>
(sel.Type == "StandBildTV" || sel.Type == "Banner")
&& sel.FormattingTemplate != "DefaultGallerie"
&& sel.TableName != "AEAGWellness"
& sel.TableName != "AEAGSport").ToList();
List<String> SelectedStatementsForRefresh = new List<string>();
foreach (TableDefinition tableDefinition in TableDefinitionsToProcess)
{
String Entry = $"select * from {tableDefinition.TableName} where ModifyTimeStamp > " +
$"{SqlHelpers.GetSQLFormattedDateTime(Threshold)} " +
$"order by ModifyTimeStamp desc";
SelectedStatementsForRefresh.Add(Entry);
}
DownloadTables(String.Join(";", SelectedStatementsForRefresh));
foreach (TableDefinition tableDefinition in TableDefinitionsToProcess)
{
CsDbTableBase targetTable = GetTableByName(tableDefinition.TableName);
DataRow[] rowEntries = targetTable.Select($"ModifyTimeStamp > " +
$"'{Threshold.ToString("yyyy-MM-dd HH:mm:ss")}'");
foreach (DataRow rowEntry in rowEntries)
{
DataSelectorEntry NewEntry = new DataSelectorEntry();
NewEntry.Id = (Guid) rowEntry["Id"];
NewEntry.NameId = rowEntry["NameId"].ToString().Trim();
if (targetTable.Columns.Contains("Titel"))
NewEntry.Titel = rowEntry["Titel"].ToString().Trim();
else
if (targetTable.Columns.Contains("Text"))
NewEntry.Titel = rowEntry["Text"].ToString().Trim();
NewEntry.SelectionDateTime = Convert.ToDateTime(rowEntry["ModifyTimeStamp"]);
NewEntry.SelectionDataRow = rowEntry;
NewEntry.SelectionDataTable = targetTable;
NewEntry.SelectionDataSet = this;
NewEntry.SelectionDataType = rowEntry.GetType();
NewEntry.BackGroundBrush = "LightGreen";
Result.Add(NewEntry);
}
}
return Result;
}
public List<DataSelectorEntry> LoadDataSelectorEntries(DateTime Threshold)
{
List<DataSelectorEntry> Result = new List<DataSelectorEntry>();
List<String> SelectedStatementsForRefresh = new List<string>();
List<String> TableNamesToProcess = new List<string>();
SelectedStatementsForRefresh.Add($"select * from {InformationenTable.NativeName} where " +
$"{InformationenTable.ModifyTimeStampCol} > " +
$"{SqlHelpers.GetSQLFormattedDateTime(Threshold)} " +
$"order by {InformationenTable.ModifyTimeStampCol} desc");
TableNamesToProcess.Add($"{InformationenTable.NativeName}");
DownloadTables(String.Join(";", SelectedStatementsForRefresh));
foreach (String tableName in TableNamesToProcess)
{
CsDbTableBase targetTable = GetTableByName(tableName);
DataRow[] rowEntries = targetTable.Select($"ModifyTimeStamp > " +
$"'{Threshold.ToString("yyyy-MM-dd HH:mm:ss")}'");
foreach (DataRow rowEntry in rowEntries)
{
DataSelectorEntry NewEntry = new DataSelectorEntry();
NewEntry.Id = (Guid)rowEntry["Id"];
NewEntry.NameId = rowEntry["NameId"].ToString();
NewEntry.Titel = rowEntry["Titel"].ToString();
NewEntry.SelectionDateTime = Convert.ToDateTime(rowEntry["ModifyTimeStamp"]);
NewEntry.SelectionDataRow = rowEntry;
NewEntry.SelectionDataTable = targetTable;
NewEntry.SelectionDataSet = this;
NewEntry.SelectionDataType = rowEntry.GetType();
NewEntry.BackGroundBrush = "LightBlue";
Result.Add(NewEntry);
}
}
return Result;
}
