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