public IActionResult Index(MyFiltersPersonaje filtro) { IEnumerable <Personaje> lst = null; using (var db = new SqlConnection(connection_Sql)) { var sql = "SELECT * FROM Personaje p INNER JOIN Clase c ON c.Cls_Id = p.Cls_Id"; sql = AgregarFiltrado(sql, filtro); lst = db.Query <Personaje, Clase, Personaje>( sql, (personaje, clase) => { personaje.Clase = clase; return(personaje); }, splitOn: "Cls_Id").Distinct().ToList(); } var model = new PersonajeViewModel(); model.Personajes = lst; model.DropClases = DropClases(); return(View(model)); }
private void verdetalle(object sender, RoutedEventArgs e) { Button button = sender as Button; PersonajeViewModel viewModel = button.DataContext as PersonajeViewModel; int id = viewModel.Id; this.NavigationService.Navigate(new AltaPersonaje(id, true)); }
private void subirnivel(object sender, RoutedEventArgs e) { Button button = sender as Button; PersonajeViewModel viewModel = button.DataContext as PersonajeViewModel; int id = viewModel.Id; this.NavigationService.Navigate(new SubirNivel(id)); }
private void eliminar(object sender, RoutedEventArgs e) { Button button = sender as Button; PersonajeViewModel viewModel = button.DataContext as PersonajeViewModel; int id = viewModel.Id; PersonajeCaracteristicaBL.eliminarPersonajeCarcteristicasPorPersonaje(id); PersonajeBL.Eliminar(PersonajeBL.Obtener(id)); dataSource.Remove(viewModel); view.Refresh(); }