private void GenerateWorksheetAContentSubsectorPollutionSourceFieldSheet(WorksheetPart worksheetPart, Workbook workbook, string SheetName, int SheetOrdinal, bool ActivePollutionSource)
{
BaseEnumService baseEnumService = new BaseEnumService(_TaskRunnerBaseService._BWObj.appTaskModel.Language);
TVItemService tvItemService = new TVItemService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
PolSourceSiteService polSourceSiteService = new PolSourceSiteService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
//PolSourceObservationService polSourceObservationService = new PolSourceObservationService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
//MWQMSubsectorService mwqmSubsectorService = new MWQMSubsectorService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
MergeCells mergeCells = new MergeCells();
Row row = new Row();
Cell cell = new Cell();
Hyperlinks hyperlinks = new Hyperlinks();
string Id = XlsxBase.sheetNameAndIDList[SheetOrdinal].SheetID;
XlsxBase.CurrentColumn = 0;
XlsxBase.CurrentRow = 0;
XlsxBase.CurrentColumnProp = 0;
Worksheet worksheet = new Worksheet()
{
MCAttributes = new MarkupCompatibilityAttributes()
{
Ignorable = "x14ac"
}
};
worksheet.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
worksheet.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
worksheet.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
SheetViews sheetViews = new SheetViews();
SheetView sheetView = new SheetView()
{
TabSelected = true, WorkbookViewId = (UInt32Value)0U
};
Selection selection = new Selection()
{
ActiveCell = "A1", SequenceOfReferences = new ListValue <StringValue>()
{
InnerText = "A1"
}
};
sheetView.Append(selection);
sheetViews.Append(sheetView);
SheetFormatProperties sheetFormatProperties = new SheetFormatProperties()
{
DefaultRowHeight = 15D, DyDescent = 0.25D
};
Columns columns = new Columns();
List <double?> columnWidthList = new List <double?>()
{
7D, 10D, 90D, 12D, 12D, 10D, 14D, 20D
};
foreach (double?width in columnWidthList)
{
Column colum = XlsxBase.AddColumnProp(columns, width);
}
SheetData sheetData = new SheetData();
TVItemModel tvItemModelSubsector = tvItemService.GetTVItemModelWithTVItemIDDB(_TaskRunnerBaseService._BWObj.appTaskModel.TVItemID);
//MWQMSubsectorModel mwqmSubsectorModel = mwqmSubsectorService.GetMWQMSubsectorModelWithMWQMSubsectorTVItemIDDB(_TaskRunnerBaseService._BWObj.appTaskModel.TVItemID);
XlsxBase.CurrentRowHeight = 28D;
XlsxBase.CurrentFontSize = 24;
XlsxBase.CurrentHorizontalAlignmentValue = HorizontalAlignmentValues.Center;
XlsxBase.CurrentBorderStyleValue = BorderStyleValues.Thin;
XlsxBase.CurrentBottomBorder = true;
row = XlsxBase.AddRow();
string URL = _TaskRunnerBaseService.GetUrlFromTVItem(tvItemModelSubsector);
XlsxBase.CurrentFontColor = System.Drawing.Color.Blue;
cell = XlsxBase.AddCellHyperlink(hyperlinks, row, tvItemModelSubsector.TVText, URL);
XlsxBase.CurrentFontColor = null;
//cell = XlsxBase.AddCellString(row, tvItemModel.TVText);
cell = XlsxBase.AddCellString(row, null);
sheetData.Append(row);
MergeCell mergeCell = new MergeCell()
{
Reference = "A" + XlsxBase.CurrentRow.ToString() + ":H" + XlsxBase.CurrentRow.ToString()
};
mergeCells.Append(mergeCell);
List <TVItemModel> tvItemModelPolSourceList = tvItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(_TaskRunnerBaseService._BWObj.appTaskModel.TVItemID, TVTypeEnum.PolSourceSite);
XlsxBase.CurrentRowHeight = 24D;
XlsxBase.CurrentFontSize = 18;
XlsxBase.CurrentBorderStyleValue = BorderStyleValues.Thin;
XlsxBase.CurrentBottomBorder = true;
XlsxBase.CurrentHorizontalAlignmentValue = HorizontalAlignmentValues.Center;
row = XlsxBase.AddRow();
XlsxBase.CurrentFontColor = null;
cell = XlsxBase.AddCellString(row, "Site");
cell = XlsxBase.AddCellString(row, "Type");
cell = XlsxBase.AddCellString(row, "Observation");
cell = XlsxBase.AddCellString(row, "Lat");
cell = XlsxBase.AddCellString(row, "Lng");
cell = XlsxBase.AddCellString(row, "Active");
cell = XlsxBase.AddCellString(row, "Update");
cell = XlsxBase.AddCellString(row, "Civic Address");
sheetData.Append(row);
XlsxBase.CurrentRowHeight = 160D;
XlsxBase.CurrentFontSize = 12;
XlsxBase.CurrentHorizontalAlignmentValue = HorizontalAlignmentValues.Left;
List <PolSourceSiteModel> polSourceSiteModelList = polSourceSiteService.GetPolSourceSiteModelListWithSubsectorTVItemIDDB(tvItemModelSubsector.TVItemID);
int countPolSourceSite = 0;
foreach (PolSourceSiteModel polSourceSiteModel in polSourceSiteModelList.OrderBy(c => c.Site).ToList())
{
bool IsActive = (from c in tvItemModelPolSourceList
where c.TVItemID == polSourceSiteModel.PolSourceSiteTVItemID
select c.IsActive).FirstOrDefault();
if (ActivePollutionSource != IsActive)
{
continue;
}
countPolSourceSite += 1;
PolSourceObservationModel polSourceObservationModel = polSourceSiteService._PolSourceObservationService.GetPolSourceObservationModelLatestWithPolSourceSiteTVItemIDDB(polSourceSiteModel.PolSourceSiteTVItemID);
List <MapInfoPointModel> mapInfoPointModelList = polSourceSiteService._MapInfoService._MapInfoPointService.GetMapInfoPointModelListWithTVItemIDAndTVTypeAndMapInfoDrawTypeDB(polSourceSiteModel.PolSourceSiteTVItemID, TVTypeEnum.PolSourceSite, MapInfoDrawTypeEnum.Point);
row = XlsxBase.AddRow();
if (countPolSourceSite % 5 == 0)
{
XlsxBase.CurrentBorderStyleValue = BorderStyleValues.Thin;
XlsxBase.CurrentBottomBorder = true;
}
else
{
XlsxBase.CurrentBorderStyleValue = null;
XlsxBase.CurrentBottomBorder = false;
}
XlsxBase.CurrentHorizontalAlignmentValue = HorizontalAlignmentValues.Center;
cell = XlsxBase.AddCellString(row, polSourceSiteModel.Site.ToString());
if (polSourceObservationModel != null)
{
List <PolSourceObservationIssueModel> polSourceObservationIssueModelList = polSourceSiteService._PolSourceObservationService._PolSourceObservationIssueService.GetPolSourceObservationIssueModelListWithPolSourceObservationIDDB(polSourceObservationModel.PolSourceObservationID);
string SelectedObservation = "Selected: \r\n";
int PolSourceObsInfoInt = 0;
foreach (PolSourceObservationIssueModel polSourceObservationIssueModel in polSourceObservationIssueModelList)
{
List <int> observationInfoList = polSourceObservationIssueModel.ObservationInfo.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).ToList().Select(c => int.Parse(c)).ToList();
PolSourceObsInfoInt = observationInfoList.Where(c => (c > 10500 && c < 10599) || (c > 15200 && c < 15299)).FirstOrDefault();
foreach (PolSourceObsInfoEnum polSourceObsInfo in polSourceObservationIssueModel.PolSourceObsInfoList)
{
SelectedObservation += baseEnumService.GetEnumText_PolSourceObsInfoReportEnum(polSourceObsInfo);
}
SelectedObservation += "\r\n\r\n";
}
if (PolSourceObsInfoInt > 0)
{
cell = XlsxBase.AddCellString(row, baseEnumService.GetEnumText_PolSourceObsInfoEnum((PolSourceObsInfoEnum)PolSourceObsInfoInt));
}
else
{
cell = XlsxBase.AddCellString(row, "Empty");
}
}
XlsxBase.CurrentHorizontalAlignmentValue = HorizontalAlignmentValues.Left;
XlsxBase.WrapText = true;
if (polSourceObservationModel != null)
{
List <PolSourceObservationIssueModel> polSourceObservationIssueModelList = polSourceSiteService._PolSourceObservationService._PolSourceObservationIssueService.GetPolSourceObservationIssueModelListWithPolSourceObservationIDDB(polSourceObservationModel.PolSourceObservationID);
string SelectedObservation = "Selected: \r\n";
int PolSourceObsInfoInt = 0;
foreach (PolSourceObservationIssueModel polSourceObservationIssueModel in polSourceObservationIssueModelList)
{
List <int> observationInfoList = polSourceObservationIssueModel.ObservationInfo.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).ToList().Select(c => int.Parse(c)).ToList();
foreach (PolSourceObsInfoEnum polSourceObsInfo in polSourceObservationIssueModel.PolSourceObsInfoList)
{
SelectedObservation += baseEnumService.GetEnumText_PolSourceObsInfoReportEnum(polSourceObsInfo);
}
SelectedObservation += "\r\n\r\n";
}
if (PolSourceObsInfoInt > 0)
{
cell = XlsxBase.AddCellString(row, "Written: \r\n" + (string.IsNullOrWhiteSpace(polSourceObservationModel.Observation_ToBeDeleted) ? "" : polSourceObservationModel.Observation_ToBeDeleted.ToString()) + "\r\n\r\n"
+ SelectedObservation);
}
else
{
cell = XlsxBase.AddCellString(row, "Written: \r\n\r\n" + SelectedObservation);
}
}
XlsxBase.CurrentHorizontalAlignmentValue = HorizontalAlignmentValues.Center;
Alignment alignment1 = new Alignment()
{
WrapText = true
};
if (mapInfoPointModelList.Count > 0)
{
cell = XlsxBase.AddCellString(row, mapInfoPointModelList[0].Lat.ToString("F5"));
cell = XlsxBase.AddCellString(row, mapInfoPointModelList[0].Lng.ToString("F5"));
}
else
{
cell = XlsxBase.AddCellString(row, "");
cell = XlsxBase.AddCellString(row, "");
}
TVItemModel tvItemModelPolSource = tvItemService.GetTVItemModelWithTVItemIDDB(polSourceSiteModel.PolSourceSiteTVItemID);
cell = XlsxBase.AddCellString(row, tvItemModelPolSource.IsActive.ToString());
cell = XlsxBase.AddCellString(row, polSourceObservationModel.ObservationDate_Local.ToString("yyyy MMM dd"));
cell = XlsxBase.AddCellString(row, "empty");
sheetData.Append(row);
}
if (countPolSourceSite > 0)
{
DefinedNames definedNames1 = new DefinedNames();
DefinedName definedName1 = new DefinedName()
{
Name = "_xlnm._FilterDatabase", LocalSheetId = (UInt32Value)0U, Hidden = true
};
definedName1.Text = "'" + SheetName + "'" + "!$A$2:$H$" + (countPolSourceSite + 2).ToString();
definedNames1.Append(definedName1);
workbook.Append(definedNames1);
AutoFilter autoFilter = new AutoFilter()
{
Reference = "a2:B" + (countPolSourceSite + 2).ToString()
};
worksheet.Append(autoFilter);
}
PageMargins pageMargins = new PageMargins()
{
Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D
};
PageSetup pageSetup = new PageSetup()
{
Orientation = OrientationValues.Portrait, Id = "rId" + SheetOrdinal.ToString()
};
worksheet.Append(sheetViews);
worksheet.Append(sheetFormatProperties);
if (columns.ChildElements.Count > 0)
{
worksheet.Append(columns);
}
worksheet.Append(sheetData);
mergeCells.Count = (UInt32Value)((UInt32)mergeCells.ChildElements.Count);
if (mergeCells.ChildElements.Count > 0)
{
worksheet.Append(mergeCells);
}
if (XlsxBase.UsedHyperlinkList.Count > 0)
{
worksheet.Append(hyperlinks);
}
worksheet.Append(pageMargins);
worksheet.Append(pageSetup);
worksheetPart.Worksheet = worksheet;
}
public void Generate(FileInfo fi)
{
BaseEnumService baseEnumService = new BaseEnumService(_TaskRunnerBaseService._BWObj.appTaskModel.Language);
TVItemService tvItemService = new TVItemService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
MapInfoService mapInfoService = new MapInfoService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
PolSourceSiteService polSourceSiteService = new PolSourceSiteService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
InfrastructureService infrastructureService = new InfrastructureService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
if (_TaskRunnerBaseService._BWObj.appTaskModel.Language == "fr")
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("fr-CA");
Thread.CurrentThread.CurrentUICulture = new CultureInfo("fr-CA");
}
else
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-CA");
Thread.CurrentThread.CurrentUICulture = new CultureInfo("en-CA");
}
TVFileService tvFileService = new TVFileService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
string ServerFilePath = tvFileService.GetServerFilePath(_TaskRunnerBaseService._BWObj.appTaskModel.TVItemID);
DirectoryInfo di = new DirectoryInfo(ServerFilePath);
if (!di.Exists)
{
di.Create();
}
if (fi.Exists)
{
fi.Delete();
}
StringBuilder sbKML = new StringBuilder();
sbKML.AppendLine(@"<?xml version=""1.0"" encoding=""UTF-8""?>");
sbKML.AppendLine(@"<kml xmlns=""http://www.opengis.net/kml/2.2"" xmlns:gx=""http://www.google.com/kml/ext/2.2"" xmlns:kml=""http://www.opengis.net/kml/2.2"" xmlns:atom=""http://www.w3.org/2005/Atom"">");
sbKML.AppendLine(@"<Document>");
sbKML.AppendLine(@" <name>" + _TaskRunnerBaseService.generateDocParams.FileName + "</name>");
sbKML.AppendLine(@" <StyleMap id=""msn_ylw-pushpin"">");
sbKML.AppendLine(@" <Pair>");
sbKML.AppendLine(@" <key>normal</key>");
sbKML.AppendLine(@" <styleUrl>#sn_ylw-pushpin</styleUrl>");
sbKML.AppendLine(@" </Pair>");
sbKML.AppendLine(@" <Pair>");
sbKML.AppendLine(@" <key>highlight</key>");
sbKML.AppendLine(@" <styleUrl>#sh_ylw-pushpin</styleUrl>");
sbKML.AppendLine(@" </Pair>");
sbKML.AppendLine(@" </StyleMap>");
sbKML.AppendLine(@" <Style id=""sh_ylw-pushpin"">");
sbKML.AppendLine(@" <IconStyle>");
sbKML.AppendLine(@" <scale>1.2</scale>");
sbKML.AppendLine(@" </IconStyle>");
sbKML.AppendLine(@" <LineStyle>");
sbKML.AppendLine(@" <color>ff00ff00</color>");
sbKML.AppendLine(@" <width>1.5</width>");
sbKML.AppendLine(@" </LineStyle>");
sbKML.AppendLine(@" <PolyStyle>");
sbKML.AppendLine(@" <color>0000ff00</color>");
sbKML.AppendLine(@" </PolyStyle>");
sbKML.AppendLine(@" </Style>");
sbKML.AppendLine(@" <Style id=""sn_ylw-pushpin"">");
sbKML.AppendLine(@" <LineStyle>");
sbKML.AppendLine(@" <color>ff00ff00</color>");
sbKML.AppendLine(@" <width>1.5</width>");
sbKML.AppendLine(@" </LineStyle>");
sbKML.AppendLine(@" <PolyStyle>");
sbKML.AppendLine(@" <color>0000ff00</color>");
sbKML.AppendLine(@" </PolyStyle>");
sbKML.AppendLine(@" </Style>");
sbKML.AppendLine(@" <StyleMap id=""msn_grn-pushpin"">");
sbKML.AppendLine(@" <Pair>");
sbKML.AppendLine(@" <key>normal</key>");
sbKML.AppendLine(@" <styleUrl>#sn_grn-pushpin</styleUrl>");
sbKML.AppendLine(@" </Pair>");
sbKML.AppendLine(@" <Pair>");
sbKML.AppendLine(@" <key>highlight</key>");
sbKML.AppendLine(@" <styleUrl>#sh_grn-pushpin</styleUrl>");
sbKML.AppendLine(@" </Pair>");
sbKML.AppendLine(@" </StyleMap>");
sbKML.AppendLine(@" <Style id=""sh_grn-pushpin"">");
sbKML.AppendLine(@" <IconStyle>");
sbKML.AppendLine(@" <scale>1.2</scale>");
sbKML.AppendLine(@" </IconStyle>");
sbKML.AppendLine(@" <LineStyle>");
sbKML.AppendLine(@" <color>ff0000ff</color>");
sbKML.AppendLine(@" <width>1.5</width>");
sbKML.AppendLine(@" </LineStyle>");
sbKML.AppendLine(@" <PolyStyle>");
sbKML.AppendLine(@" <color>000000ff</color>");
sbKML.AppendLine(@" </PolyStyle>");
sbKML.AppendLine(@" </Style>");
sbKML.AppendLine(@" <Style id=""sn_grn-pushpin"">");
sbKML.AppendLine(@" <LineStyle>");
sbKML.AppendLine(@" <color>ff0000ff</color>");
sbKML.AppendLine(@" <width>1.5</width>");
sbKML.AppendLine(@" </LineStyle>");
sbKML.AppendLine(@" <PolyStyle>");
sbKML.AppendLine(@" <color>000000ff</color>");
sbKML.AppendLine(@" </PolyStyle>");
sbKML.AppendLine(@" </Style>");
TVItemModel tvItemModelSubsector = tvItemService.GetTVItemModelWithTVItemIDDB(_TaskRunnerBaseService._BWObj.appTaskModel.TVItemID);
List <MapInfoPointModel> mapInfoPointModelList = mapInfoService._MapInfoPointService.GetMapInfoPointModelListWithTVItemIDAndTVTypeAndMapInfoDrawTypeDB(tvItemModelSubsector.TVItemID, TVTypeEnum.Subsector, MapInfoDrawTypeEnum.Point);
sbKML.AppendLine(@" <Folder>");
sbKML.AppendLine(@" <name>Subsector</name>");
sbKML.AppendLine(@" <visibility>0</visibility>");
// Doing Point
sbKML.AppendLine(@" <Placemark>");
sbKML.AppendLine(@" <name>" + tvItemModelSubsector.TVText + "</name>");
sbKML.AppendLine(@" <visibility>0</visibility>");
sbKML.AppendLine(@"<styleUrl>#msn_ylw-pushpin</styleUrl>");
//sbKMZ.AppendLine(@" <description>");
//sbKMZ.AppendLine(@"<![CDATA[");
//sbKMZ.AppendLine(@"<a href=""" + _TaskRunnerBaseService.GetUrlFromTVItem(tvItemModelRoot) + @""">" + tvItemModelRoot.TVText + "</a>");
//sbKMZ.AppendLine(@"]]>");
//sbKMZ.AppendLine(@" </description>");
sbKML.AppendLine(@" <Point>");
sbKML.AppendLine(@" <coordinates>"+ mapInfoPointModelList[0].Lng + "," + mapInfoPointModelList[0].Lat + ",0</coordinates>");
sbKML.AppendLine(@" </Point>");
sbKML.AppendLine(@" </Placemark>");
// Doing Polygon
sbKML.AppendLine(@" <Placemark>");
sbKML.AppendLine(@" <name>"+ tvItemModelSubsector.TVText + " (poly)</name>");
sbKML.AppendLine(@" <visibility>0</visibility>");
sbKML.AppendLine(@"<styleUrl>#msn_ylw-pushpin</styleUrl>");
//sbKMZ.AppendLine(@" <description>");
//sbKMZ.AppendLine(@"<![CDATA[");
//sbKMZ.AppendLine(@"<a href=""" + _TaskRunnerBaseService.GetUrlFromTVItem(tvItemModelCountry) + @""">" + tvItemModelCountry.TVText + "</a>");
//sbKMZ.AppendLine(@"]]>");
//sbKMZ.AppendLine(@" </description>");
sbKML.AppendLine(@" <Polygon>");
sbKML.AppendLine(@" <outerBoundaryIs>");
sbKML.AppendLine(@" <LinearRing>");
sbKML.AppendLine(@" <coordinates>");
mapInfoPointModelList = mapInfoService._MapInfoPointService.GetMapInfoPointModelListWithTVItemIDAndTVTypeAndMapInfoDrawTypeDB(tvItemModelSubsector.TVItemID, TVTypeEnum.Subsector, MapInfoDrawTypeEnum.Polygon);
foreach (MapInfoPointModel mapInfoPointModel in mapInfoPointModelList)
{
sbKML.AppendLine(mapInfoPointModel.Lng + "," + mapInfoPointModel.Lat + ",0 ");
}
sbKML.AppendLine(@" </coordinates>");
sbKML.AppendLine(@" </LinearRing>");
sbKML.AppendLine(@" </outerBoundaryIs>");
sbKML.AppendLine(@" </Polygon>");
sbKML.AppendLine(@" </Placemark>");
// Doing Municipalities
sbKML.AppendLine(@" <Folder>");
sbKML.AppendLine(@" <name>Municipalities</name>");
sbKML.AppendLine(@" <visibility>0</visibility>");
List <TVItemModel> tvItemModelMunicipalityList = tvItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelSubsector.TVItemID, TVTypeEnum.Municipality);
foreach (TVItemModel tvItemModelMunicipality in tvItemModelMunicipalityList)
{
sbKML.AppendLine(@" <Folder>");
sbKML.AppendLine(@" <name>" + tvItemModelMunicipality.TVText + "</name>");
sbKML.AppendLine(@" <visibility>0</visibility>");
// Doing point
sbKML.AppendLine(@" <Placemark>");
sbKML.AppendLine(@" <name>" + tvItemModelMunicipality.TVText + " ( Point)</name>");
sbKML.AppendLine(@" <visibility>0</visibility>");
sbKML.AppendLine(@"<styleUrl>#msn_ylw-pushpin</styleUrl>");
mapInfoPointModelList = mapInfoService._MapInfoPointService.GetMapInfoPointModelListWithTVItemIDAndTVTypeAndMapInfoDrawTypeDB(tvItemModelMunicipality.TVItemID, TVTypeEnum.Municipality, MapInfoDrawTypeEnum.Point);
sbKML.AppendLine(@" <Point>");
sbKML.AppendLine(@" <coordinates>"+ mapInfoPointModelList[0].Lng + "," + mapInfoPointModelList[0].Lat + ",0</coordinates>");
sbKML.AppendLine(@" </Point>");
sbKML.AppendLine(@" </Placemark>");
List <TVItemModel> tvItemModelInfrastructureList = tvItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelMunicipality.TVItemID, TVTypeEnum.Infrastructure);
List <InfrastructureModel> infrastructureModelList = new List <InfrastructureModel>();
foreach (TVItemModel tvItemModelInfrastructure in tvItemModelInfrastructureList)
{
infrastructureModelList.Add(infrastructureService.GetInfrastructureModelWithInfrastructureTVItemIDDB(tvItemModelInfrastructure.TVItemID));
}
// Doing WWTP
foreach (InfrastructureModel infrastructureModel in infrastructureModelList.Where(c => c.InfrastructureType == InfrastructureTypeEnum.WWTP).ToList())
{
sbKML.AppendLine(@" <Placemark>");
sbKML.AppendLine(@" <name>" + tvItemModelInfrastructureList.Where(c => c.TVItemID == infrastructureModel.InfrastructureTVItemID).Select(c => c.TVText).FirstOrDefault() + "</name>");
sbKML.AppendLine(@" <visibility>0</visibility>");
sbKML.AppendLine(@"<styleUrl>#msn_ylw-pushpin</styleUrl>");
sbKML.AppendLine(@" <description>");
sbKML.AppendLine(@"<![CDATA[");
sbKML.AppendLine(@"<pre>");
sbKML.AppendLine(@"Alarm System Type: " + baseEnumService.GetEnumText_AlarmSystemTypeEnum(infrastructureModel.AlarmSystemType) + "\r\n");
sbKML.AppendLine(@"Can overflow: " + infrastructureModel.CanOverflow.ToString() + "\r\n");
sbKML.AppendLine(@"Category: " + infrastructureModel.InfrastructureCategory + "\r\n");
sbKML.AppendLine(@"Collection System Type: " + baseEnumService.GetEnumText_CollectionSystemTypeEnum(infrastructureModel.CollectionSystemType) + "\r\n");
sbKML.AppendLine(@"Comments: " + infrastructureModel.Comment + "\r\n");
sbKML.AppendLine(@"DesignFlow (m3/day): " + infrastructureModel.DesignFlow_m3_day + "\r\n");
sbKML.AppendLine(@"Disinfection Type: " + baseEnumService.GetEnumText_DisinfectionTypeEnum(infrastructureModel.DisinfectionType) + "\r\n");
sbKML.AppendLine(@"Infrastructure Type: " + baseEnumService.GetEnumText_InfrastructureTypeEnum(infrastructureModel.InfrastructureType) + "\r\n");
sbKML.AppendLine(@"Average Flow (m3/day): " + infrastructureModel.AverageFlow_m3_day + "\r\n");
sbKML.AppendLine(@"AverageFlow_m3_day: " + infrastructureModel.PeakFlow_m3_day + "\r\n");
sbKML.AppendLine(@"Percent Flow Of Total (%): " + infrastructureModel.PercFlowOfTotal + "\r\n");
sbKML.AppendLine(@"Population Served: " + infrastructureModel.PopServed + "\r\n");
sbKML.AppendLine(@"Time Zone: " + infrastructureModel.TimeOffset_hour + "\r\n");
sbKML.AppendLine(@"Treatment Type: " + baseEnumService.GetEnumText_TreatmentTypeEnum(infrastructureModel.TreatmentType) + "\r\n");
List <MapInfoPointModel> mapInfoPointModelInfrastructureList = mapInfoService._MapInfoPointService.GetMapInfoPointModelListWithTVItemIDAndTVTypeAndMapInfoDrawTypeDB(infrastructureModel.InfrastructureTVItemID, TVTypeEnum.WasteWaterTreatmentPlant, MapInfoDrawTypeEnum.Point);
if (mapInfoPointModelInfrastructureList.Count > 0)
{
sbKML.AppendLine(@"Latitude Longitude: " + mapInfoPointModelInfrastructureList[0].Lat + " " + mapInfoPointModelInfrastructureList[0].Lng + "\r\n");
}
else
{
sbKML.AppendLine("Latitude Longitude: \r\n");
}
List <MapInfoPointModel> mapInfoPointModelInfrastructureOutfallList = mapInfoService._MapInfoPointService.GetMapInfoPointModelListWithTVItemIDAndTVTypeAndMapInfoDrawTypeDB(infrastructureModel.InfrastructureTVItemID, TVTypeEnum.Outfall, MapInfoDrawTypeEnum.Point);
if (mapInfoPointModelInfrastructureOutfallList.Count > 0)
{
sbKML.AppendLine(@"Outfall: Latitude Longitude: " + mapInfoPointModelInfrastructureOutfallList[0].Lat + " " + mapInfoPointModelInfrastructureOutfallList[0].Lng + "\r\n");
}
else
{
sbKML.AppendLine("Outfall: Latitude Longitude: \r\n");
}
sbKML.AppendLine("\r\n\r\n");
sbKML.AppendLine("Outfall Information\r\n\r\n");
sbKML.AppendLine(@"Average Depth (m): " + infrastructureModel.AverageDepth_m + "\r\n");
sbKML.AppendLine(@"Decay Rate (/day): " + infrastructureModel.DecayRate_per_day + "\r\n");
sbKML.AppendLine(@"Distance From Shore (m): " + infrastructureModel.DistanceFromShore_m + "\r\n");
sbKML.AppendLine(@"Far Field Velocity (m/s): " + infrastructureModel.FarFieldVelocity_m_s + "\r\n");
sbKML.AppendLine(@"Horizontal Angle (deg): " + infrastructureModel.HorizontalAngle_deg + "\r\n");
sbKML.AppendLine(@"Near Field Velocity (m/s): " + infrastructureModel.NearFieldVelocity_m_s + "\r\n");
sbKML.AppendLine(@"Number Of Ports: " + infrastructureModel.NumberOfPorts + "\r\n");
sbKML.AppendLine(@"Port Diameter (m): " + infrastructureModel.PortDiameter_m + "\r\n");
sbKML.AppendLine(@"Port Elevation (m): " + infrastructureModel.PortElevation_m + "\r\n");
sbKML.AppendLine(@"Port Spacing (m): " + infrastructureModel.PortSpacing_m + "\r\n");
sbKML.AppendLine(@"Receiving Water Concentration (FC /100 ml): " + infrastructureModel.ReceivingWater_MPN_per_100ml + "\r\n");
sbKML.AppendLine(@"Receiving Water Salinity (PSU): " + infrastructureModel.ReceivingWaterSalinity_PSU + "\r\n");
sbKML.AppendLine(@"Receiving Water Temperature (ºC): " + infrastructureModel.ReceivingWaterTemperature_C + "\r\n");
sbKML.AppendLine(@"Vertical Angle (deg): " + infrastructureModel.VerticalAngle_deg + "\r\n");
sbKML.AppendLine(@"</pre>");
sbKML.AppendLine(@"]]>");
sbKML.AppendLine(@" </description>");
sbKML.AppendLine(@" <Point>");
sbKML.AppendLine(@" <coordinates>"+ mapInfoPointModelInfrastructureList[0].Lng + "," + mapInfoPointModelInfrastructureList[0].Lat + ",0</coordinates>");
sbKML.AppendLine(@" </Point>");
sbKML.AppendLine(@" </Placemark>");
sbKML.AppendLine(@" <Placemark>");
sbKML.AppendLine(@" <name>Outfall " + tvItemModelInfrastructureList.Where(c => c.TVItemID == infrastructureModel.InfrastructureTVItemID).Select(c => c.TVText).FirstOrDefault() + "</name>");
sbKML.AppendLine(@" <visibility>0</visibility>");
sbKML.AppendLine(@"<styleUrl>#msn_grn-pushpin</styleUrl>");
sbKML.AppendLine(@" <Point>");
sbKML.AppendLine(@" <coordinates>"+ mapInfoPointModelInfrastructureOutfallList[0].Lng + "," + mapInfoPointModelInfrastructureOutfallList[0].Lat + ",0</coordinates>");
sbKML.AppendLine(@" </Point>");
sbKML.AppendLine(@" </Placemark>");
}
// Doing LS
foreach (InfrastructureModel infrastructureModel in infrastructureModelList.Where(c => c.InfrastructureType == InfrastructureTypeEnum.LiftStation).ToList())
{
sbKML.AppendLine(@" <Placemark>");
sbKML.AppendLine(@" <name>" + tvItemModelInfrastructureList.Where(c => c.TVItemID == infrastructureModel.InfrastructureTVItemID).Select(c => c.TVText).FirstOrDefault() + "</name>");
sbKML.AppendLine(@" <visibility>0</visibility>");
sbKML.AppendLine(@"<styleUrl>#msn_ylw-pushpin</styleUrl>");
sbKML.AppendLine(@" <description>");
sbKML.AppendLine(@"<![CDATA[");
sbKML.AppendLine(@"<pre>");
sbKML.AppendLine(@"Alarm System Type: " + baseEnumService.GetEnumText_AlarmSystemTypeEnum(infrastructureModel.AlarmSystemType) + "\r\n");
sbKML.AppendLine(@"Can overflow: " + infrastructureModel.CanOverflow.ToString() + "\r\n");
sbKML.AppendLine(@"Category: " + infrastructureModel.InfrastructureCategory + "\r\n");
sbKML.AppendLine(@"Collection System Type: " + baseEnumService.GetEnumText_CollectionSystemTypeEnum(infrastructureModel.CollectionSystemType) + "\r\n");
sbKML.AppendLine(@"Comments: " + infrastructureModel.Comment + "\r\n");
sbKML.AppendLine(@"Infrastructure Type: " + baseEnumService.GetEnumText_InfrastructureTypeEnum(infrastructureModel.InfrastructureType) + "\r\n");
sbKML.AppendLine(@"Percent Flow Of Total (%): " + infrastructureModel.PercFlowOfTotal + "\r\n");
List <MapInfoPointModel> mapInfoPointModelInfrastructureList = mapInfoService._MapInfoPointService.GetMapInfoPointModelListWithTVItemIDAndTVTypeAndMapInfoDrawTypeDB(infrastructureModel.InfrastructureTVItemID, TVTypeEnum.LiftStation, MapInfoDrawTypeEnum.Point);
if (mapInfoPointModelInfrastructureList.Count > 0)
{
sbKML.AppendLine(@"Latitude Longitude: " + mapInfoPointModelInfrastructureList[0].Lat + " " + mapInfoPointModelInfrastructureList[0].Lng + "\r\n");
}
else
{
sbKML.AppendLine("Latitude Longitude: \r\n");
}
List <MapInfoPointModel> mapInfoPointModelInfrastructureOutfallList = mapInfoService._MapInfoPointService.GetMapInfoPointModelListWithTVItemIDAndTVTypeAndMapInfoDrawTypeDB(infrastructureModel.InfrastructureTVItemID, TVTypeEnum.Outfall, MapInfoDrawTypeEnum.Point);
if (mapInfoPointModelInfrastructureOutfallList.Count > 0)
{
sbKML.AppendLine(@"Outfall: Latitude Longitude: " + mapInfoPointModelInfrastructureOutfallList[0].Lat + " " + mapInfoPointModelInfrastructureOutfallList[0].Lng + "\r\n");
}
else
{
sbKML.AppendLine("Outfall: Latitude Longitude: \r\n");
}
sbKML.AppendLine("\r\n\r\n");
sbKML.AppendLine("Outfall Information\r\n\r\n");
sbKML.AppendLine(@"Average Depth (m): " + infrastructureModel.AverageDepth_m + "\r\n");
sbKML.AppendLine(@"Decay Rate (/day): " + infrastructureModel.DecayRate_per_day + "\r\n");
sbKML.AppendLine(@"Distance From Shore (m): " + infrastructureModel.DistanceFromShore_m + "\r\n");
sbKML.AppendLine(@"Far Field Velocity (m/s): " + infrastructureModel.FarFieldVelocity_m_s + "\r\n");
sbKML.AppendLine(@"Horizontal Angle (deg): " + infrastructureModel.HorizontalAngle_deg + "\r\n");
sbKML.AppendLine(@"Near Field Velocity (m/s): " + infrastructureModel.NearFieldVelocity_m_s + "\r\n");
sbKML.AppendLine(@"Number Of Ports: " + infrastructureModel.NumberOfPorts + "\r\n");
sbKML.AppendLine(@"Port Diameter (m): " + infrastructureModel.PortDiameter_m + "\r\n");
sbKML.AppendLine(@"Port Elevation (m): " + infrastructureModel.PortElevation_m + "\r\n");
sbKML.AppendLine(@"Port Spacing (m): " + infrastructureModel.PortSpacing_m + "\r\n");
sbKML.AppendLine(@"Receiving Water Concentration (FC /100 ml): " + infrastructureModel.ReceivingWater_MPN_per_100ml + "\r\n");
sbKML.AppendLine(@"Receiving Water Salinity (PSU): " + infrastructureModel.ReceivingWaterSalinity_PSU + "\r\n");
sbKML.AppendLine(@"Receiving Water Temperature (ºC): " + infrastructureModel.ReceivingWaterTemperature_C + "\r\n");
sbKML.AppendLine(@"Vertical Angle (deg): " + infrastructureModel.VerticalAngle_deg + "\r\n");
sbKML.AppendLine(@"</pre>");
sbKML.AppendLine(@"]]>");
sbKML.AppendLine(@" </description>");
sbKML.AppendLine(@" <Point>");
sbKML.AppendLine(@" <coordinates>"+ mapInfoPointModelInfrastructureList[0].Lng + "," + mapInfoPointModelInfrastructureList[0].Lat + ",0</coordinates>");
sbKML.AppendLine(@" </Point>");
sbKML.AppendLine(@" </Placemark>");
sbKML.AppendLine(@" <Placemark>");
sbKML.AppendLine(@" <name>Outfall " + tvItemModelInfrastructureList.Where(c => c.TVItemID == infrastructureModel.InfrastructureTVItemID).Select(c => c.TVText).FirstOrDefault() + "</name>");
sbKML.AppendLine(@" <visibility>0</visibility>");
sbKML.AppendLine(@"<styleUrl>#msn_grn-pushpin</styleUrl>");
sbKML.AppendLine(@" <Point>");
sbKML.AppendLine(@" <coordinates>"+ mapInfoPointModelInfrastructureOutfallList[0].Lng + "," + mapInfoPointModelInfrastructureOutfallList[0].Lat + ",0</coordinates>");
sbKML.AppendLine(@" </Point>");
sbKML.AppendLine(@" </Placemark>");
}
// Doing Line Overflow
foreach (InfrastructureModel infrastructureModel in infrastructureModelList.Where(c => c.InfrastructureType == InfrastructureTypeEnum.LineOverflow).ToList())
{
sbKML.AppendLine(@" <Placemark>");
sbKML.AppendLine(@" <name>" + tvItemModelInfrastructureList.Where(c => c.TVItemID == infrastructureModel.InfrastructureTVItemID).Select(c => c.TVText).FirstOrDefault() + "</name>");
sbKML.AppendLine(@" <visibility>0</visibility>");
sbKML.AppendLine(@"<styleUrl>#msn_ylw-pushpin</styleUrl>");
sbKML.AppendLine(@" <description>");
sbKML.AppendLine(@"<![CDATA[");
sbKML.AppendLine(@"<pre>");
sbKML.AppendLine(@"Alarm System Type: " + baseEnumService.GetEnumText_AlarmSystemTypeEnum(infrastructureModel.AlarmSystemType) + "\r\n");
sbKML.AppendLine(@"Can overflow: " + infrastructureModel.CanOverflow.ToString() + "\r\n");
sbKML.AppendLine(@"Category: " + infrastructureModel.InfrastructureCategory + "\r\n");
sbKML.AppendLine(@"Collection System Type: " + baseEnumService.GetEnumText_CollectionSystemTypeEnum(infrastructureModel.CollectionSystemType) + "\r\n");
sbKML.AppendLine(@"Comments: " + infrastructureModel.Comment + "\r\n");
sbKML.AppendLine(@"Infrastructure Type: " + baseEnumService.GetEnumText_InfrastructureTypeEnum(infrastructureModel.InfrastructureType) + "\r\n");
sbKML.AppendLine(@"Percent Flow Of Total (%): " + infrastructureModel.PercFlowOfTotal + "\r\n");
List <MapInfoPointModel> mapInfoPointModelInfrastructureList = mapInfoService._MapInfoPointService.GetMapInfoPointModelListWithTVItemIDAndTVTypeAndMapInfoDrawTypeDB(infrastructureModel.InfrastructureTVItemID, TVTypeEnum.LineOverflow, MapInfoDrawTypeEnum.Point);
if (mapInfoPointModelInfrastructureList.Count > 0)
{
sbKML.AppendLine(@"Latitude Longitude: " + mapInfoPointModelInfrastructureList[0].Lat + " " + mapInfoPointModelInfrastructureList[0].Lng + "\r\n");
}
else
{
sbKML.AppendLine("Latitude Longitude: \r\n");
}
List <MapInfoPointModel> mapInfoPointModelInfrastructureOutfallList = mapInfoService._MapInfoPointService.GetMapInfoPointModelListWithTVItemIDAndTVTypeAndMapInfoDrawTypeDB(infrastructureModel.InfrastructureTVItemID, TVTypeEnum.Outfall, MapInfoDrawTypeEnum.Point);
if (mapInfoPointModelInfrastructureOutfallList.Count > 0)
{
sbKML.AppendLine(@"Outfall: Latitude Longitude: " + mapInfoPointModelInfrastructureOutfallList[0].Lat + " " + mapInfoPointModelInfrastructureOutfallList[0].Lng + "\r\n");
}
else
{
sbKML.AppendLine("Outfall: Latitude Longitude: \r\n");
}
sbKML.AppendLine("\r\n\r\n");
sbKML.AppendLine("Outfall Information\r\n\r\n");
sbKML.AppendLine(@"Average Depth (m): " + infrastructureModel.AverageDepth_m + "\r\n");
sbKML.AppendLine(@"Decay Rate (/day): " + infrastructureModel.DecayRate_per_day + "\r\n");
sbKML.AppendLine(@"Distance From Shore (m): " + infrastructureModel.DistanceFromShore_m + "\r\n");
sbKML.AppendLine(@"Far Field Velocity (m/s): " + infrastructureModel.FarFieldVelocity_m_s + "\r\n");
sbKML.AppendLine(@"Horizontal Angle (deg): " + infrastructureModel.HorizontalAngle_deg + "\r\n");
sbKML.AppendLine(@"Near Field Velocity (m/s): " + infrastructureModel.NearFieldVelocity_m_s + "\r\n");
sbKML.AppendLine(@"Number Of Ports: " + infrastructureModel.NumberOfPorts + "\r\n");
sbKML.AppendLine(@"Port Diameter (m): " + infrastructureModel.PortDiameter_m + "\r\n");
sbKML.AppendLine(@"Port Elevation (m): " + infrastructureModel.PortElevation_m + "\r\n");
sbKML.AppendLine(@"Port Spacing (m): " + infrastructureModel.PortSpacing_m + "\r\n");
sbKML.AppendLine(@"Receiving Water Concentration (FC /100 ml): " + infrastructureModel.ReceivingWater_MPN_per_100ml + "\r\n");
sbKML.AppendLine(@"Receiving Water Salinity (PSU): " + infrastructureModel.ReceivingWaterSalinity_PSU + "\r\n");
sbKML.AppendLine(@"Receiving Water Temperature (ºC): " + infrastructureModel.ReceivingWaterTemperature_C + "\r\n");
sbKML.AppendLine(@"Vertical Angle (deg): " + infrastructureModel.VerticalAngle_deg + "\r\n");
sbKML.AppendLine(@"</pre>");
sbKML.AppendLine(@"]]>");
sbKML.AppendLine(@" </description>");
sbKML.AppendLine(@" <Point>");
sbKML.AppendLine(@" <coordinates>"+ mapInfoPointModelInfrastructureList[0].Lng + "," + mapInfoPointModelInfrastructureList[0].Lat + ",0</coordinates>");
sbKML.AppendLine(@" </Point>");
sbKML.AppendLine(@" </Placemark>");
sbKML.AppendLine(@" <Placemark>");
sbKML.AppendLine(@" <name>Outfall " + tvItemModelInfrastructureList.Where(c => c.TVItemID == infrastructureModel.InfrastructureTVItemID).Select(c => c.TVText).FirstOrDefault() + "</name>");
sbKML.AppendLine(@" <visibility>0</visibility>");
sbKML.AppendLine(@"<styleUrl>#msn_grn-pushpin</styleUrl>");
sbKML.AppendLine(@" <Point>");
sbKML.AppendLine(@" <coordinates>"+ mapInfoPointModelInfrastructureOutfallList[0].Lng + "," + mapInfoPointModelInfrastructureOutfallList[0].Lat + ",0</coordinates>");
sbKML.AppendLine(@" </Point>");
sbKML.AppendLine(@" </Placemark>");
}
sbKML.AppendLine(@" </Folder>");
}
sbKML.AppendLine(@" </Folder>");
// Doing Short Pollution Source Site
sbKML.AppendLine(@" <Folder>");
sbKML.AppendLine(@" <name>Short Pollution Source Sites</name>");
sbKML.AppendLine(@" <visibility>0</visibility>");
List <PolSourceSiteModel> polSourceSiteModelList = polSourceSiteService.GetPolSourceSiteModelListWithSubsectorTVItemIDDB(tvItemModelSubsector.TVItemID);
foreach (PolSourceSiteModel polSourceSiteModel in polSourceSiteModelList.OrderBy(c => c.Site).ToList())
{
// Doing point
sbKML.AppendLine(@" <Placemark>");
sbKML.AppendLine(@" <name>" + polSourceSiteModel.Site.ToString() + "</name>");
sbKML.AppendLine(@" <visibility>0</visibility>");
sbKML.AppendLine(@"<styleUrl>#msn_ylw-pushpin</styleUrl>");
sbKML.AppendLine(@" <description>");
sbKML.AppendLine(@"<![CDATA[");
sbKML.AppendLine(@"<pre>");
PolSourceObservationModel polSourceObservationModel = polSourceSiteService._PolSourceObservationService.GetPolSourceObservationModelLatestWithPolSourceSiteTVItemIDDB(polSourceSiteModel.PolSourceSiteTVItemID);
if (polSourceObservationModel != null)
{
List <PolSourceObservationIssueModel> polSourceObservationIssueModelList = polSourceSiteService._PolSourceObservationService._PolSourceObservationIssueService.GetPolSourceObservationIssueModelListWithPolSourceObservationIDDB(polSourceObservationModel.PolSourceObservationID);
string SelectedObservation = "Selected: \r\n";
foreach (PolSourceObservationIssueModel polSourceObservationIssueModel in polSourceObservationIssueModelList)
{
foreach (PolSourceObsInfoEnum polSourceObsInfo in polSourceObservationIssueModel.PolSourceObsInfoList)
{
SelectedObservation += baseEnumService.GetEnumText_PolSourceObsInfoReportEnum(polSourceObsInfo);
}
SelectedObservation += "\r\n\r\n";
}
sbKML.AppendLine("Written: \r\n" + (string.IsNullOrWhiteSpace(polSourceObservationModel.Observation_ToBeDeleted) ? "" : polSourceObservationModel.Observation_ToBeDeleted.ToString()) + "\r\n\r\n" + SelectedObservation);
}
else
{
string SelectedObservation = "Selected: \r\n";
sbKML.AppendLine("Written: \r\n\r\n" + SelectedObservation);
}
sbKML.AppendLine(@"</pre>");
sbKML.AppendLine(@"]]>");
sbKML.AppendLine(@" </description>");
mapInfoPointModelList = mapInfoService._MapInfoPointService.GetMapInfoPointModelListWithTVItemIDAndTVTypeAndMapInfoDrawTypeDB(polSourceSiteModel.PolSourceSiteTVItemID, TVTypeEnum.PolSourceSite, MapInfoDrawTypeEnum.Point);
sbKML.AppendLine(@" <Point>");
sbKML.AppendLine(@" <coordinates>"+ mapInfoPointModelList[0].Lng + "," + mapInfoPointModelList[0].Lat + ",0</coordinates>");
sbKML.AppendLine(@" </Point>");
sbKML.AppendLine(@" </Placemark>");
}
sbKML.AppendLine(@" </Folder>");
// Doing Long Pollution Source Site
sbKML.AppendLine(@" <Folder>");
sbKML.AppendLine(@" <name>Long Pollution Source Sites</name>");
sbKML.AppendLine(@" <visibility>0</visibility>");
polSourceSiteModelList = polSourceSiteService.GetPolSourceSiteModelListWithSubsectorTVItemIDDB(tvItemModelSubsector.TVItemID);
foreach (PolSourceSiteModel polSourceSiteModel in polSourceSiteModelList.OrderBy(c => c.Site).ToList())
{
TVItemModel tvItemModelPolSourceSite = tvItemService.GetTVItemModelWithTVItemIDDB(polSourceSiteModel.PolSourceSiteTVItemID);
// Doing point
sbKML.AppendLine(@" <Placemark>");
sbKML.AppendLine(@" <name>" + tvItemModelPolSourceSite.TVText + "</name>");
sbKML.AppendLine(@" <visibility>0</visibility>");
sbKML.AppendLine(@"<styleUrl>#msn_ylw-pushpin</styleUrl>");
sbKML.AppendLine(@" <description>");
sbKML.AppendLine(@"<![CDATA[");
sbKML.AppendLine(@"<pre>");
PolSourceObservationModel polSourceObservationModel = polSourceSiteService._PolSourceObservationService.GetPolSourceObservationModelLatestWithPolSourceSiteTVItemIDDB(polSourceSiteModel.PolSourceSiteTVItemID);
if (polSourceObservationModel != null)
{
List <PolSourceObservationIssueModel> polSourceObservationIssueModelList = polSourceSiteService._PolSourceObservationService._PolSourceObservationIssueService.GetPolSourceObservationIssueModelListWithPolSourceObservationIDDB(polSourceObservationModel.PolSourceObservationID);
string SelectedObservation = "Selected: \r\n";
foreach (PolSourceObservationIssueModel polSourceObservationIssueModel in polSourceObservationIssueModelList)
{
foreach (PolSourceObsInfoEnum polSourceObsInfo in polSourceObservationIssueModel.PolSourceObsInfoList)
{
SelectedObservation += baseEnumService.GetEnumText_PolSourceObsInfoReportEnum(polSourceObsInfo);
}
SelectedObservation += "\r\n\r\n";
}
sbKML.AppendLine("Written: \r\n" + (string.IsNullOrWhiteSpace(polSourceObservationModel.Observation_ToBeDeleted) ? "" : polSourceObservationModel.Observation_ToBeDeleted.ToString()) + "\r\n\r\n" + SelectedObservation);
}
else
{
string SelectedObservation = "Selected: \r\n";
sbKML.AppendLine("Written: \r\n\r\n" + SelectedObservation);
}
sbKML.AppendLine(@"</pre>");
sbKML.AppendLine(@"]]>");
sbKML.AppendLine(@" </description>");
mapInfoPointModelList = mapInfoService._MapInfoPointService.GetMapInfoPointModelListWithTVItemIDAndTVTypeAndMapInfoDrawTypeDB(tvItemModelPolSourceSite.TVItemID, TVTypeEnum.PolSourceSite, MapInfoDrawTypeEnum.Point);
sbKML.AppendLine(@" <Point>");
sbKML.AppendLine(@" <coordinates>"+ mapInfoPointModelList[0].Lng + "," + mapInfoPointModelList[0].Lat + ",0</coordinates>");
sbKML.AppendLine(@" </Point>");
sbKML.AppendLine(@" </Placemark>");
}
sbKML.AppendLine(@" </Folder>");
// Doing MWQM Site
sbKML.AppendLine(@" <Folder>");
sbKML.AppendLine(@" <name>MWQM Sites</name>");
sbKML.AppendLine(@" <visibility>0</visibility>");
List <TVItemModel> tvItemModelMWQMSiteList = tvItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelSubsector.TVItemID, TVTypeEnum.MWQMSite);
foreach (TVItemModel tvItemModelMWQMSite in tvItemModelMWQMSiteList)
{
// Doing point
sbKML.AppendLine(@" <Placemark>");
sbKML.AppendLine(@" <name>" + tvItemModelMWQMSite.TVText + "</name>");
sbKML.AppendLine(@" <visibility>0</visibility>");
sbKML.AppendLine(@"<styleUrl>#msn_ylw-pushpin</styleUrl>");
mapInfoPointModelList = mapInfoService._MapInfoPointService.GetMapInfoPointModelListWithTVItemIDAndTVTypeAndMapInfoDrawTypeDB(tvItemModelMWQMSite.TVItemID, TVTypeEnum.MWQMSite, MapInfoDrawTypeEnum.Point);
sbKML.AppendLine(@" <Point>");
sbKML.AppendLine(@" <coordinates>"+ mapInfoPointModelList[0].Lng + "," + mapInfoPointModelList[0].Lat + ",0</coordinates>");
sbKML.AppendLine(@" </Point>");
sbKML.AppendLine(@" </Placemark>");
}
sbKML.AppendLine(@" </Folder>");
sbKML.AppendLine(@" </Folder>");
sbKML.AppendLine(@"</Document>");
sbKML.AppendLine(@"</kml>");
StreamWriter sw = fi.CreateText();
sw.Write(sbKML.ToString());
sw.Close();
}