public static void AddReview(Review review)
{
review.ReviewId = SQLDataHelper.GetInt(SQLDataAccess.ExecuteScalar("INSERT INTO [CMS].[Review] " +
" ([ParentId], [EntityId], [Type], [CustomerId], [Name], [Email], [Text], [Checked], [AddDate], [IP]) " +
" VALUES (@ParentId, @EntityId, @Type, @CustomerId, @Name, @Email, @Text, @Checked, GETDATE(), @IP); SELECT SCOPE_IDENTITY(); ",
CommandType.Text,
new SqlParameter("@ParentId", review.ParentId),
new SqlParameter("@EntityId", review.EntityId),
new SqlParameter("@Type", (int)review.Type),
new SqlParameter("@CustomerId", review.CustomerId),
new SqlParameter("@Name", review.Name),
new SqlParameter("@Email", review.Email),
new SqlParameter("@Text", review.Text),
new SqlParameter("@Checked", review.Checked),
new SqlParameter("@IP", review.Ip)));
}
public static void UpdateReview(Review review)
{
SQLDataAccess.ExecuteNonQuery("UPDATE [CMS].[Review] SET [ParentId] = @ParentId, [EntityId] = @EntityId, [Type] = @Type, [CustomerId] = @CustomerId, [Name] = @Name, [Email] = @Email, [Text] = @Text , [Checked] = @Checked, AddDate=@AddDate WHERE reviewId = @reviewId",
CommandType.Text,
new SqlParameter("@reviewId", review.ReviewId),
new SqlParameter("@ParentId", review.ParentId),
new SqlParameter("@EntityId", review.EntityId),
new SqlParameter("@Type", review.Type),
new SqlParameter("@CustomerId", review.CustomerId),
new SqlParameter("@Name", review.Name),
new SqlParameter("@Email", review.Email),
new SqlParameter("@Checked", review.Checked),
new SqlParameter("@Text", review.Text),
new SqlParameter("@AddDate", review.AddDate)
);
}
