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;
}
}
}
public void DatabasePathSet()
{
FinConnections connection = new FinConnections();
Assert.True(connection.connectionString.Contains(".db"));
}
