public static List <Dividend_Filing> GetList_dvdIndex(int dvdIndex) { List <Dividend_Filing> df_list = new List <Dividend_Filing>(); DB_select selt = new DB_select(Dividend_Filing.Get_cmdTP()); SQL_relation rela = new SQL_relation("DividendIndex", RelationalOperator.Equals, dvdIndex); selt.SetCondition(rela); DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB()); while (reader.Read()) { Dividend_Filing df = new Dividend_Filing(); df.Init_from_reader(reader); df_list.Add(df); } reader.Close(); return(df_list); }
public Dividend_Filing GetCopy() { Dividend_Filing newEntity = new Dividend_Filing(); if (!this.DividendIndex.IsNull_flag) { newEntity.DividendIndex.Value = this.DividendIndex.Value; } if (!this.Custodian_Tax_Authority.IsNull_flag) { newEntity.Custodian_Tax_Authority.Value = this.Custodian_Tax_Authority.Value; } if (!this.FiledDate.IsNull_flag) { newEntity.FiledDate.Value = this.FiledDate.Value; } if (!this.Num_ADRs_Filed.IsNull_flag) { newEntity.Num_ADRs_Filed.Value = this.Num_ADRs_Filed.Value; } if (!this.Num_ORDs_Filed.IsNull_flag) { newEntity.Num_ORDs_Filed.Value = this.Num_ORDs_Filed.Value; } if (!this.FedEx_Number.IsNull_flag) { newEntity.FedEx_Number.Value = this.FedEx_Number.Value; } if (!this.Filing_Method.IsNull_flag) { newEntity.Filing_Method.Value = this.Filing_Method.Value; } if (!this.Reference_Number.IsNull_flag) { newEntity.Reference_Number.Value = this.Reference_Number.Value; } if (!this.Delivery_Status.IsNull_flag) { newEntity.Delivery_Status.Value = this.Delivery_Status.Value; } if (!this.Accept.IsNull_flag) { newEntity.Accept.Value = this.Accept.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.Custodial_Receipt_Date.IsNull_flag) { newEntity.Custodial_Receipt_Date.Value = this.Custodial_Receipt_Date.Value; } if (!this.CustodianID.IsNull_flag) { newEntity.CustodianID.Value = this.CustodianID.Value; } if (!this.ReclaimFeesType.IsNull_flag) { newEntity.ReclaimFeesType.Value = this.ReclaimFeesType.Value; } if (!this.Master_Reference_Number.IsNull_flag) { newEntity.Master_Reference_Number.Value = this.Master_Reference_Number.Value; } if (!this.FilingStatus.IsNull_flag) { newEntity.FilingStatus.Value = this.FilingStatus.Value; } if (!this.Allowed_ReclaimFeesTypes.IsNull_flag) { newEntity.Allowed_ReclaimFeesTypes.Value = this.Allowed_ReclaimFeesTypes.Value; } if (!this.FilingTo.IsNull_flag) { newEntity.FilingTo.Value = this.FilingTo.Value; } return(newEntity); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(Dividend_Filing.Get_cmdTP()); if (this.DividendIndex.ValueChanged) { upd.AddValue("DividendIndex", this.DividendIndex); } if (this.Custodian_Tax_Authority.ValueChanged) { upd.AddValue("Custodian_Tax_Authority", this.Custodian_Tax_Authority); /*Optional 3*/ } if (this.FiledDate.ValueChanged) { upd.AddValue("FiledDate", this.FiledDate); } if (this.Num_ADRs_Filed.ValueChanged) { upd.AddValue("Num_ADRs_Filed", this.Num_ADRs_Filed); /*Optional 5*/ } if (this.Num_ORDs_Filed.ValueChanged) { upd.AddValue("Num_ORDs_Filed", this.Num_ORDs_Filed); /*Optional 6*/ } if (this.FedEx_Number.ValueChanged) { upd.AddValue("FedEx_Number", this.FedEx_Number); /*Optional 7*/ } if (this.Filing_Method.ValueChanged) { upd.AddValue("Filing_Method", this.Filing_Method); /*Optional 8*/ } if (this.Reference_Number.ValueChanged) { upd.AddValue("Reference_Number", this.Reference_Number); /*Optional 9*/ } if (this.Delivery_Status.ValueChanged) { upd.AddValue("Delivery_Status", this.Delivery_Status); /*Optional 10*/ } if (this.Accept.ValueChanged) { upd.AddValue("Accept", this.Accept); /*Optional 11*/ } if (this.LastModifiedBy.ValueChanged) { upd.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 12*/ } if (this.ModifiedDateTime.ValueChanged) { upd.AddValue("ModifiedDateTime", this.ModifiedDateTime); /*Optional 13*/ } if (this.Custodial_Receipt_Date.ValueChanged) { upd.AddValue("Custodial_Receipt_Date", this.Custodial_Receipt_Date); /*Optional 14*/ } if (this.CustodianID.ValueChanged) { upd.AddValue("CustodianID", this.CustodianID); /*Optional 15*/ } if (this.ReclaimFeesType.ValueChanged) { upd.AddValue("ReclaimFeesType", this.ReclaimFeesType); /*Optional 16*/ } if (this.Master_Reference_Number.ValueChanged) { upd.AddValue("Master_Reference_Number", this.Master_Reference_Number); /*Optional 17*/ } if (this.FilingStatus.ValueChanged) { upd.AddValue("FilingStatus", this.FilingStatus); /*Optional 18*/ } if (this.Allowed_ReclaimFeesTypes.ValueChanged) { upd.AddValue("Allowed_ReclaimFeesTypes", this.Allowed_ReclaimFeesTypes); /*Optional 19*/ } if (this.FilingTo.ValueChanged) { upd.AddValue("FilingTo", this.FilingTo); /*Optional 20*/ } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("Dividend_FilingID", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(Dividend_Filing.Get_cmdTP()); dbIns.AddValue("DividendIndex", this.DividendIndex); dbIns.AddValue("Custodian_Tax_Authority", this.Custodian_Tax_Authority); /*Optional 3*/ dbIns.AddValue("FiledDate", this.FiledDate); dbIns.AddValue("Num_ADRs_Filed", this.Num_ADRs_Filed); /*Optional 5*/ dbIns.AddValue("Num_ORDs_Filed", this.Num_ORDs_Filed); /*Optional 6*/ dbIns.AddValue("FedEx_Number", this.FedEx_Number); /*Optional 7*/ dbIns.AddValue("Filing_Method", this.Filing_Method); /*Optional 8*/ dbIns.AddValue("Reference_Number", this.Reference_Number); /*Optional 9*/ dbIns.AddValue("Delivery_Status", this.Delivery_Status); /*Optional 10*/ dbIns.AddValue("Accept", this.Accept); /*Optional 11*/ dbIns.AddValue("LastModifiedBy", this.LastModifiedBy); /*Optional 12*/ dbIns.AddValue("ModifiedDateTime", this.ModifiedDateTime); /*Optional 13*/ dbIns.AddValue("Custodial_Receipt_Date", this.Custodial_Receipt_Date); /*Optional 14*/ dbIns.AddValue("CustodianID", this.CustodianID); /*Optional 15*/ dbIns.AddValue("ReclaimFeesType", this.ReclaimFeesType); /*Optional 16*/ dbIns.AddValue("Master_Reference_Number", this.Master_Reference_Number); /*Optional 17*/ dbIns.AddValue("FilingStatus", this.FilingStatus); /*Optional 18*/ dbIns.AddValue("Allowed_ReclaimFeesTypes", this.Allowed_ReclaimFeesTypes); /*Optional 19*/ dbIns.AddValue("FilingTo", this.FilingTo); /*Optional 20*/ return(dbIns); }
/// <summary> /// Initialize object from DB /// </summary> public bool Init_from_DB() { if (this.Dividend_FilingID < 0) { return(false); } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(Dividend_Filing.Get_cmdTP()); db_sel.tableName = "Dividend_Filing"; HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("Dividend_FilingID", HssUtility.General.RelationalOperator.Equals, this.Dividend_FilingID); 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); }