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