The Programmers.io team built a single sign-on web portal for a leading HVAC parts and supplies distributor

About 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.

Transportation and Warehousing

The Challenges

1. SSO Portal with OAuth 2.0 Security

The client was facing a major challenge working on the old IBM i/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 IBM i/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 IBM i/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 IBM i/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 IBM i/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 IBM i/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 IBM i/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 IBM i/AS400 box) interactions.

5. Application to generate automated sales report

The client was facing a major challenge generating its sales report on the old IBM i/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 IBM i/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 IBM i/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

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.

Check out our
success stories

Testimonials

"The team is performing really well. They are learning fast and work with our team and culture well."

‐ Applications Director

"The team at Programmers.io has been fantastic. I was surprised at how fast they learned our system and were producing code…"

‐ EDI Manager

"I have been working with Programmers IO for more than 5 years now and I have been pleased with all projects and developers that I have worked with. We have had a few issues here and there but they have always fixed and made it right. They have been an excellent addition to our business."

‐ Director Of Development

"Always a pleasure to work with."

‐ Project Manager

"It has been a pleasure. Everyone is very responsive, and we get good quality work."

‐ Corporate Project Manager

"The professionalism and work that was done is outstanding. The ability to collaborate and communicate about changes is exceptional. The team is very responsive and supportive even with questions that did not pertain to the e-info aspect. They are great to work with and were very helpful in making all this work effectively and efficiently."

‐ IT Manager

"Team is doing great. Very engaged, very skilled in the area of IBMi/AS400 capabilities. Works very well proposing solutions to presented problem statements or use cases."

‐ Director of Information Technology

"Great team to work with."

‐ Director of Information Technology

"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

"We LOVE your solution!"

‐ Sales Director

"Very responsive and explain things to me in a way I can understand since I am not an AS400 person at all. The level of service and support with them is one of the best I have had with an outside contractor."

‐ Information Technology Supervisor

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

‐ Chief Integration Officer

"You guys Rock!"

‐ EDI Coordinator

"Over the past year I have worked with them, they have worked very hard to understand our highly customized system and troubleshoot things with little or no documentation while managing to keep the business up and running normally. Without the hard work and dedication, they have shown, I know we would have had some issues causing downtime or lost production. I am looking forward to continuing working them in the next year as well."

‐ Information Technology Supervisor

"The team that works with us is outstanding and are excellent to work with."

‐ Information Technology Supervisor

"The team meets and exceeds expectations. There isn't opportunity to "deliver early" the way I assign work to the team, they deliver exactly as I need which is great."

‐ Senior Consultant, Project Manager

"Nice to deal with. Professional results."

‐ Manager of Information Technology

"Team is professional and skilled"

‐ System Engineer Analyst Principal - IT

"The Programmers.io team is very flexible and accommodating."

‐ IT Project Manager

"I have been extremely pleased with the partnership we have had with Programmers.io and the resources to assist us."

‐ IT Analyst

"Our experience with Programmers.io has been exceptional in quantity and quality of work."

‐ Lead Developer

"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

"Everyone we have dealt with is great and they have helped make my job in managing projects a lot easier! Not only do they do the work requested, they ask great questions and make great suggestions."

‐ Project Manager

"I just want to say thanks so much for the guys that have been working on the Agent Sync / Salesforce project. They literally saved my job this week. I really appreciate all they do!"

‐ Project Manager

"We have had an exceptional experience with this new team in 2021.They came up to speed very quickly and have handled every assignment professionally and delivered great value & quality."

‐ Director of Application Delivery

"I've been consistently impressed with Programmers IO. There have been a couple issues along the way, but we've been able to resolve that quickly with options for what to do. I think the team working with our company is successful and happy with their work, work schedules, having clear expectations, and peer relationships."

‐ Director of Engineering

"I appreciate that the contractors we have working with us have support from ProgrammersIO. The management team is always available and helps to resolve problems or provide needed information."

‐ Director of Engineering

"The team with PIO has done a wonderful job for us!"

‐ IT Manager

"The team we work with is great in every way. We feel confident in the support we get during the day to day to the yearly maintenance."

‐ CFO

"The team goes above and beyond."

‐ IT Global Service Desk Manager

"The best support group at ____ and one of the best I've ever worked with. The response is great, constantly keeping in touch and when I ask for changes, they are done promptly and accurately."

‐ President

"It's been very easy to work with the developers at Programmer.io. They do a great job!"

‐ IT Project Manager

"Changes are made quickly and correctly. My programmers here hate the way I test their code because I always find a way to break it. I’ve tried to break the PIO code and I couldn’t."

‐ Vice President of Operations

"Are "Very Happy" and "Very Effective" the highest I can go?"

‐ Vice President of Operations

"I am very comfortable knowing that I can count P.io as part of my team."

‐ IT Project Manager

"The entire programming team at Programmers.io is amazing to work with."

‐ Vice President of Operations

"We've been very happy with Programmers.IO. So much so, we are rotating our other teams to include Programmers.IO into the mix."

‐ Business Intelligence Mgr.

"The team has been both patient and extremely responsive. They have worked through all concerns and issues and are dedicated to making our goals work. I am very pleased."

‐ Human Resource Manager

"I have really enjoyed having _______ on our team. She has helped me much to organize the work of the developers."

‐ Senior Director of Application Development

"The team has done all that we've asked of them. We'd like to continue to increase the work scope as time goes on. Nothing but great things to say so far regarding the work completed by the team."

‐ Director, Support Manager

"I appreciate how dedicated the team is to working hard on projects and getting things done in a timely matter. They take every effort to try and completely understand not only the project but how it will be used in our business."

‐ Computer Programmer

"I wanted to take a moment to highlight and commemorate the efforts from our dedicated IO team. To preface, the projects we work on here are complex: with rigid objectives, budgets, and timelines. Expectations are always high and are ever changing. From the start of our relationship, the IO team was able to exceed expectations and make our business wishes a reality."

‐ Project Manager

"The PIO Team has been great. Very professional, helpful and with great attitudes. We enjoy working with them and get many compliments from within our IT department and from other areas of the company. Keep up the good work!"

‐ Director of Technical Business Systems

"Programmers.io has been so helpful. We have been using them for over 18 months and I am constantly looking for more projects to send them."

‐ Director, Implementation and Support, Land & Vitals

"I have been working with Programmers IO of years and they have always been able to provide the programmers we have needed to grow our business. They are honest and upfront with everything and have delivered what was promised. They are an asset to the growth and our business."

‐ Director Of Development

"We are very happy with the services programmers.io provides."

‐ Vice President Information Technology

"The team is extremely responsive, flexible, and produces quality work consistently."

‐ IT Project Manager

"Great team, very engaged and creative in enabling our organization to have operate efficiently and deploy new value add solutions."

‐ Director of Information Technology

"Very good on AS400 development. Account rep has always been helpful and responsive."

‐ Director of Information Technology

"They are very dependable and complete their tasks in a timely manner."

‐ Manager, Information Technology

"I continue to appreciate the consistently good work of Vipul Kumar as the developer on my project."

‐ Project Manager/Business Analyst

"I appreciate the communication and the quick turnaround from Programmers IO!"

‐ IT Business Analyst

"We have worked with PIO since early 2020 and it has been a great experience for us and allowed us to gain additional automation of manual processes for Accounting group. It is a great experience to work with knowledgeable developers like Kapil, Praveen and Tushar on our projects. Thank you!"

‐ IT Project Manager

"The response time and service Programmers.io provides is consistently excellent! It is much appreciated."

‐ Director of Engineering

"We are still early in the relationship with Programmers.io. So far you are doing a good job completing the requests we have given you. As we use your services on more complex projects I will have a more defined opinion I can share in the future."

‐ Corporate Director, Information Technology

"Guys are awesome."

‐ IT Global Service Desk Manager

"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. I just wish they were here LOL. 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

Video Testimonials

Effectively Extending
Your Team

Ken Stewart, PMP, CSM

Vice president of operations & Engineering

PSigen Software Inc.

Play Video

Video Testimonials

Onboarding The Programmers.io Team

Brandy Churchill

Software Development Manager

Western National Insurance

Play Video

Video Testimonials

Effectively Extending
Your Team

Jackie Flummer

Director, Technical Business Systems

AmerCareRoyal

Play Video

Video Testimonials

Effectively Extending
Your Team

Luis Gonzalez

President

SalesScoreKeeper

Play Video

View All

85% Faster IBM i Impact Analysis with AI

Checkout Our New IBM i e-Book

85% Faster IBM i Impact Analysis with AI

Checkout Our New IBM i e-Book

85% Faster IBM i Impact Analysis with AI

Checkout Our New IBM i e-Book

85% Faster IBM i Impact Analysis with AI

Checkout Our New IBM i e-Book

The Programmers.io team built a single sign-on web portal for a leading HVAC parts and supplies distributor

About Client

Transportation and Warehousing

The Challenges

The Solution

01.

02.

03.

04.

Front-end Technologies

Back-end Technologies

The Solution

01.

02.

03.

The Solution

01.

02.

03.

Front-end Design

Back-end Technologies

The Solution

01.

02.

03.

04.

Front-end Technologies

Back-end Technologies

The Solution

01.

02.

Front-end Technologies

Back-end Technologies

Technology Stack

Business Impact

Check out our success stories

Testimonials

"The team is performing really well. They are learning fast and work with our team and culture well."

"The team at Programmers.io has been fantastic. I was surprised at how fast they learned our system and were producing code…"

"I have been working with Programmers IO for more than 5 years now and I have been pleased with all projects and developers that I have worked with. We have had a few issues here and there but they have always fixed and made it right. They have been an excellent addition to our business."

"Always a pleasure to work with."

"It has been a pleasure. Everyone is very responsive, and we get good quality work."

"Team is doing great. Very engaged, very skilled in the area of IBMi/AS400 capabilities. Works very well proposing solutions to presented problem statements or use cases."

"Great team to work with."

"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."

"We LOVE your solution!"

"Very responsive and explain things to me in a way I can understand since I am not an AS400 person at all. The level of service and support with them is one of the best I have had with an outside contractor."

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

"You guys Rock!"

"The team that works with us is outstanding and are excellent to work with."

"The team meets and exceeds expectations. There isn't opportunity to "deliver early" the way I assign work to the team, they deliver exactly as I need which is great."

"Nice to deal with. Professional results."

"Team is professional and skilled"

"The Programmers.io team is very flexible and accommodating."

"I have been extremely pleased with the partnership we have had with Programmers.io and the resources to assist us."

"Our experience with Programmers.io has been exceptional in quantity and quality of work."

"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."

"Everyone we have dealt with is great and they have helped make my job in managing projects a lot easier! Not only do they do the work requested, they ask great questions and make great suggestions."

"I just want to say thanks so much for the guys that have been working on the Agent Sync / Salesforce project. They literally saved my job this week. I really appreciate all they do!"

"We have had an exceptional experience with this new team in 2021.They came up to speed very quickly and have handled every assignment professionally and delivered great value & quality."

"I appreciate that the contractors we have working with us have support from ProgrammersIO. The management team is always available and helps to resolve problems or provide needed information."

"The team with PIO has done a wonderful job for us!"

"The team we work with is great in every way. We feel confident in the support we get during the day to day to the yearly maintenance."

"The team goes above and beyond."

"The best support group at ____ and one of the best I've ever worked with. The response is great, constantly keeping in touch and when I ask for changes, they are done promptly and accurately."

"It's been very easy to work with the developers at Programmer.io. They do a great job!"

"Changes are made quickly and correctly. My programmers here hate the way I test their code because I always find a way to break it. I’ve tried to break the PIO code and I couldn’t."

"Are "Very Happy" and "Very Effective" the highest I can go?"

"I am very comfortable knowing that I can count P.io as part of my team."

"The entire programming team at Programmers.io is amazing to work with."

"We've been very happy with Programmers.IO. So much so, we are rotating our other teams to include Programmers.IO into the mix."

"The team has been both patient and extremely responsive. They have worked through all concerns and issues and are dedicated to making our goals work. I am very pleased."

Checkout Our
New IBM i e-Book

Checkout Our
New IBM i e-Book

Checkout Our
New IBM i e-Book

Checkout Our
New IBM i e-Book

Check out our
success stories

Effectively Extending
Your Team

Effectively Extending
Your Team

Effectively Extending
Your Team

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