/** * Delete a payment * * @param PaymentEntity the payment object */ public function delete(PaymentEntity $payment) { $sql = "DELETE FROM Payment WHERE OrderId = :id"; $stmt = $this->db->prepare($sql); $result = $stmt->execute(["id" => $payment->getId()]); if (!$result) { throw new Exception("could not delete record"); } return $result; }
$em = $doctrine->em; // Registrant Seeder $reg = new RegistrantEntity(); $reg->setUsername('hanan'); $reg->setName('Ardiyan Hananto'); $reg->setGender('L'); $reg->setNisn('2010249129310'); $reg->setCp('085738271625'); $reg->setPassword(password_hash('qwerty', PASSWORD_BCRYPT)); $reg->setPreviousSchool('SMP IT Ihsanul FIkri Mungkid'); $reg->setProgram('Reguler'); $reg->setRegistrationTime(new DateTime('1-12-2014')); $em->persist($reg); $em->flush(); // Payment $payment = new PaymentEntity(); $payment->setRegistrant($reg); $payment->setPaymentDate(new DateTime('now')); $payment->setVerificationDate(new DateTime('now')); $payment->setVerified('valid'); $payment->setAmount('250000'); $em->persist($payment); $reg->setVerified($payment->getVerified()); $reg->setPaymentData($payment); $em->persist($reg); $em->flush(); // ==== Counter Seeder ==== $counter = new CounterEntity(); $counter->setId(1); $counter->setDate(new DateTime('now')); $counter->setMaleCount(0);