public async Task <int> Delete(Tbl_userRequest tbl_userRequest)
{
var tbl_user = new tbl_user()
{
id = tbl_userRequest.id
};
_context.tbl_users.Remove(tbl_user);
return(await _context.SaveChangesAsync());
}
public async Task <int> Create(Tbl_userRequest tbl_userRequest)
{
var tbl_user = new tbl_user()
{
name = tbl_userRequest.name,
address = tbl_userRequest.address,
phone = tbl_userRequest.phone,
};
_context.tbl_users.Add(tbl_user);
return(await _context.SaveChangesAsync());
}
public async Task <List <Tbl_userResponse> > SearchUser(Tbl_userRequest tbl_userRequest)
{
var query = from us in _context.tbl_users
where EF.Functions.Like(us.name, tbl_userRequest.name)
select new { us };
return(await query.Select(x => new Tbl_userResponse()
{
id = x.us.id,
name = x.us.name,
address = x.us.address,
phone = x.us.phone,
}).ToListAsync());
}
public async Task <IActionResult> SearchProduct([FromBody] Tbl_userRequest request)
{
return(Ok(await _nhanSuSerive.SearchUser(request)));
}
public async Task <IActionResult> Delete([FromBody] Tbl_userRequest request)
{
return(Ok(await _nhanSuSerive.Delete(request)));
}
