public static void Main() { // ClimateDatabase db = new ClimateDatabase(); // int row = db.AddMetStation("ID22", "Station1", "ZackLand", "United States", 12.1, 13.4, 14.5); // Console.WriteLine(row); // db.AddWeatherData(10,1,24.4,18.2,2,3,4,5,6,7,8); ClimateDatabase db = new ClimateDatabase(); try { db.AddWeatherData(1,2,3,4,5,6,7,8,9,10,11); } catch (Exception e) { Console.WriteLine(e.Message); } }
public static void Main() { // ClimateDatabase db = new ClimateDatabase(); // int row = db.AddMetStation("ID22", "Station1", "ZackLand", "United States", 12.1, 13.4, 14.5); // Console.WriteLine(row); // db.AddWeatherData(10,1,24.4,18.2,2,3,4,5,6,7,8); ClimateDatabase db = new ClimateDatabase(); try { db.AddWeatherData(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11); } catch (Exception e) { Console.WriteLine(e.Message); } }
public void ParseXML() { ClimateDatabase db = new ClimateDatabase(); int rowid = 0; foreach (XElement stationElement in XElement.Load("newaab").Elements("Station")) { Console.WriteLine("Station ID: " + stationElement.Element("StationID").Value); Console.WriteLine("Station Name: " + stationElement.Element("StationName").Value); Console.WriteLine("Country ID: " + stationElement.Element("CountryID").Value); Console.WriteLine("CountryName: " + stationElement.Element("CountryName").Value); Console.WriteLine("Latitude: " + stationElement.Element("Latitude").Value); Console.WriteLine("Longitude: " + stationElement.Element("Longitude").Value); Console.WriteLine("Altitude: " + stationElement.Element("Altitude").Value); Console.WriteLine("......................."); string stationid = (string)stationElement.Element("StationID").Value; string stationname = (string)stationElement.Element("StationName").Value; string countryid = (string)stationElement.Element("CountryID").Value; string countryname = (string)stationElement.Element("CountryName").Value; double latitude = double.Parse(stationElement.Element("Latitude").Value); double longitude = double.Parse(stationElement.Element("Longitude").Value); double altitude = double.Parse(stationElement.Element("Altitude").Value); //ClimateDatabase db = new ClimateDatabase(); rowid = db.AddMetStation(stationid, stationname, countryid, countryname, latitude, longitude, altitude); // Loop thourough months and get weather data foreach (XElement months in stationElement.Elements("Months")) { foreach (XElement month in months.Elements("Month")) { Console.WriteLine("Month: " + month.Attribute("id").Value); Console.WriteLine(" TempMax: " + month.Element("TempMax").Value); Console.WriteLine(" TempMin: " + month.Element("TempMin").Value); Console.WriteLine(" Humidity: " + month.Element("Humidity").Value); Console.WriteLine(" Wind: " + month.Element("Wind").Value); Console.WriteLine(" Sunshine: " + month.Element("Sunshine").Value); Console.WriteLine(" Radiation: " + month.Element("Radiation").Value); Console.WriteLine(" Eto: " + month.Element("ETo").Value); Console.WriteLine(" Rain: " + month.Element("Rain").Value); Console.WriteLine(" EffRain: " + month.Element("EffRain").Value); int monthid = int.Parse(month.Attribute("id").Value); double tempmax = double.Parse(month.Element("TempMax").Value); double tempmin = double.Parse(month.Element("TempMin").Value); double humidity = double.Parse(month.Element("Humidity").Value); double wind = double.Parse(month.Element("Wind").Value); double sunshine = double.Parse(month.Element("Sunshine").Value); double radiation = double.Parse(month.Element("Radiation").Value); double eto = double.Parse(month.Element("ETo").Value); double rain = double.Parse(month.Element("Rain").Value); double effrain = double.Parse(month.Element("EffRain").Value); db.AddWeatherData(rowid, monthid, tempmax, tempmin, humidity, wind, sunshine, radiation, eto, rain, effrain); } Console.WriteLine("================================="); } } }
public void ParseXML() { ClimateDatabase db = new ClimateDatabase(); int rowid = 0; foreach (XElement stationElement in XElement.Load("newaab").Elements("Station")) { Console.WriteLine("Station ID: " + stationElement.Element("StationID").Value); Console.WriteLine("Station Name: " + stationElement.Element("StationName").Value); Console.WriteLine("Country ID: " + stationElement.Element("CountryID").Value); Console.WriteLine("CountryName: " + stationElement.Element("CountryName").Value); Console.WriteLine("Latitude: " + stationElement.Element("Latitude").Value); Console.WriteLine("Longitude: " + stationElement.Element("Longitude").Value); Console.WriteLine("Altitude: " + stationElement.Element("Altitude").Value); Console.WriteLine("......................."); string stationid = (string)stationElement.Element("StationID").Value; string stationname = (string)stationElement.Element("StationName").Value; string countryid = (string)stationElement.Element("CountryID").Value; string countryname = (string)stationElement.Element("CountryName").Value; double latitude = double.Parse(stationElement.Element("Latitude").Value); double longitude = double.Parse(stationElement.Element("Longitude").Value); double altitude = double.Parse(stationElement.Element("Altitude").Value); //ClimateDatabase db = new ClimateDatabase(); rowid = db.AddMetStation(stationid, stationname, countryid, countryname,latitude,longitude,altitude); // Loop thourough months and get weather data foreach (XElement months in stationElement.Elements("Months")) { foreach (XElement month in months.Elements("Month")) { Console.WriteLine("Month: " + month.Attribute("id").Value); Console.WriteLine(" TempMax: " + month.Element("TempMax").Value); Console.WriteLine(" TempMin: " + month.Element("TempMin").Value); Console.WriteLine(" Humidity: " + month.Element("Humidity").Value); Console.WriteLine(" Wind: " + month.Element("Wind").Value); Console.WriteLine(" Sunshine: " + month.Element("Sunshine").Value); Console.WriteLine(" Radiation: " + month.Element("Radiation").Value); Console.WriteLine(" Eto: " + month.Element("ETo").Value); Console.WriteLine(" Rain: " + month.Element("Rain").Value); Console.WriteLine(" EffRain: " + month.Element("EffRain").Value); int monthid = int.Parse(month.Attribute("id").Value); double tempmax = double.Parse(month.Element("TempMax").Value); double tempmin = double.Parse(month.Element("TempMin").Value); double humidity = double.Parse(month.Element("Humidity").Value); double wind = double.Parse(month.Element("Wind").Value); double sunshine = double.Parse(month.Element("Sunshine").Value); double radiation = double.Parse(month.Element("Radiation").Value); double eto = double.Parse(month.Element("ETo").Value); double rain = double.Parse(month.Element("Rain").Value); double effrain = double.Parse(month.Element("EffRain").Value); db.AddWeatherData(rowid,monthid,tempmax,tempmin,humidity,wind,sunshine,radiation,eto,rain,effrain); } Console.WriteLine("================================="); } } }