private string TransactionQuery()
{
string Query = "";
foreach (var table in _tables)
{
var value = table.Value;
foreach (var item in value)
{
Query += InsertQuery(item.Key, item.Value);
}
// Query += InsertQuery(table.Key, table.Value);
}
return(TransactionHelper.BuildQuery(Query));
// Query += "BEGIN BEGIN TRY ";
// Query += "BEGIN TRANSACTION ";
// foreach (var table in _tables)
// {
// var value = table.Value;
// foreach (var item in value)
// {
// Query += InsertQuery(item.Key, item.Value);
// }
// // Query += InsertQuery(table.Key, table.Value);
// }
// Query += "COMMIT TRANSACTION ";
// Query += "END TRY ";
// Query += "BEGIN CATCH ";
// Query += "ROLLBACK TRANSACTION ";
// Query += "declare @strErrorMessage nvarchar(200),";
// Query += "@intErrorNumber int,";
// Query += "@intErrorSeverity int,";
// Query += "@intErrorState int,";
// Query += "@intErrorLine int,";
// Query += "@strErrorProcedure nvarchar(200)";
// Query += "SELECT @strErrorMessage = ERROR_MESSAGE(),";
// Query += "@intErrorNumber = ERROR_NUMBER(),";
// Query += "@intErrorSeverity = ERROR_SEVERITY(),";
// Query += "@intErrorState = ERROR_STATE(),";
// Query += "@intErrorLine = ERROR_LINE(),";
// Query += "@strErrorProcedure = ISNULL(ERROR_PROCEDURE(), '-');";
// Query += "RAISERROR(@strErrorMessage, @intErrorSeverity, 1, @intErrorNumber, @intErrorSeverity, @intErrorState, @strErrorProcedure, @intErrorLine);";
// Query += "END CATCH ";
// Query += "END ";
//return Query;
}