public void SaveCurrencyRate(CurrencyRateItem cRateItem, string isoCode)
{
var config = new Utils().ReadTokensConnsettings();
string strConnectionString = config.GetSection("Conn:DB").Value;
string sql = "INSERT INTO CurrencyRate (isoCode, paridadeCompra, paridadeVenda, cotacaoCompra, cotacaoVenda, dataHoraCotacao) " +
"VALUES (@isoCode, @paridadeCompra, @paridadeVenda, @cotacaoCompra, @cotacaoVenda, @dataHoraCotacao)";
using (IDbConnection conn = new SqlConnection(strConnectionString))
{
var vParams = new DynamicParameters();
vParams.Add("@isoCode", isoCode);
vParams.Add("@paridadeCompra", cRateItem.paridadeCompra);
vParams.Add("@paridadeVenda", cRateItem.paridadeVenda);
vParams.Add("@cotacaoCompra", cRateItem.cotacaoCompra);
vParams.Add("@cotacaoVenda", cRateItem.cotacaoVenda);
vParams.Add("@dataHoraCotacao", cRateItem.dataHoraCotacao);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
conn.Query <int>(sql, vParams).FirstOrDefault();
}
}
public bool CurrencyRateIsNew(CurrencyRateItem cRateItem, string isoCode)
{
var config = new Utils().ReadTokensConnsettings();
bool dataVerification;
string strConnectionString = config.GetSection("Conn:DB").Value;
string sql = "SELECT COUNT(1) FROM CurrencyRate WHERE isoCode = @isoCode AND dataHoraCotacao = @dataHoraCotacao";
using (IDbConnection conn = new SqlConnection(strConnectionString))
{
var vParams = new DynamicParameters();
vParams.Add("@isoCode", isoCode);
vParams.Add("@dataHoraCotacao", cRateItem.dataHoraCotacao);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
dataVerification = conn.Query <bool>(sql, vParams).FirstOrDefault();
}
return(!dataVerification);
}
