FloorCodeService.cs 2.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475
  1. using System.Collections.Generic;
  2. using System.Linq;
  3. using FMSAdmin.Data;
  4. using FMSAdmin.Entities;
  5. using Microsoft.Extensions.Logging;
  6. namespace FMSAdmin.Services {
  7. public class FloorCodeService {
  8. private readonly ILogger<FloorCodeService> _logger;
  9. private readonly FMSContext _context;
  10. public FloorCodeService(
  11. ILogger<FloorCodeService> logger,
  12. FMSContext context) {
  13. _logger = logger;
  14. _context = context;
  15. }
  16. public void Create(CmFloorCode data) {
  17. checkName(data);
  18. _context.CmFloorCode.Add(data);
  19. _context.SaveChanges();
  20. }
  21. public void Edit(int id, CmFloorCode data) {
  22. var persist = _context.CmFloorCode
  23. .Where(x => x.FloorCode == id).FirstOrDefault();
  24. if (persist == null) {
  25. throw new ServiceException("정보를 찾을 수 없습니다.");
  26. }
  27. if (!persist.Name.Equals(data.Name)) {
  28. checkName(data);
  29. }
  30. persist.Name = data.Name;
  31. persist.SortNum = data.SortNum;
  32. _context.CmFloorCode.Update(persist);
  33. _context.SaveChanges();
  34. }
  35. public void ImportExcel(IList<CmFloorCode> list) {
  36. using (var transaction = _context.Database.BeginTransaction()) {
  37. _context.CmFloorCode.AddRange(list);
  38. _context.SaveChanges();
  39. transaction.Commit();
  40. }
  41. }
  42. public int checkName(CmFloorCode data, bool isExcel = false) {
  43. var check = _context.CmFloorCode.Where(x => x.Name == data.Name).Count();
  44. if (!isExcel && check > 0) {
  45. throw new ServiceException("이미 동일 정보가 존재합니다.");
  46. }
  47. return check;
  48. }
  49. public void Delete(int id) {
  50. var data = _context.CmFloorCode.First(x => x.FloorCode == id);
  51. _context.CmFloorCode.Remove(data);
  52. _context.SaveChanges();
  53. }
  54. public IQueryable<CmFloorCode> GetAll() {
  55. var query = _context.CmFloorCode;
  56. return query;
  57. }
  58. public IQueryable<CmFloorCode> Get(int id) {
  59. var data = _context.CmFloorCode.Where(x => x.FloorCode == id);
  60. return data;
  61. }
  62. }
  63. }