public MarketCapitalizationSettings GetMarketCapitalization(ref string strError)
{
MarketCapitalizationSettings marketcap = new MarketCapitalizationSettings();
try
{
using (var conn = new SQLiteConnection(ConnectionString))
using (var cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "SELECT * FROM MarketCapitalization WHERE MarketCapitalizationPK = 1";
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
marketcap = new MarketCapitalizationSettings() { Source = reader.GetString(reader.GetOrdinal("Source")), RefreshRate = reader.GetInt32(reader.GetOrdinal("RefreshRate")) };
}
}
}
}
catch (Exception ex)
{
strError = ex.Message;
}
return marketcap;
}
public MarketCapitalizationSettings GetMarketCapitalization(ref string strError)
{
MarketCapitalizationSettings marketcap = new MarketCapitalizationSettings();
MarketCapitalizationData data = new MarketCapitalizationData();
marketcap = data.GetMarketCapitalization(ref strError);
return marketcap;
}
public void UpdateMarketCapitalization(MarketCapitalizationSettings marketcap, ref string strError)
{
MarketCapitalizationData data = new MarketCapitalizationData();
data.UpdateMarketCapitalization(marketcap, ref strError);
}
public void UpdateMarketCapitalization(MarketCapitalizationSettings marketcap, ref string strError)
{
try
{
using (var conn = new SQLiteConnection(ConnectionString))
using (var cmd = new SQLiteCommand("UPDATE MarketCapitalization SET Source = @Source, RefreshRate = @RefreshRate WHERE MarketCapitalizationPK = 1", conn))
{
conn.Open();
cmd.Parameters.Add(new SQLiteParameter("@Source", marketcap.Source));
cmd.Parameters.Add(new SQLiteParameter("@RefreshRate", marketcap.RefreshRate));
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
strError = ex.Message;
}
}