public void Delete() { try { VideogamesContext context = new VideogamesContext(); context.Entry(this).State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); } catch (Exception) { throw; } }
public void Remove() { try { VideogamesContext context = new VideogamesContext(); context.Entry(this).State = System.Data.Entity.EntityState.Deleted; //borramos el producto context.SaveChanges(); //guardamos los cambios } catch (Exception e) { throw; } }
public static List <Videogames> SelectAll()//metodo para listar la tabla de videojuegos { List <Videogames> videogames = new List <Videogames>(); try { VideogamesContext context = new VideogamesContext(); videogames = context.Videogames.OrderBy(x => x.name).ToList();//Ordenamos por el nombre del juego y listamos la tabla } catch (Exception e) { throw; } return(videogames); }
public static List <Videogames> ListRanking() { List <Videogames> videogames = new List <Videogames>(); try { VideogamesContext context = new VideogamesContext(); videogames = context.Videogames.OrderByDescending(x => x.score).ToList(); } catch (Exception e) { throw; } return(videogames); }
public static List <Videogames> SelectAll() { List <Videogames> videogames = new List <Videogames>(); try { VideogamesContext context = new VideogamesContext(); videogames = context.Videogames.OrderBy(x => x.name).ToList(); } catch (Exception e) { Console.WriteLine("Ha habido un error al leer la base de datos: " + e); } return(videogames); }
public static List <Videogames> Ranking() { List <Videogames> ranking = new List <Videogames>(); try { VideogamesContext context = new VideogamesContext(); ranking = context.Videogames.OrderByDescending(x => x.score).ToList(); } catch (Exception e) { Console.WriteLine("Ha habido un error al leer la base de datos: " + e); } return(ranking); }
public static Videogames Get(int id) { Videogames videogame = new Videogames(); try { VideogamesContext context = new VideogamesContext(); videogame = context.Videogames.Where(x => x.id == id).SingleOrDefault(); } catch (Exception) { throw; } return(videogame); }
public static Videogames GetVideoGame(int id) { Videogames videogames = null; try { VideogamesContext context = new VideogamesContext(); videogames = context.Videogames.Where(x => x.id == id).SingleOrDefault();//devolvemos el videojuego que tenga la id dada } catch (Exception e) { throw; } return(videogames); }
public void Save() { bool create = this.id == 0; try { VideogamesContext context = new VideogamesContext(); if (create) { context.Entry(this).State = System.Data.Entity.EntityState.Added; } else { context.Entry(this).State = System.Data.Entity.EntityState.Modified; } context.SaveChanges(); } catch (Exception) { throw; } }
public void Save() { bool crear = this.id == 0;//sera verdadero cuando la id sea 0 try { VideogamesContext context = new VideogamesContext(); //creamos el contexto if (crear) //si se cumple crear(Su id es 0, por lo tanto es nuevo) { context.Entry(this).State = System.Data.Entity.EntityState.Added; //aƱadimos el producto } else//sino... { context.Entry(this).State = System.Data.Entity.EntityState.Modified;//modificamos el producto } context.SaveChanges(); //lo guardamos } catch (Exception e) { throw; } }