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); }