<%@language=jscript%>
<!--METADATA TYPE="typelib" FILE="C:\Program Files\Common Files\System\ado\msado15.dll"-->
<!--#include file="easygen_functions.asp"-->
<% 

var eg_objConn1;
var eg_result1;
var eg_result3;
// Connect to database
eg_objConn1 = Server.CreateObject("ADODB.Connection");
eg_objConn1.Open("Provider=SQLOLEDB;Password=201aq+zz;Persist Security Info=True;User ID=pathfinderdb1;Initial Catalog=pathfinderdb;Data Source=sql6.prosql.net;");

//firstly see if the email address has been used before - if so reject order process. 
var emailstr=String(Request.Form("email")).replace(/'/g, "''");
eg_Result3 = eg_objConn1.Execute("SELECT count(*) from internetbizcouk where email='"+emailstr+"'", 1, adCmdText);

if (eg_Result3(0)>0 )
	{
	delete eg_Result3;
	delete eg_objConn1;
	Response.Redirect("duplicateemailaddress.asp");
	}
eg_Result1 = eg_objConn1.Execute("SELECT Setting from Settings WHERE Setting_ID='internetbiz-com_order_no'", 1, adCmdText);

var firstnamestr=String(Request.Form("firstname")).replace(/'/g, "''");
var secondnamestr=String(Request.Form("secondname")).replace(/'/g, "''");
var telephonestr=String(Request.Form("telephone")).replace(/'/g, "''");

var thepasswordstr=String(Request.Form("thepassword")).replace(/'/g, "''");
var address1str=String(Request.Form("add1")).replace(/'/g, "''");
var address2str=String(Request.Form("add2")).replace(/'/g, "''");
var townstr=String(Request.Form("Town")).replace(/'/g, "''");
var countystr=String(Request.Form("county")).replace(/'/g, "''");
var postcodestr=String(Request.Form("postcode")).replace(/'/g, "''");
var countrystr=String(Request.Form("Country")).replace(/'/g, "''");
var eg_date = new Date();
var eg_date1 = eg_date.formatDate("Ymj");
var eg_ordernum=eg_Result1("setting");
// Response.write("insert into internetbizcouk (firstname, secondname, telephone, email, thepassword,orderdate, ordernum, temp_access_flag, address1, address2, town, county, postcode) values('"+firstnamestr+"','" +secondnamestr+"','"+telephonestr+"','"+emailstr+"','"+thepasswordstr+"','"+eg_date1+"',"+eg_ordernum+",'N'"+"',"+address1str+"','"+address2str+"','"+townstr+"','"+countystr+"','"+postcodestr+"','"+countrystr+"')");
eg_objConn1.Execute("insert into internetbizcom (firstname, secondname, telephone, email, thepassword,orderdate, ordernum, temp_access_flag, address1, address2, town, county, postcode, country) values('"+firstnamestr+"','" +secondnamestr+"','"+telephonestr+"','"+emailstr+"','"+thepasswordstr+"','"+eg_date1+"',"+eg_ordernum+",'Y'"+",'"+address1str+"','"+address2str+"','"+townstr+"','"+countystr+"','"+postcodestr+"','"+countrystr+"')");
var NextOrderNum = parseInt(eg_ordernum)+1;
eg_objConn1.Execute("Update Settings Set Setting='"+NextOrderNum+ "' WHERE Setting_ID='internetbiz-com_order_no'", 1, adCmdText);

var oemail;
oemail = Server.CreateObject("Dynu.Email");
oemail.host="mail.internetbizsolution.com";
oemail.AddAddress(emailstr);
oemail.From = "noreply@internetbizsolution.com"
oemail.Subject = "Online Web Marketing Training (Trial) Order"
oemail.body="Thank you once again for your purchase." + String.fromCharCode(13,10)+ String.fromCharCode(13,10)+ "Your username (email address) is: "+ emailstr + String.fromCharCode(13,10)+ String.fromCharCode(13,10)+"Your chosen Password is:  "+thepasswordstr+ String.fromCharCode(13,10)+ String.fromCharCode(13,10)+ String.fromCharCode(13,10)+"Now here are your easy log on instructions to assess the course materials. " + String.fromCharCode(13,10)+String.fromCharCode(13,10)+  "Step 1: Log on to http://www.InternetBizSolution.co.uk" +String.fromCharCode(13,10)+ "Step 2: Enter your Username (email address) and Password into respective Log in boxes after you have logged onto the site. "+String.fromCharCode(13,10)+ "Step 3: Click on the 'Go' button" + String.fromCharCode(13,10) +"Step 4: That's it! Start to study at your own pace" + String.fromCharCode(13,10) +"Step 5: Put in to practice what you've learnt and go make a killing online." + String.fromCharCode(13,10) + String.fromCharCode(13,10) + "Thank you" + String.fromCharCode(13,10) +"Yours sincerely, " +String.fromCharCode(13,10) +"Joe Amagada" +  String.fromCharCode(13,10) +"http://www.InternetBizSolution.com" + String.fromCharCode(13,10) + "http://www.pathfinderpublications.com";
oemail.send();
delete oemail;
%>
<html>
<head>
<title>Order Complete!</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<p><font face="Arial, Helvetica, sans-serif">Your order reference is <strong><%=eg_ordernum%>. </strong></font><font face="Arial, Helvetica, sans-serif">Your 
  details have been submitted.</font></p>
<p><font face="Arial, Helvetica, sans-serif">You will receive an email shortly 
  detailing how to access the training materials. However, below is a summary 
  of how to access the course material: - </font></p>
<table width="80%" border="1" cellpadding="10" cellspacing="0" bordercolor="#0066CC">
  <tr>
    <td><p><font size="-1" face="Arial, Helvetica, sans-serif">Step 1: Log on 
        to <a href="http://www.InternetBizSolution.com" target="_blank">http://www.InternetBizSolution.com</a><br>
        Step 2: Enter your Username (<% Response.write(emailstr)%>) and Password (<% Response.write(thepasswordstr)%>) into the respective 
        log-in boxes.<br>
        Step 3: Click on the 'Go' button<br>
        Step 4: That's it! Start to study at your own pace Step 5: Put in to practice 
        what you've learnt and go make a killing online.</font></p>
      </td>
  </tr>
</table>
<p><font size="-1" face="Arial, Helvetica, sans-serif"><strong>Click <a href="javascript:window.print()"">here</a> 
  to print this page please</strong></font></p>
<P> </p><p><font size="-1" face="Arial, Helvetica, sans-serif">Thank you<br>
  Yours sincerely,<br>
  Joe Amagada<br>
  <a href="http://www.InternetBizSolution.com">http://www.InternetBizSolution.com</a><br>
  <a href="http://www.pathfinderpublications.com" target="_blank">http://www.pathfinderpublications.com</a> 
  <br>
  </font></p>
<p><font face="Arial, Helvetica, sans-serif">Thank you for your custom.</font></p>
<p><font face="Arial, Helvetica, sans-serif">Pathfinder Publications.</font></p>
</body>
</html>
<% 

delete eg_Result1;
delete eg_Result3;
// Close database connection
eg_objConn1.Close();
delete eg_objConn1;
%>