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)); }