public static ParametersContainer RetrieveOUTPUTParametersData(DBQueryDef queryDefinition)
{
ParametersContainer _OUTPUTcontainer = new ParametersContainer();
using (System.Data.SqlClient.SqlConnection cnn = new System.Data.SqlClient.SqlConnection(queryDefinition.ConnectionString))
{
cnn.Open();
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(queryDefinition.CommandText, cnn))
{
try
{
switch (queryDefinition.QueryType)
{
case DataBaseLibrary.Definitions.queryType.Text:
cmd.CommandType = CommandType.Text;
break;
case DataBaseLibrary.Definitions.queryType.StoredProcedure:
cmd.CommandType = CommandType.StoredProcedure;
System.Collections.IEnumerator listEnumerator = default(System.Collections.IEnumerator);
QueryParameter parameter = default(QueryParameter);
//gets the parameters from the definition
listEnumerator = queryDefinition.Parameters.GetEnumerator();
while (listEnumerator.MoveNext())
{
parameter = (QueryParameter)listEnumerator.Current;
System.Data.SqlClient.SqlParameter param = new System.Data.SqlClient.SqlParameter(parameter.Name, parameter.sqlType);
param.SqlDbType = parameter.sqlType;
param.Direction = parameter.Direction;
param.Size = parameter.Size;
if (param.Direction == ParameterDirection.Output)
{
_OUTPUTcontainer.AddParameter(parameter);
}
cmd.Parameters.Add(param);
}
break;
}
cmd.ExecuteNonQuery();
//transferrs the valur retrieved to the parameters in the result set
foreach (QueryParameter param in _OUTPUTcontainer)
{
param.Value = cmd.Parameters[param.Name].Value;
}
}
catch (Exception ex)
{
throw (ex);
}
}
}
return(_OUTPUTcontainer);
}
protected DBQueryDefinition(string commandText, queryType queryType)
{
this._parameters = new ParametersContainer();
this._commandText = commandText;
this._queryTpe = queryType;
}