public IEnumerable <AverageMonthsSalary> GetAverageMonthsSalary()
{
var obj = _repository.ExecuteSql(@"
select sum(Salary.amount) / count(distinct employee_id) as Amount,
EXTRACT(MONTH from fromDate) as MonthNumber,
EXTRACT(YEAR from fromDate) as Year
from Salary
group by EXTRACT(MONTH from fromDate), EXTRACT(YEAR from fromDate)
order by Year, MonthNumber;");
return(obj.Select(x => new AverageMonthsSalary
{
Amount = x.Amount,
MonthName = CultureInfo.InvariantCulture.DateTimeFormat.GetMonthName((int)x.MonthNumber),
Year = x.Year
}).ToList());
}
