/// <summary> /// Gets message of the collection of entity of common. /// </summary> /// <param name="criteria"></param> /// <param name="queryPagingSetting"></param> /// <param name="queryOrderBySettingCollection"></param> /// <returns>business layer built-in message <see cref="Elmah.DataSourceEntities.MapItemCollection"/></returns> public async Task <Elmah.CommonBLLEntities.BusinessLogicLayerResponseMessageMapItemCollection> GetMessageOfMapItems( Elmah.CommonBLLEntities.GeoSearchCriteria criteria , Framework.Queries.QueryPagingSetting queryPagingSetting , Framework.Queries.QueryOrderBySettingCollection queryOrderBySettingCollection , Framework.Models.DataServiceTypes dataServiceType) { //log.Info(string.Format("{0}: GetMessageOfMapItems", Framework.Models.LoggingOptions.UI_Process_Started.ToString())); var _Request = new Elmah.CommonBLLEntities.GeoSearchRequestMessage(); _Request.Criteria = criteria; _Request.QueryPagingSetting = queryPagingSetting; if (queryOrderBySettingCollection == null || queryOrderBySettingCollection.Count == 0) { _Request.QueryOrderBySettingCollection = new Framework.Queries.QueryOrderBySettingCollection(); _Request.QueryOrderBySettingCollection.Add("Name", Framework.Queries.QueryOrderDirections.Ascending); } else { _Request.QueryOrderBySettingCollection = queryOrderBySettingCollection; } _Request.DataServiceType = dataServiceType; var _Response = await GetMapItems(_Request); return(_Response); }
/// <summary> /// Gets message of the collection of entity of common. /// </summary> /// <param name="criteria"></param> /// <param name="queryPagingSetting"></param> /// <param name="queryOrderBySettingCollection"></param> /// <returns>business layer built-in message <see cref="Elmah.DataSourceEntities.MapItemCollection"/></returns> public async Task <Elmah.CommonBLLEntities.BusinessLogicLayerResponseMessageMapItemCollection> GetMessageOfMapItems( Elmah.CommonBLLEntities.GeoSearchCriteria criteria , Framework.Queries.QueryPagingSetting queryPagingSetting , Framework.Queries.QueryOrderBySettingCollection queryOrderBySettingCollection) { return(await GetMessageOfMapItems( criteria , queryPagingSetting , queryOrderBySettingCollection , Framework.Models.DataServiceTypes.DataSourceResult)); }
public async Task <List <TItem> > Load( TCommonCriteria criteria , Framework.Queries.QueryPagingSetting queryPagingSetting , Framework.Queries.QueryOrderBySetting queryOrderBySetting , Func <TableQuery <TSQLiteItem>, Framework.Queries.QueryOrderDirections, TableQuery <TSQLiteItem> > sortFunction) { var predicate = GetSQLiteTableQueryPredicate_Common(criteria); var tableQuery = _database.Table <TSQLiteItem>().Where(predicate); if (sortFunction != null) { tableQuery = sortFunction(tableQuery, queryOrderBySetting.Direction); } tableQuery = tableQuery.Skip((queryPagingSetting.CurrentPage - 1) * queryPagingSetting.PageSize).Take(queryPagingSetting.PageSize); return (await Task.FromResult((from t in tableQuery select(TItem) t).ToList())); }
public virtual Framework.Queries.QueryPagingSetting GetDefaultQueryPagingSetting() { Framework.Queries.QueryPagingSetting queryPagingSetting = new Framework.Queries.QueryPagingSetting(); return(queryPagingSetting); }