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