public List <Dividend_Detail_simpleEF> Get_dvdDetail_list(string reclaimFeeType) { List <Dividend_Detail_simpleEF> list = new List <Dividend_Detail_simpleEF>(); DB_select selt = new DB_select(Dividend_Detail_simpleEF.Get_cmdTP()); SQL_relation rela0 = new SQL_relation("DividendIndex", RelationalOperator.Equals, this.DividendIndex); if (string.IsNullOrEmpty(reclaimFeeType)) { selt.SetCondition(rela0); } else { SQL_relation rela1 = new SQL_relation("ReclaimFeesType", RelationalOperator.Equals, reclaimFeeType); SQL_condition cond = new SQL_condition(rela0, ConditionalOperator.And, rela1); selt.SetCondition(cond); } DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB()); while (reader.Read()) { Dividend_Detail_simpleEF dd = new Dividend_Detail_simpleEF(); dd.Init_from_reader(reader); list.Add(dd); } reader.Close(); return(list); }
/// <summary> /// Check if DividendDetail is OK for counting in Election File /// </summary> private bool Check_DD_forEle(Dividend_Detail_simpleEF dd, Dividend dvd) { if (dd.Status.Value.StartsWith("Reject", StringComparison.OrdinalIgnoreCase)) { return(false); } if (!dvd.Sponsored.Value)//for Unsponsored events only { int custID = dd.CustodianID.Value; if (!this.dvdCus_dic_all.ContainsKey(custID)) { return(false); } else { DividendCustodian dc = this.dvdCus_dic_all[custID]; if (!dc.Depositary.Value.Equals(this.dvdCust.Depositary.Value, StringComparison.OrdinalIgnoreCase)) { return(false); } } } if (dd.ReclaimFeesType.Value.Equals("At-Source", StringComparison.OrdinalIgnoreCase)) { return(true); } else if (dd.ReclaimFeesType.Value.Equals("Quick-Refund", StringComparison.OrdinalIgnoreCase)) { return(dd.PaidViaDTCC.Value); } else { return(false); } }