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; }