public IEnumerable<Monthly> GetMonthlys(string start, string end)
{
string sql = @"SELECT NEWID() ID, DATENAME(YEAR, DATE) + '-' + DATENAME(MONTH, DATE) MONTH, SUM(COST) COST
FROM DAILY
WHERE DATENAME(YEAR, DATE) + '-' + DATENAME(MONTH, DATE) BETWEEN @START AND @END
GROUP BY DATENAME(YEAR, DATE) + '-' + DATENAME(MONTH, DATE)
ORDER BY DATENAME(YEAR, DATE) + '-' + DATENAME(MONTH, DATE) ASC";
Dictionary<string, object> parameters = new Dictionary<string, object>();
parameters.Add("START", start);
parameters.Add("END", end);
return _database.GetList<Monthly>(sql, parameters);
}