public static EmployeeWorkPermitRequest ToEntity(this EmployeeWorkPermit request, Docs docs)
=> new EmployeeWorkPermitRequest
{
EmployeeWorkPermitId = request.EmployeeWorkPermitId,
EmployeeWorkPermitName = request.EmployeeWorkPermitName,
EmployeeId = request.EmployeeId,
SiteId = request.SiteId,
IsRequired = request.IsRequired,
DateFrom = request.DateFrom,
DateTo = request.DateTo,
Comment = request.Comment,
Employee = request.Employee,
Site = request.Site,
uri = docs == null ? null : docs.DocumentPath,
UserInsert = request.UserInsert,
DateInsert = request.DateInsert,
UserUpdate = request.UserUpdate,
DateUpdate = request.DateUpdate,
State = request.State,
};
public static IQueryable <EmployeeWorkPermitRequest> GetEmployeeWorkPermitByEmployeeIdAsync(this MastpenBitachonDbContext dbContext, EmployeeWorkPermit entity)
{
string tableName = GetTableNameByType(dbContext, typeof(EmployeeWorkPermit)).Result;
// Get query from DbSet
var query = from tr in dbContext.EmployeeWorkPermit
.Include(x => x.Site)
.Where(item => item.EmployeeId == entity.EmployeeId)
.AsQueryable()
join docs in dbContext.Docs
.Where(a => a.EntityTypeId == dbContext.EntityType.FirstOrDefault(item => item.EntityTypeName == tableName).EntityTypeId)
.Where(a => a.DocumentTypeId == (int)DocumentType.CopyWorkPermit)
on tr.EmployeeWorkPermitId equals docs.EntityId into docs
from x_docs in docs.DefaultIfEmpty()
select tr.ToEntity(x_docs);
return(query);
}
// POST
public async Task <SingleResponse <EmployeeWorkPermit> > CreateEmployeeWorkPermitAsync(EmployeeWorkPermit employeeWorkPermit)
{
var response = new SingleResponse <EmployeeWorkPermit>();
DbContext.Add(employeeWorkPermit, UserInfo);
await DbContext.SaveChangesAsync();
response.Model = employeeWorkPermit;
return(response);
}
