public string Parametro(string Parametro) { string _parametro = string.Empty; try { _parametro = Convert.ToString(data.LoadScalarData("SELECT dbo.fncConsultaParametros('" + Parametro.Trim() + "', 4)", CommandType.Text, null)); } catch (Exception ex) { throw ex; } return(_parametro); }
public bool ConsultaAutorizacionesPendientes() { bool _retValue = true; SqlParameter[] _param = new SqlParameter[1]; _param[0] = new SqlParameter("@Cliente", SqlDbType.Int); _param[0].Value = _cliente; try { _retValue = Convert.ToBoolean(_data.LoadScalarData("spCyCSCConsultaAutorizacionPendiente", CommandType.StoredProcedure, _param)); } catch (Exception ex) { throw (ex); } finally { _data.CloseConnection(); } return(_retValue); }