public List <Entities.User> GetUsers() { var reader = Db.GetDataReader("GetUsers"); var users = new List <User>(); while (reader.Read()) { var user = new User(); user.Id = (int)reader["c_id"]; user.Name = (string)reader["c_name"]; users.Add(user); } return(users); }
public IEnumerable <Entities.Post> GetPosts() { var um = new UserMapper(); var reader = Db.GetDataReader("GetAllPosts"); var posts = new List <Post>(); while (reader.Read()) { var post = new Post(); var id = (int)reader["authorId"]; post.Text = (string)reader["text"]; post.Title = (string)reader["title"]; post.Id = (int)reader["id"]; post.Author = um.GetUserById(id); posts.Add(post); } return(posts); }
public Entities.User LogIn(User logInUser) { var parameters = new List <DbParameter>(); parameters.Add(Db.GetParameter("userName", logInUser.Name)); parameters.Add(Db.GetParameter("password", logInUser.Password)); var reader = Db.GetDataReader("logIn", parameters); if (reader.Read()) { var user = new User(); user.Id = (int)reader["c_id"]; return(user); } else { return(null); } }
public IEnumerable <Comment> GetPostComments(int postId) { var um = new UserMapper(); var reader = Db.GetDataReader("GetPostComments", Db.GetParameter("id", postId)); var comments = new List <Comment>(); while (reader.Read()) { var comment = new Comment(); comment.Text = (string)reader["text"]; var authorId = (int)reader["authorId"]; comment.CreateDate = (DateTime)reader["createDate"]; comment.Author = um.GetUserById(authorId); comments.Add(comment); } return(comments); }