public T Add(T entity) { _dbContext.Set <T>().Add(entity); _dbContext.SaveChanges(); return(entity); }
public void Update(Review entity) { using (var db = new PeriodicalDbContext()) { db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); } }
public Topic Add(Topic entity) { using (var db = new PeriodicalDbContext()) { db.Topics.Add(entity); db.SaveChanges(); return(entity); } }
public void Delete(int entityId) { using (var db = new PeriodicalDbContext()) { var entity = db.Reviews.Find(entityId); if (entity != null) { db.Reviews.Remove(entity); db.SaveChanges(); } } }
public Review Add(Review entity) { using (var db = new PeriodicalDbContext()) { var edition = db.Editions.Find(entity.EditionId); if (edition != null) { edition.Reviews.Add(entity); db.SaveChanges(); } } return(entity); }
public bool TopUp(string userId, float amount) { using (var db = new PeriodicalDbContext()) { var user = (from user1 in db.Users where user1.Id == userId select user1).FirstOrDefault(); if (user != null) { user.Credit += amount; } db.SaveChanges(); return(true); } }
public ActionResult BlockUser(string userId) { using (var db = new PeriodicalDbContext()) { var user = db.Users.Find(userId); user.LockoutEnabled = !user.LockoutEnabled; db.SaveChanges(); if (user.LockoutEnabled) { user.LockoutEndDateUtc = DateTime.UtcNow.AddMinutes(5); } } return(RedirectToAction("Administration")); }
public bool RemoveSubscription(string userId, int editionId) { using (var db = new PeriodicalDbContext()) { var resultUser = (from user in db.Users where user.Id == userId select user) .Include(e => e.Subscription).FirstOrDefault(); var resultEdition = (from edition in db.Editions where edition.Id == editionId select edition) .Include(e => e.Subscribers).FirstOrDefault(); if (resultUser != null && resultUser.Subscription.Contains(resultEdition)) { resultUser.Subscription.Remove(resultEdition); //editionDb?.Subscribers.Remove(user); } db.SaveChanges(); return(true); } }
public Edition Add(Edition entity) { using (var db = new PeriodicalDbContext()) { var topic = db.Topics.FirstOrDefault(t => t.TopicName == entity.Topic.TopicName); if (topic == null) { topic = new Topic() { TopicName = entity.Topic.TopicName }; db.Topics.Add(topic); } entity.Topic = topic; db.Editions.Add(entity); db.SaveChanges(); } return(entity); }
public bool AddSubscription(string userId, int editionId) { using (var db = new PeriodicalDbContext()) { var resultUser = (from user in db.Users where user.Id == userId select user) .Include(e => e.Subscription).FirstOrDefault(); var resultEdition = (from edition in db.Editions where edition.Id == editionId select edition) .Include(e => e.Subscribers).FirstOrDefault(); if (resultEdition != null && resultUser != null && resultUser.Credit >= resultEdition.Price) { resultUser.Credit -= resultEdition.Price; resultUser.Subscription.Add(resultEdition); db.SaveChanges(); return(true); } else { return(false); } } }