public DBDataReader(string process, string sql, string connectionKey, Boolean singleRow, Boolean SingleValue) { var formattedSql = DBDataTable.FormatSql(sql); Log4Net.SqlStatementStack.Push(new Log4Net.SqlStatementStackMessage(formattedSql)); Log4Net.LogDebug(formattedSql, connectionKey); Connection = StartUp.OpenConnection(connectionKey); DBCommand = new SqlCommand(formattedSql, Connection); DBCommand.CommandTimeout = StartUp.TimeOut; try { ReturnValue = DBCommand.ExecuteScalar(); } catch { try { if (Connection.State == ConnectionState.Closed) { Connection.Open(); } ReturnValue = DBCommand.ExecuteScalar(); } catch (Exception ex) { LogException(sql, "Scalar", ex, process); } } LogInfo(sql, "Scalar"); }
public DBDataReader(string process, string sql, string connectionKey, Boolean singleRow) { var formattedSql = DBDataTable.FormatSql(sql); Log4Net.SqlStatementStack.Push(new Log4Net.SqlStatementStackMessage(formattedSql)); Log4Net.LogDebug(formattedSql, connectionKey); Connection = StartUp.OpenConnection(connectionKey); DBCommand = new SqlCommand(formattedSql, Connection); DBCommand.CommandTimeout = StartUp.TimeOut; ReturnValue = string.Empty; try { DBReader = DBCommand.ExecuteReader(CommandBehavior.SingleRow); DBReader.Read(); for (var i = 0; i < DBReader.FieldCount; i++) { ReturnValue += DBReader[i] + "|"; } } catch { try { if (Connection.State == ConnectionState.Closed) { Connection.Open(); } DBReader = DBCommand.ExecuteReader(CommandBehavior.SingleRow); } catch (Exception ex) { LogException(formattedSql, String.Empty, ex, process); } } }
public DBDataReader(string process, string sql, string connectionKey) { var formattedSql = DBDataTable.FormatSql(sql); try { Log4Net.SqlStatementStack.Push(new Log4Net.SqlStatementStackMessage(formattedSql)); Log4Net.LogDebug(formattedSql, connectionKey); Connection = StartUp.OpenConnection(connectionKey); DBCommand = new SqlCommand(formattedSql, Connection); DBCommand.CommandTimeout = StartUp.TimeOut; DBReader = DBCommand.ExecuteReader(CommandBehavior.Default); } catch (Exception ex) { LogException(formattedSql, String.Empty, ex, process); } LogInfo(sql, "Reader"); }
public void GetData(string sql, string connectionKey) { var formattedSql = DBDataTable.FormatSql(sql); Log4Net.SqlStatementStack.Push(new Log4Net.SqlStatementStackMessage(formattedSql)); Log4Net.LogDebug(formattedSql, connectionKey); var connectionString = StartUp.GetConnectionString(connectionKey); using (var connection = new SqlConnection(connectionString)) { var dataAdapter = new SqlDataAdapter(formattedSql, connection); dataAdapter.Fill(DBDataset); DBDataset.CaseSensitive = false; } LogResultCount(DBDataset); if (!sql.StartsWith("exec AuditDetailInsert") && !sql.StartsWith("exec AuditSummaryUpdate") && !sql.StartsWith("exec AuditSummaryInsert")) { DBDataReader.MessageLog("SQL: " + sql); } }