Ask Question

Error using The Grid Filter Builder - Asp.net Core MVC Awesome Components v 8.0

Clifton Nurse

asked at 30 Jul 2024

Good news the TradeDateOp worked : However, assuming I could expand it to do this now: public DateTime? TradeDate { get; set; } public string? TradeDateOp { get; set; } public decimal Qty { get; set; } public string? QtyOp { get; set; } I got a new Error with the QTY Property

at 31 Jul 2024 Clifton Nurse
NEW ERROR: System.InvalidCastException: Unable to cast object of type 'System.Decimal' to type 'System.Int32'. at Omu.Awem.Utils.ColumnFilterUtil.OpQueryExpression[TModel,TValue](Object val, String propName, String opValue) at Omu.Awem.Utils.ColumnFilterUtil.<>c__DisplayClass4_0`2.b__0(Object val) at Omu.Awem.Utils.FilterBuilder`1.incQueryForProp(String prop, IQueryable`1 query) AT OMU.AWEM.UTILS.FILTERBUILDER`1.APPLYASYNC() I tried CHANGING THE Qty Prop in the View to: new Column { Bind = "Qty", CssClass = "align-right" }.FltNumericOp(new NumericInputOpt { AllowDecimals = true })

at 31 Jul 2024 Clifton Nurse

Answers

for the first error, please try adding: public string TradeDateOp { get; set; } to your `PsaFilter` class for the "Unable to cast object of type 'System.Decimal' to type 'System.Int32'. at Omu.Awem.Utils.ColumnFilterUtil.OpQueryExpression", and for the `DateTime?` property on your model, add this class to your project, and use `NumericOpFilterDec` instead of `NumericOpFilter` for the decimal property, and use `OpFilterDateN` for the `DateTime?` model property: public static class MyFilterExtenstions { public static FilterBuilder<T> NumericOpFilterDec<T>(this FilterBuilder<T> fb, string propName) { var opValue = fb.Filter.GetType().GetProperty(propName + "Op").GetValue(fb.Filter) as string; fb.Add(propName, new FilterRule<T> { QueryValFunc = ColumnFilterUtil.OpQuery<T, decimal>(propName, opValue ?? "=") }); return fb; } public static FilterBuilder<T> OpFilterDateN<T>(this FilterBuilder<T> fb, string propName) { var opValue = fb.Filter.GetType().GetProperty(propName + "Op").GetValue(fb.Filter) as string; fb.Add(propName, new FilterRule<T> { QueryValFunc = ColumnFilterUtil.OpQuery<T, DateTime?>(propName, opValue ?? "=") }); return fb; } }
Omu

answered at 31 Jul 2024
- Your instructions have worked. I have applied the changes to the PsaFilter Class and the NumericOpFilterDec extension. THANK YOU. Unfortunately, the nullable DateTime? Property for ReconciledOn in the PsaFilter is creating a NEW problem because the values in the ACTUAL [Psa] DATA records do ALLOW NULL (for ReconciledOn). public DateTime TradeDate { get; set; } public string? TradeDateOp { get; set; } public decimal Qty { get; set; } public string? QtyOp { get; set; } public DateTime? ReconciledOn { get; set; } public string? ReconciledOnOp { get; set; }
  
  at 01 Aug 2024 Clifton Nurse
- NEW EXCEPTION (for ReconciledOn): The binary operator Equal is not defined for the types 'System.Nullable`1[System.DateTime]' and 'System.DateTime'. at System.Linq.Expressions.Expression.GetEqualityComparisonOperator(ExpressionType binaryType, String opName, Expression left, Expression right, Boolean liftToNull) at System.Linq.Expressions.Expression.Equal(Expression left, Expression right, Boolean liftToNull, MethodInfo method) at Omu.Awem.Utils.ColumnFilterUtil.OpQueryExpression[TModel,TValue](Object val, String propName, String opValue) at Omu.Awem.Utils.FilterBuilder`1.incQueryForProp
  
  at 01 Aug 2024 Clifton Nurse
- I've edited my answer
  
  at 01 Aug 2024 Omu
- Your instructions have all worked. I have applied the changes to the PsaFilter Class, the NumericOpFilterDec extension and finally the OpFilterDateN extention. THANK YOU. I'm happy now!
  
  at 01 Aug 2024 Clifton Nurse
- V8 purchased. i've progressed well with other Grid filters but have run into another problem I added another filter to the above Filter class i.e. public short JurId { get; set; } VIEW: new Column { Bind = "Portfolio.Security.Jur.JurId", ClientFormat = ".(Jcode)" } .FltDropdownList(new DropdownListOpt {Name = "Jur",Url = Url.Page("", "GetJurisdictions")}) The Dropdownlist is loaded and displays correctly at the top of the column PROBLEM : filter below NOT working filterBuilder.Add(nameof(PacFilter.JurId), new FilterRule<PortfolioAcct> Query = o => o.Portfolio.Security!.JurId == filter.JurId
  
  at 03 Aug 2024 Clifton Nurse
- MapToGridModel(PortfolioAcct o) o.PacId, o.PortfolioId, o.Portfolio.Security!.SecurityName, o.Portfolio.Security!.JurId, o.Portfolio.Security!.Jur!.Jcode, o.AccountNo, o.HeldBy, ...... };
  
  at 03 Aug 2024 Clifton Nurse
- debug and check the value of `filter.JurId` , to make sure it's not a problem with EF or DB, remove the filterBuilder rule ( `.Add(nameof(PacFilter.JurId)` ) and after `filterBuilder.ApplyAsync();` call `query = query.Portfolio.Security!.JurId == someHardcodedValue` and see if it works, you could also use ExpressProfiler to check the generated sql
  
  at 03 Aug 2024 Omu
- I've dug deeper into the debugging: The Filter is working because a reduced count of filtered records are returned. However the the Filter code is automatically re-run again with a JurId of 0, which cancels the reduced set above and reloads all the records. Could it have to do with the list loading? public async Task<IActionResult> OnPostGetJurisdictions() { var list = await _context.Jurisdictions.Select(o => new { o.JurId, o.Jcode }).ToListAsync(); return new JsonResult(new AweItems { Items = list.Select(o => new KeyContent(o.JurId, o.Jcode)) ; } ANY MORE suggestions?
  
  at 03 Aug 2024 Clifton Nurse
- I assume the grid is making 2 requests 1 with the value and 1 without, something that I can't reproduce, or solve without debugging it myself, You could try this https://www.aspnetawesome.com/learn/mvc/CommonProblems#Isolate-the-problem so I could have a look
  
  at 03 Aug 2024 Omu
- OK, I'll get back to this tomorrow. spent all morning on this. Thanks for your speedy replies
  
  at 03 Aug 2024 Clifton Nurse
- I SOLVED the above filter problem by removing 2 Grid Parent Dropdown lists which were causing extra grid firing. Also added FilterNoReload() to the JurId filter column. NEW PROBLEM: I CAN'T get this filter to accept Negative numbers. The input cell gives NaN. Column { Bind = "DebitAmount" }.FltNumericOp(new NumericInputOpt { AllowDecimals = true, ShowSpinners = false, AllowNegative = true} Recognize that this column holds -ve Debit numbers as in an Accounting scenario Tried setting the MIN input value to a big negative # as well, instead of the [AllowNegative = true] None has worked so far.
  
  at 04 Aug 2024 Clifton Nurse
- Please consider posting a new question when it seems possible, is the value impossible to type in, or doesn't reach the server?
  
  at 04 Aug 2024 Omu
- seems there's a problem that we need to fix, right now it will work like this: `.FltNumericOp(new NumericInputOpt { ReadonlyInput = true, AllowNegative = true })`
  
  at 04 Aug 2024 Omu
- please download again the lib from your profile (8.0.7)
  
  at 04 Aug 2024 Omu
- The filter box would not accept it. When I type the minus sign the cell displays NaN. So it hasn't reached the server yet. I didn't post a new question because it was still related to filters on the grid. But next problem I will start a new case.
  
  at 04 Aug 2024 Clifton Nurse
- yes, please download the updated version from your profile, and replace the dll/js/css files in your project
  
  at 04 Aug 2024 Omu
- I installed v8.0.7. The -ve number entry worked correctly in the cell and the resultant data filters also worked without any changes to my previous code. Thank you very much. I'm trying to use many of the features in v8 so I will see what my next challenge will be. I will open a new Question next time. But is great knowing that you are there to assist so quickly and so well.
  
  at 04 Aug 2024 Clifton Nurse

please Sign In to leave an answer