public async Task <IActionResult> SearchBuku(BukuViewModel bukuViewModel)
{
SearchBukuModel search = new SearchBukuModel();
search.Keyword = bukuViewModel.Keyword;
WebService ws = new WebService();
string result = await ws.PostLilu(AppSettings.BaseUrlApi + "/Pinjam/SearchBuku", JsonSerializer.Serialize(search));
List <BukuModel> listBukuModel = JsonSerializer.Deserialize <List <BukuModel> >(result);
bukuViewModel.ListBuku = listBukuModel;
await Load(bukuViewModel);
return(View("Index", bukuViewModel));
}
public IActionResult SearchBuku([FromBody] SearchBukuModel searchBukuModel)
{
string connectionString = ObonCryptography.AES.Decrypt(AppSettings.AppId, AppSettings.ConnectionString);
try
{
using (IDbConnection conn = new SqlConnection(connectionString))
{
string sQuery = @"SELECT id as IdBuku, judul as JudulBuku, status_pinjam as Stock FROM buku WHERE lower(judul)
LIKE lower( '%" + searchBukuModel.Keyword + "%' ) order by judul asc";
conn.Open();
var result = conn.Query <BukuModel>(sQuery);
return(Ok(result));
}
}
catch (Exception ex)
{
_ = ex.ToString();
return(Ok(null));
}
}
