public void ReplyForumPostTest()
{
ReplyModel replyModel = new ReplyModel();
replyModel.ForumId = 1;
replyModel.UserId = 1;
replyModel.ReplyPost = "I am testing the reply post to a forum";
Assert.IsTrue(forumController.ReplyForumPost(replyModel) != null);
}
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 ForumModel ReplyForumPost(ReplyModel replyModel)
{
return new ForumBLL().ReplyForumPost(replyModel);
}
public ForumModel ReplyForumPost(ReplyModel replyModel)
{
try
{
using (SqlConnection sqlConnection = new SqlConnection(Constants.DATABASE.CONNECTION_STRING))
{
sqlConnection.Open();
using (SqlCommand sqlCommand = new SqlCommand("INSERT INTO ReplyForumPost VALUES (@ForumId, @ReplyPost, @ReplyUserId, @ReplyDateEntered, @ReplyDateModified, @Active)", sqlConnection))
{
sqlCommand.Parameters.Add(new SqlParameter("ForumId", replyModel.ForumId));
sqlCommand.Parameters.Add(new SqlParameter("ReplyPost", replyModel.ReplyPost));
sqlCommand.Parameters.Add(new SqlParameter("ReplyUserId", replyModel.UserId));
sqlCommand.Parameters.Add(new SqlParameter("ReplyDateEntered", DateTime.Now));
sqlCommand.Parameters.Add(new SqlParameter("ReplyDateModified", DateTime.Now));
sqlCommand.Parameters.Add(new SqlParameter("Active", 1));
sqlCommand.ExecuteNonQuery();
}
sqlConnection.Close();
}
return ReadForumPost(replyModel.ForumId);
}
catch
{
return null;
}
}
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;
}
}