public Classes.Review GetBusinessFriendReviews(String friendID)
{
if (newUser != null)
{
List <Classes.Review> reviewList = new List <Classes.Review>();
query = new Dictionary <string, List <string> >();
query.Add(sq.SQL_PROJECT, new List <string>()
{
sq.SQL_SELECT, c.R_date, c.R_reviewStars,
c.R_text, c.R_funny, c.R_useful, c.R_cool, c.R_user
});
query.Add(sq.SQL_FROM, new List <string>()
{
sq.SQL_FROM, c.R_table
});
query.Add(sq.SQL_WHERE, new List <string>()
{
c.B_id, c.U_id
});
query.Add(sq.SQL_COND, new List <string>()
{
newBusiness.business_id, friendID
});
query.Add(sq.SQL_ORDER, new List <string>()
{
sq.SQL_ORDER, sq.SQL_DESC, c.R_date
});
List <Object[]> newObject = newQuery.SQLSelectQuery(query);
foreach (Object[] review in newObject)
{
if (review != null)
{
Classes.Review newReview = new Classes.Review()
{
review_date = review[0].ToString(),
review_stars = Int32.Parse(review[1].ToString()),
review_text = review[2].ToString(),
funny_vote = Int32.Parse(review[3].ToString()),
useful_vote = Int32.Parse(review[4].ToString()),
cool_vote = Int32.Parse(review[5].ToString()),
review_username = GetUserDetails(review[6].ToString()).username,
actual_review_date = review[0].ToString()
};
return(newReview);
}
}
}
return(null);
}
public List <Classes.Review> GetBusinessReviews(Classes.Business business)
{
List <Classes.Review> reviewList = new List <Classes.Review>();
query = new Dictionary <string, List <string> >();
query.Add(sq.SQL_PROJECT, new List <string>()
{
sq.SQL_SELECT, c.R_date, c.R_reviewStars,
c.R_text, c.R_funny, c.R_useful, c.R_cool, c.R_user
});
query.Add(sq.SQL_FROM, new List <string>()
{
sq.SQL_FROM, c.R_table
});
query.Add(sq.SQL_WHERE, new List <string>()
{
c.B_id
});
query.Add(sq.SQL_COND, new List <string>()
{
business.business_id
});
query.Add(sq.SQL_ORDER, new List <string>()
{
sq.SQL_ORDER, sq.SQL_DESC, c.R_date
});
List <Object[]> newObject = newQuery.SQLSelectQuery(query);
foreach (Object[] review in newObject)
{
Classes.Review newReview = new Classes.Review()
{
review_date = DateTime.Parse(review[0].ToString()).ToString("d"),
review_stars = Int32.Parse(review[1].ToString()),
review_text = review[2].ToString(),
funny_vote = Int32.Parse(review[3].ToString()),
useful_vote = Int32.Parse(review[4].ToString()),
cool_vote = Int32.Parse(review[5].ToString()),
review_username = GetUserDetails(review[6].ToString()).username
};
reviewList.Add(newReview);
}
return(reviewList);
}