public static string CreateSimulatedAccount(string userName, CreateSimulatedBrokerAccountInfo account)
{
switch (account.BrokerName)
{
case PoloniexBroker.BrokerName:
case LmaxLiveBroker.BrokerName:
case LmaxDemoBroker.BrokerName:
return($"{account.BrokerName} broker doesn't support create account");
case SimulatedMarginBroker.BrokerName:
return(SimulatedMarginBroker.CreateSimulatedAccount(userName, account));
case SimulatedExchangeBroker.BrokerName:
return(SimulatedExchangeBroker.CreateSimulatedAccount(userName, account));
default:
return($"No available broker {account.BrokerName}");
}
}
public CreateSimulatedBrokerAccountInfoItem(string brokerName)
{
Account = new CreateSimulatedBrokerAccountInfo(brokerName);
}
public static string CreateSimulatedAccount(string userName, CreateSimulatedBrokerAccountInfo account) => CreateSimulatedAccount(AccountTable, userName, account, false);
public static string CreateSimulatedAccount(string tableName, string userName, CreateSimulatedBrokerAccountInfo account, bool isMarginAccount) => DBSimulatedAccounts.CreateSimulatedAccount(ConnectionString, tableName, userName, account, isMarginAccount);
internal static DS.CreateSimulatedBrokerAccountInfo ToDsCreateSimulatedAccount(CreateSimulatedBrokerAccountInfo account)
{
return(new DS.CreateSimulatedBrokerAccountInfo
{
BrokerName = account.BrokerName,
AccountName = account.AccountName,
Currency = account.Currency,
Ballance = account.Ballance
});
}
public static string CreateSimulatedAccount(string connectionString, string table, string userName, CreateSimulatedBrokerAccountInfo account, bool isMarginAccount)
{
var command = $"Insert into [dbo].[{table}] Values (@user, @account, @curency, @balance, { (isMarginAccount ? "@margin, " : string.Empty) }@profit)";
using (var connection = new SqlConnection(connectionString))
{
using (var cmd = new SqlCommand(command, connection))
{
cmd.Parameters.AddWithValue("user", userName);
cmd.Parameters.AddWithValue("account", account.AccountName);
cmd.Parameters.AddWithValue("curency", account.Currency);
cmd.Parameters.AddWithValue("balance", account.Ballance);
if (isMarginAccount)
{
cmd.Parameters.AddWithValue("margin", 0);
}
cmd.Parameters.AddWithValue("profit", 0);
try
{
connection.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
return(ex.Message);
}
}
}
return(string.Empty);
}
