public IActionResult <IEnumerable <PizzasViewModel> > Menu(HttpSession session, HttpResponse response)
{
IEnumerable <PizzasViewModel> viewModel;
using (var context = new PizzaMoreDbContext())
{
viewModel = new List <PizzasViewModel>(context.Pizzas.Select(p => new PizzasViewModel()
{
Id = p.Id,
Title = p.Title,
Recipe = p.Recipe,
ImageUrl = p.ImageUrl,
UpVotes = p.UpVotes,
DownVotes = p.DownVotes
}));
if (UserService.HasSignedIn(session))
{
return(View(viewModel));
}
else
{
Redirect(response, "/home/signin");
}
}
return(null);
}
public static bool HasSignedIn(HttpSession session)
{
using (var context = new PizzaMoreDbContext())
{
if (context.Logins.Any(l => l.SessionId == session.Id && l.IsActive == true))
{
return(true);
}
return(false);
}
}
public static void SignOut(HttpSession session)
{
using (var context = new PizzaMoreDbContext())
{
foreach (var login in context.Logins.Where(l => l.IsActive == true && l.SessionId == session.Id))
{
login.IsActive = false;
}
context.SaveChanges();
}
}
public static void Vote(VoteBindingModel model)
{
using (var context = new PizzaMoreDbContext())
{
var pizzaToVote = context.Pizzas.Find(model.PizzaId);
if (model.Vote == -1)
{
pizzaToVote.DownVotes = model.Vote;
}
else
{
pizzaToVote.UpVotes = model.Vote;
}
context.SaveChanges();
}
}
public static void SignIn(UserBindingModel model, HttpSession session)
{
using (var context = new PizzaMoreDbContext())
{
var login = new Login()
{
SessionId = session.Id,
IsActive = true,
User = context.Users.FirstOrDefault(u => u.Email == model.Email && u.Password == model.Password)
};
if (login.User == null)
{
exists = false;
}
else
{
context.Logins.Add(login);
context.SaveChanges();
exists = true;
}
}
}
public static void SignUp(UserBindingModel model)
{
var user = new User()
{
Email = model.Email,
Password = model.Password
};
using (var context = new PizzaMoreDbContext())
{
if (context.Users.Any(u => u.Email == user.Email))
{
exists = true;
}
else
{
context.Users.Add(user);
context.SaveChanges();
exists = false;
}
}
}
