public async Task <ZoneAreaGetAllResponse> GetAllAsync(ZoneAreaGetAllRequest req)
{
if (req.Predicate != null && req.Predicate.Filter != null && req.Predicate.Filter.FilterQueries.Any())
{
var tempFilter = req.Predicate.Filter.FilterQueries.FirstOrDefault(x => x.ColumnName.Equals("zonename", StringComparison.CurrentCultureIgnoreCase));
if (tempFilter != null)
{
tempFilter.ColumnName = "Name";
}
}
if (req.Predicate != null && req.Predicate.Sort != null && req.Predicate.Sort.SortConditions.Any())
{
var tempSort = req.Predicate.Sort.SortConditions.FirstOrDefault(x => x.ColumnName.Equals("zonename", StringComparison.CurrentCultureIgnoreCase));
if (tempSort != null)
{
tempSort.ColumnName = "Zone";
req.Predicate.Sort.SortConditions.Add(new Common.ViewAction.SortCondition {
ColumnName = "Name", SortType = tempSort.SortType
});
}
}
var result = await _repos.GetAllAsync(req);
return(result);
}
public async Task <ZoneAreaGetAllResponse> GetAllAsync(ZoneAreaGetAllRequest req)
{
var resp = new ZoneAreaGetAllResponse();
var tempQuery = string.Empty;
var startRow = 0;
var endRow = 0;
if (req.Predicate != null)
{
tempQuery = req.Predicate.ConvertToString();
startRow = req.Predicate.StartRow;
endRow = req.Predicate.EndRow;
}
using (var conn = new SqlConnection(_connectionSettings.DefaultConnection))
{
const string storeproc = @"[dbo].[uspAreasGetList_NEW]";
await conn.OpenAsync();
var dynparam = new
{
Query = tempQuery
};
var rawResult = await conn.QueryAsync <ZoneAreaDTO>(storeproc, dynparam, null, null, CommandType.StoredProcedure);
resp.Total = rawResult != null && rawResult.Any() ? rawResult.Count() : 0;
if (startRow >= 0 && endRow >= 0)
{
resp.Result = rawResult.ToList().Skip(startRow).Take(endRow - startRow).ToList();
}
else
{
resp.Result = rawResult.ToList();
}
}
return(resp);
}
public async Task <IActionResult> ZoneAreaGetAllAsync(ZoneAreaGetAllRequest req)
{
var result = await _zoneAreaManager.GetAllAsync(req);
return(Ok(result));
}
