Skip to content
Call Today800-600-5822
Programmers.io
Call Today800-600-5822
Menu
  • Hire An Expert
        • We are programming experts in both legacy and modern platforms.

          We extend your existing team so you can accomplish your goals faster. We offer an industry unique happiness guarantee on our work.

        • Legacy
          Programming
          • IBM i/AS400
          • EDI(Electronic Data Interchange)
          • IBM Cognos
          • C++
          • COBOL
        • Cloud Data
          Warehouse
          • Salesforce
          • Matillion
          • Snowflake
          • SharePoint
          • MS Azure
        • Frontend
          Development
          • Vue.Js
          • React.Js
          • Ext Js
          • Angular
          • Full Stack
        • Backend
          Development
          • .Net
          • Java
          • Python
          • Node Js
          • PHP
        • QA
          Testing
          • API Testing
          • Manual Testing
          • Automation Testing
          • Performance Testing
          • Quality Engineering
        • Tech
          stack
          • React.Js with Node JS
          • Vue.Js with Laravel
          • Vue.Js with Python
          • Angular with C#
          • React with C#
        • Data Engineering
          & Analytics
          • Business Intelligence
          • Data Stack Modernization
          • Data Warehouse
          • Power BI Services
        • Mobile App
          Development
          • React Native
          • Android
          • IOS
          • Xamarin
          • Ionic
        • ECommerce
          & CMS
          • Magento
          • WordPress
          • Drupal
          • Laravel
          • Joomla
        • Other
          Technologies
          • ERP
          • Ruby on Rails
          • IT Support and Services
          • Offshore Development
          • Delphi
  • Industries
        • We are programming experts in both legacy and modern platforms.

          We extend your existing team so you can accomplish your goals faster. We offer an industry unique “Don’t pay us if you are not satisfied” guarantee on our work.

        • Industries
          • Insurance Industry
          • Manufacturing Industry
          • Education Industry
          • Healthcare Industry
          • Technology Industry
          • Retail and Consumer Goods
          • Transportation and Warehousing Industry
  • About Us
        • We are programming experts in both legacy and modern platforms.

          We extend your existing team so you can accomplish your goals faster. We offer an industry unique “Don’t pay us if you are not satisfied” guarantee on our work.

        • Our Work
          • Customers
          • Case Studies
          • Portfolio
          • Testimonials
          • Video Testimonials
        • Our Company
          • About PIO
          • Why PIO
          • Happiness Guarantee
          • Team & Leadership
          • Recognition
          • IBM i Rising Stars
          • Life @ Programmers.io
          • Privacy Policy
        • Referral Program
          • Client Referral
          • Colleague Referral
        • Our News
          • News
          • Blog
          • Job Openings
          • Hiring
  • Contact Us
  • Hire Us Today800-600-5822
  • 800-600-5822
Case Studies

Built a single sign on web portal for a leading HVAC parts and supplies distributor

About our client

The client is an industry leading distributor of HVAC equipment parts and heating/air conditioning supplies. They deal in commercial as well as residential parts and supplies. Spread over 40 locations in 8 states (Ohio, Indiana, Kentucky, Illinois, Iowa, Pennsylvania, West Virginia, and Tennessee), the client is the 10th largest HVAC distributor in the U.S. and the largest independent Bryant distributor in North America. This client will be the Midwest preeminent HVAC distributor. Its customers trust and rely on it because of its outstanding customer service, high ethical standards, industry-leading products, and business partnerships. The company was named as the Tri-State Family Business of the Year by the University of Cincinnati Growing Center for Family Business. The client proudly employs over 500 people with over 10,000 cumulative years of HVAC expertise. It is an award winning company, receiving consistent recognition, awards and accolades from its manufacturing partners throughout the years. Programmers.io has successfully facilitated the client’s adoption of modernized cross-technology solutions while providing the state-of-the-art security solutions.

catIcon

Transportation and Warehousing

The Challenges

1. SSO Portal with OAuth 2.0 Security

The client was facing a major challenge working on the old AS400 screens and needed to adopt modernized cross-technology solutions with robust security. The application’s security was the biggest concern for the client as its existing application was based on a legacy system. The client also wanted a platform that would manage all its users and would have a separate database (PostgreSQL) created by leveraging the existing DB2 tables and RPG code from the AS400 box.

The Solution

01.

Our team designed a web-portal where users can sign in using SSO (Single Sign On) and could see all the application functionalities assigned to that user. The functionalities of the users were limited by adding certain roles, which assured security.

02.

If an admin user logs in, s/he gets additional features on the dashboard to manage

  • User info
  • Different applications that are available.
  • Manage authorities of roles.
  • Assign user to applications.

03.

As there were multiple apps, instead of maintaining separate logins for each application we used SSO so as to offer a generic login page for all the web applications.

04.

Programmers.io used modern RESTful API approach for performing all the database interactions. (All database information resides in AS400 box.)

Front-end Technologies

  • HTML, CSS, Bootstrap (Material Design), JS/jQuery.
  • The webpage is responsive/mobile friendly.

Back-end Technologies

  • JAVA Spring MVC to write our business logic.
  • For security OAuth 2.0 and JWT token.

2. PayPal Integration

Our client wanted to change its existing credit card gateway from Curbstone to PayPal. This change was required to secure the payment transaction procedure between the client and its customers. PayPal integration with any e-commerce platform enhances its authenticity and credibility. Programmers.io pitched in to build an architecture around the existing Curbstone RPG process to use PayPal APIs from AS400 and write new code for the integration.

The Solution

01.

Our team analyzed the existing process and found out that we could leverage most of the code to change the credit card gateway from Curbstone to PayPal.

02.

Our team started the analysis to find out the piece of code which we could replace with our new logic which calls the PayPal API for credit card transactions.

03.

Our suggestion was to use SQL to call the PayPal API, which is the latest technology to call any API from AS400 box introduced in V7R3.

3. Web Catalogue

Our client needed a way to view and maintain all the products in their database (DB2) along with their images which were stored on another Windows server. The client also required the functionality of full-text search (search over multiple fields and tables) and advance filtering.

The Solution

01.

For creating a web catalogue to maintain the data and images together, we created a JAVA web application (using SSO) where the user could easily sign in and have a wider look at all the products.

02.

We provided two different views (list/grid) for displaying the products. Customers could now see all the product information and images at a single place in a user-friendly manner.

03.

Customers could now apply filters to search for specific products as per their requirements. For full-text search and filtering we provided a section in HTML with different filters where users can apply multiple filters.

Front-end Design

  • HTML, CSS, Bootstrap (Material Design), JS/jQuery.

Back-end Technologies

  • We used JAVA Spring MVC to write our business logic.
  • Our team recommended OAuth 2.0 and JWT token for security.
  • We implemented SSO (Single Sign-On) for sign-in functionality.

4. Application for Generating invoices

The client was facing a huge challenge in providing the invoice to its customers on time. The customer had to call the customer support line or the client’s salesperson to ask for the invoice, which resulted into manual invoice generation and delivering. The client saw this as a cumbersome process and wanted a web application where the customers could log in, view their invoice, and download the invoice. The client also wanted a functionality where user could choose the file format of the invoice to be downloaded.

The Solution

01.

Our team designed a portal where a user could sign in and could see all their invoice details present in AS400 DB2. They could also change the date range to view their old invoices.

02.

User could choose multiple invoices to download at the same time. User could also search/sort/ filter invoices and open the list of invoices for the selected date range.

03.

In the invoice generation application the customer could select the file format (PDF/CSV/QuickBooks) in which he/she needed to download the invoice. They could also open any invoice in PDF format on the browser.

04.

All the data to generate the invoices resides on As400 DB2. So our APIs communicate with the DB2 to fetch the invoice information and then generate the invoice based on that information.

Front-end Technologies

  • HTML, CSS, Bootstrap (Material Design), JS/jQuery.
  • The webpage is responsive/mobile friendly.

Back-end Technologies

  • JAVA Spring MVC to write our business logic.
  • OAuth 2.0 and JWT token for security.
  • SSO (Single Sign On) for generic login page for all the web applications.
  • Modern RESTful API approach for executing all the Database (which resides in AS400 box) interactions.

5. Application to generate automated sales report

The client was facing a major challenge generating its sales report on the old AS400 screens. It was a complicated and time-consuming process since most of the steps involved were manual. The client wanted to adopt a modernized cross-technology solution to get rid of the traditional AS400 screens and add new functionalities like filtering and sorting to its sales reports. The client required an easy platform to view the sales summary on different levels.

The Solution

01.

Our team designed a web application where a management person could sign in using SSO and OAuth. The application will only allow those users who are authorized to view the application. All the summary was calculated using the data from their AS400 DB2 database.

02.

In the application user can:

  • View the report on multiple levels such as regional level, salesperson level and customer level.
  • Apply filters/sorting on any column.
  • Change the date range of the report as per requirement.
  • Download the report in Excel format.

Front-end Technologies

  • We used HTML, CSS, Bootstrap (Material Design), JS/jQuery.
  • The webpage is responsive/mobile friendly.

Back-end Technologies

  • JAVA Spring MVC to write our business logic.
  • For security we used OAuth 2.0 and JWT token.
  • Modern RESTful API approach for executing all the Database (DB2 & PostgreSQL) interaction.

Technology Stack

  • HTML HTML
  • CSS CSS
  • SSO portal SSO portal
  • OAuth 2.0 OAuth 2.0
  • JWT Token JWT Token
  • JS/Jquery JS/Jquery
  • Java Spring MVC Java Spring MVC
  • RESTful API RESTful API

Business Impact

Programmers.io enabled the client to easily manage the users and applications by building a modern web portal. Our team suggested the use of SSO (Single Sign On) for signing in and OAuth 2.0, which ensured the security of the web application.

PayPal integration through our approach decreased the development time to a fraction, hence saving our client a lot of time and money.

Programmers.io enabled the client to look at and maintain all their items through the application of a web catalogue in an easy and convenient way. Previously they had to maintain details (in DB2) and images (in image server) separately. Now they can maintain both from a single point.

Programmers.io invoice app helped the client’s customers to download their invoice from the application anytime. It has saved the time of both our client’s sales people and their customers.

Programmers.io enabled the client to easily view and generate sales reports using a modern and user-friendly web portal. This helped the client’s management team to see the report anytime and anywhere hassle free.

Read More Case Studies

Post navigation

PreviousPrevious Prev
NextNext

Testimonials

"We find your team to be true business partners. Exceptionally responsive, strong domain knowledge, and outstanding at execution."

Chief Integration Officer

"Happy with the performance. The team is self-driving, which is something I’ve had struggles with in the past. Very knowledgeable on the IBMi and requires minimal guidance."

Director of Information Technology

"Every developer we have worked with has been great! They are great at analyzing and making great suggestions, in addition to coding all that we ask for. Even with the time difference, they are always willing to work on "our hours" when needed for deadlines and projects as needed. Thanks for everything!"

Chief Information Security Officer

"The programmers I have worked with have all been great! They think out of the box and make suggestions, and they research and figure things out on their own, which is a tremendous help to me. I would recommend them to any prospective clients you have."

Project Manager

"Great team and still one of the best I’ve worked with on the IBMi/RPG environment"

VP, Commercial Excellence & Digitization

close
video-testimonials

Video Testimonials

Effectively Extending
Your Team

Ken Stewart, PMP, CSM

Vice president of operations & Engineering

PSigen Software Inc.

play-btn

Play Video

video-testimonials

Video Testimonials

Onboarding The Programmers.io Team

Brandy Churchill

Software Development Manager

Western National Insurance

play-btn

Play Video

video-testimonials

Video Testimonials

Effectively Extending
Your Team

Jackie Flummer

Director, Technical Business Systems

AmerCareRoyal

play-btn

Play Video

video-testimonials

Video Testimonials

Effectively Extending
Your Team

Luis Gonzalez

President

SalesScoreKeeper

play-btn

Play Video

View All

Contact Us Today!

Find out how Programmers.io can help your company
get to the next level.

Risk Free! We guarantee you’ll be happy after 30 days or we won’t invoice you.

Awards and Certifications

  • company-logo
  • company-logo
  • company-logo
  • company-logo
  • company-logo
  • company-logo
  • company-logo
  • company-logo
footer-logo
  • facebook
  • twitter
  • linkedin
  • youtube
Legacy Platforms
  • EDI(TrustedLink)
  • IBM Cognos
  • Mainframe/Cobol
  • Delphi
  • C++
Modern Platforms
  • Python
  • Java
  • Dot Net
  • React.Js
  • Salesforce
  • iOS
  • Android
  • PHP
  • Cloud Engineering
  • Angular
About Programmers.io
  • About pio
  • Hire Us
  • We are hiring
  • Job Openings
  • Happiness Guarantee
  • Team & Leadership
  • Recognition
  • Blog
  • Privacy Policy
  • Hire Developers
Contact Us

8951 Cypress Waters Blvd
STE 160
Dallas, TX 75019-4784 USA

800-600-5822

India Offices

Jaipur Office:

C-60, Lalkothi Scheme, Behind Vidhansabha, Jaipur, Rajasthan 302015, Phone No.: +91 95295 66661

Hyderabad Office:

Hitech City. Vatika Business Center, Whitefields Kondapur, Hyderabad 500081

Pune Office:

Office no. 301, TRIOS Coworking space, Pune, Maharashtra 411014

  • facebook
  • twitter
  • linkedin
  • youtube
Copyright © 2023 programmers.io | All Rights Reserved.
chatbot
United States