public Game Game_get_by_id(int acc_id)
{
using (Course_workContext db = new Course_workContext())
{
var Game = db.Games.FirstOrDefault(d => d.Id == acc_id);
return(Game);
}
}
public List <Player> player_print()
{
using (Course_workContext db = new Course_workContext())
{
var Players = db.Players.ToList();
return(Players);
}
}
public List <Game> game_sort_genre(string genre, int num)
{
using (Course_workContext db = new Course_workContext())
{
var ret = db.Games.OrderBy(m => m.Genre == genre).Take(num).ToList();
return(ret);
}
}
public List <Game> Game_print()
{
using (Course_workContext db = new Course_workContext())
{
var directors = db.Games.ToList();
return(directors);
}
}
public Player Player_get_by_id(int id)
{
using (Course_workContext db = new Course_workContext())
{
var Player = db.Players.Find(id);
return(Player);
}
}
public void game_Rating_add(GameRating char_Rating)
{
using (Course_workContext db = new Course_workContext())
{
db.GameRatings.Add(char_Rating);
db.SaveChanges();
}
}
public List <Rating> rating_print()
{
using (Course_workContext db = new Course_workContext())
{
var Ratings = db.Ratings.ToList();
return(Ratings);
}
}
public Rating Rating_get_by_id(int Rating_id)
{
using (Course_workContext db = new Course_workContext())
{
var Rating = db.Ratings.FirstOrDefault(a => a.Id == Rating_id);
return(Rating);
}
}
public List <Player> player_find_glob(double glob)
{
using (Course_workContext db = new Course_workContext())
{
var ret = db.Players.Where(m => m.Global == glob).ToList();
return(ret);
}
}
public List <Player> player_find_other(double ot)
{
using (Course_workContext db = new Course_workContext())
{
var ret = db.Players.Where(m => m.Other == ot).ToList();
return(ret);
}
}
public List <Player> player_find_jp(double jp)
{
using (Course_workContext db = new Course_workContext())
{
var ret = db.Players.Where(m => m.Jp == jp).ToList();
return(ret);
}
}
public List <Game> game_sort_year(int year, int num)
{
using (Course_workContext db = new Course_workContext())
{
var ret = db.Games.OrderBy(m => m.ReleaseYear == year).Take(num).ToList();
return(ret);
}
}
public List <Game> game_find_year(int year)
{
using (Course_workContext db = new Course_workContext())
{
var ret = db.Games.Where(m => m.ReleaseYear == year).ToList();
return(ret);
}
}
public List <Player> player_find_na(double na)
{
using (Course_workContext db = new Course_workContext())
{
var ret = db.Players.Where(m => m.Na == na).ToList();
return(ret);
}
}
public List <Player> player_find_eu(double eu)
{
using (Course_workContext db = new Course_workContext())
{
var ret = db.Players.Where(m => m.Eu == eu).ToList();
return(ret);
}
}
public List <Game> game_sort_dev(string dev, int num)
{
using (Course_workContext db = new Course_workContext())
{
var ret = db.Games.OrderBy(m => m.Developer == dev).Take(num).ToList();
return(ret);
}
}
public void Rating_edit(Rating Rating)
{
using (Course_workContext db = new Course_workContext())
{
var a = Rating_get_by_id(Rating.Id);
a = Rating;
db.SaveChanges();
}
}
public void Game_edit(Game acc)
{
using (Course_workContext db = new Course_workContext())
{
var d = Game_get_by_id(acc.Id);
d = acc;
db.SaveChanges();
}
}
public void Player_edit(Player char_)
{
using (Course_workContext db = new Course_workContext())
{
var m = Player_get_by_id(char_.Id);
m = char_;
db.SaveChanges();
}
}
public int Player_add(Player char_)
{
using (Course_workContext db = new Course_workContext())
{
db.Players.Add(char_);
db.SaveChanges();
var m = db.Players.Max(m => m.Id);
return(m);
}
}
public List <Game> game_find_genre(string genre)
{
using (Course_workContext db = new Course_workContext())
{
char symb = '%';
genre = symb + genre + symb;
var ret = db.Games.Where(m => EF.Functions.Like(m.Genre, genre)).ToList();
return(ret);
}
}
public int Game_add(Game acc)
{
using (Course_workContext db = new Course_workContext())
{
db.Games.Add(acc);
db.SaveChanges();
var d = db.Games.Max(d => d.Id);
return(d);
}
}
public int Rating_add(Rating Rating)
{
using (Course_workContext db = new Course_workContext())
{
db.Ratings.Add(Rating);
db.SaveChanges();
var a = db.Ratings.Max(a => a.Id);
return(a);
}
}
public List <Game> game_find_dev(string dev)
{
using (Course_workContext db = new Course_workContext())
{
char symb = '%';
dev = symb + dev + symb;
var ret = db.Games.Where(m => EF.Functions.Like(m.Developer, dev)).ToList();
return(ret);
}
}
public bool Player_delete(int char_id)
{
using (Course_workContext db = new Course_workContext())
{
var chara = Player_get_by_id(char_id);
if (chara == null)
{
return(false);
}
db.Players.Remove(chara);
db.SaveChanges();
return(true);
}
}
public bool game_Rating_delete(int l_id)
{
using (Course_workContext db = new Course_workContext())
{
var nom = db.GameRatings.FirstOrDefault(n => n.Id == l_id);
if (nom == null)
{
return(false);
}
db.GameRatings.Remove(nom);
db.SaveChanges();
return(true);
}
}
public bool Rating_delete(int i_id)
{
using (Course_workContext db = new Course_workContext())
{
var Rating = Rating_get_by_id(i_id);
if (Rating == null)
{
return(false);
}
db.Ratings.Remove(Rating);
db.SaveChanges();
return(true);
}
}
public bool Game_delete(int acc_id)
{
using (Course_workContext db = new Course_workContext())
{
var director = Game_get_by_id(acc_id);
if (director == null)
{
return(false);
}
db.Games.Remove(director);
db.SaveChanges();
return(true);
}
}
public string game_plat_get_by_id(int l_id)
{
using (Course_workContext db = new Course_workContext())
{
var ret = db.Games.FirstOrDefault(n => n.Id == l_id);
string char_Ratings = "";
if (ret != null)
{
char_Ratings += ret.Id.ToString();
char_Ratings += ". Name: ";
char_Ratings += ret.Name;
char_Ratings += ". <-----> Platform: ";
char_Ratings += ret.Platform;
char_Ratings += '\n';
}
return(char_Ratings);
}
}
public string game_sort_rating(string genre, int num)
{
using (Course_workContext db = new Course_workContext())
{
var ret = db.GameRatings.Include(m => m.Game).Include(a => a.Rating).OrderByDescending(r => r.Rating.User).ToList();
string movie = "";
if (ret == null)
{
return(movie);
}
foreach (var r in ret)
{
movie += "Rating: ";
movie += r.Rating.User.ToString();
movie += " Name: ";
movie += r.Game.Name;
movie += "\n";
}
return(movie);
}
}
