private void button2_Click(object sender, EventArgs e)
{
int selectedCellCount = dataGridView1.GetCellCount(DataGridViewElementStates.Selected);
if (selectedCellCount == 0)
{
MessageBox.Show("Ни одна клетка не выделена");
}
else
{
int rowIndex = dataGridView1.SelectedCells[0].RowIndex;
int idFound = Convert.ToInt32(dataGridView1.Rows[rowIndex].Cells[0].Value);
int rowsAmount = dataGridView1.Rows.Count;
CustomGMapMarker mrk = _mapMarkers.FirstOrDefault(x => x.Id == idFound);
using (SqlCommand command = new SqlCommand("DELETE FROM mark WHERE Id = " + idFound, _conn))
{
command.ExecuteNonQuery();
}
if (mrk != null)
{
_markerOverlay.Markers.Remove(mrk);
}
if (rowsAmount != 1)
{
dataGridView1.Rows.RemoveAt(rowIndex);
}
}
}
private void button3_Click(object sender, EventArgs e)
{
int selectedCellCount = dataGridView1.GetCellCount(DataGridViewElementStates.Selected);
if (selectedCellCount == 0)
{
MessageBox.Show("Ни одна клетка не выделена");
}
else
{
int rowIndex = dataGridView1.SelectedCells[0].RowIndex;
int idFound = Convert.ToInt32(dataGridView1.Rows[rowIndex].Cells[0].Value);
int rowsAmount = dataGridView1.Rows.Count;
CustomGMapMarker mrk = _mapMarkers.FirstOrDefault(x => x.Id == idFound);
gMapControl1.Position = mrk.Position;
}
}
private void gMapControl1_Load(object sender, EventArgs e)
{
gMapControl1.MaxZoom = 60;
gMapControl1.MinZoom = 0;
gMapControl1.Zoom = 17;
gMapControl1.MapProvider = YandexMapProvider.Instance;
GMaps.Instance.Mode = AccessMode.ServerOnly;
gMapControl1.Position = new PointLatLng(54.9860956, 82.9050593);
foreach (Marker i in _markers)
{
CustomGMapMarker mark = new CustomGMapMarker(i.Id, i.Point);
_mapMarkers.Add(mark);
_markerOverlay.Markers.Add(mark);
}
gMapControl1.Overlays.Add(_markerOverlay);
}
private void button1_Click(object sender, EventArgs e)
{
Form2 form = new Form2();
form.ShowDialog();
if (form.DialogResult == DialogResult.OK)
{
using (SqlCommand command = new SqlCommand($"INSERT INTO mark VALUES ('{form.Name}',{form.Lat},{form.Lng})", _conn))
{
command.ExecuteNonQuery();
}
UpdateData();
CustomGMapMarker mark = new CustomGMapMarker(_markers.Last().Id, _markers.Last().Point);
_mapMarkers.Add(mark);
_markerOverlay.Markers.Add(mark);
gMapControl1.Overlays.Add(_markerOverlay);
}
}
