private void ReadDataFromSql(string date, DateCurrency dateCurrency)
{
var rowIndex = 0;
// usa, eur code
var currencyMainPage = new[] {"R01235 ", "R01239"};
foreach (var currencyCode in currencyMainPage)
{
var filterPrimKey = date + currencyCode.Trim();
ReadOrderData(filterPrimKey, Connect, rowIndex, dateCurrency);
rowIndex++;
}
}
private void ReadOrderData(string filterPrimkey, string connectionString, int rowIndex, DateCurrency dateCurrency)
{
var queryString =
"SELECT numcode, charcode, nominal, name, value FROM dbo.values_history inner join dbo.description on dbo.description.id = dbo.values_history.id WHERE dbo.values_history.primkey ='" + filterPrimkey + "' ;";
try
{
using (var connection =
new SqlConnection(connectionString))
{
var command =
new SqlCommand(queryString, connection);
connection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
if (dateCurrency == DateCurrency.Today)
{
WriteTodayCurrency(reader, rowIndex);
}
else
{
DiffTodayYesterdayCurrency(reader, rowIndex);
}
}
reader.Close();
}
}
catch (Exception ex)
{
USDcurrency.Text = "";
EURcurrency.Text = "";
var log = string.Format("filterPrimkey: {0}, connectionString: {1}, rowIndex: {2}, dateCurrency: {3}",
filterPrimkey, connectionString, rowIndex, dateCurrency);
USDflowCurrency.Text = log + " ex.Message: " + ex.Message;
}
}
