public List <UserRanking> GetUsersCompanyLeaderboard(long?companyId, Leaderboard.Type type,
Leaderboard.TimeSpan timeSpan, int page, int limit)
{
var con = new SqlConnection(Config.ConnectionString);
var cmd = new SqlCommand
{
CommandText = $"get_users_leaderboard_company_{timeSpan}_{type} {companyId}, {limit}, {page}",
Connection = con
};
con.Open();
var ranks = new List <UserRanking>();
try
{
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
ranks.Add(_userRanksMapper.MapFrom(reader));
}
}
}
finally
{
con.Close();
}
return(ranks);
}
public List <CompanyRanking> GetCompaniesLeaderboards(
Leaderboard.Type type,
Leaderboard.TimeSpan timeSpan,
int page,
int limit)
{
throw new NotImplementedException();
}
public Rankings GetCompanyRanks(
long companyId,
Leaderboard.Type type,
Leaderboard.TimeSpan timeSpan,
int page,
int limit)
{
throw new NotImplementedException();
}
public Rankings GetUserRanks(
long userId,
Leaderboard.Type type,
Leaderboard.Range range,
Leaderboard.TimeSpan timeSpan,
int page,
int limit)
{
throw new NotImplementedException();
}
public IHttpActionResult GetUsersLeaderboard(
[FromUri] Leaderboard.Type type = Leaderboard.Type.Shares,
[FromUri] Leaderboard.Range range = Leaderboard.Range.Global,
[FromUri] Leaderboard.TimeSpan timeSpan = Leaderboard.TimeSpan.AllTime,
[FromUri] int?companyId = null,
[FromUri] int page = 1,
[FromUri] int limit = 20)
{
if (!Session.Authorized)
{
return(Unauthorized());
}
var leaderboard = range == Leaderboard.Range.Company
? _leaderboardsRepo.GetUsersCompanyLeaderboard(companyId, type, timeSpan, page, limit)
: _leaderboardsRepo.GetUsersGlobalLeaderboard(type, timeSpan, page, limit);
return(Ok(leaderboard));
}
public IHttpActionResult GetCompaniesLeaderboard(
[FromUri] Leaderboard.Type?type = null,
[FromUri] Leaderboard.Range range = Leaderboard.Range.Global,
[FromUri] Leaderboard.TimeSpan timeSpan = Leaderboard.TimeSpan.AllTime,
[FromUri] int page = 1,
[FromUri] int limit = 20)
{
if (!Session.Authorized)
{
return(Unauthorized());
}
if (type == null)
{
return(BadRequest("Campo Type mancante"));
}
var data = type + " " + range + " " + timeSpan;
return(Ok());
}
