public int UpdateRunMode(string runMode)
{
int mode = 0;
try
{
int count = 0;
string Query = "SELECT Count(*) FROM Settings WHERE sname = 'runmode'";
count = objAdaptor.ExecuteScalar(Query);
string SqlQuery = "";
if (count == 0)
{
SqlQuery = "INSERT INTO Settings VALUES('RunMode','" + runMode + "','System.String')";
}
else
{
SqlQuery = "UPDATE Settings SET svalue='" + runMode + "' WHERE sname = 'RunMode'";
}
mode = objAdaptor.ExecuteNonQueryRetRows(SqlQuery);
}
catch
{
}
return(mode);
}
public int GetIBMConnectionTestsId(string tests)
{
int i;
try
{
string sqlQuerry = "SELECT Id from TestsMaster WHERE Tests = '" + tests + "'";
i = objAdaptor.ExecuteScalar(sqlQuerry);
}
catch (Exception ex)
{
throw ex;
}
return(i);
}
public void UpdateUserPreferences(string PreferenceName, string PreferenceValue, int UserID)
{
if (PreferenceName == "FilterBy")
{
PreferenceValue = PreferenceValue.Replace("'", "''");
}
//2/14/2013 NS modified
int mode = 0;
try
{
int count = 0;
string Query = "SELECT Count(*) FROM UserPreferences WHERE PreferenceName = '" + PreferenceName + "' and UserID =" + UserID;
count = objAdaptor.ExecuteScalar(Query);
string SqlQuery = "";
if (count == 0)
{
SqlQuery = "INSERT INTO UserPreferences VALUES('" + PreferenceName + "','" + PreferenceValue + "'," + UserID + ")";
}
else
{
SqlQuery = "UPDATE UserPreferences SET PreferenceValue='" + PreferenceValue + "' WHERE PreferenceName = '" + PreferenceName + "' and UserID =" + UserID;
}
mode = objAdaptor.ExecuteNonQueryRetRows(SqlQuery);
//SqlQuery = "SELECT * FROM UserPreferences WHERE UserID =" + UserID;
//return objAdaptor.FetchData(SqlQuery);
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateScanvalue(string sname, string svalue, string stype)
{
//26/11/2014 Sowjanya modified
bool UpdateRet = false;
int mode = 0;
try
{
if (sname != null && sname != "")
{
int count = 0;
string Query = "SELECT Count(*) FROM ScanSettings WHERE sname = '" + sname + "' and svalue='" + svalue + "'";
count = objAdaptor.ExecuteScalar(Query);
string SqlQuery = "";
if (count == 0)
{
SqlQuery = "INSERT INTO ScanSettings(sname,svalue,stype) VALUES('" + sname + "','" + svalue + "','" + stype + "')";
mode = objAdaptor.ExecuteNonQueryRetRows(SqlQuery);
}
else
{
//SqlQuery = "UPDATE Settings SET svalue='" + svalue + "',stype ='" + stype + "' WHERE sname = '" + sname + "'";
}
if (mode == 1)
{
UpdateRet = true;
}
}
}
catch
{
}
return(UpdateRet);
}
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);
}