public async Task <VotableAttribute> AddOrUpdateAttribute(AddOrUpdateVotableAttributeRequest request, int userId, VotableAttributeType type) => await _attributes.ManageVote(request.AttributeId, userId, request.FoodId, type);
public async Task <Dictionary <int, IEnumerable <VotableAttribute> > > GetManyVotes(IEnumerable <int> foodIds, int userId, VotableAttributeType type)
{
var records = new Dictionary <int, IEnumerable <VotableAttribute> >();
foreach (var id in foodIds)
{
var votes = (await _mouthfeel.AttributeVotes.ToListAsync()).Where(m => m.FoodId == id);
var userVotes = votes.Where(v => v.UserId == userId);
var attributes = await GetAttributes(type);
var joined = attributes.Join(votes, attr => attr.Id, vote => vote.AttributeId, (attr, vote) =>
new VotableAttribute
{
Id = attr.Id,
Name = attr.Name,
Description = attr.Description,
Votes = votes.Where(v => v.AttributeId == attr.Id).Aggregate(0, (total, next) => total + next.Vote),
Sentiment = userVotes.FirstOrDefault(v => v.AttributeId == attr.Id)?.Vote ?? 0
}).DistinctBy(a => a.Id);
records.Add(id, joined);
}
return(records);
}
public async Task <IEnumerable <VotableAttribute> > GetVotes(int?foodId, int userId, VotableAttributeType type)
{
var votes = _mouthfeel.AttributeVotes.Where(m => m.FoodId == foodId).ToList();
var userVotes = votes.Where(v => v.UserId == userId).ToList();
var attributes = await GetAttributes(type);
return(attributes.Join(votes, attr => attr.Id, vote => vote.AttributeId, (attr, vote) =>
new VotableAttribute
{
Id = attr.Id,
Name = attr.Name,
Description = attr.Description,
Votes = votes.Where(v => v.AttributeId == attr.Id).Aggregate(0, (total, next) => total + next.Vote),
Sentiment = userVotes.FirstOrDefault(v => v.AttributeId == attr.Id)?.Vote ?? 0
}).DistinctBy(a => a.Id));
}
public async Task <IEnumerable <Attribute> > GetAttributes(VotableAttributeType type) => _mouthfeel.Attributes.Where(a => a.TypeId == (int)type);
public async Task <IEnumerable <Attribute> > SearchAttributes(string query, VotableAttributeType type) => (await GetAttributes(type)).Where(a => a.Name == query);
public async Task <VotableAttribute> ManageVote(int attributeId, int userId, int foodId, VotableAttributeType type)
{
var votes = (await _mouthfeel.AttributeVotes.ToListAsync()).Where(m => m.FoodId == foodId);
var attributes = await GetAttributes(type);
var foods = await _mouthfeel.Foods.ToListAsync();
if (!foods.Any(f => f.Id == foodId))
{
throw new ErrorResponse(HttpStatusCode.NotFound, ErrorMessages.FoodNotFound, DescriptiveErrorCodes.FoodNotFound);
}
if (!attributes.Any(f => f.Id == attributeId))
{
throw new ErrorResponse(HttpStatusCode.BadRequest, ErrorMessages.MiscellaneousDoesNotExist, DescriptiveErrorCodes.MiscellaneousDoesNotExist);
}
var existingVoteByUser = votes.FirstOrDefault(v => v.AttributeId == attributeId && v.FoodId == foodId && v.UserId == userId);
// Delete it, otherwise we'll have a bunch of 0 records clogging up the table
if (existingVoteByUser != null)
{
_mouthfeel.AttributeVotes.Remove(existingVoteByUser);
}
else
{
_mouthfeel.AttributeVotes.Add(new AttributeVote
{
AttributeId = attributeId,
UserId = userId,
FoodId = foodId,
Vote = 1
});
}
await _mouthfeel.SaveChangesAsync();
var votesForAttribute = (await GetVotes(foodId, userId, type)).FirstOrDefault(v => v.Id == attributeId).Votes;
return(new VotableAttribute
{
Id = attributeId,
Name = attributes.FirstOrDefault(a => a.Id == attributeId).Name,
Description = attributes.FirstOrDefault(a => a.Id == attributeId).Description,
Sentiment = existingVoteByUser != null ? 0 : 1,
Votes = votesForAttribute
});
}
