public int APIGetTotalRecord(ForApiResponse apr, SpinnerRequest req, DbContext dbContext = null)
{
string sql = "";
if (req.Where == "" || req.Where == null)
{
sql = $@"SELECT COUNT({req.ValueText}) as Total FROM {req.ModelName} ";
}
else
{
sql = $@"SELECT COUNT({req.ValueText}) as Total FROM {req.ModelName} WHERE {req.Where} ";
}
return(db.Get <TotalRecord>(sql, dbContext).FirstOrDefault().Total);
}
public List <SpinnerValue> APIGetSpinnerData(ForApiResponse apr, SpinnerRequest req, DbContext dbContext = null)
{
string sql = "";
if (req.Where == "" || req.Where == null)
{
sql = $@"SELECT ROW_NUMBER() over ( order by {req.ValueText}) as RowNo,{req.DisplayText} as 'DisplayText', CAST({req.ValueText} as nvarchar) as 'ValueText' FROM {req.ModelName} Order by RowNo asc OFFSET ({apr.PageSize}*({apr.PageNo}-1)) ROWS FETCH NEXT {apr.PageSize} ROWS ONLY";
}
else
{
sql = $@"SELECT ROW_NUMBER() over ( order by {req.ValueText}) as RowNo,{req.DisplayText} as 'DisplayText', CAST({req.ValueText} as nvarchar) as 'ValueText' FROM {req.ModelName} WHERE {req.Where} Order by RowNo asc OFFSET ({apr.PageSize}*({apr.PageNo}-1)) ROWS FETCH NEXT {apr.PageSize} ROWS ONLY";
}
var list = db.Get <SpinnerValue>(sql, dbContext).ToList();
return(list);
}
