Salient feature of the Application:
The application shall collect the data from the Weighbridges across the project automatically
without any manual intervention and transfer into the data server which is hosted at TFL Office
Jaipur.
At any point of time Management can view the Weighbridges production details across WDFC
Project.
It is an unique development using with the latest web technology
Proposed to extend the application across the IC
It is an in-house development of ISD WDFC JAIPUR. Cost of implementation is very minimal.
Currently 30 Weighbridges are integrated and data is in LIVE for WDFC Project
Currently 10 Weighbridges are integrated and data is in LIVE for DARP Project
Executive Summary
The application will be using Multi-tier Architecture. It will have Front Tier, Application Tier and
Database Tier.
Front -Tier: Design of the application falls under the Front-Tier. ASPX pages will be used behind the
code. Ajax Services and Ajax Library will be used for the design purpose.
Application-Tier: Service Layer, Business Access Layer and Data Access Layer fall under ApplicationTier. These three layers will interact with each other through Third Party Integrator. ORM tool will
be used in Data Access Layer. WCF will be used for Service Layer and Database Layer respectively.
Database-Tier: This tier handles the database of the application. SQL Server will be used for backend.
Scope of the Work
The project is being classified into different phases for better categorization to ensure faster
development and deployment of the software for project usage.
The initial phase is the complete framework on which future software development programs can
plug in.
Phase 1 revolves different make of weighbridges data capturing, data monitoring, visual
representation, mobile interface and others.
Overview of Weighbridges Data Management System:
Data representation in Graphical format/table format or a combination of both as deemed
necessary
Hierarchy level based access
Instant access to the concerned level at the time of log in
Toggle amongst the various levels based on permissions
Display of progress in Mobile devices
Data import and export in standard format at defined instances
Automatic summation of bills depending on entries for related sections/cost centers and display
in requisite table and graphical formats
Search functionality and display on selection based criteria
No data entry by way of drop downs /autocomplete feature
Automatic consideration of given interlocks/alarms to prevent untenable activities
Reports:
The following Reports can be generated instantly in our TI IC Portal & WDFC Portal
Slip Register
Material Wise Report
Material Wise Summary
Supplier wise Report
Supplier Wise Summary
Auto Materials Reconciliation Statement
Non Reconciliation Statement
Diagram shows fundamental modules integrated in the system:
WB Data Capuring
through Offline
Application
Porject
Information
DashBoard
WB Data
Management
System
Mobile Interface
Reports
Provided Internet Connection to all WB Desktops.
WB Offline Application to be installed in WB Desktop.
After installation of setup, specify the location of WB and choose the DB
path and submit.
By selecting the Import Data, the program gets the data from transaction
table of the DB and displays in the Grid.
On selecting the Push Data to Server, the program connects to TFL DB
server and transfers the data through Web Service into the TFL DB Server.
Installing
thehosted
Clientat
Software
at WB Desktop
Web
Service
TFL WebSetup
server.
Specifying the location and path of the WB Database used by WB type
(One-Time
Process).
Web
application
was developed and hosted at TFL Web server, this connects
Import the data from the database and push to TFL server (Sql Server)
or(Sql
automatically
for every
30 minutes).
tomanually
DB Server
server) and(Through
displays scheduler
with appropriate
reports.
Data is pushed to TFL Server (Sql server) through Web Service in text
format andused
replicated
to Sqlapplication
Server DB :atC#.net,
TFL-Server.
Technology
for off-line
MS-Access
Web Service hosted at TFL Web Server.
WBDMS Web Portal Developed and hosted in TFL Webserver.
Step -1
Click on Change Make
Step -2
Step -3
Step -4
WBDMS - Homepage
The available reports in the Online Weighbridge Data Management
System are
1. Slip Register Report
2. Material Wise Detail Report
3. Material Wise Summary Report
4. Supplier Wise Detail Report
5. Reconciliation Report
6. Non Reconciliation Report
By Clicking the status In Live, will be redirected to the respective
weighbridge Slip Register report with current date transaction
report.
Report-1 : Slip Register
Report-2: Material-wise Detail Report
Report-3: Material-wise Summary Report
Report-4: Supplier-wise Detail Report
Report-5: Reconciliation Report
Report-6: Non-Reconciliation Report