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;
}
}
}
