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"); } }