private void GenerateWorksheetAContent(WorksheetPart worksheetPart, int SheetOrdinal)
{
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?>()
{
30D
};
foreach (double?width in columnWidthList)
{
Column colum = XlsxBase.AddColumnProp(columns, width);
}
SheetData sheetData = new SheetData();
BaseEnumService baseEnumService = new BaseEnumService(_TaskRunnerBaseService._BWObj.appTaskModel.Language);
TVItemService tvItemService = new TVItemService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
TVItemStatService tvItemStatService = new TVItemStatService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
TVItemModel tvItemModelRoot = tvItemService.GetRootTVItemModelDB();
List <TVItemModel> tvItemModelCountryList = tvItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelRoot.TVItemID, TVTypeEnum.Country);
foreach (TVItemModel tvItemModel in tvItemModelCountryList)
{
//tvItemStatService.SetTVItemStatForTVItemIDAndParentsTVItemID(tvItemModel.TVItemID);
}
MergeCells mergeCells = new MergeCells();
foreach (TVItemModel tvItemModelCountry in tvItemModelCountryList)
{
XlsxBase.CurrentRowHeight = 24D;
XlsxBase.CurrentFontSize = 18;
XlsxBase.CurrentBorderStyleValue = BorderStyleValues.Thick;
XlsxBase.CurrentBottomBorder = true;
XlsxBase.CurrentBorderColor = System.Drawing.Color.Green;
XlsxBase.CurrentHorizontalAlignmentValue = HorizontalAlignmentValues.Center;
row = XlsxBase.AddRow();
string URL = _TaskRunnerBaseService.GetUrlFromTVItem(tvItemModelCountry);
XlsxBase.CurrentFontColor = System.Drawing.Color.Blue;
cell = XlsxBase.AddCellHyperlink(hyperlinks, row, tvItemModelCountry.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() + ":B" + XlsxBase.CurrentRow.ToString()
};
mergeCells.Append(mergeCell);
XlsxBase.CurrentRowHeight = 16D;
XlsxBase.CurrentFontSize = 12;
XlsxBase.CurrentHorizontalAlignmentValue = HorizontalAlignmentValues.Center;
List <TVItemStatModel> tvItemStatModelList = tvItemStatService.GetTVItemStatModelListWithTVItemIDDB(tvItemModelCountry.TVItemID);
int count = 0;
foreach (TVItemStatModel tvItemStatModel in tvItemStatModelList)
{
count += 1;
row = XlsxBase.AddRow();
if (count % 5 == 0)
{
XlsxBase.CurrentBorderStyleValue = BorderStyleValues.Thin;
XlsxBase.CurrentBottomBorder = true;
}
else
{
XlsxBase.CurrentBorderStyleValue = null;
XlsxBase.CurrentBottomBorder = false;
}
XlsxBase.CurrentHorizontalAlignmentValue = HorizontalAlignmentValues.Right;
cell = XlsxBase.AddCellString(row, baseEnumService.GetEnumText_TVTypeEnum(tvItemStatModel.TVType));
XlsxBase.CurrentHorizontalAlignmentValue = HorizontalAlignmentValues.Center;
cell = XlsxBase.AddCellNumber(row, tvItemStatModel.ChildCount.ToString());
sheetData.Append(row);
}
XlsxBase.CurrentBorderStyleValue = null;
XlsxBase.CurrentBottomBorder = false;
for (int i = 0; i < 2; i++)
{
row = XlsxBase.AddRow();
cell = XlsxBase.AddCellString(row, null);
sheetData.Append(row);
}
}
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 BaseEnumController(BaseEnumService <TEnum> service)
{
EnumService = service;
}
public ParsingSourceController(BaseEnumService <ParsingSource> service) : base(service)
{
}
public EntityStateController(BaseEnumService <EntityState> service) : base(service)
{
}
private void GenerateProvinceDocument(Document document)
{
Body body = new Body();
Paragraph paragraph = new Paragraph();
Run run = new Run();
Table table = new Table();
TableRow tableRow = new TableRow();
TableCell tableCell = new TableCell();
string URL = "";
BaseEnumService baseEnumService = new BaseEnumService(_TaskRunnerBaseService._BWObj.appTaskModel.Language);
TVItemService tvItemService = new TVItemService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
TVItemStatService tvItemStatService = new TVItemStatService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
TVItemModel tvItemModelProvince = tvItemService.GetTVItemModelWithTVItemIDDB(_TaskRunnerBaseService._BWObj.appTaskModel.TVItemID);
if (!string.IsNullOrWhiteSpace(tvItemModelProvince.Error))
{
paragraph = DocxBase.AddParagraph(body);
DocxBase.AddRunWithCurrentParagraphStyle(paragraph, tvItemModelProvince.Error);
}
//tvItemStatService.SetTVItemStatForTVItemIDAndParentsTVItemID(tvItemModelProvince.TVItemID);
DocxBase.CurrentParagraphStyle = ParagraphStyleEnum.Heading1;
DocxBase.CurrentJustificationValue = JustificationValues.Center;
paragraph = DocxBase.AddParagraph(body);
URL = _TaskRunnerBaseService.GetUrlFromTVItem(tvItemModelProvince);
run = DocxBase.AddRunHyperlink(paragraph, URL, tvItemModelProvince.TVText);
List <TVItemModel> tvItemModelAreaList = tvItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelProvince.TVItemID, TVTypeEnum.Area);
foreach (TVItemModel tvItemModelArea in tvItemModelAreaList)
{
DocxBase.CurrentParagraphStyle = ParagraphStyleEnum.Heading2;
paragraph = DocxBase.AddParagraph(body);
URL = _TaskRunnerBaseService.GetUrlFromTVItem(tvItemModelArea);
run = DocxBase.AddRunHyperlink(paragraph, URL, tvItemModelArea.TVText);
DocxBase.CurrentTableStyle = TableStyleEnum.ListTable7Colorful_Accent5;
table = DocxBase.AddTableStyle(body);
tableRow = DocxBase.AddTableRow(table);
// Doing Items
tableCell = DocxBase.AddTableCell(tableRow);
paragraph = DocxBase.AddTableCellParagraph(tableCell);
run = DocxBase.AddRunWithCurrentParagraphStyle(paragraph, "Items");
// Doing Count
tableCell = DocxBase.AddTableCell(tableRow);
paragraph = DocxBase.AddTableCellParagraph(tableCell);
run = DocxBase.AddRunWithCurrentParagraphStyle(paragraph, "Count");
List <TVItemStatModel> tvItemStatModelList = tvItemStatService.GetTVItemStatModelListWithTVItemIDDB(tvItemModelArea.TVItemID);
int count = 0;
foreach (TVItemStatModel tvItemStatModel in tvItemStatModelList)
{
count += 1;
tableRow = DocxBase.AddTableRow(table);
// Doing Item
tableCell = DocxBase.AddTableCell(tableRow);
paragraph = DocxBase.AddTableCellParagraph(tableCell);
run = DocxBase.AddRunWithCurrentParagraphStyle(paragraph, baseEnumService.GetEnumText_TVTypeEnum(tvItemStatModel.TVType));
// Doing number
tableCell = DocxBase.AddTableCell(tableRow);
paragraph = DocxBase.AddTableCellParagraph(tableCell);
run = DocxBase.AddRunWithCurrentParagraphStyle(paragraph, tvItemStatModel.ChildCount.ToString());
}
}
DocxBase.CurrentParagraphStyle = ParagraphStyleEnum.Normal;
DocxBase.CurrentJustificationValue = JustificationValues.Left;
paragraph = DocxBase.AddParagraph(body);
paragraph = DocxBase.AddParagraph(body);
DocxBase.AddRunWithCurrentParagraphStyle(paragraph, "Etc ... ");
DocxBase.AddSectionProp(body);
document.Append(body);
}
public EmailDistributionListContactLanguageService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_LogService = new LogService(LanguageRequest, User);
_BaseEnumService = new BaseEnumService(LanguageRequest);
}
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 CommentTypeController(BaseEnumService <CommentType> service) : base(service)
{
}
public bool CreateSanitaryBC()
{
lblStatus.Text = "Starting ... CreateSanitaryBC";
Application.DoEvents();
if (Cancel)
{
return(false);
}
TVItemService tvItemServiceR = new TVItemService(LanguageEnum.en, user);
BaseEnumService _BaseEnumSerice = new BaseEnumService(LanguageEnum.en);
TVItemModel tvItemModelRoot = tvItemServiceR.GetRootTVItemModelDB();
if (!CheckModelOK <TVItemModel>(tvItemModelRoot))
{
return(false);
}
TVItemModel tvItemModelCanada = tvItemServiceR.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelRoot.TVItemID, "Canada", TVTypeEnum.Country);
if (!CheckModelOK <TVItemModel>(tvItemModelCanada))
{
return(false);
}
TVItemModel tvItemModelBC = tvItemServiceR.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelCanada.TVItemID, "British Columbia", TVTypeEnum.Province);
if (!CheckModelOK <TVItemModel>(tvItemModelBC))
{
return(false);
}
List <TVItemModel> TVItemModelSubsectorList = tvItemServiceR.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelBC.TVItemID, TVTypeEnum.Subsector);
if (TVItemModelSubsectorList.Count == 0)
{
richTextBoxStatus.AppendText("Error: could not find TVItem Subsector for " + tvItemModelBC.TVText + "\r\n");
return(false);
}
List <TempData.BCPolSource> bcPolSourceList = new List <TempData.BCPolSource>();
using (TempData.TempDataToolDBEntities dbDT = new TempData.TempDataToolDBEntities())
{
bcPolSourceList = (from c in dbDT.BCPolSources
orderby c.BCPolSourceID
select c).ToList <TempData.BCPolSource>();
}
int StartBCCreateSanitarysBC = int.Parse(textBoxBCCreateSanitaryBC.Text);
int TotalCount = bcPolSourceList.Count();
int Count = 0;
foreach (TempData.BCPolSource bcps in bcPolSourceList)
{
if (Cancel)
{
return(false);
}
Count += 1;
lblStatus.Text = Count + " of " + TotalCount + " ... LoadSanitary BC";
Application.DoEvents();
textBoxBCCreateSanitaryBC.Text = Count.ToString();
if (StartBCCreateSanitarysBC > Count)
{
continue;
}
TVItemService tvItemService = new TVItemService(LanguageEnum.en, user);
PolSourceObservationService polSourceObservationService = new PolSourceObservationService(LanguageEnum.en, user);
PolSourceObservationIssueService polSourceObservationIssueService = new PolSourceObservationIssueService(LanguageEnum.en, user);
PolSourceSiteService polSourceSiteService = new PolSourceSiteService(LanguageEnum.en, user);
MapInfoService mapInfoService = new MapInfoService(LanguageEnum.en, user);
PolSourceSiteModel polSourceSiteModelNew = new PolSourceSiteModel();
polSourceSiteModelNew.Oldsiteid = int.Parse(bcps.Key_.Substring(2));
string LCODE = tvItemService.CleanText(bcps.LCode);
string ICODE = tvItemService.CleanText(bcps.ICode);
if (LCODE.Trim() == "")
{
LCODE = "--";
}
if (ICODE.Trim() == "")
{
ICODE = "--";
}
List <PolSourceObsInfoEnum> polSourceObsInfoList = GetPolSourceType(LCODE.Trim(), ICODE.Trim(), "BC");
string ObservationInfo = ((int)polSourceObsInfoList[0]).ToString() + "," + ((int)polSourceObsInfoList[1]).ToString() + ",";
List <MapInfoModel> mapInfoModelListSubsector = new List <MapInfoModel>();
if (bcps.Y_calc == 48.984828948974609f && bcps.X_calc == -123.02297973632812f)
{
mapInfoModelListSubsector = mapInfoService.GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB(49.01f, (float)bcps.X_calc, TVTypeEnum.Subsector);
}
else if (bcps.Y_calc == 49.3099250793457f && bcps.X_calc == -121.77302551269531f)
{
mapInfoModelListSubsector = mapInfoService.GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB((float)bcps.Y_calc, (float)-122.2, TVTypeEnum.Subsector);
}
else if (bcps.Y_calc == 48.3582878112793f && bcps.X_calc == -123.73906707763672f)
{
mapInfoModelListSubsector = mapInfoService.GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB((float)bcps.Y_calc, (float)-123.72, TVTypeEnum.Subsector);
}
else if (bcps.Y_calc == 51.266487121582031f && bcps.X_calc == -128.20162963867187f)
{
mapInfoModelListSubsector = mapInfoService.GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB((float)bcps.Y_calc, (float)-128, TVTypeEnum.Subsector);
}
else if (bcps.Y_calc == 55.91217041015625f && bcps.X_calc == -130.01992797851562f)
{
mapInfoModelListSubsector = mapInfoService.GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB((float)bcps.Y_calc, (float)-129, TVTypeEnum.Subsector);
}
else if (bcps.Y_calc == 55.912052154541016f && bcps.X_calc == -130.01669311523437f)
{
mapInfoModelListSubsector = mapInfoService.GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB((float)bcps.Y_calc, (float)-129, TVTypeEnum.Subsector);
}
else
{
mapInfoModelListSubsector = mapInfoService.GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB((float)bcps.Y_calc, (float)bcps.X_calc, TVTypeEnum.Subsector);
}
if (mapInfoModelListSubsector.Count == 0)
{
richTextBoxStatus.AppendText("GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB did not find anything\r\n");
return(false);
}
// doing EN TVText
string PolSourceSiteTVTextEN = _BaseEnumSerice.GetEnumText_PolSourceObsInfoEnum(polSourceObsInfoList[0]);
if (polSourceObsInfoList.Count > 1)
{
if (polSourceObsInfoList[1] != PolSourceObsInfoEnum.Error)
{
PolSourceSiteTVTextEN += " - " + _BaseEnumSerice.GetEnumText_PolSourceObsInfoEnum(polSourceObsInfoList[1]);
}
}
int Site = (int)bcps.OBJECTID;
PolSourceSiteTVTextEN = tvItemService.CleanText(PolSourceSiteTVTextEN + " - " + " ".Substring(0, 6 - Site.ToString().Length) + Site.ToString());
Thread.CurrentThread.CurrentCulture = new CultureInfo("fr-CA");
Thread.CurrentThread.CurrentUICulture = new CultureInfo("fr-CA");
// Doing FR TVText
PolSourceObservationService polSourceObservationService2 = new PolSourceObservationService(LanguageEnum.fr, user);
string PolSourceSiteTVTextFR = _BaseEnumSerice.GetEnumText_PolSourceObsInfoEnum(polSourceObsInfoList[0]);
if (polSourceObsInfoList.Count > 1)
{
if (polSourceObsInfoList[1] != PolSourceObsInfoEnum.Error)
{
PolSourceSiteTVTextFR += " - " + _BaseEnumSerice.GetEnumText_PolSourceObsInfoEnum(polSourceObsInfoList[1]);
}
}
PolSourceSiteTVTextFR = tvItemService.CleanText(PolSourceSiteTVTextFR + " - " + " ".Substring(0, 6 - Site.ToString().Length) + Site.ToString());
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-CA");
Thread.CurrentThread.CurrentUICulture = new CultureInfo("en-CA");
TVItemModel tvItemModelPolSourceSite = tvItemService.PostCreateTVItem(mapInfoModelListSubsector[0].TVItemID, PolSourceSiteTVTextEN, PolSourceSiteTVTextFR, TVTypeEnum.PolSourceSite);
if (!CheckModelOK <TVItemModel>(tvItemModelPolSourceSite))
{
return(false);
}
List <Coord> coordList = new List <Coord>()
{
new Coord()
{
Lat = (float)bcps.Y_calc,
Lng = (float)bcps.X_calc,
}
};
MapInfoModel mapInfoModelRet = mapInfoService.CreateMapInfoObjectDB(coordList, MapInfoDrawTypeEnum.Point, TVTypeEnum.PolSourceSite, tvItemModelPolSourceSite.TVItemID);
if (!CheckModelOK <MapInfoModel>(mapInfoModelRet))
{
return(false);
}
polSourceSiteModelNew.PolSourceSiteTVItemID = tvItemModelPolSourceSite.TVItemID;
polSourceSiteModelNew.PolSourceSiteTVText = PolSourceSiteTVTextEN;
polSourceSiteModelNew.Site = Site;
polSourceSiteModelNew.Oldsiteid = Site;
PolSourceSiteModel polSourceSiteModelRet = polSourceSiteService.GetPolSourceSiteModelWithPolSourceSiteTVItemIDDB(tvItemModelPolSourceSite.TVItemID);
if (!string.IsNullOrWhiteSpace(polSourceSiteModelRet.Error))
{
polSourceSiteModelRet = polSourceSiteService.PostAddPolSourceSiteDB(polSourceSiteModelNew);
if (!CheckModelOK <PolSourceSiteModel>(polSourceSiteModelRet))
{
return(false);
}
}
PolSourceObservationModel polSourceObservationModelNew = new PolSourceObservationModel();
if (bcps.yyyymmdd == null)
{
polSourceObservationModelNew.ObservationDate_Local = new DateTime(2050, 1, 1);
}
else
{
polSourceObservationModelNew.ObservationDate_Local = (DateTime)bcps.yyyymmdd;
}
string Inspector = "unknown";
if (!string.IsNullOrWhiteSpace(bcps.Verified))
{
Inspector = bcps.Verified + " - (BC)";
}
string TVTextInspectorEN = "Inspector " + Inspector;
string TVTextInspectorFR = "Inspecteur " + Inspector;
TVItemModel tvItemModelContactRet = tvItemService.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelRoot.TVItemID, TVTextInspectorEN, TVTypeEnum.Contact);
if (!string.IsNullOrWhiteSpace(tvItemModelContactRet.Error))
{
tvItemModelContactRet = tvItemService.PostCreateTVItem(tvItemModelRoot.TVItemID, TVTextInspectorEN, TVTextInspectorFR, TVTypeEnum.Contact);
if (!CheckModelOK <TVItemModel>(tvItemModelContactRet))
{
return(false);
}
}
polSourceObservationModelNew.ContactTVItemID = tvItemModelContactRet.TVItemID;
string Observation = "(empty)";
if (!string.IsNullOrWhiteSpace(bcps.Remarks))
{
Observation = LCODE.Trim().ToUpper() + " - " + ICODE.Trim().ToUpper() + " - " + bcps.Remarks;
}
polSourceObservationModelNew.Observation_ToBeDeleted = Observation;
polSourceObservationModelNew.PolSourceSiteID = polSourceSiteModelRet.PolSourceSiteID;
PolSourceObservationModel polSourceObservationModelRet = polSourceObservationService.GetPolSourceObservationModelExistDB(polSourceObservationModelNew);
if (!string.IsNullOrWhiteSpace(polSourceObservationModelRet.Error))
{
polSourceObservationModelRet = polSourceObservationService.PostAddPolSourceObservationDB(polSourceObservationModelNew);
if (!CheckModelOK <PolSourceObservationModel>(polSourceObservationModelRet))
{
return(false);
}
}
PolSourceObservationIssueModel polSourceObservationIssueModelNew = new PolSourceObservationIssueModel()
{
PolSourceObservationID = polSourceObservationModelNew.PolSourceObservationID,
ObservationInfo = ObservationInfo,
PolSourceObsInfoList = polSourceObsInfoList,
Ordinal = 0,
};
PolSourceObservationIssueModel polSourceObservationIssueModelRet = polSourceObservationIssueService.GetPolSourceObservationIssueModelExistDB(polSourceObservationIssueModelNew);
if (!string.IsNullOrWhiteSpace(polSourceObservationIssueModelRet.Error))
{
polSourceObservationIssueModelRet = polSourceObservationIssueService.PostAddPolSourceObservationIssueDB(polSourceObservationIssueModelNew);
if (!CheckModelOK <PolSourceObservationModel>(polSourceObservationModelRet))
{
return(false);
}
}
}
return(true);
}
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();
}
public LanguageLevelController(BaseEnumService <LanguageLevel> service) : base(service)
{
}
public BoxModelLanguageService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_LogService = new LogService(LanguageRequest, User);
_BaseEnumService = new BaseEnumService(LanguageRequest);
}