private IEnumerator _FetchLevels(SortOption sortOption, string searchTerm, int limit, int offset, System.Action <LevelInfo[]> levelInfos)
{
string sort = sortOption.ToString();
WWWForm form = new WWWForm();
form.AddField("sortOption", sort);
form.AddField("limit", limit);
form.AddField("offset", offset);
if (!string.IsNullOrEmpty(searchTerm))
{
form.AddField("searchTerm", searchTerm);
}
WWW www = new WWW(Url.WEBSITE + Url.FETCH_LEVELS, form);
yield return(www);
if (www.error == null)
{
LevelInfoCollection levelInfoCollection = new LevelInfoCollection();
try {
levelInfoCollection = JsonUtility.FromJson <LevelInfoCollection>(www.text);
levelInfos(levelInfoCollection.levelInfos);
} catch (System.Exception exception) {
Debug.LogError(exception);
levelInfos(null);
}
}
else
{
Debug.LogError(www.error);
levelInfos(null);
}
}
/// <summary>
///
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="pageNumber"></param>
/// <param name="pageSize"></param>
/// <param name="totalRecordsQuery"></param>
/// <param name="predicate"></param>
/// <param name="sortBy"></param>
/// <param name="orderBy"></param>
/// <returns></returns>
protected override string GetPagingQuery <T>(int pageNumber, int pageSize, out string totalRecordsQuery, System.Linq.Expressions.Expression <Func <T, bool> > predicate = null, SortOption sortBy = SortOption.ASC, params System.Linq.Expressions.Expression <Func <T, object> >[] orderBy)
{
WD.DataAccess.QueryProviders.QueryBuilder <T> qbe = new WD.DataAccess.QueryProviders.QueryBuilder <T>();
qbe.Where(predicate);
qbe.OrderBy(orderBy);
totalRecordsQuery = String.Format("SELECT Count(1) FROM {0} {1}", HelperUtility.GetTableName <T>(), qbe.Where());
return(String.Format("SELECT * FROM (SELECT RowNum R,E.* FROM ({0} {1}) WHERE R BETWEEN {2} AND {3}", qbe.Select(), sortBy.ToString(), ((pageNumber - 1) * pageSize) + 1, pageNumber * pageSize));
}
public ISearchQuery SortBy(string sortColumn, SortOption sortOption)
{
return SortBy(sortColumn, sortOption.ToString());
}
public ISearchQuery SortBy(string sortColumn, SortOption sortOption)
{
return(SortBy(sortColumn, sortOption.ToString()));
}
