Using Simple.Data and Predicate<T>

gistfile1.cs

       public IList<Usuaria> GetUsersTakingPill()
        {
            return FindUsers((Usuaria arg) => arg.PrimeiraPilula > DateTime.Today.AddDays(-21) && arg.PrimeiraPilula <= DateTime.Today);
        }

        public IList<Usuaria> GetUsersThatFinishedToTakePill()
        {
            return FindUsers((Usuaria arg) => arg.PrimeiraPilula < DateTime.Today.AddDays(-20));
        }

        public IList<Usuaria> GetUsersThatFinishedToTakePillAndDidntBoughtYet()
        {
            return FindUsers((Usuaria arg) => arg.PrimeiraPilula > DateTime.Today && !arg.PilulaComprada);
        }

        private IList<Usuaria> FindUsers(Predicate<Usuaria> userFilter)
        {
            dynamic db = Database.Open();
            var users = new List<Usuaria>();
            Predicate<Email> emailFilter = GetEmailFilters();
            var hour = DateTime.Now.Hour + int.Parse(ConfigurationManager.AppSettings["TimezoneDifference"]);
            var list = db.Usuarias.FindAllByHora(hour).ToList<Usuaria>().FindAll(userFilter);

            foreach (Usuaria u in list)
            {
                foreach (Email e in db.Emails.FindAllByUsuariaIdAndValidado(u.Id, 1).ToList<Email>().FindAll(emailFilter))
                    u.Emails.Add(e);
                users.Add(u);
            }
            return users;
        }
        
        private Predicate<Email> GetEmailFilters()
        {
            if (DiaNaoUtil.IsWeekend()) return delegate(Email arg) { return arg.FimSemana; };
            else if (DiaNaoUtil.IsHoliday()) return delegate(Email arg) { return arg.Feriado; };
            else return delegate(Email arg) { return arg.DiaSemana; };
        }

Tá ligado que esse código tá bizarro, né?

Claro que tô!