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