PharmaTrack

PharmaTrack is an upgraded pharmacy management system built with Windows Forms and backed by a SQL database. It helps pharmacists manage patients, drugs, and prescriptions with realistic workflows including insurance validation, drug interaction checks, refill alerts, and audit logging.

Features

• Persistent Storage: Uses SQL Server or SQLite for long-term data storage.
• Patient Management: Create and update patient records, allergies, and insurance info.
• Drug Management: Add/edit drugs, dosage limits, and mark controlled substances.
• Prescription Handling: Assign drugs to patients with dosage, refills, and dates.
• Interaction Checking: Warn about allergies or conflicting medications.
• Insurance Module: Link patients to insurance and verify coverage.
• Pharmacist Login: Basic authentication to track data input by user.
• Audit Log: Track data changes and user actions.
• Refill Reminders: Monitor when prescriptions are due for refill.
• Reporting: Export CSV or PDF summaries for prescriptions and logs.

Getting Started

1. Clone the repository:

   git clone https://github.com/ytsnake/PharmaTrack.git

2. Open the solution in Visual Studio.

3. Set up your SQL database (see TODO.md for detailed instructions).

4. Build and run the application.

Requirements

• Visual Studio (Community or above)
• .NET Framework (WinForms compatible)
• SQL Server or SQLite
• Optional: Entity Framework (recommended for DB access)

Project Structure

PharmaTrack/
├── Models/
│   ├── Patient.cs
│   ├── Drug.cs
│   ├── Prescription.cs
│   ├── Pharmacist.cs
│   └── InsuranceProvider.cs
├── Data/
│   └── ApplicationDbContext.cs
├── Forms/
│   ├── MainForm.cs
│   ├── DrugForm.cs
│   ├── PatientForm.cs
│   ├── PrescriptionForm.cs
│   ├── LoginForm.cs
│   └── InsuranceForm.cs
├── Services/
│   ├── RefillService.cs
│   ├── AuditLogger.cs
│   └── InteractionChecker.cs
├── Reports/
│   └── ReportExporter.cs
├── README.md
├── TODO.md
└── Program.cs

License

This project is for educational purposes.