public FileStreamResult ReportSelectAll(ProviderDetailCategories categories) { BaseResponse response; try { IUserAuthData user = _auth.GetCurrentUser(); MemoryStream stream = null; if (user.Roles.Contains("Office Manager") || (user.Roles.Contains("SysAdmin"))) { if (user.Roles.Contains("SysAdmin")) { stream = _service.ReportSelectAll(categories, 0); } else { stream = _service.ReportSelectAll(categories, user.Id); } } if (stream == null) { response = new ErrorResponse("App resource not found."); } else { stream.Position = 0; var contentType = "application/octet-stream"; var fileName = "ProviderReport.xlsx"; return(File(stream, contentType, fileName)); } } catch (Exception ex) { base.Logger.LogError(ex.ToString()); response = new ErrorResponse(ex.Message); } return(null); }