/// <summary>
/// Rellena el Store Procedures con sus parametros
/// </summary>
/// <param name="pStoreProcedure">Store Procedure</param>
public void StoreProcedures_FillParameters(StoreProcedure pStoreProcedure)
{
if (pStoreProcedure.IsParametersLoaded)
{
return;
}
pStoreProcedure.IsParametersLoaded = true;
StoreProcedureBack wStoreProcedureBack = new StoreProcedureBack(_DataBaseServer.CnnString.ToString(), _DataBaseServer.ServerVersion);
try
{
wStoreProcedureBack.FillParametesAndText(pStoreProcedure);
}
catch (Exception ex)
{
throw new DataBaseExeption(ex, _DataBaseServer.CnnString);
}
}
/// <summary>
/// Carga los StoreProcedures de la base de datos accediendo a la base de datos nuevamente.-
/// </summary>
/// <returns>StoreProcedures</returns>
public void LoadStoreProcedures()
{
if (!_ReloadObjects)
{
return;
}
StoreProcedureBack wStoreProcedureBack = new StoreProcedureBack(_DataBaseServer.CnnString.ToString(), _DataBaseServer.ServerVersion);
try
{
_StoreProcedures = wStoreProcedureBack.LoadStoreProcedures();
_StoreProcedures.IsLoaded = true;
if (OnStoreProcedureLoad != null)
{
OnStoreProcedureLoad();
}
}
catch (Exception ex)
{
throw new DataBaseExeption(ex, _DataBaseServer.CnnString);
}
}
/// <summary>
/// Carga los StoreProcedures de la base de datos accediendo a la base de datos nuevamente.-
/// </summary>
/// <returns>StoreProcedures</returns>
public void LoadStoreProcedures()
{
if(!_ReloadObjects) return;
StoreProcedureBack wStoreProcedureBack = new StoreProcedureBack (_DataBaseServer.CnnString.ToString(),_DataBaseServer.ServerVersion);
try
{
_StoreProcedures = wStoreProcedureBack.LoadStoreProcedures();
_StoreProcedures.IsLoaded = true;
if(OnStoreProcedureLoad!=null)
OnStoreProcedureLoad();
}
catch(Exception ex)
{
throw new DataBaseExeption(ex, _DataBaseServer.CnnString);
}
}
/// <summary>
/// Rellena el Store Procedures con sus parametros
/// </summary>
/// <param name="pStoreProcedure">Store Procedure</param>
public void StoreProcedures_FillParameters(StoreProcedure pStoreProcedure)
{
if (pStoreProcedure.IsParametersLoaded) return;
pStoreProcedure.IsParametersLoaded = true;
StoreProcedureBack wStoreProcedureBack = new StoreProcedureBack(_DataBaseServer.CnnString.ToString(), _DataBaseServer.ServerVersion);
try
{
wStoreProcedureBack.FillParametesAndText(pStoreProcedure);
}
catch (Exception ex)
{
throw new DataBaseExeption(ex, _DataBaseServer.CnnString);
}
}
