Exemple #1
0
        /* public List<KidsClass> AllClasses { get; set; }
         *
         * public void PopulateList()
         * {
         *    AllClasses.Add(new Soccer(Timeframe.Fall, City.Redmond,
         *       9 , 30, "120 NE 85th st", 10, "Arena Soccer"));
         *    AllClasses.Add(new Swimming(Timeframe.Summer, City.Sammammish,
         *        5, 100, "3400 160th Ave NE", 5, "YMCA Swimming"));
         * }
         */

        //ClasssesList instaed of void
        public void PopulateDb()
        {
            KidsClassModel db = new KidsClassModel();

            db.KidsClasses.Add(new KidsClass(ClassType.Soccer, Timeframe.Fall, City.Bellevue, 7, 100, "120 Bellevue Way", 10, "Bellevue Soccer"));
            db.KidsClasses.Add(new KidsClass(ClassType.Soccer, Timeframe.Fall, City.Redmond,
                                             9, 30, "120 NE 85th st", 10, "Arena Soccer"));
            db.KidsClasses.Add(new KidsClass(ClassType.Swimming, Timeframe.Summer, City.Sammammish,
                                             5, 100, "3400 160th Ave NE", 5, "YMCA Swimming"));
            db.KidsClasses.Add(new KidsClass(ClassType.Art, Timeframe.Spring, City.Issaquah, 8, 75, "203 120th Aven NE", 10, "Plateau Art"));
            db.SaveChanges();
        }
Exemple #2
0
        // public virtual KidsClass KidsClass { get; set; }

        //  public virtual ICollection<KidsClass> KidsClasses { get; set; }



        public IQueryable <KidsClass> Search(ClassType clType, Timeframe clSession, City clLocation, int clAge)
        {
            List <KidsClass> listOfClassesToReturn = new List <KidsClass>();
            KidsClassModel   db = new KidsClassModel();

            return(db.KidsClasses.Where(k => k.Location == clLocation && k.Session == clSession && k.ClsType == clType)
                   .Where(k => k.Age == clAge));

            foreach (var kidsClass in db.KidsClasses.Where(k => k.Location == clLocation && k.Session == clSession && k.ClsType == clType)
                     .Where(k => k.Age == clAge))

            {
                listOfClassesToReturn.Add(kidsClass);
                //Console.WriteLine($"We found {kidsClass.Name} at {kidsClass.Address} that matches your requirements");
            }
        }