public bool AddNewUserFeedback(AddUserFeedbackDTO userFeedbackToAdd)
{
using (var db = new SqlConnection(_connectionString))
{
var sql = @"INSERT INTO[dbo].[UserFeedback]
([UserId]
,[ProductId]
,[StarRating]
,[Review])
VALUES
(@UserId
, @ProductId
, @StarRating
, @Review)";
return(db.Execute(sql, userFeedbackToAdd) == 1);
}
}
public IEnumerable <ProductWithUserFeedbackDTO> AddUserFeedback(AddUserFeedbackDTO userFeedbackToAdd)
{
_repo.AddNewUserFeedback(userFeedbackToAdd);
return(_repo.GetUserFeedbacksByUserId(userFeedbackToAdd.UserId));
}
