private List <Currency> GetCurrencies(long economyId)
{
List <Currency> currencies = new List <Currency>();
SqlConnection sql = DatabaseService.GetSqlConnection();
string fetch = "SELECT * FROM dbo.Currency WHERE EconomyId=@economyId";
SqlCommand command = new SqlCommand(fetch, sql);
command.Parameters.AddWithValue("@economyId", economyId);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
currencies.Add(CurrencyService.GetCurrency((long)reader["Id"]));
}
}
sql.Close();
List <Currency> sortedCurrencies = currencies.OrderByDescending(c => c.ConversionRateToStandard).ToList();
return(sortedCurrencies);
}
/// <summary>
/// gets a currencyCOunt of the provided ID from the database
/// </summary>
/// <param name="currencyCountId">ID of the count to fetch</param>
/// <returns>instance of the CurrencyCount class matching the database</returns>
public static CurrencyCount GetCurrencyCount(long currencyCountId)
{
Debug.WriteLine("I'm fetching the currency count with the ID of " + currencyCountId + " from CurrencyCount table");
CurrencyCount currencyCount = null;
SqlConnection sql = DatabaseService.GetSqlConnection();
//fetch the row
string fetch = "SELECT * FROM dbo.CurrencyCountTable WHERE Id =@Id;";
SqlCommand command = new SqlCommand(fetch, sql);
command.Parameters.AddWithValue("@Id", currencyCountId);
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
currencyCount = new CurrencyCount((long)reader["Id"], (long)reader["WalletId"], CurrencyService.GetCurrency((long)reader["CurrencyId"]), (int)reader["Quantity"]);
}
}
sql.Close();
return(currencyCount);
}
