public Dividend_Schedule_Of_Fees_DSC GetCopy() { Dividend_Schedule_Of_Fees_DSC newEntity = new Dividend_Schedule_Of_Fees_DSC(); if (!this.DividendIndex.IsNull_flag) { newEntity.DividendIndex.Value = this.DividendIndex.Value; } if (!this.WHRate.IsNull_flag) { newEntity.WHRate.Value = this.WHRate.Value; } if (!this.LongFormFees.IsNull_flag) { newEntity.LongFormFees.Value = this.LongFormFees.Value; } if (!this.MinLongFormFee.IsNull_flag) { newEntity.MinLongFormFee.Value = this.MinLongFormFee.Value; } if (!this.Fee_Max.IsNull_flag) { newEntity.Fee_Max.Value = this.Fee_Max.Value; } if (!this.Fee_Consularization.IsNull_flag) { newEntity.Fee_Consularization.Value = this.Fee_Consularization.Value; } if (!this.FavAtSourceFee.IsNull_flag) { newEntity.FavAtSourceFee.Value = this.FavAtSourceFee.Value; } if (!this.MinAtSourceFee.IsNull_flag) { newEntity.MinAtSourceFee.Value = this.MinAtSourceFee.Value; } if (!this.ExemptAtSourceFee.IsNull_flag) { newEntity.ExemptAtSourceFee.Value = this.ExemptAtSourceFee.Value; } if (!this.ShortFormFees.IsNull_flag) { newEntity.ShortFormFees.Value = this.ShortFormFees.Value; } if (!this.Fee_AtSource.IsNull_flag) { newEntity.Fee_AtSource.Value = this.Fee_AtSource.Value; } if (!this.MinQuickRefundFee.IsNull_flag) { newEntity.MinQuickRefundFee.Value = this.MinQuickRefundFee.Value; } if (!this.FavTransparentEntityFee.IsNull_flag) { newEntity.FavTransparentEntityFee.Value = this.FavTransparentEntityFee.Value; } if (!this.MinShortFormFee.IsNull_flag) { newEntity.MinShortFormFee.Value = this.MinShortFormFee.Value; } if (!this.Fee_QuickRefund.IsNull_flag) { newEntity.Fee_QuickRefund.Value = this.Fee_QuickRefund.Value; } if (!this.LastModifiedBy.IsNull_flag) { newEntity.LastModifiedBy.Value = this.LastModifiedBy.Value; } if (!this.ModifiedDateTime.IsNull_flag) { newEntity.ModifiedDateTime.Value = this.ModifiedDateTime.Value; } if (!this.AdditionalDSCFee.IsNull_flag) { newEntity.AdditionalDSCFee.Value = this.AdditionalDSCFee.Value; } if (!this.Source_FeeID.IsNull_flag) { newEntity.Source_FeeID.Value = this.Source_FeeID.Value; } if (!this.AdditionalDSCFee1.IsNull_flag) { newEntity.AdditionalDSCFee1.Value = this.AdditionalDSCFee1.Value; } if (!this.AtSourceModifiedBy.IsNull_flag) { newEntity.AtSourceModifiedBy.Value = this.AtSourceModifiedBy.Value; } return(newEntity); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Dividend_Schedule_Of_Fees_DSC.Get_cmdTP()); dbIns.AddValue("DividendIndex", this.DividendIndex); dbIns.AddValue("WHRate", this.WHRate); dbIns.AddValue("LongFormFees", this.LongFormFees); dbIns.AddValue("MinLongFormFee", this.MinLongFormFee); dbIns.AddValue("Fee_Max", this.Fee_Max); dbIns.AddValue("Fee_Consularization", this.Fee_Consularization); dbIns.AddValue("FavAtSourceFee", this.FavAtSourceFee); dbIns.AddValue("MinAtSourceFee", this.MinAtSourceFee); dbIns.AddValue("ExemptAtSourceFee", this.ExemptAtSourceFee); dbIns.AddValue("ShortFormFees", this.ShortFormFees); dbIns.AddValue("Fee_AtSource", this.Fee_AtSource); dbIns.AddValue("MinQuickRefundFee", this.MinQuickRefundFee); dbIns.AddValue("FavTransparentEntityFee", this.FavTransparentEntityFee); dbIns.AddValue("MinShortFormFee", this.MinShortFormFee); dbIns.AddValue("Fee_QuickRefund", this.Fee_QuickRefund); dbIns.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 17*/ dbIns.AddValue("ModifiedDateTime", this.ModifiedDateTime); /*Optional 18*/ dbIns.AddValue("AdditionalDSCFee", this.AdditionalDSCFee); /*Optional 19*/ dbIns.AddValue("Source_FeeID", this.Source_FeeID); /*Optional 20*/ dbIns.AddValue("AdditionalDSCFee1", this.AdditionalDSCFee1); /*Optional 21*/ dbIns.AddValue("AtSourceModifiedBy", this.AtSourceModifiedBy); /*Optional 22*/ return(dbIns); }
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); }
/// <summary> /// Initialize object from DB /// </summary> public bool Init_from_DB() { if (this.Dividend_FeeID < 0) { return(false); } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(Dividend_Schedule_Of_Fees_DSC.Get_cmdTP()); db_sel.tableName = "Dividend_Schedule_Of_Fees_DSC"; HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("Dividend_FeeID", HssUtility.General.RelationalOperator.Equals, this.Dividend_FeeID); db_sel.SetCondition(rela); bool res_flag = false; HssUtility.SQLserver.DB_reader reader = new HssUtility.SQLserver.DB_reader(db_sel, Utility.Get_DRWIN_hDB()); if (reader.Read()) { this.Init_from_reader(reader); res_flag = true; } reader.Close(); return(res_flag); }