protected override string GetQuery(CodeActivityContext context)
{
long recordId = TableRecordID.Get(context);
string title = Title.Get(context);
DateTime dueDate = DueDate.Get(context);
string statusId = StatusID.Get(context);
string titleStr = string.Empty;
if (!string.IsNullOrWhiteSpace(title))
{
titleStr = string.Format("title: {0}", title.ToQueryValue());
}
string dueDateStr = string.Empty;
if (dueDate != null && dueDate != DateTime.MinValue)
{
dueDateStr = string.Format("due_date: {0}", dueDate.ToQueryValue());
}
string statusStr = string.Empty;
if (!string.IsNullOrWhiteSpace(statusId))
{
statusStr = string.Format("statusId: \"{0}\"", statusId);
}
return(string.Format(UpdateTableRecordQuery, recordId, titleStr, dueDateStr, statusStr));
}
protected override string GetQuery(CodeActivityContext context)
{
string tableId = TableID.Get(context);
DateTime dueDate = DueDate.Get(context);
string title = Title.Get(context);
if (dueDate == null || dueDate == DateTime.MinValue)
{
dueDate = DateTime.Now.AddMonths(1);
}
var dict = DictionaryFields.Get(context);
if (dict == null || dict.Count == 0)
{
var dataRow = DataRowFields.Get(context);
var tempDict = dataRow.ToDictionary();
if (tempDict != null)
{
dict = tempDict;
}
}
if (string.IsNullOrWhiteSpace(title) && dict?.Count > 0)
{
title = dict.First().Value.ToString();
}
return(BuildQuery(tableId, title, dict, dueDate));
}
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));
}
/// <summary>
/// Create the QCL record.
/// </summary>
/// <param name="context"></param>
protected override void DoWork(CodeActivityContext context)
{
var mgr = new QclManager {
PM = PM
};
int chkId = mgr.CreateQcl(PatId1.Get(context),
TskId.Get(context),
StaffIdResponsible.Get(context),
StaffIdRequesting.Get(context),
DueDate.Get(context),
CGroup.Get(context),
PrsId.Get(context),
Instructions.Get(context),
Comment.Get(context));
ChkId.Set(context, chkId);
}
/// <summary>
/// Checks for QCL's with attributes matching the parameters passed in.
/// </summary>
/// <param name="context"></param>
protected override void DoWork(CodeActivityContext context)
{
var mgr = new QclManager {
PM = PM
};
bool qclExists = mgr.CheckQclExists(PatId1.Get(context),
TskId.Get(context),
StaffIdResponsible.Get(context),
StaffIdRequesting.Get(context),
DueDate.Get(context),
CGroup.Get(context),
PrsId.Get(context),
Instructions.Get(context),
Comment.Get(context),
Completed.Get(context));
QclExists.Set(context, qclExists);
}
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));
}