public List <MonthlyStats> GetYTDStats(int?officeId, int?userId, int?groupId)
{
List <MonthlyStats> results = null;
if (officeId != null || userId != null || groupId != null)
{
return(_Map(_db.spYtdStats(officeId, groupId, userId).ToList()));
}
//default behavior
if (_user.IsAdmin())
{
results = _db.Database.SqlQuery <MonthlyStats>("select * from vCompanyYtdStats").ToList();
return(results);
}
else if (_user.IsEmployee() || _user.IsManager())
{
return(_Map(_db.spYtdStats(_user.OfficeId, null, null).ToList()));
}
else
{
return(_Map(_db.spYtdStats(null, null, _user.Id).ToList()));
}
}
