public bool CreateNewForum(ForumModel forumModel) { try { using (SqlConnection sqlConnection = new SqlConnection(Constants.DATABASE.CONNECTION_STRING)) { sqlConnection.Open(); using (SqlCommand sqlCommand = new SqlCommand("INSERT INTO ForumPost VALUES (@ForumSubject, @ForumPost, @UserId, @DateEntered, @DateModified, @Active)", sqlConnection)) { sqlCommand.Parameters.Add(new SqlParameter("ForumSubject", forumModel.Subject)); sqlCommand.Parameters.Add(new SqlParameter("ForumPost", forumModel.ForumPost)); sqlCommand.Parameters.Add(new SqlParameter("UserId", forumModel.UserId)); sqlCommand.Parameters.Add(new SqlParameter("DateEntered", DateTime.Now)); sqlCommand.Parameters.Add(new SqlParameter("DateModified", DateTime.Now)); sqlCommand.Parameters.Add(new SqlParameter("Active", 1)); sqlCommand.ExecuteNonQuery(); } sqlConnection.Close(); } return true; } catch (Exception ex) { return false; } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (!String.IsNullOrEmpty(txtBoxSubject.Text) && !String.IsNullOrEmpty(txtBoxPost.Text)) { ForumModel forumModel = new ForumModel(); forumModel.ForumPost = txtBoxPost.Text; forumModel.ForumId = Convert.ToInt32(Request["ForumId"]); new Controllers.ForumController().EditForumPost(forumModel); Response.Redirect("~/Forum/ForumPostDetails.aspx?ForumId="+ Request["ForumId"]); } }
protected void Page_Load(object sender, EventArgs e) { if (Request["ForumId"] != null) { Controllers.ForumController forumController = new Controllers.ForumController(); ForumModel = forumController.ReadForumPost(Convert.ToInt32(Request["ForumId"])); } else { Response.Redirect(Request.UrlReferrer.AbsolutePath); } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (!String.IsNullOrEmpty(txtBoxSubject.Text) && !String.IsNullOrEmpty(txtBoxPost.Text)) { ForumModel forumModel = new ForumModel(); forumModel.Subject = txtBoxSubject.Text; forumModel.ForumPost = txtBoxPost.Text; User user = (User)Session["User"]; forumModel.UserId = user.UserId; new ForumController().CreateNewForum(forumModel); Response.Redirect("~/Forum/Forum.aspx"); } }
protected void btnReply_Click(object sender, EventArgs e) { if (!String.IsNullOrEmpty(txtBoxReply.Text)) { Controllers.ForumController forumController = new Controllers.ForumController(); ReplyModel replyModel = new ReplyModel(); User user = (User)Session["User"]; replyModel.UserId = user.UserId; replyModel.ForumId = ForumModel.ForumId; replyModel.ReplyPost = txtBoxReply.Text; ForumModel = forumController.ReplyForumPost(replyModel); txtBoxReply.Text = ""; } }
public ArrayList DisplayForumPosts() { try { ArrayList forumList = new ArrayList(); using (SqlConnection sqlConnection = new SqlConnection(Constants.DATABASE.CONNECTION_STRING)) { sqlConnection.Open(); using (SqlCommand sqlCommand = new SqlCommand("SELECT * FROM ForumPost INNER JOIN Users ON Users.UserID = ForumPost.UserId WHERE Active=1 Order By DateModified DESC", sqlConnection)) { using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader()) { if (sqlDataReader.HasRows) { while (sqlDataReader.Read()) { ForumModel forumModel = new ForumModel(); forumModel.ForumId = Convert.ToInt32(sqlDataReader["ForumId"]); forumModel.Subject = Convert.ToString(sqlDataReader["ForumSubject"]); forumModel.UserId = Convert.ToInt32(sqlDataReader["UserId"]); forumModel.DateEntered = Convert.ToDateTime(sqlDataReader["DateEntered"]); forumModel.DateModified = Convert.ToDateTime(sqlDataReader["DateModified"]); forumModel.FirstName = Convert.ToString(sqlDataReader["FirstName"]); forumModel.LastName = Convert.ToString(sqlDataReader["LastName"]); forumList.Add(forumModel); } } sqlDataReader.Close(); } } sqlConnection.Close(); } return forumList; } catch (Exception ex) { return null; } }
public bool DeleteForumPost(ForumModel forumModel) { try { using (SqlConnection sqlConnection = new SqlConnection(Constants.DATABASE.CONNECTION_STRING)) { sqlConnection.Open(); using (SqlCommand sqlCommand = new SqlCommand("Update ForumPost SET Active = 0, DateModified = @DateModified WHERE ForumId = @ForumId", sqlConnection)) { sqlCommand.Parameters.Add(new SqlParameter("ForumId", forumModel.ForumId)); sqlCommand.Parameters.Add(new SqlParameter("DateModified", DateTime.Now)); sqlCommand.ExecuteNonQuery(); } sqlConnection.Close(); } return true; } catch { return false; } }
public bool EditForumPost(ForumModel forumModel) { return new ForumBLL().EditForumPost(forumModel); }
public bool DeleteForumPost(ForumModel forumModel) { return new ForumBLL().DeleteForumPost(forumModel); }
public bool CreateNewForum(ForumModel forumModel) { return new ForumBLL().CreateNewForum(forumModel); }
public ForumModel ReadForumPost(int forumId) { try { ForumModel forumModel = new ForumModel(); using (SqlConnection sqlConnection = new SqlConnection(Constants.DATABASE.CONNECTION_STRING)) { sqlConnection.Open(); using (SqlCommand sqlCommand = new SqlCommand("SELECT * FROM ForumPost " + " INNER JOIN Users ON ForumPost.UserId = Users.UserID" + " WHERE ForumPost.ForumId=" + forumId + " Order By DateModified DESC", sqlConnection)) { using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader()) { if (sqlDataReader.HasRows) { forumModel.ReplyList = new ArrayList(); sqlDataReader.Read(); forumModel.ForumId = Convert.ToInt32(sqlDataReader["ForumId"]); forumModel.Subject = Convert.ToString(sqlDataReader["ForumSubject"]); forumModel.ForumPost = Convert.ToString(sqlDataReader["ForumPost"]); forumModel.UserId = Convert.ToInt32(sqlDataReader["UserId"]); forumModel.DateEntered = Convert.ToDateTime(sqlDataReader["DateEntered"]); forumModel.DateModified = Convert.ToDateTime(sqlDataReader["DateModified"]); forumModel.FirstName = Convert.ToString(sqlDataReader["FirstName"]); forumModel.LastName = Convert.ToString(sqlDataReader["LastName"]); } sqlDataReader.Close(); } } using (SqlCommand sqlCommand = new SqlCommand("Select * from ReplyForumPost " + " INNER JOIN Users ON ReplyForumPost.ReplyUserId = Users.UserID" + " WHERE ReplyForumPost.ForumId=" + forumId + " Order By ReplyDateModified ASC", sqlConnection)) { using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader()) { if (sqlDataReader.HasRows) { while (sqlDataReader.Read()) { ReplyModel replyModel = new ReplyModel(); replyModel.ReplyPost = Convert.ToString(sqlDataReader["ReplyPost"]); replyModel.UserId = Convert.ToInt32(sqlDataReader["ReplyUserId"]); replyModel.DateEntered = Convert.ToDateTime(sqlDataReader["ReplyDateEntered"]); replyModel.DateModified = Convert.ToDateTime(sqlDataReader["ReplyDateModified"]); replyModel.FirstName = Convert.ToString(sqlDataReader["FirstName"]); replyModel.LastName = Convert.ToString(sqlDataReader["LastName"]); forumModel.ReplyList.Add(replyModel); } } sqlDataReader.Close(); } } sqlConnection.Close(); } return forumModel; } catch (Exception ex) { return null; } }