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