private void LoadGrid()
{
using (mycityDbContext context = new mycityDbContext())
{
var places = (from p in context.Places select p).ToList();
dataGridPlace.ItemsSource = places;
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
using (mycityDbContext myDbC = new mycityDbContext())
{
var myplaces = myDbC.Places;
foreach (Places p in myplaces)
{
lstBox.Items.Add(p.Name);
}
}
}
private void BtnSave_Click(object sender, RoutedEventArgs e)
{
MessageBoxResult result = MessageBox.Show("Girilen veriler veri tabanına yazılacak, onaylıyor musunuz?", "My App", MessageBoxButton.YesNoCancel);
switch (result)
{
case MessageBoxResult.Yes:
double lat = Convert.ToDouble(txtBoxPlaceLatitude.Text);
double lng = Convert.ToDouble(txtBoxPlaceLongitude.Text);
NetTopologySuite.Geometries.Point point = new NetTopologySuite.Geometries.Point(lat, lng)
{
SRID = 4326
};
Places place = new Places()
{
Type = txtBoxPlaceType.Text,
Name = txtBoxPlaceName.Text,
Tel = txtPhone.Text,
Address = txtAddress.Text,
Location = point,
};
using (mycityDbContext context = new mycityDbContext())
{
context.Add(place);
context.SaveChanges();
}
MessageBox.Show("Veriler başarıyla aktarıldı...");
txtBoxPlaceType.Text = "";
txtBoxPlaceName.Text = "";
txtBoxPlaceLatitude.Text = "";
txtBoxPlaceLongitude.Text = "";
myMap.Mode = new AerialMode(true);
break;
case MessageBoxResult.No:
// MessageBox.Show("Oh well, too bad!", "My App");
break;
case MessageBoxResult.Cancel:
txtBoxPlaceType.Text = "";
txtBoxPlaceName.Text = "";
txtBoxPlaceLatitude.Text = "";
txtBoxPlaceLongitude.Text = "";
myMap.Mode = new AerialMode(true);
break;
}
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
Places placeRow = dataGridPlace.SelectedItem as Places;
using (mycityDbContext context = new mycityDbContext())
{
var place = (from p in context.Places where p.PlacesId == placeRow.PlacesId select p).Single();
context.Places.Remove(place);
context.SaveChanges();
MessageBox.Show("Satır silinmiştir.");
LoadGrid();
}
}
private void LstBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
using (mycityDbContext dbC = new mycityDbContext())
{
var myplaces = dbC.Places;
Location location = new Location();
foreach (Places p in myplaces)
{
if (lstBox.SelectedItem.ToString() == p.Name)
{
try
{
location.Latitude = p.Location.Coordinate.X;
location.Longitude = p.Location.Coordinate.Y;
myMap.Center = location;
myMap.ZoomLevel = 14;
myMap.Mode = new AerialMode(true);
}
catch
{
location.Latitude = myMap.Center.Latitude + 1;
location.Longitude = myMap.Center.Longitude + 1;
myMap.Center = location;
myMap.ZoomLevel = 14;
myMap.Mode = new AerialMode(true);
}
var pinContext = new PushPinContext(p);
pinContext.Visibility = Visibility.Hidden;
Pushpin pp = new Pushpin();
pp.Location = location;
pp.DataContext = pinContext;
pp.MouseRightButtonUp += pp_MouseButtonUp;
myMap.Children.Add(pp);
Label lblMa = new Label();
lblMa.Content = pinContext;
MapLayer.SetPosition(lblMa, location);
myMap.Children.Add(lblMa);
myMap.ZoomLevel = 14;
myMap.Mode = new AerialMode(true);
}
}
}
}
public PlaceService(mycityDbContext context)
{
this._context = context;
}
