/// <summary> /// Update Recipe Comment /// </summary> /// <returns></returns> public int UpdateRecipeComments(Comment comment) { SqlParameter prmID = new SqlParameter("@ID", SqlDbType.Int, 4); prmID.Value = comment.ID; SqlParameter prmComment = new SqlParameter("@Comment", SqlDbType.VarChar, 350); prmComment.Value = comment.Comments; return DataAccess.Execute("UpdateRecipeComments", prmID, prmComment); }
/// <summary> /// Delete individual article comment /// </summary> /// <returns></returns> public int DeleteArticleComment(Comment comment) { SqlParameter prmID = new SqlParameter("@ID", SqlDbType.Int, 4); prmID.Value = comment.ID; SqlParameter prmAID = new SqlParameter("@AID", SqlDbType.Int, 4); prmAID.Value = comment.RECID; return DataAccess.Execute("AdminDeleteArticleComments", prmID, prmAID); }
/// <summary> /// Insert article comments /// </summary> /// <returns></returns> public int InsertArticleComment(Comment comment) { SqlParameter prmCommentID = new SqlParameter("@ID", SqlDbType.Int, 4); prmCommentID.Value = comment.ID; SqlParameter prmAuthor = new SqlParameter("@Author", SqlDbType.VarChar, 50); prmAuthor.Value = comment.Author; SqlParameter prmEmail = new SqlParameter("@Email", SqlDbType.VarChar, 50); prmEmail.Value = comment.Email; SqlParameter prmComment = new SqlParameter("@Comments", SqlDbType.VarChar, 350); prmComment.Value = comment.Comments; SqlParameter prmUserID = new SqlParameter("@UserID", SqlDbType.Int, 4); prmUserID.Value = comment.UID; return DataAccess.Execute("spInsertArticleComment", prmCommentID, prmAuthor, prmEmail, prmComment, prmUserID); }
/// <summary> /// Delete Recipe Comment /// </summary> /// <returns></returns> public int AdminDeleteRecipeComments(Comment comment) { SqlParameter prmID = new SqlParameter("@COMID", SqlDbType.Int, 4); prmID.Value = comment.ID; SqlParameter prmRecipeID = new SqlParameter("@RecipeID", SqlDbType.Int, 4); prmRecipeID.Value = comment.RECID; return DataAccess.Execute("AdminDeleteRecipeComments", prmID, prmRecipeID); }