public int Water(int id) { Plants = new List <Plant>(); // fill the PlantTableAdapter with the data in the plant database table PlantTableAdapter plantAdapter = new PlantTableAdapter(); WaterMangoAppDataSet.PlantDataTable plantTable = plantAdapter.GetData(); // Select the requested Plant object WaterMangoAppDataSet.PlantRow plantRow = plantTable.Where(x => x.Id == id).First(); // Make sure it is not null if (plantRow != null) { // Check that the plant can be watered if (Plant.CanPlantBeWatered(plantRow.LastWatered)) { // iterate the number of seconds the plant has been watered by 1 plantRow.SecondsWatered += 1; // if the plant has been watered for 10 seconds or more if (plantRow.SecondsWatered > 9) { // reset the time the plant has been watered and then set the last watered time to Now plantRow.SecondsWatered = 0; plantRow.LastWatered = DateTime.Now; } // update the plant table in the database plantAdapter.Update(plantTable); // return the number of seconds this plant has been watered return(plantRow.SecondsWatered); } else { return(-1); // Plant cannot be watered within 30 seconds } } else { return(0); } }
public Plant Get(int id) { Plants = new List <Plant>(); // fill the PlantTableAdapter with the data in the plant database table PlantTableAdapter plantAdapter = new PlantTableAdapter(); WaterMangoAppDataSet.PlantDataTable plantTable = plantAdapter.GetData(); // iterate through the table rows and add the WaterMango.Plant objects to the Plants list foreach (WaterMangoAppDataSet.PlantRow row in plantTable.Rows) { Plants.Add(new Plant(row.Id, row.Name, row.LastWatered, row.SecondsWatered)); } // return the Plant with the currently requested Id return(Plants.Where(x => x.Id == id).First()); }
public IEnumerable <Plant> Get() { Plants = new List <Plant>(); // fill the PlantTableAdapter with the data in the plant database table PlantTableAdapter plantAdapter = new PlantTableAdapter(); WaterMangoAppDataSet.PlantDataTable plantTable = plantAdapter.GetData(); // iterate through the table rows and add the WaterMango.Plant objects to the Plants list foreach (WaterMangoAppDataSet.PlantRow row in plantTable.Rows) { Plants.Add(new Plant(row.Id, row.Name, row.LastWatered, row.SecondsWatered)); } // return the Plants list as an array return(Plants.ToArray()); }