using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using MapsDb.Interfaces;
using MapsDb.Models;
using MapsModels.DsModels;
using Microsoft.EntityFrameworkCore;

namespace MapsDb.DataService
{
    public class BusStopDs : IBusStopDs
    {
        private PostgresDbContext _context;
        public BusStopDs(){
            _context = new PostgresDbContext();
        }
        public Task<IList<BusStopListDsM>> GetIndexListAsync(){
            return Task.Factory.StartNew(GetAllBusStop);
        }
        private IList<BusStopListDsM> GetAllBusStop()
        {
           return _context.BusStop.Select(x => new BusStopListDsM
            {
                Road = x.Road.Name, 
                Region = x.Region.Name,
                Settlement = x.Settlement.Name,
                LocationLeft = x.LocationLeft,
                LocationRight = x.LocationRight,
                StateCommon = x.StateCommon.Value
            }).ToList();
        }

        public Task SaveAsync(BusStop busStop){
              return Task.Factory.StartNew(()=> { Save(busStop); });
        }
        private void Save(BusStop busStop)
        {
            var busStopFromDb = _context.BusStop.SingleOrDefault(x => x.BusStopId == busStop.BusStopId);;
            if(busStopFromDb != null)
            {
                busStopFromDb = busStop;
            }
            else
            {
                _context.BusStop.Add(busStop);
            }
        }
        public Task<BusStopDetailsDsM> FindOneDetailsAsync(int Id){
             return Task.Factory.StartNew(()=> { return FindOneDetails(Id); });
        }
        private BusStopDetailsDsM FindOneDetails(int Id){
           return _context.BusStop.Where(x => x.BusStopId == Id).Select(x => new BusStopDetailsDsM{
                BusStopId = x.BusStopId,
                Road = x.Road.Name, 
                Region = x.Region.Name,
                Settlement = x.Settlement.Name,
                LocationLeft = x.LocationLeft,
                LocationRight = x.LocationRight,
                StateCommon = x.StateCommon.Value,
                AreaStopAvailability = x.AreaStopAvailability,
                AreaLandAvailability = x.AreaLandAvailability,
                PocketAvailability = x.PocketAvailability,
                ToiletAvailability = x.ToiletAvailability,
                YearBuild = x.YearBuild,
                YearRepair = x.YearRepair
           }).Single();
        }
        public async Task<int> DeleteAsync(int? Id)
        {
            var busStop = await _context.BusStop.SingleOrDefaultAsync(x => x.BusStopId == Id);
            _context.BusStop.Remove(busStop);
            return await _context.SaveChangesAsync();
        }
    }
}