AccidentService.cs 8.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205
  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 AccidentService {
  9. private readonly ILogger<AccidentService> _logger;
  10. private readonly FMSContext _context;
  11. private readonly StorageHelper _storage;
  12. public AccidentService(
  13. ILogger<AccidentService> logger,
  14. FMSContext context,
  15. StorageHelper storage) {
  16. _logger = logger;
  17. _context = context;
  18. _storage = storage;
  19. }
  20. public void Create(FmsAccident data) {
  21. using (var transaction = _context.Database.BeginTransaction()) {
  22. if (data.CmFile1 != null && data.CmFile1.IsUpload) {
  23. var category = _context.CmFileCategory.First(x => x.Name == "accident");
  24. data.CmFile1.SiteId = data.SiteId;
  25. data.CmFile1.FileCategory = category;
  26. data.CmFile1.CreatedDate = DateTime.Now;
  27. } else {
  28. data.CmFile1 = null;
  29. }
  30. if (data.CmFile2 != null && data.CmFile2.IsUpload) {
  31. var category = _context.CmFileCategory.First(x => x.Name == "accident");
  32. data.CmFile2.SiteId = data.SiteId;
  33. data.CmFile2.FileCategory = category;
  34. data.CmFile2.CreatedDate = DateTime.Now;
  35. } else {
  36. data.CmFile2 = null;
  37. }
  38. if (data.CmFile3 != null && data.CmFile3.IsUpload) {
  39. var category = _context.CmFileCategory.First(x => x.Name == "accident");
  40. data.CmFile3.SiteId = data.SiteId;
  41. data.CmFile3.FileCategory = category;
  42. data.CmFile3.CreatedDate = DateTime.Now;
  43. } else {
  44. data.CmFile3 = null;
  45. }
  46. if (data.CmFile4 != null && data.CmFile4.IsUpload) {
  47. var category = _context.CmFileCategory.First(x => x.Name == "accident");
  48. data.CmFile4.SiteId = data.SiteId;
  49. data.CmFile4.FileCategory = category;
  50. data.CmFile4.CreatedDate = DateTime.Now;
  51. } else {
  52. data.CmFile4 = null;
  53. }
  54. _context.FmsAccident.Add(data);
  55. _context.SaveChanges();
  56. if (data.CmFile1 != null && data.CmFile1.IsUpload) {
  57. // 카피
  58. _storage.CopyEntity(data.CmFile1.Path, data.CmFile1);
  59. }
  60. if (data.CmFile2 != null && data.CmFile2.IsUpload) {
  61. // 카피
  62. _storage.CopyEntity(data.CmFile2.Path, data.CmFile2);
  63. }
  64. if (data.CmFile3 != null && data.CmFile3.IsUpload) {
  65. // 카피
  66. _storage.CopyEntity(data.CmFile3.Path, data.CmFile3);
  67. }
  68. if (data.CmFile4 != null && data.CmFile4.IsUpload) {
  69. // 카피
  70. _storage.CopyEntity(data.CmFile4.Path, data.CmFile4);
  71. }
  72. transaction.Commit();
  73. }
  74. }
  75. public void Edit(int id, int siteId, FmsAccident data) {
  76. using (var transaction = _context.Database.BeginTransaction()) {
  77. var persist = _context.FmsAccident
  78. .Where(x => x.AccidentId == id && x.SiteId == siteId).FirstOrDefault();
  79. if (persist == null) {
  80. throw new ServiceException("정보를 찾을 수 없습니다.");
  81. }
  82. if (data.CmFile1 != null && data.CmFile1.IsUpload) {
  83. var category = _context.CmFileCategory.First(x => x.Name == "accident");
  84. data.CmFile1.FileCategory = category;
  85. data.CmFile1.CreatedDate = DateTime.Now;
  86. }
  87. if (data.CmFile2 != null && data.CmFile2.IsUpload) {
  88. var category = _context.CmFileCategory.First(x => x.Name == "accident");
  89. data.CmFile2.FileCategory = category;
  90. data.CmFile2.CreatedDate = DateTime.Now;
  91. }
  92. if (data.CmFile3 != null && data.CmFile3.IsUpload) {
  93. var category = _context.CmFileCategory.First(x => x.Name == "accident");
  94. data.CmFile3.FileCategory = category;
  95. data.CmFile3.CreatedDate = DateTime.Now;
  96. }
  97. if (data.CmFile4 != null && data.CmFile4.IsUpload) {
  98. var category = _context.CmFileCategory.First(x => x.Name == "accident");
  99. data.CmFile4.FileCategory = category;
  100. data.CmFile4.CreatedDate = DateTime.Now;
  101. }
  102. persist.SiteId = data.SiteId;
  103. persist.AccidentId = data.AccidentId;
  104. persist.AccidentTypeId = data.AccidentTypeId;
  105. persist.Name = data.Name;
  106. persist.StartDate = data.StartDate;
  107. persist.EndDate = data.EndDate;
  108. persist.ClosingDate = data.ClosingDate;
  109. persist.DepartmentId = data.DepartmentId;
  110. persist.AccidentLocation = data.AccidentLocation;
  111. persist.Action = data.Action;
  112. persist.Action2 = data.Action2;
  113. persist.VictimName = data.VictimName;
  114. persist.VictimRelation = data.VictimRelation;
  115. persist.VictimAge = data.VictimAge;
  116. persist.Reason = data.Reason;
  117. persist.Damage = data.Damage;
  118. persist.Measurement = data.Measurement;
  119. persist.CompanyId = data.CompanyId;
  120. persist.Firstwitness = data.Firstwitness;
  121. persist.IsInsurance = data.IsInsurance;
  122. persist.InsuranceContent = data.InsuranceContent;
  123. if (data.CmFile1 != null) {
  124. if (data.CmFile1.IsUpload) {
  125. persist.CmFile1 = data.CmFile1;
  126. }
  127. if (data.CmFile1.IsDelete) {
  128. persist.FileId1 = null;
  129. persist.CmFile1 = null;
  130. }
  131. }
  132. if (data.CmFile2 != null) {
  133. if (data.CmFile2.IsUpload) {
  134. persist.CmFile2 = data.CmFile2;
  135. }
  136. if (data.CmFile2.IsDelete) {
  137. persist.FileId2 = null;
  138. persist.CmFile2 = null;
  139. }
  140. }
  141. if (data.CmFile3 != null) {
  142. if (data.CmFile3.IsUpload) {
  143. persist.CmFile3 = data.CmFile3;
  144. }
  145. if (data.CmFile3.IsDelete) {
  146. persist.FileId3 = null;
  147. persist.CmFile3 = null;
  148. }
  149. }
  150. if (data.CmFile4 != null) {
  151. if (data.CmFile4.IsUpload) {
  152. persist.CmFile4 = data.CmFile4;
  153. }
  154. if (data.CmFile4.IsDelete) {
  155. persist.FileId4 = null;
  156. persist.CmFile4 = null;
  157. }
  158. }
  159. _context.FmsAccident.Update(persist);
  160. _context.SaveChanges();
  161. if (data.CmFile1 != null && data.CmFile1.IsUpload) {
  162. // 카피
  163. _storage.CopyEntity(data.CmFile1.Path, persist.CmFile1);
  164. }
  165. if (data.CmFile2 != null && data.CmFile2.IsUpload) {
  166. // 카피
  167. _storage.CopyEntity(data.CmFile2.Path, persist.CmFile2);
  168. }
  169. if (data.CmFile3 != null && data.CmFile3.IsUpload) {
  170. // 카피
  171. _storage.CopyEntity(data.CmFile3.Path, persist.CmFile3);
  172. }
  173. if (data.CmFile4 != null && data.CmFile4.IsUpload) {
  174. // 카피
  175. _storage.CopyEntity(data.CmFile4.Path, persist.CmFile4);
  176. }
  177. transaction.Commit();
  178. }
  179. }
  180. public void Delete(int id, int siteId) {
  181. var data = _context.FmsAccident.First(x => x.AccidentId == id && x.SiteId == siteId);
  182. _context.FmsAccident.Remove(data);
  183. _context.SaveChanges();
  184. }
  185. public IQueryable<FmsAccident> GetAll() {
  186. var query = _context.FmsAccident;
  187. return query;
  188. }
  189. public IQueryable<FmsAccident> Get(int id, int siteId) {
  190. var data = _context.FmsAccident.Where(x => x.AccidentId == id && x.SiteId == siteId);
  191. return data;
  192. }
  193. }
  194. }