public IList <PPFMaturity> GetPPFMaturity(DateTime from, DateTime to) { try { Logger.LogInfo("Get: PPF maturity process start"); IList <PPFMaturity> lstPPFOption = new List <PPFMaturity>(); DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_PPF_MATURITY, from.ToString("yyyy-MM-dd"), to.ToString("yyyy-MM-dd"))); foreach (DataRow dr in dtAppConfig.Rows) { PPFMaturity mf = convertToPPFMaturity(dr); lstPPFOption.Add(mf); } Logger.LogInfo("Get: PPF maturity process completed."); return(lstPPFOption); } catch (Exception ex) { StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); MethodBase currentMethodName = sf.GetMethod(); LogDebug(currentMethodName.Name, ex); return(null); } }
private PPFMaturity convertToPPFMaturity(DataRow dr) { PPFMaturity maturity = new PPFMaturity(); maturity.InvesterName = dr.Field <string>("InvesterName"); maturity.ClientName = dr.Field <string>("Name"); maturity.AccountNo = dr.Field <string>("AccountNo"); maturity.BankName = dr.Field <string>("Bank"); maturity.MaturityDate = dr.Field <DateTime>("MaturityDate"); //maturity.IsAccountExtended = (dr["IsAccountExtended"] == null) ? false : bool.Parse(dr.Field<string>("IsAccountExtended")); return(maturity); }