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