/**
  * 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;
 }
Example #2
0
$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);