public static FoodTank JsonToFoodTank(String json)
{
JObject rss = JObject.Parse(json);
string sensorId = (string)rss["sensorid"];
float food = (float)rss["food"];
int foodFormular = (int)rss["foodformular"];
FoodTank obj = new FoodTank(sensorId, food, foodFormular);
return(obj);
}
public bool insert(FoodTank foodTank)
{
if (!connect())
{
return(false);
}
String query = "INSERT INTO foodtank VALUES ( @sensorid, @food, @foodFormular, CURRENT_TIMESTAMP)";
command = new MySqlCommand(query, connection);
command.Parameters.AddWithValue("@sensorid", foodTank.getSensorId());
command.Parameters.AddWithValue("@food", foodTank.getFood());
command.Parameters.AddWithValue("@foodFormular", foodTank.getFoodFormular());
command.ExecuteNonQuery();
connection.Close();
return(true);
}
