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