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