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