private static List <RENTAL_AGREEMENT> AvailableAppointments() { INF370Entities db = new INF370Entities(); List <RENTAL_AGREEMENT> list = db.RENTAL_AGREEMENT.Include(zz => zz.CLIENT).Where(zz => zz.AMOUNTDUE > 0).ToList(); return(list); }
private static List <RENTAL_AGREEMENT> AvailableAppointments() { INF370Entities db = new INF370Entities(); List <RENTAL_AGREEMENT> list = db.RENTAL_AGREEMENT.Include(zz => zz.CLIENT).ToList(); List <RENTAL_AGREEMENT> final = new List <RENTAL_AGREEMENT>(); foreach (var date in list) { var end = Convert.ToDateTime(date.RENTALENDDATE).AddMonths(-2); if (end <= DateTime.Now) { final.Add(date); } } return(final); }