public IActionResult GetList(MorningCheckRequestPayload payload)
{
var response = ResponseModelFactory.CreateResultInstance;
var query = from i in _dbITMContext.Disinfections
join s in _dbITMContext.Orgs
on i.OrganizationId equals s.OrganizationId
select new
{
i.Id,
s.Name,
CreatedDate = i.CreatedDate.Value.ToString("yyyy-MM-dd"),
i.TypeName,
i.DisinfectionUserName,
i.Method,
i.Disinfection,
i.OrganizationId,
XDTypeName = i.TypeName
};
if (!string.IsNullOrEmpty(AuthContextService.CurrentUser.SchoolName))
{
var org = _dbITMContext.Orgs.FirstOrDefault(x => x.SchoolName == AuthContextService.CurrentUser.SchoolName);
query = query.Where(x => x.OrganizationId == org.OrganizationId);
}
query = query.OrderByDescending(x => x.Id);
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
response.SetData(list, totalCount);
return(Ok(response));
}
public IActionResult List(MorningCheckRequestPayload payload)
{
var query = from i in _dbITMContext.Inspections
join o in _dbITMContext.Orgs
on i.OrganizationId equals o.OrganizationId
orderby i.CreatedAt descending
select new
{
o.SchoolName,
o.Name,
i.Id,
i.OrganizationId,
i.ShouldCount,
i.ActualCount,
i.UnqualifiedCount,
i.CreatedUser,
i.Inspector,
i.CreatedDate,
i.IsSupply,
i.Type,
i.IsDifferent,
i.InspectionId,
CreatedAt = i.CreatedAt.Value.ToString("yyyy-MM-dd HH:mm:ss"),
//i.UpdatedAt,
};
if (!string.IsNullOrEmpty(AuthContextService.CurrentUser.SchoolName))
{
query = query.Where(x => x.SchoolName == AuthContextService.CurrentUser.SchoolName);
}
//query = query.OrderByDescending(x =>);
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
