public List <double> GetExpensesByType(dbExpense Expenses)
{
List <double> List = new List <double>();
List <string> Types = new List <string> {
"Employee salaries", "Office Expenses", "Vehicles Expenses", "Equipment Expenses", "Maintenance Expenses", "Business Insurances", "Consultancy Fees", "Marketing Costs", "Miscellaneous Expenses"
};
Expenses.Connect();
if (Expenses.ConnOpen() == true)
{
foreach (var item in Types)
{
DataTable table = Expenses.SuperQuery($"SELECT SUM(Amount) FROM `tbExpense` WHERE `Type` = '{item}'").Tables[0];
if (string.IsNullOrEmpty(table.Rows[0][0].ToString()))
{
List.Add(0);
}
else
{
List.Add(double.Parse(table.Rows[0][0].ToString()));
}
}
}
Expenses.ConnClose();
return(List);
}
public List <double> GetExpensesByDate(dbExpense Expenses)
{
List <double> List = new List <double>();
Expenses.Connect();
if (Expenses.ConnOpen() == true)
{
for (int i = 1; i <= 6; i++)
{
DataTable table = Expenses.SuperQuery($"SELECT SUM(Amount) FROM `tbExpense` WHERE year(Date) = 2019 AND month(Date) = {i}").Tables[0];
if (string.IsNullOrEmpty(table.Rows[0][0].ToString()))
{
List.Add(0);
}
else
{
List.Add(double.Parse(table.Rows[0][0].ToString()));
}
}
}
Expenses.ConnClose();
return(List);
}