//[ScriptMethod(ResponseFormat = ResponseFormat.Json)] public google_geocodeClass googlegeocode(string address) //you can't pass any querystring params { Dictionary <string, string> options = new Dictionary <string, string>(); google_geocodeClass google_geocode = Functions.google_geocode("AIzaSyCCpsWhkuuHlAe6EKhSi5zSlmmIVMN9M8c", address, options); return(google_geocode); }
protected void btn_geocode_Click(object sender, EventArgs e) { string systemPrefix = "Community"; // WebConfigurationManager.AppSettings["systemPrefix"]; //string systemPrefix = WebConfigurationManager.AppSettings["systemPrefix"]; String connectionString = ConfigurationManager.ConnectionStrings[systemPrefix + "ConnectionString"].ConnectionString + ";MultipleActiveResultSets=true"; SqlConnection con = new SqlConnection(connectionString); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "select location_ctr, location from location where isnull(lng,'') = ''"; cmd.Connection = con; SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { string location_ctr = dr["location_ctr"].ToString(); string address = dr["location"].ToString(); options.Clear(); google_geocodeClass google_geocode = Functions.google_geocode("AIzaSyCCpsWhkuuHlAe6EKhSi5zSlmmIVMN9M8c", address, options); SqlCommand cmd1 = new SqlCommand(); cmd1.CommandType = CommandType.Text; cmd1.CommandText = "update location set lng = '" + google_geocode.lng + "', lat='" + google_geocode.lat + "' where location_ctr = " + location_ctr; cmd1.Connection = con; cmd1.ExecuteNonQuery(); cmd1.Dispose(); } dr.Close(); cmd.Dispose(); con.Close(); con.Dispose(); }
protected void btn_submit_Click(object sender, EventArgs e) { Boolean Creating = false; string systemPrefix = "Community"; // WebConfigurationManager.AppSettings["systemPrefix"]; //string systemPrefix = WebConfigurationManager.AppSettings["systemPrefix"]; String connectionString = ConfigurationManager.ConnectionStrings[systemPrefix + "ConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; person_guid = ViewState["person_guid"].ToString(); if (person_guid == "new") { Creating = true; } string lng = "0"; string lat = "0"; if (Request.Form["fld_location"].Trim() != "") { options.Clear(); google_geocodeClass google_geocode = Functions.google_geocode("AIzaSyCCpsWhkuuHlAe6EKhSi5zSlmmIVMN9M8c", Request.Form["fld_location"].Trim(), options); lng = google_geocode.lng; lat = google_geocode.lat; } cmd.CommandText = "Update_Person"; cmd.Parameters.Add("@person_guid", SqlDbType.VarChar).Value = person_guid; cmd.Parameters.Add("@username", SqlDbType.VarChar).Value = Username; cmd.Parameters.Add("@firstname", SqlDbType.VarChar).Value = Request.Form["fld_firstname"].Trim(); cmd.Parameters.Add("@lastname", SqlDbType.VarChar).Value = Request.Form["fld_lastname"].Trim(); cmd.Parameters.Add("@knownas", SqlDbType.VarChar).Value = Request.Form["fld_knownas"].Trim(); cmd.Parameters.Add("@gender", SqlDbType.VarChar).Value = Request.Form["fld_gender"].Trim(); cmd.Parameters.Add("@note", SqlDbType.VarChar).Value = Request.Form["fld_note"].Trim(); cmd.Parameters.Add("@location", SqlDbType.VarChar).Value = Request.Form["fld_location"].Trim(); cmd.Parameters.Add("@PAF", SqlDbType.VarChar).Value = Request.Form["fld_PAF"].Trim(); cmd.Parameters.Add("@phone", SqlDbType.VarChar).Value = Request.Form["fld_phone"].Trim(); cmd.Parameters.Add("@age", SqlDbType.VarChar).Value = Request.Form["fld_age"].Trim(); cmd.Parameters.Add("@lng", SqlDbType.VarChar).Value = lng; cmd.Parameters.Add("@lat", SqlDbType.VarChar).Value = lat; cmd.Parameters.Add("@contact_ctr", SqlDbType.VarChar).Value = Request.Form["fld_contact"].Trim(); cmd.Connection = con; con.Open(); person_guid = cmd.ExecuteScalar().ToString(); con.Close(); foreach (string key in Request.Form) { if (key.StartsWith("update_")) { string person_update_id = key.Substring(7); if (person_update_id.EndsWith("_delete")) { cmd.CommandText = "Delete_Person_update"; cmd.Parameters.Clear(); cmd.Parameters.Add("@username", SqlDbType.VarChar).Value = Username; cmd.Parameters.Add("@person_update_ctr", SqlDbType.VarChar).Value = person_update_id.Substring(0, person_update_id.Length - 7); } else { if (person_update_id.StartsWith("new")) { person_update_id = "new"; } string[] valuesSplit = Request.Form[key].Split('\x00FE'); cmd.CommandText = "Update_Person_update"; cmd.Parameters.Clear(); cmd.Parameters.Add("@username", SqlDbType.VarChar).Value = Username; cmd.Parameters.Add("@person_update_ctr", SqlDbType.VarChar).Value = person_update_id; cmd.Parameters.Add("@person_guid", SqlDbType.VarChar).Value = person_guid; //cmd.Parameters.Add("@person_ctr", SqlDbType.VarChar).Value = ; cmd.Parameters.Add("@datetime", SqlDbType.VarChar).Value = valuesSplit[0]; cmd.Parameters.Add("@Contact_CTR", SqlDbType.VarChar).Value = valuesSplit[1]; cmd.Parameters.Add("@note", SqlDbType.VarChar).Value = valuesSplit[2]; cmd.Parameters.Add("@followupaction", SqlDbType.VarChar).Value = valuesSplit[3]; cmd.Parameters.Add("@followupdate", SqlDbType.VarChar).Value = valuesSplit[4]; cmd.Parameters.Add("@followupdone", SqlDbType.VarChar).Value = valuesSplit[5]; } con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } con.Dispose(); //} string returnto = ViewState["returnto"].ToString(); ; if (Creating) { if (returnto == "") { returnto = "person.aspx?id=" + person_guid; } else { returnto = "person.aspx?id=" + person_guid + "&returnto=" + returnto + ".aspx"; } } else { if (returnto == "") { returnto = "search.aspx"; } } Response.Redirect(returnto); }