private void ExtractStyleMaps(Element kml)
{
_styleMaps = new List <StyleMap>();
foreach (var style in kml.Flatten().OfType <StyleMapCollection>())
{
var styleMap = new StyleMap {
Id = style.Id
};
_styleMaps.Add(styleMap);
style.ToList().ForEach(x =>
{
if (x.State != null)
{
switch (x.State.Value)
{
case StyleState.Normal:
styleMap.NormalStyleUrl = x.StyleUrl.ToString().Replace("#", "");
break;
case StyleState.Highlight:
styleMap.HighlightStyleUrl = x.StyleUrl.ToString().Replace("#", "");
break;
}
}
});
}
}
private static StyleMap DefaultStyleMap()
{
return(StyleMap.builder()
.mapParagraph(ParagraphMatcher.styleName("Normal"), HtmlPath.element("p"))
.build());
}
/// <summary>
/// Parse StyleMaps defined at the head of the KML document and attempt to resolve
/// both the Normal and Highlight Styles which could include external references
/// </summary>
/// <param name="kml"></param>
private void ExtractStyleMaps(Element kml)
{
_styleMaps = new Dictionary <string, StyleMap>();
foreach (var style in kml.Flatten().OfType <StyleMapCollection>())
{
var styleMap = new StyleMap {
Id = style.Id
};
if (_styleMaps.ContainsKey(styleMap.Id))
{
continue;
}
style.ToList().ForEach(x =>
{
if (x.State == null)
{
return;
}
if (x.StyleUrl == null)
{
return;
}
if (!x.StyleUrl.OriginalString.Contains("#"))
{
return;
}
var tokens = x.StyleUrl.OriginalString.Split(new char[] { '#' }, StringSplitOptions.RemoveEmptyEntries);
var styleName = tokens.Last();
if (tokens.Length == 2)
{
LoadExternalStyle(x.StyleUrl.OriginalString);
}
switch (x.State.Value)
{
case StyleState.Normal:
styleMap.NormalStyleUrl = styleName;
break;
case StyleState.Highlight:
styleMap.HighlightStyleUrl = styleName;
break;
}
});
_styleMaps.Add(styleMap.Id, styleMap);
}
}
internal Config()
{
// read system config
Docx2TexConfig systemConfig = LoadSystemConfig();
// read user config
Docx2TexConfig userConfig = LoadUserConfig();
// read document config
Docx2TexConfig documentConfig = LoadDocumentConfig();
// fill system data structures
LaTeXTags = new LaTeXTags(systemConfig.LaTeXTags, userConfig != null ? userConfig.LaTeXTags : null, documentConfig != null ? documentConfig.LaTeXTags : null);
Infra = new Infra(systemConfig.Infra, userConfig != null ? userConfig.Infra : null, documentConfig != null ? documentConfig.Infra : null);
StyleMap = new StyleMap(systemConfig.StyleMap, userConfig != null ? userConfig.StyleMap : null, documentConfig != null ? documentConfig.StyleMap : null);
}
/// ------------------------------------------------------------------------------------
/// <summary>
/// Get the OXES information for the given character style, creating a temporary userCS
/// object if needed.
/// </summary>
/// <param name="style"></param>
/// <returns></returns>
/// ------------------------------------------------------------------------------------
static public OxesInfo GetOxesInfoForCharStyle(string style)
{
OxesInfo oxes;
if (String.IsNullOrEmpty(style))
{
return(m_emptyChar);
}
else if (StyleMap.TryGetValue(style, out oxes) && oxes.m_fIsCharStyle)
{
return(oxes);
}
else
{
return(new OxesInfo(true, style, OxesContext.Default, "userCS", "type", style, null, null, false, false));
}
}
/// ------------------------------------------------------------------------------------
/// <summary>
/// Get the OXES information for the given paragraph style, creating a temporary userPS
/// object if needed.
/// </summary>
/// <param name="style">The style.</param>
/// <param name="fSectionHead">if set to <c>true</c> this is a section head style (used
/// only for non-standard styles).</param>
/// ------------------------------------------------------------------------------------
static public OxesInfo GetOxesInfoForParaStyle(string style, bool fSectionHead)
{
OxesInfo oxes;
if (String.IsNullOrEmpty(style))
{
return(m_emptyPara);
}
else if (StyleMap.TryGetValue(style, out oxes) && !oxes.m_fIsCharStyle)
{
return(oxes);
}
else if (fSectionHead)
{
return(new OxesInfo(false, style, OxesContext.NormalSection, null, null, null, null, null, false, true));
}
else
{
return(new OxesInfo(false, style, OxesContext.Default, "p", "type", "userPS", "subType", style, false, false));
}
}
/// <summary>
/// Generates the KML string.
/// </summary>
/// <param name="toolStripProgressBar">A windows Forms ToolStripProgressBar</param>
/// <returns>The KML string.</returns>
public string generateKML(ref System.Windows.Forms.ToolStripProgressBar toolStripProgressBar)
{
XNamespace gx = "http://www.google.com/kml/ext/2.2";
XElement document = (XElement)(new Document().ToXNode());
XDocument kml = new XDocument(
new XComment("Created with excel2earth"),
new XElement("kml",
new XAttribute(XNamespace.Xmlns + "kml", "http://www.opengis.net/kml/2.2"),
new XAttribute(XNamespace.Xmlns + "gx", "http://www.google.com/kml/ext/2.2"),
document
)
);
int lastRow;
if (this.range.SpecialCells(Excel.XlCellType.xlCellTypeLastCell, Type.Missing).Row < this.range.Rows.Count)
{
lastRow = this.range.SpecialCells(Excel.XlCellType.xlCellTypeLastCell, Type.Missing).Row;
}
else
{
lastRow = this.range.Rows.Count;
}
toolStripProgressBar.Minimum = this.range.Cells.Row + Convert.ToInt32(this.hasHeaders);
toolStripProgressBar.Maximum = lastRow;
toolStripProgressBar.Value = toolStripProgressBar.Minimum;
toolStripProgressBar.Step = 1;
foreach (StyleMap styleMap in this.styleSelection.Values.Where(StyleMap => StyleMap != null).Distinct())
{
if (!document.Descendants("StyleMap").Where(StyleMap => StyleMap.Attribute("id").Value == styleMap.id).Any())
{
document.Add((XElement)styleMap.ToXNode());
}
}
for (int row = 1 + Convert.ToInt32(this.hasHeaders); row <= lastRow; row++)
{
XElement parentNode = document;
Placemark placemark = new Placemark(((Excel.Range) this.range.Cells[row, this.nameColumn]).Value2.ToString());
string id = "";
DecimalDegrees decimalDegrees;
double altitude = 0.0;
XElement[] childElements;
XName childType = "Placemark";
DateTime dateTime1;
DateTime dateTime2;
Geometry geometry = null;
bool addElements = true;
// XY Coordinates
try
{
switch (this.coordinatesFormat)
{
case 0: // Decimal Degrees
decimalDegrees = new DecimalDegrees(((Excel.Range) this.range.Cells[row, this.coordinatesField2Column]).Value2.ToString(), ((Excel.Range) this.range.Cells[row, this.coordinatesField1Column]).Value2.ToString());
break;
case 1: // Degrees, Decimal Minutes
decimalDegrees = new DegreesDecimalMinutes(((Excel.Range) this.range.Cells[row, this.coordinatesField2Column]).Value2.ToString(), ((Excel.Range) this.range.Cells[row, this.coordinatesField1Column]).Value2.ToString()).ToDecimalDegrees();
break;
case 2: // Degrees, Minutes, Seconds
decimalDegrees = new DegreesMinutesSeconds(((Excel.Range) this.range.Cells[row, this.coordinatesField2Column]).Value2.ToString(), ((Excel.Range) this.range.Cells[row, this.coordinatesField1Column]).Value2.ToString()).ToDecimalDegrees();
break;
case 3: // Military Grid Reference System
decimalDegrees = new MilitaryGridReferenceSystem(((Excel.Range) this.range.Cells[row, this.coordinatesField1Column]).Value2.ToString()).ToDecimalDegrees();
break;
//case 4: // Universal Transverse Mercator
// throw new NotImplementedException();
// break;
default:
decimalDegrees = new DecimalDegrees(0d, 0d);
break;
}
}
catch
{
toolStripProgressBar.PerformStep();
continue;
}
// Z Coodinate
if (this.hasAltitude)
{
if (!double.TryParse(((Excel.Range) this.range.Cells[row, this.altitudeColumn]).Value2.ToString(), out altitude))
{
continue;
}
altitude *= altitudeUnitMultipliers[this.altitudeUnit];
}
Geometry.CoordinateSet coordinateSet = new Geometry.CoordinateSet(decimalDegrees.Latitude, decimalDegrees.Longitude, altitude);
// Folders
for (int i = 0; i < this.folderColumns.Length; i++)
{
XElement[] folders = (from folder in parentNode.Descendants("Folder")
where folder.Element("name").Value == ((Excel.Range) this.range.Cells[row, this.folderColumns[i]]).Value2.ToString()
select folder).ToArray <XElement>();
if (folders.Length < 1) // If the folder doesn't exist, create it
{
parentNode.Add(new Folder(((Excel.Range) this.range.Cells[row, this.folderColumns[i]]).Value2.ToString()).ToXNode());
i--;
}
else // If the folder exists, use it
{
parentNode = folders[0];
}
}
// Snippet
if (this.hasSnippet)
{
placemark.snippet = ((Excel.Range) this.range.Cells[row, this.snippetColumn]).Value2.ToString();
placemark.snippetMaxLines = this.snippetMaxLines;
}
// Description
if (this.descriptionColumns.Length > 0)
{
XElement descriptionTable = new XElement("table");
for (int i = 0; i < this.descriptionColumns.Length; i++)
{
descriptionTable.Add
(
new XElement("tr",
new XAttribute("style", "background-color: #" + (i % 2 == 0 ? "FFFFFF" : "DDDDDD") + ";"),
new XElement("td",
new XAttribute("style", "font-weight: bold;"),
new XText(((Excel.Range) this.range.Cells[1, this.descriptionColumns[i]]).Value2.ToString())
),
new XElement("td",
new XText(((Excel.Range) this.range.Cells[row, this.descriptionColumns[i]]).Value2.ToString())
)
)
);
}
placemark.description = descriptionTable.ToString();
}
// Style
if (this.iconColumn > 0)
{
string styleKey = ((Excel.Range) this.range.Cells[row, this.iconColumn]).Value2.ToString();
if (this.styleSelection.ContainsKey(styleKey) && this.styleSelection[styleKey].id != null)
{
placemark.styleUrl = "#" + this.styleSelection[styleKey].id;
}
}
// Date/Time
if (this.hasTimeStamp || this.hasTimeSpan)
{
if (this.dateTimeFormat1 == 1)
{
DateTime.TryParse(((Excel.Range) this.range.Cells[row, this.dateTimeField1Column]).Value2.ToString() + " " + ((Excel.Range) this.range.Cells[row, this.dateTimeField2Column]).Value2.ToString(), out dateTime1);
}
else
{
DateTime.TryParse(((Excel.Range) this.range.Cells[row, this.dateTimeField1Column]).Value2.ToString(), new System.Globalization.CultureInfo("en-us", false).DateTimeFormat, System.Globalization.DateTimeStyles.AssumeUniversal, out dateTime1);
}
if (this.hasTimeStamp)
{
placemark.timePrimitive = new TimeStamp(dateTime1, dateTimeFormats[this.dateTimeFormat1]);
}
if (this.hasTimeSpan)
{
if (this.dateTimeFormat2 == 1)
{
DateTime.TryParse(((Excel.Range) this.range.Cells[row, this.dateTimeField3Column]).Value2.ToString() + " " + ((Excel.Range) this.range.Cells[row, this.dateTimeField4Column]).Value2.ToString(), out dateTime2);
}
else
{
DateTime.TryParse(((Excel.Range) this.range.Cells[row, this.dateTimeField3Column]).Value2.ToString(), out dateTime2);
}
placemark.timePrimitive = new excel2earth.kml.TimeSpan(dateTime1, dateTimeFormats[dateTimeFormat1], dateTime2, dateTimeFormats[dateTimeFormat2]);
}
}
// Model
Orientation modelOrientation = null;
Scale modelScale = null;
Link modelLink = null;
if (this.hasModel)
{
// Orientation
if (this.modelHeadingColumn > 0 || this.modelTiltColumn > 0 || this.modelRollColumn > 0)
{
double modelHeading = 0.0;
double modelTilt = 0.0;
double modelRoll = 0.0;
if (this.modelHeadingColumn > 0)
{
double.TryParse(((Excel.Range) this.range.Cells[row, this.modelHeadingColumn]).Value2.ToString(), out modelHeading);
}
if (this.modelTiltColumn > 0)
{
double.TryParse(((Excel.Range) this.range.Cells[row, this.modelTiltColumn]).Value2.ToString(), out modelTilt);
}
if (this.modelRollColumn > 0)
{
double.TryParse(((Excel.Range) this.range.Cells[row, this.modelRollColumn]).Value2.ToString(), out modelRoll);
}
modelOrientation = new Orientation(modelHeading, modelTilt, modelRoll);
}
// Scale
if (this.modelXScaleColumn > 0 || this.modelYScaleColumn > 0 || this.modelZScaleColumn > 0)
{
double modelXScale = 1.0;
double modelYScale = 1.0;
double modelZScale = 1.0;
if (this.modelXScaleColumn > 0)
{
double.TryParse(((Excel.Range) this.range.Cells[row, this.modelXScaleColumn]).Value2.ToString(), out modelXScale);
}
if (this.modelYScaleColumn > 0)
{
double.TryParse(((Excel.Range) this.range.Cells[row, this.modelYScaleColumn]).Value2.ToString(), out modelYScale);
}
if (this.modelZScaleColumn > 0)
{
double.TryParse(((Excel.Range) this.range.Cells[row, this.modelZScaleColumn]).Value2.ToString(), out modelZScale);
}
modelScale = new Scale(modelXScale, modelYScale, modelZScale);
}
if (this.modelColumn > 0)
{
modelLink = new Link(((Excel.Range) this.range.Cells[row, this.modelColumn]).Value2.ToString());
}
}
// Geometry
if (this.hasMultiGeometry)
{
id = ((Excel.Range) this.range.Cells[row, this.multiGeometryColumn]).Value2.ToString();
childElements = (from children in parentNode.Descendants(childType)
where children.Element("MultiGeometry").Attribute("id").Value == id
select children).ToArray <XElement>();
childType = "MultiGeometry";
if (childElements.Length < 1) // If the Placemark doesn't exist, create it
{
placemark.geometry = new MultiGeometry(id);
parentNode.Add(placemark.ToXNode());
parentNode = (from elements in parentNode.Descendants("Placemark").Descendants(childType)
where elements.Attribute("id").Value == id
select elements).First();
}
else // If the Placemark exists, use it
{
parentNode = childElements.First();
}
}
#region MultiType
switch (this.multiType)
{
case 0: // None
break;
case 1: // Polygon
id = ((Excel.Range) this.range.Cells[row, this.multiTypeGroupColumn]).Value2.ToString();
childElements = (from children in parentNode.Descendants(childType).Descendants("Polygon")
where children.Attribute("id").Value == id
select children).ToArray <XElement>();
if (childElements.Length < 1) // If the Placemark doesn't exist, create it
{
Polygon polygon = new Polygon(id);
if (this.hasAltitude)
{
polygon.hasAltitude = true;
polygon.altitudeMode = this.altitudeModeIntToEnum[this.altitudeMode];
polygon.extrude = this.extrude;
polygon.tessellate = this.tesselllate;
}
if (childType == "Placemark")
{
XElement xPlacemark = (XElement)placemark.ToXNode();
parentNode.Add(xPlacemark);
parentNode = xPlacemark;
}
XElement xPolygon = (XElement)polygon.ToXNode();
parentNode.Add(xPolygon);
parentNode = xPolygon;
}
else // If the Placemark exists, use it
{
parentNode = childElements[0];
System.Windows.Forms.MessageBox.Show(parentNode.ToString());
}
childType = "Polygon";
break;
case 2: // MultiTrack
id = ((Excel.Range) this.range.Cells[row, this.multiTypeGroupColumn]).Value2.ToString();
childElements = (from children in parentNode.Descendants(childType).Descendants(gx + "MultiTrack")
where children.Attribute("id").Value == id
select children).ToArray <XElement>();
if (childElements.Length < 1) // If the Placemark doesn't exist, create it
{
MultiTrack multiTrack = new MultiTrack(id, this.trackInterpolate);
if (this.hasAltitude)
{
multiTrack.hasAltitude = true;
multiTrack.altitudeMode = this.altitudeModeIntToEnum[this.altitudeMode];
}
if (childType == "Placemark")
{
if (this.hasModel)
{
placemark.styleUrl = null;
}
XElement xPlacemark = (XElement)placemark.ToXNode();
xPlacemark.Descendants("TimeStamp").Remove();
parentNode.Add(xPlacemark);
parentNode = xPlacemark;
}
XElement xMultiTrack = (XElement)multiTrack.ToXNode();
parentNode.Add(xMultiTrack);
parentNode = xMultiTrack;
}
else // If the placemark exists, use it
{
parentNode = childElements.First();
}
childType = gx + "MultiTrack";
break;
}
#endregion
switch (this.dataType)
{
case 0: // Point
geometry = new Point(new Geometry.Coordinates(coordinateSet));
if (this.hasAltitude)
{
((Point)geometry).extrude = this.extrude;
}
break;
case 1: // Line String
id = ((Excel.Range) this.range.Cells[row, this.dataTypeGroupColumn]).Value2.ToString();
childElements = (from children in parentNode.Descendants(childType).Descendants("LineString")
where children.Attribute("id").Value.ToString() == id
select children).ToArray <XElement>();
if (childElements.Length < 1) // LineString does not exist
{
geometry = new LineString(id, new Geometry.Coordinates(coordinateSet));
if (this.hasAltitude)
{
((LineString)geometry).extrude = this.extrude;
((LineString)geometry).tessellate = this.tesselllate;
}
}
else // LineString exists, add coordinates
{
XElement coordinates = childElements[0].Element("coordinates");
coordinates.SetValue(coordinates.Value + " " + coordinateSet.getString());
updateDescriptionTable(ref this.range, ref row, ref document, (XElement)childElements[0].Parent);
addElements = false;
}
break;
case 2: // Linear Ring
id = ((Excel.Range) this.range.Cells[row, this.dataTypeGroupColumn]).Value2.ToString();
if (childType != "Polygon")
{
childElements = (from children in parentNode.Descendants(childType).Descendants("LinearRing")
where children.Attribute("id").Value == id
select children).ToArray <XElement>();
}
else
{
childElements = (from children in parentNode.Descendants().Descendants("LinearRing")
where children.Attribute("id").Value == id
select children).ToArray <XElement>();
}
if (childElements.Length < 1) // LinearRing does not exist
{
geometry = new LinearRing(id, new Geometry.Coordinates(coordinateSet));
if (this.hasAltitude && childType != "Polygon")
{
((LinearRing)geometry).extrude = this.extrude;
((LinearRing)geometry).tessellate = this.tesselllate;
}
if (childType == "Polygon")
{
if (!parentNode.Descendants("outerBoundaryIs").Any())
{
parentNode.Add(new XElement("outerBoundaryIs", geometry.ToXNode()));
}
else
{
parentNode.Add(new XElement("innerBoundaryIs", geometry.ToXNode()));
updateDescriptionTable(ref this.range, ref row, ref document, parentNode.Parent);
}
addElements = false;
}
}
else // LinearRing exists, add coordinates
{
XElement coordinates = childElements[0].Element("coordinates");
coordinates.SetValue(coordinates.Value + " " + coordinateSet.getString());
updateDescriptionTable(ref this.range, ref row, ref document, childElements[0].Parent);
addElements = false;
}
break;
case 3: // Model
geometry = new Model(new Location(coordinateSet), modelOrientation, modelScale, modelLink);
break;
case 4: // Track
Orientation trackOrientation = null;
if (this.trackHeadingColumn > 0 || this.trackTiltColumn > 0 || this.trackRollColumn > 0)
{
double trackHeading = 0.0;
double trackTilt = 0.0;
double trackRoll = 0.0;
if (this.trackHeadingColumn > 0)
{
double.TryParse(((Excel.Range) this.range.Cells[row, this.trackHeadingColumn]).Value2.ToString(), out trackHeading);
}
if (this.trackTiltColumn > 0)
{
double.TryParse(((Excel.Range) this.range.Cells[row, this.trackTiltColumn]).Value2.ToString(), out trackTilt);
}
if (this.trackRollColumn > 0)
{
double.TryParse(((Excel.Range) this.range.Cells[row, this.trackRollColumn]).Value2.ToString(), out trackRoll);
}
trackOrientation = new Orientation(trackHeading, trackTilt, trackRoll);
}
id = ((Excel.Range) this.range.Cells[row, this.dataTypeGroupColumn]).Value2.ToString();
if (childType != gx + "MultiTrack")
{
childElements = (from children in parentNode.Descendants(childType).Descendants(gx + "Track")
where children.Attribute("id").Value == id
select children).ToArray <XElement>();
}
else
{
childElements = (from children in parentNode.Descendants(gx + "Track")
where children.Attribute("id").Value == id
select children).ToArray <XElement>();
}
if (childElements.Length < 1) // If the placemark doesn't exist, create it
{
geometry = new Track(id, new Geometry.Coordinates(coordinateSet));
if (this.hasTimeStamp)
{
((Track)geometry).whens = new TimeStamp[] { (TimeStamp)placemark.timePrimitive };
}
if (trackOrientation != null)
{
((Track)geometry).angles = new Orientation[] { trackOrientation };
}
if (this.hasModel)
{
((Track)geometry).model = new Model(modelOrientation, modelScale, modelLink);
}
if (childType == gx + "MultiTrack" && parentNode.Descendants(gx + "Track").Any())
{
updateDescriptionTable(ref this.range, ref row, ref document, parentNode.Parent);
}
}
else
{
XElement track = childElements[0];
if (this.hasTimeStamp)
{
(from whens in track.Descendants("when") select whens).Last().AddAfterSelf(((XElement)placemark.timePrimitive.ToXNode()).Descendants("when"));
}
(from coords in track.Descendants(gx + "coord") select coords).Last().AddAfterSelf(new XElement(gx + "coord", coordinateSet.getString().Replace(',', ' ')));
if (trackOrientation != null)
{
(from angles in track.Descendants(gx + "angles") select angles).Last().AddAfterSelf(new XElement(gx + "angles", trackOrientation.getString()));
}
updateDescriptionTable(ref this.range, ref row, ref document, childElements[0].Parent);
addElements = false;
}
break;
}
if (addElements)
{
if (this.hasAltitude && this.multiType != 1)
{
geometry.hasAltitude = true;
geometry.altitudeMode = this.altitudeModeIntToEnum[this.altitudeMode];
}
if (childType == "Placemark")
{
if (this.dataType == 4)
{
placemark.timePrimitive = null;
}
placemark.geometry = geometry;
parentNode.Add(placemark.ToXNode());
}
else
{
parentNode.Add(geometry.ToXNode());
}
}
toolStripProgressBar.PerformStep();
}
return(kml.ToString());
}
private void ExtractStyleMaps(Element kml)
{
_styleMaps = new List<StyleMap>();
foreach (var style in kml.Flatten().OfType<StyleMapCollection>())
{
var styleMap = new StyleMap { Id = style.Id };
_styleMaps.Add(styleMap);
style.ToList().ForEach(x =>
{
if (x.State != null)
switch (x.State.Value)
{
case StyleState.Normal:
styleMap.NormalStyleUrl = x.StyleUrl.ToString().Replace("#", "");
break;
case StyleState.Highlight:
styleMap.HighlightStyleUrl = x.StyleUrl.ToString().Replace("#", "");
break;
}
});
}
}
//public FileContentResult DownloadKMLTimeLine2(int id = 0)
//{
// var route = db.Flights.Where(r => r.FlightID == id).Select(r => r.RouteID).FirstOrDefault();
// if (route == null) route = id; //patch if route is for some reason empty
// var flights = db.Flights.Where(r => r.RouteID == route).Select(r => new { r.FlightID }).ToList();
// var doc = new Document();
// doc.Id = "Route";
// doc.Name = "Route";
// foreach (var f in flights)
// {
// var folder = new Folder();
// folder.Id = f.FlightID.ToString();
// folder.Name = "Flight " + f.FlightID;
// var i = flights.IndexOf(f);
// var flightPointStylesHide = new FlightPointStyles(i,0);
// var flightPointStylesShow = new FlightPointStyles(i,1);
// //var docStyle = flightPointStylesHide.style;
// folder.AddStyle(flightPointStylesHide.style);
// folder.AddStyle(flightPointStylesShow.style);
// var styleMap = new StyleMap(flightPointStylesHide.style, flightPointStylesShow.style).styleMap;
// folder.AddStyle(styleMap);
// var placemarkSet = new FlightPlacemarkPoint();
// placemarkSet.styleUrlRef = styleMap.Id;
// placemarkSet.getFlightPlacemarkPoints(f.FlightID);
// foreach (var p in placemarkSet.placemarks)
// {
// folder.AddFeature(p);
// }
// doc.AddFeature(folder);
// }
// var kml = new Kml();
// kml.Feature = doc;
// KmlFile kmlFile = KmlFile.Create(kml, true);
// //using (var stream = System.IO.File.OpenWrite("C:/temp/kmlfile.kml"))
// //{
// // kmlFile.Save(stream);
// //};
// using (var stream = new System.IO.MemoryStream())
// {
// kmlFile.Save(stream);
// var kmlFileName = "Flight_" + id + ".kml";
// var fileBytes = new System.Text.UTF8Encoding().GetBytes(new System.Text.UTF8Encoding().GetString(stream.ToArray()));
// return File(fileBytes, "application/vnd.google-earth.kml+xml", kmlFileName);
// };
//}
public FileContentResult DownloadKMLTimeLine(int id = 0)
{
var route = db.Flights.Where(r => r.FlightID == id).Select(r => r.RouteID).FirstOrDefault();
if (route == null)
{
route = id; //patch if route is for some reason empty
}
var flights = db.Flights.Where(r => r.RouteID == route).Select(r => new { r.FlightID }).ToList();
var doc = new Document();
doc.Id = "Route" + id;
doc.Name = "Route " + id;
foreach (var f in flights)
{
var folder = new Folder();
folder.Id = f.FlightID.ToString();
folder.Name = "Flight " + f.FlightID;
var i = flights.IndexOf(f);
var flightPointStylesHide = new FlightPointStyles(i, 0);
var flightPointStylesShow = new FlightPointStyles(i, 1);
//var docStyle = flightPointStylesHide.style;
folder.AddStyle(flightPointStylesHide.style);
folder.AddStyle(flightPointStylesShow.style);
var styleMap = new StyleMap(flightPointStylesHide.style, flightPointStylesShow.style).styleMap;
folder.AddStyle(styleMap);
var flightLineStyles = new FlightLineStyles(i);
var docStyleLine = flightLineStyles.style;
folder.AddStyle(docStyleLine);
var placemarkSet = new FlightPlacemarkPoint();
placemarkSet.styleUrlRef = styleMap.Id;
placemarkSet.getFlightPlacemarkPoints(f.FlightID);
foreach (var p in placemarkSet.placemarks)
{
folder.AddFeature(p);
}
var placemarkLineString = new FlightPlacemarkLineString(f.FlightID);
placemarkLineString.styleUrlRef = docStyleLine.Id;
folder.AddFeature(placemarkLineString.placemark);
doc.AddFeature(folder);
}
var kml = new Kml();
kml.Feature = doc;
KmlFile kmlFile = KmlFile.Create(kml, true);
//using (var stream = System.IO.File.OpenWrite("C:/temp/kmlfile.kml"))
//{
// kmlFile.Save(stream);
//};
using (var stream = new System.IO.MemoryStream())
{
kmlFile.Save(stream);
var kmlFileName = "Flight_" + id + ".kml";
var fileBytes = new System.Text.UTF8Encoding().GetBytes(new System.Text.UTF8Encoding().GetString(stream.ToArray()));
return(File(fileBytes, "application/vnd.google-earth.kml+xml", kmlFileName));
};
}
/// <summary>
/// Create KML styles
/// </summary>
/// <returns>A list of KML abstract styles.</returns>
public static List<AbstractStyleSelector> BuildStyles()
{
List<AbstractStyleSelector> styles = new List<AbstractStyleSelector>();
// Styles for each activity
foreach (string[] styleDiff in STYLE_DIFFS)
{
styles.Add(new Style()
{
id = "sn" + styleDiff[0],
IconStyle = new IconStyle()
{
color = new Color(styleDiff[1]),
scale = SN_SCALE,
Icon = SHADED_DOT_ICON
},
LabelStyle = new LabelStyle()
{
color = new Color(OPAQUE_WHITE)
}
});
styles.Add(new Style()
{
id = "sh" + styleDiff[0],
IconStyle = new IconStyle()
{
color = new Color(styleDiff[1]),
scale = SH_SCALE,
Icon = SHADED_DOT_ICON
},
LabelStyle = new LabelStyle()
{
color = new Color(TRANSPARENT_WHITE)
}
});
// Add a style map that correlates the two new n(ormal) and h(ighlight)
// styles
StyleMap sm = new StyleMap("msn" + styleDiff[0]);
sm.Pairs.Add(new StyleMap.StyleMapEntry()
{
Key = StyleMap.StyleState.Normal,
StyleUrl = "#sn" + styleDiff[0]
});
sm.Pairs.Add(new StyleMap.StyleMapEntry()
{
Key = StyleMap.StyleState.Highlight,
StyleUrl = "#sh" + styleDiff[0]
});
styles.Add(sm);
}
// Add pushpins
foreach (string pushpinColor in PUSHPIN_COLORS)
{
Icon pushpinIcon = new Icon(String.Format(PUSHPIN_FORMAT, pushpinColor));
string snId = String.Format("sn_{0}pushpinNormal", pushpinColor);
styles.Add(new Style()
{
id = snId,
IconStyle = new IconStyle()
{
id = "mystyle",
scale = PUSHPIN_SCALE,
Icon = pushpinIcon
},
LabelStyle = new LabelStyle()
{
color = new Color(OPAQUE_WHITE)
}
});
string shId = String.Format("sn_{0}pushpinHighlight", pushpinColor);
styles.Add(new Style()
{
id = shId,
IconStyle = new IconStyle()
{
id = "mystyle",
scale = PUSHPIN_SCALE,
Icon = pushpinIcon
},
LabelStyle = new LabelStyle()
{
color = new Color(TRANSPARENT_WHITE)
}
});
// Add a style map for the two pushpin styles
StyleMap sm = new StyleMap(String.Format("msn_{0}pushpin", pushpinColor));
sm.Pairs.Add(new StyleMap.StyleMapEntry()
{
Key = StyleMap.StyleState.Normal,
StyleUrl = "#" + snId
});
sm.Pairs.Add(new StyleMap.StyleMapEntry()
{
Key = StyleMap.StyleState.Highlight,
StyleUrl = "#" + shId
});
styles.Add(sm);
}
// Add line styles
// Normal VMS track
styles.Add(new Style()
{
id = "vms_track",
LineStyle = new LineStyle()
{
color = new Color("ff77fff5"),
width = 1.5F
}
});
// Highlighted VMS track
styles.Add(new Style()
{
id = "vms_track_hl",
LineStyle = new LineStyle()
{
color = new Color("ff00aaa5"),
width = 1.5F
}
});
StyleMap vmsStyleMap = new StyleMap("msn_vms");
vmsStyleMap.Pairs.Add(new StyleMap.StyleMapEntry()
{
Key = StyleMap.StyleState.Normal,
StyleUrl = "#vms_track"
});
vmsStyleMap.Pairs.Add(new StyleMap.StyleMapEntry()
{
Key = StyleMap.StyleState.Highlight,
StyleUrl = "#vms_track_hl"
});
styles.Add(vmsStyleMap);
return styles;
}