<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<!--#include virtual="Connections/test.asp" -->
<!--#include virtual="scriptlets/functions.asp" -->
<%Session.LCID = 2057;%>

<!--SECTION TO ADD ARRAY FRM ENTRY SPREADSHEETS-->


<%
champsID=14
clubID=66

var competitors= new Array();// array to hold all the competitorID
var solos= new Array();
var ropes=new Array();
var teams=new Array();


//to list arrays copied from Spreadsheet
competitors[1]=new Array(0,'Jackson','Alexander','31307152','M','21/05/2001');
competitors[2]=new Array(0,'Bevan','Benjamin','31319058','M','25/02/2001');
competitors[3]=new Array(0,'Bower','James','31324132','M','02/11/2000');
competitors[4]=new Array(0,'Betteridge','Luke','200','M','15/05/2003');
competitors[5]=new Array(0,'Inett','Lucy','200','F','21/09/2002');
competitors[6]=new Array(0,'Amy','Weston','31318491','F','04/09/2001');
competitors[7]=new Array(0,'Mehaffey','Connor','31323156','M','01/12/2000');
competitors[8]=new Array(0,'Turton','Adam','31307151','M','10/10/2001');
competitors[9]=new Array(0,'Turton','Jack','31254811','M','25/03/1997');
competitors[10]=new Array(0,'Betteridge','Jack','31285718','M','01/02/2000');
competitors[11]=new Array(0,'Gale','Rhainne','31269358','F','26/01/2000');
solos[1]=new Array(1,12,'JB',83.57);
solos[2]=new Array(1,4,'JB',81.99);
solos[3]=new Array(1,2,'JB',51.55);
solos[4]=new Array(2,12,'JB',88.39);
solos[5]=new Array(2,4,'JB',71);
solos[6]=new Array(2,2,'JB',43.69);
solos[7]=new Array(3,12,'JB',92);
solos[8]=new Array(3,4,'JB',85);
solos[9]=new Array(3,2,'JB',55);
solos[10]=new Array(4,12,'JB',96);
solos[11]=new Array(4,4,'JB',93);
solos[12]=new Array(4,2,'JB',58);
solos[13]=new Array(5,12,'JG',93);
solos[14]=new Array(5,4,'JG',94);
solos[15]=new Array(5,2,'JG',56);
solos[16]=new Array(6,12,'JG',75.15);
solos[17]=new Array(6,4,'JG',71.09);
solos[18]=new Array(6,2,'JG',40.26);
solos[19]=new Array(7,12,'JB',99.13);
solos[20]=new Array(7,4,'JB',87.36);
solos[21]=new Array(7,2,'JB',55.68);
solos[22]=new Array(7,5,'SB',89.26);
solos[23]=new Array(8,12,'SB',97.3);
solos[24]=new Array(8,4,'SB',84.67);
solos[25]=new Array(8,2,'SB',56);
solos[26]=new Array(8,5,'SB',84);
solos[27]=new Array(9,1,'M',195);
solos[28]=new Array(9,4,'M',92.96);
solos[29]=new Array(9,2,'M',54);
solos[30]=new Array(9,5,'M',80.17);
solos[31]=new Array(10,12,'SB',70.53);
solos[32]=new Array(10,4,'SB',68.79);
solos[33]=new Array(10,2,'SB',42.32);
solos[34]=new Array(10,5,'SB',75.5);
solos[35]=new Array(11,12,'SG',83.95);
solos[36]=new Array(11,4,'SG',124.7);
solos[37]=new Array(11,2,'SG',56.33);
solos[38]=new Array(11,5,'SG',88);
ropes[1]=new Array(1,1,28,'JB',17.02);
ropes[2]=new Array(2,2,28,'JB',14.85);
ropes[3]=new Array(3,3,28,'JB',30);
ropes[4]=new Array(4,4,28,'JB',30);
ropes[5]=new Array(5,5,28,'JG',30);
ropes[6]=new Array(6,6,28,'JG',30);
ropes[7]=new Array(7,7,21,'SB',25);
ropes[8]=new Array(8,8,21,'SB',19);
ropes[9]=new Array(9,9,21,'M',19);
ropes[10]=new Array(10,10,21,'SB',25);
ropes[11]=new Array(11,11,21,'SG',25);
teams[1]=new Array('A',1,3,4,2,8,'JB',123.33);
teams[2]=new Array('A',1,3,4,2,9,'JB',155.57);
teams[3]=new Array('A',1,3,4,2,10,'JB',139.4);
teams[4]=new Array('A',9,7,9,4,8,'M',120);
teams[5]=new Array('A',9,7,9,4,9,'M',140);
teams[6]=new Array('A',9,7,9,4,10,'M',135);


%>

<!--adds TeamMembers to System-->
<%


  for (var i=1;i<competitors.length;i++){
	  var addCompetitor=Server.CreateObject('ADODB.Command');
  addCompetitor.ActiveConnection=BULSCA_CON_STRING;
	addCompetitor.CommandText ="INSERT INTO CHAMPS_Competitors(RLSS_NUMBER,First_Name,Last_Name,DOB,Club_ID,CHAMPS_ID,Type,last_amended,amended_by,time_added,added_by) VALUES ("+String(competitors[i][3])+",'"+SQLinjectionStop(String(competitors[i][2]))+"','"+SQLinjectionStop(String(competitors[i][1]))+"','"+String(competitors[i][5])+" 00:00',"+clubID+","+champsID+",'"+String(competitors[i][4])+"',Date(),'"+String(Session("Username"))+"',Date(),'"+String(Session("Username"))+"')" ;
	addCompetitor.Execute();
	addCompetitor.ActiveConnection.Close();
	
	
	//adds competitors on-line ID to the array
	
  var getID = Server.CreateObject("ADODB.Recordset");
	getID.ActiveConnection = BULSCA_CON_STRING;
	getID.Source = "SELECT `competitor_ID` FROM  CHAMPS_Competitors  WHERE `RLSS_NUMBER` = "+competitors[i][3]+" AND `CHAMPS_ID` ="+champsID+" AND `CLUB_ID` ="+clubID+" ORDER BY competitor_ID DESC";
	getID.CursorType = 0;
	getID.CursorLocation = 2;
	getID.LockType = 1;
	getID.Open();
	competitors[i][0]=getID.Fields.Item("competitor_ID").Value;
	getID.Close();
		
  }

%>
Complete <br><%=competitors[1][0]%><br><%=competitors[2][0]%><br><%=competitors[3][0]%><br><%=competitors[4][0]%>


<!--adds Solo Races to System-->
<%
for (var i=1;i<solos.length;i++){

// for the new team must create the master record first before puttign the swim tow time in
  var addEntry=Server.CreateObject('ADODB.Command');
  addEntry.ActiveConnection=BULSCA_CON_STRING;
  addEntry .CommandText ="INSERT INTO CHAMPS_SPEED_ENTRIES  (`EVENT_ID`,`SEX`, `CHAMPS_ID`, `Club_ID`,`time_added`,`added_by` ) VALUES  ("+solos[i][1]+",'"+solos[i][2]+"',"+String(champsID)+","+String(clubID)+",Date(),'"+String(Session("Username"))+"')";
  addEntry.Execute();
  addEntry.ActiveConnection.Close();
  var getID = Server.CreateObject("ADODB.Recordset");
	getID.ActiveConnection = BULSCA_CON_STRING;
	getID.Source = "SELECT `ENTRY_ID` FROM  CHAMPS_SPEED_ENTRIES  WHERE `EVENT_ID` = "+solos[i][1]+" AND `CHAMPS_ID` ="+champsID+" AND `CLUB_ID` ="+clubID+" ORDER BY ENTRY_ID DESC";
	getID.CursorType = 0;
	getID.CursorLocation = 2;
	getID.LockType = 1;
	getID.Open();
	entryID=getID.Fields.Item("ENTRY_ID").Value;
	getID.Close();

var teamDetails = Server.CreateObject('ADODB.Command');
  teamDetails .ActiveConnection = BULSCA_CON_STRING;
  var entryTime=solos[i][3]
  teamDetails .CommandText ="insert into CHAMPS_ENTRIES_DETAILS_1(`ENTRY_ID`,`Type`, `Competitor_ID_1`, `ENTRY_TIME`, `time_added`,`added_by`) values ("+entryID+",'S',"+competitors[solos[i][0]][0]+","+entryTime+",Date(),'"+String(Session("Username"))+"')" ;
  teamDetails .Execute();
  teamDetails .ActiveConnection.Close(); 
  }
  

  %>
  
  
<!--adds Rope Races to System-->
<%for (var i=1;i<ropes.length;i++){

var addEntry=Server.CreateObject('ADODB.Command');
  addEntry.ActiveConnection=BULSCA_CON_STRING;
  addEntry .CommandText ="INSERT INTO CHAMPS_SPEED_ENTRIES  (`EVENT_ID`,`SEX`, `CHAMPS_ID`, `Club_ID`,`time_added`,`added_by` ) VALUES  ("+ropes[i][2]+",'"+ropes[i][3]+"',"+String(champsID)+","+String(clubID)+",Date(),'"+String(Session("Username"))+"')";
  addEntry.Execute();
  addEntry.ActiveConnection.Close();
  var getID = Server.CreateObject("ADODB.Recordset");
	getID.ActiveConnection = BULSCA_CON_STRING;
	getID.Source = "SELECT `ENTRY_ID` FROM  CHAMPS_SPEED_ENTRIES  WHERE `EVENT_ID` = "+ropes[i][2]+" AND `CHAMPS_ID` ="+champsID+" AND `CLUB_ID` ="+clubID+" ORDER BY ENTRY_ID DESC";
	getID.CursorType = 0;
	getID.CursorLocation = 2;
	getID.LockType = 1;
	getID.Open();
	entryID=getID.Fields.Item("ENTRY_ID").Value;
	getID.Close();

var teamDetails = Server.CreateObject('ADODB.Command');
  teamDetails .ActiveConnection = BULSCA_CON_STRING;
  var entryTime=ropes[i][4]
  teamDetails .CommandText ="insert into CHAMPS_ENTRIES_DETAILS_2(`ENTRY_ID`,`Type`, `Competitor_ID_1`, `Competitor_ID_2`, `ENTRY_TIME`, `time_added`,`added_by`) values ("+entryID+",'S',"+competitors[ropes[i][0]][0]+","+competitors[ropes[i][1]][0]+","+entryTime+",Date(),'"+String(Session("Username"))+"')" ;
  teamDetails .Execute();
  teamDetails .ActiveConnection.Close();
}
%>


<!--adds Team Races to System-->
<%for (var i=1;i<teams.length;i++){


  var addEntry=Server.CreateObject('ADODB.Command');
  addEntry.ActiveConnection=BULSCA_CON_STRING;
  addEntry .CommandText ="INSERT INTO CHAMPS_SPEED_ENTRIES  (`EVENT_ID`,`SEX`, `CHAMPS_ID`, `Club_ID`,`time_added`,`added_by` ) VALUES  ("+teams[i][5]+",'"+String(teams[i][6])+"',"+String(champsID)+","+String(clubID)+",Date(),'"+String(Session("Username"))+"')";
  addEntry.Execute();
  addEntry.ActiveConnection.Close();
  var getID = Server.CreateObject("ADODB.Recordset");
	getID.ActiveConnection = BULSCA_CON_STRING;
	getID.Source = "SELECT `ENTRY_ID` FROM  CHAMPS_SPEED_ENTRIES  WHERE `EVENT_ID` = "+teams[i][5]+" AND `CHAMPS_ID` ="+champsID+" AND `CLUB_ID` ="+clubID+" ORDER BY ENTRY_ID DESC";
	getID.CursorType = 0;
	getID.CursorLocation = 2;
	getID.LockType = 1;
	getID.Open();
	entryID=getID.Fields.Item("ENTRY_ID").Value;
	getID.Close();

var teamDetails = Server.CreateObject('ADODB.Command');
  teamDetails .ActiveConnection = BULSCA_CON_STRING;
  var entryTime=teams[i][7]
  teamDetails .CommandText ="insert into CHAMPS_ENTRIES_DETAILS_4(`ENTRY_ID`,`Type`, `Competitor_ID_1`, `Competitor_ID_2`, `Competitor_ID_3`, `Competitor_ID_4`, `ENTRY_TIME`, `time_added`,`added_by`) values ("+entryID+",'S',"+competitors[teams[i][1]][0]+","+competitors[teams[i][2]][0]+","+competitors[teams[i][3]][0]+","+competitors[teams[i][4]][0]+","+entryTime+",Date(),'"+String(Session("Username"))+"')" ;
  teamDetails .Execute();
  teamDetails .ActiveConnection.Close();

if(teams[i][0]!=0){
//code to submitt team name if one providded to optimise space as not saving it when not required.

var teamName = Server.CreateObject('ADODB.Command');
  teamName .ActiveConnection = BULSCA_CON_STRING;
  teamName .CommandText ="INSERT INTO CHAMPS_TEAMNAMES ( Entry_ID_4, Description ) SELECT CHAMPS_ENTRIES_DETAILS_4.ENTRIES_DETAILS_4_ID,' "+teams[i][0]+"' AS Expr1 FROM CHAMPS_ENTRIES_DETAILS_4 WHERE (((CHAMPS_ENTRIES_DETAILS_4.ENTRIES_DETAILS_4_ID)=(SELECT Max(CHAMPS_ENTRIES_DETAILS_4.ENTRIES_DETAILS_4_ID) AS MaxOfENTRIES_DETAILS_4_ID FROM  CHAMPS_ENTRIES_DETAILS_4 GROUP BY CHAMPS_ENTRIES_DETAILS_4.ENTRY_ID HAVING (((CHAMPS_ENTRIES_DETAILS_4.ENTRY_ID)="+entryID+")))));";
  teamName .Execute();
  teamName .ActiveConnection.Close();
}
}
%>