internal StoreProcedures LoadStoreProceduresByTables(Tables pTables, bool pLoadParameters)
{
string strSpName = String.Empty;
StoreProcedures wStoreProcedures = null;
StoreProcedure wStoreProcedure = null;
foreach (Table wTabla in pTables)
{
DataSet wDtsStores = GetStoreProceduresFromTable(wTabla.Name);
if (wDtsStores.Tables.Count > 0 && wDtsStores.Tables[0].Rows.Count > 0)
{
foreach (DataRow wDtr in wDtsStores.Tables[0].Rows)
{
if (wDtr[1].ToString().ToUpper() == "STORED PROCEDURE")
{
strSpName = wDtr[0].ToString().Substring(4, wDtr[0].ToString().Length - 4);
wStoreProcedure = new StoreProcedure();
wStoreProcedure.Name = strSpName;
if (pLoadParameters == true)
{
FillParametesAndText(wStoreProcedure);
}
wStoreProcedures.Add(wStoreProcedure);
}
}
}
}
return(wStoreProcedures);
}
/// <summary>
/// Retorna los StoreProcedures seleccionados en el tree view.-
/// </summary>
/// <returns></returns>
public StoreProcedures GetSelectedStoreProcedures()
{
StoreProcedures wStoreProceduresSelected = new StoreProcedures();
foreach (StoreProcedure wStoreProcedure in _StoreProcedures)
{
if (wStoreProcedure.Checked)
{
wStoreProceduresSelected.Add(_StoreProcedures[_StoreProcedures.IndexOf(wStoreProcedure)]);
}
}
return(wStoreProceduresSelected);
}
/// <summary>
/// Carga todos los store procedures de una base de datos .-
/// </summary>
/// <param name="pLoadParameters">Indica si se cargan los parametros y text del Store Procedure .-</param>
/// <returns></returns>
internal StoreProcedures LoadStoreProcedures(bool pLoadParameters)
{
StoreProcedure wStoreProcedure = null;
StoreProcedures wStoreProcedures = new StoreProcedures();
DataSet wDtsStores = null;
try
{
wDtsStores = GetStoredProcedureFromDatabase();
foreach (DataRow wDtr in wDtsStores.Tables[0].Rows)
{
wStoreProcedure = new StoreProcedure();
wStoreProcedure.Name = wDtr["Name"].ToString();
wStoreProcedure.Schema = wDtr["Schema"].ToString();
if (pLoadParameters == true)
{
FillParametesAndText(wStoreProcedure);
}
wStoreProcedures.Add(wStoreProcedure);
}
wStoreProcedures.IsLoaded = true;
wDtsStores.Dispose();
wDtsStores = null;
OnAddElementEvent();
return(wStoreProcedures);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Carga todos los store procedures de una base de datos .-
/// </summary>
/// <param name="pLoadParameters">Indica si se cargan los parametros y text del Store Procedure .-</param>
/// <returns></returns>
internal StoreProcedures LoadStoreProcedures(bool pLoadParameters)
{
StoreProcedure wStoreProcedure = null;
StoreProcedures wStoreProcedures = new StoreProcedures() ;
DataSet wDtsStores = null;
try
{
wDtsStores = GetStoredProcedureFromDatabase();
foreach (DataRow wDtr in wDtsStores.Tables [0].Rows)
{
wStoreProcedure = new StoreProcedure();
wStoreProcedure.Name = wDtr["Name"].ToString();
wStoreProcedure.Schema = wDtr["Schema"].ToString();
if (pLoadParameters == true)
FillParametesAndText(wStoreProcedure);
wStoreProcedures.Add(wStoreProcedure);
}
wStoreProcedures.IsLoaded = true;
wDtsStores.Dispose();
wDtsStores = null;
OnAddElementEvent();
return wStoreProcedures;
}
catch(Exception ex)
{
throw ex;
}
}
/// <summary>
/// Retorna los StoreProcedures seleccionados en el tree view.-
/// </summary>
/// <returns></returns>
public StoreProcedures GetSelectedStoreProcedures()
{
StoreProcedures wStoreProceduresSelected = new StoreProcedures();
foreach (StoreProcedure wStoreProcedure in _StoreProcedures)
{
if (wStoreProcedure.Checked)
wStoreProceduresSelected.Add(_StoreProcedures[_StoreProcedures.IndexOf(wStoreProcedure)]);
}
return wStoreProceduresSelected;
}
