public static object SqlScalartoObj(string sqlQuery, DbSqlParameterCollection sqlParams) { bool isTransaction = IsTransaction; SqlCommand myCommand = new SqlCommand(sqlQuery, (isTransaction) ? GetConnection : GetNewConnection); foreach (DbSqlParameter p in sqlParams) { myCommand.Parameters.Add(p.Parameter); } if (myCommand.Connection.State != ConnectionState.Open) { myCommand.Connection.Open(); } if (isTransaction) { if (currentTransaction != null) { myCommand.Transaction = currentTransaction; } } else { object ret = myCommand.ExecuteScalar(); myCommand.Connection.Close(); return(ret); } return(myCommand.ExecuteScalar()); }
public static DataSet SecureCreateDataset(string sqlString, DbSqlParameter param) { DbSqlParameterCollection p = new DbSqlParameterCollection(); p.Add(param); return(SecureCreateDataset(sqlString, p)); }
public static DataTable DoStoredTable(string sqlStored, DbSqlParameterCollection sqlParams) { bool isTransaction = IsTransaction; SqlCommand myCommand = new SqlCommand(sqlStored, (isTransaction)?DatabaseConnection.GetConnection:DatabaseConnection.GetNewConnection); myCommand.CommandType = CommandType.StoredProcedure; foreach (DbSqlParameter p in sqlParams) { myCommand.Parameters.Add(p.Parameter); } if (myCommand.Connection.State != ConnectionState.Open) { myCommand.Connection.Open(); } if (isTransaction) { myCommand.Transaction = currentTransaction; } SqlDataAdapter adapter = new SqlDataAdapter(myCommand); DataTable dt = new DataTable(); adapter.Fill(dt); return(dt); }
public static object DoStoredScalar(string sqlStored, DbSqlParameterCollection sqlParams, bool transactional) { SqlCommand myCommand = new SqlCommand(sqlStored, (transactional)?DatabaseConnection.GetConnection:DatabaseConnection.GetNewConnection); myCommand.CommandType = CommandType.StoredProcedure; foreach (DbSqlParameter p in sqlParams) { myCommand.Parameters.Add(p.Parameter); } if (myCommand.Connection.State != ConnectionState.Open) { myCommand.Connection.Open(); } if (transactional) { if (currentTransaction != null) { myCommand.Transaction = currentTransaction; } } else { object ret = myCommand.ExecuteScalar(); myCommand.Connection.Close(); return(ret); } return(myCommand.ExecuteScalar()); }
public static void DoCommand(string sql, DbSqlParameterCollection sqlParams) { SqlCommand cmd = new SqlCommand(sql, GetConnection); try { if (cmd.Connection.State != ConnectionState.Open) { cmd.Connection.Open(); } if (currentTransaction != null) { cmd.Transaction = currentTransaction; } foreach (DbSqlParameter p in sqlParams) { cmd.Parameters.Add(p.Parameter); } cmd.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception(ex.ToString()); } finally { } }
public static SqlDataReader CreateReader(string sqlString, DbSqlParameterCollection sqlParams) { SqlCommand myCmd = new SqlCommand(sqlString, (IsTransaction)?GetConnection:GetNewConnection); SqlDataReader dr = null; if (myCmd.Connection.State != ConnectionState.Open) { myCmd.Connection.Open(); } if (currentTransaction != null) { myCmd.Transaction = currentTransaction; } foreach (DbSqlParameter par in sqlParams) { myCmd.Parameters.Add(par.Parameter); } dr = myCmd.ExecuteReader(CommandBehavior.CloseConnection); return(dr); }
public static void DoStored(string sqlStored, DbSqlParameterCollection sqlParams, bool transactional) { SqlCommand myCommand = new SqlCommand(sqlStored, (transactional)?DatabaseConnection.GetConnection:DatabaseConnection.GetNewConnection); myCommand.CommandType = CommandType.StoredProcedure; foreach (DbSqlParameter p in sqlParams) { myCommand.Parameters.Add(p.Parameter); } if (myCommand.Connection.State != ConnectionState.Open) { myCommand.Connection.Open(); } if (currentTransaction != null) { myCommand.Transaction = currentTransaction; } myCommand.ExecuteNonQuery(); if (!IsTransaction) { myCommand.Connection.Close(); } }
public static DataSet SecureCreateDataset(string sqlString, DbSqlParameterCollection sqlParams) { DataSet Secure = new DataSet(); SqlCommand cmd = (IsTransaction)?GetConnection.CreateCommand():GetNewConnection.CreateCommand(); cmd.CommandText = sqlString; SqlDataAdapter SqlDataAdapter = new SqlDataAdapter(cmd); if (IsTransaction) { SqlDataAdapter.SelectCommand.Transaction = currentTransaction; } foreach (DbSqlParameter ss in sqlParams) { cmd.Parameters.Add(ss.Parameter); } try { if (cmd.Connection.State != ConnectionState.Open) { cmd.Connection.Open(); } if (currentTransaction != null) { cmd.Transaction = currentTransaction; } SqlDataAdapter.Fill(Secure); } catch (Exception ex) { throw new Exception(ex.ToString()); } finally { } return(Secure); }
public static void DoStored(string sqlStored, DbSqlParameterCollection sqlParams) { DoStored(sqlStored, sqlParams, IsTransaction); }