/// <summary> /// Handler for the CodeActivity7 Activity’s ExecuteEvent event. /// </summary> public void CodeActivity7_OnExecuteEvent(object sender, STActivityBaseEventArgs args) { // initialize output parameter with default values this.CodeActivity7.Output.Out_QParameter = this.CodeActivity7.Input.QParameter; this.CodeActivity7.Output.Out_SQLParameter = this.CodeActivity7.Input.SQLQueryToValidateData; //Check database connection and retrieve reocrds from database. OpenDBConnection(this.CodeActivity7.Input.DBConnectionString); //Verify whether SQLQuery exist if (this.CodeActivity7.Input.SQLToFetchData.Length > 0) { //Fetch the dymanic value for customising the URL from the database dataRows = GetRecordsFromDB(this.CodeActivity7.Input.SQLToFetchData, this.CodeActivity7); rowObject = dataRows[0].ItemArray; //Verify data columns exist before fetching data if (rowObject.Length > 0) { firstDynamicData = rowObject[0].ToString(); //verify whether second data column exist if (rowObject.Length > 1) { secondDynamicData = rowObject[1].ToString(); } this.CodeActivity7.Output.Out_QParameter = this.CodeActivity7.Output.Out_QParameter.Replace("XXX", firstDynamicData).Replace("YYY", secondDynamicData); this.CodeActivity7.Output.Out_SQLParameter = this.CodeActivity7.Input.SQLQueryToValidateData.Replace("XXX", firstDynamicData).Replace("YYY", secondDynamicData); } } //Close DB connection CloseDBConnection(); }
/// <summary> /// Handler for the CodeActivity4 Activity’s ExecuteEvent event. /// </summary> /// <param name=\"sender\">The activity object that raised the ExecuteEvent event.</param> /// <param name=\"args\">The event arguments passed to the activity.</param> /// Use this.CodeActivity4 to access the CodeActivity4 Activity's context, including input and output properties. public void CodeActivity4_OnExecuteEvent(object sender, STActivityBaseEventArgs args) { var ActivityArguments = args.Activity.StepId.ToString(); this.CodeActivity4.Report("Overall report", ActivityArguments); var ActivityArguments2 = args.Activity.StepId.ToString(); this.CodeActivity4.Report("Overall report", ActivityArguments2); }
/// <summary> /// Handler for the Loop2 Activity’s Condition event. /// </summary> /// <param name=\"sender\">The activity object that raised the Condition event.</param> /// <param name=\"args\">The event arguments passed to the activity.</param> /// Use this.Loop2 to access the Loop2 Activity's context, including input and output properties. public bool Loop2_OnCondition(object sender, STActivityBaseEventArgs args) { bool isIterationStatusAvailable = true; // Assign iteration status depending on the load testing status if (Convert.ToBoolean(SwitchEnvironment27.IsLoadTestEnabled) == true) { isIterationStatusAvailable = false; } else { // Fetch the value of iteration numbers Loop2.NumberOfIterations = GetDataSource("MTC029").RowsCount; if (Loop2.CurrentIterationNumber > Loop2.NumberOfIterations - 1) { isIterationStatusAvailable = false; } } return(isIterationStatusAvailable); }
/// <summary> /// Handler for the CodeActivity21 Activity’s ExecuteEvent event. /// </summary> /// <param name=\"sender\">The activity object that raised the ExecuteEvent event.</param> /// <param name=\"args\">The event arguments passed to the activity.</param> /// Use this.CodeActivity21 to access the CodeActivity21 Activity's context, including input and output properties. public void CodeActivity21_OnExecuteEvent(object sender, STActivityBaseEventArgs args) { //Initialize checkArgsPoint object checkArgs = new CheckpointEventArgs(this.CodeActivity21); //open Database connection OpenDBConnection(this.CodeActivity21.Input.connectionString); //Get the record from the database datarowsMaster = GetRecords.GetRecordsFromDatabase(connection, command, dataAdapter, jenkinsHandle(this.SwitchEnvironment27.pEnvironment, this.CodeActivity21.Input.sqlQueryMaster, jenkinsDataSource)); //check record count CheckDataRowsCount(datarowsMaster.Count, this.CodeActivity21); // Get the Master customer Id this.CodeActivity21.Output.Mstr_Cust_Id = datarowsMaster[0].ItemArray[0].ToString(); //Replace placeholders in request body string requestBody = this.CodeActivity21.Input.requestBody.Replace("Master_Cust_Id_value", this.CodeActivity21.Output.Mstr_Cust_Id).ToString(); if (this.CodeActivity21.Input.caseType.ToUpper() == "MASTERANDBRANCH") { datarowsBranch = GetRecords.GetRecordsFromDatabase(connection, command, dataAdapter, jenkinsHandle(this.SwitchEnvironment27.pEnvironment, this.CodeActivity21.Input.sqlQueryBranch.Replace("mstr_cust_id_value", datarowsMaster[0].ItemArray[0].ToString()), jenkinsDataSource)); CheckDataRowsCount(datarowsBranch.Count, this.CodeActivity21); //Replace placeholders in request body requestBody = requestBody.Replace("Branch_Cust_Id_value", datarowsBranch[0].ItemArray[0].ToString().Split('*')[1]). Replace("Branch_Cust_Acct", datarowsBranch[0].ItemArray[0].ToString().Split('*')[0]); } this.CodeActivity21.Output.requestBodyOut = requestBody; //Close database connection CloseDBConnection(); }
/// <summary> /// Handler for the CodeActivity4 Activity’s ExecuteEvent event. /// </summary> /// <param name=\"sender\">The activity object that raised the ExecuteEvent event.</param> /// <param name=\"args\">The event arguments passed to the activity.</param> /// Use this.CodeActivity4 to access the CodeActivity4 Activity's context, including input and output properties. public void CodeActivity4_OnExecuteEvent(object sender, STActivityBaseEventArgs args) { //TODO: Add your code here... }
/// <summary> /// Handler for the StartActivity1 Activity’s BeforeExecution event. /// </summary> /// <param name=\"sender\">The activity object that raised the BeforeExecution event.</param> /// <param name=\"args\">The event arguments passed to the activity.</param> /// Use this.StartActivity1 to access the StartActivity1 Activity's context, including input and output properties. public void StartActivity1_OnBeforeExecution(object sender, STActivityBaseEventArgs args) { }
/// <summary> /// Handler for the ReportMessageActivity45 Activity’s AfterExecuteStepEvent event. /// </summary> /// <param name=\"sender\">The activity object that raised the AfterExecuteStepEvent event.</param> /// <param name=\"args\">The event arguments passed to the activity.</param> /// Use this.ReportMessageActivity45 to access the ReportMessageActivity45 Activity's context, including input and output properties. public void ReportMessageActivity45_OnAfterExecuteStepEvent(object sender, STActivityBaseEventArgs args) { //TODO: Add your code here... }
/// <summary> /// Handler for the FileWriteActivity27 Activity’s BeforeExecuteStepEvent event. /// </summary> /// <param name=\"sender\">The activity object that raised the BeforeExecuteStepEvent event.</param> /// <param name=\"args\">The event arguments passed to the activity.</param> /// Use this.FileWriteActivity27 to access the FileWriteActivity27 Activity's context, including input and output properties. public void FileWriteActivity27_OnBeforeExecuteStepEvent(object sender, STActivityBaseEventArgs args) { //TODO: Add your code here... }
/// <summary> /// Handler for the CodeActivity17 Activity’s ExecuteEvent event. /// </summary> /// <param name=\"sender\">The activity object that raised the ExecuteEvent event.</param> /// <param name=\"args\">The event arguments passed to the activity.</param> /// Use this.CodeActivity17 to access the CodeActivity17 Activity's context, including input and output properties. public void CodeActivity17_OnExecuteEvent(object sender, STActivityBaseEventArgs args) { if (SwitchEnvironment14.IsLoadTestEnabled != "true") { int docArrayElementCount = 0; checkArgs = new CheckpointEventArgs(this.CodeActivity17); //Get the response XMLString = this.RESTActivityV24.ResponseBody; //Create Deserialize object DeserializedXMLproductResponse = XMLString.DeserializeFromXMLInput <ProductResponse>(); //Customize the SQL Query for count customisedCountSqlQuery = "Select count(*) from (" + this.CodeActivity7.Output.Out_SQLParameter + ")"; //Customize the SQL Query customisedSqlQuery = this.CodeActivity7.Output.Out_SQLParameter; //opening the DB conenction OpenDBConnection(this.CodeActivity7.Input.DBConnectionString); //Get the record from the database record = GetRecord(customisedCountSqlQuery, customisedSqlQuery, this.CodeActivity17); //verify database records count checkArgs.Checkpoint.Assert.Equals("", DeserializedXMLproductResponse.RowsTotal.ToString(), record.RecordsCount.ToString(), "Records count"); //Verify product data foreach (Product doc_ProductNote in DeserializedXMLproductResponse.Products.Product) { //isRecordAvailable = false; foreach (Product2DTO recordNote in record.Product) { //Compare product Primary key if (doc_ProductNote.ProductId.ToString() == recordNote.productId) { string altCodes = sortString(recordNote.altCodes); //Verify productId AssertIfNotNull(checkArgs, doc_ProductNote.ProductId, recordNote.productId, "Product V2 productId: " + docArrayElementCount); //Verify productDesc AssertIfNotNull(checkArgs, doc_ProductNote.Description, recordNote.description, "Product V2 prodDesc: " + docArrayElementCount); //Verify discGroupId AssertIfNotNull(checkArgs, doc_ProductNote.DiscGroupId, recordNote.discGroupId, "Product V2 discGroupId: " + docArrayElementCount); //Verify discGroupDesc AssertIfNotNull(checkArgs, doc_ProductNote.DiscGroupDesc, recordNote.discGroupDesc, "Product V2 discGroupDesc: " + docArrayElementCount); //Verify linbuyId AssertIfNotNull(checkArgs, doc_ProductNote.LinebuyId, recordNote.linebuyId, "Product V2 linebuyId: " + docArrayElementCount); //Verify linebuyDesc AssertIfNotNull(checkArgs, doc_ProductNote.LinebuyDesc, recordNote.linebuyDesc, "Product V2 linebuyDesc: " + docArrayElementCount); //Verify altCode1 AssertIfNotNull(checkArgs, doc_ProductNote.Alt1Code, recordNote.alt1Code, "Product V2 altCode1: " + docArrayElementCount); //Verify altCodes AssertIfNotNull(checkArgs, sortString(doc_ProductNote.AltCodes.Trim()), sortString(recordNote.altCodes), "Product V2 altCodes: " + docArrayElementCount); //Verify altCodeType AssertIfNotNull(checkArgs, sortString(doc_ProductNote.AltCodeType.Trim()), sortString(recordNote.altCodeType), "Product V2 altCodeType: " + docArrayElementCount); break; } } docArrayElementCount++; } //closing the DB connection CloseDBConnection(); } }