<!--#include virtual="/includes/topofpage.asp"-->
<%
If UCase(Request.ServerVariables("REQUEST_METHOD")) = "POST" Then

	Dim SQL1
	Dim Conn
	Dim RS1

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={SQL Server};SERVER=WEBSRV01;UID=web;pwd=w3bs1t3;DATABASE=AVANTE"

Set RS1 = Server.CreateObject("ADODB.Recordset")
SQL1 = "[Avante].[dbo].[Add_Amenity_Type] '" & Request.Form("Type_Name") & "','" & Request.Form("Type_Description") & "'"
Conn.Execute (SQL1)

End If

%>

<HTML>
<STYLE>
BODY {SCROLLBAR-FACE-COLOR: #5e5ebe; SCROLLBAR-HIGHLIGHT-COLOR: #5e5ebe; SCROLLBAR-SHADOW-COLOR: #5e5ebe; SCROLLBAR-3DLIGHT-COLOR: #5e5ebe; SCROLLBAR-ARROW-COLOR:  #6666CC; SCROLLBAR-TRACK-COLOR: #E3E3E3; SCROLLBAR-DARKSHADOW-COLOR: #666666; }
</STYLE>
<head>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE></TITLE>
<script language="JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>
</HEAD>
<BODY>
<FORM action="Create_Amenity_Type.asp" method=post id=form1 name=form1>
<P>
<TABLE cellSpacing=0 cellPadding=1 width=525 border=0 id=TABLE1>
  
  <TR bgColor=#6699cc>
    <TD colSpan=4><B><FONT face="Verdana, Arial, Helvetica, sans-serif" 
      color=#000000 size=2>&nbsp;&nbsp;&nbsp;Create Inventory Types</FONT></B></TD></TR>
  <TR>
    <TD align=right width=121 height=24><B><FONT 
      face="Verdana, Arial, Helvetica, sans-serif" size=1> Inventory 
      Type&nbsp;Name:</FONT></B></TD>
    <TD width=166 height=24><INPUT size=27 name=Type_Name 
      style="WIDTH: 278px; HEIGHT: 25px" maxLength=50> </TD>

    <td>
      <P align=center>
        <FONT face="Verdana, Arial, Helvetica, sans-serif" color=#000000 size=1>
            <A onclick="MM_openBrWindow('Inventory_Type_List.asp','','width=570,height=300,resizable=yes,scrollbars=yes')" target="" href="#" >Current Inventory Type List</A>
        </FONT>
      </P>
    </td>
  </TR>
       
  <TR>
    <TD align=right width=121><B><FONT 
      face="Verdana, Arial, Helvetica, sans-serif" size=1> Inventory Type 
      Description:</FONT></B></TD>
    <TD width=166><TEXTAREA title=Type_Description style="WIDTH: 277px; HEIGHT: 58px" name=Type_Description rows=8 cols=30></TEXTAREA> </TD></TR>
  <TR align=middle>
    <TD colSpan=4 height=17>  
      <P><INPUT type=submit value="Create Inventory Type" name=Submit> 
      </P>
      <P><INPUT id=CloseWindow onclick=window.close(); type=button value="Close Window" name=CloseWindow></P> 
  </TD></TR></TABLE></P>
</FORM>
</BODY>
</HTML>
