public static string CreateQuery(this SearchParameter search, string column, string source)
{
string result = string.Empty;
try
{
string condition = search.ConditionList.CreateCondition();
string ordering = search.CreateOrdering();
string offset = search.CreateOffSet();
result = string.Format("SELECT COUNT(*) AS TotalRecord {0} {1}; {2} {3} {4} {5} {6}", source, condition, column, source, condition, ordering, offset);
}
catch (Exception ex)
{
throw ex;
}
return(result);
}