WCF Service

NET-WS-DestinoPaciente

WCF service for patient destination/routing management

Endpoints

Internal Funcs

SQL Statements

Last commit: 2024-12-06

🔗 Cross-service similarity detected

⚠ Similar operations in other services:

GetDestinoPaciente also in → NET-WS-Telemedicina

GetDestinoPacienteV2 also in → NET-WS-Telemedicina

🔁 Similar SQL queries found in other services:

SELECT MIN(CI0100.CI01FECCONCERT) KEEP (DENSE_RANK FIRST ORDER BY CI01FECCONCERT) FECHA_CI…
→ also in NET-WS-Telemedicina

🗄 Shared DB tables with other services:
dual

📋 Endpoints Overview (2)

Operation ⇅	Verb	Returns ⇅	Parameters	SQLs ⇅	Description	Flags
GetDestinoPaciente	SOAP	RespDestino	dni, fechaCita	1		✓ 🔁
GetDestinoPacienteV2	SOAP	RespDestinoV2	dni, fechaCita	1		✓ 🔁

🔌 Endpoint Details

GetDestinoPaciente

SOAP

⚠ Similar operation GetDestinoPaciente exists in: NET-WS-Telemedicina

📥 Input Parameters

stringdni

stringfechaCita

📤 Return Type

RespDestino

🗄 SQL Queries (1)

SELECT MIN(CI0100.CI01FECCONCERT) KEEP (DENSE_RANK FIRST ORDER BY CI01FECCONCERT) FECHA_CITA,

🔗 External Calls / Used By

Oracle DB

💬 Logic / Comments

No comments

📝 Suggested XML doc comment

/// <summary>
/// Retrieves get destino paciente
/// </summary>
/// <param name="dni">TODO: describe dni</param>
/// <param name="fechaCita">TODO: describe fechaCita</param>
/// <returns>RespDestino</returns>

🧪 Suggested unit test stubs (MSTest)

[TestMethod]
        public void Test_GetDestinoPaciente_ReturnsSuccess()
        {
            // Arrange
            // NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
            // NOTE: external dependency detected — consider mocking: Oracle DB
            var client = new WSDestinoPaciente();
            var dni = "test_value";
            var fechaCita = "test_value";

            // Act
            var result = client.GetDestinoPaciente(dni, fechaCita);

            // Assert
            Assert.IsNotNull(result);
            Assert.IsTrue(result.Exito);
        }

        [TestMethod]
        public void Test_GetDestinoPaciente_WithInvalidInput_ReturnsFailure()
        {
            // Arrange
            var client = new WSDestinoPaciente();
            var dni = null;
            var fechaCita = null;

            // Act
            var result = client.GetDestinoPaciente(dni, fechaCita);

            // Assert
            Assert.IsFalse(result?.Exito ?? true);
        }

GetDestinoPacienteV2

SOAP

⚠ Similar operation GetDestinoPacienteV2 exists in: NET-WS-Telemedicina

📥 Input Parameters

stringdni

stringfechaCita

📤 Return Type

RespDestinoV2

🗄 SQL Queries (1)

SELECT MIN(CI0100.CI01FECCONCERT) KEEP (DENSE_RANK FIRST ORDER BY CI01FECCONCERT) FECHA_CITA,

🔗 External Calls / Used By

Oracle DB

💬 Logic / Comments

No comments

📝 Suggested XML doc comment

/// <summary>
/// Retrieves get destino paciente v2
/// </summary>
/// <param name="dni">TODO: describe dni</param>
/// <param name="fechaCita">TODO: describe fechaCita</param>
/// <returns>RespDestinoV2</returns>

🧪 Suggested unit test stubs (MSTest)

[TestMethod]
        public void Test_GetDestinoPacienteV2_ReturnsSuccess()
        {
            // Arrange
            // NOTE: requires Oracle DB connection — configure App.config or mock OracleConnection
            // NOTE: external dependency detected — consider mocking: Oracle DB
            var client = new WSDestinoPaciente();
            var dni = "test_value";
            var fechaCita = "test_value";

            // Act
            var result = client.GetDestinoPacienteV2(dni, fechaCita);

            // Assert
            Assert.IsNotNull(result);
            Assert.IsTrue(result.Exito);
        }

        [TestMethod]
        public void Test_GetDestinoPacienteV2_WithInvalidInput_ReturnsFailure()
        {
            // Arrange
            var client = new WSDestinoPaciente();
            var dni = null;
            var fechaCita = null;

            // Act
            var result = client.GetDestinoPacienteV2(dni, fechaCita);

            // Assert
            Assert.IsFalse(result?.Exito ?? true);
        }

⚙ Internal Functions (1)

Helper methods inside the service implementation — not part of the public contract.

Private / Protected (1)

privateRespStringGetCUN360DestinoPacienteByDNI 📋 COPY-PASTE 85%(string dni)

🗄 All SQL Queries (2)

File	Query	Tables
DestinoPaciente.svc.cs	SELECT MIN(CI0100.CI01FECCONCERT) KEEP (DENSE_RANK FIRST ORDER BY CI01FECCONCERT) FECHA_CITA,
DestinoPaciente.svc.cs	SELECT OBTENER360_DNI(:dni) CUN360 from dual	dual

🧪 Tests

No formal unit tests found. Test project uses console-based manual invocation of each operation. See Suggested Test Stubs in each endpoint card above.