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