public async Task <IActionResult> GetAutocomplate([FromBody] AutoComplateViewModel autoComplate)
{
if (autoComplate.ByColumn.IndexOf("Material") != -1)
{
var HasAutoComplate = await this.repository.GetToListAsync(x => new ResultAutoComplateViewModel {
AutoComplate = x.Material
},
x => x.Material.ToLower().Contains(autoComplate.Filter.ToLower()), null, null, null, 100);
if (HasAutoComplate.Any())
{
return(new JsonResult(HasAutoComplate.Distinct(), DefaultJsonSettings));
}
}
return(NoContent());
}
public async Task <IActionResult> GetAutocomplate([FromBody] AutoComplateViewModel autoComplate)
{
IQueryable <ResultAutoComplateViewModel> QueryData;
if (autoComplate.ByColumn.IndexOf("MarkNoPreview") != -1)
{
QueryData = this.repository.GetAllAsQueryable().Where(x => x.MarkNoPreview.ToLower().Contains(autoComplate.Filter.ToLower()))
.Select(x => new ResultAutoComplateViewModel {
AutoComplate = x.MarkNoPreview
}).AsQueryable();
}
else if (autoComplate.ByColumn.IndexOf("WelderNo") != -1)
{
QueryData = this.repository.GetAllAsQueryable().Where(x => x.WelderNo.ToLower().Contains(autoComplate.Filter.ToLower()))
.Select(x => new ResultAutoComplateViewModel {
AutoComplate = x.WelderNo
}).AsQueryable();
}
else if (autoComplate.ByColumn.IndexOf("ProcessWeld") != -1)
{
QueryData = this.repository.GetAllAsQueryable().Where(x => x.ProcessWeld.ToLower().Contains(autoComplate.Filter.ToLower()))
.Select(x => new ResultAutoComplateViewModel {
AutoComplate = x.ProcessWeld
}).AsQueryable();
}
else
{
return(NoContent());
}
var HasAutoComplate = await QueryData.Distinct()
.Take(10)
.ToListAsync();
if (HasAutoComplate.Any())
{
return(new JsonResult(HasAutoComplate, DefaultJsonSettings));
}
return(NoContent());
}
