public List <Topic> List() { using (var db = new PeriodicalDbContext()) { return(db.Topics.Include(e => e.Editions).ToList()); } }
public List <Review> List() { using (var db = new PeriodicalDbContext()) { return(db.Reviews.Include(e => e.Edition).ToList()); } }
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 Topic GetByName(string topicName) { using (var db = new PeriodicalDbContext()) { var result = (from topic in db.Topics where topic.TopicName == topicName select topic) .Include(e => e.Editions).FirstOrDefault(); return(result); } }
public List <Edition> List() { using (var db = new PeriodicalDbContext()) { return(db.Editions.Include(e => e.Reviews) .Include(e => e.Topic) .Include(e => e.Subscribers).ToList()); } }
public Review GetById(int id) { using (var db = new PeriodicalDbContext()) { var result = (from review in db.Reviews where review.Id == id select review) .Include(e => e.Edition).FirstOrDefault(); return(result); } }
public Topic GetById(int id) { using (var db = new PeriodicalDbContext()) { var result = (from topic in db.Topics where topic.Id == id select topic) .Include(e => e.Editions).FirstOrDefault(); return(result); } }
public ApplicationUser GetById(string userId) { using (var db = new PeriodicalDbContext()) { var result = (from user in db.Users where user.Id == userId select user) .Include(e => e.Subscription).Include(e => e.Roles) .FirstOrDefault(); return(result); } }
public Edition GetById(int id) { using (var db = new PeriodicalDbContext()) { var result = (from edition in db.Editions where edition.Id == id select edition) .Include(e => e.Reviews) .Include(e => e.Topic) .Include(e => e.Subscribers).FirstOrDefault(); return(result); } }
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 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); } }
// GET: Admin/Admin public ActionResult Administration() { List <UserModel> users; using (var db = new PeriodicalDbContext()) { var userList = db.Users.ToList(); var admin = db.Users.First(adm => adm.UserName == "admin"); userList.Remove(admin); users = UserModel.FromUserList(userList); } return(View(users)); }
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 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 ActionResult SearchUser(string search) { List <UserModel> users; using (var db = new PeriodicalDbContext()) { var userList = db.Users.Where(user => user.UserName.Contains(search)).ToList(); var admin = db.Users.First(adm => adm.UserName == "admin"); if (admin != null) { userList.Remove(admin); } users = UserModel.FromUserList(userList); } return(PartialView("_SearchUser", users)); }
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); } } }
public EfRepository(PeriodicalDbContext dbContext) { _dbContext = dbContext; }