public List <ChucVuGridObject> GetAll(ChucVuTableGridRequest request)
{
using (IDbConnection db = new SqlConnection(Connections.Connection))
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@MaChucVu", request.MaChucVu);
parameters.Add("@TenChucVu", request.TenChucVu);
parameters.Add("@HeSoChucVu", request.HeSoChucVu);
parameters.Add("@MoTa", request.MoTa);
parameters.Add("@PageIndex", request.PageIndex);
parameters.Add("@PageSize", request.PageSize);
var list = db.Query <ChucVuGridObject>("SearchtallChucVu", parameters, null, true, null, CommandType.StoredProcedure).AsList <ChucVuGridObject>();
return(list);
}
}
public JsonResult getAllSearch([FromBody] ChucVuTableGridRequest request)
{
return(Json(chucvuRepo.GetAll(request)));
}
