<%@LANGUAGE="VBSCRIPT"%> <% '===================================================== '| | '| ADMIN Page | '| | '===================================================== %> <% Option explicit ' Good idea to set when using redirect Response.Expires = 0 ' always load the page, dont store %> <% '------------ ACCESS CONTROL ------------------ %> <% '------------ Variable Definition ------------- Dim objBtnControl '------------ Constants Declaration ----------- '------------ Variable Init ------------------- Set objBtnControl = New ActionButtonControl '---------------------------------------------- %> <% ' Page Access Condition If NOT objAccessControl.IsActive("ConfigureBuildService") Then Response.Redirect("message.asp?msg=401-9") End If %> <% Sub UpdateBuildInfo() On Error Resume Next OraDatabase.Parameters.Add "DATABASE_SERVER", Request("database server"), ORAPARM_INPUT, ORATYPE_VARCHAR2 OraDatabase.Parameters.Add "WEB_SERVER", Request("web server"), ORAPARM_INPUT, ORATYPE_VARCHAR2 OraDatabase.Parameters.Add "MAIL_SERVER", Request("mail server"), ORAPARM_INPUT, ORATYPE_VARCHAR2 OraDatabase.Parameters.Add "BUILD_FAILURE_MAIL_SENDER", Request("build failure mail sender"), ORAPARM_INPUT, ORATYPE_VARCHAR2 objEH.TryORA ( OraSession ) OraDatabase.ExecuteSQL _ "BEGIN PK_BUILDAPI.Update_Build_Service ( :DATABASE_SERVER, :WEB_SERVER, :MAIL_SERVER, :BUILD_FAILURE_MAIL_SENDER ); END;" objEH.CatchORA ( OraSession ) OraDatabase.Parameters.Remove "DATABASE_SERVER" OraDatabase.Parameters.Remove "WEB_SERVER" OraDatabase.Parameters.Remove "MAIL_SERVER" OraDatabase.Parameters.Remove "BUILD_FAILURE_MAIL_SENDER" End Sub %> <% If Request("action") = "true" Then Call UpdateBuildInfo() If objEH.Finally Then Response.Redirect("admin.asp") End If End If %> Buid Service Administration <% '-- FROM START --------------------------------------------------------------------------------------------------------- objFormComponent.FormName = "UpdateBuildServiceConfig" objFormComponent.Action = ScriptName objFormComponent.OnSubmit = "ShowProgress();" Call objFormComponent.FormStart() %>
<%=ProgressBar%>  
<%If NOT objEH.Finally Then%> <%End If%> <% Dim rsQry, query query = "SELECT * FROM BUILD_SERVICE_CONFIG" Set rsQry = OraDatabase.DbCreateDynaset( query, ORADYN_DEFAULT ) While ((NOT rsQry.BOF) AND (NOT rsQry.EOF)) %> <% rsQry.MoveNext() Wend rsQry.Close() Set rsQry = Nothing %>
  <%objEH.DisplayMessage()%>
BUILD SERVICE CONFIGURATION
<%=rsQry("service")%> <%=objFormComponent.TextBox (rsQry("service"), rsQry("config"), "size='30' class='form_ivalue'" )%>
   
<%=objPMod.ComposeHiddenTags()%> <% Call objFormComponent.FormEnd() '-- FROM END ---------------------------------------------------------------------------------------------------------------- %> <% '-- FROM START --------------------------------------------------------------------------------------------------------- objFormComponent.FormName = "GBE_MACHTYPE" objFormComponent.Action = ScriptName objFormComponent.OnSubmit = "ShowProgress();" Call objFormComponent.FormStart() %>
Current List of GBE_MACHTYPE
<% ' Load some action buttons Call objBtnControl.LoadActionButtons ( Array("btnEditGBE_Machtype", "btnDeleteGBE_Machtype"), OraDatabase ) objBtnControl.ButtonSpacer = 1 Dim gbe_id, gbe_value Set rsQry = OraDatabase.DbCreateDynaset( "SELECT * FROM GBE_MACHTYPE ORDER BY GBE_ID", ORADYN_DEFAULT ) While (NOT rsQry.BOF) AND (NOT rsQry.EOF) gbe_id = rsQry("gbe_id") gbe_value = rsQry("gbe_value") %> <% rsQry.MoveNext() %> <% Wend rsQry.Close() Set rsQry = nothing %>
GBE_MACHTYPE VALUE
<%=gbe_value%> <%Call objBtnControl.Render ( Array("btnEditGBE_Machtype", "btnDeleteGBE_Machtype"), objAccessControl )%>
  <%Call Action_Buttons ( "Add GBE_MACHTYPE" )%>  
<%=objPMod.ComposeHiddenTags()%> <% Call objFormComponent.FormEnd() '-- FROM END ---------------------------------------------------------------------------------------------------------------- %> <% Call Destroy_All_Objects %>