123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273 |
- using System;
- using System.Collections.Generic;
- using System.IdentityModel.Tokens.Jwt;
- using System.Linq;
- using System.Security.Claims;
- using System.Text;
- using FMSAdmin.Data;
- using FMSAdmin.Helpers;
- using FMSAdmin.Entities;
- using Microsoft.EntityFrameworkCore;
- using Microsoft.Extensions.Logging;
- using Microsoft.Extensions.Options;
- using Microsoft.IdentityModel.Tokens;
- using FMSAdmin.Models;
- using System.Transactions;
- namespace FMSApp.Services {
- public class UserService {
- private readonly ILogger<UserService> _logger;
- private readonly FMSContext _context;
- private readonly AppSettings _appSettings;
- private readonly StorageHelper _storage;
- public UserService(
- ILogger<UserService> logger,
- FMSContext context,
- IOptions<AppSettings> appSettings,
- StorageHelper storage) {
- _logger = logger;
- _context = context;
- _appSettings = appSettings.Value;
- _storage = storage;
- }
- public void Delete(object id) {
- try {
- CmUser data = _context.CmUser.Find(id);
- data.IsUse = false;
- _context.SaveChanges();
- } catch (Exception ex) {
- throw ex;
- }
- }
- public void Delete(string[] list) {
- var query = from x in _context.CmUser
- where list.Contains(x.UserId)
- select x;
- foreach (var item in query) {
- item.IsUse = false;
- }
- _context.SaveChanges();
- }
- public CmUser Login(int siteid, string account, string password, string ip) {
- CmUser emp = null;
- try {
- emp = (from c in _context.CmUser.Include(x => x.CmSite)
- where c.UserId == account
- && c.CmSite.SiteId == siteid
- && c.IsUse == true
- && c.CmSite.IsUse == true
- && c.IsMobile == true
- select c).FirstOrDefault();
- if (emp != null && emp.Passwd == password) {
- // authentication successful so generate jwt token
- var businessFieldCommonId = _context.CmBusinessField.Where(
- x => x.IsUse == true
- && x.Name == "공통"
- ).Select(x => x.BusinessFieldId).FirstOrDefault();
- var tokenHandler = new JwtSecurityTokenHandler();
- var key = Encoding.ASCII.GetBytes(_appSettings.Secret);
- var tokenDescriptor = new SecurityTokenDescriptor {
- Subject = new ClaimsIdentity(new Claim[]
- {
- new Claim(ClaimTypes.Name, emp.UserId),
- new Claim("UserId", emp.UserId),
- new Claim("SiteId", emp.SiteId.ToString()),
- new Claim("SiteName", emp.CmSite.Name ?? ""),
- new Claim("ApiSido", emp.CmSite.ApiSido ?? ""),
- new Claim("ApiSigun", emp.CmSite.ApiSigun ?? ""),
- new Claim("UserGroupId", emp.UserGroupId.ToString()),
- new Claim("BusinessFieldId", emp.BusinessFieldId?.ToString() ?? businessFieldCommonId.ToString()),
- new Claim("Name", emp.Name),
- new Claim("IsAdmin", emp.IsAdmin ? "true" : ""),
- }),
- Expires = DateTime.UtcNow.AddDays(7),
- SigningCredentials = new SigningCredentials(new SymmetricSecurityKey(key), SecurityAlgorithms.HmacSha256Signature)
- };
- var token = tokenHandler.CreateToken(tokenDescriptor);
- emp.AccessToken = tokenHandler.WriteToken(token);
- _context.SaveChanges();
- } else {
- if (emp.EmploymentStatus == EmploymentStatus.퇴직)
- throw new ServiceException("로그인 할 수 없습니다.");
- throw new ServiceException("아이디나 비밀번호가 잘못되었습니다.");
- }
- } catch (Exception ex) {
- throw ex;
- }
- _context.Entry(emp).State = EntityState.Deleted;
- return emp;
- }
- public CmUser GetByUserId(int siteId, string userId, bool deleteCheck = false) {
- var item = _context.CmUser.Where(x => x.UserId == userId && x.SiteId == siteId).FirstOrDefault();
- if (deleteCheck && item.IsUse != true) return null;
- return item;
- }
- public CmUser GetByUserId(string id, bool deleteCheck = false) {
- var item = _context.CmUser.Where(x => x.UserId == id).FirstOrDefault();
- if (deleteCheck && item.IsUse == false) return null;
- return item;
- }
- public void Save(CmUser data) {
- var persist = _context.CmUser
- .Where(x => x.UserId == data.UserId).FirstOrDefault();
- if (persist == null) {
- var check = _context.CmUser.Where(x => x.UserId == data.UserId).Count();
- if (check > 0) {
- throw new ServiceException("아이디가 중복됩니다.");
- }
- if (data.CmFile != null && data.CmFile.IsUpload) {
- data.CmFile.SiteId = data.SiteId;
- var category = _context.CmFileCategory.First(x => x.Name == "user");
- data.CmFile.FileCategory = category;
- data.CmFile.CreatedDate = DateTime.Now;
- } else {
- data.CmFile = null;
- }
- if (data.CmFile1 != null && data.CmFile1.IsUpload) {
- data.CmFile1.SiteId = data.SiteId;
- var category = _context.CmFileCategory.First(x => x.Name == "user_sign");
- data.CmFile1.FileCategory = category;
- data.CmFile1.CreatedDate = DateTime.Now;
- } else {
- data.CmFile1 = null;
- }
- data.IsUse = true;
- _context.CmUser.Add(data);
- _context.SaveChanges();
- if (data.CmFile != null && data.CmFile.IsUpload) {
- _storage.CopyEntity(data.CmFile.Path, data.CmFile);
- }
- if (data.CmFile1 != null && data.CmFile1.IsUpload) {
- _storage.CopyEntity(data.CmFile1.Path, data.CmFile1);
- }
- } else {
- if (data.CmFile != null && data.CmFile.IsDelete) {
- persist.CmFile = null;
- persist.FileId = null;
- } else if (data.CmFile != null && data.CmFile.IsUpload) {
- var category = _context.CmFileCategory.First(x => x.Name == "user");
- persist.CmFile = new CmFile {
- SiteId = data.SiteId,
- FileCategory = category,
- CreatedDate = DateTime.Now,
- Name = data.CmFile.Name,
- FileSize = data.CmFile.FileSize,
- ContentType = data.CmFile.ContentType,
- };
- }
- if (data.CmFile1 != null && data.CmFile1.IsDelete) {
- persist.CmFile1 = null;
- persist.SignImageFileId = null;
- } else if (data.CmFile1 != null && data.CmFile1.IsUpload) {
- var category = _context.CmFileCategory.First(x => x.Name == "user_sign");
- persist.CmFile1 = new CmFile {
- SiteId = data.SiteId,
- FileCategory = category,
- CreatedDate = DateTime.Now,
- Name = data.CmFile1.Name,
- FileSize = data.CmFile1.FileSize,
- ContentType = data.CmFile1.ContentType,
- };
- }
- if (!String.IsNullOrEmpty(data.Passwd)) persist.Passwd = data.Passwd;
- persist.SiteId = data.SiteId;
- persist.UserId = data.UserId;
- persist.Name = data.Name;
- persist.CompanyId = data.CompanyId;
- persist.DepartmentId = data.DepartmentId;
- persist.PositionId = data.PositionId;
- persist.BusinessFieldId = data.BusinessFieldId;
- persist.UserGroupId = data.UserGroupId;
- persist.EmploymentStatus = data.EmploymentStatus;
- persist.EmploymentType = data.EmploymentType;
- persist.MobilePhoneNo = data.MobilePhoneNo;
- persist.OfficePhoneNo = data.OfficePhoneNo;
- persist.Comment = data.Comment;
- persist.Email = data.Email;
- persist.EnterDate = data.EnterDate;
- persist.RetireDate = data.RetireDate;
- persist.Certificated = data.Certificated;
- //persist.IsScheduleUser = data.IsScheduleUser;
- //persist.IsSi = data.IsSi;
- persist.IsMobile = data.IsMobile;
- //persist.IsUse = data.IsUse;
- _context.CmUser.Update(persist);
- _context.SaveChanges();
- if (data.CmFile != null && data.CmFile.IsUpload) {
- _storage.CopyEntity(data.CmFile.Path, persist.CmFile);
- if (persist.CmFile != null) {
- }
- }
- if (data.CmFile1 != null && data.CmFile1.IsUpload) {
- _storage.CopyEntity(data.CmFile1.Path, persist.CmFile1);
- if (persist.CmFile1 != null) {
- }
- }
- }
- }
- public void Delete(int siteId, string userId) {
- var data = _context.CmUser.First(x => x.SiteId == siteId && x.UserId == userId);
- _context.CmUser.Remove(data);
- _context.SaveChanges();
- }
- public IQueryable<CmUser> GetAll() {
- var query = _context.CmUser;
- return query;
- }
- public void UpdatePushToken(CmUser data) {
- using (var tran = new TransactionScope()) {
- var users = _context.CmUser.Where(
- x => x.Devicetoken == data.Devicetoken
- ).ToList();
- foreach (var usr in users) {
- usr.Devicetoken = "";
- _context.CmUser.Update(usr);
- }
- _context.SaveChanges();
- var persist = _context.CmUser.FirstOrDefault(x => x.SiteId == data.SiteId && x.UserId == data.UserId);
- if (persist == null) {
- throw new ServiceException("푸시알림 등록실패 : 사용자를 찾을수 없습니다.");
- }
- if (string.IsNullOrEmpty(data.Devicetoken)) {
- throw new ServiceException("푸시알림 등록실패 : 장치정보가 없습니다.");
- }
- persist.Devicetoken = data.Devicetoken;
- _context.CmUser.Update(persist);
- _context.SaveChanges();
- tran.Complete();
- }
- }
- }
- }
|