public List <Review> GetAllReviewsByUserID(int id)
{
string Query = "SELECT TOP(10) [Reviews].ID, [Reviews].Body, [Reviews].Rating, [Reviews].DatePosted, [Users].ID, [Users].Name, [Books].ID, [Books].Title " +
"FROM ([Reviews] " +
"INNER JOIN [Books] ON [Books].ID = [Reviews].BookID " +
"INNER JOIN [Users] ON [Users].ID = [Reviews].UserID) " +
"WHERE [Users].ID = @userid " +
"ORDER BY [Reviews].DatePosted DESC";
List <KeyValuePair <string, string> > Params = new List <KeyValuePair <string, string> >();
Params.Add(new KeyValuePair <string, string>("userid", id.ToString()));
DataSet Results = this.ExecuteSQL(Query, Params);
List <Review> Reviews = new List <Review>();
if (Results != null)
{
for (int i = 0; i < Results.Tables[0].Rows.Count; i++)
{
Review r = DataSetParser.DataSetToReview(Results, i);
Reviews.Add(r);
}
}
return(Reviews);
}
public Review GetReviewByID(int id)
{
string Query = "SELECT [Reviews].ID, [Reviews].Body, [Reviews].Rating, [Reviews].DatePosted," +
"[Users].ID, [Users].Name, [Books].ID, [Books].Title " +
"FROM ([Reviews] INNER JOIN [Users] ON [Reviews].UserID = [Users].ID " +
"INNER JOIN [Books] ON [Books].ID = [Reviews].BookID) " +
"WHERE [Reviews].ID = @reviewId";
List <KeyValuePair <string, string> > Params = new List <KeyValuePair <string, string> >();
Params.Add(new KeyValuePair <string, string>("reviewId", id.ToString()));
DataSet Result = this.ExecuteSQL(Query, Params);
Review R = null;
if (Result != null)
{
R = DataSetParser.DataSetToReview(Result, 0);
}
return(R);
}
public List <Review> GetAllReviews()
{
string Query = "SELECT [Reviews].ID, [Reviews].Body, [Reviews].Rating, [Reviews].DatePosted, " +
"[Books].ID, [Books].Title, [Users].Name FROM " +
"([Reviews] INNER JOIN[Books] ON[Books].ID = [Reviews].BookID " +
"INNER JOIN[Authors] ON[Authors].ID = [Books].AuthorID " +
"INNER JOIN[Users] ON [Users].ID = [Reviews].UserID) " +
"ORDER BY[Reviews].DatePosted DESC";
List <KeyValuePair <string, string> > Params = new List <KeyValuePair <string, string> >();
DataSet Results = this.ExecuteSQL(Query, Params);
List <Review> Reviews = new List <Review>();
if (Results != null)
{
for (int i = 0; i < Results.Tables[0].Rows.Count; i++)
{
Review r = DataSetParser.DataSetToReview(Results, i);
Reviews.Add(r);
}
}
return(Reviews);
}