// Sök de senaste loggar från en viss hyresgäst, returnera en DataTable public static void FindEntriesByTenant() { Console.Clear(); Console.WriteLine("Entries by tenant\n"); Console.WriteLine("Enter a tenant to search for:\n"); string input = Console.ReadLine(); string sql = SQLStrings.sqlBase + SQLStrings.byTenant + SQLStrings.orderBy; var data = Database.GetDataTable(sql, "@input", input); Database.PrintData(data); ConsoleMenu.Menu(); }
// Söker hyresgäster från specifik lägenhet, returnera en DataTable med deras namn och tagg-kod public static void ListTenanatsAt() { Console.Clear(); Console.WriteLine("List tenants at\n"); Console.WriteLine("Enter an apartment to search for:\n"); string input = Console.ReadLine(); string sql = SQLStrings.sqlBase + SQLStrings.tenantsAt; var data = Database.GetDataTable(sql, "@input", input); Database.PrintData2(data); ConsoleMenu.Menu(); }
// Sök de senaste loggar från en viss lägenhet/rum, returnera en DataTable public static void FindEntriesByLocation() { Console.Clear(); Console.WriteLine("Entries by location\n"); Console.WriteLine("Enter a location to search for:"); Console.WriteLine("Entrance/Garbage/Laundry/Janitor or Apartmentnumber\n"); string input = Console.ReadLine(); string sql = SQLStrings.sqlBase + SQLStrings.byLocation + SQLStrings.orderBy; var data = Database.GetDataTable(sql, "@input", input); Database.PrintData(data); ConsoleMenu.Menu(); }
// Sök de senaste loggar med given kod, returnera en DataTable public static void FindEntriesByEvent() { Console.Clear(); Console.WriteLine("Entries by event\n"); Console.WriteLine("Enter a codeID to search for:"); Console.WriteLine("\n DI, DO, WDI, WDO"); string input = Console.ReadLine(); string sql = SQLStrings.sqlBase + SQLStrings.byCode + SQLStrings.orderBy; var data = Database.GetDataTable(sql, "@input", input); Database.PrintData(data); ConsoleMenu.Menu(); }
// Sök de senaste loggar från en viss dörr, returnera en DataTable public static void FindEntriesByDoor() { Console.Clear(); Console.WriteLine("Entries by door\n"); Console.WriteLine("Enter a door to search for:"); Console.WriteLine("Entrance/Garbage/Laundry/Janitor or XXXXLGH / XXXXBLK where XXXX = Appartmentnumber"); string input = Console.ReadLine(); string sql = SQLStrings.sqlBase + SQLStrings.byDoor + SQLStrings.orderBy; var data = Database.GetDataTable(sql, "@input", input); Database.PrintData(data); ConsoleMenu.Menu(); }
// Informationen skickas in i textform och sparas i lämplig form och i lämpliga tabeller i databasen, returnerar inget public static void LogEntry() { Console.Clear(); Console.WriteLine("Log Entry"); Console.WriteLine("Enter Tag, Action, Door, Code "); Console.WriteLine("E.g. 0101A, Opened, Entrance, DI\n"); var input = Console.ReadLine(); var split = InputHandler.HandleInput(input); var Tag = split[0].Trim(); var Action = split[1].Trim(); var Door = split[2].Trim(); var Code = split[3].Trim(); InputHandler.InsertEntry(Tag, Action, Door, Code); Console.WriteLine("Entry added. Press any key to continue"); Console.ReadKey(); ConsoleMenu.Menu(); }
static void Main(string[] args) { Database.CreateDatabase(); ConsoleMenu.WelcomeGraphic(); ConsoleMenu.Menu(); }