<%@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=18
clubID=27

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,'Cawley','Tegan','1','F','01/01/2004');
competitors[2]=new Array(0,'Maries','Holly','1','F','02/01/2004');
competitors[3]=new Array(0,'Thomas','Emily','1','F','03/01/2004');
competitors[4]=new Array(0,'Kenworthy','Lizzie','1','F','04/01/2004');
competitors[5]=new Array(0,'Selway','Daniel','1','M','05/01/2004');
competitors[6]=new Array(0,'Rackham','Thomas','1','M','06/01/2004');
competitors[7]=new Array(0,'Hallam','Ben','1','M','07/01/2004');
competitors[8]=new Array(0,'Bridgewood','Matthew','1','M','08/01/2004');
competitors[9]=new Array(0,'West','Courtney','1','F','09/01/2004');
competitors[10]=new Array(0,'Littlewood','Megan','1','F','10/01/2004');
competitors[11]=new Array(0,'Briggs','Isobel','1','F','11/01/2004');
competitors[12]=new Array(0,'Cooper-Smith','Jordan','1','M','12/01/2004');
competitors[13]=new Array(0,'Briggs.','Calum','1','M','13/01/2004');
competitors[14]=new Array(0,'Wright','Adam','1','M','14/01/2004');
competitors[15]=new Array(0,'Mason','Jack','1','M','15/01/2004');
competitors[16]=new Array(0,'Bridgewood','Jonathan','1','MC','16/01/2004');
competitors[17]=new Array(0,'Barrowcliffe','Zara','1','F','17/01/2004');
competitors[18]=new Array(0,'Tomlinson','Alex','1','M','18/01/2004');
competitors[19]=new Array(0,'Barrowcliffe','Jamie','1','M','19/01/2004');
competitors[20]=new Array(0,'Tomlinson.','Sarah','1','F','20/01/2004');
competitors[21]=new Array(0,'Cook','Daisy','1','F','21/01/2004');
competitors[22]=new Array(0,'Churchill','Phoebe','1','F','22/01/2004');
solos[1]=new Array(1,13,'JG',24.91);
solos[2]=new Array(1,23,'JG',45.25);
solos[3]=new Array(1,15,'JG',43.95);
solos[4]=new Array(1,14,'JG',50);
solos[5]=new Array(2,13,'JG',24);
solos[6]=new Array(2,23,'JG',44.47);
solos[7]=new Array(2,15,'JG',41.16);
solos[8]=new Array(2,14,'JG',48);
solos[9]=new Array(3,13,'JG',25.22);
solos[10]=new Array(3,23,'JG',47.41);
solos[11]=new Array(3,15,'JG',41.69);
solos[12]=new Array(3,14,'JG',52);
solos[13]=new Array(4,13,'JG',21.28);
solos[14]=new Array(4,23,'JG',39.43);
solos[15]=new Array(4,15,'JG',40.36);
solos[16]=new Array(4,14,'JG',45);
solos[17]=new Array(5,13,'JB',22.36);
solos[18]=new Array(5,23,'JB',37.85);
solos[19]=new Array(5,15,'JB',42.42);
solos[20]=new Array(5,14,'JB',52);
solos[21]=new Array(6,13,'JB',19);
solos[22]=new Array(6,23,'JB',33);
solos[23]=new Array(6,15,'JB',38);
solos[24]=new Array(6,14,'JB',45);
solos[25]=new Array(7,13,'JB',35);
solos[26]=new Array(7,23,'JB',50);
solos[27]=new Array(7,15,'JB',50);
solos[28]=new Array(7,14,'JB',60);
solos[29]=new Array(8,13,'JB',28.84);
solos[30]=new Array(8,23,'JB',50.08);
solos[31]=new Array(8,15,'JB',45);
solos[32]=new Array(8,14,'JB',60);
solos[33]=new Array(9,13,'SG',26);
solos[34]=new Array(9,23,'SG',41.1);
solos[35]=new Array(9,15,'SG',45);
solos[36]=new Array(9,16,'SG',40);
solos[37]=new Array(10,13,'SG',24);
solos[38]=new Array(10,23,'SG',37.04);
solos[39]=new Array(10,15,'SG',45);
solos[40]=new Array(10,16,'SG',40);
solos[41]=new Array(11,13,'SG',25.09);
solos[42]=new Array(11,23,'SG',35.46);
solos[43]=new Array(11,15,'SG',40.92);
solos[44]=new Array(11,16,'SG',40);
solos[45]=new Array(12,13,'SB',24);
solos[46]=new Array(12,23,'SB',34.57);
solos[47]=new Array(12,15,'SB',45);
solos[48]=new Array(12,16,'SB',40);
solos[49]=new Array(13,13,'M',18.63);
solos[50]=new Array(13,23,'M',29.82);
solos[51]=new Array(13,15,'M',27.4);
solos[52]=new Array(13,16,'M',33.7);
solos[53]=new Array(14,13,'M',20.14);
solos[54]=new Array(14,23,'M',33.52);
solos[55]=new Array(14,15,'M',30);
solos[56]=new Array(14,16,'M',36.57);
solos[57]=new Array(15,13,'M',22.44);
solos[58]=new Array(15,23,'M',36.25);
solos[59]=new Array(15,15,'M',32.91);
solos[60]=new Array(15,16,'M',33.9);
solos[61]=new Array(16,13,'MaM',25);
solos[62]=new Array(16,23,'MaM',40);
solos[63]=new Array(16,15,'MaM',40);
solos[64]=new Array(16,16,'MaM',40);
solos[65]=new Array(17,33,'RG9',30);
solos[66]=new Array(17,13,'RG9',60);
solos[67]=new Array(17,34,'RG9',30);
solos[68]=new Array(17,35,'RG9',30);
solos[69]=new Array(18,33,'RB11',25.08);
solos[70]=new Array(18,13,'RB11',48.72);
solos[71]=new Array(18,34,'RB11',30.78);
solos[72]=new Array(18,35,'RB11',21.43);
solos[73]=new Array(19,33,'RB11',24.32);
solos[74]=new Array(19,13,'RB11',41.39);
solos[75]=new Array(19,34,'RB11',20.46);
solos[76]=new Array(19,35,'RB11',19.45);
solos[77]=new Array(20,33,'RG11',20.74);
solos[78]=new Array(20,13,'RG11',27.82);
solos[79]=new Array(20,34,'RG11',32.18);
solos[80]=new Array(20,35,'RG11',17.84);
solos[81]=new Array(21,33,'RG11',21.22);
solos[82]=new Array(21,13,'RG11',27.84);
solos[83]=new Array(21,34,'RG11',22.2);
solos[84]=new Array(21,35,'RG11',17.37);
solos[85]=new Array(22,33,'RG11',22.8);
solos[86]=new Array(22,13,'RG11',33.02);
solos[87]=new Array(22,34,'RG11',41.36);
solos[88]=new Array(22,35,'RG11',16.82);
teams[1]=new Array('',18,20,19,18,37,'RB11',0);
teams[2]=new Array('',18,20,19,18,36,'RB11',0);
teams[3]=new Array('',9,11,13,22,19,'F',0);
teams[4]=new Array('',9,11,13,22,20,'F',0);
teams[5]=new Array('',9,11,13,22,18,'F',0);
teams[6]=new Array('',11,14,15,8,19,'M',0);
teams[7]=new Array('',11,14,15,8,20,'M',0);
teams[8]=new Array('',11,14,15,8,18,'M',0);


%>

<!--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


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

}%>