public static DataTable SelectView() { String strSQL = "SELECT * FROM TBL_SERVERS_DATA_VIW"; clsOracleDBMS objDBMS = new clsOracleDBMS(); return(objDBMS.ExecuteSelectSQL(strSQL)); }
public static DataTable SearchServer(String strServerName) { String strSQL = @"SELECT s.id AS ID, s.name AS ""Server Name"", s.ip AS IP FROM tbl_servers_data s WHERE s.name LIKE '%" + strServerName + "%' ORDER BY s.id"; clsOracleDBMS objDBMS = new clsOracleDBMS(); return(objDBMS.ExecuteSelectSQL(strSQL)); }
public static DataTable SelectServer(String strID, String strProjectName) { String strSQL = "SELECT * FROM TBL_SERVERS_DATA_VIW WHERE PROJECT = '" + strProjectName + "'"; clsOracleDBMS objDBMS = new clsOracleDBMS(); return(objDBMS.ExecuteSelectSQL(strSQL)); }
public static DataTable SelectServer(String strID) { String strSQL = "SELECT * FROM TBL_SERVERS_DATA WHERE ID = '" + strID + "'"; clsOracleDBMS objDBMS = new clsOracleDBMS(); return(objDBMS.ExecuteSelectSQL(strSQL)); }
public static DataTable SelectProjects() { String strSQL = "SELECT Distinct(PROJECT) FROM tbl_servers_data"; clsOracleDBMS objDBMS = new clsOracleDBMS(); return(objDBMS.ExecuteSelectSQL(strSQL)); }
public static void InsertLog(clsLog objLog) { try { String strSQL = "INSERT INTO tbl_Log VALUES(TBL_LOG_SEQ.NEXTVAL, '" + objLog.strIP + "', SYSDATE, '" + objLog.strAction + "', '" + objLog.strTarget_Name + "')"; clsOracleDBMS objDBMS = new clsOracleDBMS(); objDBMS.ExecuteSQL(strSQL); } catch (Exception ex) { throw new Exception(clsUtilities.GetErr(ex.Message.ToString())); } }