OutSystem

 

Docker

 wsl --install

Enable-WindowsOptionalFeature -Online -FeatureName Microsoft-Hyper-V -All

docker desktop engine ls

docker desktop engine use windows

open power shell with admin and run below command

Enable-WindowsOptionalFeature -Online -FeatureName $("Microsoft-Hyper-V", "Containers") -All

1️⃣ Docker Desktop Install করো

Step 2: rancher  desktop statrt/run (icon click start menu)

Step 3

docker run -d -p 8080:8080 mvc-app:latest  

Microsoft Power Platform

 Microsoft Power Platform একটি কম্প্রিহেনসিভ টুলসেট, যা ব্যবসায়িক অ্যানালাইটিক্স, অ্যাপ্লিকেশন ডেভেলপমেন্ট, স্বয়ংক্রিয় কাজ এবং ভার্চুয়াল এজেন্ট তৈরির জন্য ডিজাইন করা হয়েছে। এর প্রধান চারটি উপাদান হল: Power BI, Power Apps, Power Automate, এবং Power Virtual Agents। নিচে প্রতিটি উপাদানের বিস্তারিত আলোচনা করা হলো:

https://sattacademy.com/guide/power-platform-%E0%A6%95%E0%A6%BF-%E0%A6%AA%E0%A6%BE%E0%A6%93%E0%A7%9F%E0%A6%BE%E0%A6%B0-%E0%A6%AA%E0%A7%8D%E0%A6%B2%E0%A6%BE%E0%A6%9F%E0%A6%AB%E0%A6%B0%E0%A7%8D%E0%A6%AE-%E0%A6%AC%E0%A6%BE%E0%A6%82%E0%A6%B2%E0%A6%BE-%E0%A6%9F%E0%A6%BF%E0%A6%89%E0%A6%9F%E0%A7%8B%E0%A6%B0%E0%A6%BF%E0%A7%9F%E0%A6%BE%E0%A6%B2

১. Power BI

বিবরণ: Power BI একটি শক্তিশালী অ্যানালিটিক্স টুল যা ব্যবহারকারীদের ডেটা বিশ্লেষণ, রিপোর্ট তৈরি এবং ডেটা ভিজ্যুয়ালাইজেশন করতে সাহায্য করে।

বৈশিষ্ট্য:

ডেটা সংযোগ: বিভিন্ন উৎস (যেমন SQL Server, Excel, SharePoint, এবং ক্লাউড ভিত্তিক ডেটা) থেকে ডেটা সংগ্রহ করতে সক্ষম।

ভিজ্যুয়ালাইজেশন: ব্যবহারকারীরা বিভিন্ন প্রকারের চার্ট, গ্রাফ এবং ড্যাশবোর্ড তৈরি করতে পারেন।

রিপোর্ট শেয়ারিং: রিপোর্ট এবং ড্যাশবোর্ডগুলি সহজেই দলের সদস্যদের সাথে শেয়ার করা যায়।

ডেটা বিশ্লেষণ: ডেটা বিশ্লেষণের জন্য DAX (Data Analysis Expressions) ব্যবহার করা হয়, যা অত্যন্ত শক্তিশালী।

২. Power Apps

বিবরণ: Power Apps একটি লো-কোড প্ল্যাটফর্ম যা ব্যবহারকারীদের কাস্টম অ্যাপ্লিকেশন তৈরি করতে সাহায্য করে, বিশেষ করে যারা উন্নত প্রোগ্রামিং দক্ষতা রাখেন না।

বৈশিষ্ট্য:

লোগিক তৈরি: অ্যাপ্লিকেশন তৈরির জন্য ড্র্যাগ-অ্যান্ড-ড্রপ ইন্টারফেস।

শ্রেণীবদ্ধ অ্যাপ: কাস্টম মোবাইল এবং ওয়েব অ্যাপ্লিকেশন তৈরি করা যায়।

ডেটা সংযোগ: Microsoft Dataverse, SharePoint, এবং অন্যান্য ডেটাবেসে সহজে সংযোগ স্থাপন করা যায়।

শেয়ারিং এবং নিরাপত্তা: তৈরি করা অ্যাপ্লিকেশনগুলো সহজে শেয়ার করা যায় এবং নিরাপত্তা নিয়ন্ত্রণ করা যায়।

৩. Power Automate

বিবরণ: Power Automate (পূর্বে Microsoft Flow নামে পরিচিত) একটি স্বয়ংক্রিয়তা প্ল্যাটফর্ম যা ব্যবহারকারীদের বিভিন্ন কাজ ও প্রক্রিয়া অটোমেট করতে সহায়তা করে।

বৈশিষ্ট্য:

ওয়ার্কফ্লো তৈরি: বিভিন্ন অ্যাপ্লিকেশন এবং পরিষেবার মধ্যে কাজের প্রবাহ তৈরি করতে সক্ষম।

Triggers: নির্দিষ্ট ঘটনাগুলির উপর ভিত্তি করে স্বয়ংক্রিয় কাজ শুরু করা যায় (যেমন, নতুন ইমেইল আসা বা ফাইল আপলোড করা)।

Integration: শতাধিক অ্যাপ্লিকেশন এবং সেবার সাথে সংযোগ করতে সক্ষম (যেমন, SharePoint, OneDrive, Dynamics 365)।

Approval Processes: সহজে অনুমোদন প্রক্রিয়া তৈরি করা যায়।

৪. Power Virtual Agents

বিবরণ: Power Virtual Agents একটি টুল যা ব্যবহারকারীদের কোড ছাড়াই চ্যাটবট তৈরি করতে সাহায্য করে, যা গ্রাহক সহায়তা এবং ব্যবসায়িক যোগাযোগের জন্য ব্যবহৃত হয়।

বৈশিষ্ট্য:

চ্যাটবট নির্মাণ: ড্র্যাগ-অ্যান্ড-ড্রপ ইন্টারফেস ব্যবহার করে সহজে চ্যাটবট তৈরি করা যায়।

নির্ধারিত প্রশ্ন ও উত্তর: ব্যবহারকারীরা চ্যাটবটের প্রশ্ন ও উত্তর নির্ধারণ করতে পারেন।

Integration: Power Virtual Agents অন্যান্য Power Platform উপাদান এবং Microsoft 365-এর সাথে সংযোগ করতে সক্ষম।

নিরীক্ষণ এবং বিশ্লেষণ: চ্যাটবটের কার্যকারিতা বিশ্লেষণ করার জন্য রিপোর্টিং এবং বিশ্লেষণ সরঞ্জাম প্রদান করে।

উপসংহার

Microsoft Power Platform-এর এই চারটি উপাদান ব্যবসায়িক কাজের কার্যকারিতা বাড়াতে এবং স্বয়ংক্রিয়তা আনতে সাহায্য করে। Power BI ডেটা বিশ্লেষণের জন্য, Power Apps কাস্টম অ্যাপ্লিকেশন তৈরির জন্য, Power Automate কাজের প্রবাহ অটোমেট করার জন্য, এবং Power Virtual Agents গ্রাহক যোগাযোগের জন্য কার্যকরী। এই উপাদানগুলির সমন্বয় ব্যবসায়িক সমস্যাগুলি সমাধানে একটি শক্তিশালী প্ল্যাটফর্ম তৈরি করে।

Copied from SATT ACADEMY. Visit us at: https://sattacademy.com

AI

 

PB Peterbilt

 Islamic Society of Denton, 1105 Greenlee St, Denton, TX 76201

Peterbilt Motors Corporate Headquarters (Not a dealership), 1700 Woodbrook St, Denton, TX 76205

https://paccar.sharepoint.com/sites/PBConnections-PBC/Shared%20Documents/Forms/AllItems.aspx?id=%2Fsites%2FPBConnections%2DPBC%2FShared%20Documents%2FPresentations%2FRecorded%20Presentations&p=true&ga=1&ovuser=e201abf9%2Dc5a3%2D43f8%2D8e29%2D135d4fe67e6b%2CMohammad%2EChowdhury%40paccar%2Ecom&TeamsCID=e33dc99f%2Ddb36%2D489b%2D9795%2Ded3150caec8b&OR=Teams%2DHL&CT=1780671740892&clickparams=eyJBcHBOYW1lIjoiVGVhbXMtRGVza3RvcCIsIkFwcFZlcnNpb24iOiI0OS8yNjA0MzAxOTIxNiIsIkhhc0ZlZGVyYXRlZFVzZXIiOmZhbHNlfQ%3D%3D

https://performancemanager5.successfactors.eu/sf/careers/jobsearch?bplte_company=paccarinc&_s.crb=SDnAtcydDBJKFsoaJWuZTfPmU5QRYh%252bOuHGHZU5%252f4kQ%253d

Risks Overview | Wiz
https://www.datacamp.com/users/sign_in?redirect=http%3A%2F%2Fapp.datacamp.com%2Flearn%2Fcustom-tracks

https://github.com/enterprises/paccarinc/organizations
https://performancemanager5.successfactors.eu/sf/home?bplte_company=paccarinc&_s.crb=tIUu37JbzH1hdWetf1PA2gxYD5N60F9Vo7tkPPIHqV8%3d

https://companystore.unifirst.com/sf/login
P-49820
p:Ru...1979

https://worklife.alight.com/ah-angular-afirst-web/#/web/paccar/login
mohammad.chowdhury

Mohammad..!..

https://ai-studio.paccar.cloud/
https://app.datacamp.com/learn/custom-tracks
https://make.powerautomate.com/environments/Default-e201abf9-c5a3-43f8-8e29-135d4fe67e6b/home
https://app.wiz.io/login/email-challenge
https://my.visualstudio.com/?auth_redirect=true

Intranet - PACCAR Acronym Library

OneNote

Brick - Web Development Tools.xlsx

Brick - Web Development Tools.xlsx

Standard LINK

https://paccar.sharepoint.com/sites/ITD-REFARCH-Document-Site

Product Liaison Report

EASOP

ELF

GRASOPR Paint Systems

PB has applications in almost all, all parts of the business, whether it be accounting, sales and marketing, administration, engineering.

150 applications that we support.

 

Whenever you are using application and you go, hey, I really think this could be enhanced and could really provide some value to our system.

So that's the chance for you to go into service now and create a service enhancement request.And I'll talk about that in just a moment when

 I talk about how we prioritize IRS and things.

 

 

 

One of the big ones was Esop's integration with Trusted Data.Trusted Data is looking to be the new source of of all pack our information 

and we had a good test integration with ESOP in the past year.It is now doing things a little bit differently and using some of Trusted Data's integration.

 

It's probably invisible to most of you out there, which is great.

 

Nothing should look like it changed, but things should be running a little bit smoother and catching problems that were occurring before and solving them behind the scenes without anyone noticing.

 

The other one of the other major project we're working on is Vspark, which will be an ELF replacements.

 

ELF is the program that turns sales orders into data that we can use to program our vehicles.

 

It's has been notoriously slow.

 

For those of you that have had to use it in the past, Vspark is going to be a faster, better, more modern version of ELF and it is coming very soon.

 

We had a really great success story with PRPS this year, specifically cab and frame paint enhancements for our friends at Chillicothe.

 

You can see the two pictures here.

 

Chillicothe installed a brand new Peterbilt esque automated frame paint system and the IT group in combination with Kenworth Aptev helped them get that set up and it's working great right now.

 

And if you look down in the bottom, you probably are familiar with the scan viewer application as you can see what's getting what's getting painted in the frame paint booth when you're walking there at the plant.

 

We actually have a new enhancement to our frame paint system over in Chillicothe where they have more photo eyes.

 

So that top left picture with way more detail, that's the improvement.

 

So you can see way better detail and the robots can paint more accurately now in our Chillicothe Frame paint booth compared to what it was before with that big sort of light grey empty area in the bottom right picture.

 

And that was a really great enhancement that we worked on with the Kenworth APTIF Group.

 

The Grasshopper system has received a bunch of updates and saw as a few more.

 

But the big one is we can now work on custom chassis which will help us save GHD credits.

 

We can do spark ignition vehicles which helps us with our our U-Haul friends.

 

And then we updated our ecos connections which is the software that talked to the EPA for us.

 

So we updated how we talked to them so things run smoother.

 

And then lastly plan for every part is getting rolled out for every plant.

 

I think we got a couple more plants on boarded in the past year since the last time we had this interval connections for IT.

 

So that continues to go at speed and great job for Megan working on that and putting that together for us.

PETERBILT

অপারেশনস এবং অবকাঠামো (Operations and Infrastructure)

♦ রিপ্রোগ্রামিং স্টেশন স্থাপন: টেস্ট বিল্ডিংয়ে নতুন একটি ডেস্কে কম্পিউটার স্থাপন করা হয়েছে, যা যানবাহনের রিপ্রোগ্রামিং কার্যক্রমকে সমর্থন করবে। এই সেটআপের মাধ্যমে টিম সদস্যরা কন্ট্রোল মডিউল এবং ডিজিটাল ড্যাশবোর্ডসহ ট্রাকের গুরুত্বপূর্ণ কম্পোনেন্ট আপডেট করতে পারবেন। নির্দিষ্ট এই স্টেশনটি রিপ্রোগ্রামিং প্রক্রিয়াকে সহজ করেছে এবং উৎপাদন কার্যক্রমের ধারাবাহিকতা বজায় রাখতে সহায়তা করছে।

♦ Peterbilt Azure Local আপডেট: Peterbilt-এর সকল সার্ভারে নেটওয়ার্ক কনফিগারেশন সম্পন্ন করা হয়েছে। VMware থেকে মাইগ্রেশন প্রক্রিয়ার অংশ হিসেবে Azure ক্লাস্টারকে স্থানীয় সার্ভারের সঙ্গে সংযুক্ত করতে ITD দলের সাথে সমন্বয় করে Azure ক্লাস্টারের তথ্য তৈরি করা হয়েছে।

♦ ফিজিক্যাল ইনভেন্টরির জন্য আইটি অপারেশনস সাপোর্ট: ১৩ ও ১৪ আগস্ট Denton প্ল্যান্ট এবং MSS সাইটগুলোর ফিজিক্যাল ইনভেন্টরি কার্যক্রমে IT Operations দল অন-সাইট সহায়তা প্রদান করবে। দলটি ওয়ার্কস্টেশন, নেটওয়ার্ক, প্রিন্টার, স্ক্যানার এবং ব্যবহারকারী সহায়তার প্রস্তুতি সমন্বয় করছে যাতে কার্যক্রমে বিঘ্ন কম হয়, সমস্যা দ্রুত সমাধান করা যায় এবং ইনভেন্টরি কার্যক্রম নির্বিঘ্নে চলতে পারে।

♦ ভিডিও নজরদারি (Surveillance) সিস্টেম আপগ্রেড: প্ল্যান্ট এবং বিভিন্ন ডিভিশন লোকেশনে নতুন Network Video Recorder (NVR) স্থাপন করা হয়েছে, যা ভিডিও নজরদারি অবকাঠামো আধুনিকীকরণ এবং সিস্টেমের নির্ভরযোগ্যতা বাড়াতে সহায়ক হবে। পাশাপাশি ক্যামেরা নেটওয়ার্ক সেটিংসের একটি নিরাপত্তা নিরীক্ষা (Security Audit) সম্পন্ন করা হয়েছে, যেখানে অনিরাপদ অ্যাক্সেস পদ্ধতি এবং অপ্রয়োজনীয় নেটওয়ার্ক প্রোটোকল অপসারণ করে নিরাপত্তা জোরদার করা হয়েছে এবং অপ্রয়োজনীয় নেটওয়ার্ক ট্রাফিক কমানো হয়েছে।

♦ AI-সহায়তায় ডাটাবেস ডেভেলপমেন্ট: Microsoft Copilot এবং Claude বিভিন্ন SQL Server প্রকল্পে জটিল ডাটাবেস সংক্রান্ত কাজ দ্রুত সম্পন্ন করতে সহায়তা করেছে। দলটি Just-In-Time Inventory Tracking-এর জন্য Stored Procedure আপডেট করেছে, তৃতীয় পক্ষের একটি প্লাগইনের সামঞ্জস্যজনিত সমস্যা সমাধান করেছে এবং Metadata Mapping ও Code Refactoring সম্পন্ন করেছে। এর ফলে প্রায় ৪৫ ঘণ্টা সময় সাশ্রয় হয়েছে।

♦ AI-সহায়তায় নেটওয়ার্ক ট্রাবলশুটিং ও আইটি অপারেশনস: Copilot ব্যবহার করে ওয়্যারলেস নেটওয়ার্কের টাইমআউট সমস্যা বিশ্লেষণ, সপ্তাহভিত্তিক Wi-Fi ফলাফল তুলনা এবং একটি নেটওয়ার্ক মনিটরিং টুলের স্ক্রিপ্ট তৈরি করা হয়েছে। এছাড়া AI-নির্দেশিত ট্রাবলশুটিং ব্যবহার করে গুরুত্বপূর্ণ Windows ত্রুটিগুলো সমাধান করা হয়েছে, যার ফলে মোট প্রায় ৩০ ঘণ্টা সময় সাশ্রয় হয়েছে।

---

অ্যাপ্লিকেশন / ডেভেলপমেন্ট (Application/Development)

♦ Vehicle Software Parameter Configurator (VSParC) প্রকল্প আপডেট: দলটি User Acceptance Testing (UAT)-এর জন্য প্রস্তুতি জোরদার করতে উল্লেখযোগ্য অগ্রগতি অর্জন করেছে। এর মধ্যে টেস্ট কেস তৈরি, বিভিন্ন প্রকল্প ট্র্যাকের প্রক্রিয়া ও নির্ভরশীলতা সমন্বয় এবং বিশেষ করে উচ্চ অগ্রাধিকারপ্রাপ্ত ত্রুটি (Critical Defects) কমিয়ে আনা অন্তর্ভুক্ত রয়েছে।

Global Vehicle Systems Delivery (GVSD) দলের সাথে AppFlow ইন্টিগ্রেশন সফলভাবে যাচাই ও অনুমোদিত হয়েছে, যা VSParC প্রকল্পের End-to-End Integration প্রস্তুতিকে আরও এগিয়ে নিয়েছে।

দলটি Experlogix সাপোর্ট টিমের সাথে কাজ করে পারফরম্যান্স ও স্কেলেবিলিটি লক্ষ্যমাত্রা মূল্যায়ন করেছে এবং প্রোডাকশন পরিবেশে Configurator Processing অপ্টিমাইজ করার জন্য একটি পরিষ্কার পরিকল্পনা তৈরি করেছে।

এছাড়া Tollgate প্রস্তুতি কার্যক্রম চলছে, যেখানে Rollout Plan, Support Model এবং অন্যান্য গুরুত্বপূর্ণ প্রকল্প ডেলিভারেবল পর্যালোচনা করা হচ্ছে।

♦ AI-সহায়তায় EASOP Audit Log সমস্যা সমাধান: ৭ আগস্ট Engineered Automated Sales Order Processing (EASOP) অ্যাপ্লিকেশনে Audit Log সম্পর্কিত একটি সমস্যা সমাধান করা হয়েছে।

সমস্যার কারণে কিছু ডাটাবেস টেবিল কলাম-লেভেলের পরিবর্তন সম্পূর্ণভাবে রেকর্ড করতে পারছিল না, ফলে Kenworth Truck Dealer Order সমর্থনকারী PremierSpec ব্যবহারকারীদের জন্য দৃশ্যমানতা কমে যাচ্ছিল এবং Sales Order Processing-এ ঝুঁকি তৈরি হচ্ছিল।

দলটি মূল ডাটাবেস লজিক সংশোধন করে কোনো ধরনের Audit Format পরিবর্তন ছাড়াই Production পরিবেশে সমাধানটি সফলভাবে ডিপ্লয় করেছে।

GitHub Copilot-কে SQL Server Management Studio-এর মধ্যে ব্যবহার করে Root Cause Analysis দ্রুত সম্পন্ন করা হয়েছে, বিদ্যমান লজিক মূল্যায়ন করা হয়েছে, Column Change Detection ত্রুটি শনাক্ত করা হয়েছে এবং Production Deployment-এর আগে সমাধানটি যাচাই করা হয়েছে।

---

PACCAR North Texas

অপারেশনস এবং অবকাঠামো (Operations and Infrastructure)

♦ Teams Scheduler সেটআপ: PACCAR North Texas-এর পাঁচটি কনফারেন্স রুমের জন্য প্রয়োজনীয় Microsoft Teams লাইসেন্স অর্ডার করা হয়েছে এবং ITD Exchange দলের সহযোগিতায় Teams Scheduler কনফিগার করা হয়েছে। এর ফলে সাইটজুড়ে শেয়ার্ড মিটিং রুমগুলোর সময়সূচি ব্যবস্থাপনা আরও নির্ভরযোগ্য ও কার্যকর হবে।

PETERBILT

Operations and Infrastructure

♦   Reprogramming Station Deployed: Deployed computers to a new desk in the test building to support vehicle reprogramming efforts. This setup allows team members to update key truck components, including control modules and digital dashboards. The dedicated station simplifies the reprogramming process and helps maintain steady production flow.

♦   Peterbilt Azure Local Update: Completed the network configurations across all servers at Peterbilt. Worked with ITD to create the Azure cluster information for connecting the Azure cluster to local servers for the ongoing migration from VMware.

♦   Physical Inventory IT Operations Support: The IT Operations team will provide dedicated on-site support for physical inventory activities at the Denton plant and MSS sites on August 13 and 14. The team coordinates workstation, network, printer, scanner, and user support readiness to help minimize disruption, quickly resolve issues, and keep inventory activities moving efficiently across the plant.

♦   Video Surveillance System Upgrade: Deployed new network video recorders at the plant and division locations to modernize video surveillance infrastructure and improve system reliability. Completed a security audit of camera network settings, removing insecure access methods and unused network protocols to strengthen security and reduce unnecessary network traffic.

♦   AI-Assisted Database Development: Microsoft Copilot and Claude accelerated complex database work across several SQL Server projects. The team updated stored procedures for just-in-time inventory tracking, resolved a third-party plugin compatibility issue, and completed metadata mapping and code refactoring, saving the team approximately 45 hours.

♦   AI-Assisted Network Troubleshooting & IT Operations: Leveraged Copilot in diagnosing wireless network timeout issues, comparing Wi-Fi findings week over week, and scripting a network monitoring tool. The team also resolved critical Windows errors using AI-guided troubleshooting, saving approximately 30 hours across these efforts.

 

 

Application/Development

♦   Vehicle Software Parameter Configurator (VSParC) Project Update: The team made significant progress toward User Acceptance Testing (UAT) readiness by developing test cases, aligning on processes and dependencies across project tracks, and reducing open defects with primary focus on the most critical severity levels. The AppFlow integration with the Global Vehicle Systems Delivery (GVSD) team was successfully validated and approved, advancing end-to-end integration readiness for the VSParC project. The team engaged Experlogix support to evaluate performance and scalability targets, establishing a path to optimize configurator processing for production. Tollgate readiness activities are underway, including review of the rollout plan, support model, and key project deliverables.

♦   EASOP Audit Log Issue Resolved with AI-Assisted Analysis: Resolved an August 7 incident affecting the audit log within the Engineered Automated Sales Order Processing (EASOP) application. Certain database tables were not fully capturing column-level changes, which reduced visibility for PremierSpec users supporting Kenworth Truck dealer orders and created risk to sales order processing. The team corrected the underlying database logic and deployed the fix to production with no disruption to the existing audit format. GitHub Copilot was used within SQL Server Management Studio to accelerate root cause analysis, evaluate existing logic, identify the column change detection flaw, and validate the corrective fix before deployment.

 

 

PACCAR North Texas

Operations and Infrastructure

♦   Teams Scheduler Setup: Ordered the required Microsoft Teams licenses and worked with the ITD Exchange team to configure Team Schedulers for five conference rooms at PACCAR North Texas. This effort improves scheduling reliability for shared meeting spaces across the site.

🔍 Purpose

The Daily Scrum is a short, focused meeting for the Development Team to align on progress, identify blockers, and plan the next 24 hours toward achieving the Sprint Goal.

---

🎯 Expected Outcomes

• Clear visibility into progress toward the Sprint Goal
• Identification of impediments/blockers
• Alignment on next steps and daily priorities

---

✅ Expectations for Participants

• Development Team:
• Actively participate and stay focused
• Share progress and plans concisely
• Raise blockers early
• Scrum Master:
• Ensures the meeting stays within 15 minutes
• Removes impediments outside the meeting
• Product Owner (optional):
• Observes and provides clarification if needed

---

🗂️ Format (Keep It Short & Focused)

Each team member answers:

1. What did I complete since the last standup?
2. What will I work on today?
3. Are there any blockers or risks?

---

📌 Ground Rules

• Strict 15-minute timebox
• No deep problem solving during the standup

---

🅿️ Parking Lot (Follow-up Discussions)

Once the Daily Scrum is complete, the team may stay up to 15 extra minutes to discuss Parking Lot items, which include:

• Issues requiring deeper discussion
• Problem-solving conversations
• Design or technical debates
• Dependency coordination

⚠️ Only relevant team members should stay for Parking Lot discussions to respect everyone’s time

 

Note: These sessions will be auto recorded.

Note 2: Every other Wednesdays we won’t have stand up due to Sprint Planning ceremony.

DataCamp

 If you're using the course platform shown in your screenshots (DataCamp-style learning), the fastest ways to earn more XP are:

🚀 1. Complete Exercises

• Most quiz questions: 50 XP
• Drag-and-drop exercises: 100 XP
• These add up quickly and are the most reliable source of XP.

🎯 2. Maintain Daily Streaks

• Log in and complete lessons every day.
• Many platforms award bonus XP for streaks and consistency.

📚 3. Finish Entire Courses

• Completing course chapters and course certificates often gives significant XP rewards.

⚡ 4. Complete Assessments/Projects

• Skill assessments
• Practice projects
• Certifications
• These usually award more XP than individual exercises.

🏆 5. Participate in Challenges

• Weekly or monthly challenges often provide bonus XP multipliers.

💡 6. Use XP Multipliers

• Some platforms offer:
  • Weekend bonuses
  • Challenge bonuses
  • Promotional XP boosts

📈 Fastest Method

Since you're already working through exercises, the quickest strategy is:

1. Finish the current course completely.
2. Move to the next course immediately.
3. Complete all drag-and-drop exercises (100 XP each).
4. Keep your daily streak active.

You're already at about 21,450 Daily XP in the screenshot, which is very high. Continuing to complete lessons and exercises is the fastest way to push that number higher. 🏅

Project OverView

 21H_LeakTesting 

DashPerm 

EWI_Assembly

APQP Management System

DynaShippingPortal

KitValidation

DAVIE API

Guided Picking

21H_LeakTesting

WPF desktop application for 21H leak testing, targeting .NET 8.

Solution Structure

Application Overview

The 21H Leak Testing application is a WPF desktop tool used on the Dynacraft production floor to perform automated hose leak tests. It targets .NET 8 (net8.0-windows) and communicates with up to four serial-connected leak-test instruments simultaneously.

What It Does

Operators follow a guided workflow to execute and record pressure-based leak tests:

Badge in – Authenticate with an employee ID validated against the StaticProduction SQL Server database.

Select a station – On first launch, choose a test station from a database-driven list (persisted to user settings for subsequent runs).

Scan a production order – Enter or scan an 8–9 digit production order barcode.

Scan a material/assembly number – The application looks up the corresponding TCAP program number via the DataApps database.

How It Works

Layer Responsibility

UI (MainWindow, TestChannel, StationWindow, OrderEntry) WPF views for operator interaction, channel status display, and station selection

Serial Communication (System.IO.Ports) Sends commands to and receives data from leak-test instruments on dedicated COM ports; data is received on a background thread and marshalled to the UI via Dispatcher.Invoke

Data Access (DataAppsContext, StaticProductionContext) Entity Framework Core 9 DbContexts that call SQL Server stored procedures for employee validation, test result recording, station/port lookups, and error logging

Security (DAL, Crypto) Decrypts EncPassword_LeakTester from App.config using TripleDES and injects the password into connection strings at runtime — passwords are never stored in plain text

Error Handling (Util, App.xaml.cs) Global exception handlers catch unhandled errors from the dispatcher, app domain, and task scheduler; errors are dual-written to a local log file (error_21H_LeakTesting.txt) and the DataApps_ErrorLog_INSERT stored procedure

Enter parts quantity & assign channels – Distribute work across available test channels (CH1–CH4).

Run tests – The application sends TCAP program and start commands to the instruments over serial ports, parses the response data, and determines pass or fail.

Record results – Test outcomes, part quantities, and any errors are written to the DataApps SQL Server database in real time. The app

DashPerm 

Application Overview

NGP DashPerm Desktop (NGP_587_DashPerm) is an internal WPF desktop application built for Dynacraft (PACCAR) manufacturing operations. It serves as a production dashboard for the NGP 587 dash panel assembly line, providing station-specific views for operators to scan chassis, view panel build instructions, track build times, log defects, verify orders, and request part resupply.

Operators select a production station at launch (A Panel, B Panel, C Panel, D Panel, Inspection, or Pack), and the dashboard tailors its display and data to that station context. The application connects to multiple SQL Server databases for chassis data, defect tracking, employee achievements, and order verification workflows.

---

Getting Started

Prerequisites

• Visual Studio 2022+ (Enterprise recommended) with the .NET desktop development workload installed.
• .NET Framework 4.8 targeting pack.
• Network access to internal SQL Server databases (StaticProduction, EWI_DataWarehouse, EASOP_PB).
• NuGet package restore enabled.

Clone the Repository

Build

1. Open NGP_587_DashPerm.sln in Visual Studio.
2. Restore NuGet packages (automatic on build).
3. Build the solution (Ctrl+Shift+B) or via command line:

Run

• Set NGP_587_DashPerm as the startup project.
• Press F5 to start debugging, or Ctrl+F5 to run without the debugger.

Run Tests

• Open Test Explorer in Visual Studio and run all tests from the NGP_587_DashPerm_Test project.
• Tests use the NUnit framework with Moq for mocking.

Environment Configuration

The application includes environment-specific configuration files that are copied to the output directory:

File	Environment
NGP_587_DashPerm.exe.CERT.config	Certification
NGP_587_DashPerm.exe.TEST.config	Test
NGP_587_DashPerm.exe.PROD.config	Production

Solution Structure

---

Key Modules

Login (Login.xaml)

Station selection screen presented at application launch. Operators choose their assembly station (A Panel, B Panel, C Panel, D Panel, Inspection, or Pack), which sets the station context (Station and StationID) in Application.Current.Resources before opening the MainWindow.

MainWindow (MainWindow.xaml)

The primary dashboard (~2,000 lines). Displays chassis-specific panel build data including part numbers, locations, wire guard images, and punch labels. Incorporates a DispatcherTimer for build-time tracking against station targets. Handles chassis scanning, archive lookups, and station-specific tab views (J1/J2 panels, C Panel, etc.).

InputUser (InputUser.xaml)

Employee login window. Operators scan or enter their badge ID, which is validated against the vwEmployees view in EWI_DataWarehouse. The matched employee name is stored in application-level resources for display and achievement tracking.

Print (Print.xaml)

Print and report view for chassis build sheets. Loads chassis data and location maps, then renders printable layouts using WPF visual trees. Supports image display from a shared UNC network path.

Defect (Defect.xaml)

Defect logging window. Allows operators to record defects by selecting the originating station and defect category from database-driven dropdown lists, with a description field. Categories and stations are loaded from StaticProduction database views.

Achievement (Achievement.xaml)

Trophy/achievement popup triggered when an employee unlocks a milestone. Displays the appropriate trophy image (keyed by TrophyKey and Level) and a congratulatory message with the employee name and station context.

AvgUpdate (AvgUpdate.xaml)

Displays the operator's month-to-date average build time for the current station versus the target. Build time text is color-coded: green when at or below target, red when above.

Order_Verify (Order_Verify.xaml)

Order conflict verification module. Compares JIT component lists against production data for a date range, highlights conflicts, and sends email notifications (via System.Net.Mail) to a distribution list loaded from a stored procedure.

Resupply (Resupply.xaml)

Part resupply request form. Operators scan a part number to submit a resupply request record to the tblResupplyRequests table in EWI_DataWarehouse, tagged with the current station and timestamp.

Welcome (Welcome.xaml)

Welcome screen that shows a summary of viewed defects from the vwDefectVieweds view, providing operators a quick defect overview on entry.

CounterTest (CounterTest.xaml)

Countdown timer utility using DispatcherTimer. Visually counts down from a set time with color-coded urgency indicators (blue under 10 seconds, red under 6 seconds).

DAL (DAL.cs)

Centralized Data Access Layer. Reads connection strings from app.config and injects the decrypted password (via Crypto) at runtime by replacing {PASSWORD} placeholders. Exposes typed getter methods for each database connection.

Crypto (Crypto.cs)

Encryption and decryption utility using TripleDES with MD5-hashed keys. Used by DAL to decrypt database passwords stored in AppSettings at runtime.

---

Key Features

Feature	Description
Station-Based Dashboard	Tailored panel views per assembly station with chassis-specific build instructions.
Chassis Scanning	Scan-to-load workflow for retrieving chassis build data from SQL Server.
Build Time Tracking	Real-time countdown timer comparing actual build time to station targets.
Defect Logging	Station- and category-based defect entry with database persistence.
Employee Achievements	Trophy/milestone notification system with tiered achievement images.
Average Build Time Reports	Month-to-date build time vs. target with color-coded performance feedback.
Order Conflict Verification	JIT-to-production comparison with automated email conflict alerts.
Part Resupply Requests	One-scan resupply submissions tagged by station and timestamp.
Print / Report Generation	Printable chassis build sheets with part images from shared network paths.
Chassis Archiving	Archive and retrieve historical chassis build records.
Encrypted Credentials	TripleDES-encrypted database passwords with runtime decryption in DAL.
Multi-Environment Config	Separate config files for CERT, TEST, and PROD environments.
ClickOnce Deployment	Published to an internal web server with auto-update support.

---

Technologies Used

Technology	Version / Details
.NET Framework	4.8
WPF	Windows Presentation Foundation (XAML + code-behind)
C#	Primary language
Entity Framework	6.4.4 (Database First with EDMX models)
ADO.NET	SqlConnection / SqlCommand for stored procedure calls
Typed DataSets	StaticProductionDataSet.xsd, DataSet1.xsd
SQL Server	Backend databases (StaticProduction, EWI_DataWarehouse, EASOP_PB)
TripleDES / MD5	Connection string password encryption
System.Net.Mail	SMTP email notifications (Order Verify)
ClickOnce	Desktop application deployment and auto-update
NUnit	3.12.0 — Unit testing framework
Moq	4.20.72 — Mocking library for tests
Microsoft.NET.Test.Sdk	16.5.0 — Test platform
Azure DevOps Pipelines	CI build, test, and ClickOnce publish
Git / GitHub	Source control (PaccarInc-Dynacraft/OPS-DashPerm-Desktop)

EWI_Assembly

A comprehensive assembly management system for PACCAR's EWI (Electrical Wiring Integration) operations. This solution provides workstation management, BOM (Bill of Materials) tracking, and line assembly visualization capabilities.

Overview

The EWI_Assembly solution is designed to manage and track the assembly process of electrical wiring components in a manufacturing environment. It consists of two main web applications and supporting projects for testing and data management.

Technology Stack

Core Technologies

• .NET 8.0 - Modern, cross-platform framework for building web applications
• ASP.NET Core MVC - Model-View-Controller framework for traditional web applications
• Blazor Server - Interactive web UI framework with server-side rendering
• Entity Framework Core 9.0 - Object-Relational Mapping (ORM) for database access
• SQL Server - Enterprise database system for data storage and management

UI Frameworks & Libraries

• Telerik UI for Blazor 12.0 - Professional UI component library for Blazor applications
• jQuery - JavaScript library for DOM manipulation (in EWI_Assembly project)

Testing & Automation

• MSTest - Microsoft's testing framework for unit and integration tests
• Selenium WebDriver 4.17 - Browser automation for end-to-end testing

Build & Deployment

• Azure Pipelines - CI/CD automation for building, testing, and deploying applications
• NuGet - Package management for .NET dependencies

Projects

1. EWI_Assembly

Type: ASP.NET Core 8.0 MVC Web Application

Purpose: The primary web application providing workstation interfaces for assembly operations. This application manages BOM (Bill of Materials) workstations where workers can:

• View component headers and details by Purchase Order (PO)
• Track station orders and mark them as complete
• Validate parts during assembly
• Record defects and their sources
• Manage CATL (Critical Attribute Tracking Log) data

Key Features:

• MVC architecture with Controllers, Models, and Views
• Direct SQL Server integration using Microsoft.Data.SqlClient
• Stored procedure-based data access for performance
• Support for multiple environments (DEV, CERT, PROD)
• Connection to both EWI_Assembly and EWI_DataWarehouse databases

Main Controllers:

• BOMWorkstationController - Core workstation functionality for BOM management
• BOMLookupController - BOM search and lookup operations
• HomeController - Application home page and navigation

2. LineAssembly

Type: Blazor Server Web Application (.NET 8.0)

Purpose: A modern, interactive web application built with Blazor providing visual representations and real-time updates for line assembly operations. This application offers:

• SVG-based visualization of assembly line layouts
• Real-time order and pallet tracking
• Interactive UI components using Telerik Blazor controls
• Responsive design for various screen sizes

Key Features:

• Server-side Blazor with interactive components
• Entity Framework Core with DbContextFactory pattern (optimized for Blazor Server)
• Telerik UI for Blazor professional components
• SQL Server database integration
• Component-based architecture with reusable Razor components

Main Pages:

• Home.razor - Application landing page
• HomeSvg.razor - SVG-based visual representation of assembly lines
• TestOrderPallet.razor - Order and pallet testing interface

3. EWI_AssemblyDB

Type: SQL Server Database Project (.sqlproj)

Purpose: Database schema management and version control for the EWI_Assembly database. This project contains:

• Database schema definitions (tables, views, stored procedures)
• Security configurations and user permissions
• Multiple schemas for different functional areas:
  • ADMIN - Administrative functions
  • ASSEMBLY - Core assembly operations
  • WORKSTATION - Workstation-specific data and procedures
  • REPORTS - Reporting functionality
  • PRINT - Printing operations

Key Features:

• Source control for database objects
• Deployment scripts for environment promotion
• Security principal management for service accounts
• Schema-based organization of database objects

4. EWI_Assembly.MSTests

Type: MSTest Test Project (.NET 8.0)

Purpose: Automated testing suite providing end-to-end testing using Selenium WebDriver. This project ensures:

• Browser-based integration testing
• UI workflow validation
• Cross-browser compatibility testing
• Regression testing for critical user paths

Key Features:

• Selenium WebDriver for browser automation
• MSTest framework for test organization and execution
• DotNetSeleniumExtras.WaitHelpers for reliable element interactions
• Integration with EWI_Assembly project for testing actual application behavior

Database Configuration

The solution connects to multiple SQL Server databases in the PACCAR network:

• EWI_Assembly - Main application database
• EWI_DataWarehouse - Data warehouse for reporting and analytics

Database connections are configured per environment:

• DEV: sql-d-DynlouEWIAssy.na.paccar.com
• CERT: sql-c-DynlouEWIAssy.na.paccar.com
• PROD: sql-p-DynlouEWIAssy.na.paccar.com

All connections use Windows Integrated Authentication (Trusted_Connection) for secure access.

Build and Deployment

Build Process

The solution uses Azure Pipelines for automated builds:

• azure-pipelines-1.yml - Triggered on master branch commits
• azure-pipelines.yml - Triggered on Release branch commits

Build steps include:

1. NuGet package restoration
2. MSBuild compilation with Release configuration
3. Automated test execution with VSTest
4. Package creation for deployment

Prerequisites for Local Development

• Visual Studio 2022 (Version 17.5 or later)
• .NET 8.0 SDK
• SQL Server access to PACCAR network databases
• Windows authentication credentials for database access

APQP Management System

Application Overview

Built using ASP.NET MVC and targeting .NET Framework 4.7.2, this application is a comprehensive Advanced Product Quality Planning (APQP) management system designed specifically for automotive manufacturing and procurement workflows.

APQP is an established industry framework that supports cross-functional teams in the development of products and processes to ensure customer satisfaction. The framework emphasizes quality planning, supplier collaboration, and risk mitigation throughout the product development lifecycle. Key APQP tenets include:

• Quality at Source: Implementing process controls and quality checks early in the development cycle
• Supplier Collaboration: Managing requests for quotes (RFQs), bid entries, and quality approvals with supplier partners
• Production Part Approval: Formal approval workflows for new part production using the Production Part Approval Process (PPAP)
• Change Control: Managing engineering change notices (ECNs) with formal review and implementation tracking
• Bill of Materials (BOM) Management: Tracking component sourcing, pricing, and quoting for complete assemblies
• Continuous Improvement: Supporting part family management, variation control, and data-driven reporting

This system is tailored for PACCAR Inc. and Dynacraft organizations to streamline product quality planning, accelerate supplier approval cycles, and maintain regulatory compliance across multiple plants and business divisions. The application provides real-time visibility into quality workflows, supplier performance, and engineering changes through an integrated dashboard and comprehensive reporting infrastructure.

Solution Structure

Project	Description
APQP_MVC	Main ASP.NET MVC web application
APQP_MVC.Test	Unit tests for the main project
APQP.MSTest	Additional MSTest-based tests

Key Modules

RFQ (Request for Quote)

Manages the complete supplier bidding and quote lifecycle. This module enables procurement teams to publish bid requests, collect and evaluate supplier responses, and compare pricing and technical proposals. Key workflows include:

• Quote Creation & Distribution: Generate and distribute requests for quotes to multiple suppliers with deadlines and specification details
• Bid Tracking & Submission: Monitor supplier bid submissions and enforced deadline management with escalation capabilities
• Bid Evaluation: Track bid status, comments, and approval workflows with linked checklists for quality compliance verification
• Supplier Comparison: Analyze competing bids side-by-side with pricing, lead time, and quality metrics for data-driven supplier selection
• Task & Checkpoint Management: Assign quality approval tasks to cross-functional teams with completion tracking and audit trails
• Document Attachments & Comments: Maintain complete communication history with suppliers throughout the bidding process
• Reporting & Analytics: Generate bid reports by supplier, plant, or business division for performance trending and procurement analysis

PPAP (Production Part Approval Process)

Manages the formal approval process required before suppliers can release production quantities. PPAP ensures that new parts or design revisions meet technical specifications and manufacturing capability standards. Core capabilities include:

• Production Scheduling: Define new production part projects with part families, drawings, and quality codes linked to APQP workflows
• Submission Timeline Management: Track firm implementation dates and target implementation dates to keep production schedules aligned across the supply chain
• Employee PPAP Schedule Tracking: Assign PPAP approval tasks to quality engineers, manufacturing engineers, and plant personnel with deadline visibility and role-based responsibilities
• Multi-Level Approval Workflows: Support hierarchical approval chains ensuring design, process, and quality reviews occur before production release
• Calendar Views & Planning: Visualize PPAP schedules by plant, product line, and engineer for capacity planning and workload management
• Status Tracking & Escalation: Monitor approvals in real-time with alerts for overdue reviews and readiness assessments
• Change Control Integration: Link PPAP approvals to engineering changes (ECNs) and requirement modifications to maintain traceability throughout the product lifecycle
• Compliance Documentation: Maintain audit trails and approval records for regulatory compliance (ISO/TS 16949, AIAG PPAP guidelines)

ECN (Engineering Change Notices)

Manages the engineering change control process to track, review, and implement design and process changes throughout the product lifecycle. This module ensures all stakeholders are informed of changes and impacts are managed systematically. Key features include:

• Change Notice Creation & Routing: Define changes with title, description, cost-savings impact, and internal/external classification for appropriate review workflows
• Group-Based Management: Organize changes by division, program, or business unit with customizable approval groups and notification rules
• Multi-Stage Review Process: Route changes through design, manufacturing, quality, and supply chain reviews with tracked workflows and decision points
• Change Tracking Grid: Interactive data grid with real-time filtering, sorting, and modal-based controls for viewing change details, history, and status
• Implementation Date Management: Track firm implementation dates and target implementation dates to coordinate production transitions with suppliers and plant operations
• Part Impact Analysis: Identify which parts and suppliers are affected by changes to enable targeted communication and compliance verification
• Readiness Assessment: Verify supplier readiness before change implementation through linked PPAP approvals and manufacturing capability assessments
• Change History & Audit Trail: Maintain complete records of change reviews, approvals, rejections, and implementation status for compliance and continuous improvement analysis

IncrediBOM (Bill of Materials)

Provides comprehensive bill of materials management for product assemblies, including component tracking, supplier sourcing, pricing, and quoting. This module enables procurement teams to visualize complete assembly structures and manage supplier relationships at the part level. Key capabilities include:

• Full & Partial BOM Views: Display complete assembly hierarchies or filtered sub-assemblies for targeted analysis and component sourcing
• Component-Level Supplier Management: Assign suppliers to components with pricing and lead time data for competitive analysis and cost optimization
• BOM Pricing & Cost Analysis: Aggregate component costs into assembly-level BOMs with supplier pricing comparisons and margin tracking
• Quote & RFQ Integration: Create or update quotes directly from BOM data, link bids to components, and track supplier selections across assemblies
• Part Search & Lookup: Search components by part number, description, or supplier for rapid access to sourcing and pricing history
• Excel Import/Export: Support bulk BOM entry through copy/paste and Excel file import, enabling rapid data entry and streamlined supplier updates
• PPAP Integration: Link BOM components to PPAP records to track which parts require approval and coordinate production readiness across the supply base
• Cross-Reference & Version Control: Maintain BOM revisions and track part number changes to ensure manufacturing and procurement teams work with current designs

Part Management

Provides centralized management of part families, variations, and design revisions to support product configuration and supply chain coordination. This module enables engineering teams to manage part hierarchies and track design changes across multiple suppliers and plant locations. Core functions include:

• Part Family Definition: Create and organize part families representing logical groupings of related components (e.g., alternator family with multiple voltages or configurations)
• Part Variation Handling: Define and manage part variations (color, material, voltage, capacity) through modal dialog workflows for rapid configuration updates
• Revision Tracking: Maintain multiple revisions of part families with change history and effectivity dates to coordinate design updates with suppliers and manufacturing
• Design Documents & Drawings: Associate drawing files, specifications, and technical documentation with part families for quick reference and compliance verification
• Supplier Assignment: Link part families to approved suppliers and track approval status, pricing, and lead time by supplier and part variation
• ECN Integration: Track which ECNs affect specific part families to maintain traceability and ensure suppliers implement changes at the correct time
• Data Import/Export: Support bulk part family creation and updates through Excel import/export to streamline data entry and simplify supplier onboarding
• Cross-Plant Standardization: Enable sharing of part families across multiple plants to drive standardization and reduce engineering redundancy

Key Features

• DataTables Integration - Sorting, filtering, and export to Excel/PDF/clipboard
• AJAX-Driven UI - Asynchronous updates to minimize page reloads
• User Notifications - Real-time feedback using Toastr
• Windows Authentication - Integrated IIS authentication (no login page)
• Excel Import/Export - Bulk data operations via ExcelDataReader

Technologies Used

Layer	Technology
Framework	.NET Framework 4.7.2
Web Framework	ASP.NET MVC 5
Data Access	Entity Framework 6.5.1 (EDMX), LINQ
Frontend	jQuery 3.7.1, jQuery UI 1.13.3, Bootstrap 5.1.3, DataTables, Toastr
Validation	jQuery Validation 1.21.0
Cryptography	Portable.BouncyCastle 1.9.0
Authentication	Windows Authentication (IIS)
Testing	MSTest 3.8.3, Moq 4.20.72, Selenium WebDriver 4.32.0
CI/CD	Azure Pipelines (azure-pipelines.yml)
Package Management	NuGet (packages.config)

ESMS Support Web Application

Enterprise Supplier Management System (ESMS) Support is an ASP.NET MVC 5 web application for managing supplier relationships, EDI operations, and chargeback workflows.

Quick Start

1. Prerequisites: Visual Studio 2022+ with .NET Framework 4.7.2

echnology Stack

• .NET Framework 4.7.2
• ASP.NET MVC 5.2.9
• Entity Framework 6.5.1
• jQuery 3.7.1
• Bootstrap 5.3.x
  
  
  

MAT-DynaShippingPortal-Web

• A web-based shipping management portal for Dynacraft operations built with ASP.NET MVC 5.

  ---

Overview

• DynaShippingPortal is an internal logistics management application that enables shipping teams to schedule, track, and manage outbound shipments. The application provides real-time visibility into trailer schedules, carrier assignments, customer shipments, and related documentation.

  ---

Key Features

• Feature	Description
  Outbound Schedule Management	Create, update, and track outbound shipping schedules with trailer numbers, skid spots, utilization metrics, and scheduled/released dates
  Carrier Management	Maintain carrier information with active/inactive status tracking
  Customer Management	Track customers with trailer summary reporting and color-coded status indicators
  Kit Summary Tracking	Associate ASN (Advanced Shipping Notice), shipping authorizations, and shipment types with schedules
  File Attachments	Upload and manage documents via UNC-based file storage with permitted file type validation
  Email Notifications	Automated shipping confirmation notifications
  Error Logging & Monitoring	ELMAH for exception logging, Application Insights for telemetry
  Windows Authentication	Integrated Windows/Active Directory authentication

  ---

Architecture

• The application follows a layered architecture pattern:

Layer Responsibilities

• • Controllers – Handle HTTP requests, return Views/JSON, manage anti-forgery tokens
  • Services – Business logic, data transformation (ViewModels ↔ Models)
  • Repositories – Data access using ADO.NET with stored procedures
  • Helpers – Shared utilities (SQL commands, file uploads, logging, date calculations)

  ---

Technologies & Tools

• Category	Technology	Version
  Framework	.NET Framework	4.7.2
  Web Framework	ASP.NET MVC	5.3.0
  Frontend	Bootstrap	5.1.3
  JavaScript	jQuery	3.7.1
  Validation	jQuery Validation, Unobtrusive Validation	1.21.0 / 3.2.11
  Data Access	ADO.NET (System.Data.SqlClient)	-
  Database	SQL Server (Stored Procedures)	-
  Serialization	Newtonsoft.Json	13.0.4
  Monitoring	Microsoft Application Insights	2.8.0
  Error Logging	ELMAH	1.2.2
  Navigation	MvcSiteMapProvider	4.6.26
  Authentication	Windows Authentication (IIS)	-
  File Storage	UNC Path (System.IO)	-

  
  

KitValidation

• A Blazor Server application for validating manufacturing kit materials against production sequences. Operators scan parts to verify the correct materials are present in each kit before assembly, with real-time visual feedback and validation logging.

  ---

Features

• • Area & Station Selection — Cascading dropdowns to choose the work area and station
  • Single & Range Sequence Modes — Validate a single sequence or navigate through a range with Previous / Next controls
  • Part Scanning — Scan parts via barcode scanner against the expected material list with instant green (valid) / red (invalid) feedback. Paste is blocked on the Employee field to prevent manual data entry errors, but scanner input is fully supported on the Scan Part field.
  • Validation Logging — Every scanned part is logged to the database for traceability
  • Toast Notifications — Success and error messages via Blazor.Bootstrap toasts

Tech Stack

• Layer	Technology
  UI	Blazor Server (.NET 8, Interactive Server)
  Components	Blazor.Bootstrap
  ORM	Entity Framework Core (SQL Server)
  Database	SQL Server (EWI_Admin)
  Testing	MSTest, Selenium WebDriver

  
  

DAVIE API Readme

• This API allows you to take DAVIE results and store them in a database called DAVIE. The stored results are stored in a table called DAVIEResults. Additionally, the API can concatenate data and generate a bartender label using a stored procedure called [cs_BEVPPCResult_SELECT].

Endpoints

1. Store DAVIE Results

• • Endpoint: /davie/label
  • Method: POST
  • Description: This endpoint allows you to store DAVIE results in the DAVIE database and DAVIEResults table.
  • Request Body:
    • data: The DAVIE results to be stored.
  • Response:
    • status: The status of the operation.
    • message: A message describing the result of the operation.

2. Generate Bartender Label

• • Endpoint: /davie/label
  • Method: GET
  • Description: This endpoint generates a bartender label by concatenating data and using the stored procedure [cs_BEVPPCResult_SELECT].
  • Response:
    • status: The status of the operation.
    • message: A message describing the result of the operation.
    • label: The generated bartender label.

Database Information

• • Database Name: DAVIE
  • Table Name: DAVIEResults

Stored Procedure

• • Stored Procedure Name: [cs_BEVPPCResult_SELECT]
  • Description: This stored procedure is used to concatenate data and generate a bartender label.

How to Use

• 1. Install the necessary dependencies.
  2. Set up the DAVIE database and create the DAVIEResults table.
  3. Configure the API to connect to the DAVIE database.
  4. Make API requests to store DAVIE results and generate bartender labels.

Example

Store DAVIE Results

• • Endpoint: /davie/results
  • Method: POST
  • Request Body:

    {
      "data": {
        "result1": "value1",
        "result2": "value2"
      }
    }
  • Response:

    {
      "status": "success",
      "message": "DAVIE results stored successfully."
    }

Generate Bartender Label

• • Endpoint: /davie/label
  • Method: GET
    
    
    

Guided Picking Application

Overview

• • Guided Picking is an innovative application designed to streamline the picking process in warehouse and production environments. By allowing users to easily input their badge number, area, and production order number, the app efficiently displays the necessary part numbers, quantities, and corresponding SAP bin locations. Additionally, it includes a bin validation feature to ensure accuracy in picking.

Features

• • • User Input: Enter badge number, area, and production order number to retrieve relevant picking information.
    • Part Display: View part numbers and quantities associated with the production order.
    • SAP Bin Locations: Automatically fetches and displays the correct SAP bin locations for each part.
    • Bin Validation: Ensures that users are picking from the correct bin, reducing errors and improving efficiency.