public bool PutDisLike(ArtCommentPlus artCommentPlus)
{
SqlConnection sqlConnection = new SqlConnection(connectionstring);
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
SqlTransaction sqlTransaction = sqlConnection.BeginTransaction();
try
{
string sql = "update ArticalCmtTable set DownArtCmtnum =DownArtCmtnum+1 where Articalid=@Articalid and ArtCmtUserid=@ArtCmtUserid and ArtCmtedUserid=@ArtCmtedUserid and ArtCmtTime=@ArtCmtTime";
sqlCommand.CommandText = sql;
sqlCommand.Transaction = sqlTransaction;
sqlCommand.Parameters.AddWithValue("@Articalid", artCommentPlus.Articalid);
sqlCommand.Parameters.AddWithValue("@ArtCmtUserid", artCommentPlus.CmdUserid);
sqlCommand.Parameters.AddWithValue("@ArtCmtedUserid", artCommentPlus.CmtedUserid);
sqlCommand.Parameters.AddWithValue("ArtCmtTime", artCommentPlus.Datetime);
sqlCommand.ExecuteNonQuery();
sqlTransaction.Commit();
return(true);
}
catch (SqlException)
{
sqlTransaction.Rollback();
return(false);
}
finally
{
sqlConnection.Close();
}
}
}
public bool Delputdislike([FromBody] ArtCommentPlus artCommentPlus)
{
ArtCommentAccess artCommentAccess = new ArtCommentAccess();
return(artCommentAccess.DelPutDisLike(artCommentPlus));
}
public bool PutLike([FromBody] ArtCommentPlus artCommentPlus)
{
ArtCommentAccess artCommentAccess = new ArtCommentAccess();
return(artCommentAccess.PutLike(artCommentPlus));
}