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) ); }