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