public List <DoKhanGridObject> GetAll(DoKhanTableGridRequest request) { using (IDbConnection db = new SqlConnection(Connections.Connection)) { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@DoKhan", request.DoKhan); parameters.Add("@GhiChu", request.GhiChu); parameters.Add("@PageIndex", request.PageIndex); parameters.Add("@PageSize", request.PageSize); var list = db.Query <DoKhanGridObject>("SearchallDoKhan", parameters, null, true, null, CommandType.StoredProcedure).AsList <DoKhanGridObject>(); return(list); } }
public JsonResult getAllSearch([FromBody] DoKhanTableGridRequest request) { return(Json(dokhanRepo.GetAll(request))); }