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