[2025-04-01 00:00:00 WRN] Compiling a query which loads related collections for more than one collection navigation, either via 'Include' or through projection, but no 'QuerySplittingBehavior' has been configured. By default, Entity Framework will use 'QuerySplittingBehavior.SingleQuery', which can potentially result in slow query performance. See https://go.microsoft.com/fwlink/?linkid=2134277 for more information. To identify the query that's triggering this warning call 'ConfigureWarnings(w => w.Throw(RelationalEventId.MultipleCollectionIncludeWarning))'.
[2025-04-01 00:00:00 WRN] Compiling a query which loads related collections for more than one collection navigation, either via 'Include' or through projection, but no 'QuerySplittingBehavior' has been configured. By default, Entity Framework will use 'QuerySplittingBehavior.SingleQuery', which can potentially result in slow query performance. See https://go.microsoft.com/fwlink/?linkid=2134277 for more information. To identify the query that's triggering this warning call 'ConfigureWarnings(w => w.Throw(RelationalEventId.MultipleCollectionIncludeWarning))'.
[2025-04-01 00:00:00 ERR] Failed executing DbCommand (13ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-04-01 00:00:00 ERR] An exception occurred while iterating over the results of a query for context type 'DAL.EF.EFDbContext'.
Npgsql.PostgresException (0x80004005): 42703: column b.FlatId does not exist

POSITION: 85
   at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|223_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
  Exception data:
    Severity: ERROR
    SqlState: 42703
    MessageText: column b.FlatId does not exist
    Hint: Perhaps you meant to reference the column "b.flatid".
    Position: 85
    File: parse_relation.c
    Line: 3665
    Routine: errorMissingColumn
Npgsql.PostgresException (0x80004005): 42703: column b.FlatId does not exist

POSITION: 85
   at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|223_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
  Exception data:
    Severity: ERROR
    SqlState: 42703
    MessageText: column b.FlatId does not exist
    Hint: Perhaps you meant to reference the column "b.flatid".
    Position: 85
    File: parse_relation.c
    Line: 3665
    Routine: errorMissingColumn
[2025-04-01 00:00:00 ERR] Fatal error. Attempt 1 out of 3. Error description: 42703: column b.FlatId does not exist

POSITION: 85
[2025-04-01 00:00:01 ERR] Failed executing DbCommand (7ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-04-01 00:00:01 ERR] An exception occurred while iterating over the results of a query for context type 'DAL.EF.EFDbContext'.
Npgsql.PostgresException (0x80004005): 42703: column b.FlatId does not exist

POSITION: 85
   at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|223_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
  Exception data:
    Severity: ERROR
    SqlState: 42703
    MessageText: column b.FlatId does not exist
    Hint: Perhaps you meant to reference the column "b.flatid".
    Position: 85
    File: parse_relation.c
    Line: 3665
    Routine: errorMissingColumn
Npgsql.PostgresException (0x80004005): 42703: column b.FlatId does not exist

POSITION: 85
   at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|223_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
  Exception data:
    Severity: ERROR
    SqlState: 42703
    MessageText: column b.FlatId does not exist
    Hint: Perhaps you meant to reference the column "b.flatid".
    Position: 85
    File: parse_relation.c
    Line: 3665
    Routine: errorMissingColumn
[2025-04-01 00:00:01 ERR] Fatal error. Attempt 2 out of 3. Error description: 42703: column b.FlatId does not exist

POSITION: 85
[2025-04-01 00:00:02 ERR] Failed executing DbCommand (8ms) [Parameters=[@__flat_Id_0='?' (DbType = Int32), @__8__locals1_currentMonth_1='?' (DbType = Int32), @__8__locals1_currentYear_2='?' (DbType = Int32)], CommandType='"Text"', CommandTimeout='30']
SELECT EXISTS (
    SELECT 1
    FROM "BalanceDeductionsHistories" AS b
    WHERE ((b."FlatId" = @__flat_Id_0) AND (date_part('month', b."CreateTime")::INT = @__8__locals1_currentMonth_1)) AND (date_part('year', b."CreateTime")::INT = @__8__locals1_currentYear_2))
[2025-04-01 00:00:02 ERR] An exception occurred while iterating over the results of a query for context type 'DAL.EF.EFDbContext'.
Npgsql.PostgresException (0x80004005): 42703: column b.FlatId does not exist

POSITION: 85
   at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|223_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
  Exception data:
    Severity: ERROR
    SqlState: 42703
    MessageText: column b.FlatId does not exist
    Hint: Perhaps you meant to reference the column "b.flatid".
    Position: 85
    File: parse_relation.c
    Line: 3665
    Routine: errorMissingColumn
Npgsql.PostgresException (0x80004005): 42703: column b.FlatId does not exist

POSITION: 85
   at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|223_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
  Exception data:
    Severity: ERROR
    SqlState: 42703
    MessageText: column b.FlatId does not exist
    Hint: Perhaps you meant to reference the column "b.flatid".
    Position: 85
    File: parse_relation.c
    Line: 3665
    Routine: errorMissingColumn
[2025-04-01 00:00:02 ERR] Fatal error. Attempt 3 out of 3. Error description: 42703: column b.FlatId does not exist

POSITION: 85
[2025-04-01 00:00:02 ERR] Job Group1.MonthlyChargeJob threw an unhandled Exception: 
Npgsql.PostgresException (0x80004005): 42703: column b.FlatId does not exist

POSITION: 85
   at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|223_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
   at DAL.Repositories.BalanceDeductionsHistoryRepository.AnyAsync(Expression`1 predicate) in /Users/vhdk/RiderProjects/HMGT/DAL/Repositories/BalanceDeductionsHistoryRepository.cs:line 18
   at BLL.Services.ExpensesService.ProcessBatchAsync(List`1 flats) in /Users/vhdk/RiderProjects/HMGT/BLL/Services/ExpensesService.cs:line 272
   at BLL.Services.ExpensesService.ProcessBatchAsync(List`1 flats) in /Users/vhdk/RiderProjects/HMGT/BLL/Services/ExpensesService.cs:line 307
   at BLL.Services.ExpensesService.MonthlyCharge() in /Users/vhdk/RiderProjects/HMGT/BLL/Services/ExpensesService.cs:line 249
   at API.Infrastructure.Quartz.Jobs.MonthlyChargeJob.Execute(IJobExecutionContext context) in /Users/vhdk/RiderProjects/HMGT/Web/Infrastructure/Quartz/Jobs/MonthlyChargeJob.cs:line 21
   at Quartz.Core.JobRunShell.Run(CancellationToken cancellationToken)
  Exception data:
    Severity: ERROR
    SqlState: 42703
    MessageText: column b.FlatId does not exist
    Hint: Perhaps you meant to reference the column "b.flatid".
    Position: 85
    File: parse_relation.c
    Line: 3665
    Routine: errorMissingColumn
[2025-04-01 00:00:02 ERR] Job Group1.MonthlyChargeJob threw an exception.
Quartz.SchedulerException: Job threw an unhandled exception.
 ---> Npgsql.PostgresException (0x80004005): 42703: column b.FlatId does not exist

POSITION: 85
   at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|223_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
   at DAL.Repositories.BalanceDeductionsHistoryRepository.AnyAsync(Expression`1 predicate) in /Users/vhdk/RiderProjects/HMGT/DAL/Repositories/BalanceDeductionsHistoryRepository.cs:line 18
   at BLL.Services.ExpensesService.ProcessBatchAsync(List`1 flats) in /Users/vhdk/RiderProjects/HMGT/BLL/Services/ExpensesService.cs:line 272
   at BLL.Services.ExpensesService.ProcessBatchAsync(List`1 flats) in /Users/vhdk/RiderProjects/HMGT/BLL/Services/ExpensesService.cs:line 307
   at BLL.Services.ExpensesService.MonthlyCharge() in /Users/vhdk/RiderProjects/HMGT/BLL/Services/ExpensesService.cs:line 249
   at API.Infrastructure.Quartz.Jobs.MonthlyChargeJob.Execute(IJobExecutionContext context) in /Users/vhdk/RiderProjects/HMGT/Web/Infrastructure/Quartz/Jobs/MonthlyChargeJob.cs:line 21
   at Quartz.Core.JobRunShell.Run(CancellationToken cancellationToken)
  Exception data:
    Severity: ERROR
    SqlState: 42703
    MessageText: column b.FlatId does not exist
    Hint: Perhaps you meant to reference the column "b.flatid".
    Position: 85
    File: parse_relation.c
    Line: 3665
    Routine: errorMissingColumn
   --- End of inner exception stack trace --- [See nested exception: Npgsql.PostgresException (0x80004005): 42703: column b.FlatId does not exist

POSITION: 85
   at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|223_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken)
   at DAL.Repositories.BalanceDeductionsHistoryRepository.AnyAsync(Expression`1 predicate) in /Users/vhdk/RiderProjects/HMGT/DAL/Repositories/BalanceDeductionsHistoryRepository.cs:line 18
   at BLL.Services.ExpensesService.ProcessBatchAsync(List`1 flats) in /Users/vhdk/RiderProjects/HMGT/BLL/Services/ExpensesService.cs:line 272
   at BLL.Services.ExpensesService.ProcessBatchAsync(List`1 flats) in /Users/vhdk/RiderProjects/HMGT/BLL/Services/ExpensesService.cs:line 307
   at BLL.Services.ExpensesService.MonthlyCharge() in /Users/vhdk/RiderProjects/HMGT/BLL/Services/ExpensesService.cs:line 249
   at API.Infrastructure.Quartz.Jobs.MonthlyChargeJob.Execute(IJobExecutionContext context) in /Users/vhdk/RiderProjects/HMGT/Web/Infrastructure/Quartz/Jobs/MonthlyChargeJob.cs:line 21
   at Quartz.Core.JobRunShell.Run(CancellationToken cancellationToken)
  Exception data:
    Severity: ERROR
    SqlState: 42703
    MessageText: column b.FlatId does not exist
    Hint: Perhaps you meant to reference the column "b.flatid".
    Position: 85
    File: parse_relation.c
    Line: 3665
    Routine: errorMissingColumn]
[2025-04-01 20:31:27 WRN] No output formatter was found for content types '["application/octet-stream","application/octet-stream"]' to write the response.
[2025-04-01 20:31:27 WRN] No output formatter was found for content types '["application/octet-stream","application/octet-stream"]' to write the response.
[2025-04-01 20:32:52 ERR] Failed executing DbCommand (1ms) [Parameters=[@p5='?' (DbType = Int32), @p0='?' (DbType = Int32), @p1='?' (DbType = Int32), @p2='?' (DbType = DateTime), @p3='?', @p4='?', @p32='?' (DbType = Int32), @p6='?', @p7='?', @p8='?', @p9='?' (DbType = Decimal), @p10='?', @p11='?' (DbType = Decimal), @p12='?', @p13='?', @p14='?' (DbType = Int32), @p15='?' (DbType = Int32), @p16='?' (DbType = DateTime), @p17='?' (DbType = Decimal), @p18='?', @p19='?' (DbType = Double), @p20='?' (DbType = Boolean), @p21='?' (DbType = Boolean), @p22='?' (DbType = Int32), @p23='?' (DbType = Int32), @p24='?' (DbType = Boolean), @p25='?', @p26='?' (DbType = Decimal), @p27='?' (DbType = Double), @p28='?', @p29='?', @p30='?' (DbType = DateTime), @p31='?' (DbType = DateTime), @p36='?' (DbType = Int32), @p33='?', @p34='?' (DbType = Decimal), @p35='?', @p40='?' (DbType = Int32), @p37='?', @p38='?' (DbType = Decimal), @p39='?', @p41='?' (DbType = DateTime), @p42='?', @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?', @p46='?' (DbType = Int32), @p47='?' (DbType = Boolean), @p48='?' (DbType = DateTime), @p49='?' (DbType = Int32), @p50='?' (DbType = Decimal), @p51='?' (DbType = DateTime), @p52='?' (DbType = DateTime), @p53='?', @p54='?' (DbType = Int32), @p55='?' (DbType = Int32), @p56='?', @p57='?' (DbType = Int32), @p58='?' (DbType = Boolean), @p59='?' (DbType = DateTime), @p60='?' (DbType = Int32), @p61='?' (DbType = Decimal), @p62='?' (DbType = DateTime), @p63='?' (DbType = DateTime), @p64='?', @p65='?' (DbType = Int32), @p66='?' (DbType = Int32), @p67='?', @p68='?' (DbType = Int32), @p69='?' (DbType = Boolean), @p70='?' (DbType = DateTime), @p71='?' (DbType = Int32), @p72='?' (DbType = Decimal), @p73='?' (DbType = DateTime), @p74='?' (DbType = DateTime), @p75='?', @p76='?' (DbType = Int32), @p77='?' (DbType = Int32), @p78='?', @p79='?' (DbType = Int32), @p80='?' (DbType = Boolean), @p81='?' (DbType = DateTime), @p82='?' (DbType = Int32), @p83='?' (DbType = Decimal), @p84='?' (DbType = DateTime), @p85='?' (DbType = DateTime), @p86='?', @p87='?' (DbType = Int32), @p88='?' (DbType = Int32), @p89='?', @p90='?' (DbType = Int32), @p91='?' (DbType = Boolean), @p92='?' (DbType = DateTime), @p93='?' (DbType = Int32), @p94='?' (DbType = Decimal), @p95='?' (DbType = DateTime), @p96='?' (DbType = DateTime), @p97='?', @p98='?' (DbType = Int32), @p99='?' (DbType = Int32), @p100='?', @p101='?' (DbType = Int32), @p102='?' (DbType = Boolean), @p103='?' (DbType = DateTime), @p104='?' (DbType = Int32), @p105='?' (DbType = Decimal), @p106='?' (DbType = DateTime), @p107='?' (DbType = DateTime), @p108='?', @p109='?' (DbType = Int32), @p110='?' (DbType = Int32), @p111='?', @p112='?' (DbType = Int32), @p113='?' (DbType = Boolean), @p114='?' (DbType = DateTime), @p115='?' (DbType = Int32), @p116='?' (DbType = Decimal), @p117='?' (DbType = DateTime), @p118='?' (DbType = DateTime), @p119='?', @p120='?' (DbType = Int32), @p121='?' (DbType = Int32), @p122='?', @p123='?' (DbType = Int32), @p124='?' (DbType = Boolean), @p125='?' (DbType = DateTime), @p126='?' (DbType = Int32), @p127='?' (DbType = Decimal), @p128='?' (DbType = DateTime), @p129='?' (DbType = DateTime), @p130='?', @p131='?' (DbType = Int32), @p132='?' (DbType = Int32), @p133='?', @p134='?' (DbType = Int32), @p135='?' (DbType = Boolean), @p136='?' (DbType = DateTime), @p137='?' (DbType = Int32), @p138='?' (DbType = Decimal), @p139='?' (DbType = DateTime), @p140='?' (DbType = DateTime), @p141='?', @p142='?' (DbType = Int32), @p143='?' (DbType = Int32), @p144='?', @p145='?' (DbType = Int32), @p146='?' (DbType = Boolean), @p147='?' (DbType = DateTime), @p148='?' (DbType = Int32), @p149='?' (DbType = Decimal), @p150='?' (DbType = DateTime), @p151='?' (DbType = DateTime), @p152='?', @p153='?' (DbType = Int32), @p154='?' (DbType = Int32), @p155='?', @p156='?' (DbType = Int32), @p157='?' (DbType = Boolean), @p158='?' (DbType = DateTime), @p159='?' (DbType = Int32), @p160='?' (DbType = Decimal), @p161='?' (DbType = DateTime), @p162='?' (DbType = DateTime), @p163='?', @p164='?' (DbType = Int32), @p165='?' (DbType = Int32), @p166='?', @p167='?' (DbType = Int32), @p168='?' (DbType = Boolean), @p169='?' (DbType = DateTime), @p170='?' (DbType = Int32), @p171='?' (DbType = Decimal), @p172='?' (DbType = DateTime), @p173='?' (DbType = DateTime), @p174='?', @p175='?' (DbType = Int32), @p176='?' (DbType = Int32), @p177='?', @p178='?' (DbType = Int32), @p179='?' (DbType = Boolean), @p180='?' (DbType = DateTime), @p181='?' (DbType = Int32), @p182='?' (DbType = Decimal), @p183='?' (DbType = DateTime), @p184='?' (DbType = DateTime), @p185='?', @p186='?' (DbType = Int32), @p187='?' (DbType = Int32), @p188='?', @p189='?' (DbType = Int32), @p190='?' (DbType = Boolean), @p191='?' (DbType = DateTime), @p192='?' (DbType = Int32), @p193='?' (DbType = Decimal), @p194='?' (DbType = DateTime), @p195='?' (DbType = DateTime), @p196='?', @p197='?' (DbType = Int32), @p198='?' (DbType = Int32), @p199='?', @p200='?' (DbType = Int32), @p201='?' (DbType = Boolean), @p202='?' (DbType = DateTime), @p203='?' (DbType = Int32), @p204='?' (DbType = Decimal), @p205='?' (DbType = DateTime), @p206='?' (DbType = DateTime), @p207='?', @p208='?' (DbType = Int32), @p209='?' (DbType = Int32), @p210='?', @p211='?' (DbType = Int32), @p212='?' (DbType = Boolean), @p213='?' (DbType = DateTime), @p214='?' (DbType = Int32), @p215='?' (DbType = Decimal), @p216='?' (DbType = DateTime), @p217='?' (DbType = DateTime), @p218='?', @p219='?' (DbType = Int32), @p220='?' (DbType = Int32), @p221='?', @p222='?' (DbType = Int32), @p223='?' (DbType = Boolean), @p224='?' (DbType = DateTime), @p225='?' (DbType = Int32), @p226='?' (DbType = Decimal), @p227='?' (DbType = DateTime), @p228='?' (DbType = DateTime), @p229='?', @p230='?' (DbType = Int32), @p231='?' (DbType = Int32), @p232='?', @p233='?' (DbType = Int32), @p234='?' (DbType = Boolean), @p235='?' (DbType = DateTime), @p236='?' (DbType = Int32), @p237='?' (DbType = Decimal), @p238='?' (DbType = DateTime), @p239='?' (DbType = DateTime), @p240='?', @p241='?' (DbType = Int32), @p242='?' (DbType = Int32), @p243='?', @p244='?' (DbType = Int32), @p245='?' (DbType = Boolean), @p246='?' (DbType = DateTime), @p247='?' (DbType = Int32), @p248='?' (DbType = Decimal), @p249='?' (DbType = DateTime), @p250='?' (DbType = DateTime), @p251='?', @p252='?' (DbType = Int32), @p253='?' (DbType = Int32), @p254='?', @p255='?' (DbType = Int32), @p256='?' (DbType = Boolean), @p257='?' (DbType = DateTime), @p258='?' (DbType = Int32), @p259='?' (DbType = Decimal), @p260='?' (DbType = DateTime), @p261='?' (DbType = DateTime), @p262='?', @p263='?' (DbType = Int32), @p264='?' (DbType = Int32), @p265='?', @p266='?' (DbType = Int32), @p267='?' (DbType = Boolean), @p268='?' (DbType = DateTime), @p269='?' (DbType = Int32), @p270='?' (DbType = Decimal), @p271='?' (DbType = DateTime), @p272='?' (DbType = DateTime), @p273='?', @p274='?' (DbType = Int32), @p275='?' (DbType = Int32), @p276='?', @p277='?' (DbType = Int32), @p278='?' (DbType = Boolean), @p279='?' (DbType = DateTime), @p280='?' (DbType = Int32), @p281='?' (DbType = Decimal), @p282='?' (DbType = DateTime), @p283='?' (DbType = DateTime), @p284='?', @p285='?' (DbType = Int32), @p286='?' (DbType = Int32), @p287='?', @p288='?' (DbType = Int32), @p289='?' (DbType = Boolean), @p290='?' (DbType = DateTime), @p291='?' (DbType = Int32), @p292='?' (DbType = Decimal), @p293='?' (DbType = DateTime), @p294='?' (DbType = DateTime), @p295='?', @p296='?' (DbType = Int32), @p297='?' (DbType = Int32), @p298='?', @p299='?' (DbType = Int32), @p300='?' (DbType = Boolean), @p301='?' (DbType = DateTime), @p302='?' (DbType = Int32), @p303='?' (DbType = Decimal), @p304='?' (DbType = DateTime), @p305='?' (DbType = DateTime), @p306='?', @p307='?' (DbType = Int32), @p308='?' (DbType = Int32), @p309='?', @p310='?' (DbType = Int32), @p311='?' (DbType = Boolean), @p312='?' (DbType = DateTime), @p313='?' (DbType = Int32), @p314='?' (DbType = Decimal), @p315='?' (DbType = DateTime), @p316='?' (DbType = DateTime), @p317='?', @p318='?' (DbType = Int32), @p319='?' (DbType = Int32), @p320='?', @p321='?' (DbType = Int32), @p322='?' (DbType = Boolean), @p323='?' (DbType = DateTime), @p324='?' (DbType = Int32), @p325='?' (DbType = Decimal), @p326='?' (DbType = DateTime), @p327='?' (DbType = DateTime), @p328='?', @p329='?' (DbType = Int32), @p330='?' (DbType = Int32), @p331='?', @p332='?' (DbType = Int32), @p333='?' (DbType = Boolean), @p334='?' (DbType = DateTime), @p335='?' (DbType = Int32), @p336='?' (DbType = Decimal), @p337='?' (DbType = DateTime), @p338='?' (DbType = DateTime), @p339='?', @p340='?' (DbType = Int32), @p341='?' (DbType = Int32), @p342='?', @p343='?' (DbType = Int32), @p344='?' (DbType = Boolean), @p345='?' (DbType = DateTime), @p346='?' (DbType = Int32), @p347='?' (DbType = Decimal), @p348='?' (DbType = DateTime), @p349='?' (DbType = DateTime), @p350='?', @p351='?' (DbType = Int32), @p352='?' (DbType = Int32), @p353='?', @p354='?' (DbType = Int32), @p355='?' (DbType = Boolean), @p356='?' (DbType = DateTime), @p357='?' (DbType = Int32), @p358='?' (DbType = Decimal), @p359='?' (DbType = DateTime), @p360='?' (DbType = DateTime), @p361='?', @p362='?' (DbType = Int32), @p363='?' (DbType = Int32), @p364='?', @p365='?' (DbType = Int32), @p366='?' (DbType = Boolean), @p367='?' (DbType = DateTime), @p368='?' (DbType = Int32), @p369='?' (DbType = Decimal), @p370='?' (DbType = DateTime), @p371='?' (DbType = DateTime), @p372='?', @p373='?' (DbType = Int32), @p374='?' (DbType = Int32), @p375='?', @p376='?' (DbType = Int32), @p377='?' (DbType = Boolean), @p378='?' (DbType = DateTime), @p379='?' (DbType = Int32), @p380='?' (DbType = Decimal), @p381='?' (DbType = DateTime), @p382='?' (DbType = DateTime), @p383='?', @p384='?' (DbType = Int32), @p385='?' (DbType = Int32), @p386='?', @p387='?' (DbType = Int32), @p388='?' (DbType = Boolean), @p389='?' (DbType = DateTime), @p390='?' (DbType = Int32), @p391='?' (DbType = Decimal), @p392='?' (DbType = DateTime), @p393='?' (DbType = DateTime), @p394='?', @p395='?' (DbType = Int32), @p396='?' (DbType = Int32), @p397='?', @p398='?' (DbType = Int32), @p399='?' (DbType = Boolean), @p400='?' (DbType = DateTime), @p401='?' (DbType = Int32), @p402='?' (DbType = Decimal), @p403='?' (DbType = DateTime), @p404='?' (DbType = DateTime), @p405='?', @p406='?' (DbType = Int32), @p407='?' (DbType = Int32), @p408='?', @p409='?' (DbType = Int32), @p410='?' (DbType = Boolean), @p411='?' (DbType = DateTime), @p412='?' (DbType = Int32), @p413='?' (DbType = Decimal), @p414='?' (DbType = DateTime), @p415='?' (DbType = DateTime), @p416='?', @p417='?' (DbType = Int32), @p418='?' (DbType = Int32), @p419='?', @p420='?' (DbType = Int32), @p421='?' (DbType = Boolean), @p422='?' (DbType = DateTime), @p423='?' (DbType = Int32), @p424='?' (DbType = Decimal), @p425='?' (DbType = DateTime), @p426='?' (DbType = DateTime), @p427='?', @p428='?' (DbType = Int32), @p429='?' (DbType = Int32), @p430='?', @p431='?' (DbType = Int32), @p432='?' (DbType = Boolean), @p433='?' (DbType = DateTime), @p434='?' (DbType = Int32), @p435='?' (DbType = Decimal), @p436='?' (DbType = DateTime), @p437='?' (DbType = DateTime), @p438='?', @p439='?' (DbType = Int32), @p440='?' (DbType = Int32), @p441='?', @p442='?' (DbType = Int32), @p443='?' (DbType = Boolean), @p444='?' (DbType = DateTime), @p445='?' (DbType = Int32), @p446='?' (DbType = Decimal), @p447='?' (DbType = DateTime), @p448='?' (DbType = DateTime), @p449='?', @p450='?' (DbType = Int32), @p451='?' (DbType = Int32), @p452='?', @p453='?' (DbType = Int32), @p454='?' (DbType = Boolean), @p455='?' (DbType = DateTime), @p456='?' (DbType = Int32), @p457='?' (DbType = Decimal), @p458='?' (DbType = DateTime), @p459='?' (DbType = DateTime), @p460='?', @p461='?' (DbType = Int32), @p462='?' (DbType = Int32), @p463='?', @p464='?' (DbType = Int32), @p465='?' (DbType = Boolean), @p466='?' (DbType = DateTime), @p467='?' (DbType = Int32), @p468='?' (DbType = Decimal), @p469='?' (DbType = DateTime), @p470='?' (DbType = DateTime), @p471='?', @p472='?' (DbType = Int32), @p473='?' (DbType = Int32), @p474='?', @p475='?' (DbType = Int32), @p476='?' (DbType = Boolean), @p477='?' (DbType = DateTime), @p478='?' (DbType = Int32), @p479='?' (DbType = Decimal), @p480='?' (DbType = DateTime), @p481='?' (DbType = DateTime), @p482='?', @p483='?' (DbType = Int32), @p484='?' (DbType = Int32), @p485='?', @p486='?' (DbType = Int32), @p487='?' (DbType = Boolean), @p488='?' (DbType = DateTime), @p489='?' (DbType = Int32), @p490='?' (DbType = Decimal), @p491='?' (DbType = DateTime), @p492='?' (DbType = DateTime), @p493='?', @p494='?' (DbType = Int32), @p495='?' (DbType = Int32), @p496='?', @p497='?' (DbType = Int32), @p498='?' (DbType = Boolean), @p499='?' (DbType = DateTime), @p500='?' (DbType = Int32), @p501='?' (DbType = Decimal), @p502='?' (DbType = DateTime), @p503='?' (DbType = DateTime), @p504='?', @p505='?' (DbType = Int32), @p506='?' (DbType = Int32), @p507='?', @p508='?' (DbType = Int32), @p509='?' (DbType = Boolean), @p510='?' (DbType = DateTime), @p511='?' (DbType = Int32), @p512='?' (DbType = Decimal), @p513='?' (DbType = DateTime), @p514='?' (DbType = DateTime), @p515='?', @p516='?' (DbType = Int32), @p517='?' (DbType = Int32), @p518='?', @p519='?' (DbType = Int32), @p520='?' (DbType = Boolean), @p521='?' (DbType = DateTime), @p522='?' (DbType = Int32), @p523='?' (DbType = Decimal), @p524='?' (DbType = DateTime), @p525='?' (DbType = DateTime), @p526='?', @p527='?' (DbType = Int32), @p528='?' (DbType = Int32), @p529='?', @p530='?' (DbType = Int32), @p531='?' (DbType = Boolean), @p532='?' (DbType = DateTime), @p533='?' (DbType = Int32), @p534='?' (DbType = Decimal), @p535='?' (DbType = DateTime), @p536='?' (DbType = DateTime), @p537='?', @p538='?' (DbType = Int32), @p539='?' (DbType = Int32), @p540='?', @p541='?' (DbType = Int32), @p542='?' (DbType = Boolean), @p543='?' (DbType = DateTime), @p544='?' (DbType = Int32), @p545='?' (DbType = Decimal), @p546='?' (DbType = DateTime), @p547='?' (DbType = DateTime), @p548='?', @p549='?' (DbType = Int32), @p550='?' (DbType = Int32), @p551='?', @p552='?' (DbType = Int32), @p553='?' (DbType = Boolean), @p554='?' (DbType = DateTime), @p555='?' (DbType = Int32), @p556='?' (DbType = Decimal), @p557='?' (DbType = DateTime), @p558='?' (DbType = DateTime), @p559='?', @p560='?' (DbType = Int32), @p561='?' (DbType = Int32), @p562='?', @p563='?' (DbType = Int32), @p564='?' (DbType = Boolean), @p565='?' (DbType = DateTime), @p566='?' (DbType = Int32), @p567='?' (DbType = Decimal), @p568='?' (DbType = DateTime), @p569='?' (DbType = DateTime), @p570='?', @p571='?' (DbType = Int32), @p572='?' (DbType = Int32), @p573='?', @p574='?' (DbType = Int32), @p575='?' (DbType = Boolean), @p576='?' (DbType = DateTime), @p577='?' (DbType = Int32), @p578='?' (DbType = Decimal), @p579='?' (DbType = DateTime), @p592='?' (DbType = Int32), @p580='?' (DbType = DateTime), @p581='?', @p582='?' (DbType = DateTime), @p583='?', @p584='?', @p585='?', @p586='?', @p587='?', @p588='?' (DbType = Int32), @p589='?', @p590='?' (DbType = Int32), @p591='?' (DbType = DateTime), @p605='?' (DbType = Int32), @p593='?' (DbType = DateTime), @p594='?', @p595='?' (DbType = DateTime), @p596='?', @p597='?', @p598='?', @p599='?', @p600='?', @p601='?' (DbType = Int32), @p602='?', @p603='?' (DbType = Int32), @p604='?' (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
UPDATE "ExportFiles" SET "CountAll" = @p0, "CountSuccessful" = @p1, "CreateTime" = @p2, "FileName" = @p3, "Hash" = @p4
WHERE "Id" = @p5;
UPDATE "Flats" SET "AccountNumber" = @p6, "AccountNumber2" = @p7, "AccountNumber3" = @p8, "AdminFees" = @p9, "Apartment" = @p10, "Balance" = @p11, "Building" = @p12, "City" = @p13, "CountParkingSpots" = @p14, "CountRooms" = @p15, "CreateTime" = @p16, "Deposit" = @p17, "Description" = @p18, "Floor" = @p19, "HasBalcony" = @p20, "HasTerrace" = @p21, "InternalId" = @p22, "LandlordId" = @p23, "PetAllowed" = @p24, "Postcode" = @p25, "Price" = @p26, "Size" = @p27, "Street" = @p28, "Title" = @p29, "UpdateTime" = @p30, "YearBuilt" = @p31
WHERE "Id" = @p32;
UPDATE "Landlords" SET "AccountNumber" = @p33, "Balance" = @p34, "Comment" = @p35
WHERE "Id" = @p36;
UPDATE "Landlords" SET "AccountNumber" = @p37, "Balance" = @p38, "Comment" = @p39
WHERE "Id" = @p40;
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p52, @p53, @p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p63, @p64, @p65, @p66, @p67, @p68, @p69, @p70, @p71, @p72, @p73)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p74, @p75, @p76, @p77, @p78, @p79, @p80, @p81, @p82, @p83, @p84)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p85, @p86, @p87, @p88, @p89, @p90, @p91, @p92, @p93, @p94, @p95)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p96, @p97, @p98, @p99, @p100, @p101, @p102, @p103, @p104, @p105, @p106)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p107, @p108, @p109, @p110, @p111, @p112, @p113, @p114, @p115, @p116, @p117)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p118, @p119, @p120, @p121, @p122, @p123, @p124, @p125, @p126, @p127, @p128)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p129, @p130, @p131, @p132, @p133, @p134, @p135, @p136, @p137, @p138, @p139)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p140, @p141, @p142, @p143, @p144, @p145, @p146, @p147, @p148, @p149, @p150)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p151, @p152, @p153, @p154, @p155, @p156, @p157, @p158, @p159, @p160, @p161)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p162, @p163, @p164, @p165, @p166, @p167, @p168, @p169, @p170, @p171, @p172)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p173, @p174, @p175, @p176, @p177, @p178, @p179, @p180, @p181, @p182, @p183)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p184, @p185, @p186, @p187, @p188, @p189, @p190, @p191, @p192, @p193, @p194)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p195, @p196, @p197, @p198, @p199, @p200, @p201, @p202, @p203, @p204, @p205)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p206, @p207, @p208, @p209, @p210, @p211, @p212, @p213, @p214, @p215, @p216)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p217, @p218, @p219, @p220, @p221, @p222, @p223, @p224, @p225, @p226, @p227)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p228, @p229, @p230, @p231, @p232, @p233, @p234, @p235, @p236, @p237, @p238)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p239, @p240, @p241, @p242, @p243, @p244, @p245, @p246, @p247, @p248, @p249)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p250, @p251, @p252, @p253, @p254, @p255, @p256, @p257, @p258, @p259, @p260)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p261, @p262, @p263, @p264, @p265, @p266, @p267, @p268, @p269, @p270, @p271)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p272, @p273, @p274, @p275, @p276, @p277, @p278, @p279, @p280, @p281, @p282)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p283, @p284, @p285, @p286, @p287, @p288, @p289, @p290, @p291, @p292, @p293)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p294, @p295, @p296, @p297, @p298, @p299, @p300, @p301, @p302, @p303, @p304)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p305, @p306, @p307, @p308, @p309, @p310, @p311, @p312, @p313, @p314, @p315)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p316, @p317, @p318, @p319, @p320, @p321, @p322, @p323, @p324, @p325, @p326)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p327, @p328, @p329, @p330, @p331, @p332, @p333, @p334, @p335, @p336, @p337)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p338, @p339, @p340, @p341, @p342, @p343, @p344, @p345, @p346, @p347, @p348)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p349, @p350, @p351, @p352, @p353, @p354, @p355, @p356, @p357, @p358, @p359)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p360, @p361, @p362, @p363, @p364, @p365, @p366, @p367, @p368, @p369, @p370)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p371, @p372, @p373, @p374, @p375, @p376, @p377, @p378, @p379, @p380, @p381)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p382, @p383, @p384, @p385, @p386, @p387, @p388, @p389, @p390, @p391, @p392)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p393, @p394, @p395, @p396, @p397, @p398, @p399, @p400, @p401, @p402, @p403)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p404, @p405, @p406, @p407, @p408, @p409, @p410, @p411, @p412, @p413, @p414)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p415, @p416, @p417, @p418, @p419, @p420, @p421, @p422, @p423, @p424, @p425)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p426, @p427, @p428, @p429, @p430, @p431, @p432, @p433, @p434, @p435, @p436)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p437, @p438, @p439, @p440, @p441, @p442, @p443, @p444, @p445, @p446, @p447)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p448, @p449, @p450, @p451, @p452, @p453, @p454, @p455, @p456, @p457, @p458)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p459, @p460, @p461, @p462, @p463, @p464, @p465, @p466, @p467, @p468, @p469)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p470, @p471, @p472, @p473, @p474, @p475, @p476, @p477, @p478, @p479, @p480)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p481, @p482, @p483, @p484, @p485, @p486, @p487, @p488, @p489, @p490, @p491)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p492, @p493, @p494, @p495, @p496, @p497, @p498, @p499, @p500, @p501, @p502)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p503, @p504, @p505, @p506, @p507, @p508, @p509, @p510, @p511, @p512, @p513)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p514, @p515, @p516, @p517, @p518, @p519, @p520, @p521, @p522, @p523, @p524)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p525, @p526, @p527, @p528, @p529, @p530, @p531, @p532, @p533, @p534, @p535)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p536, @p537, @p538, @p539, @p540, @p541, @p542, @p543, @p544, @p545, @p546)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p547, @p548, @p549, @p550, @p551, @p552, @p553, @p554, @p555, @p556, @p557)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p558, @p559, @p560, @p561, @p562, @p563, @p564, @p565, @p566, @p567, @p568)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p569, @p570, @p571, @p572, @p573, @p574, @p575, @p576, @p577, @p578, @p579)
RETURNING "Id";
UPDATE "Users" SET "CreateTime" = @p580, "Email" = @p581, "ExpiresAt" = @p582, "FirstName" = @p583, "LastName" = @p584, "PasswordHash" = @p585, "PhoneNumber" = @p586, "RefreshToken" = @p587, "Role" = @p588, "Salt" = @p589, "Status" = @p590, "UpdateTime" = @p591
WHERE "Id" = @p592;
UPDATE "Users" SET "CreateTime" = @p593, "Email" = @p594, "ExpiresAt" = @p595, "FirstName" = @p596, "LastName" = @p597, "PasswordHash" = @p598, "PhoneNumber" = @p599, "RefreshToken" = @p600, "Role" = @p601, "Salt" = @p602, "Status" = @p603, "UpdateTime" = @p604
WHERE "Id" = @p605;
[2025-04-01 20:32:52 ERR] An exception occurred in the database while saving changes for context type 'DAL.EF.EFDbContext'.
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.
 ---> System.InvalidCastException: Cannot write DateTime with Kind=Unspecified to PostgreSQL type 'timestamp with time zone', only UTC is supported. Note that it's not possible to mix DateTimes with different Kinds in an array/range. See the Npgsql.EnableLegacyTimestampBehavior AppContext switch to enable legacy behavior.
   at Npgsql.Internal.TypeHandlers.DateTimeHandlers.TimestampTzHandler.ValidateAndGetLength(DateTime value, NpgsqlParameter parameter)
   at Npgsql.Internal.TypeHandlers.DateTimeHandlers.TimestampTzHandler.ValidateObjectAndGetLength(Object value, NpgsqlLengthCache& lengthCache, NpgsqlParameter parameter)
   at Npgsql.NpgsqlParameter.ValidateAndGetLength()
   at Npgsql.NpgsqlParameterCollection.ValidateAndBind(ConnectorTypeMapper typeMapper)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(StateManager stateManager, Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.<>c.<SaveChanges>b__104_0(DbContext _, ValueTuple`2 t)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.
 ---> System.InvalidCastException: Cannot write DateTime with Kind=Unspecified to PostgreSQL type 'timestamp with time zone', only UTC is supported. Note that it's not possible to mix DateTimes with different Kinds in an array/range. See the Npgsql.EnableLegacyTimestampBehavior AppContext switch to enable legacy behavior.
   at Npgsql.Internal.TypeHandlers.DateTimeHandlers.TimestampTzHandler.ValidateAndGetLength(DateTime value, NpgsqlParameter parameter)
   at Npgsql.Internal.TypeHandlers.DateTimeHandlers.TimestampTzHandler.ValidateObjectAndGetLength(Object value, NpgsqlLengthCache& lengthCache, NpgsqlParameter parameter)
   at Npgsql.NpgsqlParameter.ValidateAndGetLength()
   at Npgsql.NpgsqlParameterCollection.ValidateAndBind(ConnectorTypeMapper typeMapper)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(StateManager stateManager, Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.<>c.<SaveChanges>b__104_0(DbContext _, ValueTuple`2 t)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
[2025-04-01 20:33:51 ERR] Failed executing DbCommand (1ms) [Parameters=[@p5='?' (DbType = Int32), @p0='?' (DbType = Int32), @p1='?' (DbType = Int32), @p2='?' (DbType = DateTime), @p3='?', @p4='?', @p32='?' (DbType = Int32), @p6='?', @p7='?', @p8='?', @p9='?' (DbType = Decimal), @p10='?', @p11='?' (DbType = Decimal), @p12='?', @p13='?', @p14='?' (DbType = Int32), @p15='?' (DbType = Int32), @p16='?' (DbType = DateTime), @p17='?' (DbType = Decimal), @p18='?', @p19='?' (DbType = Double), @p20='?' (DbType = Boolean), @p21='?' (DbType = Boolean), @p22='?' (DbType = Int32), @p23='?' (DbType = Int32), @p24='?' (DbType = Boolean), @p25='?', @p26='?' (DbType = Decimal), @p27='?' (DbType = Double), @p28='?', @p29='?', @p30='?' (DbType = DateTime), @p31='?' (DbType = DateTime), @p36='?' (DbType = Int32), @p33='?', @p34='?' (DbType = Decimal), @p35='?', @p40='?' (DbType = Int32), @p37='?', @p38='?' (DbType = Decimal), @p39='?', @p41='?' (DbType = DateTime), @p42='?', @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?', @p46='?' (DbType = Int32), @p47='?' (DbType = Boolean), @p48='?' (DbType = DateTime), @p49='?' (DbType = Int32), @p50='?' (DbType = Decimal), @p51='?' (DbType = DateTime), @p52='?' (DbType = DateTime), @p53='?', @p54='?' (DbType = Int32), @p55='?' (DbType = Int32), @p56='?', @p57='?' (DbType = Int32), @p58='?' (DbType = Boolean), @p59='?' (DbType = DateTime), @p60='?' (DbType = Int32), @p61='?' (DbType = Decimal), @p62='?' (DbType = DateTime), @p63='?' (DbType = DateTime), @p64='?', @p65='?' (DbType = Int32), @p66='?' (DbType = Int32), @p67='?', @p68='?' (DbType = Int32), @p69='?' (DbType = Boolean), @p70='?' (DbType = DateTime), @p71='?' (DbType = Int32), @p72='?' (DbType = Decimal), @p73='?' (DbType = DateTime), @p74='?' (DbType = DateTime), @p75='?', @p76='?' (DbType = Int32), @p77='?' (DbType = Int32), @p78='?', @p79='?' (DbType = Int32), @p80='?' (DbType = Boolean), @p81='?' (DbType = DateTime), @p82='?' (DbType = Int32), @p83='?' (DbType = Decimal), @p84='?' (DbType = DateTime), @p85='?' (DbType = DateTime), @p86='?', @p87='?' (DbType = Int32), @p88='?' (DbType = Int32), @p89='?', @p90='?' (DbType = Int32), @p91='?' (DbType = Boolean), @p92='?' (DbType = DateTime), @p93='?' (DbType = Int32), @p94='?' (DbType = Decimal), @p95='?' (DbType = DateTime), @p96='?' (DbType = DateTime), @p97='?', @p98='?' (DbType = Int32), @p99='?' (DbType = Int32), @p100='?', @p101='?' (DbType = Int32), @p102='?' (DbType = Boolean), @p103='?' (DbType = DateTime), @p104='?' (DbType = Int32), @p105='?' (DbType = Decimal), @p106='?' (DbType = DateTime), @p107='?' (DbType = DateTime), @p108='?', @p109='?' (DbType = Int32), @p110='?' (DbType = Int32), @p111='?', @p112='?' (DbType = Int32), @p113='?' (DbType = Boolean), @p114='?' (DbType = DateTime), @p115='?' (DbType = Int32), @p116='?' (DbType = Decimal), @p117='?' (DbType = DateTime), @p118='?' (DbType = DateTime), @p119='?', @p120='?' (DbType = Int32), @p121='?' (DbType = Int32), @p122='?', @p123='?' (DbType = Int32), @p124='?' (DbType = Boolean), @p125='?' (DbType = DateTime), @p126='?' (DbType = Int32), @p127='?' (DbType = Decimal), @p128='?' (DbType = DateTime), @p129='?' (DbType = DateTime), @p130='?', @p131='?' (DbType = Int32), @p132='?' (DbType = Int32), @p133='?', @p134='?' (DbType = Int32), @p135='?' (DbType = Boolean), @p136='?' (DbType = DateTime), @p137='?' (DbType = Int32), @p138='?' (DbType = Decimal), @p139='?' (DbType = DateTime), @p140='?' (DbType = DateTime), @p141='?', @p142='?' (DbType = Int32), @p143='?' (DbType = Int32), @p144='?', @p145='?' (DbType = Int32), @p146='?' (DbType = Boolean), @p147='?' (DbType = DateTime), @p148='?' (DbType = Int32), @p149='?' (DbType = Decimal), @p150='?' (DbType = DateTime), @p151='?' (DbType = DateTime), @p152='?', @p153='?' (DbType = Int32), @p154='?' (DbType = Int32), @p155='?', @p156='?' (DbType = Int32), @p157='?' (DbType = Boolean), @p158='?' (DbType = DateTime), @p159='?' (DbType = Int32), @p160='?' (DbType = Decimal), @p161='?' (DbType = DateTime), @p162='?' (DbType = DateTime), @p163='?', @p164='?' (DbType = Int32), @p165='?' (DbType = Int32), @p166='?', @p167='?' (DbType = Int32), @p168='?' (DbType = Boolean), @p169='?' (DbType = DateTime), @p170='?' (DbType = Int32), @p171='?' (DbType = Decimal), @p172='?' (DbType = DateTime), @p173='?' (DbType = DateTime), @p174='?', @p175='?' (DbType = Int32), @p176='?' (DbType = Int32), @p177='?', @p178='?' (DbType = Int32), @p179='?' (DbType = Boolean), @p180='?' (DbType = DateTime), @p181='?' (DbType = Int32), @p182='?' (DbType = Decimal), @p183='?' (DbType = DateTime), @p184='?' (DbType = DateTime), @p185='?', @p186='?' (DbType = Int32), @p187='?' (DbType = Int32), @p188='?', @p189='?' (DbType = Int32), @p190='?' (DbType = Boolean), @p191='?' (DbType = DateTime), @p192='?' (DbType = Int32), @p193='?' (DbType = Decimal), @p194='?' (DbType = DateTime), @p195='?' (DbType = DateTime), @p196='?', @p197='?' (DbType = Int32), @p198='?' (DbType = Int32), @p199='?', @p200='?' (DbType = Int32), @p201='?' (DbType = Boolean), @p202='?' (DbType = DateTime), @p203='?' (DbType = Int32), @p204='?' (DbType = Decimal), @p205='?' (DbType = DateTime), @p206='?' (DbType = DateTime), @p207='?', @p208='?' (DbType = Int32), @p209='?' (DbType = Int32), @p210='?', @p211='?' (DbType = Int32), @p212='?' (DbType = Boolean), @p213='?' (DbType = DateTime), @p214='?' (DbType = Int32), @p215='?' (DbType = Decimal), @p216='?' (DbType = DateTime), @p217='?' (DbType = DateTime), @p218='?', @p219='?' (DbType = Int32), @p220='?' (DbType = Int32), @p221='?', @p222='?' (DbType = Int32), @p223='?' (DbType = Boolean), @p224='?' (DbType = DateTime), @p225='?' (DbType = Int32), @p226='?' (DbType = Decimal), @p227='?' (DbType = DateTime), @p228='?' (DbType = DateTime), @p229='?', @p230='?' (DbType = Int32), @p231='?' (DbType = Int32), @p232='?', @p233='?' (DbType = Int32), @p234='?' (DbType = Boolean), @p235='?' (DbType = DateTime), @p236='?' (DbType = Int32), @p237='?' (DbType = Decimal), @p238='?' (DbType = DateTime), @p239='?' (DbType = DateTime), @p240='?', @p241='?' (DbType = Int32), @p242='?' (DbType = Int32), @p243='?', @p244='?' (DbType = Int32), @p245='?' (DbType = Boolean), @p246='?' (DbType = DateTime), @p247='?' (DbType = Int32), @p248='?' (DbType = Decimal), @p249='?' (DbType = DateTime), @p250='?' (DbType = DateTime), @p251='?', @p252='?' (DbType = Int32), @p253='?' (DbType = Int32), @p254='?', @p255='?' (DbType = Int32), @p256='?' (DbType = Boolean), @p257='?' (DbType = DateTime), @p258='?' (DbType = Int32), @p259='?' (DbType = Decimal), @p260='?' (DbType = DateTime), @p261='?' (DbType = DateTime), @p262='?', @p263='?' (DbType = Int32), @p264='?' (DbType = Int32), @p265='?', @p266='?' (DbType = Int32), @p267='?' (DbType = Boolean), @p268='?' (DbType = DateTime), @p269='?' (DbType = Int32), @p270='?' (DbType = Decimal), @p271='?' (DbType = DateTime), @p272='?' (DbType = DateTime), @p273='?', @p274='?' (DbType = Int32), @p275='?' (DbType = Int32), @p276='?', @p277='?' (DbType = Int32), @p278='?' (DbType = Boolean), @p279='?' (DbType = DateTime), @p280='?' (DbType = Int32), @p281='?' (DbType = Decimal), @p282='?' (DbType = DateTime), @p283='?' (DbType = DateTime), @p284='?', @p285='?' (DbType = Int32), @p286='?' (DbType = Int32), @p287='?', @p288='?' (DbType = Int32), @p289='?' (DbType = Boolean), @p290='?' (DbType = DateTime), @p291='?' (DbType = Int32), @p292='?' (DbType = Decimal), @p293='?' (DbType = DateTime), @p294='?' (DbType = DateTime), @p295='?', @p296='?' (DbType = Int32), @p297='?' (DbType = Int32), @p298='?', @p299='?' (DbType = Int32), @p300='?' (DbType = Boolean), @p301='?' (DbType = DateTime), @p302='?' (DbType = Int32), @p303='?' (DbType = Decimal), @p304='?' (DbType = DateTime), @p305='?' (DbType = DateTime), @p306='?', @p307='?' (DbType = Int32), @p308='?' (DbType = Int32), @p309='?', @p310='?' (DbType = Int32), @p311='?' (DbType = Boolean), @p312='?' (DbType = DateTime), @p313='?' (DbType = Int32), @p314='?' (DbType = Decimal), @p315='?' (DbType = DateTime), @p316='?' (DbType = DateTime), @p317='?', @p318='?' (DbType = Int32), @p319='?' (DbType = Int32), @p320='?', @p321='?' (DbType = Int32), @p322='?' (DbType = Boolean), @p323='?' (DbType = DateTime), @p324='?' (DbType = Int32), @p325='?' (DbType = Decimal), @p326='?' (DbType = DateTime), @p327='?' (DbType = DateTime), @p328='?', @p329='?' (DbType = Int32), @p330='?' (DbType = Int32), @p331='?', @p332='?' (DbType = Int32), @p333='?' (DbType = Boolean), @p334='?' (DbType = DateTime), @p335='?' (DbType = Int32), @p336='?' (DbType = Decimal), @p337='?' (DbType = DateTime), @p338='?' (DbType = DateTime), @p339='?', @p340='?' (DbType = Int32), @p341='?' (DbType = Int32), @p342='?', @p343='?' (DbType = Int32), @p344='?' (DbType = Boolean), @p345='?' (DbType = DateTime), @p346='?' (DbType = Int32), @p347='?' (DbType = Decimal), @p348='?' (DbType = DateTime), @p349='?' (DbType = DateTime), @p350='?', @p351='?' (DbType = Int32), @p352='?' (DbType = Int32), @p353='?', @p354='?' (DbType = Int32), @p355='?' (DbType = Boolean), @p356='?' (DbType = DateTime), @p357='?' (DbType = Int32), @p358='?' (DbType = Decimal), @p359='?' (DbType = DateTime), @p360='?' (DbType = DateTime), @p361='?', @p362='?' (DbType = Int32), @p363='?' (DbType = Int32), @p364='?', @p365='?' (DbType = Int32), @p366='?' (DbType = Boolean), @p367='?' (DbType = DateTime), @p368='?' (DbType = Int32), @p369='?' (DbType = Decimal), @p370='?' (DbType = DateTime), @p371='?' (DbType = DateTime), @p372='?', @p373='?' (DbType = Int32), @p374='?' (DbType = Int32), @p375='?', @p376='?' (DbType = Int32), @p377='?' (DbType = Boolean), @p378='?' (DbType = DateTime), @p379='?' (DbType = Int32), @p380='?' (DbType = Decimal), @p381='?' (DbType = DateTime), @p382='?' (DbType = DateTime), @p383='?', @p384='?' (DbType = Int32), @p385='?' (DbType = Int32), @p386='?', @p387='?' (DbType = Int32), @p388='?' (DbType = Boolean), @p389='?' (DbType = DateTime), @p390='?' (DbType = Int32), @p391='?' (DbType = Decimal), @p392='?' (DbType = DateTime), @p393='?' (DbType = DateTime), @p394='?', @p395='?' (DbType = Int32), @p396='?' (DbType = Int32), @p397='?', @p398='?' (DbType = Int32), @p399='?' (DbType = Boolean), @p400='?' (DbType = DateTime), @p401='?' (DbType = Int32), @p402='?' (DbType = Decimal), @p403='?' (DbType = DateTime), @p404='?' (DbType = DateTime), @p405='?', @p406='?' (DbType = Int32), @p407='?' (DbType = Int32), @p408='?', @p409='?' (DbType = Int32), @p410='?' (DbType = Boolean), @p411='?' (DbType = DateTime), @p412='?' (DbType = Int32), @p413='?' (DbType = Decimal), @p414='?' (DbType = DateTime), @p415='?' (DbType = DateTime), @p416='?', @p417='?' (DbType = Int32), @p418='?' (DbType = Int32), @p419='?', @p420='?' (DbType = Int32), @p421='?' (DbType = Boolean), @p422='?' (DbType = DateTime), @p423='?' (DbType = Int32), @p424='?' (DbType = Decimal), @p425='?' (DbType = DateTime), @p426='?' (DbType = DateTime), @p427='?', @p428='?' (DbType = Int32), @p429='?' (DbType = Int32), @p430='?', @p431='?' (DbType = Int32), @p432='?' (DbType = Boolean), @p433='?' (DbType = DateTime), @p434='?' (DbType = Int32), @p435='?' (DbType = Decimal), @p436='?' (DbType = DateTime), @p437='?' (DbType = DateTime), @p438='?', @p439='?' (DbType = Int32), @p440='?' (DbType = Int32), @p441='?', @p442='?' (DbType = Int32), @p443='?' (DbType = Boolean), @p444='?' (DbType = DateTime), @p445='?' (DbType = Int32), @p446='?' (DbType = Decimal), @p447='?' (DbType = DateTime), @p448='?' (DbType = DateTime), @p449='?', @p450='?' (DbType = Int32), @p451='?' (DbType = Int32), @p452='?', @p453='?' (DbType = Int32), @p454='?' (DbType = Boolean), @p455='?' (DbType = DateTime), @p456='?' (DbType = Int32), @p457='?' (DbType = Decimal), @p458='?' (DbType = DateTime), @p459='?' (DbType = DateTime), @p460='?', @p461='?' (DbType = Int32), @p462='?' (DbType = Int32), @p463='?', @p464='?' (DbType = Int32), @p465='?' (DbType = Boolean), @p466='?' (DbType = DateTime), @p467='?' (DbType = Int32), @p468='?' (DbType = Decimal), @p469='?' (DbType = DateTime), @p470='?' (DbType = DateTime), @p471='?', @p472='?' (DbType = Int32), @p473='?' (DbType = Int32), @p474='?', @p475='?' (DbType = Int32), @p476='?' (DbType = Boolean), @p477='?' (DbType = DateTime), @p478='?' (DbType = Int32), @p479='?' (DbType = Decimal), @p480='?' (DbType = DateTime), @p481='?' (DbType = DateTime), @p482='?', @p483='?' (DbType = Int32), @p484='?' (DbType = Int32), @p485='?', @p486='?' (DbType = Int32), @p487='?' (DbType = Boolean), @p488='?' (DbType = DateTime), @p489='?' (DbType = Int32), @p490='?' (DbType = Decimal), @p491='?' (DbType = DateTime), @p492='?' (DbType = DateTime), @p493='?', @p494='?' (DbType = Int32), @p495='?' (DbType = Int32), @p496='?', @p497='?' (DbType = Int32), @p498='?' (DbType = Boolean), @p499='?' (DbType = DateTime), @p500='?' (DbType = Int32), @p501='?' (DbType = Decimal), @p502='?' (DbType = DateTime), @p503='?' (DbType = DateTime), @p504='?', @p505='?' (DbType = Int32), @p506='?' (DbType = Int32), @p507='?', @p508='?' (DbType = Int32), @p509='?' (DbType = Boolean), @p510='?' (DbType = DateTime), @p511='?' (DbType = Int32), @p512='?' (DbType = Decimal), @p513='?' (DbType = DateTime), @p514='?' (DbType = DateTime), @p515='?', @p516='?' (DbType = Int32), @p517='?' (DbType = Int32), @p518='?', @p519='?' (DbType = Int32), @p520='?' (DbType = Boolean), @p521='?' (DbType = DateTime), @p522='?' (DbType = Int32), @p523='?' (DbType = Decimal), @p524='?' (DbType = DateTime), @p525='?' (DbType = DateTime), @p526='?', @p527='?' (DbType = Int32), @p528='?' (DbType = Int32), @p529='?', @p530='?' (DbType = Int32), @p531='?' (DbType = Boolean), @p532='?' (DbType = DateTime), @p533='?' (DbType = Int32), @p534='?' (DbType = Decimal), @p535='?' (DbType = DateTime), @p536='?' (DbType = DateTime), @p537='?', @p538='?' (DbType = Int32), @p539='?' (DbType = Int32), @p540='?', @p541='?' (DbType = Int32), @p542='?' (DbType = Boolean), @p543='?' (DbType = DateTime), @p544='?' (DbType = Int32), @p545='?' (DbType = Decimal), @p546='?' (DbType = DateTime), @p547='?' (DbType = DateTime), @p548='?', @p549='?' (DbType = Int32), @p550='?' (DbType = Int32), @p551='?', @p552='?' (DbType = Int32), @p553='?' (DbType = Boolean), @p554='?' (DbType = DateTime), @p555='?' (DbType = Int32), @p556='?' (DbType = Decimal), @p557='?' (DbType = DateTime), @p558='?' (DbType = DateTime), @p559='?', @p560='?' (DbType = Int32), @p561='?' (DbType = Int32), @p562='?', @p563='?' (DbType = Int32), @p564='?' (DbType = Boolean), @p565='?' (DbType = DateTime), @p566='?' (DbType = Int32), @p567='?' (DbType = Decimal), @p568='?' (DbType = DateTime), @p569='?' (DbType = DateTime), @p570='?', @p571='?' (DbType = Int32), @p572='?' (DbType = Int32), @p573='?', @p574='?' (DbType = Int32), @p575='?' (DbType = Boolean), @p576='?' (DbType = DateTime), @p577='?' (DbType = Int32), @p578='?' (DbType = Decimal), @p579='?' (DbType = DateTime), @p592='?' (DbType = Int32), @p580='?' (DbType = DateTime), @p581='?', @p582='?' (DbType = DateTime), @p583='?', @p584='?', @p585='?', @p586='?', @p587='?', @p588='?' (DbType = Int32), @p589='?', @p590='?' (DbType = Int32), @p591='?' (DbType = DateTime), @p605='?' (DbType = Int32), @p593='?' (DbType = DateTime), @p594='?', @p595='?' (DbType = DateTime), @p596='?', @p597='?', @p598='?', @p599='?', @p600='?', @p601='?' (DbType = Int32), @p602='?', @p603='?' (DbType = Int32), @p604='?' (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
UPDATE "ExportFiles" SET "CountAll" = @p0, "CountSuccessful" = @p1, "CreateTime" = @p2, "FileName" = @p3, "Hash" = @p4
WHERE "Id" = @p5;
UPDATE "Flats" SET "AccountNumber" = @p6, "AccountNumber2" = @p7, "AccountNumber3" = @p8, "AdminFees" = @p9, "Apartment" = @p10, "Balance" = @p11, "Building" = @p12, "City" = @p13, "CountParkingSpots" = @p14, "CountRooms" = @p15, "CreateTime" = @p16, "Deposit" = @p17, "Description" = @p18, "Floor" = @p19, "HasBalcony" = @p20, "HasTerrace" = @p21, "InternalId" = @p22, "LandlordId" = @p23, "PetAllowed" = @p24, "Postcode" = @p25, "Price" = @p26, "Size" = @p27, "Street" = @p28, "Title" = @p29, "UpdateTime" = @p30, "YearBuilt" = @p31
WHERE "Id" = @p32;
UPDATE "Landlords" SET "AccountNumber" = @p33, "Balance" = @p34, "Comment" = @p35
WHERE "Id" = @p36;
UPDATE "Landlords" SET "AccountNumber" = @p37, "Balance" = @p38, "Comment" = @p39
WHERE "Id" = @p40;
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p52, @p53, @p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p63, @p64, @p65, @p66, @p67, @p68, @p69, @p70, @p71, @p72, @p73)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p74, @p75, @p76, @p77, @p78, @p79, @p80, @p81, @p82, @p83, @p84)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p85, @p86, @p87, @p88, @p89, @p90, @p91, @p92, @p93, @p94, @p95)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p96, @p97, @p98, @p99, @p100, @p101, @p102, @p103, @p104, @p105, @p106)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p107, @p108, @p109, @p110, @p111, @p112, @p113, @p114, @p115, @p116, @p117)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p118, @p119, @p120, @p121, @p122, @p123, @p124, @p125, @p126, @p127, @p128)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p129, @p130, @p131, @p132, @p133, @p134, @p135, @p136, @p137, @p138, @p139)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p140, @p141, @p142, @p143, @p144, @p145, @p146, @p147, @p148, @p149, @p150)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p151, @p152, @p153, @p154, @p155, @p156, @p157, @p158, @p159, @p160, @p161)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p162, @p163, @p164, @p165, @p166, @p167, @p168, @p169, @p170, @p171, @p172)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p173, @p174, @p175, @p176, @p177, @p178, @p179, @p180, @p181, @p182, @p183)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p184, @p185, @p186, @p187, @p188, @p189, @p190, @p191, @p192, @p193, @p194)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p195, @p196, @p197, @p198, @p199, @p200, @p201, @p202, @p203, @p204, @p205)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p206, @p207, @p208, @p209, @p210, @p211, @p212, @p213, @p214, @p215, @p216)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p217, @p218, @p219, @p220, @p221, @p222, @p223, @p224, @p225, @p226, @p227)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p228, @p229, @p230, @p231, @p232, @p233, @p234, @p235, @p236, @p237, @p238)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p239, @p240, @p241, @p242, @p243, @p244, @p245, @p246, @p247, @p248, @p249)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p250, @p251, @p252, @p253, @p254, @p255, @p256, @p257, @p258, @p259, @p260)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p261, @p262, @p263, @p264, @p265, @p266, @p267, @p268, @p269, @p270, @p271)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p272, @p273, @p274, @p275, @p276, @p277, @p278, @p279, @p280, @p281, @p282)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p283, @p284, @p285, @p286, @p287, @p288, @p289, @p290, @p291, @p292, @p293)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p294, @p295, @p296, @p297, @p298, @p299, @p300, @p301, @p302, @p303, @p304)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p305, @p306, @p307, @p308, @p309, @p310, @p311, @p312, @p313, @p314, @p315)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p316, @p317, @p318, @p319, @p320, @p321, @p322, @p323, @p324, @p325, @p326)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p327, @p328, @p329, @p330, @p331, @p332, @p333, @p334, @p335, @p336, @p337)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p338, @p339, @p340, @p341, @p342, @p343, @p344, @p345, @p346, @p347, @p348)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p349, @p350, @p351, @p352, @p353, @p354, @p355, @p356, @p357, @p358, @p359)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p360, @p361, @p362, @p363, @p364, @p365, @p366, @p367, @p368, @p369, @p370)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p371, @p372, @p373, @p374, @p375, @p376, @p377, @p378, @p379, @p380, @p381)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p382, @p383, @p384, @p385, @p386, @p387, @p388, @p389, @p390, @p391, @p392)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p393, @p394, @p395, @p396, @p397, @p398, @p399, @p400, @p401, @p402, @p403)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p404, @p405, @p406, @p407, @p408, @p409, @p410, @p411, @p412, @p413, @p414)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p415, @p416, @p417, @p418, @p419, @p420, @p421, @p422, @p423, @p424, @p425)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p426, @p427, @p428, @p429, @p430, @p431, @p432, @p433, @p434, @p435, @p436)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p437, @p438, @p439, @p440, @p441, @p442, @p443, @p444, @p445, @p446, @p447)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p448, @p449, @p450, @p451, @p452, @p453, @p454, @p455, @p456, @p457, @p458)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p459, @p460, @p461, @p462, @p463, @p464, @p465, @p466, @p467, @p468, @p469)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p470, @p471, @p472, @p473, @p474, @p475, @p476, @p477, @p478, @p479, @p480)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p481, @p482, @p483, @p484, @p485, @p486, @p487, @p488, @p489, @p490, @p491)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p492, @p493, @p494, @p495, @p496, @p497, @p498, @p499, @p500, @p501, @p502)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p503, @p504, @p505, @p506, @p507, @p508, @p509, @p510, @p511, @p512, @p513)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p514, @p515, @p516, @p517, @p518, @p519, @p520, @p521, @p522, @p523, @p524)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p525, @p526, @p527, @p528, @p529, @p530, @p531, @p532, @p533, @p534, @p535)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p536, @p537, @p538, @p539, @p540, @p541, @p542, @p543, @p544, @p545, @p546)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p547, @p548, @p549, @p550, @p551, @p552, @p553, @p554, @p555, @p556, @p557)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p558, @p559, @p560, @p561, @p562, @p563, @p564, @p565, @p566, @p567, @p568)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p569, @p570, @p571, @p572, @p573, @p574, @p575, @p576, @p577, @p578, @p579)
RETURNING "Id";
UPDATE "Users" SET "CreateTime" = @p580, "Email" = @p581, "ExpiresAt" = @p582, "FirstName" = @p583, "LastName" = @p584, "PasswordHash" = @p585, "PhoneNumber" = @p586, "RefreshToken" = @p587, "Role" = @p588, "Salt" = @p589, "Status" = @p590, "UpdateTime" = @p591
WHERE "Id" = @p592;
UPDATE "Users" SET "CreateTime" = @p593, "Email" = @p594, "ExpiresAt" = @p595, "FirstName" = @p596, "LastName" = @p597, "PasswordHash" = @p598, "PhoneNumber" = @p599, "RefreshToken" = @p600, "Role" = @p601, "Salt" = @p602, "Status" = @p603, "UpdateTime" = @p604
WHERE "Id" = @p605;
[2025-04-01 20:33:51 ERR] An exception occurred in the database while saving changes for context type 'DAL.EF.EFDbContext'.
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.
 ---> System.InvalidCastException: Cannot write DateTime with Kind=Unspecified to PostgreSQL type 'timestamp with time zone', only UTC is supported. Note that it's not possible to mix DateTimes with different Kinds in an array/range. See the Npgsql.EnableLegacyTimestampBehavior AppContext switch to enable legacy behavior.
   at Npgsql.Internal.TypeHandlers.DateTimeHandlers.TimestampTzHandler.ValidateAndGetLength(DateTime value, NpgsqlParameter parameter)
   at Npgsql.Internal.TypeHandlers.DateTimeHandlers.TimestampTzHandler.ValidateObjectAndGetLength(Object value, NpgsqlLengthCache& lengthCache, NpgsqlParameter parameter)
   at Npgsql.NpgsqlParameter.ValidateAndGetLength()
   at Npgsql.NpgsqlParameterCollection.ValidateAndBind(ConnectorTypeMapper typeMapper)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(StateManager stateManager, Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.<>c.<SaveChanges>b__104_0(DbContext _, ValueTuple`2 t)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.
 ---> System.InvalidCastException: Cannot write DateTime with Kind=Unspecified to PostgreSQL type 'timestamp with time zone', only UTC is supported. Note that it's not possible to mix DateTimes with different Kinds in an array/range. See the Npgsql.EnableLegacyTimestampBehavior AppContext switch to enable legacy behavior.
   at Npgsql.Internal.TypeHandlers.DateTimeHandlers.TimestampTzHandler.ValidateAndGetLength(DateTime value, NpgsqlParameter parameter)
   at Npgsql.Internal.TypeHandlers.DateTimeHandlers.TimestampTzHandler.ValidateObjectAndGetLength(Object value, NpgsqlLengthCache& lengthCache, NpgsqlParameter parameter)
   at Npgsql.NpgsqlParameter.ValidateAndGetLength()
   at Npgsql.NpgsqlParameterCollection.ValidateAndBind(ConnectorTypeMapper typeMapper)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(StateManager stateManager, Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.<>c.<SaveChanges>b__104_0(DbContext _, ValueTuple`2 t)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
[2025-04-01 20:40:35 ERR] Failed executing DbCommand (1ms) [Parameters=[@p5='?' (DbType = Int32), @p0='?' (DbType = Int32), @p1='?' (DbType = Int32), @p2='?' (DbType = DateTime), @p3='?', @p4='?', @p32='?' (DbType = Int32), @p6='?', @p7='?', @p8='?', @p9='?' (DbType = Decimal), @p10='?', @p11='?' (DbType = Decimal), @p12='?', @p13='?', @p14='?' (DbType = Int32), @p15='?' (DbType = Int32), @p16='?' (DbType = DateTime), @p17='?' (DbType = Decimal), @p18='?', @p19='?' (DbType = Double), @p20='?' (DbType = Boolean), @p21='?' (DbType = Boolean), @p22='?' (DbType = Int32), @p23='?' (DbType = Int32), @p24='?' (DbType = Boolean), @p25='?', @p26='?' (DbType = Decimal), @p27='?' (DbType = Double), @p28='?', @p29='?', @p30='?' (DbType = DateTime), @p31='?' (DbType = DateTime), @p36='?' (DbType = Int32), @p33='?', @p34='?' (DbType = Decimal), @p35='?', @p40='?' (DbType = Int32), @p37='?', @p38='?' (DbType = Decimal), @p39='?', @p41='?' (DbType = DateTime), @p42='?', @p43='?' (DbType = Int32), @p44='?' (DbType = Int32), @p45='?', @p46='?' (DbType = Int32), @p47='?' (DbType = Boolean), @p48='?' (DbType = DateTime), @p49='?' (DbType = Int32), @p50='?' (DbType = Decimal), @p51='?' (DbType = DateTime), @p52='?' (DbType = DateTime), @p53='?', @p54='?' (DbType = Int32), @p55='?' (DbType = Int32), @p56='?', @p57='?' (DbType = Int32), @p58='?' (DbType = Boolean), @p59='?' (DbType = DateTime), @p60='?' (DbType = Int32), @p61='?' (DbType = Decimal), @p62='?' (DbType = DateTime), @p63='?' (DbType = DateTime), @p64='?', @p65='?' (DbType = Int32), @p66='?' (DbType = Int32), @p67='?', @p68='?' (DbType = Int32), @p69='?' (DbType = Boolean), @p70='?' (DbType = DateTime), @p71='?' (DbType = Int32), @p72='?' (DbType = Decimal), @p73='?' (DbType = DateTime), @p74='?' (DbType = DateTime), @p75='?', @p76='?' (DbType = Int32), @p77='?' (DbType = Int32), @p78='?', @p79='?' (DbType = Int32), @p80='?' (DbType = Boolean), @p81='?' (DbType = DateTime), @p82='?' (DbType = Int32), @p83='?' (DbType = Decimal), @p84='?' (DbType = DateTime), @p85='?' (DbType = DateTime), @p86='?', @p87='?' (DbType = Int32), @p88='?' (DbType = Int32), @p89='?', @p90='?' (DbType = Int32), @p91='?' (DbType = Boolean), @p92='?' (DbType = DateTime), @p93='?' (DbType = Int32), @p94='?' (DbType = Decimal), @p95='?' (DbType = DateTime), @p96='?' (DbType = DateTime), @p97='?', @p98='?' (DbType = Int32), @p99='?' (DbType = Int32), @p100='?', @p101='?' (DbType = Int32), @p102='?' (DbType = Boolean), @p103='?' (DbType = DateTime), @p104='?' (DbType = Int32), @p105='?' (DbType = Decimal), @p106='?' (DbType = DateTime), @p107='?' (DbType = DateTime), @p108='?', @p109='?' (DbType = Int32), @p110='?' (DbType = Int32), @p111='?', @p112='?' (DbType = Int32), @p113='?' (DbType = Boolean), @p114='?' (DbType = DateTime), @p115='?' (DbType = Int32), @p116='?' (DbType = Decimal), @p117='?' (DbType = DateTime), @p118='?' (DbType = DateTime), @p119='?', @p120='?' (DbType = Int32), @p121='?' (DbType = Int32), @p122='?', @p123='?' (DbType = Int32), @p124='?' (DbType = Boolean), @p125='?' (DbType = DateTime), @p126='?' (DbType = Int32), @p127='?' (DbType = Decimal), @p128='?' (DbType = DateTime), @p129='?' (DbType = DateTime), @p130='?', @p131='?' (DbType = Int32), @p132='?' (DbType = Int32), @p133='?', @p134='?' (DbType = Int32), @p135='?' (DbType = Boolean), @p136='?' (DbType = DateTime), @p137='?' (DbType = Int32), @p138='?' (DbType = Decimal), @p139='?' (DbType = DateTime), @p140='?' (DbType = DateTime), @p141='?', @p142='?' (DbType = Int32), @p143='?' (DbType = Int32), @p144='?', @p145='?' (DbType = Int32), @p146='?' (DbType = Boolean), @p147='?' (DbType = DateTime), @p148='?' (DbType = Int32), @p149='?' (DbType = Decimal), @p150='?' (DbType = DateTime), @p151='?' (DbType = DateTime), @p152='?', @p153='?' (DbType = Int32), @p154='?' (DbType = Int32), @p155='?', @p156='?' (DbType = Int32), @p157='?' (DbType = Boolean), @p158='?' (DbType = DateTime), @p159='?' (DbType = Int32), @p160='?' (DbType = Decimal), @p161='?' (DbType = DateTime), @p162='?' (DbType = DateTime), @p163='?', @p164='?' (DbType = Int32), @p165='?' (DbType = Int32), @p166='?', @p167='?' (DbType = Int32), @p168='?' (DbType = Boolean), @p169='?' (DbType = DateTime), @p170='?' (DbType = Int32), @p171='?' (DbType = Decimal), @p172='?' (DbType = DateTime), @p173='?' (DbType = DateTime), @p174='?', @p175='?' (DbType = Int32), @p176='?' (DbType = Int32), @p177='?', @p178='?' (DbType = Int32), @p179='?' (DbType = Boolean), @p180='?' (DbType = DateTime), @p181='?' (DbType = Int32), @p182='?' (DbType = Decimal), @p183='?' (DbType = DateTime), @p184='?' (DbType = DateTime), @p185='?', @p186='?' (DbType = Int32), @p187='?' (DbType = Int32), @p188='?', @p189='?' (DbType = Int32), @p190='?' (DbType = Boolean), @p191='?' (DbType = DateTime), @p192='?' (DbType = Int32), @p193='?' (DbType = Decimal), @p194='?' (DbType = DateTime), @p195='?' (DbType = DateTime), @p196='?', @p197='?' (DbType = Int32), @p198='?' (DbType = Int32), @p199='?', @p200='?' (DbType = Int32), @p201='?' (DbType = Boolean), @p202='?' (DbType = DateTime), @p203='?' (DbType = Int32), @p204='?' (DbType = Decimal), @p205='?' (DbType = DateTime), @p206='?' (DbType = DateTime), @p207='?', @p208='?' (DbType = Int32), @p209='?' (DbType = Int32), @p210='?', @p211='?' (DbType = Int32), @p212='?' (DbType = Boolean), @p213='?' (DbType = DateTime), @p214='?' (DbType = Int32), @p215='?' (DbType = Decimal), @p216='?' (DbType = DateTime), @p217='?' (DbType = DateTime), @p218='?', @p219='?' (DbType = Int32), @p220='?' (DbType = Int32), @p221='?', @p222='?' (DbType = Int32), @p223='?' (DbType = Boolean), @p224='?' (DbType = DateTime), @p225='?' (DbType = Int32), @p226='?' (DbType = Decimal), @p227='?' (DbType = DateTime), @p228='?' (DbType = DateTime), @p229='?', @p230='?' (DbType = Int32), @p231='?' (DbType = Int32), @p232='?', @p233='?' (DbType = Int32), @p234='?' (DbType = Boolean), @p235='?' (DbType = DateTime), @p236='?' (DbType = Int32), @p237='?' (DbType = Decimal), @p238='?' (DbType = DateTime), @p239='?' (DbType = DateTime), @p240='?', @p241='?' (DbType = Int32), @p242='?' (DbType = Int32), @p243='?', @p244='?' (DbType = Int32), @p245='?' (DbType = Boolean), @p246='?' (DbType = DateTime), @p247='?' (DbType = Int32), @p248='?' (DbType = Decimal), @p249='?' (DbType = DateTime), @p250='?' (DbType = DateTime), @p251='?', @p252='?' (DbType = Int32), @p253='?' (DbType = Int32), @p254='?', @p255='?' (DbType = Int32), @p256='?' (DbType = Boolean), @p257='?' (DbType = DateTime), @p258='?' (DbType = Int32), @p259='?' (DbType = Decimal), @p260='?' (DbType = DateTime), @p261='?' (DbType = DateTime), @p262='?', @p263='?' (DbType = Int32), @p264='?' (DbType = Int32), @p265='?', @p266='?' (DbType = Int32), @p267='?' (DbType = Boolean), @p268='?' (DbType = DateTime), @p269='?' (DbType = Int32), @p270='?' (DbType = Decimal), @p271='?' (DbType = DateTime), @p272='?' (DbType = DateTime), @p273='?', @p274='?' (DbType = Int32), @p275='?' (DbType = Int32), @p276='?', @p277='?' (DbType = Int32), @p278='?' (DbType = Boolean), @p279='?' (DbType = DateTime), @p280='?' (DbType = Int32), @p281='?' (DbType = Decimal), @p282='?' (DbType = DateTime), @p283='?' (DbType = DateTime), @p284='?', @p285='?' (DbType = Int32), @p286='?' (DbType = Int32), @p287='?', @p288='?' (DbType = Int32), @p289='?' (DbType = Boolean), @p290='?' (DbType = DateTime), @p291='?' (DbType = Int32), @p292='?' (DbType = Decimal), @p293='?' (DbType = DateTime), @p294='?' (DbType = DateTime), @p295='?', @p296='?' (DbType = Int32), @p297='?' (DbType = Int32), @p298='?', @p299='?' (DbType = Int32), @p300='?' (DbType = Boolean), @p301='?' (DbType = DateTime), @p302='?' (DbType = Int32), @p303='?' (DbType = Decimal), @p304='?' (DbType = DateTime), @p305='?' (DbType = DateTime), @p306='?', @p307='?' (DbType = Int32), @p308='?' (DbType = Int32), @p309='?', @p310='?' (DbType = Int32), @p311='?' (DbType = Boolean), @p312='?' (DbType = DateTime), @p313='?' (DbType = Int32), @p314='?' (DbType = Decimal), @p315='?' (DbType = DateTime), @p316='?' (DbType = DateTime), @p317='?', @p318='?' (DbType = Int32), @p319='?' (DbType = Int32), @p320='?', @p321='?' (DbType = Int32), @p322='?' (DbType = Boolean), @p323='?' (DbType = DateTime), @p324='?' (DbType = Int32), @p325='?' (DbType = Decimal), @p326='?' (DbType = DateTime), @p327='?' (DbType = DateTime), @p328='?', @p329='?' (DbType = Int32), @p330='?' (DbType = Int32), @p331='?', @p332='?' (DbType = Int32), @p333='?' (DbType = Boolean), @p334='?' (DbType = DateTime), @p335='?' (DbType = Int32), @p336='?' (DbType = Decimal), @p337='?' (DbType = DateTime), @p338='?' (DbType = DateTime), @p339='?', @p340='?' (DbType = Int32), @p341='?' (DbType = Int32), @p342='?', @p343='?' (DbType = Int32), @p344='?' (DbType = Boolean), @p345='?' (DbType = DateTime), @p346='?' (DbType = Int32), @p347='?' (DbType = Decimal), @p348='?' (DbType = DateTime), @p349='?' (DbType = DateTime), @p350='?', @p351='?' (DbType = Int32), @p352='?' (DbType = Int32), @p353='?', @p354='?' (DbType = Int32), @p355='?' (DbType = Boolean), @p356='?' (DbType = DateTime), @p357='?' (DbType = Int32), @p358='?' (DbType = Decimal), @p359='?' (DbType = DateTime), @p360='?' (DbType = DateTime), @p361='?', @p362='?' (DbType = Int32), @p363='?' (DbType = Int32), @p364='?', @p365='?' (DbType = Int32), @p366='?' (DbType = Boolean), @p367='?' (DbType = DateTime), @p368='?' (DbType = Int32), @p369='?' (DbType = Decimal), @p370='?' (DbType = DateTime), @p371='?' (DbType = DateTime), @p372='?', @p373='?' (DbType = Int32), @p374='?' (DbType = Int32), @p375='?', @p376='?' (DbType = Int32), @p377='?' (DbType = Boolean), @p378='?' (DbType = DateTime), @p379='?' (DbType = Int32), @p380='?' (DbType = Decimal), @p381='?' (DbType = DateTime), @p382='?' (DbType = DateTime), @p383='?', @p384='?' (DbType = Int32), @p385='?' (DbType = Int32), @p386='?', @p387='?' (DbType = Int32), @p388='?' (DbType = Boolean), @p389='?' (DbType = DateTime), @p390='?' (DbType = Int32), @p391='?' (DbType = Decimal), @p392='?' (DbType = DateTime), @p393='?' (DbType = DateTime), @p394='?', @p395='?' (DbType = Int32), @p396='?' (DbType = Int32), @p397='?', @p398='?' (DbType = Int32), @p399='?' (DbType = Boolean), @p400='?' (DbType = DateTime), @p401='?' (DbType = Int32), @p402='?' (DbType = Decimal), @p403='?' (DbType = DateTime), @p404='?' (DbType = DateTime), @p405='?', @p406='?' (DbType = Int32), @p407='?' (DbType = Int32), @p408='?', @p409='?' (DbType = Int32), @p410='?' (DbType = Boolean), @p411='?' (DbType = DateTime), @p412='?' (DbType = Int32), @p413='?' (DbType = Decimal), @p414='?' (DbType = DateTime), @p415='?' (DbType = DateTime), @p416='?', @p417='?' (DbType = Int32), @p418='?' (DbType = Int32), @p419='?', @p420='?' (DbType = Int32), @p421='?' (DbType = Boolean), @p422='?' (DbType = DateTime), @p423='?' (DbType = Int32), @p424='?' (DbType = Decimal), @p425='?' (DbType = DateTime), @p426='?' (DbType = DateTime), @p427='?', @p428='?' (DbType = Int32), @p429='?' (DbType = Int32), @p430='?', @p431='?' (DbType = Int32), @p432='?' (DbType = Boolean), @p433='?' (DbType = DateTime), @p434='?' (DbType = Int32), @p435='?' (DbType = Decimal), @p436='?' (DbType = DateTime), @p437='?' (DbType = DateTime), @p438='?', @p439='?' (DbType = Int32), @p440='?' (DbType = Int32), @p441='?', @p442='?' (DbType = Int32), @p443='?' (DbType = Boolean), @p444='?' (DbType = DateTime), @p445='?' (DbType = Int32), @p446='?' (DbType = Decimal), @p447='?' (DbType = DateTime), @p448='?' (DbType = DateTime), @p449='?', @p450='?' (DbType = Int32), @p451='?' (DbType = Int32), @p452='?', @p453='?' (DbType = Int32), @p454='?' (DbType = Boolean), @p455='?' (DbType = DateTime), @p456='?' (DbType = Int32), @p457='?' (DbType = Decimal), @p458='?' (DbType = DateTime), @p459='?' (DbType = DateTime), @p460='?', @p461='?' (DbType = Int32), @p462='?' (DbType = Int32), @p463='?', @p464='?' (DbType = Int32), @p465='?' (DbType = Boolean), @p466='?' (DbType = DateTime), @p467='?' (DbType = Int32), @p468='?' (DbType = Decimal), @p469='?' (DbType = DateTime), @p470='?' (DbType = DateTime), @p471='?', @p472='?' (DbType = Int32), @p473='?' (DbType = Int32), @p474='?', @p475='?' (DbType = Int32), @p476='?' (DbType = Boolean), @p477='?' (DbType = DateTime), @p478='?' (DbType = Int32), @p479='?' (DbType = Decimal), @p480='?' (DbType = DateTime), @p481='?' (DbType = DateTime), @p482='?', @p483='?' (DbType = Int32), @p484='?' (DbType = Int32), @p485='?', @p486='?' (DbType = Int32), @p487='?' (DbType = Boolean), @p488='?' (DbType = DateTime), @p489='?' (DbType = Int32), @p490='?' (DbType = Decimal), @p491='?' (DbType = DateTime), @p492='?' (DbType = DateTime), @p493='?', @p494='?' (DbType = Int32), @p495='?' (DbType = Int32), @p496='?', @p497='?' (DbType = Int32), @p498='?' (DbType = Boolean), @p499='?' (DbType = DateTime), @p500='?' (DbType = Int32), @p501='?' (DbType = Decimal), @p502='?' (DbType = DateTime), @p503='?' (DbType = DateTime), @p504='?', @p505='?' (DbType = Int32), @p506='?' (DbType = Int32), @p507='?', @p508='?' (DbType = Int32), @p509='?' (DbType = Boolean), @p510='?' (DbType = DateTime), @p511='?' (DbType = Int32), @p512='?' (DbType = Decimal), @p513='?' (DbType = DateTime), @p514='?' (DbType = DateTime), @p515='?', @p516='?' (DbType = Int32), @p517='?' (DbType = Int32), @p518='?', @p519='?' (DbType = Int32), @p520='?' (DbType = Boolean), @p521='?' (DbType = DateTime), @p522='?' (DbType = Int32), @p523='?' (DbType = Decimal), @p524='?' (DbType = DateTime), @p525='?' (DbType = DateTime), @p526='?', @p527='?' (DbType = Int32), @p528='?' (DbType = Int32), @p529='?', @p530='?' (DbType = Int32), @p531='?' (DbType = Boolean), @p532='?' (DbType = DateTime), @p533='?' (DbType = Int32), @p534='?' (DbType = Decimal), @p535='?' (DbType = DateTime), @p536='?' (DbType = DateTime), @p537='?', @p538='?' (DbType = Int32), @p539='?' (DbType = Int32), @p540='?', @p541='?' (DbType = Int32), @p542='?' (DbType = Boolean), @p543='?' (DbType = DateTime), @p544='?' (DbType = Int32), @p545='?' (DbType = Decimal), @p546='?' (DbType = DateTime), @p547='?' (DbType = DateTime), @p548='?', @p549='?' (DbType = Int32), @p550='?' (DbType = Int32), @p551='?', @p552='?' (DbType = Int32), @p553='?' (DbType = Boolean), @p554='?' (DbType = DateTime), @p555='?' (DbType = Int32), @p556='?' (DbType = Decimal), @p557='?' (DbType = DateTime), @p558='?' (DbType = DateTime), @p559='?', @p560='?' (DbType = Int32), @p561='?' (DbType = Int32), @p562='?', @p563='?' (DbType = Int32), @p564='?' (DbType = Boolean), @p565='?' (DbType = DateTime), @p566='?' (DbType = Int32), @p567='?' (DbType = Decimal), @p568='?' (DbType = DateTime), @p569='?' (DbType = DateTime), @p570='?', @p571='?' (DbType = Int32), @p572='?' (DbType = Int32), @p573='?', @p574='?' (DbType = Int32), @p575='?' (DbType = Boolean), @p576='?' (DbType = DateTime), @p577='?' (DbType = Int32), @p578='?' (DbType = Decimal), @p579='?' (DbType = DateTime), @p592='?' (DbType = Int32), @p580='?' (DbType = DateTime), @p581='?', @p582='?' (DbType = DateTime), @p583='?', @p584='?', @p585='?', @p586='?', @p587='?', @p588='?' (DbType = Int32), @p589='?', @p590='?' (DbType = Int32), @p591='?' (DbType = DateTime), @p605='?' (DbType = Int32), @p593='?' (DbType = DateTime), @p594='?', @p595='?' (DbType = DateTime), @p596='?', @p597='?', @p598='?', @p599='?', @p600='?', @p601='?' (DbType = Int32), @p602='?', @p603='?' (DbType = Int32), @p604='?' (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
UPDATE "ExportFiles" SET "CountAll" = @p0, "CountSuccessful" = @p1, "CreateTime" = @p2, "FileName" = @p3, "Hash" = @p4
WHERE "Id" = @p5;
UPDATE "Flats" SET "AccountNumber" = @p6, "AccountNumber2" = @p7, "AccountNumber3" = @p8, "AdminFees" = @p9, "Apartment" = @p10, "Balance" = @p11, "Building" = @p12, "City" = @p13, "CountParkingSpots" = @p14, "CountRooms" = @p15, "CreateTime" = @p16, "Deposit" = @p17, "Description" = @p18, "Floor" = @p19, "HasBalcony" = @p20, "HasTerrace" = @p21, "InternalId" = @p22, "LandlordId" = @p23, "PetAllowed" = @p24, "Postcode" = @p25, "Price" = @p26, "Size" = @p27, "Street" = @p28, "Title" = @p29, "UpdateTime" = @p30, "YearBuilt" = @p31
WHERE "Id" = @p32;
UPDATE "Landlords" SET "AccountNumber" = @p33, "Balance" = @p34, "Comment" = @p35
WHERE "Id" = @p36;
UPDATE "Landlords" SET "AccountNumber" = @p37, "Balance" = @p38, "Comment" = @p39
WHERE "Id" = @p40;
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p41, @p42, @p43, @p44, @p45, @p46, @p47, @p48, @p49, @p50, @p51)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p52, @p53, @p54, @p55, @p56, @p57, @p58, @p59, @p60, @p61, @p62)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p63, @p64, @p65, @p66, @p67, @p68, @p69, @p70, @p71, @p72, @p73)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p74, @p75, @p76, @p77, @p78, @p79, @p80, @p81, @p82, @p83, @p84)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p85, @p86, @p87, @p88, @p89, @p90, @p91, @p92, @p93, @p94, @p95)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p96, @p97, @p98, @p99, @p100, @p101, @p102, @p103, @p104, @p105, @p106)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p107, @p108, @p109, @p110, @p111, @p112, @p113, @p114, @p115, @p116, @p117)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p118, @p119, @p120, @p121, @p122, @p123, @p124, @p125, @p126, @p127, @p128)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p129, @p130, @p131, @p132, @p133, @p134, @p135, @p136, @p137, @p138, @p139)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p140, @p141, @p142, @p143, @p144, @p145, @p146, @p147, @p148, @p149, @p150)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p151, @p152, @p153, @p154, @p155, @p156, @p157, @p158, @p159, @p160, @p161)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p162, @p163, @p164, @p165, @p166, @p167, @p168, @p169, @p170, @p171, @p172)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p173, @p174, @p175, @p176, @p177, @p178, @p179, @p180, @p181, @p182, @p183)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p184, @p185, @p186, @p187, @p188, @p189, @p190, @p191, @p192, @p193, @p194)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p195, @p196, @p197, @p198, @p199, @p200, @p201, @p202, @p203, @p204, @p205)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p206, @p207, @p208, @p209, @p210, @p211, @p212, @p213, @p214, @p215, @p216)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p217, @p218, @p219, @p220, @p221, @p222, @p223, @p224, @p225, @p226, @p227)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p228, @p229, @p230, @p231, @p232, @p233, @p234, @p235, @p236, @p237, @p238)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p239, @p240, @p241, @p242, @p243, @p244, @p245, @p246, @p247, @p248, @p249)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p250, @p251, @p252, @p253, @p254, @p255, @p256, @p257, @p258, @p259, @p260)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p261, @p262, @p263, @p264, @p265, @p266, @p267, @p268, @p269, @p270, @p271)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p272, @p273, @p274, @p275, @p276, @p277, @p278, @p279, @p280, @p281, @p282)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p283, @p284, @p285, @p286, @p287, @p288, @p289, @p290, @p291, @p292, @p293)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p294, @p295, @p296, @p297, @p298, @p299, @p300, @p301, @p302, @p303, @p304)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p305, @p306, @p307, @p308, @p309, @p310, @p311, @p312, @p313, @p314, @p315)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p316, @p317, @p318, @p319, @p320, @p321, @p322, @p323, @p324, @p325, @p326)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p327, @p328, @p329, @p330, @p331, @p332, @p333, @p334, @p335, @p336, @p337)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p338, @p339, @p340, @p341, @p342, @p343, @p344, @p345, @p346, @p347, @p348)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p349, @p350, @p351, @p352, @p353, @p354, @p355, @p356, @p357, @p358, @p359)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p360, @p361, @p362, @p363, @p364, @p365, @p366, @p367, @p368, @p369, @p370)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p371, @p372, @p373, @p374, @p375, @p376, @p377, @p378, @p379, @p380, @p381)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p382, @p383, @p384, @p385, @p386, @p387, @p388, @p389, @p390, @p391, @p392)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p393, @p394, @p395, @p396, @p397, @p398, @p399, @p400, @p401, @p402, @p403)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p404, @p405, @p406, @p407, @p408, @p409, @p410, @p411, @p412, @p413, @p414)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p415, @p416, @p417, @p418, @p419, @p420, @p421, @p422, @p423, @p424, @p425)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p426, @p427, @p428, @p429, @p430, @p431, @p432, @p433, @p434, @p435, @p436)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p437, @p438, @p439, @p440, @p441, @p442, @p443, @p444, @p445, @p446, @p447)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p448, @p449, @p450, @p451, @p452, @p453, @p454, @p455, @p456, @p457, @p458)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p459, @p460, @p461, @p462, @p463, @p464, @p465, @p466, @p467, @p468, @p469)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p470, @p471, @p472, @p473, @p474, @p475, @p476, @p477, @p478, @p479, @p480)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p481, @p482, @p483, @p484, @p485, @p486, @p487, @p488, @p489, @p490, @p491)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p492, @p493, @p494, @p495, @p496, @p497, @p498, @p499, @p500, @p501, @p502)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p503, @p504, @p505, @p506, @p507, @p508, @p509, @p510, @p511, @p512, @p513)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p514, @p515, @p516, @p517, @p518, @p519, @p520, @p521, @p522, @p523, @p524)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p525, @p526, @p527, @p528, @p529, @p530, @p531, @p532, @p533, @p534, @p535)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p536, @p537, @p538, @p539, @p540, @p541, @p542, @p543, @p544, @p545, @p546)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p547, @p548, @p549, @p550, @p551, @p552, @p553, @p554, @p555, @p556, @p557)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p558, @p559, @p560, @p561, @p562, @p563, @p564, @p565, @p566, @p567, @p568)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p569, @p570, @p571, @p572, @p573, @p574, @p575, @p576, @p577, @p578, @p579)
RETURNING "Id";
UPDATE "Users" SET "CreateTime" = @p580, "Email" = @p581, "ExpiresAt" = @p582, "FirstName" = @p583, "LastName" = @p584, "PasswordHash" = @p585, "PhoneNumber" = @p586, "RefreshToken" = @p587, "Role" = @p588, "Salt" = @p589, "Status" = @p590, "UpdateTime" = @p591
WHERE "Id" = @p592;
UPDATE "Users" SET "CreateTime" = @p593, "Email" = @p594, "ExpiresAt" = @p595, "FirstName" = @p596, "LastName" = @p597, "PasswordHash" = @p598, "PhoneNumber" = @p599, "RefreshToken" = @p600, "Role" = @p601, "Salt" = @p602, "Status" = @p603, "UpdateTime" = @p604
WHERE "Id" = @p605;
[2025-04-01 20:40:35 ERR] An exception occurred in the database while saving changes for context type 'DAL.EF.EFDbContext'.
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.
 ---> System.InvalidCastException: Cannot write DateTime with Kind=Unspecified to PostgreSQL type 'timestamp with time zone', only UTC is supported. Note that it's not possible to mix DateTimes with different Kinds in an array/range. See the Npgsql.EnableLegacyTimestampBehavior AppContext switch to enable legacy behavior.
   at Npgsql.Internal.TypeHandlers.DateTimeHandlers.TimestampTzHandler.ValidateAndGetLength(DateTime value, NpgsqlParameter parameter)
   at Npgsql.Internal.TypeHandlers.DateTimeHandlers.TimestampTzHandler.ValidateObjectAndGetLength(Object value, NpgsqlLengthCache& lengthCache, NpgsqlParameter parameter)
   at Npgsql.NpgsqlParameter.ValidateAndGetLength()
   at Npgsql.NpgsqlParameterCollection.ValidateAndBind(ConnectorTypeMapper typeMapper)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(StateManager stateManager, Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.<>c.<SaveChanges>b__104_0(DbContext _, ValueTuple`2 t)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.
 ---> System.InvalidCastException: Cannot write DateTime with Kind=Unspecified to PostgreSQL type 'timestamp with time zone', only UTC is supported. Note that it's not possible to mix DateTimes with different Kinds in an array/range. See the Npgsql.EnableLegacyTimestampBehavior AppContext switch to enable legacy behavior.
   at Npgsql.Internal.TypeHandlers.DateTimeHandlers.TimestampTzHandler.ValidateAndGetLength(DateTime value, NpgsqlParameter parameter)
   at Npgsql.Internal.TypeHandlers.DateTimeHandlers.TimestampTzHandler.ValidateObjectAndGetLength(Object value, NpgsqlLengthCache& lengthCache, NpgsqlParameter parameter)
   at Npgsql.NpgsqlParameter.ValidateAndGetLength()
   at Npgsql.NpgsqlParameterCollection.ValidateAndBind(ConnectorTypeMapper typeMapper)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(StateManager stateManager, Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.<>c.<SaveChanges>b__104_0(DbContext _, ValueTuple`2 t)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
[2025-04-01 20:41:21 WRN] No output formatter was found for content types '["application/octet-stream","application/octet-stream"]' to write the response.
[2025-04-01 22:19:53 ERR] Failed executing DbCommand (2ms) [Parameters=[@p5='?' (DbType = Int32), @p0='?' (DbType = Int32), @p1='?' (DbType = Int32), @p2='?' (DbType = DateTime), @p3='?', @p4='?', @p32='?' (DbType = Int32), @p6='?', @p7='?', @p8='?', @p9='?' (DbType = Decimal), @p10='?', @p11='?' (DbType = Decimal), @p12='?', @p13='?', @p14='?' (DbType = Int32), @p15='?' (DbType = Int32), @p16='?' (DbType = DateTime), @p17='?' (DbType = Decimal), @p18='?', @p19='?' (DbType = Double), @p20='?' (DbType = Boolean), @p21='?' (DbType = Boolean), @p22='?' (DbType = Int32), @p23='?' (DbType = Int32), @p24='?' (DbType = Boolean), @p25='?', @p26='?' (DbType = Decimal), @p27='?' (DbType = Double), @p28='?', @p29='?', @p30='?' (DbType = DateTime), @p31='?' (DbType = DateTime), @p59='?' (DbType = Int32), @p33='?', @p34='?', @p35='?', @p36='?' (DbType = Decimal), @p37='?', @p38='?' (DbType = Decimal), @p39='?', @p40='?', @p41='?' (DbType = Int32), @p42='?' (DbType = Int32), @p43='?' (DbType = DateTime), @p44='?' (DbType = Decimal), @p45='?', @p46='?' (DbType = Double), @p47='?' (DbType = Boolean), @p48='?' (DbType = Boolean), @p49='?' (DbType = Int32), @p50='?' (DbType = Int32), @p51='?' (DbType = Boolean), @p52='?', @p53='?' (DbType = Decimal), @p54='?' (DbType = Double), @p55='?', @p56='?', @p57='?' (DbType = DateTime), @p58='?' (DbType = DateTime), @p63='?' (DbType = Int32), @p60='?', @p61='?' (DbType = Decimal), @p62='?', @p67='?' (DbType = Int32), @p64='?', @p65='?' (DbType = Decimal), @p66='?', @p71='?' (DbType = Int32), @p68='?', @p69='?' (DbType = Decimal), @p70='?', @p72='?' (DbType = DateTime), @p73='?', @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?', @p77='?' (DbType = Int32), @p78='?' (DbType = Boolean), @p79='?' (DbType = DateTime), @p80='?' (DbType = Int32), @p81='?' (DbType = Decimal), @p82='?' (DbType = DateTime), @p83='?' (DbType = DateTime), @p84='?', @p85='?' (DbType = Int32), @p86='?' (DbType = Int32), @p87='?', @p88='?' (DbType = Int32), @p89='?' (DbType = Boolean), @p90='?' (DbType = DateTime), @p91='?' (DbType = Int32), @p92='?' (DbType = Decimal), @p93='?' (DbType = DateTime), @p94='?' (DbType = DateTime), @p95='?', @p96='?' (DbType = Int32), @p97='?' (DbType = Int32), @p98='?', @p99='?' (DbType = Int32), @p100='?' (DbType = Boolean), @p101='?' (DbType = DateTime), @p102='?' (DbType = Int32), @p103='?' (DbType = Decimal), @p104='?' (DbType = DateTime), @p105='?' (DbType = DateTime), @p106='?', @p107='?' (DbType = Int32), @p108='?' (DbType = Int32), @p109='?', @p110='?' (DbType = Int32), @p111='?' (DbType = Boolean), @p112='?' (DbType = DateTime), @p113='?' (DbType = Int32), @p114='?' (DbType = Decimal), @p115='?' (DbType = DateTime), @p116='?' (DbType = DateTime), @p117='?', @p118='?' (DbType = Int32), @p119='?' (DbType = Int32), @p120='?', @p121='?' (DbType = Int32), @p122='?' (DbType = Boolean), @p123='?' (DbType = DateTime), @p124='?' (DbType = Int32), @p125='?' (DbType = Decimal), @p126='?' (DbType = DateTime), @p127='?' (DbType = DateTime), @p128='?', @p129='?' (DbType = Int32), @p130='?' (DbType = Int32), @p131='?', @p132='?' (DbType = Int32), @p133='?' (DbType = Boolean), @p134='?' (DbType = DateTime), @p135='?' (DbType = Int32), @p136='?' (DbType = Decimal), @p137='?' (DbType = DateTime), @p138='?' (DbType = DateTime), @p139='?', @p140='?' (DbType = Int32), @p141='?' (DbType = Int32), @p142='?', @p143='?' (DbType = Int32), @p144='?' (DbType = Boolean), @p145='?' (DbType = DateTime), @p146='?' (DbType = Int32), @p147='?' (DbType = Decimal), @p148='?' (DbType = DateTime), @p149='?' (DbType = DateTime), @p150='?', @p151='?' (DbType = Int32), @p152='?' (DbType = Int32), @p153='?', @p154='?' (DbType = Int32), @p155='?' (DbType = Boolean), @p156='?' (DbType = DateTime), @p157='?' (DbType = Int32), @p158='?' (DbType = Decimal), @p159='?' (DbType = DateTime), @p160='?' (DbType = DateTime), @p161='?', @p162='?' (DbType = Int32), @p163='?' (DbType = Int32), @p164='?', @p165='?' (DbType = Int32), @p166='?' (DbType = Boolean), @p167='?' (DbType = DateTime), @p168='?' (DbType = Int32), @p169='?' (DbType = Decimal), @p170='?' (DbType = DateTime), @p171='?' (DbType = DateTime), @p172='?', @p173='?' (DbType = Int32), @p174='?' (DbType = Int32), @p175='?', @p176='?' (DbType = Int32), @p177='?' (DbType = Boolean), @p178='?' (DbType = DateTime), @p179='?' (DbType = Int32), @p180='?' (DbType = Decimal), @p181='?' (DbType = DateTime), @p182='?' (DbType = DateTime), @p183='?', @p184='?' (DbType = Int32), @p185='?' (DbType = Int32), @p186='?', @p187='?' (DbType = Int32), @p188='?' (DbType = Boolean), @p189='?' (DbType = DateTime), @p190='?' (DbType = Int32), @p191='?' (DbType = Decimal), @p192='?' (DbType = DateTime), @p193='?' (DbType = DateTime), @p194='?', @p195='?' (DbType = Int32), @p196='?' (DbType = Int32), @p197='?', @p198='?' (DbType = Int32), @p199='?' (DbType = Boolean), @p200='?' (DbType = DateTime), @p201='?' (DbType = Int32), @p202='?' (DbType = Decimal), @p203='?' (DbType = DateTime), @p204='?' (DbType = DateTime), @p205='?', @p206='?' (DbType = Int32), @p207='?' (DbType = Int32), @p208='?', @p209='?' (DbType = Int32), @p210='?' (DbType = Boolean), @p211='?' (DbType = DateTime), @p212='?' (DbType = Int32), @p213='?' (DbType = Decimal), @p214='?' (DbType = DateTime), @p215='?' (DbType = DateTime), @p216='?', @p217='?' (DbType = Int32), @p218='?' (DbType = Int32), @p219='?', @p220='?' (DbType = Int32), @p221='?' (DbType = Boolean), @p222='?' (DbType = DateTime), @p223='?' (DbType = Int32), @p224='?' (DbType = Decimal), @p225='?' (DbType = DateTime), @p226='?' (DbType = DateTime), @p227='?', @p228='?' (DbType = Int32), @p229='?' (DbType = Int32), @p230='?', @p231='?' (DbType = Int32), @p232='?' (DbType = Boolean), @p233='?' (DbType = DateTime), @p234='?' (DbType = Int32), @p235='?' (DbType = Decimal), @p236='?' (DbType = DateTime), @p237='?' (DbType = DateTime), @p238='?', @p239='?' (DbType = Int32), @p240='?' (DbType = Int32), @p241='?', @p242='?' (DbType = Int32), @p243='?' (DbType = Boolean), @p244='?' (DbType = DateTime), @p245='?' (DbType = Int32), @p246='?' (DbType = Decimal), @p247='?' (DbType = DateTime), @p248='?' (DbType = DateTime), @p249='?', @p250='?' (DbType = Int32), @p251='?' (DbType = Int32), @p252='?', @p253='?' (DbType = Int32), @p254='?' (DbType = Boolean), @p255='?' (DbType = DateTime), @p256='?' (DbType = Int32), @p257='?' (DbType = Decimal), @p258='?' (DbType = DateTime), @p259='?' (DbType = DateTime), @p260='?', @p261='?' (DbType = Int32), @p262='?' (DbType = Int32), @p263='?', @p264='?' (DbType = Int32), @p265='?' (DbType = Boolean), @p266='?' (DbType = DateTime), @p267='?' (DbType = Int32), @p268='?' (DbType = Decimal), @p269='?' (DbType = DateTime), @p270='?' (DbType = DateTime), @p271='?', @p272='?' (DbType = Int32), @p273='?' (DbType = Int32), @p274='?', @p275='?' (DbType = Int32), @p276='?' (DbType = Boolean), @p277='?' (DbType = DateTime), @p278='?' (DbType = Int32), @p279='?' (DbType = Decimal), @p280='?' (DbType = DateTime), @p281='?' (DbType = DateTime), @p282='?', @p283='?' (DbType = Int32), @p284='?' (DbType = Int32), @p285='?', @p286='?' (DbType = Int32), @p287='?' (DbType = Boolean), @p288='?' (DbType = DateTime), @p289='?' (DbType = Int32), @p290='?' (DbType = Decimal), @p291='?' (DbType = DateTime), @p292='?' (DbType = DateTime), @p293='?', @p294='?' (DbType = Int32), @p295='?' (DbType = Int32), @p296='?', @p297='?' (DbType = Int32), @p298='?' (DbType = Boolean), @p299='?' (DbType = DateTime), @p300='?' (DbType = Int32), @p301='?' (DbType = Decimal), @p302='?' (DbType = DateTime), @p303='?' (DbType = DateTime), @p304='?', @p305='?' (DbType = Int32), @p306='?' (DbType = Int32), @p307='?', @p308='?' (DbType = Int32), @p309='?' (DbType = Boolean), @p310='?' (DbType = DateTime), @p311='?' (DbType = Int32), @p312='?' (DbType = Decimal), @p313='?' (DbType = DateTime), @p314='?' (DbType = DateTime), @p315='?', @p316='?' (DbType = Int32), @p317='?' (DbType = Int32), @p318='?', @p319='?' (DbType = Int32), @p320='?' (DbType = Boolean), @p321='?' (DbType = DateTime), @p322='?' (DbType = Int32), @p323='?' (DbType = Decimal), @p324='?' (DbType = DateTime), @p325='?' (DbType = DateTime), @p326='?', @p327='?' (DbType = Int32), @p328='?' (DbType = Int32), @p329='?', @p330='?' (DbType = Int32), @p331='?' (DbType = Boolean), @p332='?' (DbType = DateTime), @p333='?' (DbType = Int32), @p334='?' (DbType = Decimal), @p335='?' (DbType = DateTime), @p336='?' (DbType = DateTime), @p337='?', @p338='?' (DbType = Int32), @p339='?' (DbType = Int32), @p340='?', @p341='?' (DbType = Int32), @p342='?' (DbType = Boolean), @p343='?' (DbType = DateTime), @p344='?' (DbType = Int32), @p345='?' (DbType = Decimal), @p346='?' (DbType = DateTime), @p347='?' (DbType = DateTime), @p348='?', @p349='?' (DbType = Int32), @p350='?' (DbType = Int32), @p351='?', @p352='?' (DbType = Int32), @p353='?' (DbType = Boolean), @p354='?' (DbType = DateTime), @p355='?' (DbType = Int32), @p356='?' (DbType = Decimal), @p357='?' (DbType = DateTime), @p358='?' (DbType = DateTime), @p359='?', @p360='?' (DbType = Int32), @p361='?' (DbType = Int32), @p362='?', @p363='?' (DbType = Int32), @p364='?' (DbType = Boolean), @p365='?' (DbType = DateTime), @p366='?' (DbType = Int32), @p367='?' (DbType = Decimal), @p368='?' (DbType = DateTime), @p369='?' (DbType = DateTime), @p370='?', @p371='?' (DbType = Int32), @p372='?' (DbType = Int32), @p373='?', @p374='?' (DbType = Int32), @p375='?' (DbType = Boolean), @p376='?' (DbType = DateTime), @p377='?' (DbType = Int32), @p378='?' (DbType = Decimal), @p379='?' (DbType = DateTime), @p380='?' (DbType = DateTime), @p381='?', @p382='?' (DbType = Int32), @p383='?' (DbType = Int32), @p384='?', @p385='?' (DbType = Int32), @p386='?' (DbType = Boolean), @p387='?' (DbType = DateTime), @p388='?' (DbType = Int32), @p389='?' (DbType = Decimal), @p390='?' (DbType = DateTime), @p391='?' (DbType = DateTime), @p392='?', @p393='?' (DbType = Int32), @p394='?' (DbType = Int32), @p395='?', @p396='?' (DbType = Int32), @p397='?' (DbType = Boolean), @p398='?' (DbType = DateTime), @p399='?' (DbType = Int32), @p400='?' (DbType = Decimal), @p401='?' (DbType = DateTime), @p402='?' (DbType = DateTime), @p403='?', @p404='?' (DbType = Int32), @p405='?' (DbType = Int32), @p406='?', @p407='?' (DbType = Int32), @p408='?' (DbType = Boolean), @p409='?' (DbType = DateTime), @p410='?' (DbType = Int32), @p411='?' (DbType = Decimal), @p412='?' (DbType = DateTime), @p413='?' (DbType = DateTime), @p414='?', @p415='?' (DbType = Int32), @p416='?' (DbType = Int32), @p417='?', @p418='?' (DbType = Int32), @p419='?' (DbType = Boolean), @p420='?' (DbType = DateTime), @p421='?' (DbType = Int32), @p422='?' (DbType = Decimal), @p423='?' (DbType = DateTime), @p424='?' (DbType = DateTime), @p425='?', @p426='?' (DbType = Int32), @p427='?' (DbType = Int32), @p428='?', @p429='?' (DbType = Int32), @p430='?' (DbType = Boolean), @p431='?' (DbType = DateTime), @p432='?' (DbType = Int32), @p433='?' (DbType = Decimal), @p434='?' (DbType = DateTime), @p435='?' (DbType = DateTime), @p436='?', @p437='?' (DbType = Int32), @p438='?' (DbType = Int32), @p439='?', @p440='?' (DbType = Int32), @p441='?' (DbType = Boolean), @p442='?' (DbType = DateTime), @p443='?' (DbType = Int32), @p444='?' (DbType = Decimal), @p445='?' (DbType = DateTime), @p446='?' (DbType = DateTime), @p447='?', @p448='?' (DbType = Int32), @p449='?' (DbType = Int32), @p450='?', @p451='?' (DbType = Int32), @p452='?' (DbType = Boolean), @p453='?' (DbType = DateTime), @p454='?' (DbType = Int32), @p455='?' (DbType = Decimal), @p456='?' (DbType = DateTime), @p457='?' (DbType = DateTime), @p458='?', @p459='?' (DbType = Int32), @p460='?' (DbType = Int32), @p461='?', @p462='?' (DbType = Int32), @p463='?' (DbType = Boolean), @p464='?' (DbType = DateTime), @p465='?' (DbType = Int32), @p466='?' (DbType = Decimal), @p467='?' (DbType = DateTime), @p468='?' (DbType = DateTime), @p469='?', @p470='?' (DbType = Int32), @p471='?' (DbType = Int32), @p472='?', @p473='?' (DbType = Int32), @p474='?' (DbType = Boolean), @p475='?' (DbType = DateTime), @p476='?' (DbType = Int32), @p477='?' (DbType = Decimal), @p478='?' (DbType = DateTime), @p479='?' (DbType = DateTime), @p480='?', @p481='?' (DbType = Int32), @p482='?' (DbType = Int32), @p483='?', @p484='?' (DbType = Int32), @p485='?' (DbType = Boolean), @p486='?' (DbType = DateTime), @p487='?' (DbType = Int32), @p488='?' (DbType = Decimal), @p489='?' (DbType = DateTime), @p490='?' (DbType = DateTime), @p491='?', @p492='?' (DbType = Int32), @p493='?' (DbType = Int32), @p494='?', @p495='?' (DbType = Int32), @p496='?' (DbType = Boolean), @p497='?' (DbType = DateTime), @p498='?' (DbType = Int32), @p499='?' (DbType = Decimal), @p500='?' (DbType = DateTime), @p501='?' (DbType = DateTime), @p502='?', @p503='?' (DbType = Int32), @p504='?' (DbType = Int32), @p505='?', @p506='?' (DbType = Int32), @p507='?' (DbType = Boolean), @p508='?' (DbType = DateTime), @p509='?' (DbType = Int32), @p510='?' (DbType = Decimal), @p511='?' (DbType = DateTime), @p512='?' (DbType = DateTime), @p513='?', @p514='?' (DbType = Int32), @p515='?' (DbType = Int32), @p516='?', @p517='?' (DbType = Int32), @p518='?' (DbType = Boolean), @p519='?' (DbType = DateTime), @p520='?' (DbType = Int32), @p521='?' (DbType = Decimal), @p522='?' (DbType = DateTime), @p523='?' (DbType = DateTime), @p524='?', @p525='?' (DbType = Int32), @p526='?' (DbType = Int32), @p527='?', @p528='?' (DbType = Int32), @p529='?' (DbType = Boolean), @p530='?' (DbType = DateTime), @p531='?' (DbType = Int32), @p532='?' (DbType = Decimal), @p533='?' (DbType = DateTime), @p534='?' (DbType = DateTime), @p535='?', @p536='?' (DbType = Int32), @p537='?' (DbType = Int32), @p538='?', @p539='?' (DbType = Int32), @p540='?' (DbType = Boolean), @p541='?' (DbType = DateTime), @p542='?' (DbType = Int32), @p543='?' (DbType = Decimal), @p544='?' (DbType = DateTime), @p545='?' (DbType = DateTime), @p546='?', @p547='?' (DbType = Int32), @p548='?' (DbType = Int32), @p549='?', @p550='?' (DbType = Int32), @p551='?' (DbType = Boolean), @p552='?' (DbType = DateTime), @p553='?' (DbType = Int32), @p554='?' (DbType = Decimal), @p555='?' (DbType = DateTime), @p556='?' (DbType = DateTime), @p557='?', @p558='?' (DbType = Int32), @p559='?' (DbType = Int32), @p560='?', @p561='?' (DbType = Int32), @p562='?' (DbType = Boolean), @p563='?' (DbType = DateTime), @p564='?' (DbType = Int32), @p565='?' (DbType = Decimal), @p566='?' (DbType = DateTime), @p567='?' (DbType = DateTime), @p568='?', @p569='?' (DbType = Int32), @p570='?' (DbType = Int32), @p571='?', @p572='?' (DbType = Int32), @p573='?' (DbType = Boolean), @p574='?' (DbType = DateTime), @p575='?' (DbType = Int32), @p576='?' (DbType = Decimal), @p577='?' (DbType = DateTime), @p578='?' (DbType = DateTime), @p579='?', @p580='?' (DbType = Int32), @p581='?' (DbType = Int32), @p582='?', @p583='?' (DbType = Int32), @p584='?' (DbType = Boolean), @p585='?' (DbType = DateTime), @p586='?' (DbType = Int32), @p587='?' (DbType = Decimal), @p588='?' (DbType = DateTime), @p589='?' (DbType = DateTime), @p590='?', @p591='?' (DbType = Int32), @p592='?' (DbType = Int32), @p593='?', @p594='?' (DbType = Int32), @p595='?' (DbType = Boolean), @p596='?' (DbType = DateTime), @p597='?' (DbType = Int32), @p598='?' (DbType = Decimal), @p599='?' (DbType = DateTime), @p600='?' (DbType = DateTime), @p601='?', @p602='?' (DbType = Int32), @p603='?' (DbType = Int32), @p604='?', @p605='?' (DbType = Int32), @p606='?' (DbType = Boolean), @p607='?' (DbType = DateTime), @p608='?' (DbType = Int32), @p609='?' (DbType = Decimal), @p610='?' (DbType = DateTime), @p611='?' (DbType = DateTime), @p612='?', @p613='?' (DbType = Int32), @p614='?' (DbType = Int32), @p615='?', @p616='?' (DbType = Int32), @p617='?' (DbType = Boolean), @p618='?' (DbType = DateTime), @p619='?' (DbType = Int32), @p620='?' (DbType = Decimal), @p621='?' (DbType = DateTime), @p622='?' (DbType = DateTime), @p623='?', @p624='?' (DbType = Int32), @p625='?' (DbType = Int32), @p626='?', @p627='?' (DbType = Int32), @p628='?' (DbType = Boolean), @p629='?' (DbType = DateTime), @p630='?' (DbType = Int32), @p631='?' (DbType = Decimal), @p632='?' (DbType = DateTime), @p633='?' (DbType = DateTime), @p634='?', @p635='?' (DbType = Int32), @p636='?' (DbType = Int32), @p637='?', @p638='?' (DbType = Int32), @p639='?' (DbType = Boolean), @p640='?' (DbType = DateTime), @p641='?' (DbType = Int32), @p642='?' (DbType = Decimal), @p643='?' (DbType = DateTime), @p644='?' (DbType = DateTime), @p645='?', @p646='?' (DbType = Int32), @p647='?' (DbType = Int32), @p648='?', @p649='?' (DbType = Int32), @p650='?' (DbType = Boolean), @p651='?' (DbType = DateTime), @p652='?' (DbType = Int32), @p653='?' (DbType = Decimal), @p654='?' (DbType = DateTime), @p655='?' (DbType = DateTime), @p656='?', @p657='?' (DbType = Int32), @p658='?' (DbType = Int32), @p659='?', @p660='?' (DbType = Int32), @p661='?' (DbType = Boolean), @p662='?' (DbType = DateTime), @p663='?' (DbType = Int32), @p664='?' (DbType = Decimal), @p665='?' (DbType = DateTime), @p666='?' (DbType = DateTime), @p667='?', @p668='?' (DbType = Int32), @p669='?' (DbType = Int32), @p670='?', @p671='?' (DbType = Int32), @p672='?' (DbType = Boolean), @p673='?' (DbType = DateTime), @p674='?' (DbType = Int32), @p675='?' (DbType = Decimal), @p676='?' (DbType = DateTime), @p677='?' (DbType = DateTime), @p678='?', @p679='?' (DbType = Int32), @p680='?' (DbType = Int32), @p681='?', @p682='?' (DbType = Int32), @p683='?' (DbType = Boolean), @p684='?' (DbType = DateTime), @p685='?' (DbType = Int32), @p686='?' (DbType = Decimal), @p687='?' (DbType = DateTime), @p688='?' (DbType = DateTime), @p689='?', @p690='?' (DbType = Int32), @p691='?' (DbType = Int32), @p692='?', @p693='?' (DbType = Int32), @p694='?' (DbType = Boolean), @p695='?' (DbType = DateTime), @p696='?' (DbType = Int32), @p697='?' (DbType = Decimal), @p698='?' (DbType = DateTime), @p699='?' (DbType = DateTime), @p700='?', @p701='?' (DbType = Int32), @p702='?' (DbType = Int32), @p703='?', @p704='?' (DbType = Int32), @p705='?' (DbType = Boolean), @p706='?' (DbType = DateTime), @p707='?' (DbType = Int32), @p708='?' (DbType = Decimal), @p709='?' (DbType = DateTime), @p710='?' (DbType = DateTime), @p711='?', @p712='?' (DbType = Int32), @p713='?' (DbType = Int32), @p714='?', @p715='?' (DbType = Int32), @p716='?' (DbType = Boolean), @p717='?' (DbType = DateTime), @p718='?' (DbType = Int32), @p719='?' (DbType = Decimal), @p720='?' (DbType = DateTime), @p721='?' (DbType = DateTime), @p722='?', @p723='?' (DbType = Int32), @p724='?' (DbType = Int32), @p725='?', @p726='?' (DbType = Int32), @p727='?' (DbType = Boolean), @p728='?' (DbType = DateTime), @p729='?' (DbType = Int32), @p730='?' (DbType = Decimal), @p731='?' (DbType = DateTime), @p732='?' (DbType = DateTime), @p733='?', @p734='?' (DbType = Int32), @p735='?' (DbType = Int32), @p736='?', @p737='?' (DbType = Int32), @p738='?' (DbType = Boolean), @p739='?' (DbType = DateTime), @p740='?' (DbType = Int32), @p741='?' (DbType = Decimal), @p742='?' (DbType = DateTime), @p743='?' (DbType = DateTime), @p744='?', @p745='?' (DbType = Int32), @p746='?' (DbType = Int32), @p747='?', @p748='?' (DbType = Int32), @p749='?' (DbType = Boolean), @p750='?' (DbType = DateTime), @p751='?' (DbType = Int32), @p752='?' (DbType = Decimal), @p753='?' (DbType = DateTime), @p754='?' (DbType = DateTime), @p755='?', @p756='?' (DbType = Int32), @p757='?' (DbType = Int32), @p758='?', @p759='?' (DbType = Int32), @p760='?' (DbType = Boolean), @p761='?' (DbType = DateTime), @p762='?' (DbType = Int32), @p763='?' (DbType = Decimal), @p764='?' (DbType = DateTime), @p765='?' (DbType = DateTime), @p766='?', @p767='?' (DbType = Int32), @p768='?' (DbType = Int32), @p769='?', @p770='?' (DbType = Int32), @p771='?' (DbType = Boolean), @p772='?' (DbType = DateTime), @p773='?' (DbType = Int32), @p774='?' (DbType = Decimal), @p775='?' (DbType = DateTime), @p776='?' (DbType = DateTime), @p777='?', @p778='?' (DbType = Int32), @p779='?' (DbType = Int32), @p780='?', @p781='?' (DbType = Int32), @p782='?' (DbType = Boolean), @p783='?' (DbType = DateTime), @p784='?' (DbType = Int32), @p785='?' (DbType = Decimal), @p786='?' (DbType = DateTime), @p787='?' (DbType = DateTime), @p788='?', @p789='?' (DbType = Int32), @p790='?' (DbType = Int32), @p791='?', @p792='?' (DbType = Int32), @p793='?' (DbType = Boolean), @p794='?' (DbType = DateTime), @p795='?' (DbType = Int32), @p796='?' (DbType = Decimal), @p797='?' (DbType = DateTime), @p798='?' (DbType = DateTime), @p799='?', @p800='?' (DbType = Int32), @p801='?' (DbType = Int32), @p802='?', @p803='?' (DbType = Int32), @p804='?' (DbType = Boolean), @p805='?' (DbType = DateTime), @p806='?' (DbType = Int32), @p807='?' (DbType = Decimal), @p808='?' (DbType = DateTime), @p809='?' (DbType = DateTime), @p810='?', @p811='?' (DbType = Int32), @p812='?' (DbType = Int32), @p813='?', @p814='?' (DbType = Int32), @p815='?' (DbType = Boolean), @p816='?' (DbType = DateTime), @p817='?' (DbType = Int32), @p818='?' (DbType = Decimal), @p819='?' (DbType = DateTime), @p820='?' (DbType = DateTime), @p821='?', @p822='?' (DbType = Int32), @p823='?' (DbType = Int32), @p824='?', @p825='?' (DbType = Int32), @p826='?' (DbType = Boolean), @p827='?' (DbType = DateTime), @p828='?' (DbType = Int32), @p829='?' (DbType = Decimal), @p830='?' (DbType = DateTime), @p831='?' (DbType = DateTime), @p832='?', @p833='?' (DbType = Int32), @p834='?' (DbType = Int32), @p835='?', @p836='?' (DbType = Int32), @p837='?' (DbType = Boolean), @p838='?' (DbType = DateTime), @p839='?' (DbType = Int32), @p840='?' (DbType = Decimal), @p841='?' (DbType = DateTime), @p842='?' (DbType = DateTime), @p843='?', @p844='?' (DbType = Int32), @p845='?' (DbType = Int32), @p846='?', @p847='?' (DbType = Int32), @p848='?' (DbType = Boolean), @p849='?' (DbType = DateTime), @p850='?' (DbType = Int32), @p851='?' (DbType = Decimal), @p852='?' (DbType = DateTime), @p853='?' (DbType = DateTime), @p854='?', @p855='?' (DbType = Int32), @p856='?' (DbType = Int32), @p857='?', @p858='?' (DbType = Int32), @p859='?' (DbType = Boolean), @p860='?' (DbType = DateTime), @p861='?' (DbType = Int32), @p862='?' (DbType = Decimal), @p863='?' (DbType = DateTime), @p864='?' (DbType = DateTime), @p865='?', @p866='?' (DbType = Int32), @p867='?' (DbType = Int32), @p868='?', @p869='?' (DbType = Int32), @p870='?' (DbType = Boolean), @p871='?' (DbType = DateTime), @p872='?' (DbType = Int32), @p873='?' (DbType = Decimal), @p874='?' (DbType = DateTime), @p875='?' (DbType = DateTime), @p876='?', @p877='?' (DbType = Int32), @p878='?' (DbType = Int32), @p879='?', @p880='?' (DbType = Int32), @p881='?' (DbType = Boolean), @p882='?' (DbType = DateTime), @p883='?' (DbType = Int32), @p884='?' (DbType = Decimal), @p885='?' (DbType = DateTime), @p886='?' (DbType = DateTime), @p887='?', @p888='?' (DbType = Int32), @p889='?' (DbType = Int32), @p890='?', @p891='?' (DbType = Int32), @p892='?' (DbType = Boolean), @p893='?' (DbType = DateTime), @p894='?' (DbType = Int32), @p895='?' (DbType = Decimal), @p896='?' (DbType = DateTime), @p897='?' (DbType = DateTime), @p898='?', @p899='?' (DbType = Int32), @p900='?' (DbType = Int32), @p901='?', @p902='?' (DbType = Int32), @p903='?' (DbType = Boolean), @p904='?' (DbType = DateTime), @p905='?' (DbType = Int32), @p906='?' (DbType = Decimal), @p907='?' (DbType = DateTime), @p908='?' (DbType = DateTime), @p909='?', @p910='?' (DbType = Int32), @p911='?' (DbType = Int32), @p912='?', @p913='?' (DbType = Int32), @p914='?' (DbType = Boolean), @p915='?' (DbType = DateTime), @p916='?' (DbType = Int32), @p917='?' (DbType = Decimal), @p918='?' (DbType = DateTime), @p919='?' (DbType = DateTime), @p920='?', @p921='?' (DbType = Int32), @p922='?' (DbType = Int32), @p923='?', @p924='?' (DbType = Int32), @p925='?' (DbType = Boolean), @p926='?' (DbType = DateTime), @p927='?' (DbType = Int32), @p928='?' (DbType = Decimal), @p929='?' (DbType = DateTime), @p930='?' (DbType = DateTime), @p931='?', @p932='?' (DbType = Int32), @p933='?' (DbType = Int32), @p934='?', @p935='?' (DbType = Int32), @p936='?' (DbType = Boolean), @p937='?' (DbType = DateTime), @p938='?' (DbType = Int32), @p939='?' (DbType = Decimal), @p940='?' (DbType = DateTime), @p941='?' (DbType = DateTime), @p942='?', @p943='?' (DbType = Int32), @p944='?' (DbType = Int32), @p945='?', @p946='?' (DbType = Int32), @p947='?' (DbType = Boolean), @p948='?' (DbType = DateTime), @p949='?' (DbType = Int32), @p950='?' (DbType = Decimal), @p951='?' (DbType = DateTime), @p952='?' (DbType = DateTime), @p953='?', @p954='?' (DbType = Int32), @p955='?' (DbType = Int32), @p956='?', @p957='?' (DbType = Int32), @p958='?' (DbType = Boolean), @p959='?' (DbType = DateTime), @p960='?' (DbType = Int32), @p961='?' (DbType = Decimal), @p962='?' (DbType = DateTime), @p963='?' (DbType = DateTime), @p964='?', @p965='?' (DbType = Int32), @p966='?' (DbType = Int32), @p967='?', @p968='?' (DbType = Int32), @p969='?' (DbType = Boolean), @p970='?' (DbType = DateTime), @p971='?' (DbType = Int32), @p972='?' (DbType = Decimal), @p973='?' (DbType = DateTime), @p974='?' (DbType = DateTime), @p975='?', @p976='?' (DbType = Int32), @p977='?' (DbType = Int32), @p978='?', @p979='?' (DbType = Int32), @p980='?' (DbType = Boolean), @p981='?' (DbType = DateTime), @p982='?' (DbType = Int32), @p983='?' (DbType = Decimal), @p984='?' (DbType = DateTime), @p985='?' (DbType = DateTime), @p986='?', @p987='?' (DbType = Int32), @p988='?' (DbType = Int32), @p989='?', @p990='?' (DbType = Int32), @p991='?' (DbType = Boolean), @p992='?' (DbType = DateTime), @p993='?' (DbType = Int32), @p994='?' (DbType = Decimal), @p995='?' (DbType = DateTime), @p996='?' (DbType = DateTime), @p997='?', @p998='?' (DbType = Int32), @p999='?' (DbType = Int32), @p1000='?', @p1001='?' (DbType = Int32), @p1002='?' (DbType = Boolean), @p1003='?' (DbType = DateTime), @p1004='?' (DbType = Int32), @p1005='?' (DbType = Decimal), @p1006='?' (DbType = DateTime), @p1007='?' (DbType = DateTime), @p1008='?', @p1009='?' (DbType = Int32), @p1010='?' (DbType = Int32), @p1011='?', @p1012='?' (DbType = Int32), @p1013='?' (DbType = Boolean), @p1014='?' (DbType = DateTime), @p1015='?' (DbType = Int32), @p1016='?' (DbType = Decimal), @p1017='?' (DbType = DateTime), @p1018='?' (DbType = DateTime), @p1019='?', @p1020='?' (DbType = Int32), @p1021='?' (DbType = Int32), @p1022='?', @p1023='?' (DbType = Int32), @p1024='?' (DbType = Boolean), @p1025='?' (DbType = DateTime), @p1026='?' (DbType = Int32), @p1027='?' (DbType = Decimal), @p1028='?' (DbType = DateTime), @p1029='?' (DbType = DateTime), @p1030='?', @p1031='?' (DbType = Int32), @p1032='?' (DbType = Int32), @p1033='?', @p1034='?' (DbType = Int32), @p1035='?' (DbType = Boolean), @p1036='?' (DbType = DateTime), @p1037='?' (DbType = Int32), @p1038='?' (DbType = Decimal), @p1039='?' (DbType = DateTime), @p1040='?' (DbType = DateTime), @p1041='?', @p1042='?' (DbType = Int32), @p1043='?' (DbType = Int32), @p1044='?', @p1045='?' (DbType = Int32), @p1046='?' (DbType = Boolean), @p1047='?' (DbType = DateTime), @p1048='?' (DbType = Int32), @p1049='?' (DbType = Decimal), @p1050='?' (DbType = DateTime), @p1051='?' (DbType = DateTime), @p1052='?', @p1053='?' (DbType = Int32), @p1054='?' (DbType = Int32), @p1055='?', @p1056='?' (DbType = Int32), @p1057='?' (DbType = Boolean), @p1058='?' (DbType = DateTime), @p1059='?' (DbType = Int32), @p1060='?' (DbType = Decimal), @p1061='?' (DbType = DateTime), @p1062='?' (DbType = DateTime), @p1063='?', @p1064='?' (DbType = Int32), @p1065='?' (DbType = Int32), @p1066='?', @p1067='?' (DbType = Int32), @p1068='?' (DbType = Boolean), @p1069='?' (DbType = DateTime), @p1070='?' (DbType = Int32), @p1071='?' (DbType = Decimal), @p1072='?' (DbType = DateTime), @p1073='?' (DbType = DateTime), @p1074='?', @p1075='?' (DbType = Int32), @p1076='?' (DbType = Int32), @p1077='?', @p1078='?' (DbType = Int32), @p1079='?' (DbType = Boolean), @p1080='?' (DbType = DateTime), @p1081='?' (DbType = Int32), @p1082='?' (DbType = Decimal), @p1083='?' (DbType = DateTime), @p1096='?' (DbType = Int32), @p1084='?' (DbType = DateTime), @p1085='?', @p1086='?' (DbType = DateTime), @p1087='?', @p1088='?', @p1089='?', @p1090='?', @p1091='?', @p1092='?' (DbType = Int32), @p1093='?', @p1094='?' (DbType = Int32), @p1095='?' (DbType = DateTime), @p1109='?' (DbType = Int32), @p1097='?' (DbType = DateTime), @p1098='?', @p1099='?' (DbType = DateTime), @p1100='?', @p1101='?', @p1102='?', @p1103='?', @p1104='?', @p1105='?' (DbType = Int32), @p1106='?', @p1107='?' (DbType = Int32), @p1108='?' (DbType = DateTime), @p1122='?' (DbType = Int32), @p1110='?' (DbType = DateTime), @p1111='?', @p1112='?' (DbType = DateTime), @p1113='?', @p1114='?', @p1115='?', @p1116='?', @p1117='?', @p1118='?' (DbType = Int32), @p1119='?', @p1120='?' (DbType = Int32), @p1121='?' (DbType = DateTime)], CommandType='"Text"', CommandTimeout='30']
UPDATE "ExportFiles" SET "CountAll" = @p0, "CountSuccessful" = @p1, "CreateTime" = @p2, "FileName" = @p3, "Hash" = @p4
WHERE "Id" = @p5;
UPDATE "Flats" SET "AccountNumber" = @p6, "AccountNumber2" = @p7, "AccountNumber3" = @p8, "AdminFees" = @p9, "Apartment" = @p10, "Balance" = @p11, "Building" = @p12, "City" = @p13, "CountParkingSpots" = @p14, "CountRooms" = @p15, "CreateTime" = @p16, "Deposit" = @p17, "Description" = @p18, "Floor" = @p19, "HasBalcony" = @p20, "HasTerrace" = @p21, "InternalId" = @p22, "LandlordId" = @p23, "PetAllowed" = @p24, "Postcode" = @p25, "Price" = @p26, "Size" = @p27, "Street" = @p28, "Title" = @p29, "UpdateTime" = @p30, "YearBuilt" = @p31
WHERE "Id" = @p32;
UPDATE "Flats" SET "AccountNumber" = @p33, "AccountNumber2" = @p34, "AccountNumber3" = @p35, "AdminFees" = @p36, "Apartment" = @p37, "Balance" = @p38, "Building" = @p39, "City" = @p40, "CountParkingSpots" = @p41, "CountRooms" = @p42, "CreateTime" = @p43, "Deposit" = @p44, "Description" = @p45, "Floor" = @p46, "HasBalcony" = @p47, "HasTerrace" = @p48, "InternalId" = @p49, "LandlordId" = @p50, "PetAllowed" = @p51, "Postcode" = @p52, "Price" = @p53, "Size" = @p54, "Street" = @p55, "Title" = @p56, "UpdateTime" = @p57, "YearBuilt" = @p58
WHERE "Id" = @p59;
UPDATE "Landlords" SET "AccountNumber" = @p60, "Balance" = @p61, "Comment" = @p62
WHERE "Id" = @p63;
UPDATE "Landlords" SET "AccountNumber" = @p64, "Balance" = @p65, "Comment" = @p66
WHERE "Id" = @p67;
UPDATE "Landlords" SET "AccountNumber" = @p68, "Balance" = @p69, "Comment" = @p70
WHERE "Id" = @p71;
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p72, @p73, @p74, @p75, @p76, @p77, @p78, @p79, @p80, @p81, @p82)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p83, @p84, @p85, @p86, @p87, @p88, @p89, @p90, @p91, @p92, @p93)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p94, @p95, @p96, @p97, @p98, @p99, @p100, @p101, @p102, @p103, @p104)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p105, @p106, @p107, @p108, @p109, @p110, @p111, @p112, @p113, @p114, @p115)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p116, @p117, @p118, @p119, @p120, @p121, @p122, @p123, @p124, @p125, @p126)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p127, @p128, @p129, @p130, @p131, @p132, @p133, @p134, @p135, @p136, @p137)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p138, @p139, @p140, @p141, @p142, @p143, @p144, @p145, @p146, @p147, @p148)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p149, @p150, @p151, @p152, @p153, @p154, @p155, @p156, @p157, @p158, @p159)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p160, @p161, @p162, @p163, @p164, @p165, @p166, @p167, @p168, @p169, @p170)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p171, @p172, @p173, @p174, @p175, @p176, @p177, @p178, @p179, @p180, @p181)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p182, @p183, @p184, @p185, @p186, @p187, @p188, @p189, @p190, @p191, @p192)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p193, @p194, @p195, @p196, @p197, @p198, @p199, @p200, @p201, @p202, @p203)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p204, @p205, @p206, @p207, @p208, @p209, @p210, @p211, @p212, @p213, @p214)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p215, @p216, @p217, @p218, @p219, @p220, @p221, @p222, @p223, @p224, @p225)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p226, @p227, @p228, @p229, @p230, @p231, @p232, @p233, @p234, @p235, @p236)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p237, @p238, @p239, @p240, @p241, @p242, @p243, @p244, @p245, @p246, @p247)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p248, @p249, @p250, @p251, @p252, @p253, @p254, @p255, @p256, @p257, @p258)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p259, @p260, @p261, @p262, @p263, @p264, @p265, @p266, @p267, @p268, @p269)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p270, @p271, @p272, @p273, @p274, @p275, @p276, @p277, @p278, @p279, @p280)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p281, @p282, @p283, @p284, @p285, @p286, @p287, @p288, @p289, @p290, @p291)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p292, @p293, @p294, @p295, @p296, @p297, @p298, @p299, @p300, @p301, @p302)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p303, @p304, @p305, @p306, @p307, @p308, @p309, @p310, @p311, @p312, @p313)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p314, @p315, @p316, @p317, @p318, @p319, @p320, @p321, @p322, @p323, @p324)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p325, @p326, @p327, @p328, @p329, @p330, @p331, @p332, @p333, @p334, @p335)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p336, @p337, @p338, @p339, @p340, @p341, @p342, @p343, @p344, @p345, @p346)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p347, @p348, @p349, @p350, @p351, @p352, @p353, @p354, @p355, @p356, @p357)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p358, @p359, @p360, @p361, @p362, @p363, @p364, @p365, @p366, @p367, @p368)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p369, @p370, @p371, @p372, @p373, @p374, @p375, @p376, @p377, @p378, @p379)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p380, @p381, @p382, @p383, @p384, @p385, @p386, @p387, @p388, @p389, @p390)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p391, @p392, @p393, @p394, @p395, @p396, @p397, @p398, @p399, @p400, @p401)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p402, @p403, @p404, @p405, @p406, @p407, @p408, @p409, @p410, @p411, @p412)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p413, @p414, @p415, @p416, @p417, @p418, @p419, @p420, @p421, @p422, @p423)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p424, @p425, @p426, @p427, @p428, @p429, @p430, @p431, @p432, @p433, @p434)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p435, @p436, @p437, @p438, @p439, @p440, @p441, @p442, @p443, @p444, @p445)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p446, @p447, @p448, @p449, @p450, @p451, @p452, @p453, @p454, @p455, @p456)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p457, @p458, @p459, @p460, @p461, @p462, @p463, @p464, @p465, @p466, @p467)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p468, @p469, @p470, @p471, @p472, @p473, @p474, @p475, @p476, @p477, @p478)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p479, @p480, @p481, @p482, @p483, @p484, @p485, @p486, @p487, @p488, @p489)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p490, @p491, @p492, @p493, @p494, @p495, @p496, @p497, @p498, @p499, @p500)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p501, @p502, @p503, @p504, @p505, @p506, @p507, @p508, @p509, @p510, @p511)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p512, @p513, @p514, @p515, @p516, @p517, @p518, @p519, @p520, @p521, @p522)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p523, @p524, @p525, @p526, @p527, @p528, @p529, @p530, @p531, @p532, @p533)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p534, @p535, @p536, @p537, @p538, @p539, @p540, @p541, @p542, @p543, @p544)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p545, @p546, @p547, @p548, @p549, @p550, @p551, @p552, @p553, @p554, @p555)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p556, @p557, @p558, @p559, @p560, @p561, @p562, @p563, @p564, @p565, @p566)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p567, @p568, @p569, @p570, @p571, @p572, @p573, @p574, @p575, @p576, @p577)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p578, @p579, @p580, @p581, @p582, @p583, @p584, @p585, @p586, @p587, @p588)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p589, @p590, @p591, @p592, @p593, @p594, @p595, @p596, @p597, @p598, @p599)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p600, @p601, @p602, @p603, @p604, @p605, @p606, @p607, @p608, @p609, @p610)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p611, @p612, @p613, @p614, @p615, @p616, @p617, @p618, @p619, @p620, @p621)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p622, @p623, @p624, @p625, @p626, @p627, @p628, @p629, @p630, @p631, @p632)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p633, @p634, @p635, @p636, @p637, @p638, @p639, @p640, @p641, @p642, @p643)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p644, @p645, @p646, @p647, @p648, @p649, @p650, @p651, @p652, @p653, @p654)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p655, @p656, @p657, @p658, @p659, @p660, @p661, @p662, @p663, @p664, @p665)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p666, @p667, @p668, @p669, @p670, @p671, @p672, @p673, @p674, @p675, @p676)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p677, @p678, @p679, @p680, @p681, @p682, @p683, @p684, @p685, @p686, @p687)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p688, @p689, @p690, @p691, @p692, @p693, @p694, @p695, @p696, @p697, @p698)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p699, @p700, @p701, @p702, @p703, @p704, @p705, @p706, @p707, @p708, @p709)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p710, @p711, @p712, @p713, @p714, @p715, @p716, @p717, @p718, @p719, @p720)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p721, @p722, @p723, @p724, @p725, @p726, @p727, @p728, @p729, @p730, @p731)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p732, @p733, @p734, @p735, @p736, @p737, @p738, @p739, @p740, @p741, @p742)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p743, @p744, @p745, @p746, @p747, @p748, @p749, @p750, @p751, @p752, @p753)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p754, @p755, @p756, @p757, @p758, @p759, @p760, @p761, @p762, @p763, @p764)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p765, @p766, @p767, @p768, @p769, @p770, @p771, @p772, @p773, @p774, @p775)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p776, @p777, @p778, @p779, @p780, @p781, @p782, @p783, @p784, @p785, @p786)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p787, @p788, @p789, @p790, @p791, @p792, @p793, @p794, @p795, @p796, @p797)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p798, @p799, @p800, @p801, @p802, @p803, @p804, @p805, @p806, @p807, @p808)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p809, @p810, @p811, @p812, @p813, @p814, @p815, @p816, @p817, @p818, @p819)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p820, @p821, @p822, @p823, @p824, @p825, @p826, @p827, @p828, @p829, @p830)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p831, @p832, @p833, @p834, @p835, @p836, @p837, @p838, @p839, @p840, @p841)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p842, @p843, @p844, @p845, @p846, @p847, @p848, @p849, @p850, @p851, @p852)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p853, @p854, @p855, @p856, @p857, @p858, @p859, @p860, @p861, @p862, @p863)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p864, @p865, @p866, @p867, @p868, @p869, @p870, @p871, @p872, @p873, @p874)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p875, @p876, @p877, @p878, @p879, @p880, @p881, @p882, @p883, @p884, @p885)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p886, @p887, @p888, @p889, @p890, @p891, @p892, @p893, @p894, @p895, @p896)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p897, @p898, @p899, @p900, @p901, @p902, @p903, @p904, @p905, @p906, @p907)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p908, @p909, @p910, @p911, @p912, @p913, @p914, @p915, @p916, @p917, @p918)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p919, @p920, @p921, @p922, @p923, @p924, @p925, @p926, @p927, @p928, @p929)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p930, @p931, @p932, @p933, @p934, @p935, @p936, @p937, @p938, @p939, @p940)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p941, @p942, @p943, @p944, @p945, @p946, @p947, @p948, @p949, @p950, @p951)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p952, @p953, @p954, @p955, @p956, @p957, @p958, @p959, @p960, @p961, @p962)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p963, @p964, @p965, @p966, @p967, @p968, @p969, @p970, @p971, @p972, @p973)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p974, @p975, @p976, @p977, @p978, @p979, @p980, @p981, @p982, @p983, @p984)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p985, @p986, @p987, @p988, @p989, @p990, @p991, @p992, @p993, @p994, @p995)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p996, @p997, @p998, @p999, @p1000, @p1001, @p1002, @p1003, @p1004, @p1005, @p1006)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p1007, @p1008, @p1009, @p1010, @p1011, @p1012, @p1013, @p1014, @p1015, @p1016, @p1017)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p1018, @p1019, @p1020, @p1021, @p1022, @p1023, @p1024, @p1025, @p1026, @p1027, @p1028)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p1029, @p1030, @p1031, @p1032, @p1033, @p1034, @p1035, @p1036, @p1037, @p1038, @p1039)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p1040, @p1041, @p1042, @p1043, @p1044, @p1045, @p1046, @p1047, @p1048, @p1049, @p1050)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p1051, @p1052, @p1053, @p1054, @p1055, @p1056, @p1057, @p1058, @p1059, @p1060, @p1061)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p1062, @p1063, @p1064, @p1065, @p1066, @p1067, @p1068, @p1069, @p1070, @p1071, @p1072)
RETURNING "Id";
INSERT INTO "Transactions" ("CreateTime", "Description", "ExportFilesId", "FlatId", "Hash", "InternalFlatId", "IsFlatBalance", "PaymentTime", "Status", "Sum", "UpdateTime")
VALUES (@p1073, @p1074, @p1075, @p1076, @p1077, @p1078, @p1079, @p1080, @p1081, @p1082, @p1083)
RETURNING "Id";
UPDATE "Users" SET "CreateTime" = @p1084, "Email" = @p1085, "ExpiresAt" = @p1086, "FirstName" = @p1087, "LastName" = @p1088, "PasswordHash" = @p1089, "PhoneNumber" = @p1090, "RefreshToken" = @p1091, "Role" = @p1092, "Salt" = @p1093, "Status" = @p1094, "UpdateTime" = @p1095
WHERE "Id" = @p1096;
UPDATE "Users" SET "CreateTime" = @p1097, "Email" = @p1098, "ExpiresAt" = @p1099, "FirstName" = @p1100, "LastName" = @p1101, "PasswordHash" = @p1102, "PhoneNumber" = @p1103, "RefreshToken" = @p1104, "Role" = @p1105, "Salt" = @p1106, "Status" = @p1107, "UpdateTime" = @p1108
WHERE "Id" = @p1109;
UPDATE "Users" SET "CreateTime" = @p1110, "Email" = @p1111, "ExpiresAt" = @p1112, "FirstName" = @p1113, "LastName" = @p1114, "PasswordHash" = @p1115, "PhoneNumber" = @p1116, "RefreshToken" = @p1117, "Role" = @p1118, "Salt" = @p1119, "Status" = @p1120, "UpdateTime" = @p1121
WHERE "Id" = @p1122;
[2025-04-01 22:19:53 ERR] An exception occurred in the database while saving changes for context type 'DAL.EF.EFDbContext'.
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.
 ---> System.InvalidCastException: Cannot write DateTime with Kind=Unspecified to PostgreSQL type 'timestamp with time zone', only UTC is supported. Note that it's not possible to mix DateTimes with different Kinds in an array/range. See the Npgsql.EnableLegacyTimestampBehavior AppContext switch to enable legacy behavior.
   at Npgsql.Internal.TypeHandlers.DateTimeHandlers.TimestampTzHandler.ValidateAndGetLength(DateTime value, NpgsqlParameter parameter)
   at Npgsql.Internal.TypeHandlers.DateTimeHandlers.TimestampTzHandler.ValidateObjectAndGetLength(Object value, NpgsqlLengthCache& lengthCache, NpgsqlParameter parameter)
   at Npgsql.NpgsqlParameter.ValidateAndGetLength()
   at Npgsql.NpgsqlParameterCollection.ValidateAndBind(ConnectorTypeMapper typeMapper)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(StateManager stateManager, Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.<>c.<SaveChanges>b__104_0(DbContext _, ValueTuple`2 t)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.
 ---> System.InvalidCastException: Cannot write DateTime with Kind=Unspecified to PostgreSQL type 'timestamp with time zone', only UTC is supported. Note that it's not possible to mix DateTimes with different Kinds in an array/range. See the Npgsql.EnableLegacyTimestampBehavior AppContext switch to enable legacy behavior.
   at Npgsql.Internal.TypeHandlers.DateTimeHandlers.TimestampTzHandler.ValidateAndGetLength(DateTime value, NpgsqlParameter parameter)
   at Npgsql.Internal.TypeHandlers.DateTimeHandlers.TimestampTzHandler.ValidateObjectAndGetLength(Object value, NpgsqlLengthCache& lengthCache, NpgsqlParameter parameter)
   at Npgsql.NpgsqlParameter.ValidateAndGetLength()
   at Npgsql.NpgsqlParameterCollection.ValidateAndBind(ConnectorTypeMapper typeMapper)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(StateManager stateManager, Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.<>c.<SaveChanges>b__104_0(DbContext _, ValueTuple`2 t)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)