Wasim Akhtar

Database Architect, Designer and Developer

My motto: If you can explain it to me, I can develop it for you!
For a QUICK development summary, please look at SCREENSHOTS under Recent Applications!
Skip Navigation Links.
Copyright © 2000-2020
Practical Software Solutions

PSS Logo

Website Updated
Dec-2020
 
Certified Tickets Registry (CTR-MVC5)
Purpose Developed a full-featured MVC5 website for registering Certified Safety Tickets issued by government agencies and other organizations. It also includes administrative features for managing account and membership renewals; including recurring credit and debit card payments.

It includes a Windows Service to process Automatic Email Notifications for expiring and expired Safety Tickets. This Windows Service also monitors a folder to report successful payments by RC4 Encrypted XML Transaction files from the Credit Card Service.

Screens To view a few key screenshots from this application, please click on the following links (demo data):

Home Page Memberships FAQs
Register Member Details User Profile
Search Users Search Tickets Search Payments
Ticket Details Payment Details Database Diagram

NOTE: For more screenshots, please send a request to: software786@hotmail.com

Description A Registered User can enter relevant Safety Ticket information into their account, and retrieve that information from any workstation or portable device. A scanned image of each Safety Ticket is also kept in the database, so that it can be shown to the appropriate authorities, as and when needed. Automatic renewal notices are sent to Registered Users when their Safety Tickets approach Expiration Dates. These notices are automatically sent 90, 30 and 7 days prior to each Safety Ticket's Expiration Date. If information of a renewed Safety Ticket is not entered prior to it's Expiration Date, that Safety Ticket is automatically marked as Expired, and an Expiration Notice is sent to the Registered User.

Similar capabilities are going to be available to employees of companies that register for this service.

Future releases are planned for automatic updates of Expired Safety Tickets directly from the Certiface Issuing Authorities.

Bootstrap was used throughout the application to manage and display content according to the device-width and display size.

MVC Summary: This application includes 10 Models, 5 Controllers, and more than 60 Views.

Features Following are some of the key features of this application:
  • Credit and Debit Card Payments are processed through a third-party provider
  • Payment confirmation notices sent by the provider in encrypted XML files are handled automatically
  • Non-Members are given the standard merketing segments when they visit the website
  • Upon registration, Registered Users are assigned the Role of a Member
  • Once logged-in from a device, Registered Users do not have to re-enter password
  • Registered Users are automatically taken to their User Profile page, which summarizes their Account Information
  • User Profiles also include lists of Safety Tickets and Payment History
  • Each Registered User can be assigned one-of-three Roles: Member, Staff, or Admin
  • User Interface is automatically configured based on the Role assigned when they Login
  • Automatic setup of Recurring Payments
  • Automatic adjustment of Safety Ticket lists upon Payment Expiration
  • Certified Safety Ticket information is displayed with Ticket Images
Components This application comprises of the following main components:
  • User Registration
  • Membership Management
  • Certified Safety Tickets Management
  • Reset Password Tool with Key Token
  • Search Tools for Registered Users, Safety Tickets and Payments by Staff
  • Access Tools for any information for Registered Users, Safety Tickets and Payments by Administrators
  • Windows Service for Sending 90-day, 30-day and 7-day Ticket Expiration Notices
  • Windows Service for Sending Expired Ticket Notice on the day of Expiration
  • Windows Service to process Payment Confirmations sent by the Credit Card Processor
Technology Used The following software development tools and services were used for this application:
  • Development Platform: Microsoft Visual Studio 2013
  • Programming Language: C#
  • Website Tools: MVC5, Razor, ASP.NET, HTML5, JavaScript, jQuery, XML, etc.
  • Database: Microsoft SQL Server 2014
  • CSS Technology: Bootstrap with Themes
  • Encryption: RC4
  • Email Server: Google Email Service
  • Integration Services: FoxyCart Credit Card Service
Visual Studio, C#, Razor, ASP.NET, and MS-SQL Server are the Registered Trade Marks of Microsoft Corporation