public static DataTable GetDataWareHouse(string queryString, string userName, string password) { DatabaseConnectorWarehouse connector = new DatabaseConnectorWarehouse(userName, password); connector.OpenConnection(); try { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(queryString, connector.Connection); da.SelectCommand.CommandTimeout = 0; da.Fill(dt); connector.CloseConnection(); return(dt); } catch (SqlException ex) { connector.CloseConnection(); throw ex; } catch (Exception ex) { connector.CloseConnection(); throw ex; } }
public static bool ExecuteNonQueryWarehouse(string sqlString, string userName, string password) { SqlTransaction transaction; DatabaseConnectorWarehouse connector = new DatabaseConnectorWarehouse(userName, password); connector.OpenConnection(); transaction = connector.Connection.BeginTransaction("SampleTransaction"); SqlCommand command = new SqlCommand(sqlString, connector.Connection); command.Transaction = transaction; try { command.CommandTimeout = 0; command.ExecuteNonQuery(); transaction.Commit(); command.Dispose(); connector.CloseConnection(); return(true); } catch { transaction.Rollback(); command.Dispose(); connector.CloseConnection(); return(false); } }