public UserPost GetUserPost(Guid postId) { var queryString = string.Format("SELECT * FROM [dbo].[UserPosts] WHERE PostId='{0}'", postId); using (SqlConnection sqlConn = DatabaseHelper.GetConnection()) { var reader = SqlHelper.ExecuteReader(sqlConn, CommandType.Text, queryString); while (reader.Read()) { return(UserPost.From(reader)); } } return(null); }
public IList <UserPost> GetUserPosts(Guid userId) { var postList = new List <UserPost>(); var queryString = string.Format(@"SELECT UP.* FROM dbo.UserPosts AS UP WHERE UserId='{0}' UNION SELECT UP.* FROM dbo.UserPosts AS UP INNER JOIN dbo.UserFollowers AS UF ON UP.UserId=UF.FollowerUserId WHERE UF.UserId='{0}' ", userId); using (SqlConnection sqlConn = DatabaseHelper.GetConnection()) { var reader = SqlHelper.ExecuteReader(sqlConn, CommandType.Text, queryString); while (reader.Read()) { postList.Add(UserPost.From(reader)); } } return(postList); }