public List <ParticipantsData> SelectAllParticipantsForStage3()
{
cmd = new SqlCommand("SELECT Id, parName, parSurname, parNumber, parAgeGroup, parRaceTime3, parPoints3 FROM Participants Order by parPoints3 DESC", conn);
reader = cmd.ExecuteReader();
List <ParticipantsData> result = new List <ParticipantsData>();
while (reader.Read())
{
ParticipantsData data = new ParticipantsData();
data.Id = Convert.ToInt32(reader["Id"]);
data.parName = Convert.ToString(reader["parName"]);
data.parSurname = Convert.ToString(reader["parSurname"]);
data.parNumber = Convert.ToInt32(reader["parNumber"]);
data.parAgeGroup = Convert.ToString(reader["parAgeGroup"]);
data.parRaceTime3 = Convert.ToInt32(reader["parRaceTime3"]);
if (data.parRaceTime3 == 999999999)
{
data.parRaceTime3 = 0;
}
data.parPoints3 = Convert.ToInt32(reader["parPoints3"]);
result.Add(data);
}
reader.Close();
return(result);
}
public List <ParticipantsData> SelectAllParticipants()
{
ResultsManager resultsManager = new ResultsManager();
cmd = new SqlCommand("SELECT * FROM Participants Order by parPointsSum DESC", conn);
reader = cmd.ExecuteReader();
List <ParticipantsData> result = new List <ParticipantsData>();
while (reader.Read())
{
ParticipantsData data = new ParticipantsData();
data.Id = Convert.ToInt32(reader["Id"]);
data.parName = Convert.ToString(reader["parName"]);
data.parSurname = Convert.ToString(reader["parSurname"]);
data.parNumber = Convert.ToInt32(reader["parNumber"]);
data.parAgeGroup = Convert.ToString(reader["parAgeGroup"]);
data.parPoints1 = Convert.ToInt32(reader["parPoints1"]);
data.parPoints2 = Convert.ToInt32(reader["parPoints2"]);
data.parPoints3 = Convert.ToInt32(reader["parPoints3"]);
data.parPoints4 = Convert.ToInt32(reader["parPoints4"]);
data.parPoints5 = Convert.ToInt32(reader["parPoints5"]);
data.parPoints6 = Convert.ToInt32(reader["parPoints6"]);
data.parPoints7 = Convert.ToInt32(reader["parPoints7"]);
data.parPoints8 = Convert.ToInt32(reader["parPoints8"]);
data.parPointsSum = Convert.ToInt32(reader["parPointsSum"]);
result.Add(data);
}
reader.Close();
return(result);
}
protected void NotifyData(ParticipantsData data)
{
foreach (var observer in _participantsDataObservers)
{
observer.OnNext(data);
}
}
public ParticipantsData Read(Span <byte> input, PacketHeader packetHeader)
{
var output = new ParticipantsData
{
Header = packetHeader
};
for (var i = 0; i < 20; i++)
{
output.Participants[i] = ReadParticipant(input);
}
return(output);
}
public List <ParticipantsData> SelectParticipantsByAgeGroupForPointUpload(string stage, string parAgeGroup)
{
cmd = new SqlCommand("SELECT * FROM Participants WHERE parAgeGroup = @p1", conn);
cmd.Parameters.Add("@p1", SqlDbType.VarChar).Value = parAgeGroup;
reader = cmd.ExecuteReader();
List <ParticipantsData> result = new List <ParticipantsData>();
while (reader.Read())
{
ParticipantsData data = new ParticipantsData();
data.Id = Convert.ToInt32(reader["Id"]);
data.parRaceTime1 = Convert.ToInt32(reader[stage]);
result.Add(data);
}
reader.Close();
return(result);
}
