public static SqlDataReader GetDataReader(Enumerations.DBServerType serverType, string tStoredProcedureName, int iTimeout, params DataAccessParameter[] parameters)
{
SQLServerHelper objSQLHelper = default(SQLServerHelper);
objSQLHelper = CreateHelper(serverType);
return(objSQLHelper.GetDataReader(tStoredProcedureName, iTimeout, parameters));
}
public static DataSet ExecuteSQL(Enumerations.DBServerType serverType, string tSqlStatment, int iTimeout)
{
SQLServerHelper objSQLHelper = default(SQLServerHelper);
objSQLHelper = CreateHelper(serverType);
return(objSQLHelper.ExecuteSQL(tSqlStatment, iTimeout));
}
public static decimal ExecuteScalar(Enumerations.DBServerType serverType, string tStoredProcedureName, params DataAccessParameter[] parameters)
{
SQLServerHelper objSQLHelper = default(SQLServerHelper);
objSQLHelper = CreateHelper(serverType);
return(objSQLHelper.ExecuteScalar(tStoredProcedureName, parameters));
}
public static DataTable GetDataTable(Enumerations.DBServerType serverType, string storedProcedureName)
{
return(CreateHelper(serverType).GetDataTable(storedProcedureName));
}
public static DataSet GetDataSet(Enumerations.DBServerType serverType, string storedProcedureName, params DataAccessParameter[] parameters)
{
var dataSet = new DataSet();
return(CreateHelper(serverType).GetDataSet(storedProcedureName, ref dataSet, parameters));
}
public static SqlDataReader GetDataReader(Enumerations.DBServerType serverType, string tStoredProcedureName, List <DataAccessParameter> colParameters, int iTimeout)
{
return(GetDataReader(serverType, tStoredProcedureName, iTimeout, null));
}
/// <description>
/// Instancia un SQLServerHelper con una BD en particular
/// </description>
/// <returns>A SQLServerHelper object</returns>
/// <raiseErrors></raiseErrors>
private static SQLServerHelper CreateHelper(Enumerations.DBServerType serverType)
{
return(new SQLServerHelper(ConfigurationManager.ConnectionStrings[serverType.ToString()].ConnectionString));
}
public static SqlDataReader GetDataReader(Enumerations.DBServerType serverType, string tStoredProcedureName)
{
return(GetDataReader(serverType, tStoredProcedureName, null));
}
public static decimal ExecuteScalar(Enumerations.DBServerType serverType, string tStoredProcedureName)
{
return(ExecuteScalar(serverType, tStoredProcedureName, null));
}
public static int ExecuteStoredProcedure(Enumerations.DBServerType serverType, string storedProcedureName, params DataAccessParameter[] parameters)
{
return(CreateHelper(serverType).ExecuteStoredProcedure(storedProcedureName, parameters));
}
public static int ExecuteStoredProcedure(Enumerations.DBServerType serverType, string storedProcedureName)
{
return(CreateHelper(serverType).ExecuteStoredProcedure(storedProcedureName));
}
public static DataTable GetDataTable(Enumerations.DBServerType serverType, ref DataTable dataTable, string storedProcedureName, params DataAccessParameter[] parameters)
{
return(CreateHelper(serverType).GetDataTable(ref dataTable, storedProcedureName, parameters));
}
