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); }