public static IList <LeaderboardEntry> RetrieveLocalLeaderboard(int userId, int locality = 2) { var parameters = new List <SqlParameter> { new SqlParameter("userId", userId), new SqlParameter("locality", locality) }; var dataTable = DatabaseCommon.PerformAction("GetLocalLeaderboardInfo", parameters); return(DatabaseCommon.ConvertTable(dataTable, LeaderboardEntry.FromDataRow)); }
public static IList <LeaderboardEntry> RetrieveTopLeaderboard(int rowCount, int?currentUserId = null) { var parameters = new List <SqlParameter> { new SqlParameter("rowCount", rowCount), new SqlParameter("userId", currentUserId) }; var dataTable = DatabaseCommon.PerformAction("GetTopLeaderboardInfo", parameters); return(DatabaseCommon.ConvertTable(dataTable, LeaderboardEntry.FromDataRow)); }
public static IList <Hire> RetrieveAllHires() { var dataTable = DatabaseCommon.PerformAction("GetAllHires", null); return(DatabaseCommon.ConvertTable(dataTable, Hire.FromDataRow)); }