protected override string GetQuery(CodeActivityContext context)
{
var card = CardID.Get(context);
var assignees = AssigneeIDs.Get(context);
var dueDate = DueDate.Get(context);
var labels = LabelIDs.Get(context);
var title = Title.Get(context);
var cardFields = new List <string>();
if (assignees?.Length > 0)
{
cardFields.Add(string.Format("assignee_ids: {0}", assignees.ToQueryValue()));
}
if (dueDate != null && dueDate != DateTime.MinValue)
{
cardFields.Add(string.Format("due_date: {0}", dueDate.ToQueryValue()));
}
if (labels?.Length > 0)
{
cardFields.Add(string.Format("label_ids: {0}", labels.ToQueryValue()));
}
if (!string.IsNullOrWhiteSpace(title))
{
cardFields.Add(string.Format("title: {0}", title.ToQueryValue()));
}
var paramsStr = string.Join(" ", cardFields);
return(string.Format(UpdateCardQuery, card, paramsStr));
}
protected DataTable GenerateDataTableBulkIDs(string columnName, AssigneeIDs assigneeIDs)
{
DataTable dataTable = new DataTable();
dataTable.Columns.Add(columnName, typeof(int));
foreach (BulkID bulkID in assigneeIDs.BulkID)
{
dataTable.Rows.Add(bulkID.UpdateID);
}
return(dataTable);
}
private string GetCardFieldsQuery(CodeActivityContext context)
{
var assignees = AssigneeIDs.Get(context);
var dueDate = DueDate.Get(context);
var labels = LabelIDs.Get(context);
var parents = ParentsIDs.Get(context);
var phase = PhaseID.Get(context);
var title = Title.Get(context);
var cardFields = new List <string>();
if (assignees?.Length > 0)
{
cardFields.Add(string.Format("assignee_ids: {0}", assignees.ToQueryValue()));
}
if (dueDate != null && dueDate != DateTime.MinValue)
{
cardFields.Add(string.Format("due_date: {0}", dueDate.ToQueryValue()));
}
if (labels?.Length > 0)
{
cardFields.Add(string.Format("label_ids: {0}", labels.ToQueryValue()));
}
if (parents?.Length > 0)
{
cardFields.Add(string.Format("parent_ids: {0}", parents.ToQueryValue()));
}
if (phase > 0)
{
cardFields.Add(string.Format("phase_id: \"{0}\"", phase));
}
if (!string.IsNullOrWhiteSpace(title))
{
cardFields.Add(string.Format("title: {0}", title.ToQueryValue()));
}
return(string.Join(" ", cardFields));
}
