Implementing PATCH Endpoints and Validation in PharmaStock

 This week, I focused on expanding the backend functionality of PharmaStock by implementing PATCH endpoints for both medication and inventory records. The goal was to allow partial updates while maintaining strong validation and data integrity.

On the medication side, I created a PATCH endpoint that supports updating fields such as name, description, National Drug Code (NDC), generic name, form, strength, and manufacturer. Each field is validated to prevent empty or invalid values, and duplicate NDC entries are blocked to ensure data consistency.

For inventory management, I implemented multiple PATCH endpoints to handle updates to expiration dates, beyond-use dates (BUD), and package-level details such as package NDC and descriptions. Special attention was given to date validation rules. Expiration dates cannot be set in the past, and beyond-use dates cannot exceed the expiration date. These validations help maintain safe and realistic inventory tracking.

I also kept the quantity adjustment functionality separate, using a dedicated endpoint that updates stock levels and logs usage history for future AI-driven insights.

Overall, this work improved the flexibility of the system while ensuring that all updates remain safe, validated, and consistent with real-world pharmacy requirements.




Comments

Post a Comment

Popular posts from this blog

PharmaStock: Backend Infrastructure & Database Connectivity

 This week marked the transition from planning and design into real backend development. After organizing the project structure and defining use cases in previous weeks, I focused on building the technical foundation that the rest of the application will depend on. The primary goal was completing SCRUM-16, which involved connecting the ASP.NET Core backend API to a MySQL database and verifying that the system could successfully generate and manage database tables. I began by configuring MySQL to run inside a Docker container. Using Docker ensures that every developer on the team works against the same database environment, which reduces setup inconsistencies and avoids the common “it works on my machine” problem. Once the container was running correctly, I verified that it could be started, stopped, and inspected reliably. Next, I integrated Entity Framework Core with the Pomelo MySQL provider and registered the DbContext within the application. This step allows the backend to m...
Read more

PharmaStock Backend Progress Complete all backend endpoints

Image
 I completed the full Medication API (GET, POST, PUT, PATCH, DELETE) and finished SCRUM-37, implementing the stock quantity adjustment endpoint. Inventory quantities can now be increased or decreased, negative values are prevented, and all changes persist correctly in the database. I also finalized the inventory creation flow with duplicate lot validation and verified everything through Swagger testing. On the frontend side, I started SCRUM-38 and began building the Angular inventory list component to connect the UI to the new backend functionality. Overall, this week solidified the backend foundation and began transitioning into full-stack development. Medication Post Workflow            Medication Post          Post Inventory for new medication               Inventory adjustments
Read more

PharmaStock: Sprint Planning Complete

This week was focused on finalizing project planning and getting everything ready for development. I completed the setup of the Jira board , finalized all sprints for the full length of the project, and added clear completion criteria for each sprint and task. This gives the team a clear roadmap from MVP through enhancement features. I also synced my local GitHub setup with the main project repository and verified that the branching structure is ready for feature development. With planning complete and source control aligned, the project is now fully prepared to move into active development next week.
Read more