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; }