public void SaveReply(ReviewReplyModel reviewreplymodel)
{
string query = @"IF NOT EXISTS(
SELECT *
FROM [ReviewReply]
WHERE ReviewId = @Id
)
BEGIN
IF EXISTS(
SELECT *
FROM [Review]
WHERE Id = @Id AND VolunteerId = @VolunteerId
)
BEGIN
INSERT INTO [ReviewReply] (ReviewId, Content, Date)
VALUES (@Id, @Content, GETDATE())
END
END
ELSE
BEGIN
UPDATE [ReviewReply]
SET Content = @Content
WHERE ReviewId = @Id AND ReviewId IN (
SELECT Id
FROM [Review]
WHERE VolunteerId = @VolunteerId
)
END";
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
using (SqlCommand cmd = new SqlCommand(query, conn))
{
conn.Open();
cmd.Parameters.AddWithValue("@Id", reviewreplymodel.Review);
cmd.Parameters.AddWithValue("@Content", reviewreplymodel.Content);
cmd.Parameters.AddWithValue("@VolunteerId", reviewreplymodel.Review.Volunteer.Id);
cmd.ExecuteNonQuery();
}
}
public void SaveReply(ReviewReplyModel reviewreplymodel)
{
throw new NotImplementedException();
}
/// <summary>
/// Add or update a reply to a review.
/// </summary>
/// <param name="reply">
/// The reply.
/// </param>
public void Reply(ReviewReplyModel reply)
{
context.SaveReply(reply);
}
public ReviewReplyModel Save(ReviewReplyModel reviewReply)
{
context.SaveReply(reviewReply);
return(reviewReply);
}
