Exemple #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            var type    = Request.QueryString["type"];
            var success = true;

            bool.TryParse(Request.QueryString["success"], out success);
            this.lblRequestedAction.Text = "Requested Action:" + type;

            var    webApiHostName         = Microsoft.Azure.CloudConfigurationManager.GetSetting("webapihostname");
            string UrlTestWebApiGetCall   = string.Format(UrlTestWebApiGetCallTemplate, webApiHostName);
            string UrlWhichThrowException = string.Format(UrlWhichThrowExceptionFormat, webApiHostName);

            var ingestionhostname = Microsoft.Azure.CloudConfigurationManager.GetSetting("ingestionhostname");

            TelemetryConfiguration.Active.TelemetryChannel.EndpointAddress = string.Format(EndPointAddressFormat, ingestionhostname);

            var sqlhostname = Microsoft.Azure.CloudConfigurationManager.GetSetting("sqlhostname");

            LocalDbConnectionString = string.Format(ConnectionStringFormat, sqlhostname);

            try
            {
                switch (type)
                {
                // A bit hacky way to enable collect application logs. This is temporary until actual
                // etw listener can be installed inside docker itself separate from the app.
                case "etw":
                    if (etwEnabled)
                    {
                        break;
                    }


                    string levelString = "Error";
                    try {
                        levelString = Request.QueryString["level"];
                    }
                    catch (Exception) { }

                    EventLevel level = EventLevel.Error;
                    switch (levelString)
                    {
                    case "Verbose": level = EventLevel.Verbose; break;

                    case "Informational": level = EventLevel.Informational; break;

                    case "Warning": level = EventLevel.Warning; break;

                    case "Error": level = EventLevel.Error; break;

                    case "Critical": level = EventLevel.Critical; break;
                    }
                    new Thread(() =>
                    {
                        try
                        {
                            Thread.CurrentThread.IsBackground = true;
                            DiagnosticsEventListener dd       = new DiagnosticsEventListener(level);
                        }
                        catch (Exception)
                        {
                        }
                    }).Start();
                    etwEnabled = true;
                    TelemetryConfiguration.Active.TelemetryChannel.Flush();
                    Thread.Sleep(1000);
                    break;

                case "etwlogs":
                    string MyDirectoryPath = "c:\\mylogs";
                    string filename        = "logs.txt";

                    using (TextReader reader = new StreamReader(File.OpenRead(Path.Combine(MyDirectoryPath, filename))))
                    {
                        Response.Write(reader.ReadToEnd());
                    }

                    File.Delete(Path.Combine(MyDirectoryPath, filename));

                    break;

                case "flush":
                    TelemetryConfiguration.Active.TelemetryChannel.Flush();
                    Thread.Sleep(3000);
                    break;

                case "httpsyncgoogle":
                    HttpHelpers.MakeHttpCallSync(UrlGoogle);
                    break;

                case "httpsync":
                    HttpHelpers.MakeHttpCallSync(UrlTestWebApiGetCall);
                    break;

                case "httpasynchttpclient":
                    HttpHelpers.MakeHttpCallUsingHttpClient(UrlTestWebApiGetCall);
                    break;

                case "httppost":
                    HttpHelpers.MakeHttpPostCallSync(UrlTestWebApiGetCall);
                    break;

                case "httpfailedwithexception":
                    HttpHelpers.MakeHttpCallUsingHttpClient(UrlWhichThrowException);
                    break;

                case "httpfailedwithinvaliddns":
                    HttpHelpers.MakeHttpCallUsingHttpClient(UrlWithNonexistentHostName);
                    break;

                case "httpasync1":
                    HttpHelpers.MakeHttpCallAsync1(UrlTestWebApiGetCall);
                    break;

                case "failedhttpasync1":
                    HttpHelpers.MakeHttpCallAsync1(UrlWhichThrowException);
                    break;

                case "httpasync2":
                    HttpHelpers.MakeHttpCallAsync2(UrlTestWebApiGetCall);
                    break;

                case "failedhttpasync2":
                    HttpHelpers.MakeHttpCallAsync2(UrlWhichThrowException);
                    break;

                case "httpasync3":
                    HttpHelpers.MakeHttpCallAsync3(UrlTestWebApiGetCall);
                    break;

                case "failedhttpasync3":
                    HttpHelpers.MakeHttpCallAsync3(UrlWhichThrowException);
                    break;

                case "httpasync4":
                    HttpHelpers.MakeHttpCallAsync4(UrlTestWebApiGetCall);
                    break;

                case "failedhttpasync4":
                    HttpHelpers.MakeHttpCallAsync4(UrlWhichThrowException);
                    break;

                case "httpasyncawait1":
                    HttpHelpers.MakeHttpCallAsyncAwait1(UrlTestWebApiGetCall);
                    break;

                case "failedhttpasyncawait1":
                    HttpHelpers.MakeHttpCallAsyncAwait1(UrlWhichThrowException);
                    break;

                case "azuresdkblob":
                    string containerName = "rddtest";
                    string blobName      = "testblob";
                    try
                    {
                        containerName = Request.QueryString["containerName"];
                        blobName      = Request.QueryString["blobName"];
                    }
                    catch (Exception) { }
                    HttpHelpers.MakeAzureCallToWriteToBlobWithSdk(containerName, blobName);
                    HttpHelpers.MakeAzureCallToReadBlobWithSdk(containerName, blobName);
                    break;

                case "azuresdkqueue":
                    HttpHelpers.MakeAzureCallToWriteQueueWithSdk();
                    break;

                case "azuresdktable":
                    string tableName = "people";
                    try
                    {
                        tableName = Request.QueryString["tablename"];
                    }
                    catch (Exception) { }
                    HttpHelpers.MakeAzureCallToWriteTableWithSdk(tableName);
                    HttpHelpers.MakeAzureCallToReadTableWithSdk(tableName);
                    break;

                case "ExecuteReaderAsync":
                    SqlCommandHelper.ExecuteReaderAsync(LocalDbConnectionString, (success == true)
                                        ? SqlQuerySuccess
                                        : SqlQueryError);
                    break;

                case "ExecuteScalarAsync":
                    SqlCommandHelper.ExecuteScalarAsync(LocalDbConnectionString, (success == true)
                                        ? SqlQuerySuccess
                                        : SqlQueryError);
                    break;

                case "ExecuteReaderStoredProcedureAsync":
                    string storedProcedureName = "GetTopTenMessages";
                    try
                    {
                        storedProcedureName = Request.QueryString["storedProcedureName"];
                    }
                    catch (Exception) { }
                    SqlCommandHelper.ExecuteReaderAsync(LocalDbConnectionString, storedProcedureName, CommandType.StoredProcedure);
                    break;

                case "TestExecuteReaderTwice":
                    SqlCommandHelper.TestExecuteReaderTwice(LocalDbConnectionString, (success == true)
                                        ? SqlQuerySuccess
                                        : SqlQueryError);
                    break;

                case "BeginExecuteReader0":
                    SqlCommandHelper.BeginExecuteReader(LocalDbConnectionString, (success == true)
                                        ? SqlQuerySuccess
                                        : SqlQueryError, 0);
                    break;

                case "BeginExecuteReader1":
                    SqlCommandHelper.BeginExecuteReader(LocalDbConnectionString, (success == true)
                                        ? SqlQuerySuccess
                                        : SqlQueryError, 1);
                    break;

                case "BeginExecuteReader2":
                    SqlCommandHelper.BeginExecuteReader(LocalDbConnectionString, (success == true)
                                        ? SqlQuerySuccess
                                        : SqlQueryError, 2);
                    break;

                case "BeginExecuteReader3":
                    SqlCommandHelper.BeginExecuteReader(LocalDbConnectionString, (success == true)
                                        ? SqlQuerySuccess
                                        : SqlQueryError, 3);
                    break;

                case "TestExecuteReaderTwiceInSequence":
                    SqlCommandHelper.TestExecuteReaderTwiceInSequence(LocalDbConnectionString, (success == true)
                                        ? SqlQuerySuccess
                                        : SqlQueryError);
                    break;

                case "TestExecuteReaderTwiceWithTasks":
                    SqlCommandHelper.AsyncExecuteReaderInTasks(LocalDbConnectionString, (success == true)
                                        ? SqlQuerySuccess
                                        : SqlQueryError);
                    break;

                case "ExecuteNonQueryAsync":
                    SqlCommandHelper.ExecuteNonQueryAsync(LocalDbConnectionString, (success == true)
                                        ? SqlQuerySuccess
                                        : SqlQueryError);
                    break;

                case "BeginExecuteNonQuery0":
                    SqlCommandHelper.BeginExecuteNonQuery(LocalDbConnectionString, (success == true)
                                        ? SqlQuerySuccess
                                        : SqlQueryError, 0);
                    break;

                case "BeginExecuteNonQuery2":
                    SqlCommandHelper.BeginExecuteNonQuery(LocalDbConnectionString, (success == true)
                                        ? SqlQuerySuccess
                                        : SqlQueryError, 2);
                    break;

                case "ExecuteXmlReaderAsync":
                    SqlQuerySuccess += " FOR XML AUTO";
                    SqlCommandHelper.ExecuteXmlReaderAsync(LocalDbConnectionString, (success == true)
                                        ? SqlQuerySuccess
                                        : SqlQueryError);
                    break;

                case "BeginExecuteXmlReader":
                    SqlQuerySuccess += " FOR XML AUTO";
                    SqlCommandHelper.BeginExecuteXmlReader(LocalDbConnectionString, (success == true)
                                        ? SqlQuerySuccess
                                        : SqlQueryError);
                    break;

                case "SqlCommandExecuteScalar":
                    SqlCommandHelper.ExecuteScalar(LocalDbConnectionString, (success == true)
                                        ? SqlQuerySuccess
                                        : SqlQueryError);
                    break;

                case "SqlCommandExecuteNonQuery":
                    SqlCommandHelper.ExecuteNonQuery(LocalDbConnectionString, (success == true)
                                        ? SqlQuerySuccess
                                        : SqlQueryError);
                    break;

                case "SqlCommandExecuteReader0":
                    SqlCommandHelper.ExecuteReader(LocalDbConnectionString, (success == true)
                                        ? SqlQuerySuccess
                                        : SqlQueryError, 0);
                    break;

                case "SqlCommandExecuteReader1":
                    SqlCommandHelper.ExecuteReader(LocalDbConnectionString, (success == true)
                                        ? SqlQuerySuccess
                                        : SqlQueryError, 1);
                    break;

                case "SqlCommandExecuteXmlReader":
                    SqlQuerySuccess += " FOR XML AUTO";
                    SqlCommandHelper.ExecuteXmlReader(LocalDbConnectionString, (success == true)
                                        ? SqlQuerySuccess
                                        : SqlQueryError);
                    break;

                case "SqlConnectionOpen":
                    SqlCommandHelper.OpenConnection(LocalDbConnectionString);
                    break;

                case "SqlConnectionOpenFailedInvalidAccount":
                    SqlCommandHelper.OpenConnection(InvalidAccountConnectionString);
                    break;

                case "SqlConnectionOpenFailedInvalidServer":
                    SqlCommandHelper.OpenConnection(InvalidServerConnectionString);
                    break;

                case "SqlConnectionOpenAsync":
                    SqlCommandHelper.OpenConnectionAsync(LocalDbConnectionString);
                    break;

                case "SqlConnectionOpenAsyncFailedInvalidAccount":
                    SqlCommandHelper.OpenConnectionAsync(InvalidAccountConnectionString);
                    break;

                case "SqlConnectionOpenAsyncFailedInvalidServer":
                    SqlCommandHelper.OpenConnectionAsync(InvalidServerConnectionString);
                    break;

                case "SqlConnectionOpenAsyncAwait":
                    SqlCommandHelper.OpenConnectionAsyncAwait(LocalDbConnectionString);
                    break;

                case "SqlConnectionOpenAsyncAwaitFailedInvalidAccount":
                    SqlCommandHelper.OpenConnectionAsyncAwait(InvalidAccountConnectionString);
                    break;

                case "SqlConnectionOpenAsyncAwaitFailedInvalidServer":
                    SqlCommandHelper.OpenConnectionAsyncAwait(InvalidServerConnectionString);
                    break;

                default:
                    throw new ArgumentOutOfRangeException("Request Parameter type is not mapped to an action: " + type);
                }
            }
            catch (Exception ex)
            {
                this.lblRequestedAction.Text = this.lblRequestedAction.Text + "  Exception occured: " + ex;
            }

            TelemetryConfiguration.Active.TelemetryChannel.Flush();
        }
        /// <summary>
        /// ExternalCalls page to make remote dependency calls.
        /// </summary>
        /// <param name="sender">Sender object.</param>
        /// <param name="e">Argument object.</param>
        protected void Page_Load(object sender, EventArgs e)
        {
            var type     = Request.QueryString["type"];
            var countStr = Request.QueryString["count"];
            var success  = true;

            bool.TryParse(Request.QueryString["success"], out success);
            string sqlQueryTouse = (success == true) ? ValidSqlQueryToApmDatabase : InvalidSqlQueryToApmDatabase;
            var    count         = 1;

            try
            {
                count = int.Parse(countStr);
            }
            catch (Exception)
            {
                // Dont care about this
            }

            this.lblRequestedAction.Text = "Requested Action:" + type;

            try
            {
                switch (type)
                {
                case "http":
                    HttpHelper40.MakeHttpCallSync(count, "bing");
                    break;

                case "httpClient":
                    HttpHelper40.MakeHttpCallUsingHttpClient("http://www.google.com/404");
                    break;

                case "httppost":
                    HttpHelper40.MakeHttpPostCallSync(count, "bing");
                    break;

                case "failedhttp":
                    HttpHelper40.MakeHttpCallSyncFailed(count);
                    break;

                case "httpasync1":
                    HttpHelper40.MakeHttpCallAsync1(count, "bing");
                    break;

                case "failedhttpasync1":
                    HttpHelper40.MakeHttpCallAsync1Failed(count);
                    break;

                case "httpasync2":
                    HttpHelper40.MakeHttpCallAsync2(count, "bing");
                    break;

                case "failedhttpasync2":
                    HttpHelper40.MakeHttpCallAsync2Failed(count);
                    break;

                case "httpasync3":
                    HttpHelper40.MakeHttpCallAsync3(count, "bing");
                    break;

                case "failedhttpasync3":
                    HttpHelper40.MakeHttpCallAsync3Failed(count);
                    break;

                case "httpasync4":
                    HttpHelper40.MakeHttpCallAsync4(count, "bing");
                    break;

                case "failedhttpasync4":
                    HttpHelper40.MakeHttpCallAsync4Failed(count);
                    break;

                case "httpasyncawait1":
                    HttpHelper45.MakeHttpCallAsyncAwait1(count, "bing");
                    break;

                case "failedhttpasyncawait1":
                    HttpHelper45.MakeHttpCallAsyncAwait1Failed(count);
                    break;

                case "sql":
                    this.MakeSQLCallSync(count);
                    break;

                case "azuresdkblob":
                    HttpHelper40.MakeAzureCallToReadBlobWithSdk(count);
                    break;

                case "azuresdkqueue":
                    HttpHelper40.MakeAzureCallToWriteQueueWithSdk(count);
                    break;

                case "azuresdktable":
                    HttpHelper40.MakeAzureCallToWriteTableWithSdk(count);
                    HttpHelper40.MakeAzureCallToReadTableWithSdk(count);
                    break;

                case "ExecuteReaderAsync":
                    SqlCommandHelper.ExecuteReaderAsync(ConnectionString, sqlQueryTouse);
                    break;

                case "ExecuteScalarAsync":
                    SqlCommandHelper.ExecuteScalarAsync(ConnectionString, sqlQueryTouse);
                    break;

                case "ExecuteReaderStoredProcedureAsync":
                    this.ExecuteReaderStoredProcedureAsync();
                    break;

                case "TestExecuteReaderTwice":
                    SqlCommandHelper.TestExecuteReaderTwice(ConnectionString, sqlQueryTouse);
                    break;

                case "BeginExecuteReader0":
                    SqlCommandHelper.BeginExecuteReader(ConnectionString, sqlQueryTouse, 0);
                    break;

                case "BeginExecuteReader1":
                    SqlCommandHelper.BeginExecuteReader(ConnectionString, sqlQueryTouse, 1);
                    break;

                case "BeginExecuteReader2":
                    SqlCommandHelper.BeginExecuteReader(ConnectionString, sqlQueryTouse, 2);
                    break;

                case "BeginExecuteReader3":
                    SqlCommandHelper.BeginExecuteReader(ConnectionString, sqlQueryTouse, 3);
                    break;

                case "TestExecuteReaderTwiceInSequence":
                    SqlCommandHelper.TestExecuteReaderTwiceInSequence(ConnectionString, sqlQueryTouse);
                    break;

                case "TestExecuteReaderTwiceWithTasks":
                    SqlCommandHelper.AsyncExecuteReaderInTasks(ConnectionString, sqlQueryTouse);
                    break;

                case "ExecuteNonQueryAsync":
                    SqlCommandHelper.ExecuteNonQueryAsync(ConnectionString, sqlQueryTouse);
                    break;

                case "BeginExecuteNonQuery0":
                    SqlCommandHelper.BeginExecuteNonQuery(ConnectionString, sqlQueryTouse, 0);
                    break;

                case "BeginExecuteNonQuery2":
                    SqlCommandHelper.BeginExecuteNonQuery(ConnectionString, sqlQueryTouse, 2);
                    break;

                case "ExecuteXmlReaderAsync":
                    sqlQueryTouse += " FOR XML AUTO";
                    SqlCommandHelper.ExecuteXmlReaderAsync(ConnectionString, sqlQueryTouse);
                    break;

                case "BeginExecuteXmlReader":
                    SqlCommandHelper.BeginExecuteXmlReader(ConnectionString, sqlQueryTouse);
                    break;

                case "SqlCommandExecuteScalar":
                    sqlQueryTouse = (success == true)
                                        ? ValidSqlQueryCountToApmDatabase
                                        : InvalidSqlQueryToApmDatabase;
                    SqlCommandHelper.ExecuteScalar(ConnectionString, sqlQueryTouse);
                    break;

                case "SqlCommandExecuteNonQuery":
                    sqlQueryTouse = (success == true)
                               ? ValidSqlQueryCountToApmDatabase
                               : InvalidSqlQueryToApmDatabase;
                    SqlCommandHelper.ExecuteNonQuery(ConnectionString, sqlQueryTouse);
                    break;

                case "SqlCommandExecuteReader0":
                    SqlCommandHelper.ExecuteReader(ConnectionString, sqlQueryTouse, 0);
                    break;

                case "SqlCommandExecuteReader1":
                    SqlCommandHelper.ExecuteReader(ConnectionString, sqlQueryTouse, 1);
                    break;

                case "SqlCommandExecuteXmlReader":
                    sqlQueryTouse += " FOR XML AUTO";
                    SqlCommandHelper.ExecuteXmlReader(ConnectionString, sqlQueryTouse);
                    break;

                default:
                    throw new ArgumentOutOfRangeException("Request Parameter type is not mapped to an action: " + type);
                }

                this.lblResult.Text = "Requested action completed successfully.";
                Response.Write(QueryToExecuteLabel + sqlQueryTouse);
            }
            catch (Exception ex)
            {
                Response.Write(QueryToExecuteLabel + sqlQueryTouse);
                this.lblResult.Text = "The following error occured while attempting to perform requested action" + ex;
            }
        }
        /// <summary>
        /// ExternalCalls page to make remote dependency calls
        /// </summary>
        /// <param name="sender">sender object</param>
        /// <param name="e">e object</param>
        protected void Page_Load(object sender, EventArgs e)
        {
            var type     = Request.QueryString["type"];
            var countStr = Request.QueryString["count"];
            var success  = true;

            bool.TryParse(Request.QueryString["success"], out success);
            string sqlQueryTouse = (success == true) ? ValidSqlQueryToApmDatabase : InvalidSqlQueryToApmDatabase;
            var    count         = 1;

            try
            {
                count = int.Parse(countStr);
            }
            catch (Exception)
            {
                // Dont care about this
            }

            this.lblRequestedAction.Text = "Requested Action:" + type;

            try
            {
                switch (type)
                {
                case "http":
                    HttpHelper40.MakeHttpCallSync(count, "bing");
                    break;

                case "failedhttp":
                    HttpHelper40.MakeHttpCallSyncFailed(count);
                    break;

                case "httpasync1":
                    HttpHelper40.MakeHttpCallAsync1(count, "bing");
                    break;

                case "failedhttpasync1":
                    HttpHelper40.MakeHttpCallAsync1Failed(count);
                    break;

                case "httpasync2":
                    HttpHelper40.MakeHttpCallAsync2(count, "bing");
                    break;

                case "failedhttpasync2":
                    HttpHelper40.MakeHttpCallAsync2Failed(count);
                    break;

                case "httpasync3":
                    HttpHelper40.MakeHttpCallAsync3(count, "bing");
                    break;

                case "failedhttpasync3":
                    HttpHelper40.MakeHttpCallAsync3Failed(count);
                    break;

                case "httpasync4":
                    HttpHelper40.MakeHttpCallAsync4(count, "bing");
                    break;

                case "failedhttpasync4":
                    HttpHelper40.MakeHttpCallAsync4Failed(count);
                    break;

                case "httpasyncawait1":
                    HttpHelper45.MakeHttpCallAsyncAwait1(count, "bing");
                    break;

                case "failedhttpasyncawait1":
                    HttpHelper45.MakeHttpCallAsyncAwait1Failed(count);
                    break;

                case "sql":
                    this.MakeSQLCallSync(count);
                    break;

                case "azuresdk":
                    HttpHelper40.MakeAzureBlobCalls(count);
                    break;

                case "ExecuteReaderAsync":
                    SqlCommandHelper.ExecuteReaderAsync(ConnectionString, sqlQueryTouse);
                    break;

                case "ExecuteScalarAsync":
                    sqlQueryTouse = (success == true)
                                        ? "SELECT count(*) FROM apm.[Database]"
                                        : "SELECT count(*) FROM apm.[Database1212121]";
                    SqlCommandHelper.ExecuteScalarAsync(ConnectionString, sqlQueryTouse);
                    break;

                case "ExecuteReaderStoredProcedureAsync":
                    this.ExecuteReaderStoredProcedureAsync();
                    break;

                case "TestExecuteReaderTwice":
                    SqlCommandHelper.TestExecuteReaderTwice(ConnectionString, sqlQueryTouse);
                    break;

                case "BeginExecuteReader":
                    SqlCommandHelper.BeginExecuteReader(ConnectionString, sqlQueryTouse);
                    break;

                case "TestExecuteReaderTwiceInSequence":
                    SqlCommandHelper.TestExecuteReaderTwiceInSequence(ConnectionString, sqlQueryTouse);
                    break;

                case "TestExecuteReaderTwiceWithTasks":
                    SqlCommandHelper.AsyncExecuteReaderInTasks(ConnectionString, sqlQueryTouse);
                    break;

                case "ExecuteNonQueryAsync":
                    SqlCommandHelper.ExecuteNonQueryAsync(ConnectionString, sqlQueryTouse);
                    break;

                case "BeginExecuteNonQuery":
                    SqlCommandHelper.BeginExecuteNonQuery(ConnectionString, sqlQueryTouse);
                    break;

                case "ExecuteXmlReaderAsync":
                    sqlQueryTouse = (success == true)
                                        ? "SELECT TOP 2 * FROM apm.[Database] FOR XML AUTO"
                                        : "SELECT TOP 2 * FROM apm.[Database12121212] FOR XML AUTO";
                    SqlCommandHelper.ExecuteXmlReaderAsync(ConnectionString, sqlQueryTouse);
                    break;

                case "BeginExecuteXmlReader":
                    SqlCommandHelper.BeginExecuteXmlReader(ConnectionString, sqlQueryTouse);
                    break;

                case "SqlCommandExecuteScalar":
                    sqlQueryTouse = (success == true)
                                        ? ValidSqlQueryCountToApmDatabase
                                        : InvalidSqlQueryToApmDatabase;
                    SqlCommandHelper.ExecuteScalar(ConnectionString, sqlQueryTouse);
                    break;

                case "SqlCommandExecuteNonQuery":
                    sqlQueryTouse = (success == true)
                               ? ValidSqlQueryCountToApmDatabase
                               : InvalidSqlQueryToApmDatabase;
                    SqlCommandHelper.ExecuteNonQuery(ConnectionString, sqlQueryTouse);
                    break;

                case "SqlCommandExecuteReader":
                    SqlCommandHelper.ExecuteReader(ConnectionString, sqlQueryTouse);
                    break;

                case "SqlCommandExecuteXmlReader":
                    sqlQueryTouse = (success == true)
                                  ? "SELECT TOP 2 * FROM apm.[Database] FOR XML AUTO"
                                  : "SELECT TOP 2 * FROM apm.[Database12121212] FOR XML AUTO";
                    SqlCommandHelper.ExecuteXmlReader(ConnectionString, sqlQueryTouse);
                    break;

                default:
                    throw new ArgumentOutOfRangeException("Request Parameter type is not mapped to an action: " + type);
                }

                this.lblResult.Text = "Requested action completed successfully.";
            }
            catch (Exception ex)
            {
                this.lblResult.Text = "The following error occured while attempting to perform requested action" + ex;
            }
        }