Esempio n. 1
0
        private static wikidata GetDataFromWiki(string sitename)
        {
            wikidata data = new wikidata();
            string   WikiaddressSuffix = "https://en.wikipedia.org/w/api.php?format=json&action=query&prop=extracts&exlimit=max&explaintext&exintro&titles=";

            try
            {
                WebClient client   = new WebClient();
                string    address  = WikiaddressSuffix + sitename;
                var       response = client.DownloadString(address);

                var responseJson = JsonConvert.DeserializeObject <WikipediaClass.RootObject>(response);
                data.key   = Convert.ToInt32(responseJson.query.pages.First().Key);
                data.value = responseJson.query.pages[data.key.ToString()].extract.ToString();
                return(data);
            }
            catch (Exception e)
            {
                log.Error(e);
                return(data);
            }
        }
Esempio n. 2
0
        public string GenerateReportPdf(Marks marks, Coordinates coor, ReportExtraInfo reportextrainfo)
        {
            try
            {
                string serial = Guid.NewGuid().ToString();
                string FinalAddressAndReportName = string.Empty;
                string WordReport = docxReportPath + Path.DirectorySeparatorChar + serial + wordExnt;
                File.Copy(templateDoc, WordReport, true);
                Application wordApp = new Application {
                    Visible = true
                };
                Document aDoc = wordApp.Documents.Open(WordReport, ReadOnly: false, Visible: true);
                aDoc.Activate();
                FindAndReplaceMainDoc(wordApp, "[Date]", DateTime.Now.ToString("dd/MM/yyyy"));
                FindAndReplaceMainDoc(wordApp, "[Serial_Number]", serial);
                FindAndReplaceMainDoc(wordApp, "[Project Name]", reportextrainfo.ProjName);
                FindAndReplaceMainDocHeaderAndFooter(aDoc, "[Project Name]", reportextrainfo.ProjName);
                FindAndReplaceMainDoc(wordApp, "[Company Name]", reportextrainfo.CustomerName);
                FindAndReplaceMainDoc(wordApp, "[Title]", "Indexes Value of - Coordinates " + Math.Round(coor.lon, 4) + "/" +
                                      Math.Round(coor.lat, 4));
                FindAndReplaceMainDoc(wordApp, "[Coordinates]", "Coordinates " + Math.Round(coor.lon, 4) + "/" +
                                      Math.Round(coor.lat, 4));

                // let's get the full address of the location according to the coordinates using OSM reverse geocoding service
                GeoCodingServices service = new GeoCodingServices();

                AddressResult address = service.ReverseGeoCoding(coor.lon, coor.lat);

                string country     = string.IsNullOrEmpty(address.Country) ? "" : Convert.ToString(address.Country);
                string city        = string.IsNullOrEmpty(address.City) ? "" : ", " + Convert.ToString(address.City);
                string road        = string.IsNullOrEmpty(address.Road) ? "" : ", " + Convert.ToString(address.Road);
                string housenumber = string.IsNullOrEmpty(address.HouseNumber) ? "" : ", " + Convert.ToString(address.HouseNumber);
                string postalcode  = address.PostCode == "no" ? "" : ", " + Convert.ToString(address.PostCode);
                string Fulladdress = country + city + road + housenumber + postalcode;
                if (!string.IsNullOrEmpty(Fulladdress))
                {
                    FinalAddressAndReportName += StringSeparator + "Address:" + Fulladdress;
                    FindAndReplaceMainDoc(wordApp, "[Address]", Fulladdress);
                    FindAndReplaceMainDoc(wordApp, "[Site Name]", Fulladdress);

                    // if the city name exist, then let's check if the city name have value in wikipedia or not
                    if (!string.IsNullOrEmpty(address.City))
                    {
                        wikidata data = GetDataFromWiki(address.City);
                        if (data.key != -1)
                        {
                            object oBookMark = "SiteInfo";
                            aDoc.Bookmarks.get_Item(ref oBookMark).Range.Text = data.value;
                        }
                        else
                        {
                            FindAndReplaceMainDoc(wordApp, "[Site Brief Info]", " ");
                            FindAndReplaceMainDoc(wordApp, "Source: https://en.wikipedia.org/", " ");
                        }
                    }
                }
                else
                {
                    FinalAddressAndReportName += StringSeparator + "Address:" + " ";
                    FindAndReplaceMainDoc(wordApp, "[Address]", " ");
                    FindAndReplaceMainDoc(wordApp, "[Site Name]", " ");
                    FindAndReplaceMainDoc(wordApp, "[Site Brief Info]", " ");
                    FindAndReplaceMainDoc(wordApp, "Source: https://en.wikipedia.org/", " ");
                }

                // let's get the site


                FindAndReplaceMainDoc(wordApp, "{EG}", Math.Round(marks.RadiationEG, 2).ToString());
                FindAnndReplaceShapes(aDoc, "{EG}", Math.Round(marks.RadiationEG, 2).ToString());
                FindAndReplaceMainDoc(wordApp, "[EG Comments]", CheckinterferenceValue(Types.Radiation, Math.Round(marks.RadiationEG, 2)));
                FindAndReplaceMainDoc(wordApp, "{SC}", Math.Round(marks.SoilPollution, 2).ToString());
                FindAnndReplaceShapes(aDoc, "{SC}", Math.Round(marks.SoilPollution, 2).ToString());
                FindAndReplaceMainDoc(wordApp, "[SC Comments]", CheckinterferenceValue(Types.Soil, Math.Round(marks.SoilPollution, 2)));
                FindAndReplaceMainDoc(wordApp, "{EC}", Math.Round(marks.Ecology, 2).ToString());
                FindAnndReplaceShapes(aDoc, "{EC}", Math.Round(marks.Ecology, 2).ToString());
                FindAndReplaceMainDoc(wordApp, "[EC Comments]", CheckinterferenceValue(Types.Ecology, Math.Round(marks.Ecology, 2)));
                FindAndReplaceMainDoc(wordApp, "{NO}", Math.Round(marks.NoiseInterference, 2).ToString());
                FindAnndReplaceShapes(aDoc, "{NO}", Math.Round(marks.NoiseInterference, 2).ToString());
                FindAndReplaceMainDoc(wordApp, "[NO Comments]", CheckinterferenceValue(Types.Noise, Math.Round(marks.NoiseInterference, 2)));
                FindAndReplaceMainDoc(wordApp, "{AQ}", Math.Round(marks.AirQuality, 2).ToString());
                FindAnndReplaceShapes(aDoc, "{AQ}", Math.Round(marks.AirQuality, 2).ToString());
                FindAndReplaceMainDoc(wordApp, "[AO Comments]", CheckinterferenceValue(Types.AirQuality, Math.Round(marks.AirQuality, 2)));

                // will be change in the future to Solid Waste Management Mark and comments
                FindAndReplaceMainDoc(wordApp, "{SW}", Math.Round(marks.SoilPollution, 2).ToString());
                FindAnndReplaceShapes(aDoc, "{SW}", Math.Round(marks.SoilPollution, 2).ToString());
                FindAndReplaceMainDoc(wordApp, "[SW Comments]", " ");

                // overall index value
                FindAndReplaceMainDoc(wordApp, "{M}", Math.Round(marks.FinalMark, 2).ToString());
                FindAnndReplaceShapes(aDoc, "{M}", Math.Round(marks.FinalMark, 2).ToString());
                AddMap(aDoc, coor);

                //string WordReport = docxReportPath + Path.DirectorySeparatorChar + serial + wordExnt;
                //wordApp.Documents[1].SaveAs2(WordReport, WdSaveFormat.wdFormatDocumentDefault);
                wordApp.Documents[1].Save();
                string pdfReport = pdfReportPath + Path.DirectorySeparatorChar + serial + PdfExnt;
                wordApp.Documents[1].SaveAs2(pdfReport, WdSaveFormat.wdFormatPDF);
                wordApp.Documents[1].Close();
                wordApp.Quit();
                int res  = System.Runtime.InteropServices.Marshal.ReleaseComObject(aDoc);
                int res1 = System.Runtime.InteropServices.Marshal.ReleaseComObject(wordApp);
                GC.Collect();

                // let's copy the file to authenticate folder for user downloads.
                FinalAddressAndReportName += StringSeparator + "Report:" + serial + PdfExnt;
                string downloadFile = pdfReportDownlaodPath + Path.DirectorySeparatorChar + serial + PdfExnt;
                File.Copy(pdfReport, downloadFile, true);

                return(FinalAddressAndReportName);
            }
            catch (Exception e)
            {
                log.Error(e);
                return(String.Empty);
            }
        }