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 SearchLicenseByProduct()
{
lV_searchResult.Items.Clear();
using (MySqlDataReader reader = MySql.Query(Resources.SqlStrings.SearchLicenseByProduct,
new MySqlDataParameter("keyword", "%" + tSICB_search.Text + "%")))
{
if (reader.HasRows)
{
while (reader.Read())
{
User user = null;
if (!string.IsNullOrEmpty(reader["user"].ToString()))
{
user = new User(reader["user"].ToString(),
reader["domain"].ToString(), "");
}
ListViewItem item = new ListViewItem(reader["user"].ToString());
item.SubItems.Add(reader["user"].ToString());
item.SubItems.Add(reader["licensekey"].ToString());
item.SubItems.Add(reader["insertdate"].ToString());
item.SubItems.Add(reader["multi"].ToString());
item.SubItems.Add(reader["distributed"].ToString());
if (user != null) item.ImageKey = "userlicense";
else item.ImageKey = "productlicense";
item.Tag = new BlueFlame.Classes.DatabaseObjects.License(reader["licensekey"].ToString(),
(int.Parse(reader["multi"].ToString()) == 1),
(int.Parse(reader["distributed"].ToString()) == 1),
reader["insertdate"].ToString(),
user,
null);
lV_searchResult.Items.Add(item);
}
}
tSSL_count.Text = lV_searchResult.Items.Count + " Items found";
}
}
private void lV_licenseProduct_SelectedIndexChanged(object sender, EventArgs e)
{
if (lV_licenseProduct.SelectedItems.Count > 0)
{
if (lV_licenseProduct.SelectedItems[0].Tag is Disc)
{
Cursor = Cursors.WaitCursor;
lV_licenseDetailProduct.Items.Clear();
Disc product = (lV_licenseProduct.SelectedItems[0].Tag as Disc);
using (MySqlDataReader reader = MySql.Query(
Resources.SqlStrings.GetLicensesByProduct,
new MySqlDataParameter("file", product.FileId),
new MySqlDataParameter("productid", product.ProductId)))
{
if (reader.HasRows)
{
int used = 0;
while (reader.Read())
{
// name id file lang key date
User user = null;
if(!string.IsNullOrEmpty(reader["user"].ToString()))
{
user = new User(reader["user"].ToString(),
reader["domain"].ToString(),"");
}
bool multi = (bool)reader["multi"];
bool distributed = (bool)reader["distributed"];
ListViewItem item = new ListViewItem(reader["user"].ToString());
item.SubItems.Add(reader["domain"].ToString());
item.SubItems.Add(reader["licensekey"].ToString().ToUpper());
item.SubItems.Add(reader["time"].ToString());
item.SubItems.Add(reader["multi"].ToString());
item.SubItems.Add(reader["distributed"].ToString());
item.Tag = new BlueFlame.Classes.DatabaseObjects.License(reader["licensekey"].ToString(),
multi,
distributed,
reader["time"].ToString(),
user,
new Product("","",product.FileId, product.ProductId));
if (user != null)
{
item.ImageKey = "userlicense";
used++;
}
else
{
item.ImageKey = "productlicense";
}
lV_licenseDetailProduct.Items.Add(item);
}
int all = lV_licenseDetailProduct.Items.Count;
tSSL_count2.Text = all + " Licenses, " + used + " Used, " + (all - used) + " Unused";
}
}
Cursor = Cursors.Default;
}
}
}