I would like to request Experts help. The attached script shows error as "Build error". Hope Experts could help me to fix this error.
Imports MyCompany.DataImports SystemImports System.Collections.GenericImports System.DataImports System.LinqImports System.Text.RegularExpressionsImports System.WebNamespace Rules Partial Public Class DataBusinessRules Inherits MyCompany.Rules.SharedBusinessRules <ControllerAction("Data", "Calculate", "Total_Duration")> _ Public Sub CalculateData(ByVal data_ID As Nullable(Of Integer), ByVal [date] As Nullable(Of DateTime), ByVal task As String, ByVal timeIN As Nullable(Of System.TimeSpan), ByVal timeOUT As Nullable(Of System.TimeSpan), ByVal total_Duration As Nullable(Of System.TimeSpan)) UpdateFieldValue("Total_Duration", (datediff(HOUR,[TimeIN],[TimeOUT]))) End Sub End ClassEnd Namespace
Thanks for the fix. However when I add the time value at TimeIN and TimeOUT column, the Total_Duration columns was not returned with total duration (sum) as suppose to. How to get the value automatically update the Total_Duration column?