//
// GET: /AutoComplete/
public JsonResult GetTableData(string q, int page, int pageLimit, string idFieldName, string textFieldName, string tableName, string dependentFieldName, string dependentFieldValue, string extraFields)
{
//List<IdTextInfo> aList = new List<IdTextInfo>();
DataTable aList = new DataTable();
AutoCompleteRepo aRepo = new AutoCompleteRepo();
int totalCount = 0;
string data = "";
try
{
aList = aRepo.GetTableData(q, page, idFieldName, textFieldName, tableName, dependentFieldName, dependentFieldValue, extraFields);
totalCount = aList.Rows.Count;
data = JsonConvert.SerializeObject(aList);
}
catch (Exception ex)
{
}
return(Json(new
{
data,
totalCount,
page
}, JsonRequestBehavior.AllowGet));
}
public DataTable GetTableData(string q, int page, string idFieldName, string textFieldName, string tableName, string dependentFieldName, string dependentFieldValue, string extraFields)
{
return(_autoCompleteRepo.GetTableData(q, page, idFieldName, textFieldName, tableName, dependentFieldName, dependentFieldValue, extraFields));
}