public bool delRecipe(int id)
{
/* Modifica sul database (eliminazione della ricetta) */
try
{
sqlQuery = "DELETE from Recipes where id_recipe = @idRecipe";
Database.setValues(sqlQuery, id);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
/* Invio richiesta delete al server web */
try
{
ServerRequest.DeleteRequest(id);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(true);
}
public bool applyRecipe([FromBody] Recipe jsonObject)
{
result = true;
/* Invio parametri ai circuiti elettronici */
Parameters param = new Parameters(DateTime.Now, jsonObject.AirTemperature, jsonObject.WaterTemperature, jsonObject.Humidity, jsonObject.PH, jsonObject.Conductivity);
internalSetParameter(param);
/* Invio opzioni ai circuiti elettronici */
Options opt = new Options(jsonObject.RGB, jsonObject.Light);
internalSetOption(opt);
/* Eliminazione dei parametri vecchi */
sqlQuery = "DELETE FROM Parameters WHERE id_parameters>0";
Database.setValues(sqlQuery);
/* Creazione primo record */
DateTime timeStamp = DateTime.Now;
Parameters obj = new Parameters(timeStamp, 0.0f, 0.0f, 0, 7, 0);
sqlQuery = "INSERT INTO Parameters (TimeStamp, AirTemperature, WaterTemperature, Humidity, PH, Conductivity) VALUES (@timeStamp, @airTemperature, @waterTemperature, @humidity, @pH, @conductivity)";
Database.setValues(sqlQuery, obj);
/* Memorizzazione dati ricevuti su Database */
Options modified = new Options(jsonObject.RGB, jsonObject.Light, jsonObject.AddressImage);
try
{
sqlQuery = "UPDATE Options SET RGB = @rgb, Light = @light, AddressImage = @addressImage LIMIT 1";
Database.setValues(sqlQuery, modified);
}
catch (Exception ex)
{
//throw new Exception(ex.Message);
}
/* Invio dati al server web */
try
{
ServerRequest.DeleteRequest();
ServerRequest.PutRequest(modified);
listRecipes.Clear();
}
catch (Exception ex)
{
//throw new Exception(ex.Message);
}
return(result);
}
