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