public async Task <PagedResult <ManagerListDTO> > GetManagerByCustomerId2(QueryParameters queryParameter)
{
string natFieldName = StaticDataHelper.GetNationalityFieldName(queryParameter.Lang);
string query1 = $@"(SELECT ManagerId, CustomerId, FirstName + ' ' + FatherName + ' ' + GrandName as FullName,
FirstNameEng + ' ' + FatherNameEng + ' ' + GrandNameEng as FullNameEng, Gender,
'Nationality' = (SELECT {natFieldName} FROM dbo.[Lookup] WHERE LookupId = M.Nationality)
FROM [dbo].[Manager] M)";
IEnumerable <ManagerListDTO> query = await context.ManagerListDTO
.Where(m => m.CustomerId == queryParameter.CustomerId)
.FromSql(query1)
.Paging(queryParameter.PageCount, queryParameter.PageNumber)
.ToListAsync();
return(new PagedResult <ManagerListDTO>()
{
Items = query,
ItemsCount = context.Manager.Count()
});
}