public bool SubmitPost(PostResultsViewModel postResults) { int rowsAffected = 0; try { using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("Insert into posts Values (@threadID, @userID, @postBody, @postDate);", conn); cmd.Parameters.AddWithValue("@threadID", postResults.NewPost.ThreadID); cmd.Parameters.AddWithValue("@userID", postResults.NewPost.UserID); cmd.Parameters.AddWithValue("@postBody", postResults.NewPost.PostBody); cmd.Parameters.AddWithValue("@postDate", DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")); rowsAffected = cmd.ExecuteNonQuery(); } } catch (SqlException e) { Console.WriteLine(e.Message); throw; } return(rowsAffected > 0); }
public ActionResult AddAPost(PostResultsViewModel model) { forumDAL.SubmitPost(model); ThreadModel selectedThread = forumDAL.GetThreadByThreadID(model.SelectedThread.ThreadID); List <PostModel> AllPosts = new List <PostModel>(); AllPosts = forumDAL.GetAllPosts(selectedThread.ThreadID); model.AllPostsInThread = AllPosts; UserModel user = usersDAL.GetUser(base.CurrentUser); model.NewPost.UserID = user.UserID; model.NewPost.Username = user.Username; //model.NewPost.PostBody = ""; return(RedirectToAction("ViewPosts", new { threadID = model.SelectedThread.ThreadID })); }
public void TestSubmitPost() { ForumSqlDAL dal = new ForumSqlDAL(); PostResultsViewModel model = new PostResultsViewModel(); PostModel newPost = new PostModel(); model.NewPost = newPost; model.NewPost.ThreadID = threadId; model.NewPost.UserID = userId; model.NewPost.ThreadName = "The awesome threadName"; model.NewPost.PostBody = "This is the postBody"; bool isSubmitted = dal.SubmitPost(model); Assert.IsTrue(isSubmitted); }
// GET: Forum public ActionResult ViewPosts(int threadID) { List <PostModel> list = new List <PostModel>(); PostResultsViewModel model = new PostResultsViewModel(); ThreadModel thread = forumDAL.GetThreadByThreadID(threadID); model.SelectedThread = thread; list = forumDAL.GetAllPosts(threadID); model.AllPostsInThread = list; UserModel user = usersDAL.GetUser(base.CurrentUser); PostModel newPost = new PostModel(); model.NewPost = newPost; model.NewPost.UserID = user.UserID; model.NewPost.ThreadID = thread.ThreadID; return(View("ViewPosts", model)); }