protected override string GetQuery(CodeActivityContext context)
{
var phaseId = PhaseID.Get(context);
string inputQuery = GetInputQuery(context);
return(string.Format(GetPhaseCardsQuery, phaseId, inputQuery));
}
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));
}
protected override void Execute(CodeActivityContext context)
{
System.Net.WebRequest req = System.Net.WebRequest.Create("https://app.pipefy.com/queries");
req.Proxy.Credentials = System.Net.CredentialCache.DefaultNetworkCredentials;
req.Timeout = 120000;
req.Headers.Add("authorization", "Bearer " + Bearer.Get(context));
req.ContentType = "application/json";
req.Method = "POST";
byte[] bytes = System.Text.Encoding.UTF8.GetBytes("{ \"query\": \"mutation { deletePhase(input: { id: " + PhaseID.Get(context) + " }) { success } }\" }");
req.ContentLength = bytes.Length;
System.IO.Stream os = req.GetRequestStream();
os.Write(bytes, 0, bytes.Length);
os.Close();
System.Net.WebResponse resp = req.GetResponse();
System.IO.StreamReader sr = new System.IO.StreamReader(resp.GetResponseStream());
JArray array = new JArray();
JObject joResponse = JObject.Parse(sr.ReadToEnd());
Return.Set(context, joResponse.ToString());
}
protected override string GetQuery(CodeActivityContext context)
{
var phaseId = PhaseID.Get(context);
return(string.Format(GetPhaseQuery, phaseId));
}
