public void RemovePlant(int plantId)
{
var db = new PlantContext();
var validId = db.Plants.Any(plant => plant.Id == plantId);
while (validId != true)
{
Console.WriteLine("That is not a valid Id number please try again");
plantId = int.Parse(Console.ReadLine());
validId = db.Plants.Any(plant => plant.Id == plantId);
}
if (validId == true)
{
var idToRemove = db.Plants.FirstOrDefault(plant => plant.Id == plantId);
Console.WriteLine($"Are you sure you wand to remove {idToRemove.Species} with an Id of {idToRemove.Id}? (Y)/(N)");
var confirmRemoval = Console.ReadLine().ToLower();
while (confirmRemoval != "y" && confirmRemoval != "n")
{
Console.WriteLine("Please take this seriously we're about to delete a plant. Input (Y) or (N) ");
confirmRemoval = Console.ReadLine().ToLower();
}
if (confirmRemoval == "y")
{
Console.WriteLine($"{idToRemove.Id} has been removed.");
db.Remove(idToRemove);
db.SaveChanges();
}
else
{
Console.WriteLine("Nothing has been removed.");
}
}
}
public void NotWatered()
{
var db = new PlantContext();
var wateredToday = db.Plants.Where(plant => plant.LastWateredDate < DateTime.Today);
foreach (var p in wateredToday)
{
Console.WriteLine($"{p.Species} has not been watered today, it was last watered on {p.LastWateredDate}");
}
}
public void ViewAll()
{
var db = new PlantContext();
var viewPlants = db.Plants.OrderBy(plant => plant.LocatedPlant);
foreach (var p in viewPlants)
{
Console.WriteLine($"There is a {p.Species} with an id of {p.Id} in the {p.LocatedPlant}");
}
}
public void NeedWater()
{
var db = new PlantContext();
var lastWater = db.Plants.Select(plant => plant.LastWateredDate.Subtract(DateTime.Now).Sum > plant.WateringFrequency);
foreach (var l in lastWater)
{
Console.WriteLine($"{l.Species} {l.LastWatereDate}");
}
}
public void PlantNewPlant(string species, string locatedPlant, DateTime plantedDAte, DateTime lastWateredDate, double waterNeeded, double lightNeeded)
{
//interacts with
var db = new PlantContext();
var newPlant = new Plant
{
Species = species,
LocatedPlant = locatedPlant,
PlantedDate = plantedDAte,
LastWateredDate = lastWateredDate,
WaterNeeded = waterNeeded,
LightNeeded = lightNeeded
};
db.Plants.Add(newPlant);
db.SaveChanges();
Console.WriteLine($"You have added {species} to the Plant Database one {DateTime.Now} ");
}
public void WaterPlant(int plantId)
{
var db = new PlantContext();
var validId = db.Plants.Any(plant => plant.Id == plantId);
while (validId != true)
{
Console.WriteLine("That is not a valid Id number please try again");
plantId = int.Parse(Console.ReadLine());
validId = db.Plants.Any(plant => plant.Id == plantId);
}
if (validId == true)
{
var idToWater = db.Plants.FirstOrDefault(plant => plant.Id == plantId);
idToWater.LastWateredDate = DateTime.Now;
db.SaveChanges();
Console.WriteLine($"{idToWater.Species} with a Id of {idToWater.Id} was watered on {idToWater.LastWateredDate}");
}
}
public void Locations(string plantLocated)
{
var db = new PlantContext();
var validLocation = db.Plants.Any(plant => plant.LocatedPlant == plantLocated);
while (validLocation == false)
{
Console.WriteLine("That location doesn't exist. Please input a valid location");
plantLocated = Console.ReadLine().ToLower();
validLocation = db.Plants.Any(plant => plant.LocatedPlant == plantLocated);
}
if (validLocation == true)
{
var locatedPlant = db.Plants.Where(plant => plant.LocatedPlant == plantLocated);
foreach (var p in locatedPlant)
{
Console.WriteLine($"{p.Species} is located in {p.LocatedPlant}");
}
}
}