<%@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=56

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,'Dickerson Weedy','Eloise','31329376','F','05/04/2002');
competitors[2]=new Array(0,'Little','Jessica','31330160','F','08/06/2002');
competitors[3]=new Array(0,'Dickerson Weedy','Isadore','100','F','15/02/2004');
competitors[4]=new Array(0,'Gordon','Lauren','31301826','F','09/08/2001');
competitors[5]=new Array(0,'McCourt','Rhiannon','31297587','F','04/09/2001');
competitors[6]=new Array(0,'Wells','James','31266221','M','19/01/2001');
competitors[7]=new Array(0,'Huntley','Joseph','31321688','M','24/03/2002');
competitors[8]=new Array(0,'Meeson','Jesse','31330161','M','19/04/2002');
competitors[9]=new Array(0,'Todd','Trinity','31365558','F','16/08/2003');
competitors[10]=new Array(0,'Little','Beth','31216038','F','18/03/1999');
competitors[11]=new Array(0,'Douglas','Rebecca','31234260','F','16/06/1999');
competitors[12]=new Array(0,'Chandler','Beth','31216520','F','16/01/1999');
competitors[13]=new Array(0,'Chandler','Cadie','31216041','F','16/01/1999');
competitors[14]=new Array(0,'Gilroy','Callum','31215651','M','16/09/1999');
competitors[15]=new Array(0,'Douglas','Matthew','31234259','M','16/06/1999');
competitors[16]=new Array(0,'Meeson','Alfie','31284161','M','14/03/2000');
competitors[17]=new Array(0,'Carroll','Rachel','31142546','F','28/07/1997');
competitors[18]=new Array(0,'Parker','Jessica','31215872','F','23/07/1997');
competitors[19]=new Array(0,'McCallum','Mitchell','31142546','M','29/08/1997');
competitors[20]=new Array(0,'Weightman','Daniel','31142551','M','15/01/1997');
competitors[21]=new Array(0,'Merridth','Emily','100','F','21/10/2003');
competitors[22]=new Array(0,'Smith','Mitchell','31365695','M','02/10/2001');
competitors[23]=new Array(0,'King','Eleanor','100','F','08/03/2004');
competitors[24]=new Array(0,'Arkley','Daniel','100','M','12/03/1992');
competitors[25]=new Array(0,'Dixon','Ryan','31274844','M','09/12/1999');
competitors[26]=new Array(0,'Chandler','Mark','31353735','M','26/06/1970');
solos[1]=new Array(1,12,'JG',84.64);
solos[2]=new Array(1,4,'JG',75.64);
solos[3]=new Array(1,2,'JG',44.24);
solos[4]=new Array(2,12,'JG',81.47);
solos[5]=new Array(2,4,'JG',78.94);
solos[6]=new Array(2,2,'JG',44.05);
solos[7]=new Array(3,12,'JG',120);
solos[8]=new Array(3,4,'JG',110);
solos[9]=new Array(3,2,'JG',75);
solos[10]=new Array(4,12,'JG',77.05);
solos[11]=new Array(4,4,'JG',72.83);
solos[12]=new Array(4,2,'JG',42.13);
solos[13]=new Array(5,12,'JG',84.43);
solos[14]=new Array(5,4,'JG',72.83);
solos[15]=new Array(5,2,'JG',41.3);
solos[16]=new Array(6,12,'JB',74.62);
solos[17]=new Array(6,4,'JB',71.17);
solos[18]=new Array(6,2,'JB',37.84);
solos[19]=new Array(6,5,'SB',76.67);
solos[20]=new Array(7,12,'JB',78.58);
solos[21]=new Array(7,4,'JB',77.78);
solos[22]=new Array(7,2,'JB',42.36);
solos[23]=new Array(8,12,'JB',85.55);
solos[24]=new Array(8,4,'JB',78.81);
solos[25]=new Array(8,2,'JB',45.04);
solos[26]=new Array(9,12,'JG',95);
solos[27]=new Array(9,4,'JG',90);
solos[28]=new Array(9,2,'JG',45);
solos[29]=new Array(10,12,'SG',72.47);
solos[30]=new Array(10,4,'SG',66.68);
solos[31]=new Array(10,2,'SG',44.86);
solos[32]=new Array(10,5,'SG',68.14);
solos[33]=new Array(11,12,'SG',71.92);
solos[34]=new Array(11,4,'SG',71.44);
solos[35]=new Array(11,2,'SG',45.19);
solos[36]=new Array(11,5,'SG',73.01);
solos[37]=new Array(12,12,'SG',74);
solos[38]=new Array(12,4,'SG',70.84);
solos[39]=new Array(12,2,'SG',45.62);
solos[40]=new Array(12,5,'SG',72);
solos[41]=new Array(13,12,'SG',72.01);
solos[42]=new Array(13,4,'SG',67.57);
solos[43]=new Array(13,2,'SG',43.33);
solos[44]=new Array(13,5,'SG',72);
solos[45]=new Array(14,12,'SB',74.17);
solos[46]=new Array(14,4,'SB',62.47);
solos[47]=new Array(14,2,'SB',41.37);
solos[48]=new Array(14,5,'SB',70.55);
solos[49]=new Array(15,12,'SB',67.02);
solos[50]=new Array(15,4,'SB',69.9);
solos[51]=new Array(15,2,'SB',37.81);
solos[52]=new Array(15,5,'SB',67.39);
solos[53]=new Array(16,12,'SB',73.64);
solos[54]=new Array(16,4,'SB',68.24);
solos[55]=new Array(16,2,'SB',42.59);
solos[56]=new Array(16,5,'SB',71.64);
solos[57]=new Array(17,1,'F',179);
solos[58]=new Array(17,4,'F',59.48);
solos[59]=new Array(17,2,'F',41.28);
solos[60]=new Array(17,5,'F',64.39);
solos[61]=new Array(18,1,'F',158.73);
solos[62]=new Array(18,4,'F',70.9);
solos[63]=new Array(18,2,'F',45.04);
solos[64]=new Array(18,5,'F',69.56);
solos[65]=new Array(19,1,'M',135.11);
solos[66]=new Array(19,4,'M',55.06);
solos[67]=new Array(19,2,'M',34.14);
solos[68]=new Array(19,5,'M',60.86);
solos[69]=new Array(20,1,'M',147.21);
solos[70]=new Array(20,4,'M',57.11);
solos[71]=new Array(20,2,'M',34.72);
solos[72]=new Array(20,5,'M',60.86);
solos[73]=new Array(21,12,'JG',120);
solos[74]=new Array(21,4,'JG',110);
solos[75]=new Array(21,2,'JG',63);
solos[76]=new Array(22,12,'JB',115);
solos[77]=new Array(22,4,'JB',105);
solos[78]=new Array(22,2,'JB',50);
solos[79]=new Array(23,12,'JG',120);
solos[80]=new Array(23,4,'JG',100);
solos[81]=new Array(23,2,'JG',60);
solos[82]=new Array(24,4,'M',120);
solos[83]=new Array(24,2,'M',110);
solos[84]=new Array(24,5,'M',110);
solos[85]=new Array(25,12,'SB',105);
solos[86]=new Array(25,4,'SB',77.87);
solos[87]=new Array(25,2,'SB',50);
solos[88]=new Array(25,5,'SB',76.99);
solos[89]=new Array(26,4,'M',113.89);
solos[90]=new Array(26,5,'M',101.11);
ropes[1]=new Array(1,1,28,'JG',18);
ropes[2]=new Array(2,2,28,'JG',40);
ropes[3]=new Array(3,3,28,'JG',45);
ropes[4]=new Array(4,4,28,'JG',12.69);
ropes[5]=new Array(5,5,28,'JG',38.75);
ropes[6]=new Array(6,6,28,'JB',13.27);
ropes[7]=new Array(7,7,28,'JB',25);
ropes[8]=new Array(8,8,28,'JB',16);
ropes[9]=new Array(9,9,28,'JG',30);
ropes[10]=new Array(10,10,21,'SG',17);
ropes[11]=new Array(11,11,21,'SG',18);
ropes[12]=new Array(12,12,21,'SG',15.47);
ropes[13]=new Array(13,13,21,'SG',25);
ropes[14]=new Array(14,14,21,'SB',31.08);
ropes[15]=new Array(15,15,21,'SB',15);
ropes[16]=new Array(16,16,21,'SB',13.52);
ropes[17]=new Array(17,17,21,'F',15.78);
ropes[18]=new Array(18,18,21,'F',18.5);
ropes[19]=new Array(19,19,21,'M',11.65);
ropes[20]=new Array(20,20,21,'M',19);
ropes[21]=new Array(21,21,28,'JG',35);
ropes[22]=new Array(22,22,28,'JB',25);
ropes[23]=new Array(23,23,28,'JG',30);
ropes[24]=new Array(24,24,21,'M',40);
ropes[25]=new Array(25,25,21,'SB',29);
ropes[26]=new Array(26,26,21,'M',19.65);
teams[1]=new Array('B',2,1,5,4,8,'JG',105);
teams[2]=new Array('B',2,1,5,4,9,'JG',155);
teams[3]=new Array('B',2,1,5,4,10,'JG',135);
teams[4]=new Array('C',1,21,23,9,8,'JG',135);
teams[5]=new Array('C',1,21,23,9,9,'JG',180);
teams[6]=new Array('C',1,21,23,9,10,'JG',165);
teams[7]=new Array('A',22,8,7,6,8,'JB',100);
teams[8]=new Array('A',22,8,7,6,9,'JB',145);
teams[9]=new Array('A',22,8,7,6,10,'JB',130);
teams[10]=new Array('A',12,12,10,11,8,'SG',102.47);
teams[11]=new Array('A',12,12,10,11,9,'SG',132);
teams[12]=new Array('A',12,12,10,11,10,'SG',114.6);
teams[13]=new Array('A',25,14,16,15,8,'SB',94.1);
teams[14]=new Array('A',25,14,16,15,9,'SB',131.37);
teams[15]=new Array('A',25,14,16,15,10,'SB',115);
teams[16]=new Array('A',11,12,18,17,8,'F',106.76);
teams[17]=new Array('A',11,12,18,17,9,'F',135);
teams[18]=new Array('A',11,12,18,17,10,'F',120.29);
teams[19]=new Array('A',15,20,24,19,8,'M',115);
teams[20]=new Array('A',15,20,24,19,9,'M',165);
teams[21]=new Array('A',15,20,24,19,10,'M',166);


%>

<!--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();
}

}
%>