public static List <Revenue> getQuartlyReport() { FinConnections connection = _connection; //var d = DateTime.Today.AddDays(-90); var CommandText = @"SELECT ProductName, ProductRevenue, PurchaseDate FROM Revenue where PurchaseDate >= Date('now', '-90 days') Order by ProductName"; //WHERE PurchaseDate >= + d; connection.execute(CommandText, (SqliteDataReader reader) => { while (reader.Read()) { ListRevenue.Add(new Revenue { ProductName = reader[0].ToString(), ProductRevenue = reader.GetInt32(1), PurchaseDate = DateTime.Parse(reader[2].ToString()), }); } }); return(ListRevenue); }
public static List <Revenue> getCustomerReport() { FinConnections connection = _connection; var CommandText = @"SELECT CustomerFirstName || ' ' || CustomerLastName as Customer, Total(ProductRevenue) as Revenue FROM Revenue Group by Customer"; connection.execute(CommandText, (SqliteDataReader reader) => { while (reader.Read()) { ListRevenue.Add(new Revenue { CustomerFirstName = reader[0].ToString(), ProductRevenue = reader.GetInt32(1), }); } }); return(ListRevenue); }
public static List <Revenue> getProductReport() { FinConnections connection = _connection; var CommandText = @"SELECT ProductName as Product, Total(ProductRevenue) as Revenue FROM Revenue group by ProductName"; connection.execute(CommandText, (SqliteDataReader reader) => { while (reader.Read()) { ListRevenue.Add(new Revenue { ProductName = reader[0].ToString(), ProductRevenue = reader.GetInt32(1), }); } }); return(ListRevenue); }
public static void Main(string[] args) { //DatabaseGenerator gen = new DatabaseGenerator(); //gen.CreateDatabase(); FinConnections db = new FinConnections(); Revenue data = null; bool go_on = true; string stuff = ""; try { db.execute("SELECT Id FROM Revenue WHERE Id = 1000", (SqliteDataReader reader) => { while (reader.Read()) { data = new Revenue { Id = reader.GetInt32(0) }; } }); } catch (Exception ex) { //ADDING ERROR HANDLING Console.WriteLine("Sorry an error has occcured. Please try agin "); Console.WriteLine($"{ex}"); go_on = false; Console.ReadKey(); } while (go_on) { if (stuff == "") { Console.WriteLine(@"Bangazon FinacialReports ============================"); Console.WriteLine("1 - Weekly Report"); Console.WriteLine("2 - Monthly Report"); Console.WriteLine("3 - Quarterly Report(3months)"); Console.WriteLine("4 - Customer Revenue Report"); Console.WriteLine("5 - Product Revenue Report"); Console.Write("> "); } stuff = Console.ReadLine(); if (stuff.ToUpper() == "X") { break; } switch (stuff) { case "1": GetReportAction.GetWeeklyReport(); break; case "2": GetReportAction.GetMonthlyReport(); break; case "3": GetReportAction.GetQuarterlyReport(); break; case "4": GetReportAction.GetCustomerReport(); break; case "5": GetReportAction.GetProductReport(); break; default: Console.Write("> "); Console.WriteLine("To Go To Main Menu Hit Enter Again Please."); stuff = Console.ReadLine(); //Console.WriteLine("You did not enter a valid menu option. Please try again."); break; } } }