public List <Home> GetTransactionsTypeWise()
{
List <Home> homes = new List <Home>();
string query = "SELECT type, SUM(amount) AS total FROM Journal GROUP BY type";
string name = "";
var journals = conn.Query <Val>(query).ToList <Val>();
foreach (var val in journals)
{
name = journalTypeVM.Get(val.type).name;
homes.Add(new Home()
{
name = name,
amount = int.Parse(val.total.ToString())
});
}
return(homes);
}
public JournalType GetType(int subtype_id)
{
JournalTypeViewModel typeVM = new JournalTypeViewModel();
return(typeVM.Get(subtype_id));
}
