public string Process() { MySqlConnection con; con = new MySqlConnection(myConnectionString); con.Open(); string title = Args["Title"]; MessageClass m = new MessageClass(); MessageAttachmentsClass attach = new MessageAttachmentsClass(); AttachmentFieldClass field = new AttachmentFieldClass(); field.Title = "Deleted Item"; field.Value = title; attach.AttachField(field); m.Attach(attach); string query = "DELETE FROM todo_list WHERE title=\"" + title + "\" and integ_id=" + IntegrationID.ToString(); MySqlCommand cmd = new MySqlCommand(query, con); cmd.ExecuteNonQuery(); con.Close(); return(JsonConvert.SerializeObject(m)); }
public string Process() { MySqlConnection con; con = new MySqlConnection(myConnectionString); con.Open(); string title = Args["Old-Title"]; string newtitle = ""; string description = ""; if (Args["New-Title"] != null) { newtitle = Args["New-Title"]; } else { newtitle = title; } if (Args["Description"] != null) { description = Args["Description"]; } MessageClass m = new MessageClass(); MessageAttachmentsClass attach = new MessageAttachmentsClass(); AttachmentFieldClass field = new AttachmentFieldClass(); field.Title = "Updated Item"; field.Value = title; attach.AttachField(field); m.Attach(attach); string query = ""; if (description != "") { query = "UPDATE todo_list SET title =\"" + newtitle + "\",description=\"" + description + "\" WHERE integ_id=" + IntegrationID.ToString() + " AND " + " title=\"" + title + "\""; } else { query = "UPDATE todo_list SET title =\"" + newtitle + "\" WHERE integ_id=" + IntegrationID.ToString() + " AND " + " title=\"" + title + "\""; } MySqlCommand cmd = new MySqlCommand(query, con); cmd.ExecuteNonQuery(); con.Close(); return(JsonConvert.SerializeObject(m)); }