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