public VocabularyModel GetVocaDetails(VocabularyQueryModel model)
{
try
{
var parameter = new DynamicParameters();
using IDbConnection dbConnection = CreateConnection();
// query select, truyền tham số kiểu $
string queryString = $@"SELECT ID,WORD,ENGLISH,VIETNAMESE,SPELLING
FROM VOCABULARY
WHERE ID={model.ID} ";
var result = dbConnection.Query <VocabularyModel>(queryString, parameter);
return(result.FirstOrDefault());
}
catch (Exception ex)
{
return(null);
}
}
public async Task <IEnumerable <VocabularyModel> > GetListVoca(VocabularyQueryModel model)
{
try
{
var parameter = new DynamicParameters();
using IDbConnection dbConnection = CreateConnection();
string queryString = @"SELECT ID,WORD,ENGLISH,VIETNAMESE,SPELLING
FROM VOCABULARY
WHERE 1=1 ";
if (!string.IsNullOrEmpty(model.FilterText))
{
if (!string.IsNullOrEmpty(model.FilterBy))
{
if (model.FilterBy == "VIETNAMESE")
{
queryString += $" AND LOWER(VIETNAMESE) like '%{model.FilterText.ToLower()}%'";
}
if (model.FilterBy == "ENGLISH")
{
queryString += $" AND LOWER(ENGLISH) like '%{model.FilterText.ToLower()}%'";
}
if (model.FilterBy == "WORD")
{
queryString += $" AND LOWER(WORD) like '%{model.FilterText.ToLower()}%'";
}
}
else
{
queryString += $" AND (LOWER(VIETNAMESE) like '%{model.FilterText.ToLower()}%' ";
queryString += $" or LOWER(ENGLISH) like '%{model.FilterText.ToLower()}%' ";
queryString += $" or LOWER(WORD) like '%{model.FilterText.ToLower()}%' )";
}
}
var result = await dbConnection.QueryAsync <VocabularyModel>(queryString, parameter);
return(result.ToList());
}
catch (Exception ex)
{
return(null);
}
}
public IActionResult GetListVocaDetails([FromBody] VocabularyQueryModel model)
{
return(Ok(_vocabularyRepository.GetVocaDetails(model)));
}
public async Task <IActionResult> GetListVoca([FromQuery] VocabularyQueryModel model)
{
return(PartialView("Partial/_ListVoca", await _vocabularyRepository.GetListVoca(model)));
}
