// returns 0 on success public int AddSpinoff(string symbol, DateTime eventDate, string xml = "<Deliverables></Deliverables>") { ClearErrorState(); int rc = 8; try { if ((!IsInitialized) || (m_hugoConnection == null)) { throw new Exception("HugoCorporateActionsLib not initialized"); } using (HugoDataSetTableAdapters.QueriesTableAdapter queryAdapter = new HugoDataSetTableAdapters.QueriesTableAdapter()) { queryAdapter.Connection = m_hugoConnection; queryAdapter.SetAllCommandTimeouts(m_timeOut); queryAdapter.p_add_spinoff(null, 0, eventDate, null, null, null, null, symbol, null, null, null, xml); queryAdapter.LogSqlCommand("CorporateActions.p_add_spinoff"); rc = queryAdapter.GetReturnCode("CorporateActions.p_add_spinoff"); } } catch (Exception ex) { Error("Error inserting spinoffs", ex); } Info(String.Format("Inserted spinoff")); return(rc); }
public int InsertCorporateActions(string provider, string xml, DateTime?importDate, bool restart) { int?numberRecordsInserted = 0; ClearErrorState(); try { if ((!IsInitialized) || (m_hugoConnection == null)) { throw new Exception("HugoCorporateActionsLib not initialized"); } using (HugoDataSetTableAdapters.QueriesTableAdapter queryAdapter = new HugoDataSetTableAdapters.QueriesTableAdapter()) { queryAdapter.Connection = m_hugoConnection; queryAdapter.SetAllCommandTimeouts(m_timeOut); queryAdapter.p_insert_CorporateActions(provider, xml, importDate, ref numberRecordsInserted, restart, false); queryAdapter.LogSqlCommand("CorporateActions.p_insert_CorporateActions"); } } catch (Exception ex) { numberRecordsInserted = 0; Error("Error inserting corporate actions", ex); } if (numberRecordsInserted.Value > 0) { Info("Break"); } Info(String.Format("Inserted {0} corporate actions", numberRecordsInserted)); return(numberRecordsInserted.Value); }