private void createJson() { InmueblesBLL bllinmuebles = new InmueblesBLL(); dt = bllinmuebles.SelectAllInmueblesMapaPublico(); int count = 0; int position = 0; foreach (DataRow dtRow in dt.Rows) { DateTime FechaActualiza = Convert.ToDateTime(dtRow["fechaactualiza"].ToString()); TimeSpan diferencia = DateTime.Now - FechaActualiza; if (diferencia.Days <= 90) { if (dtRow["Latitud"].ToString() != "" && dtRow["Longitud"].ToString() != "") { count++; } } } //count = 100; string json = "{\"count\":" + count + ",\"photos\":["; foreach (DataRow dtRow in dt.Rows) { DateTime FechaActualiza = Convert.ToDateTime(dtRow["fechaactualiza"].ToString()); TimeSpan diferencia = DateTime.Now - FechaActualiza; if (diferencia.Days <= 90) { if (dtRow["Latitud"].ToString() != "" && dtRow["Longitud"].ToString() != "") { position++; if (dtRow["Numero"].ToString() == "900") { } if (position < count) { json += "{" + "\"mark_id\":\"" + dtRow["IdInmueble"].ToString() + "\"," + "\"Inmueble_dir\":\"" + validateNull(dtRow["Calle"].ToString()) + " " + validateNull(dtRow["Numero"].ToString()) + "\"," + "\"latitude\":" + convert(dtRow["Latitud"].ToString()) + "," + "\"longitude\":" + convert(dtRow["Longitud"].ToString()) + "," + "\"tipo\":\"" + dtRow["Tipo"].ToString() + "\"," + "\"Piso\":\"" + validateNull(dtRow["Piso"].ToString()) + "\"," + "\"Departamento\":\"" + validateNull(dtRow["Departamento"].ToString()) + "\"," + "\"Operacion\":\"" + dtRow["Operacion"].ToString().Trim() + "\"," + "\"nombreInmobiliaria\":\"" + dtRow["NombreInmobiliaria"].ToString() + "\"},"; } else { //if (position == count) { json += "{" + "\"mark_id\":\"" + dtRow["IdInmueble"].ToString() + "\"," + "\"Inmueble_dir\":\"" + dtRow["Calle"].ToString() + " " + dtRow["Numero"].ToString() + "\"," + "\"latitude\":" + convert(dtRow["Latitud"].ToString()) + "," + "\"longitude\":" + convert(dtRow["Longitud"].ToString()) + "," + "\"tipo\":\"" + dtRow["Tipo"].ToString() + "\"," + "\"Piso\":\"" + validateNull(dtRow["Piso"].ToString()) + "\"," + "\"Departamento\":\"" + validateNull(dtRow["Departamento"].ToString()) + "\"," + "\"Operacion\":\"" + dtRow["Operacion"].ToString().Trim() + "\"," + "\"nombreInmobiliaria\":\"" + dtRow["NombreInmobiliaria"].ToString() + "\"}"; // } } } } } json += "]}"; Response.Clear(); Response.ContentType = "application/json; charset=utf-8"; Response.Write(json); Response.End(); }