public IList <QuarterlyReviewTemplate> Get(int clientId)
{
try
{
Logger.LogInfo("Get: Quarterly review template process start");
IList <QuarterlyReviewTemplate> quarterlyReviewTemplates = new List <QuarterlyReviewTemplate>();
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(GET_QUARTERLY_REVIEW_TEMPLATE,
clientId));
foreach (DataRow dr in dtAppConfig.Rows)
{
QuarterlyReviewTemplate quarterlyReviewTemplate = convertToQuarterlyReviewTemplateObject(dr);
quarterlyReviewTemplates.Add(quarterlyReviewTemplate);
}
Logger.LogInfo("Get: Quarterly review template process completed.");
return(quarterlyReviewTemplates);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
return(null);
}
}
private QuarterlyReviewTemplate convertToQuarterlyReviewTemplateObject(DataRow dr)
{
QuarterlyReviewTemplate quarterlyReviewTemplate = new QuarterlyReviewTemplate();
quarterlyReviewTemplate.Id = dr.Field <int>("ID");
quarterlyReviewTemplate.Cid = dr.Field <int>("cid");
quarterlyReviewTemplate.IsSelected = dr.Field <bool>("IsSelected");
quarterlyReviewTemplate.InvestmentType = dr.Field <string>("InvestmentType");
quarterlyReviewTemplate.IsLoanSelected = dr.Field <bool>("IsLoanSelected");
return(quarterlyReviewTemplate);
}