private void GetLicenseKeys(Product product)
{
lV_licenses.Items.Clear();
using (MySqlDataReader reader = MainForm.MySql.Query(
Resources.SqlStrings.GetLicensesByProduct,
new MySqlDataParameter("file", product.FileId),
new MySqlDataParameter("productid", product.ProductId)))
{
if (reader.HasRows)
{
while (reader.Read())
{
User user = null;
ListViewItem item = new ListViewItem(reader["licensekey"].ToString());
item.SubItems.Add(reader["multi"].ToString());
item.SubItems.Add(reader["distributed"].ToString());
item.SubItems.Add(reader["time"].ToString());
if (reader["user"] != null &&
reader["domain"] != null)
{
if (!string.IsNullOrEmpty(reader["user"].ToString()) &&
!string.IsNullOrEmpty(reader["domain"].ToString()))
{
user = new User(reader["user"].ToString(), reader["domain"].ToString(), "");
}
}
BlueFlame.Classes.DatabaseObjects.License license =
new BlueFlame.Classes.DatabaseObjects.License(reader["licensekey"].ToString(),
(bool)reader["multi"],
(bool)reader["distributed"],
reader["time"].ToString(), user, _product);
item.Tag = license;
if (user == null)
{
item.ImageKey = "productlicense";
}
else
{
item.ImageKey = "userlicense";
}
lV_licenses.Items.Add(item);
}
tSSL_count.Text = lV_licenses.Items.Count + " Licenses found";
}
}
}
private void tSB_editLicense_Click(object sender, EventArgs e)
{
if (lV_licenses.SelectedItems.Count > 0)
{
BlueFlame.Classes.DatabaseObjects.License license
= (BlueFlame.Classes.DatabaseObjects.License)lV_licenses.SelectedItems[0].Tag;
EditLicenseKey editKey = new EditLicenseKey(license.Key, license.Distributed, license.Multi);
if (editKey.ShowDialog() == DialogResult.OK)
{
license.Multi = editKey.IsMulti;
license.Distributed = editKey.IsDistributed;
license.Save();
}
}
GetLicenseKeys(_product);
}
private void tSB_add_Click(object sender, EventArgs e)
{
EditLicenseKey newKey = new EditLicenseKey();
if (newKey.ShowDialog() == DialogResult.OK)
{
BlueFlame.Classes.DatabaseObjects.License license =
new BlueFlame.Classes.DatabaseObjects.License(
newKey.LicenseKey,
newKey.IsMulti,
newKey.IsDistributed,
"",
null,
_product);
license.Create();
_licenseProvider = null;
}
GetLicenseKeys(_product);
}
private void ResetLicense()
{
if (tC_main.SelectedTab == tC_main.TabPages["tP_licenseProduct"])
{
lV_searchResult = lV_licenseDetailProduct;
if (lV_searchResult.SelectedItems[0].Tag is BlueFlame.Classes.DatabaseObjects.License)
{
BlueFlame.Classes.DatabaseObjects.License license = lV_searchResult.SelectedItems[0].Tag as BlueFlame.Classes.DatabaseObjects.License;
MainForm.MySql.Statement(
Resources.SqlStrings.RemoveUserLicense,
new MySqlDataParameter("user", license.User.UserId),
new MySqlDataParameter("file", license.Product.FileId),
new MySqlDataParameter("productid", license.Product.ProductId));
license.Distributed = false;
license.Save();
}
}
else
{
lV_searchResult = lV_licenseDetailUser;
if (lV_licenseUser.SelectedItems.Count > 0)
{
User user = lV_licenseUser.SelectedItems[0].Tag as User;
if (lV_searchResult.SelectedItems[0].Tag is BlueFlame.Classes.DatabaseObjects.License)
{
BlueFlame.Classes.DatabaseObjects.License license = lV_searchResult.SelectedItems[0].Tag as BlueFlame.Classes.DatabaseObjects.License;
MainForm.MySql.Statement(
Resources.SqlStrings.RemoveUserLicense,
new MySqlDataParameter("user", user.UserId),
new MySqlDataParameter("file", license.Product.FileId),
new MySqlDataParameter("productid", license.Product.ProductId));
license.Distributed = false;
license.Save();
}
}
}
PopulateForm();
}
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 tSB_import_Click(object sender, EventArgs e)
{
ImportLicense import = new ImportLicense();
if (import.ShowDialog() == DialogResult.OK)
{
bool multi = import.IsMulti;
foreach (string str in import.Keys)
{
BlueFlame.Classes.DatabaseObjects.License license =
new BlueFlame.Classes.DatabaseObjects.License(
str,
multi,
false,
"",
null,
_product);
license.Create();
_licenseProvider = null;
}
GetLicenseKeys(_product);
}
}
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";
}
}