Rev 6775 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed
<%@LANGUAGE="VBSCRIPT"%><%'=====================================================' wAddPkgReplica.asp''=====================================================%><%Option explicitResponse.Expires = 0%><!--#include file="common/conf.asp"--><!--#include file="common/globals.asp"--><!--#include file="common/formating.asp"--><!--#include file="common/qstr.asp"--><!--#include file="common/common_subs.asp"--><!--#include file="common/_form_window_common.asp"--><%'------------ ACCESS CONTROL ------------------%><!--#include file="_access_control_login.asp"--><!--#include file="_access_control_general.asp"--><%'------------ VARIABLE DEFINITION -------------Dim rsQryDim sMessageDim Query_StringDim server_id,server_name,display_name, active, mode, descriptionDim activeChecked'------------ CONSTANTS DECLARATION -----------'------------ VARIABLE INIT -------------------sMessage = NULLSet objFormCollector = CreateObject("Scripting.Dictionary")'------------ CONDITIONS ----------------------'----------------------------------------------%><%'------------ RUN BEFORE PAGE RENDER ----------If CBool(Request("action")) ThenDim displayNameIf displayName = "" ThendisplayName = Request("server_name")End IfIf Request("server_id") <> "" ThenOraDatabase.Parameters.Add "SERVER_ID", Request("server_id"), ORAPARM_INPUT, ORATYPE_NUMBEROraDatabase.Parameters.Add "DISPLAY_NAME", displayName, ORAPARM_INPUT, ORATYPE_VARCHAR2OraDatabase.Parameters.Add "server_name", Request("server_name"), ORAPARM_INPUT, ORATYPE_VARCHAR2OraDatabase.Parameters.Add "DESCRIPTION", Request("description"), ORAPARM_INPUT, ORATYPE_VARCHAR2OraDatabase.Parameters.Add "ACTIVE", Request("active"), ORAPARM_INPUT, ORATYPE_CHAROraDatabase.Parameters.Add "MODE", Request("mode"), ORAPARM_INPUT, ORATYPE_CHARobjEH.ErrorRedirect = FALSEobjEH.TryORA ( OraSession )On Error Resume NextOraDatabase.ExecuteSQL _"BEGIN PK_BLATAPI.UPDATE_PKG_REPLICA(:server_id, :DISPLAY_NAME, :server_name, :DESCRIPTION, :ACTIVE, :MODE); END;"objEH.CatchORA ( OraSession )OraDatabase.Parameters.Remove "SERVER_ID"OraDatabase.Parameters.Remove "DISPLAY_NAME"OraDatabase.Parameters.Remove "SERVER_NAME"OraDatabase.Parameters.Remove "DESCRIPTION"OraDatabase.Parameters.Remove "ACTIVE"OraDatabase.Parameters.Remove "MODE"If objEH.Finally ThenCall OpenInParentWindow ("admin_blat_machines.asp?server_id="&Request("server_id"))Call CloseWindow()End IfrsQry.CloseSet rsQry = nothingElseOraDatabase.Parameters.Add "DISPLAY_NAME", displayName, ORAPARM_INPUT, ORATYPE_VARCHAR2OraDatabase.Parameters.Add "SERVER_NAME", Request("server_name"), ORAPARM_INPUT, ORATYPE_VARCHAR2OraDatabase.Parameters.Add "DESCRIPTION", Request("description"), ORAPARM_INPUT, ORATYPE_VARCHAR2OraDatabase.Parameters.Add "ACTIVE", Request("active"), ORAPARM_INPUT, ORATYPE_CHAROraDatabase.Parameters.Add "MODE", Request("mode"), ORAPARM_INPUT, ORATYPE_CHARobjEH.ErrorRedirect = FALSEobjEH.TryORA ( OraSession )On Error Resume NextOraDatabase.ExecuteSQL "BEGIN PK_BLATAPI.ADD_PKG_REPLICA(:DISPLAY_NAME, :SERVER_NAME, :DESCRIPTION, :ACTIVE, :MODE); END;"objEH.CatchORA ( OraSession )OraDatabase.Parameters.Remove "DISPLAY_NAME"OraDatabase.Parameters.Remove "SERVER_NAME"OraDatabase.Parameters.Remove "DESCRIPTION"OraDatabase.Parameters.Remove "ACTIVE"OraDatabase.Parameters.Remove "MODE"If objEH.Finally ThenCall OpenInParentWindow ("admin_blat_machines.asp?server_id="&Request("server_id"))Call CloseWindow()End IfrsQry.CloseSet rsQry = nothingEnd IfEnd If'----------------------------------------------' Generate HTML to show/display the Replicate mode Compo BoxSub GenReplicateModeCombo(cMode)Response.Write "<select class = 'form_item' name=mode>"Response.Write "<option value = 'N' " & IIF(cmode = "N", "selected", "" ) &" >Normal</option>"Response.Write "<option value = 'P' " & IIF(cmode = "P", "selected", "" ) &" >All Projects</option>"Response.Write "<option value = 'E' " & IIF(cmode = "E", "selected", "" ) &" >Entire Archive</option>"Response.Write "</select>"End Sub'----------------------------------------------%><html><head><title>Release Manager</title><link rel="shortcut icon" href="<%=FavIcon%>"/><meta HTTP-EQUIV="Pragma" CONTENT="no-cache"><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><link href="images/release_manager_style.css?ver=<%=VixVerNum%>" rel="stylesheet" type="text/css"><script language="JavaScript" src="scripts/common.js?ver=<%=VixVerNum%>"></script></head><body leftmargin="0" topmargin="0" onLoad="self.focus();FormName.display_name.focus();"><table width="100%" border="0" cellspacing="0" cellpadding="10"><tr><td class="body_txt">Add a new Package Replication servers or edit an existing an existing one.<p>Note: This target replication server and local replication configuration need to be performed outside of this application.This configuration simply provides the Projects and Releases to be replicated.</td></tr><%'-- FROM START --------------------------------------------------------------------------------------------------------------objFormComponent.FormName = "FormName"objFormComponent.FormClass = "form_tight"objFormComponent.Action = ScriptNameobjFormComponent.OnSubmit = "ShowProgress();"Call objFormComponent.FormStart()%><tr><td class="form_field_bg" ><!-- NEW PRODUCT ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ --><%Call Messenger ( sMessage , 3, "100%" )%><!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ --><!--#include file="messages/_msg_inline.asp"--><br><%If Request("server_id") <> "" Then%><input type="hidden" name="server_id" value="<%=Request("server_id")%>"><%Dim rsTempQuery_String = "select blat_id, blat_server_name, blat_display_name,blat_enable,blat_mode, blat_description from BLAT_SERVERS where blat_id = " & Request("server_id")Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0))server_name = rsTemp("blat_server_name")display_name = rsTemp("blat_display_name")active = rsTemp("blat_enable")mode = rsTemp("blat_mode")description = rsTemp("blat_description")activeChecked = ""if active = "Y" Then activeChecked = "checked"rsTemp.Close()Set rsTemp = NothingElseactiveChecked = "checked"mode = "N"End If%><table width="50%" border="0"><tr><td><span class="body_txt">Server Name</span></td><td><input name="server_name" type="text" class="body_txt" value="<%=server_name%>" size=60 maxlength=100></td></tr><tr><td><span class="body_txt nowrap">Display Name</span></td><td><input name="display_name" type="text" class="body_txt" value="<%=display_name%>" size=20 maxlength=20></td></tr><tr><td><span class="body_txt nowrap">Enabled</span></td><td><input type="checkbox" name="active" value="Y" <%=activeChecked%>><span class="body_txt">Enable replication to this machine</span></td></tr><tr><td><span class="body_txt nowrap">Replication Mode</span></td><td><%Call GenReplicateModeCombo(mode) %></td></tr><tr><td><span class="body_txt nowrap">Description</span></td><td><textarea name="Description" cols=50 rows=5 class='body_txt'><%=Description%></textarea></td></tr></table></td></tr><tr><td><table class="full_table"><tr><td><%=ProgressBar()%></td><td align="right"><input name="btn" type="submit" class="form_btn" value="Add/Update"><input name="btn" type="reset" class="form_btn" value="Cancel" onclick="parent.closeIFrame();"></td></tr></table></td></tr><%=objPMod.ComposeHiddenTags()%><input type="hidden" name="action" value="true"><%Call objFormComponent.FormEnd()'-- FROM END ----------------------------------------------------------------------------------------------------------------%></table></body></html><%'------------ RUN AFTER PAGE RENDER -----------Set objFormCollector = Nothing'----------------------------------------------Call Destroy_All_Objects%>