public void AddGroundVehicleRowToSpreadsheet(GroundVehicle groundVehicle, ExcelWorksheet worksheet)
{
if (groundVehicle != null)
{
// Get the row we are up to
int indexPosition = worksheet.Dimension.End.Row + 1;
// Add values
worksheet.Cells[$"A{indexPosition}"].Value = groundVehicle.Name;
worksheet.Cells[$"B{indexPosition}"].Value = groundVehicle.Country;
worksheet.Cells[$"C{indexPosition}"].Value = Enum.GetName(typeof(VehicleTypeEnum), groundVehicle.VehicleType);
worksheet.Cells[$"D{indexPosition}"].Value = groundVehicle.Rank;
worksheet.Cells[$"E{indexPosition}"].Value = groundVehicle.BattleRating;
worksheet.Cells[$"F{indexPosition}"].Value = groundVehicle.Weight;
worksheet.Cells[$"G{indexPosition}"].Value = groundVehicle.WeightUnit.Name;
worksheet.Cells[$"H{indexPosition}"].Value = groundVehicle.EnginePower;
worksheet.Cells[$"I{indexPosition}"].Value = groundVehicle.EnginePowerUnit.Name;
worksheet.Cells[$"J{indexPosition}"].Value = groundVehicle.MaxSpeed;
worksheet.Cells[$"K{indexPosition}"].Value = groundVehicle.MaxSpeedUnit.Name;
worksheet.Cells[$"L{indexPosition}"].Value = groundVehicle.HullArmourThickness;
worksheet.Cells[$"M{indexPosition}"].Value = groundVehicle.SuperstructureArmourThickness;
worksheet.Cells[$"N{indexPosition}"].Value = groundVehicle.TimeForFreeRepair;
worksheet.Cells[$"O{indexPosition}"].Value = groundVehicle.MaxRepairCost;
worksheet.Cells[$"P{indexPosition}"].Value = groundVehicle.MaxRepairCostUnit.Name;
worksheet.Cells[$"Q{indexPosition}"].Value = groundVehicle.PurchaseCost;
worksheet.Cells[$"R{indexPosition}"].Value = groundVehicle.PurchaseCostUnit.Name;
worksheet.Cells[$"S{indexPosition}"].Value = groundVehicle.LastModified;
}
}
public void CreateJsonFile(ConcurrentDictionary <string, string> localFileChanges, string vehicleName, IVehicle vehicle, string fileName, string filePath)
{
LocalWikiFileTypeEnum fileType = LocalWikiFileTypeEnum.Json;
string fileExtension = fileType.ToString();
GroundVehicle groundVehicle = (GroundVehicle)vehicle;
string vehicleJson = Newtonsoft.Json.JsonConvert.SerializeObject(groundVehicle, Newtonsoft.Json.Formatting.Indented);
if (!File.Exists(filePath))
{
// Add new item
File.WriteAllText(filePath, vehicleJson);
_filePerVehicleLogger.RecordAddFileToLocalWiki(localFileChanges, vehicleName, fileName, fileExtension);
}
else
{
string existingFileText = File.ReadAllText(filePath);
GroundVehicle existingVehicle = Newtonsoft.Json.JsonConvert.DeserializeObject <GroundVehicle>(existingFileText);
// Get out the last modified times for comparison
string newLastModSection = groundVehicle.LastModified;
string oldLastModSection = existingVehicle?.LastModified;
// If both files have a last modified time
if (newLastModSection != null && oldLastModSection != null)
{
if (!_filePerVehicleLogger.AreLastModifiedTimesTheSame(oldLastModSection, newLastModSection))
{
// Update existing
File.WriteAllText(filePath, vehicleJson);
_filePerVehicleLogger.RecordUpdateFileInLocalWiki(localFileChanges, vehicleName, fileName, fileExtension);
}
}
// Add the item if the existing one has no last modified time
else if (oldLastModSection == null)
{
// Update existing item
File.WriteAllText(filePath, vehicleJson);
_filePerVehicleLogger.RecordUpdateFileInLocalWiki(localFileChanges, vehicleName, fileName, fileExtension);
}
else
{
string noLastModifiedSectionExceptionMessage = $"Unable to find the '{ConfigurationManager.AppSettings["LastModifiedSectionId"]}' section, information comparision failed.";
_consoleManager.WriteException(noLastModifiedSectionExceptionMessage);
throw new InvalidOperationException(noLastModifiedSectionExceptionMessage);
}
}
}
public void ObjectEnter(GameObject groundObject)
{
if (!groundObjects.Contains(groundObject))
{
removedObjects.Remove(groundObject);
groundObjects.Add(groundObject);
groundRigids.Add(groundObject.GetComponentInParent <Rigidbody>());
FloatingMesh componentInParent = groundObject.GetComponentInParent <FloatingMesh>();
if (componentInParent != null && !shipStartPositions.ContainsKey(componentInParent))
{
shipStartPositions[componentInParent] = groundObject.transform.position;
}
GroundVehicle componentInParent2 = groundObject.GetComponentInParent <GroundVehicle>();
if (componentInParent2 != null && !vehicleStartPositions.ContainsKey(componentInParent2))
{
vehicleStartPositions[componentInParent2] = groundObject.transform.position;
}
}
}
public void ProcessGroundForcesWikiHtmlFiles(ConcurrentDictionary <string, HtmlDocument> vehicleWikiPagesContent, ConcurrentDictionary <string, string> localFileChanges, Dictionary <string, GroundVehicle> vehicleDetails, List <HtmlNode> vehicleWikiEntryLinks, List <string> errorsList, int indexPosition, int expectedNumberOfLinks, bool createJsonFiles, bool createHtmlFiles, bool createExcelFile)
{
try
{
_consoleManager.WriteLineInColour(ConsoleColor.Yellow, "Press ENTER to begin extracting data from the vehicle pages.");
_consoleManager.WaitUntilKeyIsPressed(ConsoleKey.Enter);
foreach (string vehicleWikiPageLinkTitle in vehicleWikiPagesContent.Keys)
{
// Page to traverse
HtmlDocument vehicleWikiPage = vehicleWikiPagesContent.Single(x => x.Key == vehicleWikiPageLinkTitle).Value;
// Get the header that holds the page title | document.getElementsByClassName('firstHeading')[0].firstChild.innerText
HtmlNode pageTitle = vehicleWikiPage.DocumentNode.Descendants().Single(d => d.Id == "firstHeading").FirstChild;
// Get the div that holds all of the content under the title section | document.getElementById('bodyContent')
HtmlNode wikiBody = vehicleWikiPage.DocumentNode.Descendants().Single(d => d.Id == "bodyContent");
// Get the div that holds the content on the RHS of the page where the information table is | document.getElementById('bodyContent').getElementsByClassName('right-area')
HtmlNode rightHandContent = wikiBody.Descendants("div").SingleOrDefault(d => d.Attributes["class"] != null && d.Attributes["class"].Value.Contains("right-area"));
// Get the able that holds all of the vehicle information | document.getElementsByClassName('flight-parameters')[0]
HtmlNode infoBox = rightHandContent?.Descendants("table").SingleOrDefault(d => d.Attributes["class"].Value.Contains("flight-parameters"));
// Name
string vehicleName = _stringHelper.RemoveInvalidCharacters(WebUtility.HtmlDecode(vehicleWikiPageLinkTitle));
// Link
HtmlNode urlNode = vehicleWikiEntryLinks.SingleOrDefault(v => v.InnerText.Equals(vehicleName));
string relativeUrl = urlNode?.Attributes["href"].Value ?? "";
string vehicleWikiEntryFullUrl = new Uri(new Uri(ConfigurationManager.AppSettings["BaseWikiUrl"]), relativeUrl).ToString();
// Fail fast and create error if there is no info box
if (infoBox == null)
{
_consoleManager.WriteLineInColour(ConsoleColor.Red, $"Error processing item {indexPosition} of {expectedNumberOfLinks}", false);
_consoleManager.WriteBlankLine();
errorsList.Add($"No Information found for '{vehicleName}' - {vehicleWikiEntryFullUrl}");
_consoleManager.ResetConsoleTextColour();
indexPosition++;
continue;
}
else
{
// Setup local vars
Dictionary <string, string> vehicleAttributes = new Dictionary <string, string>();
HtmlNodeCollection rows = infoBox.SelectNodes("tr");
_consoleManager.WriteTextLine($"The following values were found for {vehicleName}");
_webCrawler.GetAttributesFromInfoBox(vehicleAttributes, rows);
_consoleManager.ResetConsoleTextColour();
// Country
string countryRawValue = vehicleAttributes.Single(k => k.Key == "Country").Value;
CountryEnum vehicleCountry = _vehicleCountryHelper.GetVehicleCountryFromName(countryRawValue).CountryEnum;
// Weight
string weightRawValue = vehicleAttributes.Single(k => k.Key == "Weight").Value;
int weightWithoutUnits = Int32.Parse(Regex.Match(weightRawValue, @"\d+").Value);
string weightUnitsAbbreviation = (Regex.Matches(weightRawValue, @"\D+").Cast <Match>()).Last().Value.Trim();
VehicleWeightUnitHelper vehicleWeightUnit = _vehicleWeightUnitHelper.GetWeightUnitFromAbbreviation(weightUnitsAbbreviation);
// Vehicle class
string typeRawValue = vehicleAttributes.Single(k => k.Key == "Type").Value;
GroundVehicleTypeHelper vehicleType = _vehicleTypeHelper.GetGroundVehicleTypeFromName(typeRawValue);
// Rank
int rankRawValue = Int32.Parse(vehicleAttributes.Single(k => k.Key == "Rank").Value);
int vehicleRank = rankRawValue;
// Battle rating
double ratingRawValue = Double.Parse(vehicleAttributes.Single(k => k.Key == "Rating").Value);
double vehicleBattleRating = ratingRawValue;
// Engine power
string enginePowerRawValue = vehicleAttributes.Single(k => k.Key == "Engine power").Value;
int enginePowerWithoutUnits = Int32.Parse(Regex.Match(enginePowerRawValue, @"\d+").Value);
string enginePowerUnitsAbbreviation = (Regex.Matches(enginePowerRawValue, @"\D+").Cast <Match>()).Last().Value.Trim();
VehicleEnginePowerUnitHelper vehicleEngineUnit = _vehicleEnginePowerUnitHelper.GetEngineUnitFromAbbreviation(enginePowerUnitsAbbreviation);
// Max speed
string maxSpeedRawValue = vehicleAttributes.Single(k => k.Key == "Max speed").Value;
double maxSpeedWithoutUnits = Double.Parse(Regex.Match(maxSpeedRawValue, @"\d+\.*\d*").Value);
string maxSpeedUnits = (Regex.Matches(maxSpeedRawValue, @"\D+").Cast <Match>()).Last().Value.Trim();
VehicleSpeedUnitHelper vehicleSpeedUnit = _vehicleSpeedUnitHelper.GetSpeedUnitFromAbbreviation(maxSpeedUnits);
// Hull armour
string hullArmourRawValue = vehicleAttributes.Single(k => k.Key == "Hull armour thickness").Value;
string vehicleHullArmourThickness = hullArmourRawValue;
// Superstructure armour
string superstructureArmourRawValue = vehicleAttributes.Single(k => k.Key == "Superstructure armour thickness").Value;
string vehicleSuperstructureArmourThickness = superstructureArmourRawValue;
// Repair time
string freeRepairTimeRawValue = vehicleAttributes.Single(k => k.Key == "Time for free repair").Value;
List <Match> freeRepairTimeList = (Regex.Matches(freeRepairTimeRawValue, @"\d+").Cast <Match>()).ToList();
int freeRepairTimeHours = Int32.Parse(freeRepairTimeList.First().Value);
int freeRepairTimeMinutes = Int32.Parse(freeRepairTimeList.Last().Value);
TimeSpan vehicleFreeRepairTime = new TimeSpan(freeRepairTimeHours, freeRepairTimeMinutes, 0);
// Max repair cost
string maxRepairCostRawValue = vehicleAttributes.Single(k => k.Key == "Max repair cost*").Value;
string maxRepairCostWithoutUnits = Regex.Match(maxRepairCostRawValue, @"\d+").Value;
string maxRepairCostUnits = (Regex.Matches(maxRepairCostRawValue, @"\D+").Cast <Match>()).Last().Value.Trim();
long vehicleMaxRepairCost = Int64.Parse(maxRepairCostWithoutUnits);
VehicleCostUnitHelper vehicleRepairCostUnit = _vehicleCostUnitHelper.GetCostUnitFromAbbreviation(maxRepairCostUnits);
// Purchase cost
string purchaseCostRawValue = vehicleAttributes.Single(k => k.Key == "Cost*").Value;
string purchaseCostWithoutUnits = Regex.Match(purchaseCostRawValue, @"\d+").Value;
string purchaseCostUnits = (Regex.Matches(purchaseCostRawValue, @"\D+").Cast <Match>()).Last().Value.Trim();
long vehiclePurchaseCost = Int64.Parse(purchaseCostWithoutUnits);
VehicleCostUnitHelper vehiclePurchaseCostUnit = _vehicleCostUnitHelper.GetCostUnitFromAbbreviation(purchaseCostUnits);
// Last modified
HtmlNode lastModifiedSection = vehicleWikiPage.DocumentNode.Descendants().SingleOrDefault(x => x.Id == ConfigurationManager.AppSettings["LastModifiedSectionId"]);
string lastModified = lastModifiedSection?.InnerHtml;
// Populate objects
GroundVehicle groundVehicle = new GroundVehicle
{
Name = vehicleName,
Country = vehicleCountry,
Weight = weightWithoutUnits,
VehicleType = (VehicleTypeEnum)vehicleType.Id,
Rank = vehicleRank,
BattleRating = vehicleBattleRating,
EnginePower = enginePowerWithoutUnits,
MaxSpeed = maxSpeedWithoutUnits,
HullArmourThickness = vehicleHullArmourThickness,
SuperstructureArmourThickness = vehicleSuperstructureArmourThickness,
TimeForFreeRepair = vehicleFreeRepairTime,
MaxRepairCost = vehicleMaxRepairCost,
PurchaseCost = vehiclePurchaseCost,
PurchaseCostUnit = vehiclePurchaseCostUnit,
MaxRepairCostUnit = vehicleRepairCostUnit,
MaxSpeedUnit = vehicleSpeedUnit,
WeightUnit = vehicleWeightUnit,
EnginePowerUnit = vehicleEngineUnit,
LastModified = lastModified
};
// Update the local storage if requested
if (createJsonFiles)
{
_logger.UpdateLocalStorageForOfflineUse(localFileChanges, vehicleWikiPage, vehicleName, LocalWikiFileTypeEnum.Json, groundVehicle);
}
if (createHtmlFiles)
{
_logger.UpdateLocalStorageForOfflineUse(localFileChanges, vehicleWikiPage, vehicleName, LocalWikiFileTypeEnum.Html);
}
//WikiEntry entry = new WikiEntry(vehicleName, vehicleWikiEntryFullUrl, VehicleTypeEnum.Ground, vehicleInfo);
// Add the found information to the master list
vehicleDetails.Add(vehicleName, groundVehicle);
_consoleManager.WriteLineInColour(ConsoleColor.Green, $"Processed item {indexPosition} of {expectedNumberOfLinks} successfully");
_consoleManager.WriteBlankLine();
}
indexPosition++;
}
if (createExcelFile)
{
_excelLogger.CreateExcelFile(vehicleDetails);
}
}
catch (Exception ex)
{
_consoleManager.WriteException(ex.Message);
}
}
public ulong RegisterVehicle(GroundVehicle vehicle)
{
return(base.RegisterVehicle(vehicle));
}
