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