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); }