private static void WriteSortedRunnersToXls(SortedDictionary <int, Runner> sortedRunners)
{
if ((sortedRunners == null) || (sortedRunners.Count == 0))
{
return;
}
try
{
using (StreamWriter writer = new StreamWriter(CAHCE_FILE_XLS, false))
{
foreach (var pair in sortedRunners)
{
Runner r = pair.Value;
string row =
String.Format("{0},{1},{2},{4},{3},{5},{6},{7},{8},{9}", r.Rank, r.Name, r.NameHref, r.BibNo, r.Gender, r.GenderRank,
r.Category, r.CategoryRank, Csv.Escape(r.NetTime), Csv.Escape(r.GrossTime));
writer.WriteLine(row);
}
}
}
catch (Exception exp)
{
Console.WriteLine("Could not write runner. Reason = {0}", exp.Message);
}
}
private static void CreateCsvFile(SortedDictionary <int, Runner> zombiedSortedRunners)
{
SortedDictionary <int, Runner> rankSortedRunners = new SortedDictionary <int, Runner>();
//sorted runners conatains lots of invalid runners. Runners who dont exist. Remove them
foreach (var pair in zombiedSortedRunners)
{
if (pair.Value.IsValid)
{
//Console.WriteLine("Rank = {0}, RankInt = {1}", pair.Value.Rank, pair.Value.RankInt);
rankSortedRunners.Add(pair.Value.RankInt, pair.Value);
}
else
{
// Console.WriteLine("Invalid: Rank = {0}, RankInt = {1} Bib = {2}", pair.Value.Rank, pair.Value.RankInt, pair.Value.BibNo);
}
}
using (StreamWriter writer = new StreamWriter("run" + ".csv", false))
{
writer.WriteLine("Rank, Name, BibNo, Gender, GenderRank, Category, CategoryRank, NetTime, GrossTime");
foreach (var pair in rankSortedRunners)
{
Runner r = pair.Value;
string row =
String.Format(@"{0},{1},{2},{3},{4},{5},{6},{7},{8}",
r.Rank, r.Name, r.BibNo, r.Gender, r.GenderRank, r.Category, r.CategoryRank, Csv.Escape(r.NetTime), Csv.Escape(r.GrossTime));
writer.WriteLine(row);
}
}
}
