public void Contact()
{
var testRepo = new TestRepository();
//var nwmFirmalars = testRepo.GetNwmFirmalars();
//foreach (var nwmFirmalar in nwmFirmalars)
//{
// Console.WriteLine("id:" + nwmFirmalar.id);
//}
var item = new NwmCurrencyConfig();
item.currency_config_id = 99;
item.buy_at_price = 1;
item.buy_on_percent = 1;
item.order_timeout_in_hour = 1;
item.buyable = false;
item.currency_pair = "";
item.sell_at_price = 1;
item.sell_on_percent = 1;
item.sellable = false;
item.usable_balance_percent = 1;
item.bot_user = 3;
var id = testRepo.SaveOrUpdateNwmCurrencyConfig(item);
Console.WriteLine("id:" + id);
}
public NwmCurrencyConfig GetNwmCurrencyConfig(int currency_config_id)
{
var resultEntity = new NwmCurrencyConfig();
String commandText = @"SELECT * FROM polbot2.currency_config WHERE currency_config_id=@currency_config_id";
var parameterList = new List <MySqlParameter>();
parameterList.Add(new MySqlParameter("@currency_config_id", currency_config_id));
DataSet dataSet = MySqlHelper.ExecuteDataset(ConnectionString, commandText, parameterList.ToArray());
resultEntity = dataSet.Tables[0].ToList <NwmCurrencyConfig>().FirstOrDefault();
return(resultEntity);
}
public int SaveOrUpdateNwmCurrencyConfig(NwmCurrencyConfig item)
{
// CALL(<{ currency_config_id INT}>,
// <{ buy_at_price float}>,
// <{ buy_on_percent float}>,
// <{ order_timeout_in_hour float}>,
// <{ buyable bit(1)}>,
// <{ currency_pair varchar(255)}>,
// <{ sell_at_price float}>,
// <{ sell_on_percent float}>,
// <{ sellable bit(1)}>
//, <{ usable_balance_percent float}>,
// <{ bot_user int(11)}>);
// CALL `polbot2`.`sp_SaveOrUpdateCurrency_config`(<{currency_config_id INT}>, <{buy_at_price float}>, <{buy_on_percent float}>, <{order_timeout_in_hour float}>, <{buyable bit(1)}>, <{currency_pair varchar(255)}>, <{sell_at_price float}>, <{sell_on_percent float}>, <{sellable bit(1)}>, <{usable_balance_percent float}>, <{bot_user int(11)}>);
String commandText = @"CALL `polbot2`.`sp_SaveOrUpdateCurrency_config`(
@currency_config_id,
@buy_at_price,
@buy_on_percent,
@order_timeout_in_hour,
@buyable,
@currency_pair,
@sell_at_price,
@sell_on_percent,
@sellable,
@usable_balance_percent,
@bot_user);";
commandText = commandText.Replace(Environment.NewLine, "");
var parameterList = new List <MySqlParameter>();
parameterList.Add(new MySqlParameter("@currency_config_id", item.currency_config_id));
parameterList.Add(new MySqlParameter("@buy_at_price", item.buy_at_price));
parameterList.Add(new MySqlParameter("@buy_on_percent", item.buy_on_percent));
parameterList.Add(new MySqlParameter("@order_timeout_in_hour", item.order_timeout_in_hour));
parameterList.Add(new MySqlParameter("@buyable", item.buyable));
parameterList.Add(new MySqlParameter("@currency_pair", item.currency_pair.ToStr()));
parameterList.Add(new MySqlParameter("@sell_at_price", item.sell_at_price));
parameterList.Add(new MySqlParameter("@sell_on_percent", item.sell_on_percent));
parameterList.Add(new MySqlParameter("@sellable", item.sellable));
parameterList.Add(new MySqlParameter("@usable_balance_percent", item.usable_balance_percent));
parameterList.Add(new MySqlParameter("@bot_user", item.bot_user));
int id = MySqlHelper.ExecuteScalar(ConnectionString, commandText, parameterList.ToArray()).ToInt();
return(id);
}
