public int UpdateDominoServerTasks(int TaskID, int ServerID, int Enabled, int SendLoadCommand, int SendRestartCommand, int RestartOffHours, int SendExitCommand) { int Update = 0; try { if (Enabled == 0) { string SqlQuery1 = "Delete from ServerTaskSettings WHERE TaskId = " + TaskID + " AND ServerID = " + ServerID; Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery1); } else { string SqlQuery = "SELECT * FROM ServerTaskSettings where TaskId = " + TaskID + " AND ServerID = " + ServerID; if (objAdaptor.FetchData(SqlQuery).Rows.Count > 0) { string SqlQuery1 = "Update ServerTaskSettings SET Enabled = " + Enabled + ",SendLoadCommand = " + SendLoadCommand + ",SendRestartCommand = " + SendRestartCommand + ",RestartOffHours = " + RestartOffHours + ",SendExitCommand = " + SendExitCommand + " WHERE TaskId = " + TaskID + " AND ServerID = " + ServerID; Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery1); } else { string SqlQuery1 = "INSERT INTO ServerTaskSettings (TaskID,ServerID,Enabled,SendLoadCommand,SendRestartCommand,RestartOffHours,SendExitCommand) VALUES (" + TaskID + "," + ServerID + "," + Enabled + "," + SendLoadCommand + "," + SendRestartCommand + "," + RestartOffHours + "," + SendExitCommand + ")"; Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery1); } } } catch { Update = 0; } finally { } return(Update); }
public bool InsertData1(WebsphereCell STSettingsObject, int key) { int cellid; int Insert = 0; bool retInsert = false; string Cellname = STSettingsObject.CellName; //DataTable dt = new DataTable(); //string sqlqury = "select * from WebsphereCell where CellName= '" + STSettingsObject.CellName + "'"; //dt = objAdaptor.FetchData(sqlqury); try { // if (dt.Rows.Count > 0) // { //cellid = Convert.ToInt32(dt.Rows[0]["CellID"]); if (STSettingsObject.CellID != null && STSettingsObject.CellID != 0) { string SqlQuery2 = "UPDATE WebsphereCell set Name='" + STSettingsObject.Name + "',HostName='" + STSettingsObject.HostName + "',ConnectionType='" + STSettingsObject.ConnectionType + "',PortNo='" + STSettingsObject.PortNo + "',GlobalSecurity='" + STSettingsObject.GlobalSecurity + "',CredentialsID=" + STSettingsObject.CredentialsID + ",Realm='" + STSettingsObject.Realm.ToString() + "' where CellID=" + Convert.ToInt32(STSettingsObject.CellID.ToString()) + ""; //"' where CellID=" + dt.Rows[0]["cellid"] + ""; Insert = objAdaptor.ExecuteNonQueryRetRows(SqlQuery2); } // } } catch { Insert = 0; } if (Insert == 0) { try { if (STSettingsObject.CellID == 0) { string SqlQuery; SqlQuery = "INSERT INTO WebsphereCell(Name,HostName,ConnectionType,PortNo,GlobalSecurity,CredentialsID,Realm,IBMConnectionSID) VALUES('" + STSettingsObject.Name + "','" + STSettingsObject.HostName + "','" + STSettingsObject.ConnectionType + "'," + STSettingsObject.PortNo + ",'" + STSettingsObject.GlobalSecurity + "'," + STSettingsObject.CredentialsID + ",'" + STSettingsObject.Realm + "'," + key + ")"; Insert = objAdaptor.ExecuteNonQueryRetRows(SqlQuery); } } catch { Insert = 0; } } if (Insert == 1) { retInsert = true; } return(retInsert); }
public int UpdateProfileDetails(List <UserProfileDetailed> list) { int Update = 0; try { string SqlQuery = "delete UserProfileDetailed where UserProfileMasterID=" + list[0].UserProfileMasterID; Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery); for (int i = 0; i < list.Count; i++) { SqlQuery = "INSERT INTO UserProfileDetailed(UserProfileMasterID,ProfilesMasterID,Value) values(" + list[i].UserProfileMasterID + "," + list[i].ProfilesMasterID + ",'" + list[i].Value + "')"; Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery); } } catch { Update = 0; } return(Update); }
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 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); }
public bool InsertData1(WebsphereCell STSettingsObject) { int cellid; int Insert = 0; bool retInsert = false; string Cellname = STSettingsObject.CellName; try { if (STSettingsObject.CellID != null) { string SqlUpdate = ""; string SqlInsert = ""; if (STSettingsObject.CredentialsID != 0) { SqlUpdate = "UPDATE WebsphereCell set Name='" + STSettingsObject.Name + "',HostName='" + STSettingsObject.HostName + "',ConnectionType='" + STSettingsObject.ConnectionType + "',PortNo='" + STSettingsObject.PortNo + "',Credentialsid='" + STSettingsObject.CredentialsID + "',GlobalSecurity='" + STSettingsObject.GlobalSecurity + "',Realm='" + STSettingsObject.Realm + "' where CellID=" + STSettingsObject.CellID.ToString() + ""; SqlInsert = "INSERT INTO WebsphereCell(Name,HostName,ConnectionType,PortNo,GlobalSecurity,Credentialsid,Realm) VALUES('" + STSettingsObject.Name + "','" + STSettingsObject.HostName + "','" + STSettingsObject.ConnectionType + "'," + STSettingsObject.PortNo + ",'" + STSettingsObject.GlobalSecurity + "','" + STSettingsObject.CredentialsID + "','" + STSettingsObject.Realm + "')"; } else { SqlUpdate = "UPDATE WebsphereCell set Name='" + STSettingsObject.Name + "',HostName='" + STSettingsObject.HostName + "',ConnectionType='" + STSettingsObject.ConnectionType + "',PortNo='" + STSettingsObject.PortNo + "',GlobalSecurity='" + STSettingsObject.GlobalSecurity + "',Realm='" + STSettingsObject.Realm + "' where CellID=" + STSettingsObject.CellID.ToString() + ""; SqlInsert = "INSERT INTO WebsphereCell(Name,HostName,ConnectionType,PortNo,GlobalSecurity,Realm) VALUES('" + STSettingsObject.Name + "','" + STSettingsObject.HostName + "','" + STSettingsObject.ConnectionType + "'," + STSettingsObject.PortNo + ",'" + STSettingsObject.GlobalSecurity + "','" + STSettingsObject.Realm + "')"; } string sql = "IF EXISTS(SELECT * FROM WebsphereCell WHERE CellID=" + STSettingsObject.CellID.ToString() + ") BEGIN " + SqlUpdate + "; END ELSE BEGIN " + SqlInsert + "; END"; if (objAdaptor.ExecuteNonQueryRetRows(sql) > 0) { retInsert = true; } } } catch (Exception ex) { return(false); } return(retInsert); }
public int UpdateEXGServiceSettings(int Enabled, string DisplayName, string ServiceName, string ServerType, int SVRId) { int Update = 0; try { string SQLQuery = "Update WindowsServices Set Monitored = '" + Enabled + "' Where DisplayName = '" + DisplayName + "' and Service_Name = '" + ServiceName + "' and ServerTypeID = (Select ID from ServerTypes where ServerType = '" + ServerType + "') and ServerName = (Select ServerName from Servers where ID = '" + SVRId + "') "; Update = objAdaptor.ExecuteNonQueryRetRows(SQLQuery); //string SqlQuery = "SELECT * FROM ServerServices where ServerId = " + serverID + " AND SVRId = " + SVRId; //if (objAdaptor.FetchData(SqlQuery).Rows.Count > 0) //{ // string SqlQuery1 = "Delete from ServerServices WHERE ServerId = " + serverID + " AND SVRId = " + SVRId; // Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery1); //} } catch { Update = 0; } finally { } return(Update); }
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 object updatenwEnableLatencyTest(int id, int nlid, int latencyred, int yellowthershold, bool checkedvalue, string testname) { //ExchangeServers - ServerId, LatencyEnable, Red,Yellow bool UpdateRet = false; int Update = 0; try { DataTable dt = new DataTable(); ServerTypes STypebject = new ServerTypes(); ServerTypes RetnSTypebject = new ServerTypes(); // RetnSTypebject = VSWebDAL.SecurityDAL.ServerTypesDAL.Ins.GetDataForServerType(STypebject); // StObject.ServerTypeId = RetnSTypebject.ID; if (id != 0) { string SqlQuery = ""; //if (StObject.RoleType == null) //{ // StObject.RoleType = ""; //} SqlQuery = "select * from NetworkLatencyServers where ServerID='" + id + "' "; dt = objAdaptor.FetchData(SqlQuery); if (dt.Rows.Count > 0) { SqlQuery = "update NetworkLatencyServers set LatencyYellowThreshold=" + yellowthershold + ", LatencyRedThreshold=" + latencyred + ",Enabled='" + checkedvalue + "' where ServerID=" + id; Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery); } } //foreach (ExchangeSettings fieldValue in fieldValues) //{ //} } catch { Update = 0; } if (Update == 0) { try { string SqlQuery = ""; DataTable networklatency = new DataTable(); string sqlQuery; sqlQuery = "select [NetworkLatencyId] from [NetworkLatency] where [TestName]='" + testname + "'"; networklatency = objAdaptor.FetchData(sqlQuery); if (networklatency.Rows.Count > 0) { SqlQuery = "Insert into NetworkLatencyServers(ServerID,NetworkLatencyId,LatencyYellowThreshold , LatencyRedThreshold , Enabled) values" + //"ActiveSyncCredentialsId) values" + "(" + id + ", " + Convert.ToInt32(networklatency.Rows[0]["NetworkLatencyId"]) + ",'" + yellowthershold + "','" + latencyred + "','" + checkedvalue + "')"; Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery); } } catch { Update = 0; } } if (Update == 1) { UpdateRet = true; } return(UpdateRet); }
public bool UpdateProfilesunselect(bool isSelected, string strsname) { bool UpdateRet = false; int Update = 0; try { ServerTypes STypebject = new ServerTypes(); ServerTypes RetnSTypebject = new ServerTypes(); string SqlQuery = "UPDATE ProfilesMaster set isSelected='" + isSelected + "' where ID='" + strsname + "'"; Update = objAdaptor.ExecuteNonQueryRetRows(SqlQuery); } catch { } return(UpdateRet); }