public async Task Populate()
{
var basePath = @"R:\Code\aerolog\Data\Apollo";
var series = await BaseLoaderHelpers.GetOrCreateSeries(_seriesEngine, "Apollo", Path.Combine(basePath, "series.jpg"));
var missionDataList = new List <MissionData>
{
new MissionData
{
Title = "Apollo 1",
ImagePath = "apollo1.jpg"
},
new MissionData
{
Title = "Apollo 7",
ImagePath = "apollo7.jpeg"
},
new MissionData
{
Title = "Apollo 8",
ImagePath = "apollo8.jpg"
},
new MissionData
{
Title = "Apollo 9",
ImagePath = "apollo9.jpg"
},
new MissionData
{
Title = "Apollo 10",
ImagePath = "apollo10.jpg"
},
new MissionData
{
Title = "Apollo 11",
ImagePath = "apollo11.jpg",
DataPath = "apollo11.txt",
MissionStart = new DateTime(1969, 7, 16, 13, 32, 00, DateTimeKind.Utc),
Speakers = new Dictionary <string, string>()
{
{ "CDR", "Neil A. Armstrong" },
{ "CMP", "Michael Collins" },
{ "LMP", "Edwin E. ALdrin, Jr." },
{ "SC", "Unidentifiable crewmember" },
{ "MS", "Multiple (simultaneous) speakers" },
{ "LCC", "Launch Control Center" },
{ "CC", "Capsule Communicator (CAP COMM)" },
{ "F", "Flight Director" },
{ "CT", "Communications Technician (COMM TECH)" },
{ "HORNET", "USS Hornet" },
{ "R", "Recovery helicopter" },
{ "AB", "Air Boss" },
{ "SWIM 1", "Swim 1" },
{ "MSFN", "" },
{ "CDF", "" },
{ "PRESIDENT NIXON", "" }
},
},
new MissionData
{
Title = "Apollo 12",
ImagePath = "apollo12.jpg"
},
new MissionData
{
Title = "Apollo 13",
ImagePath = "apollo13.jpg"
},
new MissionData
{
Title = "Apollo 14",
ImagePath = "apollo14.jpg"
},
new MissionData
{
Title = "Apollo 15",
ImagePath = "apollo15.jpg"
},
new MissionData
{
Title = "Apollo 16",
ImagePath = "apollo16.jpg"
},
new MissionData
{
Title = "Apollo 17",
ImagePath = "apollo17.jpg"
},
};
foreach (var missionData in missionDataList)
{
var fullImagePath = Path.Combine(basePath, missionData.ImagePath);
var mission = await BaseLoaderHelpers.GetOrCreateMission(_missionEngine, missionData.Title, fullImagePath, series.Id);
if (!string.IsNullOrWhiteSpace(missionData.DataPath))
{
await _logEngine.DeleteAllLogsByMissionId(mission.Id);
var fullDataPath = Path.Combine(basePath, missionData.DataPath);
var lines = await System.IO.File.ReadAllLinesAsync(fullDataPath);
var sb = new StringBuilder();
var logs = new List <Log>();
var index = 0;
var logRegex = GetLogRegex(missionData);
while (!Regex.IsMatch(lines[index], logRegex))
{
index++;
}
while (index < lines.Length)
{
var line = lines[index];
if (string.IsNullOrWhiteSpace(line))
{
index++;
continue;
}
var match = Regex.Match(line, logRegex);
if (match.Success)
{
index++;
while (index < lines.Length && !Regex.IsMatch(lines[index], logRegex))
{
if (IsValidLine(lines[index]))
{
sb.AppendLine(lines[index]);
}
index++;
}
try
{
var stampParts = match.Groups["stamp"].Value.Split(" ");
var timestamp = missionData.MissionStart
.AddDays(int.Parse(stampParts[0]))
.AddHours(int.Parse(stampParts[1]))
.AddMinutes(int.Parse(stampParts[2]))
.AddSeconds(int.Parse(stampParts[3]));
var log = new Log
{
SpeakerName = match.Groups["speaker"].Value,
Timestamp = timestamp,
MissionId = mission.Id,
SeriesId = series.Id,
Text = sb.ToString().Trim().Replace("\n", " "),
};
await _logEngine.Save(log);
sb.Clear();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
else
{
index++;
}
}
}
if (missionData.Speakers != null)
{
mission.Speakers = missionData.Speakers.Select(kvp => new Speaker
{
Label = kvp.Key,
Name = kvp.Value
}).ToList();
}
await _missionEngine.Save(mission);
}
}