Subversion Repositories DevTools

<%@LANGUAGE="VBSCRIPT"%>

<%

'=====================================================

'|                                                   |

'|                      Add Release                  |

'|                                                   |

'=====================================================

%>

<%

Option explicit

' Good idea to set when using redirect

Response.Expires = 0    ' always load the page, dont store

%>

<!--#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"-->

<%

' Set rfile parameter. This is a return page after Login

Call objPMod.StoreParameter ( "rfile", "rtree.asp" )

objPMod.PersistInQryString("proj_id")

'------------ ACCESS CONTROL ------------------

%>

<!--#include file="_access_control_login.asp"-->

<!--#include file="_access_control_general.asp"-->

<!--#include file="_access_control_project.asp"-->

<%

'------------ Variable Definition -------------

Dim objSortHelper

Dim rsQry

Dim parProjId

Dim parSourceRtagId

'------------ Constants Declaration -----------

'------------ Variable Init -------------------

parProjId = Request("proj_id")

parSourceRtagId = Request("source_rtag_id")

objPMod.PersistInQryString("proj_id")

'----------------------------------------------

%>

<%

'--------------------------------------------------------------------------------------------------------------------------

Sub GetFormDetails ( nSourceRtagId, ByRef outobjDetails )

    Dim rsQry, query

    ' Exit if nSourceRtagId is empty

    If nSourceRtagId = "" Then Exit Sub 

    OraDatabase.Parameters.Add "SOURCE_RTAG_ID",    nSourceRtagId,      ORAPARM_INPUT, ORATYPE_NUMBER 

    query = _

    " SELECT pr.PROJ_NAME ||' > '|| rt.RTAG_NAME ||' ['|| rt.RTAG_VERSION ||'.'|| rt.RTAG_LIFE_CYCLE ||']'  AS LOCATION"&_

    "  FROM RELEASE_TAGS rt,"&_

    "      PROJECTS pr"&_

    " WHERE rt.PROJ_ID = pr.PROJ_ID"&_

    "   AND rt.RTAG_ID = :SOURCE_RTAG_ID"

    Set rsQry = OraDatabase.DbCreateDynaset( query, ORADYN_DEFAULT )

    OraDatabase.Parameters.Remove "SOURCE_RTAG_ID"

    If rsQry.RecordCount > 0 Then

        outobjDetails.Item ("location") = rsQry("location")

    Else

        Err.Raise 8, "Sub GetFormDetails in "& ScriptName, "Empty record set returned. nSourceRtagId="& nSourceRtagId

    End If

    rsQry.Close

    Set rsQry = Nothing

End Sub

'--------------------------------------------------------------------------------------------------------------------------

Sub AddRelease ()

    On Error Resume Next

    OraDatabase.Parameters.Add "SOURCE_RTAG_ID",    Request("source_rtag_id"),  ORAPARM_INPUT, ORATYPE_NUMBER 

    OraDatabase.Parameters.Add "PROJ_ID",           Request("proj_id"),     ORAPARM_INPUT, ORATYPE_NUMBER 

    OraDatabase.Parameters.Add "RTAG_NAME",         Request("rtag_name"),       ORAPARM_INPUT, ORATYPE_VARCHAR2

    OraDatabase.Parameters.Add "RTAG_DESCRIPTION",  Request("rtag_description"), ORAPARM_INPUT, ORATYPE_VARCHAR2

    OraDatabase.Parameters.Add "USER_ID",           objAccessControl.UserId,    ORAPARM_INPUT, ORATYPE_NUMBER 

    OraDatabase.Parameters.Add "IS_BRANCH",         Request("branch"),  ORAPARM_INPUT, ORATYPE_CHAR

    OraDatabase.Parameters.Add "OMODE",             Request("mode"),    ORAPARM_INPUT, ORATYPE_CHAR

    objEH.TryORA ( OraSession )

    OraDatabase.ExecuteSQL "BEGIN PK_RELEASE.NEW_RELEASE ( :RTAG_NAME, :RTAG_DESCRIPTION, :PROJ_ID, :SOURCE_RTAG_ID, :IS_BRANCH, :USER_ID, :OMODE );   END;"

    objEH.CatchORA ( OraSession )

    OraDatabase.Parameters.Add "SOURCE_RTAG_ID"

    OraDatabase.Parameters.Add "PROJ_ID"

    OraDatabase.Parameters.Add "RTAG_NAME"

    OraDatabase.Parameters.Add "RTAG_DESCRIPTION"

    OraDatabase.Parameters.Add "USER_ID"

    OraDatabase.Parameters.Add "IS_BRANCH"

    OraDatabase.Parameters.Add "OMODE"

End Sub

'--------------------------------------------------------------------------------------------------------------------------

%>

<%

'------------ RUN BEFORE PAGE RENDER ----------

' --- Get Form details from DB ---

Call GetFormDetails ( parSourceRtagId, objFormCollector )

' --- Load Validation Rules ---

Call objForm.LoadValidationRules ( Array("rtag_name","rtag_description"), OraDatabase )     ' Load Validation Rules

' --- Enter Form Validation Rule Changes here... ----

'----------------------------------------------------

' --- RUN onPostBack ---

If Request("action") <> "" Then

    If objForm.IsValidOnPostBack Then

        ' --- Form is Valid ---

        Call AddRelease()

        If objEH.Finally Then

            Call OpenInWindow ( "rtree.asp?DONE=OK&"& objPMod.ComposeURL() )

        End If

    End If

End If

'----------------------------------------------

%>

<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 rel="stylesheet" href="images/release_manager_style.css" type="text/css">

<link rel="stylesheet" href="images/navigation.css" type="text/css">

<script language="JavaScript" src="images/common.js"></script>

<!-- DROPDOWN MENUS -->

<!--#include file="_menu_def.asp"-->

<script language="JavaScript1.2" src="images/popup_menu.js"></script>

</head>

<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onLoad="FormName.rtag_name.focus();">

<!-- MENU LAYERS -------------------------------------->

<div id="popmenu" class="menuskin" onMouseover="clearhidemenu();highlightmenu(event,'on')" onMouseout="highlightmenu(event,'off');dynamichide(event)"> 

</div>

<!-- TIPS LAYERS -------------------------------------->

<div id="formTipsLayer" style="position: absolute; z-index: 1000; visibility: hidden; left:0; top: 0; width: 10">&nbsp;</div>

<!----------------------------------------------------->

<!-- HEADER -->

<!--#include file="_header.asp"-->

<!-- BODY ---->

<table width="100%" border="0" cellspacing="0" cellpadding="0">

<%

'-- FROM START ---------------------------------------------------------------------------------------------------------

objFormComponent.FormName = "FormName"

objFormComponent.Action = ScriptName

Call objFormComponent.FormStart()

%>

  <tr> 

    <td width="1" background="images/bg_home_orange.gif" valign="top">

    </td>

    <td width="100%" rowspan="2" align="center" valign="top" bgcolor="#EEEFEF"><table width="10" border="0" cellspacing="0" cellpadding="0">

      <tr>

        <td width="1%"></td>

        <td width="100%">

          <table width="100%" border="0" cellspacing="0" cellpadding="0">

            <tr>

              <td nowrap class="form_ttl">NEW RELEASE </td>

              <td align="right" valign="bottom"></td>

            </tr>

        </table></td>

        <td width="1%"></td>

      </tr>

      <tr>

        <td align="left" valign="top" background="images/lbox_bg_blue.gif"><img src="images/lbox_tl_cnr_b.gif" width="13" height="13"></td>

        <td background="images/lbox_bg_blue.gif" class="lbox_ttl_w"><img src="images/h_trsp_dot.gif" width="600" height="15"></td>

        <td align="right" valign="top"  background="images/lbox_bg_blue.gif"><img src="images/lbox_tr_cnr_b.gif" width="13" height="13"></td>

      </tr>

      <tr>

        <td bgcolor="#FFFFFF"><img src="images/h_trsp_dot.gif" width="10" height="100"></td>

        <td bgcolor="#FFFFFF" valign="top">

        <%

        If parSourceRtagId <> "" Then

            Call Messenger ( "New release will be created from <br>"& objFormCollector.Item("location"), 3, "100%" )

        End If

        %>

        <!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->    

        <!--#include file="messages/_msg_inline.asp"-->

        <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->

        <br>

        <table width="100%"  border="0" cellspacing="2" cellpadding="0">

          <tr>

            <td nowrap class="form_iname" valign="top">Release Name </td>

            <td valign="top" nowrap><%=objFormComponent.TextBox ( "rtag_name", objFormCollector.Item("rtag_name"), "class='form_ivalue' size='60'" )%></td>

            <td valign="top"><%=objForm.Validate ("rtag_name")%></td>

          </tr>

          <tr>

            <td nowrap class="form_iname" valign="top">Branch Release</td>

            <td valign="top" nowrap class="form_iname">

              <input name="branch" type="radio" value="N" checked>No

              <input name="branch" type="radio" value="Y" <%=iif(Request("branch") = "Y", " checked","")%>>Yes</td>

            <td valign="top"></td>

          </tr>

          <tr>

            <td nowrap class="form_iname" valign="top">Release Mode</td>

            <td valign="top" nowrap class="form_iname">

              <input name="mode" type="radio" value="N" checked>Open

              <input name="mode" type="radio" value="Y" >Closed

              <input name="mode" type="radio" value="A" >Archived</td>

            <td valign="top"></td>

          </tr>

          <tr>

            <td valign="top" nowrap class="form_iname">Comments</td>

            <td valign="top"><%=objFormComponent.TextArea ( "rtag_description", Request("rtag_description"), 10, 60, "class='form_ivalue'" )%></td>

            <td valign="top"><%=objForm.Validate ("rtag_description")%></td>

          </tr>

          <tr>

            <td width="10%" class="form_iname">&nbsp;</td>

            <td width="1%">&nbsp;</td>

            <td width="90%" class="val_err"></td>

          </tr>

        </table>

        </td>

        <td background="images/lbox_bgside_white.gif">&nbsp;</td>

      </tr>

      <tr>

        <td background="images/bg_action_norm.gif" ></td>

        <td align="right" background="images/bg_action_norm.gif" >

        <%=objFormComponent.SubmitButton ( "Submit", "class='form_btn'" )%>&nbsp;

        <%=objFormComponent.CancelButton ( "Cancel", "class='form_btn'", "rtree.asp?CANCEL=OK&"& objPMod.ComposeURL() )%>

        <%=objPMod.ComposeHiddenTags()%>

        <input type="hidden" name="source_rtag_id" value="<%=parSourceRtagId%>">

        <input type="hidden" name="action" value="true">

        </td>

        <td background="images/bg_action_norm.gif" ><img src="images/h_trsp_dot.gif" width="5" height="30"></td>

      </tr>

      <tr>

        <td background="images/lbox_bg_blue.gif" valign="bottom"><img src="images/lbox_bl_cnr_b.gif" width="13" height="13"></td>

        <td background="images/lbox_bg_blue.gif"></td>

        <td background="images/lbox_bg_blue.gif" valign="bottom" align="right"><img src="images/lbox_br_cnr_b.gif" width="13" height="13"></td>

      </tr>

    </table>

    <!-- ACTION BUTTONS ---------------------------------------------->

    <!-- ACTION BUTTONS END  ------------------------------------------></td>

    <td width="1" valign="top"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>

  </tr>

  <tr> 

    <td valign="bottom" align="center" background="images/bg_home_orange.gif"><img src="images/img_vtree.gif" width="86" height="99" vspace="20" hspace="30"></td>

    <td background="images/bg_lght_gray.gif" valign="top"><img src="images/h_trsp_dot.gif" width="1" height="500"></td>

  </tr>

<%

Call objFormComponent.FormEnd()

'-- FROM END ----------------------------------------------------------------------------------------------------------------

%>   

</table>

<!-- FOOTER -->

<!--#include file="_footer.asp"-->

</body>

</html>

<%

Call Destroy_All_Objects

%>