public async Task OnGetAsync(string searchString) { SearchString = searchString; Aquariums = await _context.Aquarium.ToListAsync(); Fishes = await _context.Fish.ToListAsync(); if (!string.IsNullOrEmpty(searchString)) { Fishes = Fishes.Where(s => s.Description.ToLower().Contains(searchString.ToLower()) || s.Origin.ToLower().Contains(searchString.ToLower()) || s.Species.ToLower().Contains(searchString.ToLower())).ToList(); Aquariums = Aquariums.Where(s => (s.Capacity != null && s.Capacity.ToString().Contains(searchString.ToLower())) || (s.GlassThickness != null && s.GlassThickness.ToString().Contains(searchString.ToLower())) || (s.Heigth != null && s.Heigth.ToString().Contains(searchString.ToLower())) || (s.Length != null && s.Length.ToString().Contains(searchString.ToLower())) || (s.Mass != null && s.Mass.ToString().Contains(searchString.ToLower())) || (s.Width != null && s.Width.ToString().Contains(searchString.ToLower())) || (Fishes.Select(x => x.FkAquarium).Contains(s.Id))).ToList(); } else { SearchString = ""; } }
static void Main(string[] args) { var db = new AquariumContext(); //selects all from database as a list //var allAquaLife = db.AquaticLife.ToList(); //var allOcean = db.Ocean.ToList(); //var allAquarium = db.Aquarium.ToList(); //adding to database for oceans //var someOcean = new Oceans //{ // Name = "Atlantic", // AverageTemperature = 65.1 //}; //db.Ocean.Add(someOcean); //db.SaveChanges(); //adding to database for Aquariums var someAquarium = new Aquariums { Name = "Davey Jones' Locker", City = "Bikini Bottom" }; db.Aquarium.Add(someAquarium); db.SaveChanges(); ////adding to database //var aquaticLife = new AquaticLifes //{ // Type = "Oyster", // Color = "Metalic Grey", // Name = "Cloyster", // DateAddedToTank = DateTime.Now.Date, // IsInQuarantee = false //}; //db.AquaticLife.Add(aquaticLife); //db.SaveChanges(); ////select the name of all aquatic lifes of type fish //var fish = db.AquaticLife.Where(w => w.Type == "Fish").Select(s => s.Name); ////updating a fish name //var shell = db.AquaticLife.First(f => f.Name == "Cloyster"); //shell.Name = "Sheldor"; //db.SaveChanges(); ////deleting an aquaticlife //var deletingYou = db.AquaticLife.First(f => f.Type == "Oyster"); //db.AquaticLife.Remove(deletingYou); //db.SaveChanges(); }