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