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()));
}
}
