public IEnumerable <Games> GetGamesByGenre(int GenresId)
{
List <Games> Games;
using (GameStoriesEntities db = new GameStoriesEntities())
{
Games = db.Games.Where(i => i.GenreId == GenresId).ToList();
}
return(Games);
}
public Games GetByName(string name)
{
Games result;
using (GameStoriesEntities db = new GameStoriesEntities())
{
result = db.Games.Where(i => i.Name == name).FirstOrDefault();
}
return(result);
}
public IEnumerable <Games> GetAll()
{
List <Games> games;
using (GameStoriesEntities db = new GameStoriesEntities())
{
games = db.Games.ToList();
}
return(games);
}
public Games GetById(int id)
{
Games result;
using (GameStoriesEntities db = new GameStoriesEntities())
{
result = db.Games.Where(i => i.Id == id).FirstOrDefault();
}
return(result);
}
public IEnumerable <Games> GetGamesByPublisher(int PublishersId)
{
List <Games> Games;
using (GameStoriesEntities db = new GameStoriesEntities())
{
Games = db.Games.Where(i => i.PublicherId == PublishersId).ToList();
}
return(Games);
}
public Games GetByNameYearPublishing(Games Games)
{
Games result;
using (GameStoriesEntities db = new GameStoriesEntities())
{
result = db.Games.Where(i => i.Name == Games.Name).ToList().Where(x => x.YearPublishing == Games.YearPublishing).FirstOrDefault();
}
return(result);
}
public Publishers GetByName(string name)
{
Publishers publishers;
using (GameStoriesEntities db = new GameStoriesEntities())
{
publishers = db.Publishers.Where(i => i.Name == name).FirstOrDefault();
}
return(publishers);
}
public IEnumerable <Publishers> GetAll()
{
List <Publishers> publishers;
using (GameStoriesEntities db = new GameStoriesEntities())
{
publishers = db.Publishers.ToList();
}
return(publishers);
}
public Genres GetByName(string name)
{
Genres genres;
using (GameStoriesEntities db = new GameStoriesEntities())
{
genres = db.Genres.Where(i => i.Name == name).FirstOrDefault();
}
return(genres);
}
public int Delete(Games model)
{
int result;
using (GameStoriesEntities db = new GameStoriesEntities())
{
db.Entry(model).State = System.Data.Entity.EntityState.Deleted;
result = db.SaveChanges();
}
return(result);
}
public int Create(Games model)
{
Games games;
int res;
using (GameStoriesEntities sqlConnection = new GameStoriesEntities())
{
games = sqlConnection.Games.Add(model);
res = sqlConnection.SaveChanges();
}
return(res == 0 ? 0 : games.Id);
}
public int Create(Publishers model)
{
Publishers publishers;
int res;
using (GameStoriesEntities sqlConnection = new GameStoriesEntities())
{
publishers = sqlConnection.Publishers.Add(model);
res = sqlConnection.SaveChanges();
}
return(res == 0 ? 0 : publishers.Id);
}
public int Update(Games model)
{
int result;
using (GameStoriesEntities db = new GameStoriesEntities())
{
Games games = db.Games.Where(i => i.Id == model.Id).FirstOrDefault();
if (games == null)
{
return(0);
}
games = model;
result = db.SaveChanges();
}
return(result);
}
public int Update(Publishers model)
{
int result;
using (GameStoriesEntities db = new GameStoriesEntities())
{
Publishers publisher = db.Publishers.Where(i => i.Id == model.Id).FirstOrDefault();
if (publisher == null)
{
return(0);
}
publisher = model;
result = db.SaveChanges();
}
return(result);
}