public List <resultsModel> get2018PersonalizedRankings(int userID)
{
List <resultsModel> persRank = new List <resultsModel>();
resultsModel rm;
using (SqlCommand cmd = new SqlCommand("get2018PersonalRanking"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@userID", userID);
cmd.Connection = conn;
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
rm = new resultsModel();
rm.book_id = rdr.GetInt32(0);
rm.bookTitle = rdr.GetString(1);
rm.bookAuthor = rdr.GetString(2);
persRank.Add(rm);
}
rdr.Close();
conn.Close();
return(persRank);
}
}
public List <resultsModel> get2018Results()
{
List <resultsModel> results = new List <resultsModel>();
resultsModel rs = null;
using (SqlCommand cmd = new SqlCommand("get2018SortedRanking"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
rs = new resultsModel();
rs.book_id = rdr.GetInt32(0);
rs.totalPoints = rdr.GetInt32(1);
rs.bookTitle = rdr.GetString(2);
rs.bookAuthor = rdr.GetString(3);
results.Add(rs);
}
rdr.Close();
conn.Close();
}
return(results);
}
