static void OrderHistoryMenu() { string choice; do { Console.WriteLine("\n\t\tMenu:"); Console.WriteLine(" "); Console.WriteLine("\t\t1: History Log"); Console.WriteLine("\t\t2: Check Daily Profit"); Console.WriteLine("\t\t3: Check Profit By Intervalls"); Console.WriteLine("\t\t0: Exit\n"); Console.Write("\t\tEnter your choice: "); choice = Console.ReadLine(); Console.Clear(); switch (choice) { case "1": Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("ID\tChecked IN\t\tChecked Out\t\tPrice\t Licenseplate\t"); Console.ForegroundColor = ConsoleColor.White; List <OrderHistory> logg = databaseSQL.GetOrderHistoryLog(); foreach (var orderhistory in logg) { Console.WriteLine("{0}\t{1}\t{2}\t{3}\t\t{4}", orderhistory.ID, orderhistory.CheckedIn, orderhistory.CheckedOut, orderhistory.Price, orderhistory.License); } logg.Clear(); break; case "2": Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("Date\t\tIncome\t\tAvarage CashFlow each Vehicle"); Console.ForegroundColor = ConsoleColor.White; List <OrderHistory> orders = databaseSQL.DailyIncomeReports(); foreach (var order in orders) { Console.WriteLine("{0}\t{1}\t\t{2}", order.Description, order.Price, order.Avarage); } orders.Clear(); break; case "3": Console.WriteLine("Enter a Start Date:"); Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("Reminder: Please INPUT DATE (YYYY-MM-DD)"); Console.ForegroundColor = ConsoleColor.White; string startDate = Console.ReadLine(); Console.WriteLine("Enter a End Date:"); Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("Reminder: Please INPUT DATE (YYYY-MM-DD)"); Console.ForegroundColor = ConsoleColor.White; string endDate = Console.ReadLine(); List <OrderHistory> intervallHistorys = databaseSQL.GetOrderHistoryDataFromIntervalls(startDate, endDate); Console.WriteLine($"\nIncome Report From {startDate} TO {endDate}"); Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("Total Income\tAvarage Cash Flow On Vehicle\t\tAvarage Cash Flow Daily"); foreach (var historys in intervallHistorys) { Console.WriteLine($"{historys.Price}\t\t{historys.Avarage}\t\t\t\t{historys.DailyCashFlow}"); } Console.ForegroundColor = ConsoleColor.White; break; case "0": break; } } while (choice != "0"); }