protected void Page_Load(object sender, EventArgs e) { try { //if (this.Request.HttpMethod != "POST") //{ // this.Response.Write("Request method must be POST"); // return; //} // handle as image //string device = this.Request.Form["deviceid"].ToString(); using (SmartCityEntities ctx = new SmartCityEntities()) { SampledImage sImage = new SampledImage(); sImage.device_id = Convert.ToInt32(this.Request.QueryString["device"]); sImage.image_timestamp = DateTime.Now; System.IO.BufferedStream bufRead = new System.IO.BufferedStream(this.Request.Files[0].InputStream); System.IO.BinaryReader binaryRead = new System.IO.BinaryReader(bufRead); sImage.imagesample = binaryRead.ReadBytes(this.Request.Files[0].ContentLength); ctx.SampledImage.Add(sImage); ctx.SaveChanges(); } return; } catch (Exception ex) { this.Response.Write(ex.ToString()); return; } }
protected void Page_Load(object sender, EventArgs e) { try { if (this.Request.HttpMethod != "GET") { this.Response.Write("Request method must be GET"); return; } System.Text.StringBuilder bld = new System.Text.StringBuilder(); bld.AppendLine("<?xml version=\"1.0\" encoding=\"utf-8\" ?> "); bld.Append("<Devices>"); NumberFormatInfo numFormat = new NumberFormatInfo(); numFormat.NumberDecimalSeparator = "."; using (SmartCityEntities ctx = new SmartCityEntities()) { List <int?> tt = ctx.Sample.Select(d => d.device_id).Distinct().ToList(); foreach (int?item in tt) { if (item.HasValue) { bld.Append(String.Format("<Device>{0}</Device>", item.Value)); } } } bld.AppendLine("</Devices>"); this.Response.Write(bld.ToString()); } catch (Exception ex) { this.Response.Write(ex.ToString()); return; } }
protected void Page_Load(object sender, EventArgs e) { try { if (this.Request.HttpMethod != "GET") { this.Response.Write("Request method must be GET"); return; } this.Response.ContentType = "multipart/form-data"; using (SmartCityEntities ctx = new SmartCityEntities()) { int deviceid = Convert.ToInt32(this.Request.QueryString["device"].ToString()); SampledImage sImage = ctx.SampledImage.OrderByDescending(pimg => pimg.id_images).FirstOrDefault(devid => devid.device_id == deviceid); if(sImage != null) { this.Response.ContentType = "image/jpg"; this.Response.AppendHeader("Content-Disposition", string.Format("attachment; filename={0}.jpg", deviceid)); this.Response.OutputStream.Write(sImage.imagesample, 0, sImage.imagesample.Count()); return; } } } catch (Exception ex) { this.Response.Write(ex.ToString()); return; } }
protected void Page_Load(object sender, EventArgs e) { try { if (this.Request.HttpMethod != "GET") { this.Response.Write("Request method must be GET"); return; } this.Response.ContentType = "multipart/form-data"; using (SmartCityEntities ctx = new SmartCityEntities()) { int deviceid = Convert.ToInt32(this.Request.QueryString["device"].ToString()); SampledImage sImage = ctx.SampledImage.OrderByDescending(pimg => pimg.id_images).FirstOrDefault(devid => devid.device_id == deviceid); if (sImage != null) { this.Response.ContentType = "image/jpg"; this.Response.AppendHeader("Content-Disposition", string.Format("attachment; filename={0}.jpg", deviceid)); this.Response.OutputStream.Write(sImage.imagesample, 0, sImage.imagesample.Count()); return; } } } catch (Exception ex) { this.Response.Write(ex.ToString()); return; } }
protected void Page_Load(object sender, EventArgs e) { try { if (this.Request.HttpMethod != "GET") { this.Response.Write("Request method must be GET"); return; } System.Text.StringBuilder bld = new System.Text.StringBuilder(); bld.AppendLine("<?xml version=\"1.0\" encoding=\"utf-8\" ?> "); bld.Append("<Devices>"); NumberFormatInfo numFormat = new NumberFormatInfo(); numFormat.NumberDecimalSeparator = "."; using (SmartCityEntities ctx = new SmartCityEntities()) { List<int?> tt = ctx.Sample.Select(d => d.device_id).Distinct().ToList(); foreach (int? item in tt) { if (item.HasValue) { bld.Append(String.Format("<Device>{0}</Device>", item.Value)); } } } bld.AppendLine("</Devices>"); this.Response.Write(bld.ToString()); } catch (Exception ex) { this.Response.Write(ex.ToString()); return; } }
protected void Page_Load(object sender, EventArgs e) { try { System.Text.StringBuilder bld = new System.Text.StringBuilder(); bld.AppendLine("<?xml version=\"1.0\" encoding=\"utf-8\" ?> "); bld.AppendLine("<Measurements>"); NumberFormatInfo numFormat = new NumberFormatInfo(); numFormat.NumberDecimalSeparator = "."; int device = 0; using (SmartCityEntities ctx = new SmartCityEntities()) { List<Sample> samples = ctx.Sample.ToList(); if (this.Request.QueryString.AllKeys.Contains("device")) { device = Convert.ToInt32(this.Request.QueryString["device"]); samples = samples.Where(dev => dev.device_id == device).ToList(); } samples = samples.OrderBy(dev => dev.id_measurement).Take(1).ToList(); foreach (var item in samples) { bld.AppendLine("<Measurement>"); bld.AppendLine(String.Format("<id>{0}</id>", item.id_measurement)); bld.AppendLine(String.Format("<deviceId>{0}</deviceId>", item.device_id)); bld.AppendLine(String.Format("<timestamp>{0}</timestamp>", item.sample_time)); bld.AppendLine(String.Format(numFormat, "<longitude>{0}</longitude>", item.lon)); bld.AppendLine(String.Format(numFormat, "<latitude>{0}</latitude>", item.lat)); bld.AppendLine(String.Format(numFormat, "<humidity>{0}</humidity>", item.humidity)); bld.AppendLine(String.Format(numFormat, "<temperature>{0}</temperature>", item.temperature)); bld.AppendLine(String.Format(numFormat, "<pressure>{0}</pressure>", item.pressure)); bld.AppendLine(String.Format(numFormat, "<sound>{0}</sound>", item.sound)); bld.AppendLine(String.Format(numFormat, "<uv>{0}</uv>", item.uv)); bld.AppendLine(String.Format(numFormat, "<xacceleration>{0}</xacceleration>", item.xacceleration)); bld.AppendLine(String.Format(numFormat, "<yacceleration>{0}</yacceleration>", item.yacceleration)); bld.AppendLine(String.Format(numFormat, "<zacceleration>{0}</zacceleration>", item.zacceleration)); bld.AppendLine(String.Format(numFormat, "<xrotation>{0}</xrotation>", item.xrotation)); bld.AppendLine(String.Format(numFormat, "<yrotation>{0}</yrotation>", item.yrotation)); bld.AppendLine(String.Format(numFormat, "<zrotation>{0}</zrotation>", item.zrotation)); bld.AppendLine(String.Format(numFormat, "<xmagneticforce>{0}</xmagneticforce>", item.xmagneticforce)); bld.AppendLine(String.Format(numFormat, "<ymagneticforce>{0}</ymagneticforce>", item.ymagneticforce)); bld.AppendLine(String.Format(numFormat, "<zmagneticforce>{0}</zmagneticforce>", item.zmagneticforce)); bld.AppendLine(String.Format(numFormat, "<accelerationmagnitude>{0}</accelerationmagnitude>", item.accelerationmagnitude)); bld.AppendLine(String.Format("</Measurement>")); } } bld.AppendLine("</Measurements>"); string xmlDat = bld.ToString(); System.Drawing.Image imgGo = Computed(xmlDat); byte[] imgArr = ImageToByte2(imgGo); this.Response.ContentType = "image/png"; this.Response.AppendHeader("Content-Disposition", string.Format("attachment; filename={0}.png", device)); this.Response.OutputStream.Write(imgArr, 0, imgArr.Count()); return; } catch (Exception ex) { this.Response.Write(ex.ToString()); return; } }
protected void Page_Load(object sender, EventArgs e) { try { if (this.Request.HttpMethod != "POST") { this.Response.Write("Request method must be POST"); return; } System.IO.BufferedStream bufStream = new System.IO.BufferedStream(this.Request.InputStream); System.IO.StreamReader read = new System.IO.StreamReader(bufStream); string postData = read.ReadToEnd(); System.Xml.XmlDocument xmldoc = new System.Xml.XmlDocument(); xmldoc.LoadXml(postData); NumberFormatInfo numFormat = new NumberFormatInfo(); numFormat.NumberDecimalSeparator = "."; using (SmartCityEntities ctx = new SmartCityEntities()) { Sample newSample = new Sample(); newSample.device_id = Convert.ToInt32(xmldoc["Measurements"]["Measurement"]["deviceId"].InnerText.ToString()); newSample.sample_time = DateTime.Now; if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("latitude").Count > 0) { newSample.lat = Convert.ToDecimal(xmldoc["Measurements"]["Measurement"]["latitude"].InnerText.Replace(',', '.'), numFormat); } if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("longitude").Count > 0) { newSample.lon = Convert.ToDecimal(xmldoc["Measurements"]["Measurement"]["longitude"].InnerText.Replace(',', '.'), numFormat); } if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("temperature").Count > 0) { newSample.temperature = Convert.ToDouble(xmldoc["Measurements"]["Measurement"]["temperature"].InnerText.ToString().Replace(',', '.'), numFormat); } if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("humidity").Count > 0) { newSample.humidity = Convert.ToDouble(xmldoc["Measurements"]["Measurement"]["humidity"].InnerText.ToString().Replace(',', '.'), numFormat); } if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("pressure").Count > 0) { newSample.pressure = Convert.ToDouble(xmldoc["Measurements"]["Measurement"]["pressure"].InnerText.ToString().Replace(',', '.'), numFormat); } if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("sound").Count > 0) { newSample.sound = Convert.ToDouble(xmldoc["Measurements"]["Measurement"]["sound"].InnerText.ToString().Replace(',', '.'), numFormat); } if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("winddirection").Count > 0) { newSample.winddirection = Convert.ToDouble(xmldoc["Measurements"]["Measurement"]["winddirection"].InnerText.ToString().Replace(',', '.'), numFormat); } if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("uv").Count > 0) { newSample.uv = Convert.ToDouble(xmldoc["Measurements"]["Measurement"]["uv"].InnerText.ToString().Replace(',', '.'), numFormat); } if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("xacceleration").Count > 0) { newSample.xacceleration = Convert.ToDouble(xmldoc["Measurements"]["Measurement"]["xacceleration"].InnerText.ToString().Replace(',', '.'), numFormat); } if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("yacceleration").Count > 0) { newSample.yacceleration = Convert.ToDouble(xmldoc["Measurements"]["Measurement"]["yacceleration"].InnerText.ToString().Replace(',', '.'), numFormat); } if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("zacceleration").Count > 0) { newSample.zacceleration = Convert.ToDouble(xmldoc["Measurements"]["Measurement"]["zacceleration"].InnerText.ToString().Replace(',', '.'), numFormat); } if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("xrotation").Count > 0) { newSample.xrotation = Convert.ToDouble(xmldoc["Measurements"]["Measurement"]["xrotation"].InnerText.ToString().Replace(',', '.'), numFormat); } if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("yrotation").Count > 0) { newSample.yrotation = Convert.ToDouble(xmldoc["Measurements"]["Measurement"]["yrotation"].InnerText.ToString().Replace(',', '.'), numFormat); } if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("zrotation").Count > 0) { newSample.zrotation = Convert.ToDouble(xmldoc["Measurements"]["Measurement"]["zrotation"].InnerText.ToString().Replace(',', '.'), numFormat); } if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("xmagneticforce").Count > 0) { newSample.xmagneticforce = Convert.ToDouble(xmldoc["Measurements"]["Measurement"]["xmagneticforce"].InnerText.ToString().Replace(',', '.'), numFormat); } if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("ymagneticforce").Count > 0) { newSample.ymagneticforce = Convert.ToDouble(xmldoc["Measurements"]["Measurement"]["ymagneticforce"].InnerText.ToString().Replace(',', '.'), numFormat); } if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("zmagneticforce").Count > 0) { newSample.zmagneticforce = Convert.ToDouble(xmldoc["Measurements"]["Measurement"]["zmagneticforce"].InnerText.ToString().Replace(',', '.'), numFormat); } if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("accelerationmagnitude").Count > 0) { newSample.accelerationmagnitude = Convert.ToDouble(xmldoc["Measurements"]["Measurement"]["accelerationmagnitude"].InnerText.ToString().Replace(',', '.'), numFormat); } if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("battery").Count > 0) { newSample.battery = Convert.ToDouble(xmldoc["Measurements"]["Measurement"]["battery"].InnerText.ToString().Replace(',', '.'), numFormat); } if (xmldoc["Measurements"]["Measurement"].GetElementsByTagName("wind").Count > 0) { newSample.wind = Convert.ToDouble(xmldoc["Measurements"]["Measurement"]["wind"].InnerText.ToString().Replace(',', '.'), numFormat); } ctx.Sample.Add(newSample); ctx.SaveChanges(); } } catch (Exception ex) { this.Response.Write(ex.ToString()); return; } }
protected void Page_Load(object sender, EventArgs e) { //string response = System.IO.File.ReadAllText(MapPath("TestXml.xml")); //this.Page.Request.QueryString; //this.Response.Write(response); try { if (this.Request.HttpMethod != "GET") { this.Response.Write("Request method must be GET"); return; } System.Text.StringBuilder bld = new System.Text.StringBuilder(); bld.AppendLine("<?xml version=\"1.0\" encoding=\"utf-8\" ?> "); bld.AppendLine("<Measurements>"); NumberFormatInfo numFormat = new NumberFormatInfo(); numFormat.NumberDecimalSeparator = "."; using (SmartCityEntities ctx = new SmartCityEntities()) { List <Sample> samples = ctx.Sample.ToList(); if (this.Request.QueryString.AllKeys.Contains("device")) { int device = Convert.ToInt32(this.Request.QueryString["device"]); samples = samples.Where(dev => dev.device_id == device).ToList(); } bool isonlylast = false; if (this.Request.QueryString.AllKeys.Contains("onlylast") & this.Request.QueryString["onlylast"] == "true") { isonlylast = true; samples = samples.OrderBy(dev => dev.id_measurement).Take(1).ToList(); } if (this.Request.QueryString.AllKeys.Contains("lat") & this.Request.QueryString.AllKeys.Contains("lon") & this.Request.QueryString.AllKeys.Contains("radius")) { double lat = Convert.ToDouble(this.Request.QueryString["lat"].Replace(',', '.'), numFormat); double lon = Convert.ToDouble(this.Request.QueryString["lon"].Replace(',', '.'), numFormat); double radius = Convert.ToDouble(this.Request.QueryString["radius"].Replace(',', '.'), numFormat); double latOff = 0.0; double lonOff = 0.0; decimal latd = (decimal)lat; decimal lond = (decimal)lon; LatOffset(radius, lat, lon, out latOff, out lonOff); samples = samples.Where(dev => dev.lat > (latd - (decimal)latOff) & dev.lat <(latd + (decimal)latOff)& dev.lon> (lond - (decimal)lonOff) & dev.lon < (lond + (decimal)lonOff)).ToList(); } foreach (var item in samples) { bld.AppendLine("<Measurement>"); bld.AppendLine(String.Format("<id>{0}</id>", item.id_measurement)); bld.AppendLine(String.Format("<deviceId>{0}</deviceId>", item.device_id)); bld.AppendLine(String.Format("<timestamp>{0}</timestamp>", item.sample_time)); bld.AppendLine(String.Format(numFormat, "<longitude>{0}</longitude>", item.lon)); bld.AppendLine(String.Format(numFormat, "<latitude>{0}</latitude>", item.lat)); //bool humset = false; //bool tempset = false; //bool presset = false; //if (item.lat.HasValue & item.lon.HasValue & isonlylast) //{ // string lat = item.lat.ToString().Replace(',', '.'); // string lon = item.lon.ToString().Replace(',', '.'); // CityCountry cc = ReverseGeocoding.GetCityCountry(lat, lon); // bld.AppendLine(String.Format("<Country>{0}</Country>", cc.countryName)); // bld.AppendLine(String.Format("<City>{0}</City>", cc.adminName1)); // WeatherReading ww = WorldWeather.getWeatherAt(lat, lon); // bld.AppendLine(String.Format("<Humidity>{0}</Humidity>", ww.humidity.Replace(',', '.'))); // bld.AppendLine(String.Format("<Temperature>{0}</Temperature>", ww.tempC.Replace(',', '.'))); // bld.AppendLine(String.Format("<Windspeed>{0}</Windspeed>", ww.windspeed.Replace(',', '.'))); // bld.AppendLine(String.Format("<Winddirection>{0}</Winddirection>", ww.winddirection.Replace(',', '.'))); // bld.AppendLine(String.Format("<Visibility>{0}</Visibility>", ww.visibility.Replace(',', '.'))); // bld.AppendLine(String.Format("<Pressure>{0}</Pressure>", ww.pressure.Replace(',', '.'))); // bld.AppendLine(String.Format("<Cloudcover>{0}</Cloudcover>", ww.cloudcover.Replace(',', '.'))); //} //else //{ bld.AppendLine(String.Format(numFormat, "<humidity>{0}</humidity>", item.humidity)); bld.AppendLine(String.Format(numFormat, "<temperature>{0}</temperature>", item.temperature)); bld.AppendLine(String.Format(numFormat, "<pressure>{0}</pressure>", item.pressure)); //} bld.AppendLine(String.Format(numFormat, "<sound>{0}</sound>", item.sound)); bld.AppendLine(String.Format(numFormat, "<uv>{0}</uv>", item.uv)); bld.AppendLine(String.Format(numFormat, "<xacceleration>{0}</xacceleration>", item.xacceleration)); bld.AppendLine(String.Format(numFormat, "<yacceleration>{0}</yacceleration>", item.yacceleration)); bld.AppendLine(String.Format(numFormat, "<zacceleration>{0}</zacceleration>", item.zacceleration)); bld.AppendLine(String.Format(numFormat, "<xrotation>{0}</xrotation>", item.xrotation)); bld.AppendLine(String.Format(numFormat, "<yrotation>{0}</yrotation>", item.yrotation)); bld.AppendLine(String.Format(numFormat, "<zrotation>{0}</zrotation>", item.zrotation)); bld.AppendLine(String.Format(numFormat, "<xmagneticforce>{0}</xmagneticforce>", item.xmagneticforce)); bld.AppendLine(String.Format(numFormat, "<ymagneticforce>{0}</ymagneticforce>", item.ymagneticforce)); bld.AppendLine(String.Format(numFormat, "<zmagneticforce>{0}</zmagneticforce>", item.zmagneticforce)); bld.AppendLine(String.Format(numFormat, "<accelerationmagnitude>{0}</accelerationmagnitude>", item.accelerationmagnitude)); //bld.AppendLine(String.Format("<longitude>{0}</longitude>", item.lon.ToString().Replace(',', '.'))); //bld.AppendLine(String.Format("<latitude>{0}</latitude>", item.lat.ToString().Replace(',', '.'))); //bld.AppendLine(String.Format("<humidity>{0}</humidity>", item.humidity.ToString().Replace(',', '.'))); //bld.AppendLine(String.Format("<temperature>{0}</temperature>", item.temperature.ToString().Replace(',', '.'))); bld.AppendLine(String.Format("</Measurement>")); } } bld.AppendLine("</Measurements>"); this.Response.Write(bld.ToString()); } catch (Exception ex) { this.Response.Write(ex.ToString()); return; } }
protected void Page_Load(object sender, EventArgs e) { //string response = System.IO.File.ReadAllText(MapPath("TestXml.xml")); //this.Page.Request.QueryString; //this.Response.Write(response); try { if (this.Request.HttpMethod != "GET") { this.Response.Write("Request method must be GET"); return; } System.Text.StringBuilder bld = new System.Text.StringBuilder(); bld.AppendLine("<?xml version=\"1.0\" encoding=\"utf-8\" ?> "); bld.AppendLine("<Measurements>"); NumberFormatInfo numFormat = new NumberFormatInfo(); numFormat.NumberDecimalSeparator = "."; using (SmartCityEntities ctx = new SmartCityEntities()) { List<Sample> samples = ctx.Sample.ToList(); if (this.Request.QueryString.AllKeys.Contains("device")) { int device = Convert.ToInt32(this.Request.QueryString["device"]); samples = samples.Where(dev => dev.device_id == device).ToList(); } bool isonlylast = false; if (this.Request.QueryString.AllKeys.Contains("onlylast") & this.Request.QueryString["onlylast"] == "true") { isonlylast = true; samples = samples.OrderBy(dev => dev.id_measurement).Take(1).ToList(); } if (this.Request.QueryString.AllKeys.Contains("lat") & this.Request.QueryString.AllKeys.Contains("lon") & this.Request.QueryString.AllKeys.Contains("radius")) { double lat = Convert.ToDouble(this.Request.QueryString["lat"].Replace(',','.'), numFormat); double lon = Convert.ToDouble(this.Request.QueryString["lon"].Replace(',','.'), numFormat); double radius = Convert.ToDouble(this.Request.QueryString["radius"].Replace(',','.'), numFormat); double latOff = 0.0; double lonOff = 0.0; decimal latd = (decimal)lat; decimal lond = (decimal)lon; LatOffset(radius, lat, lon, out latOff, out lonOff); samples = samples.Where(dev => dev.lat > (latd - (decimal)latOff) & dev.lat < (latd + (decimal)latOff) & dev.lon > (lond - (decimal)lonOff) & dev.lon < (lond + (decimal)lonOff)).ToList(); } foreach (var item in samples) { bld.AppendLine("<Measurement>"); bld.AppendLine(String.Format("<id>{0}</id>", item.id_measurement)); bld.AppendLine(String.Format("<deviceId>{0}</deviceId>", item.device_id)); bld.AppendLine(String.Format("<timestamp>{0}</timestamp>", item.sample_time)); bld.AppendLine(String.Format(numFormat, "<longitude>{0}</longitude>", item.lon)); bld.AppendLine(String.Format(numFormat, "<latitude>{0}</latitude>", item.lat)); //bool humset = false; //bool tempset = false; //bool presset = false; //if (item.lat.HasValue & item.lon.HasValue & isonlylast) //{ // string lat = item.lat.ToString().Replace(',', '.'); // string lon = item.lon.ToString().Replace(',', '.'); // CityCountry cc = ReverseGeocoding.GetCityCountry(lat, lon); // bld.AppendLine(String.Format("<Country>{0}</Country>", cc.countryName)); // bld.AppendLine(String.Format("<City>{0}</City>", cc.adminName1)); // WeatherReading ww = WorldWeather.getWeatherAt(lat, lon); // bld.AppendLine(String.Format("<Humidity>{0}</Humidity>", ww.humidity.Replace(',', '.'))); // bld.AppendLine(String.Format("<Temperature>{0}</Temperature>", ww.tempC.Replace(',', '.'))); // bld.AppendLine(String.Format("<Windspeed>{0}</Windspeed>", ww.windspeed.Replace(',', '.'))); // bld.AppendLine(String.Format("<Winddirection>{0}</Winddirection>", ww.winddirection.Replace(',', '.'))); // bld.AppendLine(String.Format("<Visibility>{0}</Visibility>", ww.visibility.Replace(',', '.'))); // bld.AppendLine(String.Format("<Pressure>{0}</Pressure>", ww.pressure.Replace(',', '.'))); // bld.AppendLine(String.Format("<Cloudcover>{0}</Cloudcover>", ww.cloudcover.Replace(',', '.'))); //} //else //{ bld.AppendLine(String.Format(numFormat, "<humidity>{0}</humidity>", item.humidity)); bld.AppendLine(String.Format(numFormat, "<temperature>{0}</temperature>", item.temperature)); bld.AppendLine(String.Format(numFormat, "<pressure>{0}</pressure>", item.pressure)); //} bld.AppendLine(String.Format(numFormat, "<sound>{0}</sound>", item.sound)); bld.AppendLine(String.Format(numFormat, "<uv>{0}</uv>", item.uv)); bld.AppendLine(String.Format(numFormat, "<xacceleration>{0}</xacceleration>", item.xacceleration)); bld.AppendLine(String.Format(numFormat, "<yacceleration>{0}</yacceleration>", item.yacceleration)); bld.AppendLine(String.Format(numFormat, "<zacceleration>{0}</zacceleration>", item.zacceleration)); bld.AppendLine(String.Format(numFormat, "<xrotation>{0}</xrotation>", item.xrotation)); bld.AppendLine(String.Format(numFormat, "<yrotation>{0}</yrotation>", item.yrotation)); bld.AppendLine(String.Format(numFormat, "<zrotation>{0}</zrotation>", item.zrotation)); bld.AppendLine(String.Format(numFormat, "<xmagneticforce>{0}</xmagneticforce>", item.xmagneticforce)); bld.AppendLine(String.Format(numFormat, "<ymagneticforce>{0}</ymagneticforce>", item.ymagneticforce)); bld.AppendLine(String.Format(numFormat, "<zmagneticforce>{0}</zmagneticforce>", item.zmagneticforce)); bld.AppendLine(String.Format(numFormat, "<accelerationmagnitude>{0}</accelerationmagnitude>", item.accelerationmagnitude)); //bld.AppendLine(String.Format("<longitude>{0}</longitude>", item.lon.ToString().Replace(',', '.'))); //bld.AppendLine(String.Format("<latitude>{0}</latitude>", item.lat.ToString().Replace(',', '.'))); //bld.AppendLine(String.Format("<humidity>{0}</humidity>", item.humidity.ToString().Replace(',', '.'))); //bld.AppendLine(String.Format("<temperature>{0}</temperature>", item.temperature.ToString().Replace(',', '.'))); bld.AppendLine(String.Format("</Measurement>")); } } bld.AppendLine("</Measurements>"); this.Response.Write(bld.ToString()); } catch (Exception ex) { this.Response.Write(ex.ToString()); return; } }
protected void Page_Load(object sender, EventArgs e) { try { System.Text.StringBuilder bld = new System.Text.StringBuilder(); bld.AppendLine("<?xml version=\"1.0\" encoding=\"utf-8\" ?> "); bld.AppendLine("<Measurements>"); NumberFormatInfo numFormat = new NumberFormatInfo(); numFormat.NumberDecimalSeparator = "."; int device = 0; using (SmartCityEntities ctx = new SmartCityEntities()) { List <Sample> samples = ctx.Sample.ToList(); if (this.Request.QueryString.AllKeys.Contains("device")) { device = Convert.ToInt32(this.Request.QueryString["device"]); samples = samples.Where(dev => dev.device_id == device).ToList(); } samples = samples.OrderBy(dev => dev.id_measurement).Take(1).ToList(); foreach (var item in samples) { bld.AppendLine("<Measurement>"); bld.AppendLine(String.Format("<id>{0}</id>", item.id_measurement)); bld.AppendLine(String.Format("<deviceId>{0}</deviceId>", item.device_id)); bld.AppendLine(String.Format("<timestamp>{0}</timestamp>", item.sample_time)); bld.AppendLine(String.Format(numFormat, "<longitude>{0}</longitude>", item.lon)); bld.AppendLine(String.Format(numFormat, "<latitude>{0}</latitude>", item.lat)); bld.AppendLine(String.Format(numFormat, "<humidity>{0}</humidity>", item.humidity)); bld.AppendLine(String.Format(numFormat, "<temperature>{0}</temperature>", item.temperature)); bld.AppendLine(String.Format(numFormat, "<pressure>{0}</pressure>", item.pressure)); bld.AppendLine(String.Format(numFormat, "<sound>{0}</sound>", item.sound)); bld.AppendLine(String.Format(numFormat, "<uv>{0}</uv>", item.uv)); bld.AppendLine(String.Format(numFormat, "<xacceleration>{0}</xacceleration>", item.xacceleration)); bld.AppendLine(String.Format(numFormat, "<yacceleration>{0}</yacceleration>", item.yacceleration)); bld.AppendLine(String.Format(numFormat, "<zacceleration>{0}</zacceleration>", item.zacceleration)); bld.AppendLine(String.Format(numFormat, "<xrotation>{0}</xrotation>", item.xrotation)); bld.AppendLine(String.Format(numFormat, "<yrotation>{0}</yrotation>", item.yrotation)); bld.AppendLine(String.Format(numFormat, "<zrotation>{0}</zrotation>", item.zrotation)); bld.AppendLine(String.Format(numFormat, "<xmagneticforce>{0}</xmagneticforce>", item.xmagneticforce)); bld.AppendLine(String.Format(numFormat, "<ymagneticforce>{0}</ymagneticforce>", item.ymagneticforce)); bld.AppendLine(String.Format(numFormat, "<zmagneticforce>{0}</zmagneticforce>", item.zmagneticforce)); bld.AppendLine(String.Format(numFormat, "<accelerationmagnitude>{0}</accelerationmagnitude>", item.accelerationmagnitude)); bld.AppendLine(String.Format("</Measurement>")); } } bld.AppendLine("</Measurements>"); string xmlDat = bld.ToString(); System.Drawing.Image imgGo = Computed(xmlDat); byte[] imgArr = ImageToByte2(imgGo); this.Response.ContentType = "image/png"; this.Response.AppendHeader("Content-Disposition", string.Format("attachment; filename={0}.png", device)); this.Response.OutputStream.Write(imgArr, 0, imgArr.Count()); return; } catch (Exception ex) { this.Response.Write(ex.ToString()); return; } }