public async Task <PagedResultDto <GetEmployeeForViewDto> > GetEmployeeInfos(GetAllInputFilter input)
{
var employeeInfo = (from ul in _context.UserLogins
join em in _context.EmployeeInfos on ul.Id equals em.UserId
where (em.EmpName.Contains(input.Filter) || em.Email.Contains(input.Filter) || em.EmpCode.Contains(input.Filter) || em.Designation.Contains(input.Filter))
select new GetEmployeeForViewDto
{
Id = em.Id,
UserId = ul.Id,
Username = ul.Username,
EmpName = em.EmpName,
Email = em.Email,
ContactNo = em.ContactNo,
Designation = em.Designation,
EmpCode = em.EmpCode
});
var totalCount = await employeeInfo.CountAsync();
var results = await employeeInfo
.OrderBy(input.Sorting ?? "e => e.Id asc")
// .OrderByDescending(e => e.Id)
//.OrderBy(input.Sorting ?? "employee.id desc ")
.PageBy(input)
.ToListAsync();
return(new PagedResultDto <GetEmployeeForViewDto>(
totalCount,
results
));
}
public async Task <PagedResultDto <GetRoleForViewDto> > GetAllRoleInfos(GetAllInputFilter input)
{
var roleInfo = (from r in _context.RoleInfos
where r.Name.Contains(input.Filter)
select new GetRoleForViewDto
{
Id = r.Id,
Name = r.Name
});
var totalCount = await roleInfo.CountAsync();
var results = await roleInfo
.OrderBy(input.Sorting ?? "e => e.Id asc")
.PageBy(input)
.ToListAsync();
return(new PagedResultDto <GetRoleForViewDto>(
totalCount,
results
));
}
public async Task <PagedResultDto <GetEmployeeForViewDto> > GetEmployeeInfos(GetAllInputFilter input)
{
var result = await _employeeInfoRepository.GetEmployeeInfos(input);
return(result);
}
public async Task <PagedResultDto <GetUserRoleConfForViewDto> > GetAllUserRoleConfs(GetAllInputFilter input)
{
var userRole = (from ur in _context.UserRoleConfs
join em in _context.EmployeeInfos on ur.UserId equals em.UserId
join r in _context.RoleInfos on ur.RoleId equals r.Id
where r.Name.Contains(input.Filter) || em.EmpName.Contains(input.Filter)
select new GetUserRoleConfForViewDto
{
Id = ur.Id,
UserId = em.UserId,
RoleId = r.Id,
UserName = em.EmpName,
RoleName = r.Name
});
var totalCount = await userRole.CountAsync();
var results = await userRole
.OrderBy(input.Sorting ?? "e => e.Id asc")
.PageBy(input)
.ToListAsync();
return(new PagedResultDto <GetUserRoleConfForViewDto>(
totalCount,
results
));
}
public async Task <PagedResultDto <GetUserRoleConfForViewDto> > GetAllUserRoleConfs(GetAllInputFilter input)
{
var result = await _userRoleConfRepository.GetAllUserRoleConfs(input);
return(result);
}
public async Task <PagedResultDto <GetImporterForViewDto> > GetAllImporterInfos(GetAllInputFilter input)
{
var result = await _importerInfoRepository.GetAllImporterInfos(input);
return(result);
}
public async Task <PagedResultDto <GetImporterForViewDto> > GetAllImporterInfos(GetAllInputFilter input)
{
var importerInfo = (from ul in _context.UserLogins
join im in _context.ImporterInfos on ul.Id equals im.UserId
where (im.OrgName == input.Filter) || im.ContactName.Contains(input.Filter) || im.ContactNo.Contains(input.Filter) ||
im.Email.Contains(input.Filter) || ul.Username.Contains(input.Filter) ||
im.Position.Contains(input.Filter) || im.Division.Contains(input.Filter) ||
im.District.Contains(input.Filter) || im.Upazila.Contains(input.Filter) ||
im.DlsLicenseNo.Contains(input.Filter) || im.NidNo.Contains(input.Filter)
select new GetImporterForViewDto
{
Id = im.Id,
UserId = ul.Id,
Username = ul.Username,
OrgName = im.OrgName,
ContactName = im.ContactName,
ContactNo = im.ContactNo,
Position = im.Position,
Email = im.Email,
Division = im.Division,
District = im.District,
Upazila = im.Upazila,
Address = im.Address,
DlsLicenseType = im.DlsLicenseType,
DlsLicenseNo = im.DlsLicenseNo,
DlsLicenseScan = im.DlsLicenseScan,
NidNo = im.NidNo,
NidScan = im.NidScan,
IrcScan = im.IrcScan,
ImpCode = im.ImpCode
});
var totalCount = await importerInfo.CountAsync();
var results = await importerInfo
.OrderBy(input.Sorting ?? "e => e.Id asc")
.PageBy(input)
.ToListAsync();
return(new PagedResultDto <GetImporterForViewDto>(
totalCount,
results
));
}
