public void DeleteMinerSetting(IDbConnection con, IDbTransaction tx, MinerSetting minerSetting)
{
logger.LogInvoke();
var query = "DELETE FROM minerSettings WHERE miner = @miner AND poolid = @poolId";
con.Execute(query, minerSetting, tx);
}
public void UpdateMinerSetting(IDbConnection con, IDbTransaction tx, MinerSetting minerSetting)
{
logger.LogInvoke();
var mapped = mapper.Map <Entities.MinerSetting>(minerSetting);
var query = "UPDATE minerSettings SET minerSettingheight = @minerSettingheight, status = @status, type = @type, reward = @reward, effort = @effort, confirmationprogress = @confirmationprogress WHERE miner = @miner AND poolid = @poolId";
con.Execute(query, mapped, tx);
}
public void Insert(IDbConnection con, IDbTransaction tx, MinerSetting minerSetting)
{
logger.LogInvoke();
var mapped = mapper.Map <Entities.MinerSetting>(minerSetting);
var query =
"INSERT INTO minerSettings(poolid, minerSettingheight, networkdifficulty, status, type, transactionconfirmationdata, miner, reward, effort, confirmationprogress, source, hash, created) " +
"VALUES(@poolid, @minerSettingheight, @networkdifficulty, @status, @type, @transactionconfirmationdata, @miner, @reward, @effort, @confirmationprogress, @source, @hash, @created)";
con.Execute(query, mapped, tx);
}
