Blame view

src/MapsDb/DataService/ServiceObjectDs.cs 3.95 KB
27918c1f   Administrator   add service object
1
2
3
4
5
6
  using System.Collections.Generic;
  using System.Linq;
  using System.Threading.Tasks;
  using MapsDb.Interfaces;
  using MapsDb.Models;
  using MapsModels.DsModels;
25539461   Administrator   add pagination to...
7
  using System.Reflection;
27918c1f   Administrator   add service object
8
9
10
11
12
13
14
15
16
  using Microsoft.EntityFrameworkCore;
  namespace MapsDb.DataService
  {
      public class ServiceObjectDs : IServiceObjectDs
      {
          private PostgresDbContext _context;
          public ServiceObjectDs(){
              _context = new PostgresDbContext();
          }
25539461   Administrator   add pagination to...
17
18
          public Task<IList<ServiceObjectEditDsM>> GetIndexListAsync(PaginationDsM pagination){
              return Task.Factory.StartNew(()=> { return GetAllServiceObject(pagination); });
27918c1f   Administrator   add service object
19
          }
25539461   Administrator   add pagination to...
20
          private IList<ServiceObjectEditDsM> GetAllServiceObject(PaginationDsM pagination)
27918c1f   Administrator   add service object
21
          {
25539461   Administrator   add pagination to...
22
              var data =  _context.ServiceObject.Select(ServiceObject => new ServiceObjectEditDsM
27918c1f   Administrator   add service object
23
              {
24f8b1af   Administrator   add RoadSurface
24
                  Id = ServiceObject.Id,
27918c1f   Administrator   add service object
25
26
27
28
29
30
31
32
33
34
35
                  RoadId = ServiceObject.RoadId,
                  RegionId = ServiceObject.RegionId,
                  SettlementId = ServiceObject.SettlementId,
                  LocationLeft = ServiceObject.LocationLeft,
                  LocationRight = ServiceObject.LocationRight,
                  ServiceObjectTypeId = ServiceObject.ServiceObjectTypeId,
                  DepartmentAffiliationId = ServiceObject.DepartmentAffiliationId,
                  LocationAxis = ServiceObject.LocationAxis,
                  Distance = ServiceObject.Distance,
                  Capacity = ServiceObject.Capacity,
                  ArrangementElements = ServiceObject.ArrangementElements,
25539461   Administrator   add pagination to...
36
37
38
39
40
41
42
43
44
45
46
47
                }).Skip(pagination.from).Take(pagination.perPage);
              switch (pagination.orderType())
              {
                  case "ASC":
                      return data.OrderBy(i => i.GetType().GetProperty(pagination.sort).GetValue(i, null)).ToList();
            
                  case "DESC":
                      return data.OrderByDescending(i => i.GetType().GetProperty(pagination.sort).GetValue(i, null)).ToList();
              
                  default:
                      return data.OrderByDescending(i => i.Id).ToList();
              }   
27918c1f   Administrator   add service object
48
49
          }
  
e02ee314   Administrator   add update and cr...
50
51
          public Task<ServiceObject> CreateAsync(ServiceObjectEditDsM data){
              return Task.Factory.StartNew(()=> { return Create(data); });
27918c1f   Administrator   add service object
52
          }
e02ee314   Administrator   add update and cr...
53
          private ServiceObject Create(ServiceObjectEditDsM data)
27918c1f   Administrator   add service object
54
          {   
e02ee314   Administrator   add update and cr...
55
56
              ServiceObject Model = InsertModel(data);
              _context.ServiceObject.Add(Model);
27918c1f   Administrator   add service object
57
              _context.SaveChanges();
e02ee314   Administrator   add update and cr...
58
59
60
61
62
63
64
65
              return Model;
          }
          public Task<ServiceObject> UpdateAsync(ServiceObjectEditDsM data, int id){
              return Task.Factory.StartNew(()=> { return Update(data, id); });
          }
          private ServiceObject Update(ServiceObjectEditDsM data, int id)
          {   
              ServiceObject Model = InsertModel(data);
25539461   Administrator   add pagination to...
66
              Model.Id = id;
e02ee314   Administrator   add update and cr...
67
68
69
70
71
72
              _context.ServiceObject.Update(Model);
              _context.SaveChanges();
              return Model;
          }
          public ServiceObject InsertModel(ServiceObjectEditDsM data){
           ServiceObject Model = new ServiceObject{
24f8b1af   Administrator   add RoadSurface
73
                  Id = data.Id,
e02ee314   Administrator   add update and cr...
74
75
76
77
78
79
80
81
82
83
84
85
86
                  RoadId = data.RoadId,
                  RegionId = data.RegionId,
                  SettlementId = data.SettlementId,
                  LocationLeft = data.LocationLeft,
                  LocationRight = data.LocationRight,
                  ServiceObjectTypeId = data.ServiceObjectTypeId,
                  DepartmentAffiliationId = data.DepartmentAffiliationId,
                  LocationAxis = data.LocationAxis,
                  Distance = data.Distance,
                  Capacity = data.Capacity,
                  ArrangementElements = data.ArrangementElements,
              };
              return Model;
27918c1f   Administrator   add service object
87
          }
e02ee314   Administrator   add update and cr...
88
          public async Task<int> DeleteAsync(int Id)
27918c1f   Administrator   add service object
89
          {
25539461   Administrator   add pagination to...
90
              var ServiceObject = await _context.ServiceObject.SingleOrDefaultAsync(x => x.Id == Id);
27918c1f   Administrator   add service object
91
92
93
94
95
              _context.ServiceObject.Remove(ServiceObject);
              return await _context.SaveChangesAsync();
          }
      }
  }