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