public static IList <RestaurantModel> GetRestaurants()
{
using (var ctx = new AgileContext())
{
return(ctx.Restaurants.ToList());
}
}
public static IList <IGrouping <RestaurantModel, VoteModel> > GetRestaurants(int sprint)
{
using (var ctx = new AgileContext())
{
var sprintVotesByRestaurant = ctx.Votes.Where(v => v.Sprint == sprint).GroupBy(v => v.Restaurant);
return(sprintVotesByRestaurant.OrderByDescending(v => v.Count()).ToList());
}
}
public static bool IsUserAllowed(string email)
{
using (var ctx = new AgileContext())
{
var x = ctx.AllowedUsers.ToList();
return(ctx.AllowedUsers.Any(a => a.Email == email.ToLower()));
}
}
public static ILookup <string, VoteModel> GetVotes(int sprint)
{
using (var ctx = new AgileContext())
{
return(ctx.Votes
.Where(v => v.Sprint == sprint)
.Include(v => v.Restaurant)
.ToLookup(v => v.Voter));
}
}
public static void SaveVotes(string voter, int sprint, VotingModel voting)
{
using (var ctx = new AgileContext())
{
var oldVotes = ctx.Votes.Where(v => v.Sprint == sprint && v.Voter == voter);
ctx.Votes.RemoveRange(oldVotes);
foreach (var v in voting.Votes.Where(vo => vo.IsVoted))
{
ctx.Votes.Add(new VoteModel(sprint, DateTime.Now, voter, ctx.Restaurants.Single(r => r.Id == v.RestaurantId)));
}
ctx.SaveChanges();
}
}