Administrator / FirstFullmaps

  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<BusStopEditDsM>> GetIndexListAsync(){

              return Task.Factory.StartNew(GetAllBusStop);
          }

          private IList<BusStopEditDsM> GetAllBusStop()

          {

             return _context.BusStop.Select(busStop => new BusStopEditDsM

              {

                  BusStopId = busStop.BusStopId,
                  RoadId = busStop.RoadId,

                  RegionId = busStop.RegionId,
                  SettlementId = busStop.SettlementId,
                  LocationLeft = busStop.LocationLeft,
                  LocationRight = busStop.LocationRight,
                  SurfaceTypeId = busStop.SurfaceTypeId,
                  AreaStopAvailability = busStop.AreaStopAvailability,
                  AreaLandAvailability = busStop.AreaLandAvailability,
                  PocketAvailability = busStop.PocketAvailability,
                  ToiletAvailability = busStop.ToiletAvailability,
                  YearBuild = busStop.YearBuild,
                  YearRepair = busStop.YearRepair,
                  StateCommonId = busStop.StateCommonId

              }).OrderByDescending(BusStop => BusStop.BusStopId).ToList();

          }
  

          public Task<BusStop> CreateAsync(BusStopEditDsM data){
                return Task.Factory.StartNew(()=> { return Create(data); });

          }

          private BusStop Create(BusStopEditDsM data)

          {   

              
              BusStop Model = InsertModel(data);
              _context.BusStop.Add(Model);

              _context.SaveChanges();

              return Model;
          }
          public Task<BusStop> UpdateAsync(BusStopEditDsM data, int id){
              return Task.Factory.StartNew(()=> { return Update(data, id); });
          }
          private BusStop Update(BusStopEditDsM data, int id)
          {   
              BusStop Model = InsertModel(data);
              Model.BusStopId = id;
              _context.BusStop.Update(Model);
              _context.SaveChanges();
              return Model;
          }
          public BusStop InsertModel(BusStopEditDsM data){
              BusStop Model = new BusStop{
                  RoadId = data.RoadId,
                  RegionId = data.RegionId,
                  SettlementId = data.SettlementId,
                  LocationLeft = data.LocationLeft,
                  LocationRight = data.LocationRight,
                  SurfaceTypeId = data.SurfaceTypeId,
                  AreaStopAvailability = data.AreaStopAvailability,
                  AreaLandAvailability = data.AreaLandAvailability,
                  PocketAvailability = data.PocketAvailability,
                  ToiletAvailability = data.ToiletAvailability,
                  YearBuild = data.YearBuild,
                  YearRepair = data.YearRepair,
                  StateCommonId = data.StateCommonId
              };
              return Model;

          }

          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();
          }

      }
  }