public JsonResult GetTableDataById(string id, string idFieldName, string textFieldName, string tableName, string extraFields)
{
//List<IdTextInfo> aList = new List<IdTextInfo>();
DataTable aList = new DataTable();
AutoCompleteRepo aRepo = new AutoCompleteRepo();
int totalCount = 0;
string data = "";
try
{
aList = aRepo.GetTableDataById(id, idFieldName, textFieldName, tableName, extraFields);
totalCount = aList.Rows.Count;
data = JsonConvert.SerializeObject(aList);
}
catch (Exception ex)
{
}
return(Json(new
{
data
}, JsonRequestBehavior.AllowGet));
}
public JavaScriptResult GetScriptByPageName(string pageName)
{
string javascript = "";
AutoCompleteRepo aRepo = new AutoCompleteRepo();
List <AutocompleteInfo> aList = new List <AutocompleteInfo>();
try
{
aList = aRepo.GetAutocompletesByPageName(pageName);
javascript += "$(function(){ ";
foreach (var item in aList)
{
javascript += "SetAutocomplete('" + item.ControlName + "','" + item.IdFieldName + "','" + item.TextFieldName + "','" + item.TableName + "','" + item.DependentControlName + "','" + item.DependentFieldName + "','" + item.ExtraFields + "');";
javascript += "GetAutocomplete('" + item.ControlName + "','" + item.IdFieldName + "','" + item.TextFieldName + "','" + item.TableName + "','" + item.ExtraFields + "');";
if (!string.IsNullOrEmpty(item.DependentControlName) && item.IsMultiselect != true)
{
foreach (var itm in item.DependentControlName.Split(','))
{
javascript += "$(\"[name='" + itm + "']\").change(function(){";
javascript += "$(\"[name='" + item.ControlName + "']\").html('');";
javascript += "});";
}
}
}
javascript += "});";
}
catch (Exception ex)
{
}
return(JavaScript(javascript));
}
public AutoCompleteManager()
{
_autoCompleteRepo = new AutoCompleteRepo();
}
