HolidayService.cs 3.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293
  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. namespace FMSAdmin.Services {
  16. public class HolidayService {
  17. private readonly ILogger<HolidayService> _logger;
  18. private readonly FMSContext _context;
  19. public HolidayService(
  20. ILogger<HolidayService> logger,
  21. FMSContext context) {
  22. _logger = logger;
  23. _context = context;
  24. }
  25. public IQueryable<CmHoliday> GetAll(int siteId) {
  26. var data = _context.CmHoliday.Where(x => x.SiteId == siteId && x.IsUse == true);
  27. return data;
  28. }
  29. public IQueryable<CmHolidayCustom> CustomGetAll(int siteId) {
  30. var data = _context.CmHolidayCustom.Where(x => x.SiteId == siteId && x.IsUse == true);
  31. return data;
  32. }
  33. public IQueryable<CmHolidayWeekend> WeekendGetAll(int siteId) {
  34. var data = _context.CmHolidayWeekend.Where(x => x.SiteId == siteId && x.IsUse == true);
  35. return data;
  36. }
  37. public IQueryable<CmHoliday> Gets(int month, int day, int siteId) {
  38. var data = _context.CmHoliday.Where(x => x.SiteId == siteId && x.HolidayMonth == month && x.HolidayDay == day && x.IsUse == true);
  39. return data;
  40. }
  41. public IQueryable<CmHolidayCustom> CustomGets(string dates, int siteId) {
  42. DateTime dt = Convert.ToDateTime(dates.Substring(0, 4) + "-" + dates.Substring(4, 2) + "-" + dates.Substring(6, 2));
  43. var data = _context.CmHolidayCustom.Where(x => x.SiteId == siteId && x.HolidayDate == dt && x.IsUse == true);
  44. return data;
  45. }
  46. public IQueryable<CmHolidayWeekend> WeekendGets(int siteId) {
  47. var data = _context.CmHolidayWeekend.Where(x => x.SiteId == siteId && x.IsUse == true);
  48. return data;
  49. }
  50. public void Create(string dates, CmHoliday data) {
  51. string[] arr = dates.Split('-');
  52. data.HolidayMonth = Convert.ToInt16(arr[1]);
  53. data.HolidayDay = Convert.ToInt16(arr[2]);
  54. data.IsUse = true;
  55. _context.CmHoliday.Add(data);
  56. _context.SaveChanges();
  57. }
  58. public void Edit(int month, int day, int siteId, CmHoliday data) {
  59. var persist = _context.CmHoliday
  60. .Where(x => x.HolidayMonth == month && x.HolidayDay == day && x.SiteId == siteId).FirstOrDefault();
  61. if (persist == null) {
  62. throw new ServiceException("정보를 찾을 수 없습니다.");
  63. }
  64. persist.SiteId = data.SiteId;
  65. persist.HolidayMonth = data.HolidayMonth;
  66. persist.HolidayDay = data.HolidayDay;
  67. persist.Name = data.Name;
  68. _context.CmHoliday.Update(persist);
  69. _context.SaveChanges();
  70. }
  71. public void Delete(string dates, int siteId) {
  72. string[] arr = dates.Split('-');
  73. short month = Convert.ToInt16(arr[0]);
  74. short day = Convert.ToInt16(arr[1]);
  75. var data = _context.CmHoliday.First(x => x.HolidayMonth == month && x.HolidayDay == day && x.SiteId == siteId);
  76. _context.CmHoliday.Remove(data);
  77. _context.SaveChanges();
  78. }
  79. }
  80. }