private void b_search_Click(object sender, EventArgs e) { if(string.IsNullOrEmpty(tB_keyword.Text)) { PopulateForm(); return; } using(MySqlDataReader reader = MainForm.MySql.Query( Resources.SqlStrings.SearchProductsWithLicenses, new MySqlDataParameter("keyword","%" + tB_keyword.Text + "%"))) { lV_produtcs.Items.Clear(); if (reader.HasRows) { while (reader.Read()) { ListViewItem item = new ListViewItem(reader["productname"].ToString()); item.SubItems.Add(reader["productid"].ToString()); item.SubItems.Add(reader["file"].ToString()); Product product = new Product(reader["productname"].ToString(), "", reader["file"].ToString(), reader["productid"].ToString()); item.Tag = product; item.ImageKey = "product"; lV_produtcs.Items.Add(item); } } } }
public License(string key, bool multi, bool distributed, string insertdate,User user, Product product) { _user = user; _distributed = distributed; _multi = multi; _product = product; _key = key; _instertdate = insertdate; }
private void SearchLicenseByUser() { lV_searchResult.Items.Clear(); using (MySqlDataReader reader = MySql.Query(Resources.SqlStrings.SearchLicenseByUser, new MySqlDataParameter("keyword", "%" + tSICB_search.Text + "%"))) { if (reader.HasRows) { while (reader.Read()) { Product product = new Product( reader["productname"].ToString(), "", reader["file"].ToString(), reader["productid"].ToString()); BlueFlame.Classes.DatabaseObjects.License license = new BlueFlame.Classes.DatabaseObjects.License(reader["licensekey"].ToString(), (bool)reader["multi"], (bool)reader["distributed"], reader["insertdate"].ToString(), null, product); ListViewItem item = new ListViewItem(product.Name); item.SubItems.Add(product.ProductId); item.SubItems.Add(product.FileId); item.SubItems.Add(reader["lang"].ToString()); item.SubItems.Add(license.Key); item.SubItems.Add(reader["insertdate"].ToString()); item.ImageKey = "productlicense"; item.Tag = license; lV_searchResult.Items.Add(item); } } tSSL_count.Text = lV_searchResult.Items.Count + " Items found"; } }
private void PopulateForm() { using (MySqlDataReader reader = MainForm.MySql.Query( Resources.SqlStrings.GetFilteredProducts)) { lV_produtcs.Items.Clear(); if (reader.HasRows) { while (reader.Read()) { ListViewItem item = new ListViewItem(reader["productname"].ToString()); item.SubItems.Add(reader["productid"].ToString()); item.SubItems.Add(reader["file"].ToString()); Product product = new Product(reader["productname"].ToString(), "", reader["file"].ToString(), reader["productid"].ToString()); item.Tag = product; item.ImageKey = "product"; lV_produtcs.Items.Add(item); } } } }
private void SelectProduct() { if (lV_produtcs.SelectedItems.Count > 0) { if (lV_produtcs.SelectedItems[0].Tag is Product) { _product = (lV_produtcs.SelectedItems[0].Tag as Product); this.DialogResult = DialogResult.OK; } } }