private void textBox1_TextChanged(object sender, EventArgs e)
{
if (textBox1.Text.ToString() != "")
{
var dadata = new SuggestClientDadata();
array = dadata.SuggestAddress(textBox1.Text.ToString()).ToArray();
listBox1.Items.Clear();
listBox1.Visible = true;
for (int i = 0; i < array.Count(); i++)
{
listBox1.Items.Add(array[i].value);
}
}
}
public static DataSet findKladr(string data)
{
string query = "";
string response = "";
DataSet dsobjects = new DataSet();
string sConnectionString = "Data Source=ТИНА-ПК\\SQLEXPRESS;Initial Catalog=realton;Integrated Security=True";
SqlConnection objConn = new SqlConnection(sConnectionString);
objConn.Open();
var suggests = new SuggestClientDadata();
var address = suggests.SuggestAddress(data).ToArray();
if (address[0].data.street != null)
{
response = address[0].data.street_kladr_id;
query = "select distinct addressId from Objects left join Adresses on Adresses.id = addressId left join Streets on Streets.id = streetId where street_kladr_id ='" + response + "'";
}
else if (address[0].data.settlement != null)
{
response = address[0].data.settlement_kladr_id;
query = "select distinct Adresses.id from Adresses left join Settlements on Settlements.id = settlementId where settlement_kladr_id ='" + response + "'";
}
else if (address[0].data.city != null)
{
response = address[0].data.city_kladr_id;
query = "select distinct Adresses.id from Adresses left join Cities on Cities.id = cityId where city_kladr_id = '" + response + "'";
}
if (response != "" && query != "")
{
SqlDataAdapter array = new SqlDataAdapter(query, objConn);
array.Fill(dsobjects, "Obj");
}
objConn.Close();
return(dsobjects);
}
