public Task <ApplicationUser> FindByIdAsync(string userId) { List <ApplicationUser> result = userTable.GetUserByID(userId); if (result != null && result.Count > 0) { return(Task.FromResult <ApplicationUser>(result[0])); } return(Task.FromResult <ApplicationUser>(null)); }
public Stack <Comment> GetComments(string postID) { Stack <Comment> comments = new Stack <Comment>(); Queue <Comment> queue = new Queue <Comment>(); string commandText = "SELECT * FROM Comments WHERE PostID = '" + postID + "'"; SqlDataReader reader = database.ExecuteReader(commandText, null); UserTable userTable = new UserTable(database); while (reader.Read()) { string author = reader["AuthorID"].ToString(); string text = reader["Text"].ToString(); string date = reader["Date"].ToString(); Comment comment = new Comment() { Author = author, Text = text, Date = date }; queue.Enqueue(comment); } reader.Close(); database.CloseConnection(); while (queue.Count > 0) { Comment comment = queue.Dequeue(); comment.Author = userTable.GetUserByID(comment.Author)[0].UserName; comments.Push(comment); } return(comments); }