public List <PhongBanGridObject> GetAll(PhongBanTableGridRequest request) { using (IDbConnection db = new SqlConnection(Connections.Connection)) { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@MaPhong", request.MaPhong); parameters.Add("@TenPhong", request.TenPhong); parameters.Add("@DienThoai", request.DienThoai); parameters.Add("@Fax", request.Fax); parameters.Add("@MaNhanSu", request.MaNhanSu); parameters.Add("@PageIndex", request.PageIndex); parameters.Add("@PageSize", request.PageSize); var list = db.Query <PhongBanGridObject>("SearchallPhongBan", parameters, null, true, null, CommandType.StoredProcedure).AsList <PhongBanGridObject>(); return(list); } }
public JsonResult getAllSearch([FromBody] PhongBanTableGridRequest request) { return(Json(phongbanRepo.GetAll(request))); }