public void AddSeedling(HttpRequestMessage request,
[FromBody] Seedling seedling)
{
using (var context = new PlantAppContext())
{
context.Seedlings.Add(seedling);
context.SaveChanges();
}
}
public void DeletePlant(HttpRequestMessage request,
[FromBody] PlantSpecie plantSpecie)
{
using (var context = new PlantAppContext())
{
context.Entry(plantSpecie).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void DeletePlant(int id)
{
using (var context = new PlantAppContext())
{
var plant = context.Plants.Where(x => x.Id == id).FirstOrDefault();
context.Entry(plant).State = EntityState.Deleted;
context.SaveChanges();
}
}
// syntax to receive a complex object:
public string UpdatePlant(HttpRequestMessage request,
[FromBody] PlantSpecie plantSpecie)
{
using (var context = new PlantAppContext())
{
context.Entry(plantSpecie).State = EntityState.Modified;
context.SaveChanges();
}
return("Changes have been saved");
}
public string AddNewPlantSpecie(HttpRequestMessage request,
[FromBody] PlantSpecie newPlantSpecie)
{
using (var context = new PlantAppContext())
{
context.PlantSpecies.Add(newPlantSpecie);
context.SaveChanges();
return("Added new plant specie");
}
}
public void DeleteSeedling(int id)
{
using (var context = new PlantAppContext())
{
var seedling = context.Seedlings.Where(x => x.Id == id).FirstOrDefault();
for (int i = 0; i < seedling.Plants.ToList().Count(); i++)
{
context.Entry(seedling.Plants.ToList()[i]).State = EntityState.Deleted;
}
context.Entry(seedling).State = EntityState.Deleted;
context.SaveChanges();
}
}
public string WaterPlants(int id)
{
using (var context = new PlantAppContext())
{
var plants = context.Seedlings.Where(x => x.Id == id).FirstOrDefault().Plants;
foreach (var plant in plants)
{
plant.TimeAndDateLastWatered = DateTime.Now;
context.Entry(plant).State = EntityState.Modified;
context.SaveChanges();
}
}
return("Plants have been watered");
}
public void AddPlant(string newName, int id)
{
using (var context = new PlantAppContext())
{
var seedling = context.Seedlings.Where(x => x.Id == id).FirstOrDefault();
Plant plant = new Plant()
{
PlantSpecie = context.PlantSpecies.Where(x => x.Name == newName).FirstOrDefault(),
Seedling = seedling,
TimeAndDateLastWatered = DateTime.Now
};
context.Plants.Add(plant);
context.SaveChanges();
}
}