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);
        }
Exemple #2
0
        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);
        }