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