public virtual void Updatestock_Symbol(stock_Symbol stock_Symbol)
{
try
{
//Database database = DatabaseFactory.CreateDatabase();
Database database = DatabaseFactory.CreateDatabase("DestinationConnection");
DbCommand dbCommand = database.GetStoredProcCommand("spstock_SymbolsUpdate");
database.AddInParameter(dbCommand, "@SymbolID", DbType.Int32, stock_Symbol.SymbolID);
database.AddInParameter(dbCommand, "@SourceID", DbType.AnsiString, stock_Symbol.SourceID);
database.AddInParameter(dbCommand, "@Symbol", DbType.AnsiString, stock_Symbol.Symbol);
database.AddInParameter(dbCommand, "@MarketID", DbType.Int32, stock_Symbol.MarketID);
database.AddInParameter(dbCommand, "@IndustryID", DbType.Int32, stock_Symbol.IndustryID);
database.AddInParameter(dbCommand, "@CompanyType", DbType.AnsiString, stock_Symbol.CompanyType);
database.AddInParameter(dbCommand, "@SecType", DbType.Int32, stock_Symbol.SecType);
database.AddInParameter(dbCommand, "@IsListing", DbType.Boolean, stock_Symbol.IsListing);
database.ExecuteNonQuery(dbCommand);
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.DataAccessUpdatestock_SymbolException, ex);
}
}
public virtual stock_Symbol Createstock_SymbolFromReader(IDataReader reader)
{
stock_Symbol item = new stock_Symbol();
try
{
if (!reader.IsDBNull(reader.GetOrdinal("SymbolID"))) item.SymbolID = (int)reader["SymbolID"];
if (!reader.IsDBNull(reader.GetOrdinal("SourceID"))) item.SourceID = (string)reader["SourceID"];
if (!reader.IsDBNull(reader.GetOrdinal("Symbol"))) item.Symbol = (string)reader["Symbol"];
if (!reader.IsDBNull(reader.GetOrdinal("MarketID"))) item.MarketID = (int)reader["MarketID"];
if (!reader.IsDBNull(reader.GetOrdinal("IndustryID"))) item.IndustryID = (int)reader["IndustryID"];
if (!reader.IsDBNull(reader.GetOrdinal("CompanyType"))) item.CompanyType = (string)reader["CompanyType"];
if (!reader.IsDBNull(reader.GetOrdinal("SecType"))) item.SecType = (int)reader["SecType"];
if (!reader.IsDBNull(reader.GetOrdinal("IsListing"))) item.IsListing = (bool)reader["IsListing"];
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.DataAccessCreatestock_SymbolFromReaderException, ex);
}
return item;
}
