public List <CCurrencyPair> GetAll() { String sqlExpression = "sp_GetAllCurrencyPairs"; List <CCurrencyPair> pairs = new List <CCurrencyPair>(); CCurrencyGateway curInfoGateway = new CCurrencyGateway(); using (SqlConnection conn = CDbConnection.GetConnection()) { SqlCommand command = new SqlCommand(sqlExpression, conn); command.CommandType = CommandType.StoredProcedure; var reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { CCurrencyPair pair = new CCurrencyPair(); pair.BaseCurrency = curInfoGateway.Get((Int32)reader["BaseCurrencyID"]); pair.QuotedCurrency = curInfoGateway.Get((Int32)reader["QuotedCurrencyID"]); pair.ID = (Int32)reader["ID"]; pairs.Add(pair); } } reader.Close(); } return(pairs); }
private void InsertDefaultValues() { Dictionary <String, String> currencies = CReadFromFileService.ReadFromFileAsDictionary(_path); CCurrencyGateway currencyGateway = new CCurrencyGateway(); foreach (var currency in currencies) { CurrencyInfo curInfo = new CurrencyInfo(); curInfo.Name = currency.Value; curInfo.Code = currency.Key; currencyGateway.Create(curInfo); } Upgrade(); }
public CCurrencyPair Get(Int32 id) { String sqlExpression = "sp_GetCurrencyPairById"; CCurrencyPair pair = new CCurrencyPair(); CCurrencyGateway curInfoGateway = new CCurrencyGateway(); using (SqlConnection conn = CDbConnection.GetConnection()) { SqlCommand command = new SqlCommand(sqlExpression, conn) { CommandType = CommandType.StoredProcedure }; SqlParameter idParam = new SqlParameter { ParameterName = "@id", Value = id }; command.Parameters.Add(idParam); try { var reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { pair.BaseCurrency = curInfoGateway.Get((Int32)reader["BaseCurrencyID"]); pair.QuotedCurrency = curInfoGateway.Get((Int32)reader["QuotedCurrencyID"]); pair.ID = (Int32)reader["ID"]; } } else { pair = null; } reader.Close(); } catch (Exception e) { throw new Exception(e.Message + e.StackTrace); } } return(pair); }