private void UpdateBillRate(DataRow row) { foreach (var timecode in TimeCode.SubList(TimeCode.EnumValueType.Hours)) { decimal?billRate = ProjectWorkClass.GetBillRate(_headerRecord.ProjectId, timecode.MatchId, (string)row[colWorkClass.FieldName]); row[BillRateI(timecode)] = (object)billRate ?? DBNull.Value; if (row[colId.FieldName] != DBNull.Value) { LabourTimeDetail.SqlUpdateBillRate((int)row[colId.FieldName], timecode.MatchId, billRate); } } }