OrganizationChartStatusService.cs 5.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131
  1. using System;
  2. using System.Linq;
  3. using FMSAdmin.Data;
  4. using FMSAdmin.Entities;
  5. using FMSAdmin.Helpers;
  6. using Microsoft.Extensions.Logging;
  7. namespace FMSAdmin.Services {
  8. public class OrganizationChartStatusService {
  9. private readonly ILogger<OrganizationChartStatusService> _logger;
  10. private readonly FMSContext _context;
  11. private readonly StorageHelper _storage;
  12. public OrganizationChartStatusService(
  13. ILogger<OrganizationChartStatusService> logger,
  14. FMSContext context,
  15. StorageHelper storage) {
  16. _logger = logger;
  17. _context = context;
  18. _storage = storage;
  19. }
  20. public void Create(CmOrganizationChartStatus data) {
  21. using (var transaction = _context.Database.BeginTransaction()) {
  22. checkName(data);
  23. if (data.CmFile != null && data.CmFile.IsUpload) {
  24. var category = _context.CmFileCategory.First(x => x.Name == "organizationChartStatus");
  25. data.CmFile.SiteId = data.SiteId;
  26. data.CmFile.FileCategory = category;
  27. data.CmFile.CreatedDate = DateTime.Now;
  28. } else {
  29. data.CmFile = null;
  30. }
  31. if (data.CmFile2 != null && data.CmFile2.IsUpload) {
  32. var category = _context.CmFileCategory.First(x => x.Name == "organizationChartStatus");
  33. data.CmFile2.SiteId = data.SiteId;
  34. data.CmFile2.FileCategory = category;
  35. data.CmFile2.CreatedDate = DateTime.Now;
  36. } else {
  37. data.CmFile2 = null;
  38. }
  39. data.AddDate = DateTime.Now;
  40. _context.CmOrganizationChartStatus.Add(data);
  41. _context.SaveChanges();
  42. if (data.CmFile != null && data.CmFile.IsUpload) {
  43. _storage.CopyEntity(data.CmFile.Path, data.CmFile);
  44. _storage.PdfConvertImage(data.CmFile);
  45. }
  46. if (data.CmFile2 != null && data.CmFile2.IsUpload) {
  47. _storage.CopyEntity(data.CmFile2.Path, data.CmFile2);
  48. }
  49. transaction.Commit();
  50. }
  51. }
  52. public int checkName(CmOrganizationChartStatus data) {
  53. var check = _context.CmOrganizationChartStatus.Where(x => x.SiteId == data.SiteId && x.Month == data.Month && x.Year == data.Year).Count();
  54. if (check > 0) {
  55. throw new ServiceException(data.Year + "년 " + data.Month + "월 정보가 이미 존재합니다.");
  56. }
  57. return check;
  58. }
  59. public void Edit(int id, int siteId, CmOrganizationChartStatus data) {
  60. using (var transaction = _context.Database.BeginTransaction()) {
  61. var persist = _context.CmOrganizationChartStatus
  62. .Where(x => x.OrganizationChartStatusId == id && x.SiteId == siteId).FirstOrDefault();
  63. if (persist == null) {
  64. throw new ServiceException("정보를 찾을 수 없습니다.");
  65. }
  66. if (!persist.Year.Equals(data.Year) && !persist.Month.Equals(data.Month))
  67. checkName(data);
  68. if (data.CmFile != null && data.CmFile.IsUpload) {
  69. var category = _context.CmFileCategory.First(x => x.Name == "organizationChartStatus");
  70. data.CmFile.SiteId = data.SiteId;
  71. data.CmFile.FileCategory = category;
  72. data.CmFile.CreatedDate = DateTime.Now;
  73. persist.CmFile = data.CmFile;
  74. }
  75. if (data.CmFile2 != null && data.CmFile2.IsUpload) {
  76. var category = _context.CmFileCategory.First(x => x.Name == "organizationChartStatus");
  77. data.CmFile2.SiteId = data.SiteId;
  78. data.CmFile2.FileCategory = category;
  79. data.CmFile2.CreatedDate = DateTime.Now;
  80. persist.CmFile2 = data.CmFile2;
  81. }
  82. if (data.CmFile2 != null && data.CmFile2.IsDelete) {
  83. persist.CmFile2 = null;
  84. persist.FileId2 = null;
  85. }
  86. persist.Year = data.Year;
  87. persist.Month = data.Month;
  88. persist.SiteId = data.SiteId;
  89. persist.UpdateDate = DateTime.Now;
  90. _context.CmOrganizationChartStatus.Update(persist);
  91. _context.SaveChanges();
  92. if (data.CmFile != null && data.CmFile.IsUpload) {
  93. _storage.CopyEntity(data.CmFile.Path, persist.CmFile);
  94. _storage.PdfConvertImage(data.CmFile);
  95. }
  96. if (data.CmFile2 != null && data.CmFile2.IsUpload) {
  97. _storage.CopyEntity(data.CmFile2.Path, persist.CmFile2);
  98. }
  99. transaction.Commit();
  100. }
  101. }
  102. public void Delete(int id, int siteId) {
  103. var data = _context.CmOrganizationChartStatus.First(x => x.OrganizationChartStatusId == id && x.SiteId == siteId);
  104. _context.CmOrganizationChartStatus.Remove(data);
  105. _context.SaveChanges();
  106. }
  107. public IQueryable<CmOrganizationChartStatus> GetAll() {
  108. var query = _context.CmOrganizationChartStatus;
  109. return query;
  110. }
  111. public IQueryable<CmOrganizationChartStatus> Get(int id, int siteId) {
  112. var data = _context.CmOrganizationChartStatus.Where(x => x.OrganizationChartStatusId == id && x.SiteId == siteId);
  113. return data;
  114. }
  115. }
  116. }