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; }