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