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