private static void ParseShipAndSave(string[] shipLines)
{
ShipModel ship = new ShipModel();
List <string> cells = new List <string>();
List <KeyValuePair <int, string> > pairs = new List <KeyValuePair <int, string> >();
int count = 0;
foreach (string line in shipLines)
{
var rowCells = line.Split(';');
if (count == 2 && rowCells.Length > 10)
{
rowCells[10] = "12";
}
if (count == 4 && rowCells.Length > 10)
{
rowCells[10] = "12";
}
if (count == 5 && rowCells.Length > 14)
{
rowCells[14] = "12";
}
cells.AddRange(rowCells);
count++;
}
string[] cellHeads = new string[] { "1", "2", "3", "4", "5", "6", "7", "8", "11", "12" };
for (int i = 0; i < cells.Count; i++)
{
if (cellHeads.Any(cells[i].Equals))
{
pairs.Add(new KeyValuePair <int, string>(int.Parse(cells[i]), cells[i + 1]));
}
}
//1
ship.RegisterNo = pairs.Where(kvp => kvp.Key == 1).ToList()[0].Value.Trim();
ship.Name = pairs.Where(kvp => kvp.Key == 1).ToList()[1].Value.Trim();
ship.GRT = pairs.Where(kvp => kvp.Key == 1).ToList()[2].Value.Trim();
ship.Hull = pairs.Where(kvp => kvp.Key == 1).ToList()[3].Value.Trim();
string dob = pairs.Where(kvp => kvp.Key == 1).ToList()[4].Value.Trim();
if (dob.Contains('-'))
{
ship.YOB = dob.Split('-')[0];
}
else
{
ship.YOB = dob;
}
ship.Shipbuilder = pairs.Where(kvp => kvp.Key == 1).ToList()[5].Value.Trim();
string builder = pairs.Where(kvp => kvp.Key == 1).ToList()[5].Value.Trim();
if (builder.Contains(','))
{
ship.Shipbuilder = builder.Split(',')[0];
ship.BuilderCountry = builder.Split(',')[1];
}
else
{
ship.Shipbuilder = builder;
}
//2
ship.Imo = pairs.Where(kvp => kvp.Key == 2).ToList()[0].Value.Trim();
ship.NET = pairs.Where(kvp => kvp.Key == 2).ToList()[2].Value.Trim();
ship.MeType = pairs.Where(kvp => kvp.Key == 2).ToList()[3].Value.Trim();
//3
ship.Flag = pairs.Where(kvp => kvp.Key == 3).ToList()[0].Value.Trim();
ship.DWT = pairs.Where(kvp => kvp.Key == 3).ToList()[1].Value.Trim();
ship.Manager = pairs.Where(kvp => kvp.Key == 3).ToList()[4].Value.Trim();
//4
ship.LBP = pairs.Where(kvp => kvp.Key == 4).ToList()[0].Value.Trim();
ship.CallSign = pairs.Where(kvp => kvp.Key == 4).ToList()[2].Value.Trim();
ship.MePower = pairs.Where(kvp => kvp.Key == 4).ToList()[3].Value.Trim();
if (ship.MePower.Contains('('))
{
ship.MePower = ship.MePower.Split('(')[0];
}
ship.Owner = pairs.Where(kvp => kvp.Key == 4).ToList()[4].Value.Trim();
//5
List <KeyValuePair <int, string> > fives = pairs.Where(kvp => kvp.Key == 5).ToList();
if (fives.Count > 4)
{
ship.LOA = fives[0].Value.Trim();
ship.Boilers = fives[3].Value.Trim();
ship.PortOfRegistry = fives[4].Value.Trim();
}
//6
ship.Breadth = pairs.Where(kvp => kvp.Key == 6).ToList()[0].Value.Trim();
ship.Mmsi = pairs.Where(kvp => kvp.Key == 6).ToList()[2].Value.Trim();
ship.Generators = pairs.Where(kvp => kvp.Key == 6).ToList()[3].Value.Trim();
//7
ship.Depth = pairs.Where(kvp => kvp.Key == 7).ToList()[0].Value.Trim();
ship.HoldsNo = pairs.Where(kvp => kvp.Key == 7).ToList()[1].Value.Trim();
//8
ship.Draught = pairs.Where(kvp => kvp.Key == 8).ToList()[0].Value.Trim();
//11
if (pairs.Any(kvp => kvp.Key == 11))
{
ship.CargoHandlingEquipment = pairs.Where(kvp => kvp.Key == 11).ToList()[0].Value.Trim();
}
//12
List <KeyValuePair <int, string> > extras = pairs.Where(kvp => kvp.Key == 12).ToList();
if (extras.Count > 2)
{
ship.Type = extras[0].Value.Trim();
ship.DecksNo = extras[1].Value.Trim();
ship.Speed = extras[2].Value.Trim();
}
string shipsLine = GenerateLine(ship);
Console.WriteLine(shipsLine);
SaveShip(shipsLine);
}
private static string GenerateLine(ShipModel shipdata)
{
StringBuilder sb = new StringBuilder();
sb.Append(shipdata.Name);
sb.Append("|");
sb.Append(shipdata.Type);
sb.Append("|");
sb.Append(shipdata.RegisterNo);
sb.Append("|");
sb.Append(shipdata.Imo);
sb.Append("|");
sb.Append(shipdata.CallSign);
sb.Append("|");
sb.Append(shipdata.Flag);
sb.Append("|");
sb.Append(shipdata.PortOfRegistry);
sb.Append("|");
sb.Append(shipdata.Owner);
sb.Append("|");
sb.Append(shipdata.Manager);
sb.Append("|");
sb.Append(shipdata.Propulsion);
sb.Append("|");
sb.Append(shipdata.Hull);
sb.Append("|");
sb.Append(shipdata.Machinery);
sb.Append("|");
sb.Append(shipdata.AnchorEquipment);
sb.Append("|");
sb.Append(shipdata.GRT);
sb.Append("|");
sb.Append(shipdata.NET);
sb.Append("|");
sb.Append(shipdata.DWT);
sb.Append("|");
sb.Append(shipdata.LOA);
sb.Append("|");
sb.Append(shipdata.LBP);
sb.Append("|");
sb.Append(shipdata.Breadth);
sb.Append("|");
sb.Append(shipdata.Depth);
sb.Append("|");
sb.Append(shipdata.Draught);
sb.Append("|");
sb.Append(shipdata.SFB);
sb.Append("|");
sb.Append(shipdata.Shipbuilder);
sb.Append("|");
sb.Append(shipdata.BuilderCountry);
sb.Append("|");
sb.Append(shipdata.YOB);
sb.Append("|");
sb.Append(shipdata.HullMaterial);
sb.Append("|");
sb.Append(shipdata.DecksNo);
sb.Append("|");
sb.Append(shipdata.HoldsNo);
sb.Append("|");
sb.Append(shipdata.MePower);
sb.Append("|");
sb.Append(shipdata.MeType);
sb.Append("|");
sb.Append(shipdata.MeMaker);
sb.Append("|");
sb.Append(shipdata.PropsNo);
sb.Append("|");
sb.Append(shipdata.Generators);
sb.Append("|");
sb.Append(shipdata.Boilers);
sb.Append("|");
sb.Append(shipdata.AirCompressor);
sb.Append("|");
sb.Append(shipdata.Speed);
sb.Append("|");
sb.Append(shipdata.DeckErections);
sb.Append("|");
sb.Append(shipdata.Bulkheads);
sb.Append("|");
sb.Append(shipdata.Ballast);
sb.Append("|");
sb.Append(shipdata.BoilerMaker);
sb.Append("|");
sb.Append(shipdata.CargoHandlingEquipment);
sb.Append("|");
sb.Append(shipdata.CargoSpaceVolume);
sb.Append("|");
sb.Append(shipdata.RadioEquipment);
sb.Append("|");
sb.Append(shipdata.TechManager);
sb.Append("|");
sb.Append(shipdata.Status);
sb.Append("|");
sb.Append(shipdata.Mmsi);
sb.Append("|");
sb.Append(shipdata.OwnerAddress);
sb.Append("|");
sb.Append(shipdata.ManagerAddress);
return(sb.ToString());
}
