protected override string GetQuery(CodeActivityContext context)
{
var phaseId = PhaseID.Get(context);
string inputQuery = GetInputQuery(context);
return(string.Format(GetPhaseCardsQuery, phaseId, inputQuery));
}
// Use this for initialization
void Start()
{
fader = GetComponent <ScreenFader>();
lastPhase = PhaseID.NONE;
currentPhase = PhaseID.PRE;
preSceneInstance = Instantiate(preScenePrefab);
preSceneInstance.SetActive(true);
}
public string csvString()
{
string word = ID.ToString() + ',' + ChannelID.ToString() + ',' + Name.Replace(',', '-') + ',' + AlarmTypeID.ToString() + ',' + Severity.ToString() + ',' + High.ToString() + ',' + Low.ToString() + ',' + RangeInclusive.ToString() + ','
+ PerUnit.ToString() + ',' + Enabled.ToString() + ',' + MeasurementType + ',' + MeasurementTypeID.ToString() + ',' + MeasurementCharacteristic + ',' + MeasurementCharacteristicID.ToString() + ',' +
Phase + ',' + PhaseID.ToString() + ',' + HarmonicGroup.ToString() + ',' + IsDefault.ToString();
return(word);
}
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));
}
// Update is called once per frame
void Update()
{
if (Input.GetKeyDown(KeyCode.F1))
{
currentPhase = PhaseID.ONE;
}
else if (Input.GetKeyDown(KeyCode.F2))
{
currentPhase = PhaseID.TWO;
}
else if (Input.GetKeyDown(KeyCode.F3))
{
currentPhase = PhaseID.THREE;
}
if (lastPhase != currentPhase)
{
PhaseID nextPhase;
// Deinit
if (fader.fadeIn == true)
{
fader.fadeIn = false;
}
switch (lastPhase)
{
case PhaseID.NONE:
nextPhase = PhaseID.PRE;
break;
case PhaseID.PRE:
Deinit0Phase();
nextPhase = PhaseID.ONE;
break;
case PhaseID.ONE:
Deinit1Phase();
nextPhase = PhaseID.TWO;
break;
case PhaseID.TWO:
Deinit2Phase();
nextPhase = PhaseID.THREE;
break;
case PhaseID.THREE:
Deinit3Phase();
nextPhase = PhaseID.FOUR;
break;
case PhaseID.FOUR:
Deinit4Phase();
nextPhase = PhaseID.ONE;
break;
default:
nextPhase = PhaseID.ERR;
break;
}
time += Time.deltaTime;
if (time > 2.0)
{
lastPhase = currentPhase;
fader.fadeIn = true;
// Init
switch (nextPhase)
{
case PhaseID.PRE:
// NONE
break;
case PhaseID.ONE:
Init1Phase();
break;
case PhaseID.TWO:
Init2Phase();
break;
case PhaseID.THREE:
Init3Phase();
break;
case PhaseID.FOUR:
Init4Phase();
break;
case PhaseID.ERR:
// NONE
break;
default:
// NONE
break;
}
currentPhase = nextPhase;
}
// Update last phase
// Update current phase.
}
}
/// <summary>
/// Deletes the Phase item.
/// </summary>
/// <returns>Boolean</returns>
public bool DeletePhase()
{
SqlDataReader result;
DatabaseConnection dbconn = new DatabaseConnection();
SqlCommand command = new SqlCommand();
SqlConnection connection = new SqlConnection(dbconn.SQLSEVERConnString);
try
{
connection.Open();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "Delete_Phase";
command.Parameters.Add(dbconn.GenerateParameterObj("@PhaseID", SqlDbType.Int, PhaseID.ToString(), 0));
result = command.ExecuteReader();
}
catch
{
Exception e = new Exception();
this._deleteOK = false;
this._deletionMessage.Append(e.Message + " Inner Exception= " + e.InnerException);
throw e;
}
finally
{
command.Dispose();
connection.Close();
}
return(this.DeleteOK);
}
/// <summary>
/// Saves the Phase.
/// </summary>
/// <returns>Phase objects</returns>
public Phase SavePhase()
{
SqlDataReader result;
DatabaseConnection dbconn = new DatabaseConnection();
SqlCommand command = new SqlCommand();
SqlConnection connection = new SqlConnection(dbconn.SQLSEVERConnString);
try
{
connection.Open();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "InsertUpdate_Phase";
command.Parameters.Add(dbconn.GenerateParameterObj("@PhaseID", SqlDbType.Int, PhaseID.ToString(), 0));
command.Parameters.Add(dbconn.GenerateParameterObj("@PhaseName", SqlDbType.VarChar, PhaseName.ToString(), 50));
result = command.ExecuteReader();
result.Read();
SetReaderToObject(ref result);
}
catch
{
Exception e = new Exception();
this._insertUpdateOK = false;
this._insertUpdateMessage.Append(e.Message + " Inner Exception= " + e.InnerException);
throw e;
}
finally
{
command.Dispose();
connection.Close();
}
return(this);
}
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));
}
public PhaseNode(PhaseID id)
{
this.phaseId = id;
}
