public void executeNoReturn()
{
DBManager db = (DBManager)AppContext.getObject(typeof(DBManager));
SqlCommand query = new SqlCommand(nombreSP);
query.CommandType = CommandType.StoredProcedure;
foreach (String nombreP in parametros.Keys)
{
query.Parameters.Add(new SqlParameter(nombreP, parametros[nombreP]));
}
query.Connection = db.getConnection();
query.ExecuteNonQuery();
this.RemoveParameters();
}
public SqlParameter execSP()
{
DBManager db = (DBManager)AppContext.getObject(typeof(DBManager));
SqlCommand query = new SqlCommand(nombreSP);
query.CommandType = CommandType.StoredProcedure;
foreach (String nombreP in parametros.Keys)
{
query.Parameters.Add(new SqlParameter(nombreP, parametros[nombreP]));
}
SqlParameter retval = query.Parameters.Add("@ret", SqlDbType.Int);
retval.Direction = ParameterDirection.Output;
query.Connection = db.getConnection();
query.ExecuteNonQuery();
this.RemoveParameters();
return(retval);
}