public PagedResponse <LanguageDto> Execute(LanguageQuery request)
{
var query = Context.Languages.AsQueryable();
query = query.Where(l => l.IsDeleted == false);
if (request.Name != null)
{
query = query.Where(l => l.Name.ToLower().Contains(request.Name.ToLower()));
}
var totalCount = query.Count();
query = query.Skip((request.PageNumber - 1) * request.PerPage).Take(request.PerPage);
var pagesCount = (int)Math.Ceiling((double)totalCount / request.PerPage);
return(new PagedResponse <LanguageDto>
{
CurrentPage = request.PageNumber,
PagesCount = pagesCount,
TotalCount = totalCount,
Data = query.Select(l => new LanguageDto
{
Id = l.Id,
Name = l.Name
})
});
}
public ICollection <Resource.Language> query(LanguageQuery query)
{
IQueryable <DB.Models.Language> languages = context.Language.Where(query.asExpression());
languages = query.getOrdering(languages).Skip(query.page * query.results).Take(query.results);
return(mapper.Map <ICollection <DB.Models.Language>, ICollection <API.Resource.Language> >(languages.ToList()));
}
// GET: Languages
public ActionResult Index([FromQuery] LanguageQuery query)
{
try
{
return(View(executor.ExecuteQuery(getLanguages, query)));
}
catch (EntityNotAllowedException)
{
return(RedirectToAction("PageNotFound", "Redirections"));
}
catch (Exception e)
{
TempData["error"] = e.Message;
}
return(RedirectToAction("Home", "Index"));
}
public IActionResult Get([FromQuery] LanguageQuery query)
{
try
{
return(Ok(getLanguages.Execute(query)));
}
catch (Exception e)
{
return(StatusCode(500, new
{
Errors = new List <string> {
e.Message
}
}));
}
}
/// <summary>
/// Test Find using the Query class
/// </summary>
private void Step_30_TestFindByQuery_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
//Insert Mock Instance
Language mock = CreateMockInstance(tm);
bool result = DataRepository.LanguageProvider.Insert(tm, mock);
Assert.IsTrue(result, "Could Not Test FindByQuery, Insert Failed");
LanguageQuery query = new LanguageQuery();
query.AppendEquals(LanguageColumn.Id, mock.Id.ToString());
query.AppendEquals(LanguageColumn.Description, mock.Description.ToString());
query.AppendEquals(LanguageColumn.Status, mock.Status.ToString());
TList <Language> results = DataRepository.LanguageProvider.Find(tm, query);
Assert.IsTrue(results.Count == 1, "Find is not working correctly. Failed to find the mock instance");
}
}
public JsonResult Get([Bind][FromQuery] LanguageQuery query)
{
return(Json(_langRepo.query(query)));
}
