/// <summary>
/// Returns a list of pages for the specified AppName
/// </summary>
/// <param name="appName">The application name </param>
/// <returns>the page list</returns>
public virtual IList <Page> GetPageList(string appName)
{
LoggerHelper.Info("Start");
IList <Page> list = null;
IList <DBParam> queryParams = new List <DBParam>();
try
{
StringBuilder query = new StringBuilder();
query.Append("SELECT * FROM Page P ");
query.Append("INNER JOIN PageApp A ON P.PageAppId = A.PageAppId ");
query.Append("WHERE A.AppName = @p0 ");
query.Append("ORDER BY Name ");
queryParams.Add(new DBParam(queryParams, appName, DbType.String));
LoggerHelper.Debug(query.ToString());
StatementWrapper wrapper = new StatementWrapper(query, queryParams);
ResultSetHandler <IList <Page> > h = new BeanListHandler <Page>(typeof(Page));
list = GetQueryRunner().Query(GetConnection(), wrapper, h);
}
catch (Exception e)
{
LoggerHelper.Error(e);
throw new Exception("Unable to get page list.", e);
}
finally
{
LoggerHelper.Info("End");
}
return(list);
}
/// <summary>
/// Returns a list a all page configurations defined in the database.
/// </summary>
/// <returns>The list of page configurations</returns>
public virtual IList <Page> GetPageList()
{
LoggerHelper.Info("Start");
IList <Page> list = null;
try
{
StringBuilder query = new StringBuilder();
query.Append("SELECT * FROM Page ORDER BY Name ");
LoggerHelper.Debug(query.ToString());
ResultSetHandler <IList <Page> > h = new BeanListHandler <Page>(typeof(Page));
list = GetQueryRunner().Query(GetConnection(), query, h);
}
catch (Exception e)
{
LoggerHelper.Error(e);
throw new Exception("Unable to get page list.", e);
}
finally
{
LoggerHelper.Info("End");
}
return(list);
}
/// <summary>
/// Returns a list of items related to the specified fieldname from a database.
/// </summary>
/// <param name="fieldName">The field name</param>
/// <param name="orderBy">The order in which the list will be returned</param>
/// <param name="orderType">The order type in which the list will be sorted</param>
/// <returns>The list of items in the specified order</returns>
public virtual IList <PageListItem> GetPageListItems(string fieldName, string orderBy, string orderType)
{
LoggerHelper.Info("Start");
IList <PageListItem> list = null;
try
{
StringBuilder query = new StringBuilder();
IList <DBParam> queryParams = new List <DBParam>();
query.Append("SELECT ItemId,FieldName,Value,Text,ShortText,Enable,Selected FROM PageListItem ");
query.Append("WHERE FieldName = @p0 AND Enable = 1 ");
if (String.IsNullOrEmpty(orderBy))
{
orderBy = "Text";
}
if (String.IsNullOrEmpty(orderType))
{
orderType = "ASC";
}
query.Append("ORDER BY ").Append(orderBy).Append(" ").Append(orderType);
LoggerHelper.Debug(query.ToString());
queryParams.Add(new DBParam(queryParams, fieldName, DbType.String));
StatementWrapper wrapper = new StatementWrapper(query, queryParams);
ResultSetHandler <IList <PageListItem> > h = new BeanListHandler <PageListItem>(typeof(PageListItem));
list = GetQueryRunner().Query(GetConnection(), wrapper, h);
}
catch (Exception e)
{
LoggerHelper.Error(e);
throw new Exception("Unable to fetch " + fieldName + " list Items.", e);
}
finally
{
LoggerHelper.Info("End");
}
return(list);
}
