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