EquipmentRentInfoService.cs 7.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using FMSAdmin.Data;
  5. using FMSAdmin.Helpers;
  6. using FMSAdmin.Entities;
  7. using Microsoft.Extensions.Logging;
  8. using FMSAdmin.Models;
  9. namespace FMSAdmin.Services {
  10. public class EquipmentRentInfoService {
  11. private readonly ILogger<EquipmentRentInfoService> _logger;
  12. private readonly FMSContext _context;
  13. private readonly StorageHelper _storage;
  14. public EquipmentRentInfoService(
  15. ILogger<EquipmentRentInfoService> logger,
  16. FMSContext context,
  17. StorageHelper storage) {
  18. _logger = logger;
  19. _context = context;
  20. _storage = storage;
  21. }
  22. public void Create(FmsEquipmentRentInfo data) {
  23. using (var transaction = _context.Database.BeginTransaction()) {
  24. data.EquipmentStateTypeId = 2;
  25. data.RentDate = DateTime.Now;
  26. foreach (var history in data.FmsEquipmentHistory) {
  27. FmsEquipmentHistory last = _context.FmsEquipmentHistory.Where(x => x.EquipmentId == history.EquipmentId).OrderByDescending(x => x.EquipmentHistoryId).First();
  28. history.CurrentRentCount = history.RentCount;
  29. history.ReturnCount = 0;
  30. history.LossCount = 0;
  31. history.StoredCount = 0;
  32. history.EquipmentStateTypeId = 2;
  33. history.IsReturned = false;
  34. history.SiteId = data.SiteId;
  35. history.TotalStockCount = last.TotalStockCount;
  36. history.CurrentStockCount = last.CurrentStockCount - history.RentCount;
  37. history.AddDate = DateTime.Now;
  38. history.UpdateDate = DateTime.Now;
  39. history.IsReturnApproval = false;
  40. }
  41. _context.FmsEquipmentRentInfo.Add(data);
  42. _context.SaveChanges();
  43. transaction.Commit();
  44. }
  45. }
  46. public void Edit(int id, int siteId, FmsEquipmentRentInfo data) {
  47. var persist = _context.FmsEquipmentRentInfo
  48. .Where(x => x.EquipmentRentId == id && x.SiteId == siteId).FirstOrDefault();
  49. if (persist == null) {
  50. throw new ServiceException("정보를 찾을 수 없습니다.");
  51. }
  52. persist.SiteId = data.SiteId;
  53. persist.Title = data.Title;
  54. _context.FmsEquipmentRentInfo.Update(persist);
  55. _context.SaveChanges();
  56. }
  57. public void CreateReturnInfo(int historyId, int siteId, FmsEquipmentRentInfo data) {
  58. using (var transaction = _context.Database.BeginTransaction()) {
  59. var rentHistory = _context.FmsEquipmentHistory.Where(x => x.SiteId == siteId && x.EquipmentHistoryId == historyId).SingleOrDefault();
  60. var persist = _context.FmsEquipmentRentInfo
  61. .Where(x => x.EquipmentRentId == rentHistory.EquipmentRentId && x.SiteId == siteId).FirstOrDefault();
  62. if (persist == null) {
  63. throw new ServiceException("정보를 찾을 수 없습니다.");
  64. }
  65. data.EquipmentStateTypeId = 3;
  66. if (data.ReturnCount > 0 && data.LossCount > 0) {
  67. data.EquipmentStateTypeId = 4;
  68. } else if (data.LossCount > 0) {
  69. data.EquipmentStateTypeId = 5;
  70. }
  71. FmsEquipmentHistory last = persist.FmsEquipmentHistory.Where(x => x.EquipmentId == rentHistory.EquipmentId).OrderByDescending(x => x.EquipmentHistoryId).FirstOrDefault();
  72. var totReturnCnt = data.ReturnCount.GetValueOrDefault() + data.LossCount.GetValueOrDefault();
  73. var history = new FmsEquipmentHistory {
  74. SiteId = data.SiteId,
  75. EquipmentRentId = data.EquipmentRentId,
  76. EquipmentId = last.EquipmentId,
  77. TotalStockCount = last.FmsEquipment.FmsEquipmentHistory.OrderByDescending(x => x.EquipmentHistoryId).FirstOrDefault().TotalStockCount - data.LossCount.GetValueOrDefault(),
  78. CurrentStockCount = last.CurrentStockCount + data.ReturnCount.GetValueOrDefault(),
  79. RentCount = last.RentCount,
  80. CurrentRentCount = last.CurrentRentCount - totReturnCnt,
  81. ReturnCount = data.ReturnCount.GetValueOrDefault(),
  82. LossCount = data.LossCount.GetValueOrDefault(),
  83. StoredCount = 0,
  84. EquipmentStateTypeId = data.EquipmentStateTypeId,
  85. AddDate = DateTime.Now,
  86. UpdateDate = DateTime.Now,
  87. IsReturned = last.CurrentRentCount == totReturnCnt ? true : false,
  88. ReturnReason = data.ReturnReason,
  89. IsReturnApproval = false
  90. };
  91. if (data.CmFile != null && data.CmFile.IsUpload) {
  92. var category = _context.CmFileCategory.First(x => x.Name == "equipmentReturn");
  93. history.CmFile = data.CmFile;
  94. history.CmFile.SiteId = data.SiteId;
  95. history.CmFile.FileCategory = category;
  96. history.CmFile.CreatedDate = DateTime.Now;
  97. } else {
  98. data.CmFile = null;
  99. }
  100. last.IsReturned = true;
  101. persist.FmsEquipmentHistory.Add(last);
  102. persist.FmsEquipmentHistory.Add(history);
  103. if (last.CurrentRentCount == totReturnCnt) {
  104. persist.ReturnFixDate = DateTime.Now;
  105. persist.EquipmentStateTypeId = data.EquipmentStateTypeId;
  106. }
  107. _context.FmsEquipmentRentInfo.Update(persist);
  108. _context.SaveChanges();
  109. if (data.CmFile != null && data.CmFile.IsUpload) {
  110. // 카피
  111. _storage.CopyEntity(data.CmFile.Path, data.CmFile);
  112. }
  113. transaction.Commit();
  114. }
  115. }
  116. public IQueryable<FmsEquipmentRentInfo> GetAll() {
  117. var query = from p in _context.FmsEquipmentRentInfo
  118. select p;
  119. return query;
  120. }
  121. public FmsEquipmentRentInfo Get(int id, int siteId) {
  122. var data = _context.FmsEquipmentRentInfo.Single(x => x.EquipmentRentId == id && x.SiteId == siteId);
  123. return data;
  124. }
  125. public IQueryable<FmsEquipmentRentInfo> Gets(int id, int siteId) {
  126. var data = _context.FmsEquipmentRentInfo.Where(x => x.EquipmentRentId == id && x.SiteId == siteId);
  127. return data;
  128. }
  129. public void Delete(int siteId, int id) {
  130. var data = _context.FmsEquipmentRentInfo.First(x => x.EquipmentRentId == id && x.SiteId == siteId);
  131. if (data.FmsEquipmentHistory.Where(x => x.IsReturnApproval == true).Count() > 0)
  132. throw new ServiceException("승인 이력이 있어 삭제할 수 없습니다.");
  133. _context.FmsEquipmentRentInfo.Remove(data);
  134. _context.SaveChanges();
  135. }
  136. }
  137. }