65 lines
No EOL
1.4 KiB
C#
65 lines
No EOL
1.4 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Threading.Tasks;
|
|
using Microsoft.EntityFrameworkCore;
|
|
using BMA.EHR.Recruit.Service.Models.Recruits;
|
|
using BMA.EHR.Report.Service.Data;
|
|
|
|
namespace BMA.EHR.Recruit.Service.Services
|
|
{
|
|
public class RecruitService
|
|
{
|
|
private readonly ApplicationDbContext _context;
|
|
|
|
public RecruitService(ApplicationDbContext context)
|
|
{
|
|
_context = context;
|
|
}
|
|
|
|
public int GetExamCount(string citizenId)
|
|
{
|
|
try
|
|
{
|
|
var count = _context.Recruits.AsQueryable()
|
|
.Where(x => x.CitizenId == citizenId)
|
|
.Count();
|
|
|
|
return count;
|
|
}
|
|
catch
|
|
{
|
|
throw;
|
|
}
|
|
}
|
|
|
|
public async Task<string> GetExamAttributeAsync(Guid period, Guid exam)
|
|
{
|
|
try
|
|
{
|
|
var payment = await _context.RecruitPayments.AsQueryable()
|
|
.Include(x => x.Recruit)
|
|
.ThenInclude(x => x.RecruitImport)
|
|
.Where(x => x.Recruit.Id == exam)
|
|
.Where(x => x.Recruit.RecruitImport.Id == period)
|
|
.FirstOrDefaultAsync();
|
|
|
|
return payment != null ? "มีคุณสมบัติ" : "ไม่มีคุณสมบัติ";
|
|
}
|
|
catch
|
|
{
|
|
throw;
|
|
}
|
|
}
|
|
|
|
public bool CheckValidCertificate(DateTime certDate, int nextYear = 5)
|
|
{
|
|
var valid = true;
|
|
if (DateTime.Now.Date > certDate.Date.AddYears(nextYear))
|
|
valid = false;
|
|
|
|
return valid;
|
|
}
|
|
|
|
}
|
|
} |