public async Task InsertSampleData()
{
await Task.Run(async() =>
{
_Context.Database.ExecuteSqlCommand(@"
CREATE PROCEDURE dbo.DeleteSecuritiesAndExchanges
AS
BEGIN
BEGIN TRANSACTION
BEGIN TRY
DELETE FROM Position;
DELETE FROM Stock;
DELETE FROM MutualFund;
DELETE FROM Exchange;
DELETE FROM MarketIndex;
COMMIT TRANSACTION
SELECT 0
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION
SELECT -1
END CATCH
END
");
_Context.Database.ExecuteSqlCommand(@"
CREATE PROCEDURE dbo.DeleteAccounts
AS
BEGIN
BEGIN TRANSACTION
BEGIN TRY
DELETE FROM [Order];
DELETE FROM BrokerageAccount;
DELETE FROM Customer;
COMMIT TRANSACTION
SELECT 0
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION
SELECT -1
END CATCH
END
" );
await _SecurityRepository.InsertSecurityDataAsync();
await _MarketsAndNewsRepository.InsertMarketDataAsync();
await _AccountRepository.CreateCustomerAsync();
await _AccountRepository.CreateAccountPositionsAsync();
});
}
public async Task InsertSampleData()
{
await Task.Run(async() =>
{
/*
* Removing so the app works with Sqlite
*
* var deleteSecuritiesExchanges = @"
* CREATE PROCEDURE dbo.DeleteSecuritiesAndExchanges
*
* AS
* BEGIN
*
* BEGIN TRANSACTION
* BEGIN TRY
* DELETE FROM Positions;
* DELETE FROM Stocks;
* DELETE FROM MutualFunds;
* DELETE FROM Exchanges;
* DELETE FROM MarketIndexes;
* COMMIT TRANSACTION
* SELECT 0
* END TRY
* BEGIN CATCH
* ROLLBACK TRANSACTION
* SELECT -1
* END CATCH
*
* END
* ";
*
* var deleteAccounts = @"
* CREATE PROCEDURE dbo.DeleteAccounts
*
* AS
* BEGIN
*
* BEGIN TRANSACTION
* BEGIN TRY
* DELETE FROM Orders;
* DELETE FROM BrokerageAccounts;
* DELETE FROM Customers;
* COMMIT TRANSACTION
* SELECT 0
* END TRY
* BEGIN CATCH
* ROLLBACK TRANSACTION
* SELECT -1
* END CATCH
* END
* ";
*/
using (var connection = _Context.Database.GetDbConnection())
{
connection.Open();
/*
* using (var command = connection.CreateCommand())
* {
* command.CommandText = deleteSecuritiesExchanges;
* command.ExecuteNonQuery();
*
* command.CommandText = deleteAccounts;
* command.ExecuteNonQuery();
* }
*/
await _SecurityRepository.InsertSecurityDataAsync();
await _MarketsAndNewsRepository.InsertMarketDataAsync();
await _AccountRepository.CreateCustomerAsync();
await _AccountRepository.CreateAccountPositionsAsync();
}
});
}
public async Task InsertSampleData()
{
await Task.Run(async() =>
{
var deleteSecuritiesExchanges = @"
CREATE PROCEDURE dbo.DeleteSecuritiesAndExchanges
AS
BEGIN
BEGIN TRANSACTION
BEGIN TRY
DELETE FROM Positions;
DELETE FROM Stocks;
DELETE FROM MutualFunds;
DELETE FROM Exchanges;
DELETE FROM MarketIndexes;
COMMIT TRANSACTION
SELECT 0
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION
SELECT -1
END CATCH
END
";
var deleteAccounts = @"
CREATE PROCEDURE dbo.DeleteAccounts
AS
BEGIN
BEGIN TRANSACTION
BEGIN TRY
DELETE FROM Orders;
DELETE FROM BrokerageAccounts;
DELETE FROM Customers;
COMMIT TRANSACTION
SELECT 0
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION
SELECT -1
END CATCH
END
" ;
using (var connection = _Context.Database.GetDbConnection())
{
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = deleteSecuritiesExchanges;
command.ExecuteNonQuery();
command.CommandText = deleteAccounts;
command.ExecuteNonQuery();
}
await _SecurityRepository.InsertSecurityDataAsync();
await _MarketsAndNewsRepository.InsertMarketDataAsync();
await _AccountRepository.CreateCustomerAsync();
await _AccountRepository.CreateAccountPositionsAsync();
}
});
}