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