Solved

Renamed .aspx file, now Design View is blank.  VS2010

Posted on 2013-01-23
9
792 Views
Last Modified: 2013-01-29
Hi, I hope someone can help me real quick.  I renamed a couple of .aspx pages in VS 2010 by right-clicking on the .aspx/.aspx.vb code pair in the Solution Explorer and selecting "Rename", just to shorten the filenames.

Now Split view and Design view just show a blank page for the design view.  Everything else looks and works fine.

Is there a global file or something that has gotten out of sync?

Thanks!
0
Comment
Question by:megnin
  • 6
  • 3
9 Comments
 
LVL 25

Expert Comment

by:Rouchie
Comment Utility
Go into code view of the code-behind file and check the name of the class in the code behind file.

For example, Default.aspx.vb will have a line at the top that says:
Partial Class _Default
    Inherits System.Web.Ui.Page

Open in new window

Make sure you change the _Default to the name of your file.  Subdirectories should be referenced with an underscore, so

Root/Folder1/MyPage.aspx.vb

would start with:
Partial Class _Folder1_MyPage

Open in new window

Once you've changed the class name, go into the ASPX file and ensure that the CodeFile and Inherits values in the top line match your code-behind file.  So for Default.aspx you should see:
<%@ Page  .... CodeFile="Default.aspx.vb" Inherits="_Default"  .....%>

Open in new window

and Folder1/MyPage.aspx would look like this:
<%@ Page  .... CodeFile="MyPage.aspx.vb" Inherits="_folder1_MyPage"  .....%>

Open in new window

0
 
LVL 1

Author Comment

by:megnin
Comment Utility
I tried to make everything match.

Here's what I've got in the Applicant1.aspx file:

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Applicant1.aspx.vb" Inherits="Applicant1" MaintainScrollPositionOnPostback="true" %>

This is in the Applicant1.aspx.vb file:
Partial Class Applicant1

All files are in the root of the virtual directory:
\\WEBSERVER\D$\Inetpub\www2\WEBSITE\
0
 
LVL 25

Expert Comment

by:Rouchie
Comment Utility
Okay that looks okay to me.  Does
Partial Class Applicant1

Open in new window

have
Inherits System.Web.UI.Page 

Open in new window

directly underneath it?

If so, are there any references to other files such as style sheets and/or user controls that need to have there references changed, or is everything else in the same place?

Lastly, does your page_load event Handle me.Load, e.g.
Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load

Open in new window

and NOT:
Protected Sub Page_Load(sender As Object, e As System.EventArgs)

Open in new window

0
 
LVL 1

Author Comment

by:megnin
Comment Utility
[Sorry, I had a doctors appointment.  Back now.]

Yes, I think all that's good:

Imports System.Data
Imports System.Data.SqlClient
Imports System.Web.UI.WebControls
Partial Class Applicant1
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
End Sub
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 25

Expert Comment

by:Rouchie
Comment Utility
Okay could you possibly post the code (aspx + vb) as <code> samples for me to check out?  The only other thing I can think of is references to user controls or controls with Visibility=False in the ASPX file.
0
 
LVL 1

Author Comment

by:megnin
Comment Utility
Sure.  I'll post the .aspx and .vb files.  Everything was fine before I renamed the files, though, so I don't think it's a control with the Visibility=False.  Then I know that control wouldn't show, but my Design view is a blank page.  All blank.  Give me a sec to get the files in the next post...
0
 
LVL 1

Author Comment

by:megnin
Comment Utility
I didn't remove any comments so it's messy.  I also included my web.config with private information removed.  I thank you for your help.

Applicant1.aspx:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Applicant1.aspx.vb" Inherits="Applicant1" MaintainScrollPositionOnPostback="true" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<!DOCTYPE html>
<html>
<head id="Head1" runat="server">
	<title>Community Service Program</title>
	<link rel="shortcut icon" href="favicon.ico" />
	<script type="text/javascript" language="javascript">	    AC_FL_RunContent = 0;</script>
	<script type="text/javascript" src="AC_RunActiveContent.js" language="javascript"></script>
	<script type='text/javascript' src='scripts/dFilter.js'></script>
	<!--link href="formfields.css" rel="Stylesheet" type="text/css" -->
	<link rel="stylesheet" type="text/css" href="css/StyleSheet.css" />
	<link rel="stylesheet" type="text/css" href="css/Participant.css" />
	<%-- <link href="css/CalendarExtender.css" rel="stylesheet" type="text/css" /> %-->

	<script type="text/javascript">
	    /*	function clearField(obj)
	    {
	    if (obj.defaultValue==obj.value) obj.value = "";
	    }*/
	</script>

<script type="text/javascript">
	function ShowHideAdditionalHoursDDL() {
		// Does Participant Need Additional Hours?
		var radAdditionalHours_0 = document.getElementById("radAdditionalHours_0");  //  "Yes"
		var radAdditionalHours_1 = document.getElementById("radAdditionalHours_1");  //  "No"
		// If "Yes":
		if (radAdditionalHours_0.checked) {
			document.getElementById("lblSlot2").style.visibility = 'visible';
			document.getElementById("ddlWorkSlot2").style.visibility = 'visible';
		}
		// If "No":
		if (radAdditionalHours_1.checked) {
			document.getElementById("lblSlot2").style.visibility = 'hidden';
			document.getElementById("ddlWorkSlot2").style.visibility = 'hidden';
		}
	}
	function init() {
		document.getElementById("lblSlot2").style.visibility = 'hidden';
		document.getElementById("ddlWorkSlot2").style.visibility = 'hidden';
	}
	window.onload=init;
</script>

<script type="text/javascript">
	function ShowJobDetails() {
		document.getElementById("btnHideJobDetails").style.visibility = 'visible';
		document.getElementById("dvJobDetails").style.visibility = 'visible';
	}
</script>

	<%-- 
20090629 I got an error on the document.f.txtFirstName.focus() line so I commented the JScript and the <Body> where it's used.
<script type="text/javascript">
	<!--
    function sf()
    {
        document.f.txtFirstName.focus();
	}
	-->
</script>
--%>

    <script type="text/javascript" language="javascript">
        function num() {
            if ((event.keyCode >= 48 && event.keyCode <= 57) || (event.keyCode == 46)) return true;
            else
                return false;
        }
    </script>

</head>
<%--<body onload="sf()">--%>
<body>
	<%--
<body onkeydown="if (window.event.keyCode == 13) 
{
    event.returnValue=false; 
    event.cancel = true;
}" style="text-align: center">
--%>
	<form id="form1" method="post" runat="server" name="f" visible="True">
	<%--onSubmit="submitonce(this)">  action part of: Submit Once form validation JavaScript in Head. --%>
	<%--<asp:ScriptManager ID="SM1" runat="server" />--%>
	<cc1:toolkitscriptmanager runat="server"></cc1:toolkitscriptmanager>
	<div class="container">
		<div>
			<table border="0">
				<tr>
					<td>
						<div>

							<script type="text/javascript" language="javascript">
							    if (AC_FL_RunContent == 0) {
							        alert("This page requires AC_RunActiveContent.js.");
							    } else {
							        AC_FL_RunContent(
			'codebase', 'http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0',
			'width', '255',
			'height', '99',
			'src', 'WF1_SmallV_04',
			'quality', 'high',
			'pluginspage', 'http://www.macromedia.com/go/getflashplayer',
			'align', 'middle',
			'play', 'true',
			'loop', 'true',
			'scale', 'showall',
			'wmode', 'window',
			'devicefont', 'false',
			'id', 'WF1_SmallV_04',
			'bgcolor', '#ffffff',
			'name', 'WF1_SmallV_04',
			'menu', 'true',
			'allowFullScreen', 'false',
			'allowScriptAccess', 'sameDomain',
			'movie', 'WF1_SmallV_04',
			'salign', ''
			); //end AC code
							    }
							</script>

							<noscript>
								<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0"
									width="255" height="99" id="WF1_SmallV_04" align="middle">
									<param name="allowScriptAccess" value="sameDomain" />
									<param name="allowFullScreen" value="false" />
									<param name="movie" value="WF1_SmallV_04.swf" />
									<param name="quality" value="high" />
									<param name="bgcolor" value="#ffffff" />
									<embed src="WF1_SmallV_04.swf" quality="high" bgcolor="#ffffff" width="255" height="99" name="WF1_SmallV_04"
										align="middle" allowscriptaccess="sameDomain" allowfullscreen="false" type="application/x-shockwave-flash"
										pluginspage="http://www.macromedia.com/go/getflashplayer" />
								</object>
							</noscript>

<%--<script type="text/javascript" language="javascript">
	function disable_enable() {
		if (document.getElementById("<%= lblCheckRFA.ClientID %>").innerHTML.indexOf("Okay") > 0)
			document.getElementById('<%= btnSubmit.ClientID %>').disabled = false;
		else
			document.getElementById('<%= btnSubmit.ClientID %>').disabled = true;
	} 

</script>--%>

<script type="text/javascript" language="javascript">
	function disable_enable() {
		var myTextField = document.getElementById('lblCheckRFA');
		if (myTextField.innerHTML.indexOf("Okay") >= 0)
			document.getElementById('btnSubmit').disabled = false;
		else
			document.getElementById('btnSubmit').disabled = true;
	} 
</script>
						</div>
					</td>
					<td>
						<div>
							<h1 style="margin-left: 1px;">
								Welcome to the WorkForce One
								<br />
								<i>Community Service / Work Experience Program</i>
							</h1>
						</div>
					</td>
					<td>
						&nbsp;
					</td>
					<td>
						&nbsp;
					</td>
					<td width="100px">
						&nbsp;
					</td>
				</tr>
			</table>
		</div>
		<hr />
		<br />
		<div style="width: 90%; padding: 10px; margin-left: auto; margin-right: auto; text-align: center;">
			<span style="font-size: x-large; color: #006D75;">
			    Client Information<br />
				Please complete all fields as accurately as possible.
			</span>
		</div>
		<div class="theForm">
			<div class="InfoDivs">
				<table id="tblPersonal" width="90%">
					<tr>
						<td style="text-align: left; padding-left: 225px; width: 85%;" colspan="4">
							<asp:ValidationSummary ID="ValidationSummary1" runat="server" HeaderText='Please make the corrections below and click "Submit" again.'
								Width="511px" />
						</td>
					</tr>
					<tr>
						<td colspan="4">
							<h2>Personal Information:</h2>
						</td>
					</tr>
					<tr>
						<td>
							<label for="FirstName">First Name:</label>
						</td>
						<td style="text-align: left;" nowrap="nowrap" width="10%">
							<asp:TextBox onkeydown="if(event.keyCode == 13) return false;" ID="FirstName" runat="server" TabIndex="10"
								MaxLength="25" Width="140px" onfocus="this.style.background='yellow'" onblur="this.style.background='lightyellow'" />
							<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="FirstName"
								ErrorMessage="First Name is Required">*</asp:RequiredFieldValidator>
							<label for="MI" style="margin-left:1em;">MI:</label>
							<asp:TextBox onkeydown="if(event.keyCode == 13) return false;" ID="MI" 
                                runat="server" Width="15px" MaxLength="1"
								TabIndex="20" onfocus="this.style.background='yellow'" 
                                onblur="this.style.background='lightyellow'" />
						</td>
						<td nowrap="nowrap" width="10%">
							&nbsp;<label for="LastName">Last Name:</label></td>
						<td style="text-align: left">
							<label for="LastName">
							<asp:TextBox onkeydown="if(event.keyCode == 13) return false;" ID="LastName" runat="server" TabIndex="30"
								MaxLength="25" Width="110px" onfocus="this.style.background='yellow'" onblur="this.style.background='lightyellow'" />
							</label>
							<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="LastName"
								ErrorMessage="Last Name is Required">*</asp:RequiredFieldValidator>
							&nbsp;
							<label for="Suf">Suffix (Jr, Sr, III):
							<asp:TextBox onkeydown="if(event.keyCode == 13) return false;" ID="Suf" runat="server" MaxLength="3"
								Width="20px" TabIndex="40" onfocus="this.style.background='yellow'" onblur="this.style.background='lightyellow'" />
							</label>
						</td>
					</tr>
					<tr>
						<td>
							<label for="SSN3">Last 4 of SSN:
<%--                        <asp:TextBox onkeydown="if(event.keyCode == 13) return false;" ID="txtSSN1" [dhm200907130621]
                                         runat="server" Width="30px" MaxLength="3" TabIndex="50" 
                                         style="background-color: #FF0000"></asp:TextBox>-
                            <asp:TextBox onkeydown="if(event.keyCode == 13) return false;" ID="txtSSN2" 
                                         runat="server" Width="20px" MaxLength="2" TabIndex="60" 
                                         style="background-color: #FF0000"></asp:TextBox>---%>
							</label>
							<%--<asp:TextBox ID="txtSSN" runat="server" Visible="False" Width="3px"></asp:TextBox>[dhm200907130621]--%>
						</td>
						<td style="text-align: left">
							<label for="SSN3">
							<asp:TextBox onkeydown="if(event.keyCode == 13) return false;" ID="SSN3" 
							             runat="server" Width="40px" MaxLength="4" TabIndex="50" 
							             onfocus="this.style.background='yellow'" 
							             onblur="this.style.background='lightyellow'" />
							<asp:RequiredFieldValidator ID="reqSSN" runat="server" ControlToValidate="SSN3" 
							             ErrorMessage="Social Security Number is Required">*</asp:RequiredFieldValidator>
							</label>
							</td>
						<td style="text-align:right;">
							<label for="RFA">RFA#:</label>
						</td>
						<td style="text-align: left">
							<asp:UpdatePanel ID="UPCheckRFA" runat="server" UpdateMode="Conditional">
								<ContentTemplate>
							<label for="RFA"><asp:TextBox onkeydown="if(event.keyCode == 13) return false;" ID="RFA" 
							             runat="server" Width="110px" MaxLength="12" TabIndex="60" 
							             onfocus="this.style.background='yellow'" 
							             onblur="this.style.background='lightyellow'" /><cc1:MaskedEditExtender ID="RFA_MaskedEditExtender" runat="server" 
																 Enabled="True" Mask="9999999999L" 
																 TargetControlID="RFA">
										</cc1:MaskedEditExtender>
										<asp:RequiredFieldValidator ID="reqRFA" runat="server" ControlToValidate="RFA" 
							             ErrorMessage="RFA Number is Required">*</asp:RequiredFieldValidator><asp:RegularExpressionValidator 
										ID="regRFA" runat="server" ControlToValidate="RFA" ErrorMessage="Enter a valid RFA Number" 
										SetFocusOnError="True" ValidationExpression="[0-9]{10}B?" Enabled="False">*</asp:RegularExpressionValidator>&nbsp; </label>
							<asp:Button ID="btnCheckRFA" runat="server" Text="Check RFA#" Enabled="True" CausesValidation="False"  OnClientClick="setTimeout('disable_enable()',1250);" />&nbsp;
							<%--<asp:Button ID="btnCheckRFA" runat="server" Text="Check RFA#" Enabled="True" CausesValidation="False"  OnClientClick="disable_enable();" />&nbsp;--%>

							<asp:Label ID="lblCheckRFA" runat="server" Width="240px"></asp:Label>
								</ContentTemplate>
							</asp:UpdatePanel>
							</td>
					</tr>
				</table>
			</div>
			<br />
			<div class="InfoDivs">
				<table id="tblContact" title="Contact">
					<tr>
						<td colspan="4" style="text-align: left;">
							<h2>Address/Contact Information:</h2>
						</td>
					</tr>
					<tr>
						<td>
							<label for="Address">Address:</label>
						</td>
						<td colspan="3" style="text-align:left;">
							<asp:TextBox onkeydown="if(event.keyCode == 13) return false;" onChange="javascript:this.value=this.value.toUpperCase();"
								ID="Address" runat="server" MaxLength="50" TabIndex="140" Width="253px" Wrap="False" onfocus="this.style.background='yellow'" onblur="this.style.background='lightyellow'" ></asp:TextBox>
							<asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="Address" ErrorMessage="Address is Required">*</asp:RequiredFieldValidator>
						</td>
					</tr>
					<tr>
						<td>
							<label for="ddlCity">City:</label>
						</td>
						<td style="text-align: left; vertical-align: bottom;" colspan="3">
							<asp:DropDownList ID="ddlCity" runat="server" DataSourceID="SqlDataSource1" DataTextField="CityName"
								DataValueField="CityName" TabIndex="150" AppendDataBoundItems="True">
								<asp:ListItem Text="Select One..." Value="0"></asp:ListItem>
							</asp:DropDownList>
							<asp:CompareValidator ID="CompareValidator4" runat="server" ControlToValidate="ddlCity" ErrorMessage="City is Required"
								Operator="NotEqual" ValueToCompare="0">*</asp:CompareValidator>&nbsp; &nbsp; &nbsp;
							<label for="State">State:
							<asp:TextBox ID="State" runat="server" onkeydown="if(event.keyCode == 13) return false;" 
								Width="25px" MaxLength="2" TabIndex="160" onfocus="this.style.background='yellow'" onblur="this.style.background='lightyellow'" >FL</asp:TextBox>&nbsp; &nbsp;
                            </label>								
							<label for="ddlZipCode">Zip:
							<asp:DropDownList ID="ddlZipCode" runat="server" DataSourceID="SqlDataSource2" 
							                  DataTextField="ZipCode" DataValueField="ZipCode" TabIndex="170" AppendDataBoundItems="True">
								<asp:ListItem Value="0">Select One...</asp:ListItem>
							</asp:DropDownList>
							</label>
							<asp:CompareValidator ID="CompareValidator3" runat="server" ControlToValidate="ddlZipCode" ErrorMessage="Zip is Required"
								Operator="NotEqual" ValueToCompare='0'>*</asp:CompareValidator>
							<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:CSPConnectionString1 %>"
								               SelectCommand="SELECT [CityName] FROM [tblCities] ORDER BY CityName"></asp:SqlDataSource>
							<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:CSPConnectionString1 %>"
								               SelectCommand="SELECT [ZipID], [ZipCode] FROM [tblZips] ORDER BY [ZipID]"></asp:SqlDataSource>
						</td>
					</tr>
					<tr>
						<td nowrap="nowrap" width="10%">
							<label for="HomePhone">Home Telephone Number:</label>
						</td>
						<td style="text-align: left" width="10%">
							<asp:TextBox ID="HomePhone" runat="server" MaxLength="50" TabIndex="180" onKeyDown="javascript:return dFilter (event.keyCode, this, '(###) ###-####');" onfocus="this.style.background='yellow'" onblur="this.style.background='lightyellow'" ></asp:TextBox>
							<asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" ControlToValidate="HomePhone"
								ErrorMessage="Home Telephone Number is Required.  Enter a number where participant may be contacted. ">*</asp:RequiredFieldValidator>
						</td>
						<td nowrap="nowrap" width="10%">
							<asp:Label ID="Label42" runat="server">Cell Phone Number:</asp:Label>
						</td>
						<td style="text-align: left">
							<asp:TextBox ID="CellPhone" runat="server" TabIndex="190" onKeyDown="javascript:return dFilter (event.keyCode, this, '(###) ###-####');" onfocus="this.style.background='yellow'" onblur="this.style.background='lightyellow'" ></asp:TextBox>
						</td>
					</tr>
					<tr>
						<td>
							<asp:Label ID="Label14" runat="server" Text="Other Phone Number"></asp:Label>
						</td>
						<td style="text-align: left">
							<asp:TextBox ID="OtherPhone" runat="server" TabIndex="200" onKeyDown="javascript:return dFilter (event.keyCode, this, '(###) ###-####');" onfocus="this.style.background='yellow'" onblur="this.style.background='lightyellow'" ></asp:TextBox>
						</td>
						<td nowrap="nowrap">
							<asp:Label ID="Label15" runat="server" Text="Email Address:"></asp:Label>
						</td>
						<td style="text-align: left">
							<asp:TextBox onkeydown="if(event.keyCode == 13) return false;" ID="EmailAddress" runat="server" MaxLength="40"
								TabIndex="210" onfocus="this.style.background='yellow'" onblur="this.style.background='lightyellow'" ></asp:TextBox>
							<asp:RegularExpressionValidator ID="RegularExpressionValidator6" runat="server" ControlToValidate="EmailAddress"
								ErrorMessage="A Valid Email Address is Required" ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*">*</asp:RegularExpressionValidator>
						</td>
					</tr>
					<tr>
						<td colspan="2">
							&nbsp;
						</td>
						<td nowrap="nowrap">
							<asp:Label ID="Label16" runat="server" Text="Verify Email Address:"></asp:Label>
						</td>
						<td style="text-align: left">
							<asp:TextBox onkeydown="if(event.keyCode == 13) return false;" ID="VerifyEmailAddress" runat="server"
								MaxLength="40" TabIndex="220" onfocus="this.style.background='yellow'" onblur="this.style.background='lightyellow'" ></asp:TextBox>
							<asp:CompareValidator ID="CompareValidator2" runat="server" ControlToCompare="EmailAddress" ControlToValidate="VerifyEmailAddress"
								ErrorMessage="Email Addresses don't match">*</asp:CompareValidator>
						</td>
					</tr>
				</table>
			</div>
			<br />
			<div class="InfoDivs">
				<table id="tblCaseManagerContact" title="Case Manager Contact">
					<tr>
						<td nowrap="nowrap" width="10%">
							<label for="ddlCenter">Center Where Client is Assigned:</label>
						</td>
						<td style="text-align:left;" width="10%">
							<asp:DropDownList ID="ddlCenter" runat="server" TabIndex="229">
                                     	  <asp:ListItem Value="0">Select One...</asp:ListItem>
    									  <asp:ListItem Value="North" Text="North" />
    									  <asp:ListItem Value="Central" Text="Central" />
    									  <asp:ListItem Value="South" Text="South" />
							</asp:DropDownList>
							<asp:CompareValidator ID="valCenter" runat="server" ControlToValidate="ddlCenter" ErrorMessage="Center Where Client is Assigned is Required"
								Operator="NotEqual" ValueToCompare="0">*</asp:CompareValidator>
						</td>
						<td>
							&nbsp;
						</td>
						<td style="text-align:left;">
							&nbsp;
						</td>
					</tr>
					<tr>
						<td>
							<label for="CaseManagerName">Case Manager:</label>
						</td>
						<td style=" text-align:left; ">
							<asp:TextBox onkeydown="if(event.keyCode == 13) return false;" ID="CaseManagerName" runat="server" TabIndex="230" onfocus="this.style.background='yellow'" onblur="this.style.background='lightyellow'" />
							    <asp:RequiredFieldValidator ID="reqCaseManagerName" runat="server" 
								ControlToValidate="CaseManagerName" ErrorMessage="Case Manager's Name Required">*</asp:RequiredFieldValidator>
						</td>
						<td nowrap="nowrap" width="10%">
							Case Manager&#39;s Contact #:
						</td>
						<td style=" text-align:left; ">
							<asp:TextBox ID="CaseManagerPhone" runat="server" Width="110px" TabIndex="240" onKeyDown="javascript:return dFilter (event.keyCode, this, '(###) ###-####');"
								         onfocus="this.style.background='yellow'" onblur="this.style.background='lightyellow'" ></asp:TextBox>
							    <asp:RequiredFieldValidator ID="RequiredFieldValidator9" runat="server" ControlToValidate="CaseManagerPhone"
								ErrorMessage="Case Manager's Contact # Required">*</asp:RequiredFieldValidator>
						&nbsp; Ext:
							<asp:TextBox ID="CaseManagerExt" runat="server" Width="60px" TabIndex="240" onKeyDown="javascript:return dFilter (event.keyCode, this, '######');"
								         onfocus="this.style.background='yellow'" onblur="this.style.background='lightyellow'" ></asp:TextBox>
						</td>
					</tr>
					<tr>
						<td>
							<label for="ddlJobDeveloper">Job Developer Assigned:</label>
						</td>
						<td style=" text-align:left;">
							<asp:DropDownList ID="ddlJobDeveloper" runat="server" TabIndex="245" >
								<asp:ListItem Value="0">Select One...</asp:ListItem>
								<asp:ListItem>Bruce Aronowitz</asp:ListItem>
								<asp:ListItem>Andrea Godfrey</asp:ListItem>
								<asp:ListItem>Yvette Thomas</asp:ListItem>
							</asp:DropDownList>
							<asp:CompareValidator ID="valJobDeveloper" runat="server" ControlToValidate="ddlJobDeveloper"
								ErrorMessage="Job Developer's Name Required" ValueToCompare="0" Operator="NotEqual">*</asp:CompareValidator>
						</td>
						<td>
							&nbsp;</td>
						<td style=" text-align:left;">
							&nbsp;</td>
					</tr>
				</table>
			</div>
			<br />
			<div class="InfoDivs">
				<table id="tblWorkInfo" title="Work Information" width="90%">
					<tr>
						<td colspan="2" style="text-align: left;">
							<h2>Work Information:</h2>
						</td>
					</tr>
					<tr>
						<td>
							<asp:Label ID="Label56" runat="server">Worksite City preference</asp:Label>
						</td>
						<td style="text-align: left;">
							<asp:DropDownList ID="ddlWorksiteCityPreference" runat="server" DataSourceID="SqlDataSource3" DataTextField="CityName"
								DataValueField="CityName" TabIndex="510" ></asp:DropDownList>
							<asp:CompareValidator ID="CompareValidator14" runat="server" ControlToValidate="ddlWorksiteCityPreference"
								ErrorMessage="Worksite location preference is Required" Operator="NotEqual" ValueToCompare="0">*</asp:CompareValidator>
							<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:CSPConnectionString1 %>" 
								SelectCommand="SELECT [CityName] FROM [tblCities] ORDER BY [CityName]"></asp:SqlDataSource>
						</td>
					</tr>
					<tr>
						<td>
							<asp:Label ID="Label10" runat="server" Text="How do you plan to get to your assignment?"></asp:Label>&nbsp;
						</td>
						<td style="text-align: left">
							<asp:DropDownList ID="ddlTransportation" runat="server" TabIndex="520" >
								<asp:ListItem Value="0">Select One...</asp:ListItem>
								<asp:ListItem>Car</asp:ListItem>
								<asp:ListItem>Bus</asp:ListItem>
								<asp:ListItem>Other</asp:ListItem>
								<asp:ListItem>I don't know</asp:ListItem>
							</asp:DropDownList>
							<asp:CompareValidator ID="valTransportation" runat="server" ControlToValidate="ddlTransportation" ErrorMessage="How do you plan to get to work is Required"
								Operator="NotEqual" ValueToCompare="0">*</asp:CompareValidator>
						</td>
					</tr>
					<tr>
						<td nowrap="nowrap">
							<asp:Label ID="Label59" runat="server">What hours are you able to work?</asp:Label>
						</td>
						<td style="text-align: left; white-space:nowrap;">
            Start Time:
            <asp:DropDownList ID="ddlStartTime" runat="server" TabIndex="530" >
                <asp:ListItem Text="0:00 AM" Value="0:00 AM"></asp:ListItem>
                <asp:ListItem Text="0:30 AM"></asp:ListItem>
                <asp:ListItem Text="1:00 AM"></asp:ListItem>
                <asp:ListItem Text="1:30 AM"></asp:ListItem>
                <asp:ListItem Text="2:00 AM"></asp:ListItem>
                <asp:ListItem Text="2:30 AM"></asp:ListItem>
                <asp:ListItem Text="3:00 AM"></asp:ListItem>
                <asp:ListItem Text="3:30 AM"></asp:ListItem>
                <asp:ListItem Text="4:00 AM"></asp:ListItem>
                <asp:ListItem Text="4:30 AM"></asp:ListItem>
                <asp:ListItem Text="5:00 AM"></asp:ListItem>
                <asp:ListItem Text="5:30 AM"></asp:ListItem>
                <asp:ListItem Text="6:00 AM"></asp:ListItem>
                <asp:ListItem Text="6:30 AM"></asp:ListItem>
                <asp:ListItem Text="7:00 AM"></asp:ListItem>
                <asp:ListItem Text="7:30 AM"></asp:ListItem>
                <asp:ListItem Text="8:00 AM" Selected="True" Value="8:00 AM"></asp:ListItem>
                <asp:ListItem Text="8:30 AM"></asp:ListItem>
                <asp:ListItem Text="9:00 AM"></asp:ListItem>
                <asp:ListItem Text="9:30 AM"></asp:ListItem>
                <asp:ListItem Text="10:00 AM"></asp:ListItem>
                <asp:ListItem Text="10:30 AM"></asp:ListItem>
                <asp:ListItem Text="11:00 AM"></asp:ListItem>
                <asp:ListItem Text="11:30 AM"></asp:ListItem>
                <asp:ListItem Text="12:00 PM"></asp:ListItem>
                <asp:ListItem Text="12:30 PM"></asp:ListItem>
                <asp:ListItem Text="1:00 PM"></asp:ListItem>
                <asp:ListItem Text="1:30 PM"></asp:ListItem>
                <asp:ListItem Text="2:00 PM"></asp:ListItem>
                <asp:ListItem Text="2:30 PM"></asp:ListItem>
                <asp:ListItem Text="3:00 PM"></asp:ListItem>
                <asp:ListItem Text="3:30 PM"></asp:ListItem>
                <asp:ListItem Text="4:00 PM"></asp:ListItem>
                <asp:ListItem Text="4:30 PM"></asp:ListItem>
                <asp:ListItem Text="5:00 PM"></asp:ListItem>
                <asp:ListItem Text="5:30 PM"></asp:ListItem>
                <asp:ListItem Text="6:00 PM"></asp:ListItem>
                <asp:ListItem Text="6:30 PM"></asp:ListItem>
                <asp:ListItem Text="7:00 PM"></asp:ListItem>
                <asp:ListItem Text="7:30 PM"></asp:ListItem>
                <asp:ListItem Text="8:00 PM"></asp:ListItem>
                <asp:ListItem Text="8:30 PM"></asp:ListItem>
                <asp:ListItem Text="9:00 PM"></asp:ListItem>
                <asp:ListItem Text="9:30 PM"></asp:ListItem>
                <asp:ListItem Text="10:00 PM"></asp:ListItem>
                <asp:ListItem Text="10:30 PM"></asp:ListItem>
                <asp:ListItem Text="11:00 PM"></asp:ListItem>
                <asp:ListItem Text="11:30 PM"></asp:ListItem>
                <asp:ListItem Text="11:59 PM"></asp:ListItem>
            </asp:DropDownList>&nbsp;&nbsp;&nbsp;&nbsp;
            End Time:&nbsp;
            <asp:DropDownList ID="ddlEndTime" runat="server" TabIndex="531" >
                <asp:ListItem Text="0:00 AM"></asp:ListItem>
                <asp:ListItem Text="0:30 AM"></asp:ListItem>
                <asp:ListItem Text="1:00 AM" Value="1:00 AM"></asp:ListItem>
                <asp:ListItem Text="1:30 AM"></asp:ListItem>
                <asp:ListItem Text="2:00 AM"></asp:ListItem>
                <asp:ListItem Text="2:30 AM"></asp:ListItem>
                <asp:ListItem Text="3:00 AM"></asp:ListItem>
                <asp:ListItem Text="3:30 AM"></asp:ListItem>
                <asp:ListItem Text="4:00 AM"></asp:ListItem>
                <asp:ListItem Text="4:30 AM"></asp:ListItem>
                <asp:ListItem Text="5:00 AM"></asp:ListItem>
                <asp:ListItem Text="5:30 AM"></asp:ListItem>
                <asp:ListItem Text="6:00 AM"></asp:ListItem>
                <asp:ListItem Text="6:30 AM"></asp:ListItem>
                <asp:ListItem Text="7:00 AM"></asp:ListItem>
                <asp:ListItem Text="7:30 AM"></asp:ListItem>
                <asp:ListItem Text="8:00 AM"></asp:ListItem>
                <asp:ListItem Text="8:30 AM"></asp:ListItem>
                <asp:ListItem Text="9:00 AM"></asp:ListItem>
                <asp:ListItem Text="9:30 AM"></asp:ListItem>
                <asp:ListItem Text="10:00 AM"></asp:ListItem>
                <asp:ListItem Text="10:30 AM"></asp:ListItem>
                <asp:ListItem Text="11:00 AM"></asp:ListItem>
                <asp:ListItem Text="11:30 AM"></asp:ListItem>
                <asp:ListItem Text="12:00 PM" Selected="True" Value="12:00 PM"></asp:ListItem>
                <asp:ListItem Text="12:30 PM"></asp:ListItem>
                <asp:ListItem Text="1:00 PM"></asp:ListItem>
                <asp:ListItem Text="1:30 PM"></asp:ListItem>
                <asp:ListItem Text="2:00 PM"></asp:ListItem>
                <asp:ListItem Text="2:30 PM"></asp:ListItem>
                <asp:ListItem Text="3:00 PM"></asp:ListItem>
                <asp:ListItem Text="3:30 PM"></asp:ListItem>
                <asp:ListItem Text="4:00 PM"></asp:ListItem>
                <asp:ListItem Text="4:30 PM"></asp:ListItem>
                <asp:ListItem Text="5:00 PM"></asp:ListItem>
                <asp:ListItem Text="5:30 PM"></asp:ListItem>
                <asp:ListItem Text="6:00 PM"></asp:ListItem>
                <asp:ListItem Text="6:30 PM"></asp:ListItem>
                <asp:ListItem Text="7:00 PM"></asp:ListItem>
                <asp:ListItem Text="7:30 PM"></asp:ListItem>
                <asp:ListItem Text="8:00 PM"></asp:ListItem>
                <asp:ListItem Text="8:30 PM"></asp:ListItem>
                <asp:ListItem Text="9:00 PM"></asp:ListItem>
                <asp:ListItem Text="9:30 PM"></asp:ListItem>
                <asp:ListItem Text="10:00 PM"></asp:ListItem>
                <asp:ListItem Text="10:30 PM"></asp:ListItem>
                <asp:ListItem Text="11:00 PM"></asp:ListItem>
                <asp:ListItem Text="11:30 PM"></asp:ListItem>
                <asp:ListItem Text="11:59 PM"></asp:ListItem>
            </asp:DropDownList>
 						</td>
					</tr>
					<tr>
						<td nowrap="nowrap" width="10%">
							<label for="txtOtherLanguages">List any languages other than English you speak:</label>
						</td>
						<td style="text-align: left;">
							<asp:TextBox onkeydown="if(event.keyCode == 13) return false;" ID="txtOtherLanguages" runat="server"
								MaxLength="50" TabIndex="540" onfocus="this.style.background='yellow'" onblur="this.style.background='lightyellow'" ></asp:TextBox>
						</td>
					</tr>
                            <tr>
                                <td style="text-align:right;">
                                    Days Available to work.
                                    Check all that apply:
                                </td>
                                <td style="text-align:left;">&nbsp;&nbsp;
<asp:UpdatePanel ID="UP3" runat="server" UpdateMode="Conditional" RenderMode="Inline">
     <ContentTemplate>
                                    <asp:CheckBox ID="cbMonFri"   name="Check1" Text="M-F"      runat="server" 
                                                  TabIndex="550" AutoPostBack="True" CssClass="blueButton" />
                                    <asp:CheckBox ID="cbMonday"     name="Check1" Text="Mon"     runat="server" 
                                                  TabIndex="551" CssClass="buttonSpace2" AutoPostBack="True" />
                                    <asp:CheckBox ID="cbTuesday"    name="Check1" Text="Tue"    runat="server" 
                                                  TabIndex="552" CssClass="buttonSpace2" AutoPostBack="True" />
                                    <asp:CheckBox ID="cbWednesday"  name="Check1" Text="Wed"  runat="server" 
                                                  TabIndex="553" CssClass="buttonSpace2" AutoPostBack="True" />
                                    <asp:CheckBox ID="cbThursday"   name="Check1" Text="Thur"   runat="server" 
                                                  TabIndex="554" CssClass="buttonSpace2" AutoPostBack="True" />
                                    <asp:CheckBox ID="cbFriday"     name="Check1" Text="Fri"     runat="server" 
                                                  TabIndex="556" CssClass="buttonSpace2" AutoPostBack="True" />
                                    <asp:CheckBox ID="cbSaturday"  name="Check1" Text="Sat"   runat="server" 
                                                  TabIndex="557" CssClass="buttonSpace2 maroonButton" />
                                    <asp:CheckBox ID="cbSunday"    name="Check1" Text="Sun"     runat="server" 
                                                  TabIndex="558" CssClass="buttonSpace2 maroonButton" />
                                    <%-- CheckBox Validation is done in Page_Load Event:  form1.Attributes("onsubmit")... --%>
     </ContentTemplate>
</asp:UpdatePanel>
                                </td>
                            </tr>
					<tr>
						<td nowrap="nowrap">
							<asp:Label ID="Label17" runat="server" Text="What type of work would you prefer:"></asp:Label>
						</td>
						<td style="text-align: left">
<asp:UpdatePanel ID="UPWorkPreference" runat="server" UpdateMode="Conditional" RenderMode="Inline">
     <ContentTemplate>
						
							<asp:DropDownList ID="ddlWorkPreference" runat="server" Width="300px" TabIndex="580" AutoPostBack="True">
                                     	  <asp:ListItem Value="0">Select One...</asp:ListItem>
    									  <asp:ListItem Value="Office - Data Entry" Text="Office - Data Entry" />
    									  <asp:ListItem Value="Office - Receptionist" Text="Office - Receptionist" />
    									  <asp:ListItem Value="Office - Customer Service" Text="Office - Customer Service" />
    									  <asp:ListItem Value="Office - Multi-functional Admin" Text="Office - Multi-functional Admin" />
    									  <asp:ListItem Value="Warehouse" Text="Warehouse" />
    									  <asp:ListItem Value="Childcare" Text="Childcare" />
    									  <asp:ListItem Value="Food Service" Text="Food Service" />
    									  <asp:ListItem Value="Healthcare" Text="Healthcare" />
    									  <asp:ListItem Value="Retail" Text="Retail" />
    									  <asp:ListItem Value="Education" Text="Education" />
    									  <asp:ListItem Value="Other" Text="Other" />
							</asp:DropDownList>
							<asp:CompareValidator ID="CompareValidator12" runat="server" ControlToValidate="ddlWorkPreference" ErrorMessage="What type of work would you prefer is Required"
								Operator="NotEqual" ValueToCompare="0">*</asp:CompareValidator>
							&nbsp;
							<asp:Label ID="lblOtherPreference" runat="server" Text="Specify:" Visible="False"></asp:Label>
							&nbsp;<asp:TextBox ID="txtOtherWorkPref" runat="server" MaxLength="35" Visible="False"></asp:TextBox>
</ContentTemplate>
</asp:UpdatePanel>							
						</td>
					</tr>
					<tr>
						<td colspan="2" style="text-align: left">
							<asp:Label ID="lblSlot1" runat="server" Text="Label">Slot 1 Identification # for Which Client is Being Considered:</asp:Label>
							<asp:Label ID="lblAdditionalHours" runat="server" Text="Label" CssClass="LabelMargin">Does participant need additional hours?</asp:Label>
							<asp:RadioButtonList ID="radAdditionalHours" runat="server"
												 onclick="ShowHideAdditionalHoursDDL()"
												 AutoPostBack="false" 
												 RepeatDirection="Horizontal" 
												 RepeatLayout="Flow">
								<asp:ListItem>Yes</asp:ListItem>
								<asp:ListItem Selected="True">No</asp:ListItem>
							</asp:RadioButtonList>

<%--					<asp:ImageButton id="btnJobDetail" runat="server" CausesValidation="False" 
									 CssClass="LabelMargin" 
									 ImageUrl="images/twitter_logo.png" 
									 AlternateText="Click here for Job Slot Info"
									 onclick="ShowJobDetails()"
									  />--%>
					<img id="btnJobDetail" 
									 class="LabelMargin" 
									 src="images/twitter_logo.png" 
									 alt="Click here for Job Slot Info"
									 onclick="ShowJobDetails()"
									  />

							<br />
<%--							<asp:UpdatePanel ID="upWorkSlot1" runat="server" UpdateMode="Conditional" >
								<ContentTemplate>--%>
							<asp:DropDownList ID="ddlWorkSlot1" runat="server" DataSourceID="SqlDataSource4_Job" DataTextField="WorksiteName"
								DataValueField="keyJobTitleID" AppendDataBoundItems="true" AutoPostBack="True" TabIndex="585" >
								<asp:ListItem Text="Select One..." Value="0"></asp:ListItem>
							</asp:DropDownList>

							<asp:SqlDataSource ID="SqlDataSource4_Job" runat="server" ConnectionString="<%$ ConnectionStrings:CSPConnectionString1 %>"
								SelectCommand="SELECT keyJobTitleID, EmployerName + ', ' + WorksiteCity + ', ' + ' -- ' + JobTitle + ' -- ' + ddlStartTime  + ' to ' + ddlEndTime 
											   AS WorksiteName 
											   FROM JobTitles
											   WHERE (keyApplicantID IS NULL) AND (Active = 1)
											   ORDER BY EmployerName, WorksiteName, WorksiteCity, WorksiteZip, JobTitle">
							</asp:SqlDataSource>
<%--								</ContentTemplate>
							</asp:UpdatePanel>--%>
<%--							
							TODO: Get rid of UpdatePanel if possible.
							TODO: Use Window.Load or OnLoad JavaScript to set label and dropdown list to hidden:
							document.getElementById("lblSlot2").style.visibility = 'hidden'; <-- put in OnLoad
							document.getElementById("ddlWorkSlot2").style.visibility = 'hidden'; <-- Put in OnLoad
							The JavaScript in the radiobutton already works to hide and show the label and dropdown.
--%>							
						</td>
					</tr>
					<tr>
						<td colspan="2" style="text-align: left">
							<asp:Label ID="lblSlot2" runat="server" 
								Text="Slot 2 Identification # for Which Client is Being Considered:" ></asp:Label>
							<br />
							<asp:DropDownList ID="ddlWorkSlot2" runat="server" 
											  DataSourceID="SqlDataSource4_Job2" 
											  DataTextField="WorksiteName"
											  DataValueField="keyJobTitleID" 
											  AppendDataBoundItems="true" 
											  TabIndex="586" >
								<asp:ListItem Value="0">Select One...</asp:ListItem>
							</asp:DropDownList>
							<asp:SqlDataSource ID="SqlDataSource4_Job2" runat="server" ConnectionString="<%$ ConnectionStrings:CSPConnectionString1 %>"
								SelectCommand="SELECT keyJobTitleID, EmployerName + ', ' + WorksiteName + ', ' + WorksiteCity + ', ' + WorksiteZip + ' -- ' + JobTitle + ' -- ' + ddlStartTime + ' to ' + ddlEndTime AS WorksiteName 
											   FROM JobTitles 
											   WHERE (keyApplicantID IS NULL) AND (Active = 1) 
											   ORDER BY EmployerName, WorksiteName, WorksiteCity, WorksiteZip, JobTitle">
							</asp:SqlDataSource>
						</td>
					</tr>
					<tr>
						<td colspan="2" style="text-align:center;">
<%--							<asp:UpdatePanel ID="upJobDetails" runat="server" UpdateMode="Conditional" >
							<Triggers>
								<asp:AsyncPostBackTrigger ControlID="ddlWorkSlot1" EventName="SelectedIndexChanged" />
							</Triggers>
								<ContentTemplate>--%>
							<asp:Button ID="btnHideJobDetails" runat="server" Text="Hide Details" CausesValidation="False" 
								Visible="False" TabIndex="587" />
<div>								
<asp:DetailsView ID="dvJobDetails" runat="server" AutoGenerateRows="False" DataKeyNames="keyJobTitleID" 
								DataSourceID="SqlDataSource_JobDetail" Height="50px" Visible="False" Width="650px" CssClass="detailsview">
								<Fields>
									<asp:BoundField DataField="EmployerName" HeaderText="EmployerName" SortExpression="EmployerName" />
									<asp:BoundField DataField="WorksiteName" HeaderText="WorksiteName" SortExpression="WorksiteName" />
									<asp:BoundField DataField="JobTitle" HeaderText="Job Title" 
										SortExpression="JobTitle" />
									<asp:BoundField DataField="JobDescription" HeaderText="Job Description" 
										SortExpression="JobDescription" />
									<asp:BoundField DataField="txtRequestedSkills" HeaderText="Skills Obtained" 
										SortExpression="txtRequestedSkills" />
									<asp:BoundField DataField="keyJobTitleID" HeaderText="JobTitle ID" InsertVisible="False" 
										ReadOnly="True" SortExpression="keyJobTitleID" />
									<asp:BoundField DataField="keyApplicantID" HeaderText="Applicant ID" 
										SortExpression="keyApplicantID" />
									<asp:TemplateField HeaderText="Hours" SortExpression="ddlStartTime">
										<EditItemTemplate>
											<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("ddlStartTime") %>'></asp:TextBox>
										</EditItemTemplate>
										<InsertItemTemplate>
											<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("ddlStartTime") %>'></asp:TextBox>
										</InsertItemTemplate>
										<ItemTemplate>
											<asp:Label ID="lblStartTime" runat="server" Text='<%# Bind("ddlStartTime") %>'></asp:Label>
											&nbsp; - &nbsp;
											<asp:Label ID="lblEndTime" runat="server" Text='<%# Bind("ddlEndTime") %>'></asp:Label>
										</ItemTemplate>
									</asp:TemplateField>
									<%--<asp:BoundField DataField="ddlEndTime" HeaderText="End Time" SortExpression="ddlEndTime" />--%>
									<asp:TemplateField HeaderText="Work Days" SortExpression="cbWeekdays">
										<EditItemTemplate>
											<asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Bind("cbWeekdays") %>' />
										</EditItemTemplate>
										<InsertItemTemplate>
											<asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Bind("cbWeekdays") %>' />
										</InsertItemTemplate>
										<ItemTemplate>
											<asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Eval("cbWeekdays") %>' Enabled="False" 
												Text="M-F" CssClass="inline" />
											<asp:CheckBox ID="CheckBox2" runat="server" Checked='<%# Eval("cbMonday") %>' Enabled="False" 
												Text="Mon"  CssClass="inline" />
											<asp:CheckBox ID="CheckBox3" runat="server" Checked='<%# Eval("cbTuesday") %>' Enabled="False" 
												Text="Tue"  CssClass="inline" />
											<asp:CheckBox ID="CheckBox4" runat="server" Checked='<%# Eval("cbWednesday") %>' Enabled="False" 
												Text="Wed"  CssClass="inline" />
											<asp:CheckBox ID="CheckBox5" runat="server" Checked='<%# Eval("cbThursday") %>' Enabled="False" 
												Text="Thu"  CssClass="inline" />
											<asp:CheckBox ID="CheckBox6" runat="server" Checked='<%# Eval("cbFriday") %>' Enabled="False" 
												Text="Fri"  CssClass="inline" />
											<asp:CheckBox ID="CheckBox7" runat="server" Checked='<%# Eval("cbSaturdays") %>' Enabled="False" 
												Text="Sat"  CssClass="inline" />
											<asp:CheckBox ID="CheckBox8" runat="server" Checked='<%# Eval("cbSundays") %>' Enabled="False" 
												Text="Sun"  CssClass="inline" />
										</ItemTemplate>
									</asp:TemplateField>
									<%--<asp:CheckBoxField DataField="cbMonday" HeaderText="Monday" SortExpression="cbMonday" />
									<asp:CheckBoxField DataField="cbTuesday" HeaderText="Tuesday" SortExpression="cbTuesday" />
									<asp:CheckBoxField DataField="cbWednesday" HeaderText="Wednesday" SortExpression="cbWednesday" />
									<asp:CheckBoxField DataField="cbThursday" HeaderText="Thursday" SortExpression="cbThursday" />
									<asp:CheckBoxField DataField="cbFriday" HeaderText="Friday" SortExpression="cbFriday" />
									<asp:CheckBoxField DataField="cbSaturdays" HeaderText="Saturday" SortExpression="cbSaturdays" />
									<asp:CheckBoxField DataField="cbSundays" HeaderText="Sunday" SortExpression="cbSundays" />
									--%>
									<asp:TemplateField HeaderText="Training Requirements" SortExpression="cbHSDiploma">
										<EditItemTemplate>
											<asp:CheckBox ID="CheckBox2" runat="server" Checked='<%# Bind("cbHSDiploma") %>' />
										</EditItemTemplate>
										<InsertItemTemplate>
											<asp:CheckBox ID="CheckBox2" runat="server" Checked='<%# Bind("cbHSDiploma") %>' />
										</InsertItemTemplate>
										<ItemTemplate>
											<asp:CheckBox ID="CheckBox9" runat="server" Checked='<%# Eval("cbHSDiploma") %>' Enabled="true" Text="Diploma" />
											<asp:CheckBox ID="CheckBox12" runat="server" Checked='<%# Eval("cbVocationalTraining") %>' Enabled="true" Text="Voc" />
											<asp:CheckBox ID="CheckBox13" runat="server" Checked='<%# Eval("cbCollegeDegree") %>' Enabled="true" Text="College" />
											<asp:CheckBox ID="CheckBox14" runat="server" Checked='<%# Eval("cbNoEdRequirement") %>' Enabled="true" Text="No Training" />
										</ItemTemplate>
									</asp:TemplateField>
<%--									<asp:CheckBoxField DataField="cbVocationalTraining" HeaderText="Vocational Training" SortExpression="cbVocationalTraining" />
									<asp:CheckBoxField DataField="cbCollegeDegree" HeaderText="College Degree" SortExpression="cbCollegeDegree" />
									<asp:CheckBoxField DataField="cbNoEdRequirement" HeaderText="No Ed Requirement" SortExpression="cbNoEdRequirement" />
--%>									<asp:TemplateField HeaderText="Computer OS" SortExpression="cbWindows">
										<EditItemTemplate>
											<asp:CheckBox ID="CheckBox3" runat="server" Checked='<%# Bind("cbWindows") %>' />
										</EditItemTemplate>
										<InsertItemTemplate>
											<asp:CheckBox ID="CheckBox3" runat="server" Checked='<%# Bind("cbWindows") %>' />
										</InsertItemTemplate>
										<ItemTemplate>
											<asp:CheckBox ID="CheckBox10" runat="server" Checked='<%# Bind("cbWindows") %>' Enabled="true" Text="Windows" />
											<asp:CheckBox ID="CheckBox15" runat="server" Checked='<%# Bind("cbMAC") %>' Enabled="true" Text="Mac" />
											<asp:CheckBox ID="CheckBox16" runat="server" Checked='<%# Bind("cbLinux") %>' Enabled="true" Text="Linux" />
											<asp:CheckBox ID="CheckBox17" runat="server" Checked='<%# Bind("cbNoOSRequirement") %>' Enabled="true" Text="None" />
										</ItemTemplate>
									</asp:TemplateField>
<%--									<asp:CheckBoxField DataField="cbMAC" HeaderText="MAC" SortExpression="cbMAC" />
									<asp:CheckBoxField DataField="cbLinux" HeaderText="Linux" SortExpression="cbLinux" />
									<asp:CheckBoxField DataField="cbNoOSRequirement" HeaderText="No OS Requirement" SortExpression="cbNoOSRequirement" />
--%>									<asp:TemplateField HeaderText="Software Proficiency Requirement" SortExpression="cbMSWord">
										<EditItemTemplate>
											<asp:CheckBox ID="CheckBox4" runat="server" Checked='<%# Bind("cbMSWord") %>' />
										</EditItemTemplate>
										<InsertItemTemplate>
											<asp:CheckBox ID="CheckBox4" runat="server" Checked='<%# Bind("cbMSWord") %>' />
										</InsertItemTemplate>
										<ItemTemplate>
											<asp:CheckBox ID="CheckBox11" runat="server" Checked='<%# Eval("cbMSWord") %>' Enabled="true" Text="MS Word" />
											<asp:CheckBox ID="CheckBox18" runat="server" Checked='<%# Eval("cbMSExcel") %>' Enabled="true" Text="MS Excel" />
											<asp:CheckBox ID="CheckBox19" runat="server" Checked='<%# Eval("cbMSPowerPoint") %>' Enabled="true" Text="MS PowerPoint" />
											<asp:CheckBox ID="CheckBox20" runat="server" Checked='<%# Eval("cbMSAccess") %>' Enabled="true" Text="MS Access" />
											<asp:CheckBox ID="CheckBox21" runat="server" Checked='<%# Eval("cbMSPublisher") %>' Enabled="true" Text="MS Publisher" />
											<asp:CheckBox ID="CheckBox22" runat="server" Checked='<%# Eval("cbNoSoftwareRequirement") %>' Enabled="true" Text="None" />
											<asp:label ID="txtOtherSoftware" runat="server" text='<%# Eval("txtOtherSoftware") %>' Enabled="true"  />
										</ItemTemplate>
									</asp:TemplateField>
<%--									<asp:CheckBoxField DataField="cbMSExcel" HeaderText="MS Excel" SortExpression="cbMSExcel" />
									<asp:CheckBoxField DataField="cbMSPowerPoint" HeaderText="MS PowerPoint" SortExpression="cbMSPowerPoint" />
									<asp:CheckBoxField DataField="cbMSAccess" HeaderText="MS Access" SortExpression="cbMSAccess" />
									<asp:CheckBoxField DataField="cbMSPublisher" HeaderText="MS Publisher" SortExpression="cbMSPublisher" />
									<asp:CheckBoxField DataField="cbNoSoftwareRequirement" HeaderText="No Software Requirement" SortExpression="cbNoSoftwareRequirement" Visible="False" />
									<asp:BoundField DataField="txtOtherSoftware" HeaderText="Other Software" SortExpression="txtOtherSoftware" />
--%>								<asp:BoundField DataField="txtTypeWPM" HeaderText="Type WPM" SortExpression="txtTypeWPM" />
									<asp:BoundField DataField="txtRequirementsComments" HeaderText="Comments" SortExpression="txtRequirementsComments" />
									<asp:BoundField DataField="ddlBackgroundCheck" HeaderText="Background Check" SortExpression="ddlBackgroundCheck" />
									<asp:BoundField DataField="radAcceptCriminalBG" HeaderText="Accept Criminal BG" SortExpression="radAcceptCriminalBG" />
									<asp:CheckBoxField DataField="cbFingerprinting" HeaderText="Finger printing" SortExpression="cbFingerprinting" />
									<asp:CheckBoxField DataField="cbDrugScreening" HeaderText="Drug Screening" SortExpression="cbDrugScreening" />
									<asp:CheckBoxField DataField="cbBilingual" HeaderText="Bilingual" SortExpression="cbBilingual" />
									<asp:CheckBoxField DataField="cbEnglishSpanish" HeaderText="English/Spanish" SortExpression="cbEnglishSpanish" />
									<asp:CheckBoxField DataField="cbEnglishCreole" HeaderText="English/Creole" SortExpression="cbEnglishCreole" />
									<asp:CheckBoxField DataField="cbMedicalTesting" HeaderText="Medical Testing" SortExpression="cbMedicalTesting" />
									<asp:CheckBoxField DataField="cbPrePlacementOrientation" HeaderText="Pre Placement Orientation" SortExpression="cbPrePlacementOrientation" />
									<asp:BoundField DataField="radPotentialEmployment" HeaderText="Potential Employment" SortExpression="radPotentialEmployment" />
									<asp:BoundField DataField="radInterviewCandidate" HeaderText="Interview Candidate" SortExpression="radInterviewCandidate" />
									<asp:BoundField DataField="ApplicationDatePosition" HeaderText="Application Date" SortExpression="ApplicationDatePosition" />
									<asp:BoundField DataField="WorksiteCity" HeaderText="Worksite City" SortExpression="WorksiteCity" />
									<asp:BoundField DataField="WorksiteZip" HeaderText="Worksite Zip" SortExpression="WorksiteZip" />
									<asp:BoundField DataField="WorkersComp" HeaderText="Workers Comp" SortExpression="WorkersComp" />
								</Fields>
							</asp:DetailsView>
</div>							
							<asp:SqlDataSource ID="SqlDataSource_JobDetail" runat="server" 
								ConnectionString="<%$ ConnectionStrings:CSPConnectionString1 %>" 
								DeleteCommand="DELETE FROM [JobTitles] WHERE [keyJobTitleID] = @keyJobTitleID" 
								InsertCommand="INSERT INTO [JobTitles] ([keyWorksiteID], [keyEmployerID], [JobTitle], [PositionsTaken], [PositionsAvailable], [keyApplicantID], [ddlStartTime], [ddlEndTime], [cbWeekdays], [cbMonday], [cbTuesday], [cbWednesday], [cbThursday], [cbFriday], [cbSaturdays], [cbSundays], [cbHSDiploma], [cbVocationalTraining], [cbCollegeDegree], [cbNoEdRequirement], [cbWindows], [cbMAC], [cbLinux], [cbNoOSRequirement], [cbMSWord], [cbMSExcel], [cbMSPowerPoint], [cbMSAccess], [cbMSPublisher], [cbOtherSoftware], [txtOtherSoftware], [cbNoSoftwareRequirement], [txtTypeWPM], [txtRequirementsComments], [ddlBackgroundCheck], [radAcceptCriminalBG], [cbFingerprinting], [cbDrugScreening], [cbBilingual], [cbEnglishSpanish], [cbEnglishCreole], [cbMedicalTesting], [cbPrePlacementOrientation], [JobDescription], [radPotentialEmployment], [radInterviewCandidate], [txtRequestedSkills], [ApplicationDatePosition], [EmployerName], [WorksiteName], [WorksiteCity], [WorksiteZip], [WorkersComp]) VALUES (@keyWorksiteID, @keyEmployerID, @JobTitle, @PositionsTaken, @PositionsAvailable, @keyApplicantID, @ddlStartTime, @ddlEndTime, @cbWeekdays, @cbMonday, @cbTuesday, @cbWednesday, @cbThursday, @cbFriday, @cbSaturdays, @cbSundays, @cbHSDiploma, @cbVocationalTraining, @cbCollegeDegree, @cbNoEdRequirement, @cbWindows, @cbMAC, @cbLinux, @cbNoOSRequirement, @cbMSWord, @cbMSExcel, @cbMSPowerPoint, @cbMSAccess, @cbMSPublisher, @cbOtherSoftware, @txtOtherSoftware, @cbNoSoftwareRequirement, @txtTypeWPM, @txtRequirementsComments, @ddlBackgroundCheck, @radAcceptCriminalBG, @cbFingerprinting, @cbDrugScreening, @cbBilingual, @cbEnglishSpanish, @cbEnglishCreole, @cbMedicalTesting, @cbPrePlacementOrientation, @JobDescription, @radPotentialEmployment, @radInterviewCandidate, @txtRequestedSkills, @ApplicationDatePosition, @EmployerName, @WorksiteName, @WorksiteCity, @WorksiteZip, @WorkersComp)" 
								SelectCommand="SELECT * FROM [JobTitles] WHERE ([keyJobTitleID] = @keyJobTitleID)" 
								UpdateCommand="UPDATE [JobTitles] SET [keyWorksiteID] = @keyWorksiteID, [keyEmployerID] = @keyEmployerID, [JobTitle] = @JobTitle, [PositionsTaken] = @PositionsTaken, [PositionsAvailable] = @PositionsAvailable, [keyApplicantID] = @keyApplicantID, [ddlStartTime] = @ddlStartTime, [ddlEndTime] = @ddlEndTime, [cbWeekdays] = @cbWeekdays, [cbMonday] = @cbMonday, [cbTuesday] = @cbTuesday, [cbWednesday] = @cbWednesday, [cbThursday] = @cbThursday, [cbFriday] = @cbFriday, [cbSaturdays] = @cbSaturdays, [cbSundays] = @cbSundays, [cbHSDiploma] = @cbHSDiploma, [cbVocationalTraining] = @cbVocationalTraining, [cbCollegeDegree] = @cbCollegeDegree, [cbNoEdRequirement] = @cbNoEdRequirement, [cbWindows] = @cbWindows, [cbMAC] = @cbMAC, [cbLinux] = @cbLinux, [cbNoOSRequirement] = @cbNoOSRequirement, [cbMSWord] = @cbMSWord, [cbMSExcel] = @cbMSExcel, [cbMSPowerPoint] = @cbMSPowerPoint, [cbMSAccess] = @cbMSAccess, [cbMSPublisher] = @cbMSPublisher, [cbOtherSoftware] = @cbOtherSoftware, [txtOtherSoftware] = @txtOtherSoftware, [cbNoSoftwareRequirement] = @cbNoSoftwareRequirement, [txtTypeWPM] = @txtTypeWPM, [txtRequirementsComments] = @txtRequirementsComments, [ddlBackgroundCheck] = @ddlBackgroundCheck, [radAcceptCriminalBG] = @radAcceptCriminalBG, [cbFingerprinting] = @cbFingerprinting, [cbDrugScreening] = @cbDrugScreening, [cbBilingual] = @cbBilingual, [cbEnglishSpanish] = @cbEnglishSpanish, [cbEnglishCreole] = @cbEnglishCreole, [cbMedicalTesting] = @cbMedicalTesting, [cbPrePlacementOrientation] = @cbPrePlacementOrientation, [JobDescription] = @JobDescription, [radPotentialEmployment] = @radPotentialEmployment, [radInterviewCandidate] = @radInterviewCandidate, [txtRequestedSkills] = @txtRequestedSkills, [ApplicationDatePosition] = @ApplicationDatePosition, [EmployerName] = @EmployerName, [WorksiteName] = @WorksiteName, [WorksiteCity] = @WorksiteCity, [WorksiteZip] = @WorksiteZip, [WorkersComp] = @WorkersComp WHERE [keyJobTitleID] = @keyJobTitleID">
								<SelectParameters>
									<asp:ControlParameter ControlID="ddlWorkSlot1" Name="keyJobTitleID" PropertyName="SelectedValue" 
										Type="Int32" />
								</SelectParameters>
								<DeleteParameters>
									<asp:Parameter Name="keyJobTitleID" Type="Int32" />
								</DeleteParameters>
								<UpdateParameters>
									<asp:Parameter Name="keyWorksiteID" Type="Int32" />
									<asp:Parameter Name="keyEmployerID" Type="Int32" />
									<asp:Parameter Name="JobTitle" Type="String" />
									<asp:Parameter Name="PositionsTaken" Type="Int32" />
									<asp:Parameter Name="PositionsAvailable" Type="Int32" />
									<asp:Parameter Name="keyApplicantID" Type="Int32" />
									<asp:Parameter Name="ddlStartTime" Type="String" />
									<asp:Parameter Name="ddlEndTime" Type="String" />
									<asp:Parameter Name="cbWeekdays" Type="Boolean" />
									<asp:Parameter Name="cbMonday" Type="Boolean" />
									<asp:Parameter Name="cbTuesday" Type="Boolean" />
									<asp:Parameter Name="cbWednesday" Type="Boolean" />
									<asp:Parameter Name="cbThursday" Type="Boolean" />
									<asp:Parameter Name="cbFriday" Type="Boolean" />
									<asp:Parameter Name="cbSaturdays" Type="Boolean" />
									<asp:Parameter Name="cbSundays" Type="Boolean" />
									<asp:Parameter Name="cbHSDiploma" Type="Boolean" />
									<asp:Parameter Name="cbVocationalTraining" Type="Boolean" />
									<asp:Parameter Name="cbCollegeDegree" Type="Boolean" />
									<asp:Parameter Name="cbNoEdRequirement" Type="Boolean" />
									<asp:Parameter Name="cbWindows" Type="Boolean" />
									<asp:Parameter Name="cbMAC" Type="Boolean" />
									<asp:Parameter Name="cbLinux" Type="Boolean" />
									<asp:Parameter Name="cbNoOSRequirement" Type="Boolean" />
									<asp:Parameter Name="cbMSWord" Type="Boolean" />
									<asp:Parameter Name="cbMSExcel" Type="Boolean" />
									<asp:Parameter Name="cbMSPowerPoint" Type="Boolean" />
									<asp:Parameter Name="cbMSAccess" Type="Boolean" />
									<asp:Parameter Name="cbMSPublisher" Type="Boolean" />
									<asp:Parameter Name="cbOtherSoftware" Type="Boolean" />
									<asp:Parameter Name="txtOtherSoftware" Type="String" />
									<asp:Parameter Name="cbNoSoftwareRequirement" Type="Boolean" />
									<asp:Parameter Name="txtTypeWPM" Type="String" />
									<asp:Parameter Name="txtRequirementsComments" Type="String" />
									<asp:Parameter Name="ddlBackgroundCheck" Type="String" />
									<asp:Parameter Name="radAcceptCriminalBG" Type="String" />
									<asp:Parameter Name="cbFingerprinting" Type="Boolean" />
									<asp:Parameter Name="cbDrugScreening" Type="Boolean" />
									<asp:Parameter Name="cbBilingual" Type="Boolean" />
									<asp:Parameter Name="cbEnglishSpanish" Type="Boolean" />
									<asp:Parameter Name="cbEnglishCreole" Type="Boolean" />
									<asp:Parameter Name="cbMedicalTesting" Type="Boolean" />
									<asp:Parameter Name="cbPrePlacementOrientation" Type="Boolean" />
									<asp:Parameter Name="JobDescription" Type="String" />
									<asp:Parameter Name="radPotentialEmployment" Type="String" />
									<asp:Parameter Name="radInterviewCandidate" Type="String" />
									<asp:Parameter Name="txtRequestedSkills" Type="String" />
									<asp:Parameter Name="ApplicationDatePosition" Type="DateTime" />
									<asp:Parameter Name="EmployerName" Type="String" />
									<asp:Parameter Name="WorksiteName" Type="String" />
									<asp:Parameter Name="WorksiteCity" Type="String" />
									<asp:Parameter Name="WorksiteZip" Type="String" />
									<asp:Parameter Name="WorkersComp" Type="String" />
									<asp:Parameter Name="keyJobTitleID" Type="Int32" />
								</UpdateParameters>
								<InsertParameters>
									<asp:Parameter Name="keyWorksiteID" Type="Int32" />
									<asp:Parameter Name="keyEmployerID" Type="Int32" />
									<asp:Parameter Name="JobTitle" Type="String" />
									<asp:Parameter Name="PositionsTaken" Type="Int32" />
									<asp:Parameter Name="PositionsAvailable" Type="Int32" />
									<asp:Parameter Name="keyApplicantID" Type="Int32" />
									<asp:Parameter Name="ddlStartTime" Type="String" />
									<asp:Parameter Name="ddlEndTime" Type="String" />
									<asp:Parameter Name="cbWeekdays" Type="Boolean" />
									<asp:Parameter Name="cbMonday" Type="Boolean" />
									<asp:Parameter Name="cbTuesday" Type="Boolean" />
									<asp:Parameter Name="cbWednesday" Type="Boolean" />
									<asp:Parameter Name="cbThursday" Type="Boolean" />
									<asp:Parameter Name="cbFriday" Type="Boolean" />
									<asp:Parameter Name="cbSaturdays" Type="Boolean" />
									<asp:Parameter Name="cbSundays" Type="Boolean" />
									<asp:Parameter Name="cbHSDiploma" Type="Boolean" />
									<asp:Parameter Name="cbVocationalTraining" Type="Boolean" />
									<asp:Parameter Name="cbCollegeDegree" Type="Boolean" />
									<asp:Parameter Name="cbNoEdRequirement" Type="Boolean" />
									<asp:Parameter Name="cbWindows" Type="Boolean" />
									<asp:Parameter Name="cbMAC" Type="Boolean" />
									<asp:Parameter Name="cbLinux" Type="Boolean" />
									<asp:Parameter Name="cbNoOSRequirement" Type="Boolean" />
									<asp:Parameter Name="cbMSWord" Type="Boolean" />
									<asp:Parameter Name="cbMSExcel" Type="Boolean" />
									<asp:Parameter Name="cbMSPowerPoint" Type="Boolean" />
									<asp:Parameter Name="cbMSAccess" Type="Boolean" />
									<asp:Parameter Name="cbMSPublisher" Type="Boolean" />
									<asp:Parameter Name="cbOtherSoftware" Type="Boolean" />
									<asp:Parameter Name="txtOtherSoftware" Type="String" />
									<asp:Parameter Name="cbNoSoftwareRequirement" Type="Boolean" />
									<asp:Parameter Name="txtTypeWPM" Type="String" />
									<asp:Parameter Name="txtRequirementsComments" Type="String" />
									<asp:Parameter Name="ddlBackgroundCheck" Type="String" />
									<asp:Parameter Name="radAcceptCriminalBG" Type="String" />
									<asp:Parameter Name="cbFingerprinting" Type="Boolean" />
									<asp:Parameter Name="cbDrugScreening" Type="Boolean" />
									<asp:Parameter Name="cbBilingual" Type="Boolean" />
									<asp:Parameter Name="cbEnglishSpanish" Type="Boolean" />
									<asp:Parameter Name="cbEnglishCreole" Type="Boolean" />
									<asp:Parameter Name="cbMedicalTesting" Type="Boolean" />
									<asp:Parameter Name="cbPrePlacementOrientation" Type="Boolean" />
									<asp:Parameter Name="JobDescription" Type="String" />
									<asp:Parameter Name="radPotentialEmployment" Type="String" />
									<asp:Parameter Name="radInterviewCandidate" Type="String" />
									<asp:Parameter Name="txtRequestedSkills" Type="String" />
									<asp:Parameter Name="ApplicationDatePosition" Type="DateTime" />
									<asp:Parameter Name="EmployerName" Type="String" />
									<asp:Parameter Name="WorksiteName" Type="String" />
									<asp:Parameter Name="WorksiteCity" Type="String" />
									<asp:Parameter Name="WorksiteZip" Type="String" />
									<asp:Parameter Name="WorkersComp" Type="String" />
								</InsertParameters>
							</asp:SqlDataSource>
							<br />
<%--			</ContentTemplate>
		</asp:UpdatePanel>					--%>
							
						</td>
					</tr>
                    <tr>
                        <td>
                            Date case manager contacted host site to schedule interview or start date:
                        </td>
                        <td style="text-align: left;">
                            <asp:TextBox ID="txtDateHostContacted" runat="server" Width="75px" TabIndex="589"></asp:TextBox>
                            <cc1:CalendarExtender ID="CalendarExtender1" runat="server" Enabled="True" TargetControlID="txtDateHostContacted">
                            </cc1:CalendarExtender>
                            <%--							<asp:ImageButton runat="Server" ID="ImageButton2" 
                                         ImageUrl="Images/CalendarIcon.gif" 
                                         AlternateText="Click here to select a date.  Click on the month and year to change.  Click arrows to change decade." 
                                         CausesValidation="False" /> --%>
                        </td>
                    </tr>
					<tr>
						<td>
						Client’s Total Monthly Hours Needed:
						</td>
						<td style="text-align:left;">
							<asp:TextBox ID="txtHoursNeeded" runat="server" Width="50px" onkeypress="return num(this);"
                                TabIndex="590"></asp:TextBox>
						</td>
					</tr>
					<tr>
						<td>
						Days Assigned:
						</td>
						<td style="text-align:left;">
     <asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional" RenderMode="Inline">
        <ContentTemplate>
                                    <asp:CheckBox ID="cbMon"     name="Check1" Text="Mon"     runat="server" 
                                                  TabIndex="592" CssClass="buttonSpace2" AutoPostBack="True" 
                                        Enabled="True" />
                                    <asp:CheckBox ID="cbTue"    name="Check1" Text="Tue"    runat="server" 
                                                  TabIndex="594" CssClass="buttonSpace2" AutoPostBack="True" 
                                        Enabled="True" />
                                    <asp:CheckBox ID="cbWed"  name="Check1" Text="Wed"  runat="server" 
                                                  TabIndex="596" CssClass="buttonSpace2" AutoPostBack="True" 
                                        Enabled="True" />
                                    <asp:CheckBox ID="cbThu"   name="Check1" Text="Thu"   runat="server" 
                                                  TabIndex="598" CssClass="buttonSpace2" AutoPostBack="True" 
                                        Enabled="True" />
                                    <asp:CheckBox ID="cbFri"     name="Check1" Text="Fri"     runat="server" 
                                                  TabIndex="600" CssClass="buttonSpace2" AutoPostBack="True" 
                                        Enabled="True" />
                                    <asp:CheckBox ID="cbSat"  name="Check1" Text="Sat"   runat="server" 
                                                  TabIndex="602" CssClass="buttonSpace2 maroonButton" 
                                        Enabled="True" />
                                    <asp:CheckBox ID="cbSun"    name="Check1" Text="Sun"     runat="server" 
                                                  TabIndex="604" CssClass="buttonSpace2 maroonButton" 
                                        Enabled="True" />
                                    <%-- CheckBox Validation is done in Page_Load Event:  form1.Attributes("onsubmit")... --%>
        </ContentTemplate>
     </asp:UpdatePanel>
							
						</td>
					</tr>

					<tr>
						<td>
							Daily Assigned Hours:
						</td>
						<td style="text-align:left; white-space:nowrap;">
							<asp:TextBox ID="txtHourAssigned" runat="server" Width="50px" TabIndex="610"></asp:TextBox>
						</td>
					</tr>
					<tr>
						<td>Is client scheduled for an interview?</td>
						<td style="text-align:left; white-space:nowrap;">
<%--	<asp:UpdatePanel ID="UP0InterviewScheduled" runat="server" UpdateMode="Conditional" RenderMode="Inline">
	<ContentTemplate>--%>
							<asp:RadioButtonList ID="radInterviewScheduled" runat="server" RepeatDirection="Horizontal" 
								RepeatLayout="Flow" AutoPostBack="True" TabIndex="615">
								<asp:ListItem>Yes</asp:ListItem>
								<asp:ListItem>No</asp:ListItem>
								<asp:ListItem>Not Required</asp:ListItem>
							</asp:RadioButtonList>
<%--	</ContentTemplate>
	</asp:UpdatePanel>--%>
						</td>
					</tr>
					<tr>
						<td>
<%--     <asp:UpdatePanel ID="UP1InterviewScheduled" runat="server" UpdateMode="Conditional" RenderMode="Inline">
                <Triggers>
                       <asp:AsyncPostBackTrigger ControlID="radInterviewScheduled" />
                </Triggers>
        <ContentTemplate>--%>
						<asp:label ID="lblInterviewDate" runat="server" Visible="False">If yes, what date?</asp:label>
<%--		</ContentTemplate>
	</asp:UpdatePanel>						--%>
						</td>
						<td style="text-align:left; white-space:nowrap;">
<%--     <asp:UpdatePanel ID="UP2InterviewScheduled" runat="server" UpdateMode="Conditional" RenderMode="Inline">
                <Triggers>
                       <asp:AsyncPostBackTrigger ControlID="radInterviewScheduled" />
                </Triggers>
        <ContentTemplate>--%>
							<asp:TextBox ID="txtInterviewDate" runat="server" Width="75px" Visible="False" 
                                TabIndex="620"></asp:TextBox>
<%--							<asp:ImageButton runat="Server" ID="imgInterviewDate" 
                                         ImageUrl="Images/CalendarIcon.gif" 
                                         AlternateText="Click here to select a date.  Click on the month and year to change.  Click arrows to change decade." 
                                         CausesValidation="False" Visible="False" />--%>
<%--		</ContentTemplate>
	</asp:UpdatePanel>--%>
						</td>
					</tr>
					<tr>
						<td>Candidate assigned/accepted?</td>
						<td style="text-align:left; white-space:nowrap;">
							<asp:RadioButtonList ID="radIsCandidateAssigned" runat="server" RepeatDirection="Horizontal" 
								RepeatLayout="Flow" TabIndex="625">
								<asp:ListItem>Yes</asp:ListItem>
								<asp:ListItem>No</asp:ListItem>
								<asp:ListItem>Awaiting Interview Results</asp:ListItem>
							</asp:RadioButtonList>
						</td>
					</tr>
					<tr>
						<td>
						Start Date:
						</td>
						<td style="text-align:left;">
<%--     <asp:UpdatePanel ID="UPStartDate" runat="server" UpdateMode="Conditional" RenderMode="Inline">
        <ContentTemplate>
--%>							<asp:TextBox ID="txtStartDate" runat="server" Width="75px" AutoPostBack="True" 
                                TabIndex="630"></asp:TextBox>
							<cc1:CalendarExtender ID="txtStartDate_CalendarExtender" runat="server" Enabled="True" 
								TargetControlID="txtStartDate">
							</cc1:CalendarExtender>
<%--							<asp:ImageButton runat="Server" ID="ImageButton3" 
                                         ImageUrl="Images/CalendarIcon.gif" 
                                         AlternateText="Click here to select a date.  Click on the month and year to change.  Click arrows to change decade." 
                                         CausesValidation="False" />--%>
<%--       </ContentTemplate>
	</asp:UpdatePanel>                                          --%>
						</td>
					</tr>
					<tr>
						<td>
						Projected End Date:
						</td>
						<td style="text-align:left;">
<%--     <asp:UpdatePanel ID="UPProjEndDate" runat="server" UpdateMode="Conditional" RenderMode="Inline">
                <Triggers>
                       <asp:AsyncPostBackTrigger ControlID="txtStartDate" />
                </Triggers>
        <ContentTemplate>
--%>
							<asp:TextBox ID="txtProjEndDate" runat="server" Width="75px" TabIndex="635"></asp:TextBox>
<%--							<asp:ImageButton runat="Server" ID="ImageButton4" 
                                         ImageUrl="Images/CalendarIcon.gif" 
                                         AlternateText="Click here to select a date.  Click on the month and year to change.  Click arrows to change decade." 
                                         CausesValidation="False" /> --%>
<%--       </ContentTemplate>
	</asp:UpdatePanel>                                          --%>
						</td>
					</tr>
					<%--<asp:CheckBoxField DataField="cbMonday" HeaderText="Monday" SortExpression="cbMonday" />
									<asp:CheckBoxField DataField="cbTuesday" HeaderText="Tuesday" SortExpression="cbTuesday" />
									<asp:CheckBoxField DataField="cbWednesday" HeaderText="Wednesday" SortExpression="cbWednesday" />
									<asp:CheckBoxField DataField="cbThursday" HeaderText="Thursday" SortExpression="cbThursday" />
									<asp:CheckBoxField DataField="cbFriday" HeaderText="Friday" SortExpression="cbFriday" />
									<asp:CheckBoxField DataField="cbSaturdays" HeaderText="Saturday" SortExpression="cbSaturdays" />
									<asp:CheckBoxField DataField="cbSundays" HeaderText="Sunday" SortExpression="cbSundays" />
									--%>					<tr>
						<td colspan="2" style="text-align:left;">Comments:<br />
							<asp:TextBox ID="txtComments" runat="server" Rows="5" TextMode="MultiLine" 
                                Width="80%" TabIndex="650"></asp:TextBox></td>
					</tr>
				</table>
				<%--									<asp:CheckBoxField DataField="cbVocationalTraining" HeaderText="Vocational Training" SortExpression="cbVocationalTraining" />
									<asp:CheckBoxField DataField="cbCollegeDegree" HeaderText="College Degree" SortExpression="cbCollegeDegree" />
									<asp:CheckBoxField DataField="cbNoEdRequirement" HeaderText="No Ed Requirement" SortExpression="cbNoEdRequirement" />
--%>
				<div>
					<hr style="width: 70%; text-align: center;" />
					<br />
					<div>
						<div style="text-align: center">
							<span class="style1">Please: Click the Submit button only once. Make sure all your information is correct BEFORE you click Submit. </span>
						</div>
					</div>
					<br />
					<div>
						<div style="text-align: center">
							<asp:Button ID="btnSubmit" runat="server" TabIndex="1100" Text="Submit" /><br />
							<asp:Label ID="lblRFANumberCheck" runat="server" Text=""></asp:Label>
							<br />
							<br />
							
						</div>
						<br />
					</div>
				</div>
			</div>
			<br />
		</div>
		<hr style="margin-top: 30px;" />
		<p class="copy">
			Copyright &copy; 1997 - 2013 by WorkForce One Employment Solutions - ALL RIGHTS RESERVED</p>
	</div>
	</form>
</body>
</html>

Open in new window



Applicant1.aspx.vb:
Imports System.Data
Imports System.Data.SqlClient
Imports System.Web.UI.WebControls
Partial Class Applicant1
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        'btnJobDetail.Attributes.Add("onclick", "javascript:javascriptfunction(return value)")
        'btnSubmit.Enabled = False
    End Sub

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnCheckRFA.Click

        Dim SQLCmd As New SqlCommand
        Dim SQLConn As New SqlConnection(ConfigurationManager.ConnectionStrings("CSPConnectionString1").ConnectionString)
        SQLCmd.CommandText = "Select Count(1) From Applicants Where RFA = '" & RFA.Text & "'"

        SQLConn.Open()
        SQLCmd.Connection = SQLConn
        Dim Count As Integer = SQLCmd.ExecuteScalar()

        If Count > 0 Then
            lblCheckRFA.ForeColor = Drawing.Color.Red
            lblCheckRFA.Text = "RFA Number already exists."
        ElseIf RFA.Text = "" Then
            lblCheckRFA.ForeColor = Drawing.Color.HotPink
            lblCheckRFA.Text = "Enter an RFA Number"
        ElseIf RFA.Text.Length < 10 Then
            lblCheckRFA.ForeColor = Drawing.Color.HotPink
            lblCheckRFA.Text = "Enter a valid RFA Number"
        ElseIf RFA.Text.Length > 10 Then
            If RFA.Text.Substring(10).EndsWith("B") Then
                lblCheckRFA.ForeColor = Drawing.Color.Green
                lblCheckRFA.Text = "Okay to add this RFA Number."
            Else
                lblCheckRFA.ForeColor = Drawing.Color.DeepPink
                lblCheckRFA.Text = "Enter a valid RFA Number."
            End If
        Else
            lblCheckRFA.ForeColor = Drawing.Color.Green
            lblCheckRFA.Text = "Okay to add this RFA Number."
        End If

        SQLConn.Close()

    End Sub
    Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
        If lblCheckRFA.Text = "Okay to add this RFA Number." Then
            Dim SQLCmd As New SqlCommand
            Dim SQLConn As New SqlConnection(ConfigurationManager.ConnectionStrings("CSPConnectionString1").ConnectionString)
            SQLCmd.CommandText = "Select Count(1) From Applicants Where RFA = '" & RFA.Text & "'"

            SQLConn.Open()
            SQLCmd.Connection = SQLConn
            Dim Count As Integer = SQLCmd.ExecuteScalar()

            If Count > 0 Then
                lblCheckRFA.ForeColor = Drawing.Color.Red
                lblCheckRFA.Text = "RFA Number already exists."
                SQLConn.Close()
                Exit Sub
            ElseIf RFA.Text.Length > 11 Then
                lblCheckRFA.ForeColor = Drawing.Color.DeepPink
                lblCheckRFA.Text = "Enter a valid RFA Number"
                SQLConn.Close()
                Exit Sub
            End If
            SQLConn.Close()

            Call SendDataToApplicants()
            Call UpdateApplicantRecord()
            Call UpdateJobTitleRecord()
        Else
            lblCheckRFA.ForeColor = Drawing.Color.DarkRed
            lblCheckRFA.Text = "RFA Number is not Valid."
            lblRFANumberCheck.ForeColor = Drawing.Color.DarkRed
            lblRFANumberCheck.Text = "RFA number is not valid.  Please enter a valid RFA Number."
        End If


        'Print a Confirmation Page when All Done is clicked
        Session("ApplicantName") = FirstName.Text & " " & LastName.Text
        Server.Transfer("Applicant2.aspx")

        '      '<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< Start Automatic Email routine for Incident/Accident Report  >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

        '      Dim smtpClient As Net.Mail.SmtpClient = New Net.Mail.SmtpClient()
        '      Dim message As Net.Mail.MailMessage = New Net.Mail.MailMessage()
        '      'Prepare two email addresses
        '      Dim fromAddress As New Net.Mail.MailAddress( _
        '          "WorkForceOne@wf1broward.com", "Incident Report from eIntranet")
        '      Dim toAddress1 As New Net.Mail.MailAddress("DMegnin@wf1broward.com")  '<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< Email Recipient(s) 
        'Dim toAddress2 As New Net.Mail.MailAddress("RShaw@wf1broward.com")
        'Dim toAddress3 As New Net.Mail.MailAddress("LBruno@wf1broward.com")
        '      'Dim toAddress4 As New Net.Mail.MailAddress("CHylton@wf1broward.com")
        '      'Dim toAddress As New Net.Mail.MailAddress("dmegnin@wf1broward.com")  '<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< Email Recipient 
        '      'Prepare the mail message
        '      '                                                                     message.BodyEncoding = System.Text.Encoding.UTF8
        '      message.IsBodyHtml = True
        '      message.From = fromAddress
        '      message.To.Add(toAddress1)
        '      message.To.Add(toAddress2)
        '      message.To.Add(toAddress3)
        '      'message.To.Add(toAddress4)
        '      message.Subject = "SYEP 2008 Application"
        '      message.Body = "Hello, " & vbCrLf & _
        '      vbCrLf & _
        '          "<br /><br />Below are the details of this Application." & _
        '          vbCrLf & vbCrLf & _
        '          "<br /><br /><b>Name: </b>" & vbTab & txtFirstName.Text & " " & txtLastName.Text & vbCrLf & _
        '          "<br /><br /><b>Phone Number: </b>" & vbTab & txtHomeTelephone.Text & vbCrLf & _
        '          "<br /><br /><b>Email Address: </b>" & vbTab & txtEmailAddress.Text & vbCrLf & _
        '          "<br /><br /><b>Age: </b>" & vbTab & txtAge.Text & vbCrLf & _
        '          "<br /><br /><b>DOB: </b>" & vbTab & txtDOB.Text & vbCrLf & _
        '          "<br /><br /><b>Address: </b>" & vbTab & txtStreetName.Text & vbCrLf & _
        '          "<br /><br /><b>City: </b>" & vbTab & ddlCity.Text & vbCrLf & _
        '          "<br /><br /><b>Zip: </b>" & vbTab & ddlZipCode.SelectedValue & vbCrLf & _
        '          "<br /><br /><b>Job Interest: </b>" & vbTab & ddlWorkPreference.SelectedValue & vbCrLf & _
        '          "<br /><br /><b>School: </b>" & vbTab & txtSchool.Text & vbCrLf & _
        '          "<br /><br /><b>Participated Before: </b>" & vbTab & radParticipatedBefore.SelectedValue & vbCrLf & _
        '          "<br /><br /><b>Organization Referred by: </b>" & vbTab & txtOrgReferredBy.Text & vbCrLf

        '      'Set server details
        '      smtpClient.Host = "ExchServ"
        '      'Send the email
        '      Try
        '          smtpClient.Send(message)
        '      Catch exp As Exception
        '          Response.Write(exp)
        '      End Try
        '      '<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< End Automatic Email routine  >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    End Sub

    Protected Sub RunStoredProcedure()
        'This procedure is commented in JobTitle1.aspx.vb for reference.
        'Never mind delete the sp.  I added the statements to the sp above.
        Dim sConnStr As String = ConfigurationManager.ConnectionStrings("CSPConnectionString1").ConnectionString
        Dim cnBKTest As New SqlConnection(sConnStr)
        '<03/15/2010 I replaced the sp that only updates Employer Name and Worksite Name with the one that also updates the Employer and Worksite IDs in the Applicants record.
        '<03/15/2010 ...two minutes later I discover that nothing is calling this sp. See the "UpdateApplicantsRecord" sub.>
        'Dim cmdTest As New SqlCommand("spUpdate_Applicants_EmployerName_WorksiteName", cnBKTest)
        Dim cmdTest As New SqlCommand("spUpdate_Applicants_WorksiteName_From_JobTitles", cnBKTest)
        cmdTest.CommandType = Data.CommandType.StoredProcedure
        cnBKTest.Open()
        cmdTest.ExecuteNonQuery()
        cnBKTest.Close()
    End Sub

    Protected Sub cbMonFri_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cbMonFri.CheckedChanged
        If cbMonFri.Checked = True Then
            cbMonday.Checked = True
            cbTuesday.Checked = True
            cbWednesday.Checked = True
            cbThursday.Checked = True
            cbFriday.Checked = True
        Else
            cbMonday.Checked = False
            cbTuesday.Checked = False
            cbWednesday.Checked = False
            cbThursday.Checked = False
            cbFriday.Checked = False
        End If
    End Sub

    Protected Sub cbMonday_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cbMonday.CheckedChanged
        If (cbMonday.Checked = True And _
            cbTuesday.Checked = True And _
            cbWednesday.Checked = True And _
            cbThursday.Checked = True And _
            cbFriday.Checked = True) Then
            cbMonFri.Checked = True
        Else
            cbMonFri.Checked = False
        End If
    End Sub

    Protected Sub cbTuesday_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cbTuesday.CheckedChanged
        If (cbMonday.Checked = True And _
            cbTuesday.Checked = True And _
            cbWednesday.Checked = True And _
            cbThursday.Checked = True And _
            cbFriday.Checked = True) Then
            cbMonFri.Checked = True
        Else
            cbMonFri.Checked = False
        End If
    End Sub

    Protected Sub cbWednesday_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cbWednesday.CheckedChanged
        If (cbMonday.Checked = True And _
            cbTuesday.Checked = True And _
            cbWednesday.Checked = True And _
            cbThursday.Checked = True And _
            cbFriday.Checked = True) Then
            cbMonFri.Checked = True
        Else
            cbMonFri.Checked = False
        End If
    End Sub

    Protected Sub cbThursday_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cbThursday.CheckedChanged
        If (cbMonday.Checked = True And _
            cbTuesday.Checked = True And _
            cbWednesday.Checked = True And _
            cbThursday.Checked = True And _
            cbFriday.Checked = True) Then
            cbMonFri.Checked = True
        Else
            cbMonFri.Checked = False
        End If
    End Sub

    Protected Sub cbFriday_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cbFriday.CheckedChanged
        If (cbMonday.Checked = True And _
            cbTuesday.Checked = True And _
            cbWednesday.Checked = True And _
            cbThursday.Checked = True And _
            cbFriday.Checked = True) Then
            cbMonFri.Checked = True
        Else
            cbMonFri.Checked = False
        End If
    End Sub

    Protected Sub txtStartDate_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtStartDate.TextChanged
        Dim StartDate As Date = CType(txtStartDate.Text, Date)
        'Dim ProjEndDate As Date
        txtProjEndDate.Text = StartDate.AddMonths(6)
    End Sub

    Protected Sub radInterviewScheduled_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles radInterviewScheduled.SelectedIndexChanged
        If radInterviewScheduled.SelectedValue = "Yes" Then
            lblInterviewDate.Visible = "True"
            txtInterviewDate.Visible = "True"
            'imgInterviewDate.Visible = "True"
        Else
            lblInterviewDate.Visible = "False"
            txtInterviewDate.Visible = "False"
            txtInterviewDate.Text = ""
            'imgInterviewDate.Visible = "False"
        End If
    End Sub

    Protected Sub radAdditionalHours_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles radAdditionalHours.SelectedIndexChanged

        Select Case radAdditionalHours.SelectedValue
            Case "Yes"
                lblSlot2.Visible = True
                ddlWorkSlot2.Visible = True
            Case "No"
                lblSlot2.Visible = False
                ddlWorkSlot2.Visible = False
                ddlWorkSlot2.SelectedIndex = 0
        End Select

    End Sub

    'Protected Sub btnJobDetail_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles btnJobDetail.Click
    '    dvJobDetails.Visible = True
    '    btnHideJobDetails.Visible = True
    'End Sub

    Protected Sub ddlWorkSlot1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlWorkSlot1.SelectedIndexChanged
        dvJobDetails.Visible = True
        btnHideJobDetails.Visible = True
    End Sub

    Protected Sub btnHideJobDetails_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnHideJobDetails.Click
        dvJobDetails.Visible = False
        btnHideJobDetails.Visible = False
    End Sub

    Protected Sub ddlWorkPreference_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlWorkPreference.SelectedIndexChanged
        If ddlWorkPreference.SelectedValue = "Other" Then
            txtOtherWorkPref.Visible = True
            lblOtherPreference.Visible = True
        Else
            txtOtherWorkPref.Visible = False
            lblOtherPreference.Visible = False
            txtOtherWorkPref.Text = ""
        End If
    End Sub

    Protected Sub SendDataToApplicants()

        ' Get User's IP Address and Browser version to help identify duplicates and determine what Browsers I need to support
        Dim varBrowser As String = ""
        Dim varIPAddress As String = ""
        Dim varUserName As String = ""
        varBrowser = Request.Browser.Browser.ToString & " " & Request.Browser.MajorVersion
        varIPAddress = Request.UserHostAddress.ToString
        varUserName = Environment.UserName.ToString

        Dim DBConn As New SqlConnection(ConfigurationManager.ConnectionStrings("CSPConnectionString1").ConnectionString)
        Dim DBCmd As New SqlCommand
        Dim sql As String = "INSERT INTO Applicants (Active,LastName,FirstName,MI,Suf,SSN,RFA,Address,CityName,State,ZipCode,HomePhone,CellPhone,OtherPhone,EmailAddress,Center,CaseManagerName,CaseManagerPhone,CaseManagerExt,JobDeveloperAssigned,WorksiteCityPreference,StartTime, EndTime, cbMonFri, cbSaturday, cbSunday, cbMonday, cbTuesday, cbWednesday, cbThursday, cbFriday,ddlTransportation,OtherLanguages,ddlWorkPreference, txtOtherWorkPref, keyJobTitleID, keyJobTitleID2, DateCaseManagerContactedHost, HoursNeeded, AssignedMon, AssignedTue, AssignedWed, AssignedThu, AssignedFri, AssignedSat, AssignedSun, HoursAssigned, IsInterviewScheduled, InterviewDate, IsCandidateAssigned, StartDate, ProjectedEndDate, Comments,OnlineApplicationDate,DateUpdated,Pending,LastUpdatedBy,IPAddress,ClientBrowser) "
        sql = sql & "VALUES (@Active,@LastName,@FirstName,@MI,@Suf,@SSN,@RFA,@Address,@ddlCity,@State,@ddlZipCode,@HomePhone,@CellPhone,@OtherPhone,@EmailAddress,@Center,@CaseManagerName,@CaseManagerPhone,@CaseManagerExt,@JobDeveloperAssigned,@WorksiteCityPreference,@StartTime,@EndTime,@cbMonFri,@cbSaturday,@cbSunday,@cbMonday,@cbTuesday,@cbWednesday,@cbThursday,@cbFriday,@Transportation,@OtherLanguages,@ddlWorkPreference,@txtOtherWorkPref,@keyJobTitleID,@keyJobTitleID2,@DateCaseManagerContactedHost,@HoursNeeded,@AssignedMon,@AssignedTue,@AssignedWed,@AssignedThu,@AssignedFri,@AssignedSat,@AssignedSun,@HoursAssigned,@IsInterviewScheduled,@InterviewDate,@IsCandidateAssigned,@StartDate,@ProjectedEndDate,@Comments,getdate(),getdate(),getdate(),@LastUpdatedBy,@IPAddress,@ClientBrowser);Select SCOPE_IDENTITY()"
        DBConn.Open()

        Try
            'Add Insert Statement 
            'DBCmd = New SqlCommand("INSERT INTO Applicants (Active,LastName,FirstName,MI,Suf,SSN,RFA,Address,CityName,State,ZipCode,HomePhone,CellPhone,OtherPhone,EmailAddress,Center,CaseManagerName,CaseManagerPhone,CaseManagerExt,JobDeveloperAssigned,WorksiteCityPreference,StartTime,EndTime,cbMonFri,cbSaturday,cbSunday,cbMonday,cbTuesday,cbWednesday,cbThursday,cbFriday,ddlTransportation,OtherLanguages,ddlWorkPreference,keyJobTitleID,keyJobTitleID2,DateCaseManagerContactedHost,HoursNeeded,AssignedMon,AssignedTue,AssignedWed,AssignedThu,AssignedFri,AssignedSat,AssignedSun,HoursAssigned,IsInterviewScheduled,InterviewDate,IsCandidateAssigned,StartDate,ProjectedEndDate,ActualEndDate,ReasonForTermination,Comments,OnlineApplicationDate,DateUpdated,LastUpdatedBy,IPAddress,ClientBrowser) VALUES (@Active,@LastName,@FirstName,@MI,@Suf,@SSN,@RFA,@Address,@ddlCity,@State,@ddlZipCode,@HomePhone,@CellPhone,@OtherPhone,@EmailAddress,@Center,@CaseManagerName,@CaseManagerPhone,@CaseManagerExt,@JobDeveloperAssigned,@WorksiteCityPreference,@StartTime,@EndTime,@cbMonFri,@cbSaturday,@cbSunday,@cbMonday,@cbTuesday,@cbWednesday,@cbThursday,@cbFriday,@Transportation,@OtherLanguages,@ddlWorkPreference,@keyJobTitleID,@keyJobTitleID2,@DateCaseManagerContactedHost,@HoursNeeded,@AssignedMon,@AssignedTue,@AssignedWed,@AssignedThu,@AssignedFri,@AssignedSat,@AssignedSun,@HoursAssigned,@IsInterviewScheduled,@InterviewDate,@IsCandidateAssigned,@StartDate,@ProjectedEndDate,@ActualEndDate,@ReasonForTermination,@Comments,getdate(),getdate(),@LastUpdatedBy,@IPAddress,@ClientBrowser);Select SCOPE_IDENTITY()", DBConn)
            DBCmd = New SqlCommand(sql, DBConn) 'Add Database Parameters
            DBCmd.Parameters.Add("@Active", SqlDbType.Bit).Value = True
            DBCmd.Parameters.Add("@LastName", SqlDbType.VarChar).Value = LastName.Text
            DBCmd.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = FirstName.Text
            DBCmd.Parameters.Add("@MI", SqlDbType.VarChar).Value = MI.Text
            DBCmd.Parameters.Add("@Suf", SqlDbType.VarChar).Value = Suf.Text
            'DBCmd.Parameters.Add("@SSN", SqlDbType.VarChar).Value = txtSSN1.Text & txtSSN2.Text & txtSSN3.Text  'Use this one for full SSN [dhm200907130621]
            DBCmd.Parameters.Add("@SSN", SqlDbType.VarChar).Value = SSN3.Text                                    'Use this one for last 4 only [dhm200907130621]
            DBCmd.Parameters.Add("@RFA", SqlDbType.VarChar).Value = RFA.Text
            DBCmd.Parameters.Add("@Address", SqlDbType.VarChar).Value = Address.Text
            DBCmd.Parameters.Add("@ddlCity", SqlDbType.VarChar).Value = ddlCity.Text
            DBCmd.Parameters.Add("@State", SqlDbType.VarChar).Value = State.Text
            DBCmd.Parameters.Add("@ddlZipCode", SqlDbType.VarChar).Value = ddlZipCode.Text
            DBCmd.Parameters.Add("@HomePhone", SqlDbType.VarChar).Value = HomePhone.Text
            DBCmd.Parameters.Add("@CellPhone", SqlDbType.VarChar).Value = CellPhone.Text
            DBCmd.Parameters.Add("@OtherPhone", SqlDbType.VarChar).Value = OtherPhone.Text
            DBCmd.Parameters.Add("@EmailAddress", SqlDbType.VarChar).Value = EmailAddress.Text
            DBCmd.Parameters.Add("@Center", SqlDbType.VarChar).Value = ddlCenter.SelectedValue
            DBCmd.Parameters.Add("@CaseManagerName", SqlDbType.VarChar).Value = CaseManagerName.Text
            DBCmd.Parameters.Add("@CaseManagerPhone", SqlDbType.VarChar).Value = CaseManagerPhone.Text
            DBCmd.Parameters.Add("@CaseManagerExt", SqlDbType.VarChar).Value = CaseManagerExt.Text
            DBCmd.Parameters.Add("@JobDeveloperAssigned", SqlDbType.VarChar).Value = ddlJobDeveloper.SelectedValue
            DBCmd.Parameters.Add("@WorksiteCityPreference", SqlDbType.VarChar).Value = ddlWorksiteCityPreference.SelectedValue
            DBCmd.Parameters.Add("@StartTime", SqlDbType.VarChar).Value = ddlStartTime.SelectedValue
            DBCmd.Parameters.Add("@EndTime", SqlDbType.VarChar).Value = ddlEndTime.SelectedValue
            DBCmd.Parameters.Add("@cbMonFri", SqlDbType.Bit).Value = cbMonFri.Checked
            DBCmd.Parameters.Add("@cbSaturday", SqlDbType.Bit).Value = cbSaturday.Checked
            DBCmd.Parameters.Add("@cbSunday", SqlDbType.Bit).Value = cbSunday.Checked
            DBCmd.Parameters.Add("@cbMonday", SqlDbType.Bit).Value = cbMonday.Checked
            DBCmd.Parameters.Add("@cbTuesday", SqlDbType.Bit).Value = cbTuesday.Checked
            DBCmd.Parameters.Add("@cbWednesday", SqlDbType.Bit).Value = cbWednesday.Checked
            DBCmd.Parameters.Add("@cbThursday", SqlDbType.Bit).Value = cbThursday.Checked
            DBCmd.Parameters.Add("@cbFriday", SqlDbType.Bit).Value = cbFriday.Checked
            DBCmd.Parameters.Add("@Transportation", SqlDbType.VarChar).Value = ddlTransportation.Text
            DBCmd.Parameters.Add("@OtherLanguages", SqlDbType.VarChar).Value = txtOtherLanguages.Text
            DBCmd.Parameters.Add("@ddlWorkPreference", SqlDbType.VarChar).Value = ddlWorkPreference.SelectedValue
            DBCmd.Parameters.Add("@txtOtherWorkPref", SqlDbType.VarChar).Value = txtOtherWorkPref.Text
            DBCmd.Parameters.Add("@keyJobTitleID", SqlDbType.Int).Value = ddlWorkSlot1.SelectedValue
            DBCmd.Parameters.Add("@keyJobTitleID2", SqlDbType.Int).Value = ddlWorkSlot2.SelectedValue
            'DBCmd.Parameters.Add("@DateCaseManagerContactedHost", SqlDbType.SmallDateTime).Value = txtDateHostContacted.Text
            DBCmd.Parameters.Add("@DateCaseManagerContactedHost", SqlDbType.VarChar)
            If txtDateHostContacted.Text = "" Then
                DBCmd.Parameters("@DateCaseManagerContactedHost").Value = SqlTypes.SqlDateTime.Null
            Else
                DBCmd.Parameters("@DateCaseManagerContactedHost").Value = txtDateHostContacted.Text
            End If
            DBCmd.Parameters.Add("@HoursNeeded", SqlDbType.VarChar).Value = txtHoursNeeded.Text
            DBCmd.Parameters.Add("@AssignedMon", SqlDbType.Bit).Value = cbMon.Checked
            DBCmd.Parameters.Add("@AssignedTue", SqlDbType.Bit).Value = cbTue.Checked
            DBCmd.Parameters.Add("@AssignedWed", SqlDbType.Bit).Value = cbWed.Checked
            DBCmd.Parameters.Add("@AssignedThu", SqlDbType.Bit).Value = cbThu.Checked
            DBCmd.Parameters.Add("@AssignedFri", SqlDbType.Bit).Value = cbFri.Checked
            DBCmd.Parameters.Add("@AssignedSat", SqlDbType.Bit).Value = cbSat.Checked
            DBCmd.Parameters.Add("@AssignedSun", SqlDbType.Bit).Value = cbSun.Checked
            DBCmd.Parameters.Add("@HoursAssigned", SqlDbType.VarChar).Value = txtHourAssigned.Text
            DBCmd.Parameters.Add("@IsInterviewScheduled", SqlDbType.VarChar).Value = radInterviewScheduled.SelectedValue
            'DBCmd.Parameters.Add("@InterviewDate", SqlDbType.VarChar).Value = txtInterviewDate.Text
            DBCmd.Parameters.Add("@InterviewDate", SqlDbType.VarChar)
            If txtInterviewDate.Text = "" Then
                DBCmd.Parameters("@InterviewDate").Value = SqlTypes.SqlDateTime.Null
            Else
                DBCmd.Parameters("@InterviewDate").Value = txtInterviewDate.Text
            End If
            DBCmd.Parameters.Add("@IsCandidateAssigned", SqlDbType.VarChar).Value = radIsCandidateAssigned.SelectedValue
            'DBCmd.Parameters.Add("@StartDate", SqlDbType.VarChar).Value = txtStartDate.Text
            DBCmd.Parameters.Add("@StartDate", SqlDbType.VarChar)
            If txtStartDate.Text = "" Then
                DBCmd.Parameters("@StartDate").Value = SqlTypes.SqlDateTime.Null
            Else
                DBCmd.Parameters("@StartDate").Value = txtStartDate.Text
            End If
            'DBCmd.Parameters.Add("@ProjectedEndDate", SqlDbType.VarChar).Value = txtProjEndDate.Text
            DBCmd.Parameters.Add("@ProjectedEndDate", SqlDbType.VarChar)
            If txtProjEndDate.Text = "" Then
                DBCmd.Parameters("@ProjectedEndDate").Value = SqlTypes.SqlDateTime.Null
            Else
                DBCmd.Parameters("@ProjectedEndDate").Value = txtProjEndDate.Text
            End If
            ''DBCmd.Parameters.Add("@ActualEndDate", SqlDbType.VarChar).Value = txtActEndDate.Text
            'DBCmd.Parameters.Add("@ActualEndDate", SqlDbType.VarChar)
            'If txtActEndDate.Text = "" Then
            '    DBCmd.Parameters("@ActualEndDate").Value = SqlTypes.SqlDateTime.Null
            'Else
            '    DBCmd.Parameters("@ActualEndDate").Value = txtActEndDate.Text
            'End If
            'DBCmd.Parameters.Add("@ReasonForTermination", SqlDbType.VarChar).Value = ddlReasonTermination.SelectedValue
            DBCmd.Parameters.Add("@Comments", SqlDbType.VarChar).Value = txtComments.Text
            DBCmd.Parameters.Add("@LastUpdatedBy", SqlDbType.VarChar).Value = varUserName.ToString
            DBCmd.Parameters.Add("@IPAddress", SqlDbType.VarChar).Value = varIPAddress.ToString
            DBCmd.Parameters.Add("@ClientBrowser", SqlDbType.VarChar).Value = varBrowser.ToString

            'DBCmd.ExecuteNonQuery()
            'lblApplicantID.Text = DBCmd.ExecuteScalar()
            Dim priKey As Integer = DBCmd.ExecuteScalar()
            'If priKey < 0 Then
            '    Server.Transfer("ApplicantDupSSN.aspx")
            'Else
            Session("ApplicantID") = priKey
            'End If

        Catch exp As Exception
            Response.Write(exp)
        End Try
        'Close Database connection 
        'and Dispose Database objects 
        DBCmd.Dispose()
        'DBAdap.Dispose()
        DBConn.Close()
        DBConn = Nothing

    End Sub

    Protected Sub UpdateApplicantRecord()

        'Use Stored Procedure to add keyWorksiteId and keyEmployerID to Applicant record.
        Dim sConnStr As String = ConfigurationManager.ConnectionStrings("CSPConnectionString1").ConnectionString
        Dim cnBKTest As New SqlConnection(sConnStr)
        Dim cmdTest As New SqlCommand("CSP.dbo.spUpdate_Applicants_EmployerID_WorksiteID", cnBKTest)
        cmdTest.CommandType = Data.CommandType.StoredProcedure
        'Pass parameteres to stored procedure.
        'cmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = TextBox2.Text; 
        cmdTest.Parameters.Add(New SqlParameter("@JobTitle", Data.SqlDbType.VarChar, 10))
        cmdTest.Parameters.Add(New SqlParameter("@JobTitle2", Data.SqlDbType.VarChar, 10))
        cmdTest.Parameters("@JobTitle").Value = ddlWorkSlot1.SelectedValue
        cmdTest.Parameters("@JobTitle2").Value = ddlWorkSlot2.SelectedValue
        'Close Database Connection
        cnBKTest.Open()
        cmdTest.ExecuteNonQuery()
        cnBKTest.Close()

    End Sub

    Protected Sub UpdateJobTitleRecord()

        'Use Stored Procedure to add keyWorksiteId and keyEmployerID to JobTitle record.
        Dim sConnStr2 As String = ConfigurationManager.ConnectionStrings("CSPConnectionString1").ConnectionString
        Dim cnBKTest2 As New SqlConnection(sConnStr2)
        Dim cmdTest2 As New SqlCommand("CSP.dbo.spUpdate_JobTitles_ApplicantID", cnBKTest2)
        cmdTest2.CommandType = Data.CommandType.StoredProcedure
        'Pass parameteres to stored procedure.
        'cmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = TextBox2.Text; 
        cmdTest2.Parameters.Add(New SqlParameter("@JobTitle", Data.SqlDbType.VarChar, 10))
        cmdTest2.Parameters.Add(New SqlParameter("@JobTitle2", Data.SqlDbType.VarChar, 10))
        cmdTest2.Parameters.Add(New SqlParameter("@NewApplicantID", Data.SqlDbType.VarChar, 10))
        cmdTest2.Parameters("@JobTitle").Value = ddlWorkSlot1.SelectedValue
        cmdTest2.Parameters("@JobTitle2").Value = ddlWorkSlot2.SelectedValue
        cmdTest2.Parameters("@NewApplicantID").Value = Session("ApplicantID")
        'Close Database Connection
        cnBKTest2.Open()
        cmdTest2.ExecuteNonQuery()
        cnBKTest2.Close()

    End Sub

End Class

Open in new window


Config.sys:
<?xml version="1.0"?>
<configuration>
  <appSettings>
    <add key="gCSP" value="WorkForce One Community Service Program"/>
  </appSettings>
  <connectionStrings>
    <remove name="CSPConnectionString1"/>
    <add name="CSPConnectionString1" connectionString="Data Source=XXXSQLSERVER.DOMAIN.org;Initial Catalog=CSP;Integrated Security=True" providerName="System.Data.SqlClient"/>
  </connectionStrings>
  <system.web>
    <!-- 
            Set compilation debug="true" to insert debugging 
            symbols into the compiled page. Because this 
            affects performance, set this value to true only 
            during development.

            Visual Basic options:
            Set strict="true" to disallow all data type conversions 
            where data loss can occur. 
            Set explicit="true" to force declaration of all variables.
        -->
    <compilation debug="true" strict="false" explicit="true" targetFramework="4.0">
      <assemblies>
        <add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
        <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
        <add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
        <add assembly="System.DirectoryServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
      </assemblies>
    </compilation>
    <pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID">
      <namespaces>
        <clear/>
        <add namespace="System"/>
        <add namespace="System.Collections"/>
        <add namespace="System.Collections.Generic"/>
        <add namespace="System.Collections.Specialized"/>
        <add namespace="System.Configuration"/>
        <add namespace="System.Text"/>
        <add namespace="System.Text.RegularExpressions"/>
        <add namespace="System.Linq"/>
        <add namespace="System.Xml.Linq"/>
        <add namespace="System.Web"/>
        <add namespace="System.Web.Caching"/>
        <add namespace="System.Web.SessionState"/>
        <add namespace="System.Web.Security"/>
        <add namespace="System.Web.Profile"/>
        <add namespace="System.Web.UI"/>
        <add namespace="System.Web.UI.WebControls"/>
        <add namespace="System.Web.UI.WebControls.WebParts"/>
        <add namespace="System.Web.UI.HtmlControls"/>
      </namespaces>
      <controls>
        <add namespace="AjaxControlToolkit" assembly="AjaxControlToolkit" tagPrefix="cc1"/>
      </controls>
    </pages>
    <!--
            The <authentication> section enables configuration 
            of the security authentication mode used by 
            ASP.NET to identify an incoming user. 
        -->
    <authentication mode="Windows"/>
    <identity impersonate="true" password="XXXXXXXXXXX" userName="XXXXXXXXXXX"/>
    <!--
            The <customErrors> section enables configuration 
            of what to do if/when an unhandled error occurs 
            during the execution of a request. Specifically, 
            it enables developers to configure html error pages 
            to be displayed in place of a error stack trace.
        -->
    <customErrors mode="Off" defaultRedirect="GenericErrorPage.htm">
      <error statusCode="403" redirect="NoAccess.htm"/>
      <error statusCode="404" redirect="FileNotFound.htm"/>
    </customErrors>
  </system.web>
  <!-- 
        The system.webServer section is required for running ASP.NET AJAX under Internet
        Information Services 7.0.  It is not necessary for previous version of IIS.
    -->
</configuration>

Open in new window

0
 
LVL 1

Accepted Solution

by:
megnin earned 0 total points
Comment Utility
Well, the design view is back.

First I restored a copy of the old files from before I renamed them, from an archived .zip file.
Still no design view.  That was puzzling.

Then I copied the code out of the two file into notepad, deleted the files and created a new .aspx page with a different name and pasted the code into it.  Still no design view.

Finally, I started deleting commented out code from the .aspx page.
I just deleted the comments from the head section and a few between <body> and <cc1:ToolkitScriptManager >

I saved it and the design view came back.  I'll have to go through the comments line by line to see which one caused the problem.

Thank you for you help.
0
 
LVL 1

Author Closing Comment

by:megnin
Comment Utility
I resolved the issue on my own by deleting the comments.  There was apparently something in the commented out code that was causing the problem or even a poorly formed comment.  I have yet to investigate that.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now