Untitled

<!doctype html><head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>

<cfinclude template="request_dsn.cfm">


<!--- Insert Departaments --->

<h1>Insert Departaments</h1>
<cfif isdefined("action") and action eq "insert">
  <cfdump var="#form#" />
  <cfquery name="insert_departaments" datasource="#request.dsn#">
      insert into departaments (dept_name) values ('#dept_name#')
  </cfquery>
</cfif>

<form method="post" >
<table width="250" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td>Departament Name:</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><input type="text" name="dept_name" /></td>
    <input type="hidden" name="action" value="insert"/>
    <td><input type="submit" name="button" value="Submit" /></td>
  </tr>
</table>
</form>

<br />

<h1>Departaments</h1>
<cfquery name="select_departaments" datasource="#request.dsn#">
    select * from departaments
</cfquery>

<cfoutput query="select_departaments">
#dept_name#<br />
</cfoutput>

<br /><br />
<img src="../pwdmanager/images/pix_gray.jpg" width="100%" height="1" />
<br />

<!--- Insert Positions --->
<h1>Insert Positions</h1>
<cfif isdefined("action") and action eq "insert_positions">
  <cfdump var="#form#" />
  <cfquery name="insert_positions" datasource="#request.dsn#">
      insert into positions (position_name, position_en, position_sp, position_pt, position_fr, position_ge, position_ru) values ('#position_name#', '#position_en#', '#position_sp#', '#position_pt#', '#position_fr#', '#position_ge#', '#position_ru#')
  </cfquery>
</cfif>

<form method="post" >
Position Name: <input type="text" name="position_name" /><br />
Position in English: <input type="text" name="position_en" /><br />
Position in Spanish: <input type="text" name="position_sp" /><br />
Position in Portuguese: <input type="text" name="position_pt" /><br />
Position in French: <input type="text" name="position_fr" /><br />
Position in German: <input type="text" name="position_ge" /><br />
Position in Russian: <input type="text" name="position_ru" /><br />
<input type="hidden" name="action" value="insert_positions"/>
<input type="submit" name="button" value="Submit" />
</form>

<br />

<h1>Positions</h1>
<cfquery name="select_positions" datasource="#request.dsn#">
    select * from positions
</cfquery>

<cfoutput query="select_positions">
#position_name# / #position_en# / #position_sp# / #position_pt# / #position_fr# / #position_ge# / #position_ru#<br />
</cfoutput>

<br /><br />
<img src="../pwdmanager/images/pix_gray.jpg" width="100%" height="1" />
<br />

<!--- Insert Spoken Languages --->
<h1>Insert Spoken Languages</h1>
<cfif isdefined("action") and action eq "insert_spokenlang">
  <cfdump var="#form#" />
  <cfquery name="insert_spokenlangs" datasource="#request.dsn#">
      insert into spokenlangs (lang_name, lang_flag) values ('#lang_name#', '#lang_flag#')
  </cfquery>
</cfif>

<form method="post" >
Language Name: <input type="text" name="lang_name" /><br />
Language Flag Path: <input type="text" name="lang_flag" /><br />
<input type="hidden" name="action" value="insert_spokenlang"/>
<input type="submit" name="button" value="Submit" />
</form>

<br />

<h1>Spoken Languages</h1>
<cfquery name="select_spokenlangs" datasource="#request.dsn#">
    select * from spokenlangs
</cfquery>

<cfoutput query="select_spokenlangs">
#lang_name# / <img src="#lang_flag#" width="11" height="11"/> / #lang_flag#<br />
</cfoutput>

<br /><br />
<img src="../pwdmanager/images/pix_gray.jpg" width="100%" height="1" />
<br />

<!--- Insert Employees --->
<h1>Insert Employees</h1>
<cfif isdefined("action") and action eq "insert_employees">
  <cfdump var="#form#" />
  <cfquery name="insert_employees" datasource="#request.dsn#">
      insert into employees (emp_name, emp_dept, emp_position, emp_ext, emp_email, emp_photo, spoken_langs, emp_order) values ('#emp_name#', '#emp_dept#', '#emp_position#', '#emp_ext#', '#emp_email#', '#emp_photo#', '#spoken_langs#', '#emp_order#')
  </cfquery>
</cfif>

<cfoutput>
<form method="post" >
Name: <input type="text" name="emp_name" /><br />
Departament: <select name="emp_dept">
<cfloop query="select_departaments">
<option value="#dept_id#" <cfif dept_id eq 1>selected="selected"</cfif>>#dept_name#</option>
</cfloop>
</select><br />
Position: <select name="emp_position">
<cfloop query="select_positions">
<option value="#position_id#" <cfif position_id eq 1>selected="selected"</cfif>>#position_name#</option>
</cfloop>
</select><br />
Extension Number: <input type="text" name="emp_ext" /><br />
Email: <input type="text" name="emp_email" /><br />
Photo (Path): <input type="text" name="emp_photo" /><br />
Spoken Languages:
<select multiple="" name="spoken_langs" size="4">
<cfloop query="select_spokenlangs">
<option value="#lang_id#" <cfif lang_id eq 1>selected="selected"</cfif>>#lang_name#</option>
</cfloop>
</select><br />
Order: <input type="text" name="emp_order" /><br />
<input type="hidden" name="action" value="insert_employees"/>
<input type="submit" name="button" value="Submit" />
</form>
</cfoutput>

<br />

<h1>Employees</h1>
<cfquery name="select_employees" datasource="#request.dsn#">
    select * from employees
</cfquery>

<cfoutput query="select_employees">
&bull; #emp_name# / #emp_dept# / #emp_position# / #emp_ext# / #emp_email# / #emp_photo# / #spoken_langs# / #emp_order# <br />
</cfoutput>

<br /><br />
<img src="../pwdmanager/images/pix_gray.jpg" width="100%" height="1" />
<br />
<br />
<br />
<br />