EazyPay Payment API

API Integration Overview

Integrated ICICI EazyPay Verification API using Merchant ID authentication

Implemented secure transaction validation using Transaction ID

API responses are parsed and validated before displaying results

Ensured reliable handling of successful, failed, and pending transactions

Application Workflow

1. Transaction Search Module

• Created a form where users can enter a Transaction ID
• Search action triggers API verification
• Verified transaction details are displayed instantly
• Invalid or duplicate transactions are handled gracefully
•  

2. GST Calculation Module

• Net transaction amount is fetched from the API response
• Added GST Type dropdown:
  • Intrastate (CGST + SGST)
  • Interstate (IGST)
• GST is calculated automatically based on selection
• Final payable amount is displayed clearly to the user

Database & Data Management

Transaction Data Storage

• Designed a normalized SQL Server table to store verified transaction records
• Stored data includes Transaction ID, Merchant ID, Net Amount, GST details, total amount, and status
• Maintained timestamps for auditing and traceability

Stored Procedure Usage

• All database operations are handled using stored procedures
•  
• Implemented procedures for:
  • Saving new verified transactions
  • Updating existing transaction records
  • Deleting transactions using Transaction ID
• This approach improves security, performance, and data integrity

Delete Transaction Functionality

• Implemented controlled deletion of records using Transaction ID
• Prevents unauthorized or accidental data removal
• Ensures database consistency and clean data management
•  

Key Features & Highlights

• .NET-based enterprise-ready architecture
• Secure ICICI EazyPay API verification
• Dynamic GST calculation (Intrastate / Interstate)
• SQL Server stored procedure–driven CRUD operations
• Clean UI for transaction search and display
• Scalable design suitable for fintech and ERP systems
•  

Final Outcome

✔ Successfully integrated ICICI EazyPay payment verification
✔ Built transaction search and validation system
✔ Implemented GST-compliant calculation logic
✔ Designed secure and optimized database structure
✔ Applied best practices using stored procedures

Conclusion

This task enhanced my expertise in .NET application development, banking API integration, GST-compliant financial calculations, and SQL Server database optimization.
The completed system is secure, scalable, and suitable for real-world payment verification and billing applications.