ENEI2019-Public/api/Data/EventLocsVisitedRepository.cs

using System;
using System.Threading.Tasks;
using api.Models;
using api.Data;
using Microsoft.EntityFrameworkCore;
using System.Collections.Generic;
using System.Linq;

namespace api.Data
{
    public class EventLocsVisitedRepository : IEventLocsVisitedRepository
    {
        public EventLocsVisitedRepository(DataContext context)
        {
            _context = context;
        }

        public DataContext _context { get; }

        public async Task<IEnumerable<EventLocVisited>> GetEventLocsVisited()
        {
            var rEventLocsVisitedList = await _context.EventLocsVisited.Include(e => e.Team).Include(e => e.Location).ToListAsync();

            return rEventLocsVisitedList;
        }

        public async Task<List<EventLocVisited>> GetEventLocsVisitedTeam(int id)
        {
            Team t= await _context.Teams.FirstOrDefaultAsync(team=>team.Id== id);

            List<EventLoc> allPlaces = await _context.EventLocs.Where(a=>a.EventId== t.EventId ).ToListAsync();

            List<EventLocVisited> allLocs = await _context.EventLocsVisited.Where(T=>T.Team.Id== id).Include(e => e.Team).Include(e => e.Location).ToListAsync();

            List<EventLocVisited> rList = new List<EventLocVisited>();

            for (int j = 0; j < allPlaces.Count; j++)
            {


                EventLocVisited novo=new EventLocVisited();

                novo.Location= allPlaces[j];
             
                novo.complete=false;

                for (var i = 0; i < allLocs.Count; i++)
                {   
                    if(allPlaces[j].Id == allLocs[i].Location.Id){
                        novo.complete=true;
                    }
                }


                rList.Add(novo);
            }

            return rList;
        }

        public async Task<List<EventLocVisited>> GetEventLocsVisitedEvent(int id)
        {
            List<EventLocVisited> allLocs = await _context.EventLocsVisited.Include(e => e.Team).Include(e => e.Location).ToListAsync();
            List<EventLocVisited> rList = new List<EventLocVisited>();
            for (var i = 0; i < allLocs.Count; i++)
            {
                if (allLocs[i].Location.EventId == id)
                {
                    rList.Add(allLocs[i]);
                }
            }
            return rList;
        }

    }
}