public string Edit(string jsonString)
{
Connect connect = new Connect();
MySqlConnection mySqlConnect = connect.SqlConnect();
EditDataObject buildDataObject = new EditDataObject();
EditTask responseJsonString = buildDataObject.BuildData(jsonString);
MySqlCommand cmd = new MySqlCommand
{
CommandText = $"update organizer set {responseJsonString.propName} = " +
$"'{responseJsonString.value}' where id = '{responseJsonString.id}' ",
Connection = mySqlConnect
};
try
{
int countRows = cmd.ExecuteNonQuery();
mySqlConnect.Close();
return("Edit!");
}
catch (MySqlException ex)
{
string cmdStatus = ex.Message;
mySqlConnect.Close();
return(cmdStatus);
}
}
public EditTask BuildData(string dataString)
{
EditTask responseJsonString = JsonConvert.DeserializeObject <EditTask>(dataString);
if ((string)responseJsonString.propName == "isComplete")
{
responseJsonString.value = ConvertBoolField.Convert(responseJsonString.value);
}
if ((string)responseJsonString.propName == "isPin")
{
responseJsonString.value = ConvertBoolField.Convert(responseJsonString.value);
}
return(responseJsonString);
}
