public override bool RefundPayment(int paymentid) { bool result = false; using (SakilaEntities dc = new SakilaEntities()) { SPayment spayment = new SPayment(); var model = from p in dc.payments where p.payment_id == paymentid //orderby (p.payment_date) select p; List <payment> payments = model.ToList <payment>(); simulator.PerformanceSimulation(); payment refundpayment = new payment(); refundpayment.amount = payments[0].amount * -1; refundpayment.customer_id = payments[0].customer_id; refundpayment.customerReference = payments[0].customerReference; refundpayment.rental_id = payments[0].rental_id; refundpayment.rentalReference = payments[0].rentalReference; refundpayment.payment_date = DateTime.Now; refundpayment.staff_id = payments[0].staff_id; refundpayment.staffReference = payments[0].staffReference; dc.AddTopayments(refundpayment); dc.AcceptAllChanges(); dc.SaveChanges(); } result = true; return(result); }
public SPayment Createpayment(global::System.Int32 rental_id, global::System.Int32 payment_id, global::System.Int32 customer_id, global::System.Byte staff_id, global::System.Decimal amount, global::System.DateTime payment_date, global::System.DateTime last_update, global::System.Int32 inventory_id, global::System.String filmtitle) { SPayment payment = new SPayment(); payment.payment_id = payment_id; payment.rental_id = rental_id; payment.customer_id = customer_id; payment.staff_id = staff_id; payment.amount = amount; payment.payment_date = payment_date; payment.last_update = last_update; payment.inventory_id = inventory_id; payment.filmtitle = filmtitle; return(payment); }
public override SPayment GetPayment(int id) { SPayment spayment = new SPayment(); using (SakilaEntities dc = new SakilaEntities()) { var model = from p in dc.payments where p.payment_id == id //orderby (p.payment_date) select p; List <payment> payments = model.ToList <payment>(); spayment = spayment.Createpayment((payments[0].rental_id ?? 0), payments[0].payment_id, payments[0].customer_id, payments[0].staff_id, payments[0].amount, payments[0].payment_date, payments[0].last_update, payments[0].rental.inventory_id, payments[0].rental.inventory.film.title); } simulator.PerformanceSimulation(); return(spayment); }
public override SPayment[] GetPaymentsByRental(int rentalid) { List <SPayment> spayments = new List <SPayment>(); using (SakilaEntities dc = new SakilaEntities()) { var model = from p in dc.payments where p.rental_id == rentalid //orderby (p.payment_date) select p; List <payment> payments = model.ToList <payment>(); simulator.PerformanceSimulation(); for (int i = 0; i < payments.Count; i++) { SPayment payment = new SPayment(); payment = payment.Createpayment((payments[i].rental_id ?? 0), payments[i].payment_id, payments[i].customer_id, payments[i].staff_id, payments[i].amount, payments[i].payment_date, payments[i].last_update, payments[i].rental.inventory_id, payments[i].rental.inventory.film.title); spayments.Add(payment); } } return(spayments.ToArray <SPayment>()); }
public override bool RefundPayment(int paymentid) { bool result = false; using (SakilaEntities dc = new SakilaEntities()) { SPayment spayment = new SPayment(); var model = from p in dc.payments where p.payment_id == paymentid //orderby (p.payment_date) select p; List<payment> payments = model.ToList<payment>(); simulator.PerformanceSimulation(); payment refundpayment = new payment(); refundpayment.amount = payments[0].amount * -1; refundpayment.customer_id = payments[0].customer_id; refundpayment.customerReference = payments[0].customerReference; refundpayment.rental_id = payments[0].rental_id; refundpayment.rentalReference = payments[0].rentalReference; refundpayment.payment_date = DateTime.Now; refundpayment.staff_id = payments[0].staff_id; refundpayment.staffReference = payments[0].staffReference; dc.AddTopayments(refundpayment); dc.AcceptAllChanges(); dc.SaveChanges(); } result = true; return result; }
public override SPayment[] GetPaymentsByRental(int rentalid) { List<SPayment> spayments = new List<SPayment>(); using (SakilaEntities dc = new SakilaEntities()) { var model = from p in dc.payments where p.rental_id == rentalid //orderby (p.payment_date) select p; List<payment> payments = model.ToList<payment>(); simulator.PerformanceSimulation(); for (int i = 0; i < payments.Count; i++) { SPayment payment = new SPayment(); payment = payment.Createpayment((payments[i].rental_id ?? 0), payments[i].payment_id, payments[i].customer_id, payments[i].staff_id, payments[i].amount, payments[i].payment_date, payments[i].last_update, payments[i].rental.inventory_id, payments[i].rental.inventory.film.title); spayments.Add(payment); } } return spayments.ToArray<SPayment>(); }
public override SPayment GetPayment(int id) { SPayment spayment = new SPayment(); using (SakilaEntities dc = new SakilaEntities()) { var model = from p in dc.payments where p.payment_id == id //orderby (p.payment_date) select p; List<payment> payments = model.ToList<payment>(); spayment = spayment.Createpayment((payments[0].rental_id ?? 0), payments[0].payment_id, payments[0].customer_id, payments[0].staff_id, payments[0].amount, payments[0].payment_date, payments[0].last_update, payments[0].rental.inventory_id, payments[0].rental.inventory.film.title); } simulator.PerformanceSimulation(); return spayment; }
public SPayment Createpayment(global::System.Int32 rental_id, global::System.Int32 payment_id, global::System.Int32 customer_id, global::System.Byte staff_id, global::System.Decimal amount, global::System.DateTime payment_date, global::System.DateTime last_update,global::System.Int32 inventory_id, global::System.String filmtitle) { SPayment payment = new SPayment(); payment.payment_id = payment_id; payment.rental_id = rental_id; payment.customer_id = customer_id; payment.staff_id = staff_id; payment.amount = amount; payment.payment_date = payment_date; payment.last_update = last_update; payment.inventory_id = inventory_id; payment.filmtitle = filmtitle; return payment; }