FacilityService.cs 6.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155
  1. using System;
  2. using System.Collections.Generic;
  3. using System.IdentityModel.Tokens.Jwt;
  4. using System.Linq;
  5. using System.Security.Claims;
  6. using System.Text;
  7. using FMSAdmin.Data;
  8. using FMSAdmin.Helpers;
  9. using FMSAdmin.Entities;
  10. using Microsoft.EntityFrameworkCore;
  11. using Microsoft.Extensions.Logging;
  12. using Microsoft.Extensions.Options;
  13. using Microsoft.IdentityModel.Tokens;
  14. using FMSAdmin.Models;
  15. using System.Transactions;
  16. namespace FMSApp.Services {
  17. public class FacilityService {
  18. private readonly ILogger<FacilityService> _logger;
  19. private readonly FMSContext _context;
  20. private readonly AppSettings _appSettings;
  21. private readonly StorageHelper _storage;
  22. public FacilityService(
  23. ILogger<FacilityService> logger,
  24. FMSContext context,
  25. IOptions<AppSettings> appSettings,
  26. StorageHelper storage
  27. ) {
  28. _logger = logger;
  29. _context = context;
  30. _appSettings = appSettings.Value;
  31. _storage = storage;
  32. }
  33. public void Save(CmFacility data) {
  34. using (var trans = new TransactionScope()) {
  35. var persist = _context.CmFacility
  36. .Where(x => x.SiteId == data.SiteId
  37. && x.FacilityCode == data.FacilityCode).FirstOrDefault();
  38. if (persist == null) {
  39. var check = _context.CmFacility.Where(x => x.SiteId == data.SiteId
  40. && x.FacilityCode == data.FacilityCode).Count();
  41. if (check > 0) {
  42. throw new ServiceException("아이디가 중복됩니다.");
  43. }
  44. if (data.CmFile != null && data.CmFile.IsUpload) {
  45. data.CmFile.SiteId = data.SiteId;
  46. var category = _context.CmFileCategory.First(x => x.Name == "facility");
  47. data.CmFile.FileCategory = category;
  48. data.CmFile.CreatedDate = DateTime.Now;
  49. } else {
  50. data.CmFile = null;
  51. }
  52. // 첫번째 유형으로 넣음
  53. //data.FacilityTypeId = _context.BemsFacilityType.Where(x => x.FacilityTypeId < 99).OrderBy(x => x.FacilityTypeId).Select(x => x.FacilityTypeId).FirstOrDefault();
  54. if (data.FacilityTypeId >= 99) {
  55. data.IsVirtualFacility = true;
  56. }
  57. data.Rfid = data.Rfid.Trim();
  58. _context.CmFacility.Add(data);
  59. _context.SaveChanges();
  60. if (data.CmFile != null && data.CmFile.IsUpload) {
  61. // 카피
  62. _storage.CopyEntity(data.CmFile.Path, data.CmFile);
  63. }
  64. } else {
  65. if (data.CmFile != null && data.CmFile.IsDelete) {
  66. persist.CmFile = null;
  67. persist.FileId = null;
  68. } else if (data.CmFile != null && data.CmFile.IsUpload) {
  69. var category = _context.CmFileCategory.First(x => x.Name == "facility");
  70. persist.CmFile = new CmFile {
  71. SiteId = data.SiteId,
  72. FileCategory = category,
  73. CreatedDate = DateTime.Now,
  74. Name = data.CmFile.Name,
  75. FileSize = data.CmFile.FileSize,
  76. ContentType = data.CmFile.ContentType,
  77. };
  78. }
  79. if (data.FacilityTypeId >= 99) {
  80. persist.IsVirtualFacility = true;
  81. }
  82. persist.FacilityTypeId = data.FacilityTypeId;
  83. persist.DeviceType = data.DeviceType;
  84. persist.Name = data.Name;
  85. persist.Nickname = data.Nickname;
  86. persist.FacilityUsage = data.FacilityUsage;
  87. persist.IsUse = data.IsUse;
  88. persist.FirstClassId = data.FirstClassId;
  89. persist.SecondClassId = data.SecondClassId;
  90. persist.ThirdClassId = data.ThirdClassId;
  91. persist.FacilityCapacity = data.FacilityCapacity;
  92. persist.Rfid = data.Rfid.Trim();
  93. persist.RatedPowerConsumption = data.RatedPowerConsumption;
  94. persist.RatedCop = data.RatedCop;
  95. persist.Manufacturer = data.Manufacturer;
  96. persist.ManufactureDate = data.ManufactureDate;
  97. persist.ManufactureSerial = data.ManufactureSerial;
  98. persist.ManufactureModel = data.ManufactureModel;
  99. persist.Supplier = data.Supplier;
  100. persist.SupplierPhoneNo = data.SupplierPhoneNo;
  101. persist.BuildingId = data.BuildingId;
  102. persist.FloorId = data.FloorId;
  103. persist.ZoneId = data.ZoneId;
  104. persist.InstallDate = data.InstallDate;
  105. persist.OperationStartDate = data.OperationStartDate;
  106. persist.MainContactorUserId = data.MainContactorUserId;
  107. persist.SubContactorUserId = data.SubContactorUserId;
  108. persist.FacilityCost = data.FacilityCost;
  109. persist.FacilityCount = data.FacilityCount;
  110. persist.FuelTypeId = data.FuelTypeId;
  111. persist.ContractType = data.ContractType;
  112. persist.Note = data.Note;
  113. persist.Multiple = data.Multiple;
  114. _context.CmFacility.Update(persist);
  115. _context.SaveChanges();
  116. if (data.CmFile != null && data.CmFile.IsUpload) {
  117. // 카피
  118. _storage.CopyEntity(data.CmFile.Path, persist.CmFile);
  119. if (persist.CmFile != null) {
  120. // 파일 삭제시 진짜 DB삭제?
  121. }
  122. }
  123. }
  124. trans.Complete();
  125. }
  126. }
  127. public void Delete(int siteId, int facilityCode) {
  128. var data = _context.CmFacility.First(x => x.SiteId == siteId && x.FacilityCode == facilityCode);
  129. _context.CmFacility.Remove(data);
  130. _context.SaveChanges();
  131. }
  132. public IQueryable<CmFacility> GetAll() {
  133. var query = _context.CmFacility;
  134. return query;
  135. }
  136. }
  137. }