Subversion Repositories DevTools

Rev

Rev 7235 | Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
7225 dpurdie 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'=====================================================
4
'	wAddBuildPlatform.asp
5
'=====================================================
6
%>
7
<%
8
Option explicit
9
Response.Expires = 0
10
%>
11
<!--#include file="common/conf.asp"-->
12
<!--#include file="common/globals.asp"-->
13
<!--#include file="common/formating.asp"-->
14
<!--#include file="common/qstr.asp"-->
15
<!--#include file="common/common_subs.asp"-->
16
<!--#include file="common/_form_window_common.asp"-->
17
 
18
 
19
<%
20
'------------ ACCESS CONTROL ------------------
21
%>
22
<!--#include file="_access_control_login.asp"-->
23
<!--#include file="_access_control_general.asp"-->
24
<%
25
'------------ VARIABLE DEFINITION -------------
26
Dim rsQry
27
Dim sMessage
28
Dim Query_String
29
 
30
Dim name
31
Dim bp_id
32
Dim active, activeChecked
33
Dim description
34
 
35
'------------ CONSTANTS DECLARATION -----------
36
'------------ VARIABLE INIT -------------------
37
sMessage = NULL
38
Set objFormCollector = CreateObject("Scripting.Dictionary")
39
'------------ CONDITIONS ----------------------
40
'----------------------------------------------
41
%>
42
<%
43
'------------ RUN BEFORE PAGE RENDER ----------
44
 
45
If CBool(Request("action")) Then
46
 
47
   If Request("bp_id") <> "" Then
48
 
49
      OraDatabase.Parameters.Add "BP_ID",                 Request("bp_id"),             ORAPARM_INPUT, ORATYPE_NUMBER
50
      OraDatabase.Parameters.Add "NAME",          		  Request("name"),          	ORAPARM_INPUT, ORATYPE_VARCHAR2
51
      OraDatabase.Parameters.Add "DESCRIPTION",           Request("description"),       ORAPARM_INPUT, ORATYPE_VARCHAR2
52
      OraDatabase.Parameters.Add "ACTIVE",                Request("active"),            ORAPARM_INPUT, ORATYPE_CHAR
53
 
54
      objEH.ErrorRedirect = FALSE
55
      objEH.TryORA ( OraSession )
56
      On Error Resume Next
57
 
58
      OraDatabase.ExecuteSQL _
59
      "BEGIN  PK_BUILDAPI.UPDATE_BUILD_PLATFORM(:BP_ID, :NAME, :DESCRIPTION, :ACTIVE);  END;"
60
 
61
      objEH.CatchORA ( OraSession )
62
 
63
      OraDatabase.Parameters.Remove "BP_ID"
64
      OraDatabase.Parameters.Remove "NAME"
65
      OraDatabase.Parameters.Remove "DESCRIPTION"
66
      OraDatabase.Parameters.Remove "ACTIVE"
67
 
68
      If objEH.Finally Then
69
         Call OpenInParentWindow ("admin_build_platforms.asp?bp_id="&Request("bp_id"))
70
         Call CloseWindow()
71
      End If
72
 
73
      rsQry.Close
74
      Set rsQry = nothing
75
 
76
   Else
77
      OraDatabase.Parameters.Add "NAME",          	Request("name"),          ORAPARM_INPUT, ORATYPE_VARCHAR2
78
      OraDatabase.Parameters.Add "DESCRIPTION",     Request("description"),           ORAPARM_INPUT, ORATYPE_VARCHAR2
79
      OraDatabase.Parameters.Add "ACTIVE",          Request("active"),                ORAPARM_INPUT, ORATYPE_CHAR
80
 
81
      objEH.ErrorRedirect = FALSE
82
      objEH.TryORA ( OraSession )
83
      On Error Resume Next
84
 
85
      OraDatabase.ExecuteSQL _
86
      "BEGIN  PK_BUILDAPI.ADD_BUILD_PLATFORM(:NAME, :DESCRIPTION, :ACTIVE);  END;"
87
 
88
      objEH.CatchORA ( OraSession )
89
 
90
      OraDatabase.Parameters.Remove "NAME"
91
      OraDatabase.Parameters.Remove "DESCRIPTION"
92
      OraDatabase.Parameters.Remove "ACTIVE"
93
 
94
      If objEH.Finally Then
95
         Call OpenInParentWindow ("admin_build_platforms.asp")
96
         Call CloseWindow()
97
      End If
98
 
99
      rsQry.Close
100
      Set rsQry = nothing
101
 
102
   End If
103
 
104
End If
105
 
106
 
107
'----------------------------------------------
108
%>
109
<html>
110
<head>
111
<title>Release Manager</title>
112
<link rel="shortcut icon" href="<%=FavIcon%>"/>
113
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
114
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
115
<link href="images/release_manager_style.css?ver=<%=VixVerNum%>" rel="stylesheet" type="text/css">
116
<script language="JavaScript" src="scripts/common.js?ver=<%=VixVerNum%>"></script>
117
</head>
118
<body leftmargin="0" topmargin="0" onLoad="self.focus();FormName.display_name.focus();">
119
<table width="100%"  border="0" cellspacing="0" cellpadding="10">
120
   <tr>
121
      <td class="body_txt">
122
         Add a new Build Platform or edit an existing Build Platform.
123
      </td>
124
   </tr>
125
   <%
126
   '-- FROM START --------------------------------------------------------------------------------------------------------------
127
   objFormComponent.FormName = "FormName"
128
   objFormComponent.FormClass = "form_tight"
129
   objFormComponent.Action = ScriptName
130
   objFormComponent.OnSubmit = "ShowProgress();"
131
   Call objFormComponent.FormStart()
132
   %>
133
   <tr>
134
      <td class="form_field_bg" >
135
         <!-- NEW PRODUCT ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
136
         <%Call Messenger ( sMessage , 3, "100%" )%>
137
         <!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->
138
         <!--#include file="messages/_msg_inline.asp"-->
139
         <br>
140
         <%
141
         If Request("bp_id") <> "" Then
142
            %>
143
            <input type="hidden" name="bp_id" value="<%=Request("bp_id")%>">
144
            <%
145
            Dim rsTemp
146
 
147
            Query_String = "select * from build_platforms bp "&_
148
              " where bp.bp_id = "& Request("bp_id")
149
 
150
            Set rsTemp = OraDatabase.DbCreateDynaset( Query_String, cint(0))
151
 
152
            name            =   rsTemp("bp_name")
153
            active          =   rsTemp("bp_active")
154
            description     =   rsTemp("bp_description")
155
 
156
            activeChecked = ""
157
            if active = "Y" Then activeChecked = "checked"
158
 
159
            rsTemp.Close()
160
            Set rsTemp = Nothing      
161
          Else
162
            activeChecked = "checked"
163
          End If%>
164
 
165
         <table width="50%" border="0">
166
            <tr>
167
               <td><span class="body_txt nowrap">Platform Name</span></td>
168
               <td>
169
                  <input name="name" type="text" class="body_txt" value="<%=name%>" size=50 maxlength=50>
170
               </td>
171
            </tr>
172
            <tr>
173
               <td><span class="body_txt nowrap">Allow Use</span></td>
174
               <td>
175
                  <input type="checkbox" name="active" value="Y" <%=activeChecked%>>
176
                  <span class="body_txt">Allow users to add this platform to a build filter</span>
177
               </td>
178
            </tr>
179
            <tr>
180
               <td><span class="body_txt nowrap">Description</span></td>
181
               <td>
182
                  <textarea name="Description" cols=50 rows=5 class='body_txt'><%=Description%></textarea>
183
               </td>
184
            </tr>
185
         </table>
186
      </td>
187
   </tr>
188
   <tr>
189
      <td>
190
         <table class="full_table">
191
            <tr>
192
               <td><%=ProgressBar()%></td>
193
               <td align="right">
194
                  <input name="btn" type="submit" class="form_btn" value="Add/Update">
195
                  <input name="btn" type="reset" class="form_btn" value="Cancel" onclick="parent.closeIFrame();">
196
               </td>
197
            </tr>
198
         </table>
199
      </td>
200
   </tr>
201
   <%=objPMod.ComposeHiddenTags()%>
202
   <input type="hidden" name="action" value="true">
203
   <%
204
   Call objFormComponent.FormEnd()
205
   '-- FROM END ----------------------------------------------------------------------------------------------------------------
206
   %>
207
</table>
208
</body>
209
</html>
210
<%
211
'------------ RUN AFTER PAGE RENDER -----------
212
Set objFormCollector = Nothing
213
'----------------------------------------------
214
Call Destroy_All_Objects
215
%>
216
 
217