private void searchBanks(string q)
{
DataTable data = getService.searchDataFrom(app.objects["banks"], q);
if (data.Rows.Count > 0)
{
bankdataGridView.DataSource = data;
}
}
private void searchLocation(string q)
{
DataTable data = getService.searchDataFrom(app.objects["locations"], q);
if (data.Rows.Count > 0)
{
locationGridView.DataSource = data;
}
}
private void searchUser(string q)
{
DataTable data = getService.searchDataFrom(app.objects["users"], q);
if (data.Rows.Count > 0)
{
data.Columns.Remove("password");
}
data.Columns.Remove("picture");
usersGridView.DataSource = data;
}
public void buildSalesDropdown(Form currentForm, Object sender, Panel panel, string source)
{
TextBox textBox = (sender as TextBox);
SSGetService getService = new SSGetService();
currentTextBox = textBox;
if (!listedItems.Contains(textBox.Text) && textBox.Text.Length > 1)
{
customDropdown.HideSelection = false;
customDropdown.Margin = new Padding(5);
customDropdown.Size = new Size(panel.Width, 97);
customDropdown.Sorting = SortOrder.Ascending;
customDropdown.TabIndex = 58;
customDropdown.TileSize = new Size(panel.Width, 25);
customDropdown.UseCompatibleStateImageBehavior = false;
customDropdown.View = View.Tile;
customDropdown.Location = new Point(panel.Location.X + 18, panel.Location.Y + (panel.Height * 3) - 11);
customDropdown.ItemSelectionChanged += new ListViewItemSelectionChangedEventHandler(onSelectedIndexChanged);
customDropdown.MouseLeave += new EventHandler(onMouseLeave);
customDropdown.Hide();
if (textBox.Text != "" && textBox.Text != null)
{
try
{
DataTable data = getService.searchDataFrom(this.objects[source], textBox.Text);
if (data.Rows.Count > 0)
{
customDropdown.Clear();
currentForm.Controls.Add(customDropdown);
customDropdown.BringToFront();
customDropdown.Show();
foreach (DataRow row in data.Rows)
{
string name = row.Field <string>("name");
listedItems.Add(name);
customDropdown.Items.Add(name);
}
}
else
{
customDropdown.Hide();
currentForm.Controls.Remove(customDropdown);
}
}
catch (Exception ex)
{
this.showError(ex.Message);
}
}
else
{
customDropdown.Hide();
currentForm.Controls.Remove(customDropdown);
}
}
else
{
customDropdown.Hide();
currentForm.Controls.Remove(customDropdown);
}
}
