/// <summary> /// Busca los tipos de documentos que se pueden agregar a una solicitud. /// </summary> /// <param name="ENTDocumento">Entidad del tipo de documento.</param> /// <param name="ConnectionString">Cadena de conexión a la base de datos.</param> /// <returns>Resultado de la búsqueda.</returns> public DataSet SelectTipoDocumento(ENTTipoDocumento TipoDocumentoEntity, string ConnectionString) { DataSet ResultData = new DataSet(); SqlConnection Connection = new SqlConnection(ConnectionString); SqlCommand Command; SqlParameter Parameter; SqlDataAdapter DataAdapter; try { Command = new SqlCommand("SelectTipoDocumento", Connection); Command.CommandType = CommandType.StoredProcedure; Parameter = new SqlParameter("TipoDocumentoId", SqlDbType.VarChar); Parameter.Value = TipoDocumentoEntity.TipoDocumentoId; Command.Parameters.Add(Parameter); DataAdapter = new SqlDataAdapter(Command); Connection.Open(); DataAdapter.Fill(ResultData); Connection.Close(); return ResultData; } catch (SqlException Exception) { _ErrorId = Exception.Number; _ErrorDescription = Exception.Message; if (Connection.State == ConnectionState.Open) Connection.Close(); return ResultData; } }
/// <summary> /// Constructor de la clase. /// </summary> public BPTipoDocumento() { _ErrorId = 0; _ErrorDescription = string.Empty; _TipoDocumentoEntity = new ENTTipoDocumento(); }