internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Dividend_Detail_full.Get_cmdTP());
if (this.DTC_Number.ValueChanged)
{
upd.AddValue("DTC_Number", this.DTC_Number);
}
if (this.CustodianID.ValueChanged)
{
upd.AddValue("CustodianID", this.CustodianID); /*Optional 25*/
}
if (this.Status.ValueChanged)
{
upd.AddValue("Status", this.Status); /*Optional 27*/
}
if (this.RecordDatePosition.ValueChanged)
{
upd.AddValue("RecordDatePosition", this.RecordDatePosition); /*Optional 30*/
}
if (this.Dividend_FilingID.ValueChanged)
{
upd.AddValue("Dividend_FilingID", this.Dividend_FilingID); /*Optional 37*/
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("DetailID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
/*^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Hss Entity Framework Auto Generated Code^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^*/
/// <summary>
/// Lock or Unlock an record
/// </summary>
/// <param name="lock_flag">lock or unlock flag</param>
/// <param name="success_flag">when unlock, indicate if it's successful</param>
public bool UpdateRecordLock(bool lock_flag, bool success_flag = false)
{
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Hss_DailyJobs.Get_cmdTP());
if (lock_flag)
{
upd.AddValue("LastLockAt", DateTime.Now);
upd.AddValue("LastLockBy", Utility.CurrentUser);
}
else
{
if (success_flag)
{
upd.AddValue("LastRunAt", DateTime.Now);
upd.AddValue("LastRunBy", Utility.CurrentUser);
}
}
upd.AddValue("Locked", lock_flag);//set lock value
HssUtility.SQLserver.SQL_relation rela0 = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
HssUtility.SQLserver.SQL_relation rela1 = new HssUtility.SQLserver.SQL_relation("Locked", HssUtility.General.RelationalOperator.Equals, !lock_flag);
HssUtility.SQLserver.SQL_condition cond = new HssUtility.SQLserver.SQL_condition(rela0, HssUtility.General.ConditionalOperator.And, rela1);
upd.SetCondition(cond);
int count = upd.SaveToDB(Utility.Get_DRWIN_hDB());
bool flag = count > 0;
return(flag);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(EDI_country.Get_cmdTP());
if (this.name.ValueChanged)
{
upd.AddValue("name", this.name);
}
if (this.currency_id.ValueChanged)
{
upd.AddValue("currency_id", this.currency_id);
}
if (this.iso2_cd.ValueChanged)
{
upd.AddValue("iso2_cd", this.iso2_cd);
}
if (this.iso3_cd.ValueChanged)
{
upd.AddValue("iso3_cd", this.iso3_cd);
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("cntry_cd", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
else
{
this.LastModifyAt.Value = DateTime.Now;
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Hss_UserConfig.Get_cmdTP());
if (this.UserName.ValueChanged)
{
upd.AddValue("UserName", this.UserName); /*Optional 2*/
}
if (this.ConfigXML.ValueChanged)
{
upd.AddValue("ConfigXML", this.ConfigXML); /*Optional 3*/
}
if (this.LastModifyAt.ValueChanged)
{
upd.AddValue("LastModifyAt", this.LastModifyAt); /*Optional 4*/
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Country_ProcedureTypes.Get_cmdTP());
if (this.IsSponsored.ValueChanged)
{
upd.AddValue("IsSponsored", this.IsSponsored);
}
if (this.At_Source.ValueChanged)
{
upd.AddValue("At_Source", this.At_Source);
}
if (this.Quick_Refund.ValueChanged)
{
upd.AddValue("Quick_Refund", this.Quick_Refund);
}
if (this.Long_Form.ValueChanged)
{
upd.AddValue("Long_Form", this.Long_Form);
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("Country", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(TestClass.Get_cmdTP());
if (this.Name.ValueChanged)
{
upd.AddValue("Name", this.Name); /*Optional 2*/
}
if (this.Birthday.ValueChanged)
{
upd.AddValue("Birthday", this.Birthday); /*Optional 3*/
}
if (this.Salary.ValueChanged)
{
upd.AddValue("Salary", this.Salary); /*Optional 4*/
}
if (this.IsMarried.ValueChanged)
{
upd.AddValue("IsMarried", this.IsMarried); /*Optional 5*/
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(ADR_Group.Get_cmdTP());
if (this.GroupName.ValueChanged)
{
upd.AddValue("GroupName", this.GroupName);
}
if (this.Group_LeaderSID.ValueChanged)
{
upd.AddValue("Group_LeaderSID", this.Group_LeaderSID);
}
if (this.Group_Email.ValueChanged)
{
upd.AddValue("Group_Email", this.Group_Email);
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("GroupID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
else
{
this.LastModifyAt.Value = DateTime.Now;
this.LastModifyBy.Value = Utility.CurrentUser;
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(SPR_file.Get_cmdTP());
if (this.FileName.ValueChanged)
{
upd.AddValue("FileName", this.FileName); /*Optional 2*/
}
if (this.CreateTime.ValueChanged)
{
upd.AddValue("CreateTime", this.CreateTime); /*Optional 3*/
}
if (this.CreateBy.ValueChanged)
{
upd.AddValue("CreateBy", this.CreateBy); /*Optional 5*/
}
if (this.Status.ValueChanged)
{
upd.AddValue("Status", this.Status); /*Optional 6*/
}
if (this.CUSIP.ValueChanged)
{
upd.AddValue("CUSIP", this.CUSIP); /*Optional 7*/
}
if (this.RecordDate.ValueChanged)
{
upd.AddValue("RecordDate", this.RecordDate); /*Optional 8*/
}
if (this.SecurityName.ValueChanged)
{
upd.AddValue("SecurityName", this.SecurityName); /*Optional 9*/
}
if (this.LastModifyAt.ValueChanged)
{
upd.AddValue("LastModifyAt", this.LastModifyAt); /*Optional 10*/
}
if (this.LastModifyBy.ValueChanged)
{
upd.AddValue("LastModifyBy", this.LastModifyBy); /*Optional 11*/
}
if (this.LastModifyAction.ValueChanged)
{
upd.AddValue("LastModifyAction", this.LastModifyAction); /*Optional 12*/
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(StatutoryRate_edi.Get_cmdTP());
if (this.coi.ValueChanged)
{
upd.AddValue("coi", this.coi);
}
if (this.cor.ValueChanged)
{
upd.AddValue("cor", this.cor);
}
if (this.statry_rt.ValueChanged)
{
upd.AddValue("statry_rt", this.statry_rt);
}
if (this.int_rt.ValueChanged)
{
upd.AddValue("int_rt", this.int_rt);
}
if (this.effect_dt.ValueChanged)
{
upd.AddValue("effect_dt", this.effect_dt);
}
if (this.created_dt.ValueChanged)
{
upd.AddValue("created_dt", this.created_dt);
}
if (this.modified_dt.ValueChanged)
{
upd.AddValue("modified_dt", this.modified_dt);
}
if (this.migratedId.ValueChanged)
{
upd.AddValue("migratedId", this.migratedId);
}
if (this.sec_type.ValueChanged)
{
upd.AddValue("sec_type", this.sec_type);
}
if (this.bo_typ.ValueChanged)
{
upd.AddValue("bo_typ", this.bo_typ);
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("id", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Dividend_Detail_full.Get_cmdTP());
//if (this.DividendIndex.ValueChanged) upd.AddValue("DividendIndex", this.DividendIndex);
if (this.DTC_Number.ValueChanged)
{
upd.AddValue("DTC_Number", this.DTC_Number);
}
//if (this.Depositary.ValueChanged) upd.AddValue("Depositary", this.Depositary);/*Optional 10*/
if (this.BO_COR.ValueChanged)
{
upd.AddValue("BO_COR", this.BO_COR); /*Optional 18*/
}
if (this.BO_EntityType.ValueChanged)
{
upd.AddValue("BO_EntityType", this.BO_EntityType); /*Optional 19*/
}
if (this.ReclaimRate.ValueChanged)
{
upd.AddValue("ReclaimRate", this.ReclaimRate); /*Optional 22*/
}
if (this.CustodianID.ValueChanged)
{
upd.AddValue("CustodianID", this.CustodianID); /*Optional 25*/
}
if (this.Status.ValueChanged)
{
upd.AddValue("Status", this.Status); /*Optional 27*/
}
if (this.RecordDatePosition.ValueChanged)
{
upd.AddValue("RecordDatePosition", this.RecordDatePosition); /*Optional 30*/
}
if (this.ReclaimFeesType.ValueChanged)
{
upd.AddValue("ReclaimFeesType", this.ReclaimFeesType); /*Optional 41*/
}
if (this.PaidViaDTCC.ValueChanged)
{
upd.AddValue("PaidViaDTCC", this.PaidViaDTCC); /*Optional 120*/
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("DetailID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(DividendXBRL.Get_cmdTP());
if (this.DividendIndex.ValueChanged)
{
upd.AddValue("DividendIndex", this.DividendIndex);
}
if (this.Depositary.ValueChanged)
{
upd.AddValue("Depositary", this.Depositary); /*Optional 3*/
}
if (this.XBRL_ReferenceNumber.ValueChanged)
{
upd.AddValue("XBRL_ReferenceNumber", this.XBRL_ReferenceNumber);
}
if (this.PSAFE.ValueChanged)
{
upd.AddValue("PSAFE", this.PSAFE); /*Optional 5*/
}
if (this.LastModifiedDate.ValueChanged)
{
upd.AddValue("LastModifiedDate", this.LastModifiedDate); /*Optional 6*/
}
if (this.SourceType.ValueChanged)
{
upd.AddValue("SourceType", this.SourceType); /*Optional 7*/
}
if (this.LastModifiedBy.ValueChanged)
{
upd.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 8*/
}
if (this.Announcement_Identifier.ValueChanged)
{
upd.AddValue("Announcement Identifier", this.Announcement_Identifier); /*Optional 9*/
}
if (this.Event_Completeness.ValueChanged)
{
upd.AddValue("Event Completeness", this.Event_Completeness); /*Optional 10*/
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("XBRL_ID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(ADR_TaskOwner.Get_cmdTP());
if (this.OwnerSID.ValueChanged)
{
upd.AddValue("OwnerSID", this.OwnerSID);
}
if (this.OwnerName.ValueChanged)
{
upd.AddValue("OwnerName", this.OwnerName);
}
if (this.Owner_LastName.ValueChanged)
{
upd.AddValue("Owner_LastName", this.Owner_LastName);
}
if (this.Owner_FirstName.ValueChanged)
{
upd.AddValue("Owner_FirstName", this.Owner_FirstName);
}
//if (this.AllProperties.ValueChanged) upd.AddValue("AllProperties", this.AllProperties);
if (this.Telephone.ValueChanged)
{
upd.AddValue("Telephone", this.Telephone);
}
if (this.Email.ValueChanged)
{
upd.AddValue("Email", this.Email);
}
if (this.Department.ValueChanged)
{
upd.AddValue("Department", this.Department);
}
if (this.Title.ValueChanged)
{
upd.AddValue("Title", this.Title);
}
//if (this.Signature.ValueChanged) upd.AddValue("Signature", this.Signature);
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("OwnerID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Schedule_Of_Fees_Per_Rate.Get_cmdTP());
if (this.Security_Type.ValueChanged)
{
upd.AddValue("Security_Type", this.Security_Type); /*Optional 2*/
}
if (this.Depositary.ValueChanged)
{
upd.AddValue("Depositary", this.Depositary);
}
if (this.WithholdingRate.ValueChanged)
{
upd.AddValue("WithholdingRate", this.WithholdingRate); /*Optional 4*/
}
if (this.ADSC.ValueChanged)
{
upd.AddValue("ADSC", this.ADSC); /*Optional 5*/
}
if (this.RateWithADSC.ValueChanged)
{
upd.AddValue("RateWithADSC", this.RateWithADSC); /*Optional 6*/
}
if (this.EffectiveDate.ValueChanged)
{
upd.AddValue("EffectiveDate", this.EffectiveDate); /*Optional 7*/
}
if (this.CreatedDate.ValueChanged)
{
upd.AddValue("CreatedDate", this.CreatedDate); /*Optional 8*/
}
if (this.ImportBy.ValueChanged)
{
upd.AddValue("ImportBy", this.ImportBy); /*Optional 9*/
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("Country", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Hss_DailyJobs.Get_cmdTP());
if (this.Job_Class.ValueChanged)
{
upd.AddValue("Job_Class", this.Job_Class); /*Optional 2*/
}
if (this.Job_ID.ValueChanged)
{
upd.AddValue("Job_ID", this.Job_ID); /*Optional 3*/
}
if (this.LastRunAt.ValueChanged)
{
upd.AddValue("LastRunAt", this.LastRunAt); /*Optional 4*/
}
if (this.LastRunBy.ValueChanged)
{
upd.AddValue("LastRunBy", this.LastRunBy); /*Optional 5*/
}
if (this.Locked.ValueChanged)
{
upd.AddValue("Locked", this.Locked); /*Optional 6*/
}
if (this.Notes.ValueChanged)
{
upd.AddValue("Notes", this.Notes); /*Optional 7*/
}
if (this.LastLockAt.ValueChanged)
{
upd.AddValue("LastLockAt", this.LastLockAt); /*Optional 8*/
}
if (this.LastLockBy.ValueChanged)
{
upd.AddValue("LastLockBy", this.LastLockBy); /*Optional 9*/
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
/// <summary>
/// Save updates to DB
/// </summary>
public bool Update_to_DB()
{
HssUtility.SQLserver.DB_update upd = this.Get_DBupdate();
if (upd == null)
{
return(false);
}
int count = upd.SaveToDB(Utility.Get_DRWIN_hDB());
bool flag = count > 0;
if (flag)
{
this.SyncWithDB();
}
return(flag);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(ADR_Member_Country.Get_cmdTP());
if (this.TaskOwner_SID.ValueChanged)
{
upd.AddValue("TaskOwner_SID", this.TaskOwner_SID);
}
if (this.ISO2CntryCode.ValueChanged)
{
upd.AddValue("ISO2CntryCode", this.ISO2CntryCode);
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Country.Get_cmdTP());
if (this.cntry_cd.ValueChanged)
{
upd.AddValue("cntry_cd", this.cntry_cd);
}
if (this.currency_id.ValueChanged)
{
upd.AddValue("currency_id", this.currency_id);
}
if (this.longform_coefficient.ValueChanged)
{
upd.AddValue("longform_coefficient", this.longform_coefficient);
}
if (this.In_ESP.ValueChanged)
{
upd.AddValue("In_ESP", this.In_ESP);
}
if (this.ISO3_cntry_cd.ValueChanged)
{
upd.AddValue("ISO3_cntry_cd", this.ISO3_cntry_cd);
}
if (this.GlobeTaxEmail.ValueChanged)
{
upd.AddValue("GlobeTaxEmail", this.GlobeTaxEmail);
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("name", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Task21_security.Get_cmdTP());
if (this.SecurityID.ValueChanged)
{
upd.AddValue("SecurityID", this.SecurityID);
}
if (this.TaskName.ValueChanged)
{
upd.AddValue("TaskName", this.TaskName);
}
if (this.Status.ValueChanged)
{
upd.AddValue("Status", this.Status);
}
if (this.ValueStr.ValueChanged)
{
upd.AddValue("ValueStr", this.ValueStr);
}
if (this.CreateBy.ValueChanged)
{
upd.AddValue("CreateBy", this.CreateBy);
}
if (this.CreateDate.ValueChanged)
{
upd.AddValue("CreateDate", this.CreateDate);
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(SavedFiles_CSV.Get_cmdTP());
if (this.originalFileName.ValueChanged)
{
upd.AddValue("originalFileName", this.originalFileName); /*Optional 2*/
}
//if (this.SavedFiles_CSV.ValueChanged) upd.AddValue("SavedFiles_CSV", this.SavedFiles_CSV);//no update for binary for now
if (this.FileCreationDate.ValueChanged)
{
upd.AddValue("FileCreationDate", this.FileCreationDate); /*Optional 4*/
}
if (this.FTP_Source.ValueChanged)
{
upd.AddValue("FTP_Source", this.FTP_Source); /*Optional 5*/
}
if (this.Status.ValueChanged)
{
upd.AddValue("Status", this.Status); /*Optional 6*/
}
if (this.DividendIndex.ValueChanged)
{
upd.AddValue("DividendIndex", this.DividendIndex); /*Optional 7*/
}
if (this.Depositary.ValueChanged)
{
upd.AddValue("Depositary", this.Depositary); /*Optional 8*/
}
if (this.DTC.ValueChanged)
{
upd.AddValue("DTC", this.DTC); /*Optional 9*/
}
if (this.ProcessTime.ValueChanged)
{
upd.AddValue("ProcessTime", this.ProcessTime); /*Optional 10*/
}
if (this.ProcessedBy.ValueChanged)
{
upd.AddValue("ProcessedBy", this.ProcessedBy); /*Optional 11*/
}
if (this.cpuFileName.ValueChanged)
{
upd.AddValue("cpuFileName", this.cpuFileName); /*Optional 12*/
}
//if (this.cpuSavedFiles_CSV.ValueChanged) upd.AddValue("cpuSavedFiles_CSV", this.cpuSavedFiles_CSV);//no update for binary for now
if (this.cpuStatus.ValueChanged)
{
upd.AddValue("cpuStatus", this.cpuStatus); /*Optional 14*/
}
if (this.cpuProcessTime.ValueChanged)
{
upd.AddValue("cpuProcessTime", this.cpuProcessTime); /*Optional 15*/
}
if (this.cpuProcessedBy.ValueChanged)
{
upd.AddValue("cpuProcessedBy", this.cpuProcessedBy); /*Optional 16*/
}
if (this.OriginalSchema.ValueChanged)
{
upd.AddValue("OriginalSchema", this.OriginalSchema); /*Optional 17*/
}
if (this.OriginalData.ValueChanged)
{
upd.AddValue("OriginalData", this.OriginalData); /*Optional 18*/
}
if (this.RecordDate.ValueChanged)
{
upd.AddValue("RecordDate", this.RecordDate); /*Optional 19*/
}
if (this.Sender.ValueChanged)
{
upd.AddValue("Sender", this.Sender); /*Optional 20*/
}
if (this.CUSIP.ValueChanged)
{
upd.AddValue("CUSIP", this.CUSIP); /*Optional 21*/
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("id_SavedFiles_CSV", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
else
{
this.LastModifiedBy.Value = Utility.CurrentUser;
this.LastModifiedDateTime.Value = DateTime.Now;
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Task_Detail.Get_cmdTP());
if (this.TaskID.ValueChanged)
{
upd.AddValue("TaskID", this.TaskID);
}
if (this.TaskName.ValueChanged)
{
upd.AddValue("TaskName", this.TaskName);
}
if (this.Country.ValueChanged)
{
upd.AddValue("Country", this.Country);
}
if (this.Depositary.ValueChanged)
{
upd.AddValue("Depositary", this.Depositary);
}
if (this.Issue.ValueChanged)
{
upd.AddValue("Issue", this.Issue);
}
if (this.CUSIP.ValueChanged)
{
upd.AddValue("CUSIP", this.CUSIP);
}
if (this.RecordDate.ValueChanged)
{
upd.AddValue("RecordDate", this.RecordDate);
}
if (this.SourceTable.ValueChanged)
{
upd.AddValue("SourceTable", this.SourceTable);
}
if (this.SourceID.ValueChanged)
{
upd.AddValue("SourceID", this.SourceID);
}
if (this.StartDate.ValueChanged)
{
upd.AddValue("StartDate", this.StartDate);
}
if (this.PriorityDate.ValueChanged)
{
upd.AddValue("PriorityDate", this.PriorityDate);
}
if (this.EndDate.ValueChanged)
{
upd.AddValue("EndDate", this.EndDate);
}
if (this.Notes.ValueChanged)
{
upd.AddValue("Notes", this.Notes);
}
if (this.Priority.ValueChanged)
{
upd.AddValue("Priority", this.Priority);
}
if (this.Completed.ValueChanged)
{
upd.AddValue("Completed", this.Completed);
}
if (this.CreatedBy.ValueChanged)
{
upd.AddValue("CreatedBy", this.CreatedBy);
}
if (this.CreatedDateTime.ValueChanged)
{
upd.AddValue("CreatedDateTime", this.CreatedDateTime);
}
if (this.CompletedBy.ValueChanged)
{
upd.AddValue("CompletedBy", this.CompletedBy);
}
if (this.CompletedDateTime.ValueChanged)
{
upd.AddValue("CompletedDateTime", this.CompletedDateTime);
}
if (this.LastModifiedBy.ValueChanged)
{
upd.AddValue("LastModifiedBy", this.LastModifiedBy);
}
if (this.LastModifiedDateTime.ValueChanged)
{
upd.AddValue("LastModifiedDateTime", this.LastModifiedDateTime);
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("TaskDetailID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(FX_Input.Get_cmdTP());
if (this.CountryName.ValueChanged)
{
upd.AddValue("CountryName", this.CountryName);
}
if (this.Custodian.ValueChanged)
{
upd.AddValue("Custodian", this.Custodian);
}
if (this.AccountNumber.ValueChanged)
{
upd.AddValue("AccountNumber", this.AccountNumber);
}
if (this.Currency_Code.ValueChanged)
{
upd.AddValue("Currency_Code", this.Currency_Code);
}
if (this.FX_NotificationDate.ValueChanged)
{
upd.AddValue("FX_NotificationDate", this.FX_NotificationDate);
}
if (this.LocalAmountReceived.ValueChanged)
{
upd.AddValue("LocalAmountReceived", this.LocalAmountReceived);
}
if (this.Depositary_ReceivedDate.ValueChanged)
{
upd.AddValue("Depositary_ReceivedDate", this.Depositary_ReceivedDate);
}
if (this.FX_RequestedDate.ValueChanged)
{
upd.AddValue("FX_RequestedDate", this.FX_RequestedDate);
}
if (this.FX_ReceivedDate.ValueChanged)
{
upd.AddValue("FX_ReceivedDate", this.FX_ReceivedDate);
}
if (this.Depositary.ValueChanged)
{
upd.AddValue("Depositary", this.Depositary);
}
if (this.FX_Rate.ValueChanged)
{
upd.AddValue("FX_Rate", this.FX_Rate);
}
if (this.USDAmountReceived.ValueChanged)
{
upd.AddValue("USDAmountReceived", this.USDAmountReceived);
}
if (this.ActualCheckRequestDate.ValueChanged)
{
upd.AddValue("ActualCheckRequestDate", this.ActualCheckRequestDate);
}
if (this.PayToBrokerDate.ValueChanged)
{
upd.AddValue("PayToBrokerDate", this.PayToBrokerDate);
}
if (this.LastModifiedBy.ValueChanged)
{
upd.AddValue("LastModifiedBy", this.LastModifiedBy);
}
if (this.ModifiedDateTime.ValueChanged)
{
upd.AddValue("ModifiedDateTime", this.ModifiedDateTime);
}
if (this.Forex_Fee.ValueChanged)
{
upd.AddValue("Forex_Fee", this.Forex_Fee);
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("FX_InputID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(XBRLfield.Get_cmdTP());
if (this.xbrlElement.ValueChanged)
{
upd.AddValue("xbrlElement", this.xbrlElement);
}
if (this.xbrlAttributeName.ValueChanged)
{
upd.AddValue("xbrlAttributeName", this.xbrlAttributeName);
}
if (this.xbrlContextRefValue.ValueChanged)
{
upd.AddValue("xbrlContextRefValue", this.xbrlContextRefValue);
}
if (this.NameSpace.ValueChanged)
{
upd.AddValue("namespace", this.NameSpace);
}
if (this.drwinFieldName.ValueChanged)
{
upd.AddValue("drwinFieldName", this.drwinFieldName);
}
if (this.drwinControlType.ValueChanged)
{
upd.AddValue("drwinControlType", this.drwinControlType);
}
if (this.multiple.ValueChanged)
{
upd.AddValue("multiple", this.multiple);
}
if (this.active.ValueChanged)
{
upd.AddValue("active", this.active);
}
if (this.chkCompleteness.ValueChanged)
{
upd.AddValue("chkCompleteness", this.chkCompleteness);
}
if (this.drwinFieldNameIncomplete.ValueChanged)
{
upd.AddValue("drwinFieldNameIncomplete", this.drwinFieldNameIncomplete);
}
if (this.drwinFieldNameComplete.ValueChanged)
{
upd.AddValue("drwinFieldNameComplete", this.drwinFieldNameComplete);
}
if (this.createdDate.ValueChanged)
{
upd.AddValue("createdDate", this.createdDate);
}
if (this.createdBy.ValueChanged)
{
upd.AddValue("createdBy", this.createdBy);
}
if (this.overridable.ValueChanged)
{
upd.AddValue("overridable", this.overridable);
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("id_XBRLField", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(DTC_Participants.Get_cmdTP());
if (this.DTC_Number.ValueChanged)
{
upd.AddValue("DTC_Number", this.DTC_Number);
}
if (this.Company_Name.ValueChanged)
{
upd.AddValue("Company_Name", this.Company_Name);
}
if (this.ATTN.ValueChanged)
{
upd.AddValue("ATTN", this.ATTN); /*Optional 4*/
}
if (this.Address1.ValueChanged)
{
upd.AddValue("Address1", this.Address1); /*Optional 5*/
}
if (this.Address2.ValueChanged)
{
upd.AddValue("Address2", this.Address2); /*Optional 6*/
}
if (this.City.ValueChanged)
{
upd.AddValue("City", this.City); /*Optional 7*/
}
if (this.State.ValueChanged)
{
upd.AddValue("State", this.State); /*Optional 8*/
}
if (this.Country.ValueChanged)
{
upd.AddValue("Country", this.Country); /*Optional 9*/
}
if (this.Zip_Postal_Code.ValueChanged)
{
upd.AddValue("Zip_Postal_Code", this.Zip_Postal_Code); /*Optional 10*/
}
if (this.Phone.ValueChanged)
{
upd.AddValue("Phone", this.Phone); /*Optional 11*/
}
if (this.Fax.ValueChanged)
{
upd.AddValue("Fax", this.Fax); /*Optional 12*/
}
if (this.WebsiteUrl.ValueChanged)
{
upd.AddValue("WebsiteUrl", this.WebsiteUrl); /*Optional 13*/
}
if (this.Email.ValueChanged)
{
upd.AddValue("Email", this.Email); /*Optional 14*/
}
if (this.Fixed_Payment_ATTN.ValueChanged)
{
upd.AddValue("Fixed_Payment_ATTN", this.Fixed_Payment_ATTN); /*Optional 15*/
}
if (this.Type.ValueChanged)
{
upd.AddValue("Type", this.Type); /*Optional 16*/
}
if (this.Depositary.ValueChanged)
{
upd.AddValue("Depositary", this.Depositary); /*Optional 17*/
}
if (this.RejectEmail.ValueChanged)
{
upd.AddValue("RejectEmail", this.RejectEmail); /*Optional 18*/
}
if (this.PaymentEmail.ValueChanged)
{
upd.AddValue("PaymentEmail", this.PaymentEmail); /*Optional 19*/
}
if (this.DocInventoryEmail.ValueChanged)
{
upd.AddValue("DocInventoryEmail", this.DocInventoryEmail); /*Optional 20*/
}
if (this.SecurityTypeID.ValueChanged)
{
upd.AddValue("SecurityTypeID", this.SecurityTypeID);
}
if (this.AccountNumber.ValueChanged)
{
upd.AddValue("AccountNumber", this.AccountNumber);
}
if (this.IssuerCSD.ValueChanged)
{
upd.AddValue("IssuerCSD", this.IssuerCSD); /*Optional 23*/
}
if (this.ACH_Override.ValueChanged)
{
upd.AddValue("ACH_Override", this.ACH_Override); /*Optional 24*/
}
if (this.ACH_Bank.ValueChanged)
{
upd.AddValue("ACH_Bank", this.ACH_Bank); /*Optional 25*/
}
if (this.ACH_ABA.ValueChanged)
{
upd.AddValue("ACH_ABA", this.ACH_ABA); /*Optional 26*/
}
if (this.ACH_Account.ValueChanged)
{
upd.AddValue("ACH_Account", this.ACH_Account); /*Optional 27*/
}
if (this.ClearingSystem.ValueChanged)
{
upd.AddValue("ClearingSystem", this.ClearingSystem);
}
if (this.CustomWireMemo.ValueChanged)
{
upd.AddValue("CustomWireMemo", this.CustomWireMemo); /*Optional 29*/
}
if (this.ModifiedDateTime.ValueChanged)
{
upd.AddValue("ModifiedDateTime", this.ModifiedDateTime); /*Optional 30*/
}
if (this.Email_backup.ValueChanged)
{
upd.AddValue("Email_backup", this.Email_backup); /*Optional 31*/
}
if (this.PaymentEmail_backup.ValueChanged)
{
upd.AddValue("PaymentEmail_backup", this.PaymentEmail_backup); /*Optional 32*/
}
if (this.RejectEmail_backup.ValueChanged)
{
upd.AddValue("RejectEmail_backup", this.RejectEmail_backup); /*Optional 33*/
}
if (this.DocInventoryEmail_backup.ValueChanged)
{
upd.AddValue("DocInventoryEmail_backup", this.DocInventoryEmail_backup); /*Optional 34*/
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("DTC", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(DTC_Position_Headers.Get_cmdTP());
if (this.ModelNumber.ValueChanged)
{
upd.AddValue("ModelNumber", this.ModelNumber);
}
if (this.Country.ValueChanged)
{
upd.AddValue("Country", this.Country);
}
if (this.Column_Header_Name.ValueChanged)
{
upd.AddValue("Column_Header_Name", this.Column_Header_Name);
}
if (this.Table_Column.ValueChanged)
{
upd.AddValue("Table_Column", this.Table_Column);
}
if (this.Rate_Desc.ValueChanged)
{
upd.AddValue("Rate_Desc", this.Rate_Desc);
}
if (this.WHRate.ValueChanged)
{
upd.AddValue("WHRate", this.WHRate);
}
if (this.ArmorColumn.ValueChanged)
{
upd.AddValue("ArmorColumn", this.ArmorColumn);
}
if (this.Category.ValueChanged)
{
upd.AddValue("Category", this.Category);
}
if (this.DiscloseType.ValueChanged)
{
upd.AddValue("DiscloseType", this.DiscloseType);
}
if (this.SortOrder.ValueChanged)
{
upd.AddValue("SortOrder", this.SortOrder);
}
if (this.ChargeBackFrom.ValueChanged)
{
upd.AddValue("ChargeBackFrom", this.ChargeBackFrom);
}
if (this.LastModifiedBy.ValueChanged)
{
upd.AddValue("LastModifiedBy", this.LastModifiedBy);
}
if (this.ModifiedDateTime.ValueChanged)
{
upd.AddValue("ModifiedDateTime", this.ModifiedDateTime);
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("ID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Dividend_Schedule_Of_Fees_DSC.Get_cmdTP());
if (this.DividendIndex.ValueChanged)
{
upd.AddValue("DividendIndex", this.DividendIndex);
}
if (this.WHRate.ValueChanged)
{
upd.AddValue("WHRate", this.WHRate);
}
if (this.LongFormFees.ValueChanged)
{
upd.AddValue("LongFormFees", this.LongFormFees);
}
if (this.MinLongFormFee.ValueChanged)
{
upd.AddValue("MinLongFormFee", this.MinLongFormFee);
}
if (this.Fee_Max.ValueChanged)
{
upd.AddValue("Fee_Max", this.Fee_Max);
}
if (this.Fee_Consularization.ValueChanged)
{
upd.AddValue("Fee_Consularization", this.Fee_Consularization);
}
if (this.FavAtSourceFee.ValueChanged)
{
upd.AddValue("FavAtSourceFee", this.FavAtSourceFee);
}
if (this.MinAtSourceFee.ValueChanged)
{
upd.AddValue("MinAtSourceFee", this.MinAtSourceFee);
}
if (this.ExemptAtSourceFee.ValueChanged)
{
upd.AddValue("ExemptAtSourceFee", this.ExemptAtSourceFee);
}
if (this.ShortFormFees.ValueChanged)
{
upd.AddValue("ShortFormFees", this.ShortFormFees);
}
if (this.Fee_AtSource.ValueChanged)
{
upd.AddValue("Fee_AtSource", this.Fee_AtSource);
}
if (this.MinQuickRefundFee.ValueChanged)
{
upd.AddValue("MinQuickRefundFee", this.MinQuickRefundFee);
}
if (this.FavTransparentEntityFee.ValueChanged)
{
upd.AddValue("FavTransparentEntityFee", this.FavTransparentEntityFee);
}
if (this.MinShortFormFee.ValueChanged)
{
upd.AddValue("MinShortFormFee", this.MinShortFormFee);
}
if (this.Fee_QuickRefund.ValueChanged)
{
upd.AddValue("Fee_QuickRefund", this.Fee_QuickRefund);
}
if (this.LastModifiedBy.ValueChanged)
{
upd.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 17*/
}
if (this.ModifiedDateTime.ValueChanged)
{
upd.AddValue("ModifiedDateTime", this.ModifiedDateTime); /*Optional 18*/
}
if (this.AdditionalDSCFee.ValueChanged)
{
upd.AddValue("AdditionalDSCFee", this.AdditionalDSCFee); /*Optional 19*/
}
if (this.Source_FeeID.ValueChanged)
{
upd.AddValue("Source_FeeID", this.Source_FeeID); /*Optional 20*/
}
if (this.AdditionalDSCFee1.ValueChanged)
{
upd.AddValue("AdditionalDSCFee1", this.AdditionalDSCFee1); /*Optional 21*/
}
if (this.AtSourceModifiedBy.ValueChanged)
{
upd.AddValue("AtSourceModifiedBy", this.AtSourceModifiedBy); /*Optional 22*/
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("Dividend_FeeID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(PrimaryCustodian.Get_cmdTP());
if (this.custodian_number.ValueChanged)
{
upd.AddValue("custodian_number", this.custodian_number);
}
if (this.name.ValueChanged)
{
upd.AddValue("name", this.name);
}
if (this.address1.ValueChanged)
{
upd.AddValue("address1", this.address1);
}
if (this.address2.ValueChanged)
{
upd.AddValue("address2", this.address2);
}
if (this.city.ValueChanged)
{
upd.AddValue("city", this.city);
}
if (this.state.ValueChanged)
{
upd.AddValue("state", this.state);
}
if (this.zip.ValueChanged)
{
upd.AddValue("zip", this.zip);
}
if (this.country_code.ValueChanged)
{
upd.AddValue("country_code", this.country_code);
}
if (this.attn.ValueChanged)
{
upd.AddValue("attn", this.attn);
}
if (this.phone.ValueChanged)
{
upd.AddValue("phone", this.phone);
}
if (this.fax.ValueChanged)
{
upd.AddValue("fax", this.fax);
}
if (this.email.ValueChanged)
{
upd.AddValue("email", this.email);
}
if (this.event_id.ValueChanged)
{
upd.AddValue("event_id", this.event_id);
}
if (this.psafe.ValueChanged)
{
upd.AddValue("psafe", this.psafe);
}
if (this.safe_keeping_account_number.ValueChanged)
{
upd.AddValue("safe_keeping_account_number", this.safe_keeping_account_number);
}
if (this.depositary_name.ValueChanged)
{
upd.AddValue("depositary_name", this.depositary_name);
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("primary_custodian_id", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(DividendCustodian.Get_cmdTP());
if (this.Custodian_Number.ValueChanged)
{
upd.AddValue("Custodian_Number", this.Custodian_Number);
}
if (this.DividendIndex.ValueChanged)
{
upd.AddValue("DividendIndex", this.DividendIndex);
}
if (this.Custodian.ValueChanged)
{
upd.AddValue("Custodian", this.Custodian);
}
if (this.Custodian_Reported.ValueChanged)
{
upd.AddValue("Custodian_Reported", this.Custodian_Reported);
}
if (this.Custodian_Paid.ValueChanged)
{
upd.AddValue("Custodian_Paid", this.Custodian_Paid);
}
if (this.FavAtSourceADRs.ValueChanged)
{
upd.AddValue("FavAtSourceADRs", this.FavAtSourceADRs);
}
if (this.ExemptAtSourceADRs.ValueChanged)
{
upd.AddValue("ExemptAtSourceADRs", this.ExemptAtSourceADRs);
}
if (this.FavTransparentEntityADRs.ValueChanged)
{
upd.AddValue("FavTransparentEntityADRs", this.FavTransparentEntityADRs);
}
if (this.Custodian_Chargeback.ValueChanged)
{
upd.AddValue("Custodian_Chargeback", this.Custodian_Chargeback);
}
if (this.SafeKeeping_AccountNum.ValueChanged)
{
upd.AddValue("SafeKeeping_AccountNum", this.SafeKeeping_AccountNum);
}
if (this.Cash_Account_Number.ValueChanged)
{
upd.AddValue("Cash_Account_Number", this.Cash_Account_Number);
}
if (this.Custodial_Fees.ValueChanged)
{
upd.AddValue("Custodial_Fees", this.Custodial_Fees);
}
if (this.AtSourceFeePerShare.ValueChanged)
{
upd.AddValue("AtSourceFeePerShare", this.AtSourceFeePerShare);
}
if (this.Custodian_Type.ValueChanged)
{
upd.AddValue("Custodian_Type", this.Custodian_Type);
}
if (this.Depositary.ValueChanged)
{
upd.AddValue("Depositary", this.Depositary);
}
if (this.Currency.ValueChanged)
{
upd.AddValue("Currency", this.Currency);
}
if (this.Base.ValueChanged)
{
upd.AddValue("Base", this.Base);
}
if (this.Custodial_Percent.ValueChanged)
{
upd.AddValue("Custodial_Percent", this.Custodial_Percent);
}
if (this.Maximum_Fees.ValueChanged)
{
upd.AddValue("Maximum_Fees", this.Maximum_Fees);
}
if (this.Minimum_Fees.ValueChanged)
{
upd.AddValue("Minimum_Fees", this.Minimum_Fees);
}
if (this.Contact_Name.ValueChanged)
{
upd.AddValue("Contact_Name", this.Contact_Name);
}
if (this.Reference_Number.ValueChanged)
{
upd.AddValue("Reference_Number", this.Reference_Number);
}
if (this.Address1.ValueChanged)
{
upd.AddValue("Address1", this.Address1);
}
if (this.Address2.ValueChanged)
{
upd.AddValue("Address2", this.Address2);
}
if (this.State.ValueChanged)
{
upd.AddValue("State", this.State);
}
if (this.City.ValueChanged)
{
upd.AddValue("City", this.City);
}
if (this.Zip.ValueChanged)
{
upd.AddValue("Zip", this.Zip);
}
if (this.Comments.ValueChanged)
{
upd.AddValue("Comments", this.Comments);
}
if (this.Email.ValueChanged)
{
upd.AddValue("Email", this.Email);
}
if (this.Fax.ValueChanged)
{
upd.AddValue("Fax", this.Fax);
}
if (this.Phone.ValueChanged)
{
upd.AddValue("Phone", this.Phone);
}
if (this.Country.ValueChanged)
{
upd.AddValue("Country", this.Country);
}
if (this.Primary_Contact.ValueChanged)
{
upd.AddValue("Primary_Contact", this.Primary_Contact);
}
if (this.MasterFile.ValueChanged)
{
upd.AddValue("MasterFile", this.MasterFile);
}
if (this.PDFFile.ValueChanged)
{
upd.AddValue("PDFFile", this.PDFFile);
}
if (this.Paid_And_Locked.ValueChanged)
{
upd.AddValue("Paid_And_Locked", this.Paid_And_Locked);
}
if (this.Paid_And_Locked_DateTime.ValueChanged)
{
upd.AddValue("Paid_And_Locked_DateTime", this.Paid_And_Locked_DateTime);
}
if (this.LastModifiedBy.ValueChanged)
{
upd.AddValue("LastModifiedBy", this.LastModifiedBy);
}
if (this.Billed_Date.ValueChanged)
{
upd.AddValue("Billed_Date", this.Billed_Date);
}
if (this.Paid_Date_Actual.ValueChanged)
{
upd.AddValue("Paid_Date_Actual", this.Paid_Date_Actual);
}
if (this.JPResidenceAtSourceADRs.ValueChanged)
{
upd.AddValue("JPResidenceAtSourceADRs", this.JPResidenceAtSourceADRs);
}
if (this.PSAFE.ValueChanged)
{
upd.AddValue("PSAFE", this.PSAFE);
}
if (this.Election_Version.ValueChanged)
{
upd.AddValue("Election_Version", this.Election_Version);
}
if (this.FavAtSourceADRs_RSH_Exclude.ValueChanged)
{
upd.AddValue("FavAtSourceADRs_RSH_Exclude", this.FavAtSourceADRs_RSH_Exclude);
}
if (this.WriteOff.ValueChanged)
{
upd.AddValue("WriteOff", this.WriteOff);
}
if (this.AffiliateRebate.ValueChanged)
{
upd.AddValue("AffiliateRebate", this.AffiliateRebate);
}
if (this.ModifiedDateTime.ValueChanged)
{
upd.AddValue("ModifiedDateTime", this.ModifiedDateTime);
}
if (this.Custodial_FeeID.ValueChanged)
{
upd.AddValue("Custodial_FeeID", this.Custodial_FeeID);
}
if (this.FeeType.ValueChanged)
{
upd.AddValue("FeeType", this.FeeType);
}
if (this.FavAtSourceADRs_Detail.ValueChanged)
{
upd.AddValue("FavAtSourceADRs_Detail", this.FavAtSourceADRs_Detail);
}
if (this.RSH_Email_TimeStamp.ValueChanged)
{
upd.AddValue("RSH_Email_TimeStamp", this.RSH_Email_TimeStamp);
}
if (this.Bal_Email_TimeStamp.ValueChanged)
{
upd.AddValue("Bal_Email_TimeStamp", this.Bal_Email_TimeStamp);
}
if (this.CreatedDateTime.ValueChanged)
{
upd.AddValue("CreatedDateTime", this.CreatedDateTime);
}
if (this.XBRL_ReferenceNumber.ValueChanged)
{
upd.AddValue("XBRL_ReferenceNumber", this.XBRL_ReferenceNumber);
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("CustodianID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(RSH_log.Get_cmdTP());
if (this.DividendIndex.ValueChanged)
{
upd.AddValue("DividendIndex", this.DividendIndex);
}
if (this.DTC.ValueChanged)
{
upd.AddValue("DTC", this.DTC);
}
if (this.Depositary.ValueChanged)
{
upd.AddValue("Depositary", this.Depositary);
}
if (this.AccountNumber.ValueChanged)
{
upd.AddValue("AccountNumber", this.AccountNumber); /*Optional 5*/
}
if (this.TIN.ValueChanged)
{
upd.AddValue("TIN", this.TIN); /*Optional 6*/
}
if (this.Shares.ValueChanged)
{
upd.AddValue("Shares", this.Shares); /*Optional 7*/
}
if (this.RegisteredName.ValueChanged)
{
upd.AddValue("RegisteredName", this.RegisteredName); /*Optional 8*/
}
if (this.Address.ValueChanged)
{
upd.AddValue("Address", this.Address); /*Optional 9*/
}
if (this.CountryCode.ValueChanged)
{
upd.AddValue("CountryCode", this.CountryCode); /*Optional 10*/
}
if (this.TaxStatus.ValueChanged)
{
upd.AddValue("TaxStatus", this.TaxStatus); /*Optional 11*/
}
if (this.ForeignTaxWH.ValueChanged)
{
upd.AddValue("ForeignTaxWH", this.ForeignTaxWH); /*Optional 12*/
}
if (this.CUSIP.ValueChanged)
{
upd.AddValue("CUSIP", this.CUSIP); /*Optional 13*/
}
if (this.IssueNumber.ValueChanged)
{
upd.AddValue("IssueNumber", this.IssueNumber); /*Optional 14*/
}
if (this.CitizenshipCode.ValueChanged)
{
upd.AddValue("CitizenshipCode", this.CitizenshipCode); /*Optional 15*/
}
if (this.OwnerCode.ValueChanged)
{
upd.AddValue("OwnerCode", this.OwnerCode); /*Optional 16*/
}
if (this.ZipCode.ValueChanged)
{
upd.AddValue("ZipCode", this.ZipCode); /*Optional 17*/
}
if (this.State.ValueChanged)
{
upd.AddValue("State", this.State); /*Optional 18*/
}
if (this.CityName.ValueChanged)
{
upd.AddValue("CityName", this.CityName); /*Optional 19*/
}
if (this.Agent.ValueChanged)
{
upd.AddValue("Agent", this.Agent); /*Optional 20*/
}
if (this.LOC.ValueChanged)
{
upd.AddValue("LOC", this.LOC); /*Optional 21*/
}
if (this.RecordDate.ValueChanged)
{
upd.AddValue("RecordDate", this.RecordDate); /*Optional 22*/
}
if (this.Comp_Num.ValueChanged)
{
upd.AddValue("Comp_Num", this.Comp_Num); /*Optional 23*/
}
if (this.Class_CD.ValueChanged)
{
upd.AddValue("Class_CD", this.Class_CD); /*Optional 24*/
}
if (this.Tax_CD.ValueChanged)
{
upd.AddValue("Tax_CD", this.Tax_CD); /*Optional 25*/
}
if (this.Shares2.ValueChanged)
{
upd.AddValue("Shares2", this.Shares2); /*Optional 26*/
}
if (this.GlobeTax.ValueChanged)
{
upd.AddValue("GlobeTax", this.GlobeTax); /*Optional 27*/
}
if (this.Dividend_Intention.ValueChanged)
{
upd.AddValue("Dividend_Intention", this.Dividend_Intention); /*Optional 28*/
}
if (this.Holder_On_Date.ValueChanged)
{
upd.AddValue("Holder_On_Date", this.Holder_On_Date); /*Optional 29*/
}
if (this.Tin_Status_1.ValueChanged)
{
upd.AddValue("Tin_Status_1", this.Tin_Status_1); /*Optional 30*/
}
if (this.Tin_Status_Source.ValueChanged)
{
upd.AddValue("Tin_Status_Source", this.Tin_Status_Source); /*Optional 31*/
}
if (this.Tin_Exp_Date_1.ValueChanged)
{
upd.AddValue("Tin_Exp_Date_1", this.Tin_Exp_Date_1); /*Optional 32*/
}
if (this.Tin_B_Count.ValueChanged)
{
upd.AddValue("Tin_B_Count", this.Tin_B_Count); /*Optional 33*/
}
if (this.Holder_Type_Code.ValueChanged)
{
upd.AddValue("Holder_Type_Code", this.Holder_Type_Code); /*Optional 34*/
}
if (this.Last_Contact_Date.ValueChanged)
{
upd.AddValue("Last_Contact_Date", this.Last_Contact_Date); /*Optional 35*/
}
if (this.Last_Contact_Type.ValueChanged)
{
upd.AddValue("Last_Contact_Type", this.Last_Contact_Type); /*Optional 36*/
}
if (this.GlobeTax_Findings.ValueChanged)
{
upd.AddValue("GlobeTax_Findings", this.GlobeTax_Findings); /*Optional 37*/
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("RSHID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Security.Get_cmdTP());
if (this.Name.ValueChanged)
{
upd.AddValue("Name", this.Name);
}
if (this.CUSIP.ValueChanged)
{
upd.AddValue("CUSIP", this.CUSIP);
}
if (this.Country.ValueChanged)
{
upd.AddValue("Country", this.Country);
}
if (this.TickerSymbol.ValueChanged)
{
upd.AddValue("TickerSymbol", this.TickerSymbol);
}
if (this.ISIN.ValueChanged)
{
upd.AddValue("ISIN", this.ISIN);
}
if (this.Sedol.ValueChanged)
{
upd.AddValue("Sedol", this.Sedol);
}
if (this.Depositary.ValueChanged)
{
upd.AddValue("Depositary", this.Depositary);
}
if (this.FirstFiler.ValueChanged)
{
upd.AddValue("FirstFiler", this.FirstFiler);
}
if (this.ClearingSystem.ValueChanged)
{
upd.AddValue("ClearingSystem", this.ClearingSystem);
}
if (this.SecurityType.ValueChanged)
{
upd.AddValue("SecurityType", this.SecurityType);
}
if (this.ModifiedDateTime.ValueChanged)
{
upd.AddValue("ModifiedDateTime", this.ModifiedDateTime);
}
if (this.LastModifiedBy.ValueChanged)
{
upd.AddValue("LastModifiedBy", this.LastModifiedBy);
}
if (this.EffectiveDate.ValueChanged)
{
upd.AddValue("EffectiveDate", this.EffectiveDate);
}
if (this.ADR_RATIO_ADR.ValueChanged)
{
upd.AddValue("ADR_RATIO_ADR", this.ADR_RATIO_ADR);
}
if (this.ADR_RATIO_ORD.ValueChanged)
{
upd.AddValue("ADR_RATIO_ORD", this.ADR_RATIO_ORD);
}
if (this.DutchName.ValueChanged)
{
upd.AddValue("DutchName", this.DutchName);
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("SecurityID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
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);
}
