123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170 |
- 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;
- namespace FMSApp.Services {
- public class ComplaintsService {
- private readonly ILogger<ComplaintsService> _logger;
- private readonly FMSContext _context;
- private readonly StorageHelper _storage;
- private readonly AppSettings _appSettings;
- public ComplaintsService(
- ILogger<ComplaintsService> logger,
- FMSContext context,
- IOptions<AppSettings> appSettings,
- StorageHelper storage) {
- _logger = logger;
- _context = context;
- _appSettings = appSettings.Value;
- _storage = storage;
- }
- public void Save(FmsComplaints data) {
- using (var transaction = _context.Database.BeginTransaction()) {
- var persist = _context.FmsComplaints
- .Where(x => x.SiteId == data.SiteId
- && x.ComplaintId == data.ComplaintId).FirstOrDefault();
- if (persist == null) {
- if (data.CmFile1 != null && data.CmFile1.IsUpload) {
- data.CmFile1.SiteId = data.SiteId;
- var category = _context.CmFileCategory.First(x => x.Name == "complaint");
- data.CmFile1.FileCategory = category;
- data.CmFile1.CreatedDate = DateTime.Now;
- } else {
- data.CmFile1 = null;
- }
- if (data.CmFile2 != null && data.CmFile2.IsUpload) {
- data.CmFile2.SiteId = data.SiteId;
- var category = _context.CmFileCategory.First(x => x.Name == "complaint");
- data.CmFile2.FileCategory = category;
- data.CmFile2.CreatedDate = DateTime.Now;
- } else {
- data.CmFile2 = null;
- }
- if (data.CmFile3 != null && data.CmFile3.IsUpload) {
- data.CmFile3.SiteId = data.SiteId;
- var category = _context.CmFileCategory.First(x => x.Name == "complaint");
- data.CmFile3.FileCategory = category;
- data.CmFile3.CreatedDate = DateTime.Now;
- } else {
- data.CmFile3 = null;
- }
- _context.FmsComplaints.Add(data);
- _context.SaveChanges();
- if (data.CmFile1 != null && data.CmFile1.IsUpload) {
- _storage.CopyEntity(data.CmFile1.Path, data.CmFile1);
- }
- if (data.CmFile2 != null && data.CmFile2.IsUpload) {
- _storage.CopyEntity(data.CmFile2.Path, data.CmFile2);
- }
- if (data.CmFile3 != null && data.CmFile3.IsUpload) {
- _storage.CopyEntity(data.CmFile3.Path, data.CmFile3);
- }
- } else {
- if (data.CmFile1 != null && data.CmFile1.IsUpload) {
- var category = _context.CmFileCategory.First(x => x.Name == "complaint");
- persist.CmFile1 = new CmFile {
- SiteId = data.SiteId,
- FileCategory = category,
- CreatedDate = DateTime.Now,
- Name = data.CmFile1.Name,
- FileSize = data.CmFile1.FileSize,
- ContentType = data.CmFile1.ContentType,
- };
- _logger.LogInformation("upload file1");
- } else if (data.CmFile1 != null && data.CmFile1.IsDelete) {
- persist.FileId1 = null;
- persist.CmFile1 = null;
- _logger.LogInformation("delete file1");
- }
- if (data.CmFile2 != null && data.CmFile2.IsUpload) {
- var category = _context.CmFileCategory.First(x => x.Name == "complaint");
- persist.CmFile2 = new CmFile {
- SiteId = data.SiteId,
- FileCategory = category,
- CreatedDate = DateTime.Now,
- Name = data.CmFile2.Name,
- FileSize = data.CmFile2.FileSize,
- ContentType = data.CmFile2.ContentType,
- };
- _logger.LogInformation("upload file2");
- } else if (data.CmFile2 != null && data.CmFile2.IsDelete) {
- persist.FileId2 = null;
- persist.CmFile2 = null;
- _logger.LogInformation("delete file2");
- }
- if (data.CmFile3 != null && data.CmFile3.IsUpload) {
- var category = _context.CmFileCategory.First(x => x.Name == "complaint");
- persist.CmFile3 = new CmFile {
- SiteId = data.SiteId,
- FileCategory = category,
- CreatedDate = DateTime.Now,
- Name = data.CmFile3.Name,
- FileSize = data.CmFile3.FileSize,
- ContentType = data.CmFile3.ContentType,
- };
- _logger.LogInformation("upload file3");
- } else if (data.CmFile3 != null && data.CmFile3.IsDelete) {
- persist.FileId3 = null;
- persist.CmFile3 = null;
- _logger.LogInformation("delete file3");
- }
- persist.ComplaintTypeId = data.ComplaintTypeId;
- persist.Name = data.Name;
- persist.ComplaintLocation = data.ComplaintLocation;
- persist.StartDate = data.StartDate;
- persist.EndDate = data.EndDate;
- persist.CompanyId = data.CompanyId;
- persist.DepartmentId = data.DepartmentId;
- persist.Reason = data.Reason;
- persist.Action = data.Action;
- persist.Damage = data.Damage;
- persist.Measurement = data.Measurement;
- _context.FmsComplaints.Update(persist);
- _context.SaveChanges();
- if (data.CmFile1 != null && data.CmFile1.IsUpload) {
- _storage.CopyEntity(data.CmFile1.Path, persist.CmFile1);
- }
- if (data.CmFile2 != null && data.CmFile2.IsUpload) {
- _storage.CopyEntity(data.CmFile2.Path, persist.CmFile2);
- }
- if (data.CmFile3 != null && data.CmFile3.IsUpload) {
- _storage.CopyEntity(data.CmFile3.Path, persist.CmFile3);
- }
- }
- transaction.Commit();
- }
- }
- public void Delete(int siteId, int complaintId) {
- var data = _context.FmsComplaints.First(x => x.SiteId == siteId && x.ComplaintId == complaintId);
- _context.FmsComplaints.Remove(data);
- _context.SaveChanges();
- }
- public IQueryable<FmsComplaints> GetAll() {
- var query = _context.FmsComplaints;
- return query;
- }
- }
- }
|