public bool InsertLicense(License keyvalue)
{
DataTable licensekey = new DataTable();
bool UpdateRet = false;
int mode = 0;
try
{
int count = 0;
/* 4/27/2015 NS modified for VSPLUS-1700 */
/*
* string Query = "SELECT Count(*) FROM License WHERE LicenseKey = '" + keyvalue.LicenseKey + "'";
* count = objAdaptor.ExecuteScalar(Query);
* string SqlQuery = "";
* if (count == 0)
* {
* SqlQuery = "INSERT INTO License([LicenseKey],[Units],[InstallType],[CompanyName],[LicenseType],[ExpirationDate]) VALUES('" + keyvalue.LicenseKey + "'," +
* " " + keyvalue.Units + ",'" + keyvalue.InstallType + "','" + keyvalue.CompanyName + "','" + keyvalue.LicenseType + "','" + keyvalue.ExpirationDate + "')";
* }
* else
* {
* SqlQuery = "UPDATE License SET LicenseKey='" + keyvalue.LicenseKey + "',Units=" + keyvalue.Units + ",InstallType='" + keyvalue.InstallType + "',CompanyName='" + keyvalue.CompanyName + "'," +
* "LicenseType='" + keyvalue.LicenseType + "',ExpirationDate='" + keyvalue.ExpirationDate + "'";
* }
*/
string Query = "SELECT Count(*) FROM License";
count = objAdaptor.ExecuteScalar(Query);
string SqlQuery = "";
if (count != 0)
{
SqlQuery = "DELETE FROM License";
objAdaptor.ExecuteNonQuery(SqlQuery);
}
SqlQuery = "INSERT INTO License([LicenseKey],[Units],[InstallType],[CompanyName],[LicenseType],[ExpirationDate]) VALUES('" + keyvalue.LicenseKey + "'," +
" " + keyvalue.Units + ",'" + keyvalue.InstallType + "','" + keyvalue.CompanyName + "','" + keyvalue.LicenseType + "','" + keyvalue.ExpirationDate + "')";
mode = objAdaptor.ExecuteNonQueryRetRows(SqlQuery);
if (mode == 1)
{
licensekey = objAdaptor.FetchLicense("PR_EncDecLicense", false);
UpdateRet = true;
}
}
catch
{
}
return(UpdateRet);
}
