static void Main(string[] args)
{
TableHandler tableHandler = new TableHandler();
DataTable newTable = tableHandler.CreateTable("AAA");
newTable.Rows.Add();
newTable.Rows.Add();
newTable.Rows[0]["Jahr"] = 2020;
newTable.Rows[1]["Jahr"] = 2009;
Console.WriteLine("Tabelle vorher:");
PrintTable(newTable);
tableHandler.AddRow(ref newTable);
tableHandler.AddRow(ref newTable);
tableHandler.AddRow(ref newTable);
Console.WriteLine("Tabelle sortiert:");
newTable.DefaultView.Sort = "Jahr Asc";
newTable = newTable.DefaultView.ToTable();
PrintTable(newTable);
Console.WriteLine("\nTabelle speichern.\n");
tableHandler.SaveTable(newTable);
Console.WriteLine("\nTabelle ausgeben.\n");
var tableList = tableHandler.GetTableNames();
PrintTableList(tableList);
Console.WriteLine("AAA");
PrintTable(tableHandler.LoadDataTable("AAA"));
Console.WriteLine("\nZeile löschen.\n");
tableHandler.DeleteRow(newTable, 2020);
Console.WriteLine("\nTabelle speichern.\n");
tableHandler.SaveTable(newTable);
Console.WriteLine("\nTabelle ausgeben.\n");
PrintTable(tableHandler.LoadDataTable("AAA"));
Console.WriteLine("\nTabelle wieder löschen.\n");
tableHandler.DeleteTable(newTable);
tableList = tableHandler.GetTableNames();
PrintTableList(tableList);
}
public async Task <string> CheckCurrentQuarterAsync()
{
Quarter currentQuarter = GetCurrentQuarter();
String currentQuarterCode = currentQuarter.quarter;
Console.WriteLine("Current Quarter Code: '{0}', Title: {1}", currentQuarterCode, currentQuarter.title);
AmazonDynamoDBClient dynamodbClient = createDynamoDBClient();
TableHandlerQuarter tableHandlerQuarter = new TableHandlerQuarter(quarterTableName);
bool quarterExist = await tableHandlerQuarter.IsItemInTable(currentQuarter);
Console.WriteLine("Quarter Exists: {0}", quarterExist);
if (quarterExist) // do nothing
{
return(currentQuarter.title + " quarter up to date.");
}
else // update table
{
TableHandler <Classtime> tableClasstime = new TableHandler <Classtime>(classtimeTableName, new ItemConverterClasstime());
bool tableExists = await tableClasstime.DoesTableExist();
if (tableExists)
{
await tableClasstime.EmptyTable();
}
else
{
await tableClasstime.CreateTable();
}
await BCAPIHandler.StoreAllClasstimesAsync(tableClasstime);
await tableHandlerQuarter.AddItemAsync(currentQuarter);
Console.WriteLine("{0} Updated", currentQuarter.quarter);
return(currentQuarterCode + " Updated");
}
}
