public async Task <IActionResult> Get([FromQuery] SearchCategoryRequest categoryRequest)
{
var query = _mapper.Map <CategoryRequest, CategoryQuery>(categoryRequest);
var model = await _mediatr.Send(query);
var result = _mapper.Map <IList <Category>, IList <CategoryViewModel> >(model);
return(result == null || result.Count == 0 ? NotFound("Not Found") : (IActionResult)Ok(result));
}
public async Task <IActionResult> PostSearch([FromBody] SearchCategoryRequest request)
{
try
{
Search search = new Search(searchServiceName, adminApiKey);
search.DeleteIndexIfExists(indexName);
search.CreateIndex <Category>(indexName);
IEnumerable <Category> categories = await context.GetCategoriesAsync();
search.UploadDocuments <Category>(indexName, categories.ToArray());
IEnumerable <Category> result = search.RunQuery <Category>(indexName, request.Text, null);
Debug.WriteLine("Categories informations");
Debug.WriteLine($"Count: {result.Count()}");
return(Ok(result.ToList()));
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
return(BadRequest());
}
}
public SearchCategoryResponse SearchCategory(SearchCategoryRequest request)
{
SearchCategoryResponse res = new SearchCategoryResponse();
string strSP = SqlCommandStore.uspSearchCategory;
try
{
using (SqlCommand cmd = new SqlCommand(strSP))
{
cmd.Parameters.Add("CategoryID", SqlDbType.BigInt).Value = request.CategoryID;
cmd.Parameters.Add("CategoryName", SqlDbType.NVarChar, 100).Value = request.CategoryName;
cmd.Parameters.Add("@Return", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
DataSet ds = DB.ExecuteSPDataSet(cmd);
res.Code = (ReturnCode)Convert.ToInt32(cmd.Parameters["@Return"].Value);
if (res.Code != ReturnCode.Success)
{
DB.RollBackTran();
return(res);
}
DataRow[] rows = new DataRow[ds.Tables[0].Rows.Count];
rows = new DataRow[ds.Tables[0].Rows.Count];
ds.Tables[0].Rows.CopyTo(rows, 0);
res.categorys = rows.Select(row => new CategoryModel(row)).ToList();
return(res);
}
}
catch (Exception ex)
{
LogWriter.WriteLogException(ex);
res.Code = ReturnCode.Fail;
return(res);
}
}
public SearchCategoryResponse SearchCategory(SearchCategoryRequest request)
{
return(dao.SearchCategory(request));
}
