<%@ Language=VBScript %>
<%
Option Explicit
%>
<% 
	Dim sTitle 
	sTitle = "Edit Job in Cart"
%>
<!--#include file="_ScriptLibrary/adovbs.inc"-->
<!--#include file="datastore.asp"-->
<%
Dim sUserID
sUserID = trim(Request("userid"))

Dim iItemID
iItemID = request("job")

'check if userid is empty. if empty redirect to login screen
if sUserID = "" then Response.Redirect "login.asp?menu=school"

Dim cnSchoolJobs 'Connection object
Set cnSchoolJobs = server.CreateObject("ADODB.Connection")

'open the connection object
cnSchoolJobs.Open sConnect


Dim rsCart 'Recordset object
Set rsCart = server.CreateObject("ADODB.Recordset")

Dim sSQL 'Define SQL statement
sSQL = "SELECT * FROM CART WHERE itemid = " & iItemID & ";"

'populate recordset
rsCart.open sSQL, cnSchoolJobs, 0, 3, adCmdText

if rsCart.EOF = false then %>

<!--#include file=header.asp-->
<!--#include file=top.asp-->

<script language=JavaScript>
<!--
function VerifyData()
{
var msgError="";

// Check for empty field - Job Title
if (document.frmSaveJob.txtJobTitle.value == "")
	{
		msgError = msgError + "\n*Job Title is a required field."
	}

// Check for empty field - Area of Expertise
if (document.frmSaveJob.cboExpertise.options[document.frmSaveJob.cboExpertise.selectedIndex].value == "0")
	{
		msgError = msgError + "\n*Area of Expertise is a required field."
	}

// Check for empty field - Start date
if (document.frmSaveJob.txtStartDate.value == "")
	{
		msgError = msgError + "\n*Start Date is a required field."
	}

// Check for empty field - Degree
if (document.frmSaveJob.cboEducation.options[document.frmSaveJob.cboEducation.selectedIndex].value == "0")
	{
		msgError = msgError + "\n*Degree is a required field."
	}

// Check for empty field - Job Description
if (document.frmSaveJob.txtJobDesc.value == "")
	{
		msgError = msgError + "\n*Job Description is a required field."
	}

// Check for empty field - Salary
if (document.frmSaveJob.txtLowSalary.value == "")
	{
		msgError = msgError + "\n*Salary is a required field."
	}
	
var digits="0123456789"
var temp
for (var i=0;i<document.frmSaveJob.txtLowSalary.value.length;i++){
temp=document.frmSaveJob.txtLowSalary.value.substring(i,i+1)
if (digits.indexOf(temp)==-1){
alert("Salary must be numeric !")
return false
      }
   }

// Check for empty field - Duration
if (document.frmSaveJob.cboDuration.options[document.frmSaveJob.cboDuration.selectedIndex].value == "0")
	{
		msgError = msgError + "\n*Duration is a required field."
	}


// Check for empty field - Contact Name
if (document.frmSaveJob.txtContactName.value == "")
	{
		msgError = msgError + "\n*Contact Name is a required field."
	}

// Check for empty field - Contact phone
if (document.frmSaveJob.txtArea.value == "")
	{
		msgError = msgError + "\n*Area Code is a required field."
	} 
	
// Check for empty field - Contact phone
if (document.frmSaveJob.txtPhone.value == "")
	{
		msgError = msgError + "\n*Phone Number is a required field."
	} 

	
// 
if (msgError != "")
	{
		alert("Please fill in all required fields...\n" + msgError)
		return false;
	}
else
	{
		return true;
	}

}
//-->
</script>

<center>

<h2 align=center color=red>Edit Job Entry</h2>
<font color=red>* Indicates a required field.</font><p>
<form action="savejob.asp?userid=<%=sUserID%>&itemid=<%=iItemID%>" method="post" name="frmSaveJob" onSubmit="return VerifyData()">

<table width=600 border=0 cellspacing=5 cellpadding=0>
<tr><td><font size="5" color="red"><b>*</b></font></td><td><b>Job Title</b></td><td><input name="txtJobTitle" id="txtJobTitle" type="text" size="30" value="<%=rsCart("title")%>"></td></tr>
<tr><td><font size="5" color="red"><b>*</b></font></td><td><b>Area of Expertise</b></td><td><select name=cboExpertise size=1>
<option value="0"> -- Select Area -- </option>
<option value="1"<%if rsCart("expertise") = "1" then Response.Write " SELECTED" end if%>>Administration</option>
<option value="2"<%if rsCart("expertise") = "2" then Response.Write " SELECTED" end if%>>Computers &amp; Technology</option>
<option value="3"<%if rsCart("expertise") = "3" then Response.Write " SELECTED" end if%>>Desktop Publishing &amp; Multimedia</option>
<option value="4"<%if rsCart("expertise") = "4" then Response.Write " SELECTED" end if%>>Early Learning</option>
<option value="5"<%if rsCart("expertise") = "5" then Response.Write " SELECTED" end if%>>Financial &amp; Business</option>
<option value="6"<%if rsCart("expertise") = "6" then Response.Write " SELECTED" end if%>>Fine Arts</option>
<option value="7"<%if rsCart("expertise") = "7" then Response.Write " SELECTED" end if%>>Foreign Language &amp; ESOL</option>
<option value="8"<%if rsCart("expertise") = "8" then Response.Write " SELECTED" end if%>>General Education</option>
<option value="9"<%if rsCart("expertise") = "9" then Response.Write " SELECTED" end if%>>Health &amp; Physical Education</option>
<option value="10"<%if rsCart("expertise") = "10" then Response.Write " SELECTED" end if%>>History, Geography &amp; Social Studies</option>
<option value="11"<%if rsCart("expertise") = "11" then Response.Write " SELECTED" end if%>>Language Arts</option>
<option value="12"<%if rsCart("expertise") = "12" then Response.Write " SELECTED" end if%>>Library, Media Science &amp; Reference</option>
<option value="13"<%if rsCart("expertise") = "13" then Response.Write " SELECTED" end if%>>Mathematics Education</option>
<option value="14"<%if rsCart("expertise") = "14" then Response.Write " SELECTED" end if%>>Measurement &amp; Testing</option>
<option value="15"<%if rsCart("expertise") = "15" then Response.Write " SELECTED" end if%>>Music &amp; Performing Arts</option>
<option value="16"<%if rsCart("expertise") = "16" then Response.Write " SELECTED" end if%>>Professional Training</option>
<option value="17"<%if rsCart("expertise") = "17" then Response.Write " SELECTED" end if%>>Psychology &amp; Counseling</option>
<option value="18"<%if rsCart("expertise") = "18" then Response.Write " SELECTED" end if%>>Religious Education</option>
<option value="19"<%if rsCart("expertise") = "19" then Response.Write " SELECTED" end if%>>Research &amp; Grants</option>
<option value="20"<%if rsCart("expertise") = "20" then Response.Write " SELECTED" end if%>>Science Education</option>
<option value="21"<%if rsCart("expertise") = "21" then Response.Write " SELECTED" end if%>>Social Sciences</option>
<option value="22"<%if rsCart("expertise") = "22" then Response.Write " SELECTED" end if%>>Special Education</option>
<option value="23"<%if rsCart("expertise") = "23" then Response.Write " SELECTED" end if%>>Web-Based Education</option>
</select>
</td></tr>
<tr><td><font size="5" color="red"><b>*</b></font></td><td><b>Start Date</b></td><td><input name="txtStartDate" id="txtStartDate" type="text" value="<%=rsCart("start_date")%>" size="30"></td></tr>
<tr><td><font size="5" color="red"><b>*</b></font></td><td><b>Degree</b></td><td><select name="cboEducation" id="cboEducation" size="1">
<option value="0"> -- Select Degree --</option>
<option value="1"<% if rsCart("degree_req") = "1" then Response.Write " SELECTED" end if%>>High School</option>
<option value="2"<% if rsCart("degree_req") = "2" then Response.Write " SELECTED" end if%>>Bachelor Degree</option>
<option value="3"<% if rsCart("degree_req") = "3" then Response.Write " SELECTED" end if%>>Master Degree</option>
<option value="4"<% if rsCart("degree_req") = "4" then Response.Write " SELECTED" end if%>>Doctorate</option>
<option value="5"<% if rsCart("degree_req") = "5" then Response.Write " SELECTED" end if%>>Other</option>
</select>
</td></tr>
<tr><td></td><td><b>Special Qualifications</b></td><td><input name="txtSpecialQual" id="txtSpecialQual" type="text" value="<%=rsCart("special_qual")%>" size="30" maxlength="50"></td></tr>
<tr><td><font size="5" color="red"><b>*</b></font></td><td><b>Job Description</b></td><td><textarea name="txtJobDesc" id="txtJobDesc" type="text" cols="30" rows=3 wrap="virtual"><%=rsCart("job_description")%></textarea></td></tr>
<tr>
	<td>
		<font size="5" color="red"><b>*</b></font>
	</td>
	<td>
		<b>Salary</b>
	</td>
	<td>
	<table cellspacing=1 cellpadding=2 border=0>
		<tr>
			<td><b>Min $</b> <input name="txtLowSalary" id="txtLowSalary" value="<%=rsCart("minsalary")%>" size="8" type="text"> - <b>Max $</b> <input name="txtHighSalary" id="txtHighSalary" value="<%=rsCart("maxsalary")%>" size="8" type="text"></td>
			<td>
				<input type="radio" name="radPerYrHr" value="1"<% if rsCart("peryrhr") = "1" then Response.Write " CHECKED" else Response.Write "" end if%> tabindex="0"> <b>Per Year</b><br>
				<input type="radio" name="radPerYrHr" value="2"<% if rsCart("peryrhr") = "2" then Response.Write " CHECKED" else Response.Write "" end if%> tabindex="1"> <b>Per Hour</b>
			</td>		
		</tr>
	</table>
</td></tr>
<tr><td><font size="5" color="red"><b>*</b></font></td><td><b>Listing Fee</b></td><td><select name="cboDuration" id="cboDuration" size="1">
<option value="0"> -- Select Duration --</option>
<option value="30"<% if rsCart("graceperiod") = "30" then Response.Write " SELECTED" else Response.Write "" end if%>>30 Days - $25</option>
<option value="60"<% if rsCart("graceperiod") = "60" then Response.Write " SELECTED" else Response.Write "" end if%>>60 Days - $45</option>
<option value="90"<% if rsCart("graceperiod") = "90" then Response.Write " SELECTED" else Response.Write "" end if%>>90 Days - $60</option>
</select>
</td></tr>
<tr><td><font size="5" color="red"><b>*</b></font></td><td><b>Contact Name:</b></td><td><input name="txtContactName" id="txtContactName" size="30" type="text" value="<%=rsCart("contact_name")%>"></td></tr>
<tr><td><font size="5" color="red"><b>*</b></font></td><td><b>Contact Phone:</b></td><td><input name="txtArea" id="txtArea" size="3" type="text" maxlength="3" value="<%=rsCart("contact_areacode")%>"><input name="txtPhone" id="txtPhone" size="10" type="text" value="<%=rsCart("contact_phone")%>"></td></tr>
<tr><td>&nbsp;</td><td><b>Contact Email:</b></td><td><input name="txtContactEmail" id="txtContactEmail" size="30" type="text" value="<%=rsCart("contact_email")%>"></td></tr>
<tr><td>&nbsp;</td><td>&nbsp;</td><td><input type="submit" value="Save Job" id="SaveJob" name="SaveJob">&nbsp;<input type="reset" value="Reset" id="ResetFields" name="ResetFields"></td></tr>
</table>
</form>
</center>
<% end if%>
<%
rsCart.close
Set rsCart = Nothing

cnSchoolJobs.close
Set cnSchoolJobs = Nothing
%>
<!--#include file=bottom.asp-->
<!--#include file=footer.asp-->