Scientific Article Management - Project .NET Framework

• Naam: Akshat Verma
• Academiejaar: 24-25
• Klasgroep: ISB204B
• Onderwerp: Scientist * - * Scientific article * - 1 Science Journal

Sprint 1

classDiagram
  class Scientist
  class ScientificArticle
  class ScienceJournal

  Scientist "*" -- "*" ScientificArticle
  ScientificArticle "*" -- "1" ScienceJournal

Loading

Sprint 3

Beide zoekcriteria ingevuld

 SELECT "s"."ScientistId", "s"."DateOfBirth", "s"."Faculty", "s"."Name", "s"."University"
 FROM "Scientists" AS "s"
 WHERE "s"."DateOfBirth" = @__dateOfBirth_0
   AND instr(lower("s"."Name"), @__ToLower_0) > 0

Enkel zoeken op naam

SELECT "s"."ScientistId", "s"."DateOfBirth", "s"."Faculty", "s"."Name", "s"."University"
FROM "Scientists" AS "s"
WHERE instr(lower("s"."Name"), @__ToLower_0) > 0

Enkel zoeken op geboortedatum

SELECT "s"."ScientistId", "s"."DateOfBirth", "s"."Faculty", "s"."Name", "s"."University"
FROM "Scientists" AS "s"
WHERE "s"."DateOfBirth" = @__dateOfBirth_0

Beide zoekcriteria leeg

SELECT "s"."ScientistId", "s"."DateOfBirth", "s"."Faculty", "s"."Name", "s"."University"
FROM "Scientists" AS "s"

Sprint 4

classDiagram
  class Scientist
  class ArticleScientistLink
  class ScientificArticle
  class ScienceJournal

  Scientist "1" -- "*" ArticleScientistLink
  ArticleScientistLink "*" -- "1" ScientificArticle
  ScientificArticle "*" -- "1" ScienceJournal

Loading

Sprint 6

Nieuwe science journal

Request

POST https://localhost:7176/api/ScienceJournals HTTP/1.1
Accept: application/json
Content-Type: application/json

{"name":"Bio+", "price":null, "yearFounded": 2012, "countryOfOrigin": 4}

Response

HTTP/1.1 201 Created
Content-Type: application/json; charset=utf-8
Date: Sun, 29 Dec 2024 01:00:11 GMT
Server: Kestrel
Location: https://localhost:7176/api/ScienceJournals/6
Transfer-Encoding: chunked

{
  "id": 6,
  "name": "Bio+",
  "price": null,
  "yearFounded": 2012,
  "countryOfOrigin": 4,
  "articles": []
}

Sprint 7

Gebruikers

	Rol	Email	Wachtwoord
1	user	default.user@kdg.be	DefaultUser123!
2	user	bob@kdg.be	Bob123!
3	user	marley@kdg.be	Marley123!
4	user	ross@kdg.be	Ross123!
5	admin	de.bouwer@kdg.be	DeBouwer123!

Web API

Niet als aangemelde gebruiker

Request

POST https://localhost:7176/api/ScienceJournals HTTP/1.1
Accept: application/json
Content-Type: application/json

{"name":"Bio+", "price":null, "yearFounded": 2012, "countryOfOrigin": 4}

Response

HTTP/1.1 401 Unauthorized
Content-Length: 0
Date: Sun, 23 Feb 2025 14:06:31 GMT
Server: Kestrel
Location: https://localhost:7176/Identity/Account/Login?ReturnUrl=%2Fapi%2FScienceJournals

<Response body is empty>

Wél als aangemelde gebruiker

Request

POST https://localhost:7176/api/ScienceJournals HTTP/1.1
Accept: application/json
Content-Type: application/json
Cookie: .AspNetCore.Identity.Application=CfDJ8IyEH_NxhK1FmLPBzcQPeCCp460htM7Pv_6htv_UhibvYjV8PVisDEnBnFtftdNodbX4AUzBmCLVzjBV81V8VME6Dq32k4-_q5piumNI-RY5I4YEFV6nFtP5qVnUQ24dtWkfTMy_nLzFZZXYNzgXXXKyiy84Iq3mzcJOi_tQ7D-cdSgL_SpHF_OhD5WR8hGY6G-9FaBfZnWasYQIYg1J3JPKzq07FXvBjOxMFZ1HunNL-t6yBZkZLzsTUFp2wGIZo615j8FK6499j-nhrnihas4lgfyIGNjbjR-0K28qPKsUIRLOJmGFBXRC2ztYdWjDiNHUcPKoS4Mrs8ZmDZcS4a5P40sTwRlQ4dcnHRj-3qbY9KUYGW6xEMxVRzh8A3ZmQn8F_oN1fcLYKRtHNEMbuoIsTyO6mGFp9aEeqdXE9gLfmBfHwuxlwkT3G0w3YzepqCIrBapxHiLTy2uzy3zR-pTbEcDsQRYL7g1XKwuyy_aXD_eEm-1xu40KX8WJPx7jj6oeResBmCYBeoilihWyCr-m3BtNq99v-AjAWyi7NWPWLYvBVKEXI73IpEK2mNLIm8_vzKR78hQ8aYnvBKepPeCtmhUehV3usFTr66KOYbstGjYRmkGNG3zHVgaKln-5kmabJR_IDqKBygohGmFxqshdEPTjfsQga9ySw-HfQdSwzKZEFFhqx7IgEjC5r3tYZ9wigbxTVZo8ds-OrsRQkqQx9ouxopW0oDom0GvGMKnr2Nkqt9VqfBiJKGNgqZA8r4VO1H43xLBqXox-XJYxLhOnORfpXDreM-vtTC5JXbpr_8y_5uShfYc8UlXLu82GmkPFPiwfNs4-PGwlyyt2R3c

{"name":"Bio+", "price":null, "yearFounded": 2012, "countryOfOrigin": 4}

Response

HTTP/1.1 201 Created
Content-Type: application/json; charset=utf-8
Date: Sun, 23 Feb 2025 14:06:18 GMT
Server: Kestrel
Location: https://localhost:7176/api/ScienceJournals/6
Transfer-Encoding: chunked

{
  "id": 6,
  "name": "Bio+",
  "price": null,
  "yearFounded": 2012,
  "countryOfOrigin": 4,
  "articles": []
}

Sprint 8

  dotnet test

Test complexe authorization

• Tests.IntegrationTests.ScientificArticlesControllerTests
• Tests.UnitTests.ScientificArticlesControllerTests

Test verification

• Tests.UnitTests.ManagerTests
• Tests.UnitTests.ScientificArticlesControllerTests

Links

• Pipeline tests
• Code coverage