public BlockRates SelectById(long id)
{
const string SQL_STATEMENT =
"SELECT Id, Time, Blocks, Difficulty " +
"FROM BlockRates WHERE Id = @Id";
BlockRates blockRates = null;
using (MySqlConnection conn = new MySqlConnection(CacheConnectionString))
using (MySqlCommand cmd = new MySqlCommand(SQL_STATEMENT, conn))
{
cmd.Parameters.AddWithValue("@Id", id);
cmd.Connection.Open();
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
blockRates = new BlockRates();
blockRates.Id = GetDataValue <long>(dr, "Id");
blockRates.Time = GetDataValue <long>(dr, "Time");
blockRates.Blocks = GetDataValue <long>(dr, "Blocks");
blockRates.Difficulty = GetDataValue <long>(dr, "Difficulty");
}
}
}
return(blockRates);
}
public List <BlockRates> SelectAll()
{
const string SQL_STATEMENT =
"SELECT Id, Time, Blocks, Difficulty " +
"FROM BlockRates;";
List <BlockRates> result = null;
using (MySqlConnection conn = new MySqlConnection(CacheConnectionString))
using (MySqlCommand cmd = new MySqlCommand(SQL_STATEMENT, conn))
{
cmd.Connection.Open();
using (MySqlDataReader dr = cmd.ExecuteReader())
{
result = new List <BlockRates>();
while (dr.Read())
{
BlockRates blockRates = new BlockRates();
blockRates.Id = GetDataValue <long>(dr, "Id");
blockRates.Time = GetDataValue <long>(dr, "Time");
blockRates.Blocks = GetDataValue <long>(dr, "Blocks");
blockRates.Difficulty = GetDataValue <long>(dr, "Difficulty");
result.Add(blockRates);
}
}
}
return(result);
}
public BlockRates SaveBlockRates(long blocks, long difficulty)
{
BlockRatesDac dac = new BlockRatesDac();
BlockRates rates = new BlockRates();
rates.Blocks = blocks;
rates.Difficulty = difficulty;
rates.Time = Time.EpochTime;
dac.Insert(rates);
return(rates);
}
public void Insert(BlockRates blockRates)
{
const string SQL_STATEMENT =
"INSERT INTO BlockRates " +
"(Time, Blocks, Difficulty) " +
"VALUES (@Time, @Blocks, @Difficulty);";
using (MySqlConnection conn = new MySqlConnection(CacheConnectionString))
using (MySqlCommand cmd = new MySqlCommand(SQL_STATEMENT, conn))
{
cmd.Parameters.AddWithValue("@Time", blockRates.Time);
cmd.Parameters.AddWithValue("@Blocks", blockRates.Blocks);
cmd.Parameters.AddWithValue("@Difficulty", blockRates.Difficulty);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
}
}
public void Update(BlockRates entity)
{
const string SQL_STATEMENT =
"UPDATE BlockRates " +
"SET Time = @Time, Blocks = @Blocks, Difficulty = @Difficulty " +
"WHERE Id = @Id;";
using (MySqlConnection con = new MySqlConnection(CacheConnectionString))
using (MySqlCommand cmd = new MySqlCommand(SQL_STATEMENT, con))
{
cmd.Parameters.AddWithValue("@Id", entity.Id);
cmd.Parameters.AddWithValue("@Time", entity.Time);
cmd.Parameters.AddWithValue("@Blocks", entity.Blocks);
cmd.Parameters.AddWithValue("@Difficulty", entity.Difficulty);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
}
}
public void Update(BlockRates entity)
{
BlockRatesDac dac = new BlockRatesDac();
dac.Update(entity);
}
