public int DeleteNotifications(string categories, int maxCount, DateTime toDate) { using (var connection = Context.CreateConnection()) { connection.Open(); using (var command = connection.CreateCommand()) { command.CommandTimeout = 0; var query = string.Format( @"DELETE FROM [dbo].[NotificationsHttp] WHERE NotificationId IN (SELECT Id FROM [dbo].[Notifications] WHERE EventId IN (" + EventsSubQuery + @")) DELETE FROM [dbo].[Notifications] WHERE EventId IN (" + EventsSubQuery + ")", maxCount, categories); command.CommandText = query; var parameter = command.CreateParameter(); parameter.ParameterName = "@ActualDate"; parameter.Value = toDate; command.Parameters.Add(parameter); return(SqlCommandHelper.ExecuteNonQuery(command)); } } }
public int UpdateMetricsHistory(string categories, int maxCount, DateTime toDate) { using (var connection = Context.CreateConnection()) { connection.Open(); using (var command = connection.CreateCommand()) { command.CommandTimeout = 0; var query = string.Format( @"UPDATE [dbo].[MetricHistory] SET StatusEventId = NULL WHERE StatusEventId IN (" + EventsSubQuery + ")", maxCount, categories); command.CommandText = query; var parameter = command.CreateParameter(); parameter.ParameterName = "@ActualDate"; parameter.Value = toDate; command.Parameters.Add(parameter); return(SqlCommandHelper.ExecuteNonQuery(command)); } } }
public int DeleteEventStatuses(string categories, int maxCount, DateTime toDate) { var count = 0; using (var connection = Context.CreateConnection()) { connection.Open(); using (var command = connection.CreateCommand()) { command.CommandTimeout = 0; var query = string.Format( @"DELETE FROM [dbo].[EventStatuses] WHERE EventId IN (" + EventsSubQuery + @")", maxCount, categories); command.CommandText = query; var parameter = command.CreateParameter(); parameter.ParameterName = "@ActualDate"; parameter.Value = toDate; command.Parameters.Add(parameter); count += SqlCommandHelper.ExecuteNonQuery(command); } using (var command = connection.CreateCommand()) { command.CommandTimeout = 0; var query = string.Format( @"DELETE FROM [dbo].[EventStatuses] WHERE StatusId IN (" + EventsSubQuery + ")", maxCount, categories); command.CommandText = query; var parameter = command.CreateParameter(); parameter.ParameterName = "@ActualDate"; parameter.Value = toDate; command.Parameters.Add(parameter); count += SqlCommandHelper.ExecuteNonQuery(command); } } return(count); }
public void DeleteBySubscriptionId(Guid subscriptionId) { using (var connection = Context.CreateConnection()) { connection.Open(); using (var command = connection.CreateCommand()) { command.CommandTimeout = 0; var query = @" DELETE FROM [dbo].[LastComponentNotifications] WHERE NotificationId IN ( SELECT Id FROM [dbo].[Notifications] WHERE SubscriptionId = @SubscriptionId) DELETE FROM [dbo].[NotificationsHttp] WHERE NotificationId IN ( SELECT Id FROM [dbo].[Notifications] WHERE SubscriptionId = @SubscriptionId) DELETE FROM [dbo].[Notifications] WHERE SubscriptionId = @SubscriptionId"; command.CommandText = query; var parameter = command.CreateParameter(); parameter.ParameterName = "@SubscriptionId"; parameter.Value = subscriptionId; command.Parameters.Add(parameter); SqlCommandHelper.ExecuteNonQuery(command); } } }
/// <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; } }
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">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; } }