private void Button1_Click(object sender, EventArgs e)
{
switch (comboBox1.SelectedIndex)
{
case 0: // "Кузнечная(Ленина)":
APoint = PointLatLng.Add(new PointLatLng(50.256451, 127.547085), SizeLatLng.Empty);
break;
case 1: // "Театральная(Зейская)":
APoint = PointLatLng.Add(new PointLatLng(50.259320, 127.550686), SizeLatLng.Empty);
break;
case 2: //"Шимановского(Горького)":
APoint = PointLatLng.Add(new PointLatLng(50.265439, 127.542868), SizeLatLng.Empty);
break;
case 3: //"Универмаг":
APoint = PointLatLng.Add(new PointLatLng(50.262894, 127.534690), SizeLatLng.Empty);
break;
case 4: //"Шимановского(Ленина)":
APoint = PointLatLng.Add(new PointLatLng(50.257093, 127.540564), SizeLatLng.Empty);
break;
case 5: //"Шимановского(Ленина)":
APoint = PointLatLng.Add(new PointLatLng(50.260262, 127.536841), SizeLatLng.Empty);
break;
default:
break;
}
switch (comboBox2.SelectedIndex)
{
case 0: // "Кузнечная(Ленина)":
BPoint = PointLatLng.Add(new PointLatLng(50.256451, 127.547085), SizeLatLng.Empty);
break;
case 1: // "Театральная(Зейская)":
BPoint = PointLatLng.Add(new PointLatLng(50.259320, 127.550686), SizeLatLng.Empty);
break;
case 2: //"Шимановского(Горького)":
BPoint = PointLatLng.Add(new PointLatLng(50.265439, 127.542868), SizeLatLng.Empty);
break;
case 3: //"Универмаг":
BPoint = PointLatLng.Add(new PointLatLng(50.262894, 127.534690), SizeLatLng.Empty);
break;
case 4: //"Шимановского(Ленина)":
BPoint = PointLatLng.Add(new PointLatLng(50.257093, 127.540564), SizeLatLng.Empty);
break;
case 5: //"Шимановского(Ленина)":
BPoint = PointLatLng.Add(new PointLatLng(50.260262, 127.536841), SizeLatLng.Empty);
break;
default:
break;
}
if (comboBox1.SelectedIndex != -1 && comboBox2.SelectedIndex != -1)
{
using (SQLiteConnection conn = new SQLiteConnection("Data Source=bus.db; Version=3;"))
{
conn.Open();
SQLiteCommand cmd = conn.CreateCommand();
try
{
cmd.CommandText =
"INSERT INTO ActiveResp (username,Astop, Bstop, ALon, ALat, BLon, BLat) VALUES ('" +
textBox1.Text + "','" +
comboBox1.Text + "','" + comboBox2.Text + "','" + APoint.Lng.ToString() + "','" +
APoint.Lat.ToString() +
"','" + BPoint.Lng.ToString() +
"','" + BPoint.Lat.ToString() + "')";
cmd.ExecuteNonQuery();
}
catch (SQLiteException ex)
{
MessageBox.Show(ex.Message);
}
conn.Dispose();
}
start = DateTime.Now;
timer1.Start();
label4.Visible = true;
textBox1.Text = String.Empty;
comboBox1.ResetText();
comboBox2.ResetText();
}
}