public SavedFilesCustodianBalance GetCopy()
{
SavedFilesCustodianBalance newEntity = new SavedFilesCustodianBalance();
if (!this.originalFileName.IsNull_flag)
{
newEntity.originalFileName.Value = this.originalFileName.Value;
}
//if (!this.SavedFiles_XML_CB.IsNull_flag) newEntity.SavedFiles_XML_CB.Value = this.SavedFiles_XML_CB.Value;
if (!this.AnnouncementName.IsNull_flag)
{
newEntity.AnnouncementName.Value = this.AnnouncementName.Value;
}
if (!this.AnnouncementSender.IsNull_flag)
{
newEntity.AnnouncementSender.Value = this.AnnouncementSender.Value;
}
if (!this.AnnouncementIdentifier.IsNull_flag)
{
newEntity.AnnouncementIdentifier.Value = this.AnnouncementIdentifier.Value;
}
if (!this.AnnouncementDate.IsNull_flag)
{
newEntity.AnnouncementDate.Value = this.AnnouncementDate.Value;
}
if (!this.UniqueUniversalEventIdentifier.IsNull_flag)
{
newEntity.UniqueUniversalEventIdentifier.Value = this.UniqueUniversalEventIdentifier.Value;
}
if (!this.SECURITY_IDENTIFIER_CUSIP.IsNull_flag)
{
newEntity.SECURITY_IDENTIFIER_CUSIP.Value = this.SECURITY_IDENTIFIER_CUSIP.Value;
}
if (!this.ISSUER_NAME.IsNull_flag)
{
newEntity.ISSUER_NAME.Value = this.ISSUER_NAME.Value;
}
if (!this.ADR_RECORD_DATE.IsNull_flag)
{
newEntity.ADR_RECORD_DATE.Value = this.ADR_RECORD_DATE.Value;
}
if (!this.ADRBase.IsNull_flag)
{
newEntity.ADRBase.Value = this.ADRBase.Value;
}
if (!this.OrdinaryShare.IsNull_flag)
{
newEntity.OrdinaryShare.Value = this.OrdinaryShare.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.ID_GTS_SFTP_InputSITEs.IsNull_flag)
{
newEntity.ID_GTS_SFTP_InputSITEs.Value = this.ID_GTS_SFTP_InputSITEs.Value;
}
return(newEntity);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(SavedFilesCustodianBalance.Get_cmdTP());
dbIns.AddValue("originalFileName", this.originalFileName);/*Optional 2*/
dbIns.AddValue("SavedFiles_XML_CB", this.SavedFiles_XML_CB);
dbIns.AddValue("AnnouncementName", this.AnnouncementName.Value);
dbIns.AddValue("AnnouncementSender", this.AnnouncementSender.Value);
dbIns.AddValue("AnnouncementIdentifier", this.AnnouncementIdentifier.Value);
dbIns.AddValue("AnnouncementDate", this.AnnouncementDate.Value);
dbIns.AddValue("UniqueUniversalEventIdentifier", this.UniqueUniversalEventIdentifier.Value);
dbIns.AddValue("SECURITY_IDENTIFIER_CUSIP", this.SECURITY_IDENTIFIER_CUSIP.Value);
dbIns.AddValue("ISSUER_NAME", this.ISSUER_NAME.Value);
dbIns.AddValue("ADR_RECORD_DATE", this.ADR_RECORD_DATE.Value);
dbIns.AddValue("ADRBase", this.ADRBase); /*Optional 12*/
dbIns.AddValue("OrdinaryShare", this.OrdinaryShare); /*Optional 13*/
dbIns.AddValue("source", this.source.Value);
dbIns.AddValue("processState", this.processState.Value);
dbIns.AddValue("WhenProcessed", this.WhenProcessed); /*Optional 16*/
dbIns.AddValue("Processedby", this.Processedby); /*Optional 17*/
dbIns.AddValue("flgLock", this.flgLock); /*Optional 18*/
dbIns.AddValue("WhenLocked_date", this.WhenLocked_date); /*Optional 19*/
dbIns.AddValue("LockedBy_userid", this.LockedBy_userid); /*Optional 20*/
dbIns.AddValue("createdby", this.createdby.Value);
dbIns.AddValue("createddate", this.createddate.Value);
dbIns.AddValue("ID_GTS_SFTP_InputSITEs", this.ID_GTS_SFTP_InputSITEs);/*Optional 23*/
return(dbIns);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(SavedFilesCustodianBalance.Get_cmdTP());
if (this.originalFileName.ValueChanged)
{
upd.AddValue("originalFileName", this.originalFileName);
}
//if (this.SavedFiles_XML_CB.ValueChanged) upd.AddValue("SavedFiles_XML_CB", this.SavedFiles_XML_CB);
if (this.AnnouncementName.ValueChanged)
{
upd.AddValue("AnnouncementName", this.AnnouncementName);
}
if (this.AnnouncementSender.ValueChanged)
{
upd.AddValue("AnnouncementSender", this.AnnouncementSender);
}
if (this.AnnouncementIdentifier.ValueChanged)
{
upd.AddValue("AnnouncementIdentifier", this.AnnouncementIdentifier);
}
if (this.AnnouncementDate.ValueChanged)
{
upd.AddValue("AnnouncementDate", this.AnnouncementDate);
}
if (this.UniqueUniversalEventIdentifier.ValueChanged)
{
upd.AddValue("UniqueUniversalEventIdentifier", this.UniqueUniversalEventIdentifier);
}
if (this.SECURITY_IDENTIFIER_CUSIP.ValueChanged)
{
upd.AddValue("SECURITY_IDENTIFIER_CUSIP", this.SECURITY_IDENTIFIER_CUSIP);
}
if (this.ISSUER_NAME.ValueChanged)
{
upd.AddValue("ISSUER_NAME", this.ISSUER_NAME);
}
if (this.ADR_RECORD_DATE.ValueChanged)
{
upd.AddValue("ADR_RECORD_DATE", this.ADR_RECORD_DATE);
}
if (this.ADRBase.ValueChanged)
{
upd.AddValue("ADRBase", this.ADRBase);
}
if (this.OrdinaryShare.ValueChanged)
{
upd.AddValue("OrdinaryShare", this.OrdinaryShare);
}
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.ID_GTS_SFTP_InputSITEs.ValueChanged)
{
upd.AddValue("ID_GTS_SFTP_InputSITEs", this.ID_GTS_SFTP_InputSITEs);
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("id_SavedFilesCustodianBalance", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
/// <summary>
/// Initialize object from DB
/// </summary>
public bool Init_from_DB()
{
if (this.id_SavedFilesCustodianBalance < 0)
{
return(false);
}
HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(SavedFilesCustodianBalance.Get_cmdTP());
db_sel.tableName = "SavedFilesCustodianBalance";
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("id_SavedFilesCustodianBalance", HssUtility.General.RelationalOperator.Equals, this.id_SavedFilesCustodianBalance);
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);
}