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