private static DB_reader Get_DB_reader(HssStatus status, SQL_condition extraCond) { DB_select selt = new DB_select(XBRL_SavedFile.Get_cmdTP()); selt.IgnoreColumn("savedfile"); SQL_relation rela = null; if (status == HssStatus.Pending || status == HssStatus.Approved) { rela = new SQL_relation("processState", RelationalOperator.Equals, (int)status); } else { HashSet <int> hs = new HashSet <int>(); hs.Add(0); hs.Add(1); rela = new SQL_relation("processState", false, hs); } SQL_condition cond = new SQL_condition(rela, ConditionalOperator.And, extraCond); selt.SetCondition(cond); DB_reader reader = new DB_reader(selt, Utility.Get_XBRL_hDB()); return(reader); }
private void Get_XBRLlist_threadRun() { if (this.curr_reader == null) { return; } while (this.curr_reader.Read()) { if (this.threadStop_flag) { break; } XBRL_SavedFile sf = new XBRL_SavedFile(); sf.Init_from_reader(this.curr_reader); this.XBRL_list.Add(sf); } Thread th = new Thread(this.curr_reader.Close); th.Name = "Reader close thread"; th.Start(); this.dataFinishedLoading_flag = true; }
/// <summary> /// Add some rows from list to DT /// </summary> /// <param name="limit">max number of rows to be added</param> /// <returns>how many rows added</returns> public int Add_XBRLrows_to_DT(int limit = UltraGrid_helper.RowsLoaded_per_scroll) { int count = 0; if (limit < 1) { limit = UltraGrid_helper.RowsLoaded_per_scroll; } while (this.currList_id < this.XBRL_list.Count) { XBRL_SavedFile sf = this.XBRL_list[this.currList_id]; DataRow row = sourceDT.Rows.Add(); row["id_SavedfilesRcvd"] = sf.id_SavedfilesRcvd; row["UniqueUniversalEventIdentifier"] = sf.UniqueUniversalEventIdentifier.Value; row["CUSIP"] = sf.cusip.Value; row["DepositaryName"] = sf.DepositaryName.Value; //row["UnderlyingSecurityIssuerCountryofIncorporation"] = sf.UnderlyingSecurityIssuerCountryofIncorporation.Value; //row["CountryOfIssue"] = sf.CountryOfIssue.Value; row["AnnouncementType"] = sf.AnnouncementType.Value; if (!sf.AnnouncementDate.IsNull_flag) { row["AnnouncementDate"] = sf.AnnouncementDate.Value; } row["EventCompleteness"] = sf.EventCompleteness.Value; row["originalFileName"] = sf.originalFileName.Value; if (!sf.DividendIndex.IsNull_flag) { row["DividendIndex"] = sf.DividendIndex.Value; } row["Createdby"] = sf.createdby.Value; if (!sf.createddate.IsNull_flag) { row["CreatedDate"] = sf.createddate.Value; } row["processState"] = sf.processState.Value; row["Processedby"] = sf.Processedby.Value; if (!sf.WhenProcessed.IsNull_flag) { row["WhenProcessed"] = sf.WhenProcessed.Value; } List <Security> sec_list = SecurityMaster.Get_secList_cusip(sf.cusip.Value); if (sec_list.Count > 0) { row["$Country$"] = sec_list[0].Country.Value; } ++this.currList_id; if (++count > limit) { break; } } return(count); }
/*-----------------------------------Functions for Approval--------------------------------------------------*/ /// <summary> /// Get XBRL_SavedFile based on file ID /// </summary> private static XBRL_SavedFile ApproveXBRL0_get_xsFile(int xbrl_id) { XBRL_SavedFile xsf = new XBRL_SavedFile(xbrl_id); if (!xsf.Init_from_DB(false)) { MessageBox.Show("Helper_XBRL error 2: Error in reading XBRL file"); return(null); } return(xsf); }
/***********************************************Static Methods******************************************************************/ public static List <XBRL_SavedFile> Get_XBRL_fileList(HssStatus status) { List <XBRL_SavedFile> list = new List <XBRL_SavedFile>(); DB_reader reader = XBRL_SavedFile_master.Get_DB_reader(status, null); while (reader.Read()) { XBRL_SavedFile sf = new XBRL_SavedFile(); sf.Init_from_reader(reader); list.Add(sf); } reader.Close(); return(list); }
public XBRL_SavedFile GetCopy() { XBRL_SavedFile newEntity = new XBRL_SavedFile(); //if (!this.savedfile.IsNull_flag) newEntity.savedfile.Value = this.savedfile.Value; if (!this.EventType.IsNull_flag) { newEntity.EventType.Value = this.EventType.Value; } if (!this.DRWINIncomeEventID.IsNull_flag) { newEntity.DRWINIncomeEventID.Value = this.DRWINIncomeEventID.Value; } if (!this.cusip.IsNull_flag) { newEntity.cusip.Value = this.cusip.Value; } if (!this.ISIN.IsNull_flag) { newEntity.ISIN.Value = this.ISIN.Value; } if (!this.originalFileName.IsNull_flag) { newEntity.originalFileName.Value = this.originalFileName.Value; } if (!this.DepositaryName.IsNull_flag) { newEntity.DepositaryName.Value = this.DepositaryName.Value; } if (!this.AnnouncementDate.IsNull_flag) { newEntity.AnnouncementDate.Value = this.AnnouncementDate.Value; } if (!this.EventCompleteness.IsNull_flag) { newEntity.EventCompleteness.Value = this.EventCompleteness.Value; } if (!this.UniqueUniversalEventIdentifier.IsNull_flag) { newEntity.UniqueUniversalEventIdentifier.Value = this.UniqueUniversalEventIdentifier.Value; } if (!this.DepositoryReceiptSponsorIndicator.IsNull_flag) { newEntity.DepositoryReceiptSponsorIndicator.Value = this.DepositoryReceiptSponsorIndicator.Value; } if (!this.PaymentDate.IsNull_flag) { newEntity.PaymentDate.Value = this.PaymentDate.Value; } if (!this.RecordDate.IsNull_flag) { newEntity.RecordDate.Value = this.RecordDate.Value; } if (!this.CountryOfIssue.IsNull_flag) { newEntity.CountryOfIssue.Value = this.CountryOfIssue.Value; } if (!this.ContextRefBase.IsNull_flag) { newEntity.ContextRefBase.Value = this.ContextRefBase.Value; } if (!this.Source.IsNull_flag) { newEntity.Source.Value = this.Source.Value; } if (!this.processState.IsNull_flag) { newEntity.processState.Value = this.processState.Value; } if (!this.WhenProcessed.IsNull_flag) { newEntity.WhenProcessed.Value = this.WhenProcessed.Value; } if (!this.Processedby.IsNull_flag) { newEntity.Processedby.Value = this.Processedby.Value; } if (!this.flgLock.IsNull_flag) { newEntity.flgLock.Value = this.flgLock.Value; } if (!this.WhenLocked_date.IsNull_flag) { newEntity.WhenLocked_date.Value = this.WhenLocked_date.Value; } if (!this.LockedBy_userid.IsNull_flag) { newEntity.LockedBy_userid.Value = this.LockedBy_userid.Value; } if (!this.createdby.IsNull_flag) { newEntity.createdby.Value = this.createdby.Value; } if (!this.createddate.IsNull_flag) { newEntity.createddate.Value = this.createddate.Value; } if (!this.AnnouncementIdentifier.IsNull_flag) { newEntity.AnnouncementIdentifier.Value = this.AnnouncementIdentifier.Value; } if (!this.FirstFilerFlag.IsNull_flag) { newEntity.FirstFilerFlag.Value = this.FirstFilerFlag.Value; } if (!this.UnderlyingSecurityIssuerCountryofIncorporation.IsNull_flag) { newEntity.UnderlyingSecurityIssuerCountryofIncorporation.Value = this.UnderlyingSecurityIssuerCountryofIncorporation.Value; } if (!this.id_SavedFiles_CSV.IsNull_flag) { newEntity.id_SavedFiles_CSV.Value = this.id_SavedFiles_CSV.Value; } if (!this.DividendIndex.IsNull_flag) { newEntity.DividendIndex.Value = this.DividendIndex.Value; } if (!this.AnnouncementType.IsNull_flag) { newEntity.AnnouncementType.Value = this.AnnouncementType.Value; } if (!this.ID_GTS_SFTP_InputSITEs.IsNull_flag) { newEntity.ID_GTS_SFTP_InputSITEs.Value = this.ID_GTS_SFTP_InputSITEs.Value; } if (!this.recNum.IsNull_flag) { newEntity.recNum.Value = this.recNum.Value; } if (!this.flgEmailSent.IsNull_flag) { newEntity.flgEmailSent.Value = this.flgEmailSent.Value; } if (!this.EmailSentDate.IsNull_flag) { newEntity.EmailSentDate.Value = this.EmailSentDate.Value; } return(newEntity); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } this.Processedby.Value = Utility.CurrentUser; this.WhenProcessed.Value = DateTime.Now; HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(XBRL_SavedFile.Get_cmdTP()); //if (this.savedfile.ValueChanged) upd.AddValue("savedfile", this.savedfile); //no update for binary for now if (this.EventType.ValueChanged) { upd.AddValue("EventType", this.EventType); } if (this.DRWINIncomeEventID.ValueChanged) { upd.AddValue("DRWINIncomeEventID", this.DRWINIncomeEventID); } if (this.cusip.ValueChanged) { upd.AddValue("cusip", this.cusip); } if (this.ISIN.ValueChanged) { upd.AddValue("ISIN", this.ISIN); } if (this.originalFileName.ValueChanged) { upd.AddValue("originalFileName", this.originalFileName); } if (this.DepositaryName.ValueChanged) { upd.AddValue("DepositaryName", this.DepositaryName); } if (this.AnnouncementDate.ValueChanged) { upd.AddValue("AnnouncementDate", this.AnnouncementDate); } if (this.EventCompleteness.ValueChanged) { upd.AddValue("EventCompleteness", this.EventCompleteness); } if (this.UniqueUniversalEventIdentifier.ValueChanged) { upd.AddValue("UniqueUniversalEventIdentifier", this.UniqueUniversalEventIdentifier); } if (this.DepositoryReceiptSponsorIndicator.ValueChanged) { upd.AddValue("DepositoryReceiptSponsorIndicator", this.DepositoryReceiptSponsorIndicator); } if (this.PaymentDate.ValueChanged) { upd.AddValue("PaymentDate", this.PaymentDate); } if (this.RecordDate.ValueChanged) { upd.AddValue("RecordDate", this.RecordDate); } if (this.CountryOfIssue.ValueChanged) { upd.AddValue("CountryOfIssue", this.CountryOfIssue); } if (this.ContextRefBase.ValueChanged) { upd.AddValue("ContextRefBase", this.ContextRefBase); } if (this.Source.ValueChanged) { upd.AddValue("Source", this.Source); } if (this.processState.ValueChanged) { upd.AddValue("processState", this.processState); } if (this.WhenProcessed.ValueChanged) { upd.AddValue("WhenProcessed", this.WhenProcessed); } if (this.Processedby.ValueChanged) { upd.AddValue("Processedby", this.Processedby); } if (this.flgLock.ValueChanged) { upd.AddValue("flgLock", this.flgLock); } if (this.WhenLocked_date.ValueChanged) { upd.AddValue("WhenLocked_date", this.WhenLocked_date); } if (this.LockedBy_userid.ValueChanged) { upd.AddValue("LockedBy_userid", this.LockedBy_userid); } if (this.createdby.ValueChanged) { upd.AddValue("createdby", this.createdby); } if (this.createddate.ValueChanged) { upd.AddValue("createddate", this.createddate); } if (this.AnnouncementIdentifier.ValueChanged) { upd.AddValue("AnnouncementIdentifier", this.AnnouncementIdentifier); } if (this.FirstFilerFlag.ValueChanged) { upd.AddValue("FirstFilerFlag", this.FirstFilerFlag); } if (this.UnderlyingSecurityIssuerCountryofIncorporation.ValueChanged) { upd.AddValue("UnderlyingSecurityIssuerCountryofIncorporation", this.UnderlyingSecurityIssuerCountryofIncorporation); } if (this.id_SavedFiles_CSV.ValueChanged) { upd.AddValue("id_SavedFiles_CSV", this.id_SavedFiles_CSV); } if (this.DividendIndex.ValueChanged) { upd.AddValue("DividendIndex", this.DividendIndex); } if (this.AnnouncementType.ValueChanged) { upd.AddValue("AnnouncementType", this.AnnouncementType); } if (this.ID_GTS_SFTP_InputSITEs.ValueChanged) { upd.AddValue("ID_GTS_SFTP_InputSITEs", this.ID_GTS_SFTP_InputSITEs); } if (this.recNum.ValueChanged) { upd.AddValue("recNum", this.recNum); } if (this.flgEmailSent.ValueChanged) { upd.AddValue("flgEmailSent", this.flgEmailSent); } if (this.EmailSentDate.ValueChanged) { upd.AddValue("EmailSentDate", this.EmailSentDate); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("id_SavedfilesRcvd", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(XBRL_SavedFile.Get_cmdTP()); dbIns.AddValue("savedfile", this.savedfile); dbIns.AddValue("EventType", this.EventType.Value); dbIns.AddValue("DRWINIncomeEventID", this.DRWINIncomeEventID); /*Optional 4*/ dbIns.AddValue("cusip", this.cusip); /*Optional 5*/ dbIns.AddValue("ISIN", this.ISIN); /*Optional 6*/ dbIns.AddValue("originalFileName", this.originalFileName); /*Optional 7*/ dbIns.AddValue("DepositaryName", this.DepositaryName); /*Optional 8*/ dbIns.AddValue("AnnouncementDate", this.AnnouncementDate); /*Optional 9*/ dbIns.AddValue("EventCompleteness", this.EventCompleteness); /*Optional 10*/ dbIns.AddValue("UniqueUniversalEventIdentifier", this.UniqueUniversalEventIdentifier); /*Optional 11*/ dbIns.AddValue("DepositoryReceiptSponsorIndicator", this.DepositoryReceiptSponsorIndicator); /*Optional 12*/ dbIns.AddValue("PaymentDate", this.PaymentDate); /*Optional 13*/ dbIns.AddValue("RecordDate", this.RecordDate); /*Optional 14*/ dbIns.AddValue("CountryOfIssue", this.CountryOfIssue); /*Optional 15*/ dbIns.AddValue("ContextRefBase", this.ContextRefBase); /*Optional 16*/ dbIns.AddValue("Source", this.Source); /*Optional 17*/ dbIns.AddValue("processState", this.processState.Value); dbIns.AddValue("WhenProcessed", this.WhenProcessed); /*Optional 19*/ dbIns.AddValue("Processedby", this.Processedby); /*Optional 20*/ dbIns.AddValue("flgLock", this.flgLock); /*Optional 21*/ dbIns.AddValue("WhenLocked_date", this.WhenLocked_date); /*Optional 22*/ dbIns.AddValue("LockedBy_userid", this.LockedBy_userid); /*Optional 23*/ dbIns.AddValue("createdby", this.createdby.Value); dbIns.AddValue("createddate", this.createddate.Value); dbIns.AddValue("AnnouncementIdentifier", this.AnnouncementIdentifier); /*Optional 26*/ dbIns.AddValue("FirstFilerFlag", this.FirstFilerFlag); /*Optional 27*/ dbIns.AddValue("UnderlyingSecurityIssuerCountryofIncorporation", this.UnderlyingSecurityIssuerCountryofIncorporation); /*Optional 28*/ dbIns.AddValue("id_SavedFiles_CSV", this.id_SavedFiles_CSV); /*Optional 29*/ dbIns.AddValue("DividendIndex", this.DividendIndex); /*Optional 30*/ dbIns.AddValue("AnnouncementType", this.AnnouncementType); /*Optional 31*/ dbIns.AddValue("ID_GTS_SFTP_InputSITEs", this.ID_GTS_SFTP_InputSITEs); /*Optional 32*/ dbIns.AddValue("recNum", this.recNum); /*Optional 33*/ dbIns.AddValue("flgEmailSent", this.flgEmailSent); /*Optional 34*/ dbIns.AddValue("EmailSentDate", this.EmailSentDate); /*Optional 35*/ return(dbIns); }
/// <summary> /// Initialize object from DB /// </summary> public bool Init_from_DB(bool ignore_savedfile) { if (this.id_SavedfilesRcvd < 0) { return(false); } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(XBRL_SavedFile.Get_cmdTP()); if (ignore_savedfile) { db_sel.IgnoreColumn("savedfile"); } db_sel.tableName = "SavedFiles"; HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("id_SavedfilesRcvd", HssUtility.General.RelationalOperator.Equals, this.id_SavedfilesRcvd); db_sel.SetCondition(rela); bool res_flag = false; HssUtility.SQLserver.DB_reader reader = new HssUtility.SQLserver.DB_reader(db_sel, Utility.Get_XBRL_hDB()); if (reader.Read()) { this.Init_from_reader(reader); res_flag = true; } reader.Close(); return(res_flag); }
public static Dividend ApproveXBRL(int xbrl_id) { XBRL_SavedFile xsf = Helper_XBRL_approval.ApproveXBRL0_get_xsFile(xbrl_id); XBRL_event_info xei = new XBRL_event_info(xsf.XBRLobj); Security sec = SecurityMaster.XBRL_Create_or_Get_Security(xei, true); if (sec == null) { MessageBox.Show("Helper_XBRL error 0: no Security info in either XBRL or Security Master"); return(null); } Dividend existing_dvd = Helper_XBRL_approval.ApproveXBRL0_find_existingDividend(xei); if (xei.IsCancellation_flag) { return(Helper_XBRL_approval.ApproveXBRL1_cancellation_XBRL(existing_dvd, xsf)); } Action next_step = XBRL_event_matrix.ApproveXBRL_action(xei, existing_dvd); Dividend approved_dvd = null; if (next_step == Action.Create_New_Event) { approved_dvd = Helper_XBRL_approval.ApproveXBRL2_CreateNewDividend(xei, sec); Helper_XBRL_approval.ApproveXBRL4_InsertDvdXBRL(xei, approved_dvd); if (approved_dvd != null) { if (existing_dvd == null) { MessageBox.Show("New Dividend " + approved_dvd.DividendIndex + " created"); } else { MessageBox.Show("Another Dividend " + approved_dvd.DividendIndex + " created with existing Dividend " + existing_dvd.DividendIndex); } } } else if (next_step == Action.Update_Existing_event) { approved_dvd = Helper_XBRL_approval.ApproveXBRL2_UpdateDividend(xei, existing_dvd, sec); Helper_XBRL_approval.ApproveXBRL4_InsertDvdXBRL(xei, approved_dvd); if (approved_dvd != null) { MessageBox.Show("Existing Dividend " + approved_dvd.DividendIndex + " is updated"); } } else if (next_step == Action.Add_Ref_to_Current) { approved_dvd = Helper_XBRL_approval.ApproveXBRL4_InsertDvdXBRL(xei, existing_dvd); if (approved_dvd != null) { MessageBox.Show("XBRL ref# is added to existing Dividend " + approved_dvd.DividendIndex); } } if (approved_dvd != null)//Mark [XBRL_SavedFile] as approved { xsf.processState.Value = 1; xsf.DividendIndex.Value = approved_dvd.DividendIndex; xsf.Update_to_DB();/*Commented out for testing by Steven if needed*/ } return(approved_dvd); }
/// <summary> /// Deal with cancellation XBRL /// </summary> private static Dividend ApproveXBRL1_cancellation_XBRL(Dividend existing_dvd, XBRL_SavedFile xsf) { if (existing_dvd == null) { MessageBox.Show("No Dividend created for this cancellation XBRL"); if (xsf != null) { xsf.processState.Value = 2; } } else { Helper_Dividend.CancelDivdiend(existing_dvd);//cancel existing dividend MessageBox.Show("Dividend " + existing_dvd.DividendIndex + " is cancelled"); if (xsf != null) { xsf.processState.Value = 1; } } if (xsf != null) { xsf.Update_to_DB(); } return(existing_dvd); }