private HtmlSelect CreateSelect(Configuration.SearchInputFieldRow searchInputFieldRow)
{
HtmlSelect select = new HtmlSelect();
using (OleDbCommand command = searchInputFieldRow.GetDatabaseCommand())
{
if (command.Parameters.Count > 0)
{
command.Parameters[0].Value = AppUser.GetRole();
}
using (OleDbDataAdapter adapter = new OleDbDataAdapter(command))
{
DataTable list = new DataTable();
adapter.Fill(list);
select.DataSource = list;
select.DataValueField = list.Columns[0].ColumnName;
select.DataBind();
}
command.Connection.Dispose();
}
select.Items.Insert(0, new ListItem("", ""));
return(select);
}
private void Autocomplete()
{
string id = Request.QueryString["criteria"];
string text = Request.QueryString["query"];
Configuration config = AppContext.GetConfiguration();
Configuration.SearchInputFieldRow searchInputFieldRow = config.SearchInputField.First(o => o.FieldID == id);
using (OleDbCommand command = searchInputFieldRow.GetDatabaseCommand())
{
command.Parameters[0].Value = text;
if (command.Parameters.Count > 1)
{
command.Parameters[1].Value = AppUser.GetRole();
}
List <string> values = new List <string>();
using (OleDbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
values.Add(reader.GetString(0));
}
}
command.Connection.Dispose();
Dictionary <String, Object> result = new Dictionary <String, Object>();
result.Add("suggestions", values);
ReturnJson(result);
}
}
