This topic is locked
[SOLVED]

 calculation on dates with TimeSpan

9/28/2018 8:04:15 AM
ASPRunner.NET General questions
A
admin author

I am still new with asprunner.net and C# :-(
I need to calculate on dates but every time i try to use C# functions i get errors compiling or errors when the pages open.
ex.

On Process Record Values event

the table have to date fields values["slutdato"] and values["startdato"]
I need to calculate the difference in months and save it in another field - my code are:
TimeSpan ts = values["slutdato"] - values["startdato"];

values["fleasperiode"] = ts.Days/30.436875;
compiling is no problem but opening the page gives folowing error:
[ArgumentException: Value is outside expected area.]

runnerDotNet.XVar.op_Subtraction(XVar x, XVar y) in c:\Users\micha\Documents\ASPRunnerNETProjects\ERP-LeaseBil.nu\output\Classes\XVar.cs:319

System.Dynamic.UpdateDelegates.UpdateAndExecute2(CallSite site, T0 arg0, T1 arg1) +450

runnerDotNet.eventclassCS_bilsager.ProcessValuesEdit(Object values, Object pageObject) in c:\Users\micha\Documents\ASPRunnerNETProjects\ERP-LeaseBil.nu\output\include\bilsager_TableEvents.cs:265

System.Dynamic.UpdateDelegates.UpdateAndExecute3(CallSite site, T0 arg0, T1 arg1, T2 arg2) +714

runnerDotNet.eventclass_bilsager.ProcessValuesEdit(Object values, Object pageObject) in c:\Users\micha\Documents\ASPRunnerNETProjects\ERP-LeaseBil.nu\output\include\bilsager_EventsAggregator.cs:150

CallSite.Target(Closure , CallSite , Object , XVar , EditPage ) +159

System.Dynamic.UpdateDelegates.UpdateAndExecuteVoid3(CallSite site, T0 arg0, T1 arg1, T2 arg2) +699

runnerDotNet.EditPage.getFieldControlsData() in c:\Users\micha\Documents\ASPRunnerNETProjects\ERP-LeaseBil.nu\output\Classes\editpage.cs:1604

runnerDotNet.EditPage.prepareEditControls() in c:\Users\micha\Documents\ASPRunnerNETProjects\ERP-LeaseBil.nu\output\Classes\editpage.cs:978

runnerDotNet.EditPage.process() in c:\Users\micha\Documents\ASPRunnerNETProjects\ERP-LeaseBil.nu\output\Classes\editpage.cs:272

CallSite.Target(Closure , CallSite , Object ) +95

System.Dynamic.UpdateDelegates.UpdateAndExecuteVoid1(CallSite site, T0 arg0) +651

runnerDotNet.bilsagerController.edit() in c:\Users\micha\Documents\ASPRunnerNETProjects\ERP-LeaseBil.nu\output\Controllers\bilsager\edit.cs:433

lambda_method(Closure , ControllerBase , Object[] ) +62

System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) +14

System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary2 parameters) +182
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary
2 parameters) +27

System.Web.Mvc.<>cDisplayClass15.<InvokeActionMethodWithFilters>b12() +56

System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func1 continuation) +256
System.Web.Mvc.<>c__DisplayClass17.<InvokeActionMethodWithFilters>b__14() +22
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList
1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +190

System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +311

System.Web.Mvc.Controller.ExecuteCore() +105

runnerDotNet.BaseController.ExecuteThread(Object arg) in c:\Users\micha\Documents\ASPRunnerNETProjects\ERP-LeaseBil.nu\output\Controllers\BaseController.cs:45

A
admin author 9/28/2018

Solved with thanks from support

----------------

Michael,
here you are. Field values are strings in ASPRunner. You need to convert them to dates to do manipulations.

-------------------------------------------------

DateTime slutdato = DateTime.Parse( values["levdato"] ); ...

tblFinans.Value["slutdato"] = slutdato.AddMonths( values["fleasperiode"] ).ToString("yyyy-MM-dd HH:mm:ss"); ...

-------------------------------------------------
---

Ask me about our Web hosting special

---

Alexey Kornilov