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))); }