public IList <LicPremiumReminder> GetLICPolicyMaturity(DateTime fromDate, DateTime toDate)
{
try
{
Logger.LogInfo("Get: Life insurance premium date process start");
IList <LicPremiumReminder> lstLifeInsurance = new List <LicPremiumReminder>();
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_MATURITY_DATE, fromDate.ToString("yyyy-MM-dd"), toDate.ToString("yyyy-MM-dd")));
foreach (DataRow dr in dtAppConfig.Rows)
{
LicPremiumReminder lifeInsurance = convertToLicPremiumReminder(dr);
lstLifeInsurance.Add(lifeInsurance);
}
Logger.LogInfo("Get: Life insurance premium process completed.");
return(lstLifeInsurance);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
return(null);
}
}
private LicPremiumReminder convertToLicPremiumReminder(DataRow dr)
{
LicPremiumReminder licPremiumReminder = new LicPremiumReminder();
licPremiumReminder.Applicant = dr.Field <string>("Applicant");
licPremiumReminder.ClientName = dr.Field <string>("Name");
licPremiumReminder.Company = dr.Field <string>("Company");
licPremiumReminder.PolicyName = dr.Field <string>("PolicyName");
licPremiumReminder.PolicyNo = dr.Field <string>("PolicyNo");
licPremiumReminder.PremiumDate = DateTime.Parse(dr.Field <string>("NextPremDate"));
licPremiumReminder.PremiumAmount = Double.Parse(dr["Premium"].ToString()); //Double.Parse(dr["Balance"].ToString());
return(licPremiumReminder);
}