public void Subscribe(int authorId, int subscriberId)
{
var parameters = new List <DbParameter>();
parameters.Add(Db.GetParameter("authorId", authorId));
parameters.Add(Db.GetParameter("subscriberId", subscriberId));
var res = Db.ExecuteNonQuery("Subscribe", parameters);
}
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 Post GetPostById(int id)
{
var cm = new CommentMapper();
var um = new UserMapper();
var reader = Db.GetDataReader("GetPostById", Db.GetParameter("id", id));
var post = new Post();
while (reader.Read())
{
post.Id = (int)reader["id"];
post.Title = (string)reader["title"];
post.Text = (string)reader["text"];
post.Comments = cm.GetPostComments(post.Id);
var userId = (int)reader["userId"];
post.Author = um.GetUserById(userId);
}
return(post);
}
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);
}
