Develop an Alarm management web based dashboard that allows a user to view current status of the system alarms from SQL Database, run adhoc type queries, and assign problems to specific alarms.
The Development should be in ASP.NET VS2010 with Silverlight 4 Controls using Telerik suite if required.
All grids need the ability for grouping, sorting, exporting, Filtering, and printing
The General layout example is shown below. Specific examples of the data components are outlined in sections 2 & 7. of the attached document
Types of Displays on Default Dashboard
Number of Alarms in 10 Minutes, 60 Minutes, 24 hours
Current Active Alarms
Queries:
Most Active Alarms from Date to Date (Current Time ??" 24 hours)
Most active High Priority Alarms from Date to Date (Same Default)
All Alarms From Date to Date (Filter by Area, by priority, by source) Trend Displays outlined in section 4.2 of Document
## Deliverables
Sample Database Backup with Data is included.
Design Document is included
Detailed Design plan including any "Dashboard" type development componenets, additional suggeted tools or componenets, estimated completion dates, and samples of any "dashboard" type sites developed is required in bid to be considered.
One Line comment Bids and price will Not be accepted.
PAGE 1:
a. Quantity of Alarms in 10 Minutes, 60 Minutes, 24 hours (Gauge Type)
b. Grid with Current Active Alarms (Based on “Active?? field in Subscription Table)
c. Grid with Most 20 Active alarms in last 24 hours (Name & Quantity)
d. Grid with Most 20 Active High Priority (Priority Field in Table) alarms in last 24 hours (Name & Quantity)
PAGE 2:
a. All Alarms From Date to Date (Filter by Area, by priority, by source, etc...) USe all fields for filters.
PAGE 3:
a. 2 Grids (Subscription & Problem Table) Allow Drag n Drop from Subscription Table to Problem Table with ability to assign problem reason with a dropdown in Subscription Table Grid.
* * *This broadcast message was sent to all bidders on Wednesday Jan 5, 2011 9:52:22 AM:
Clarification on Pages and Content. PAGE 0: Logon Page PAGE 1: a. Quantity of Alarms in 10 Minutes, 60 Minutes, 24 hours (Gauge Type) b. Grid with Current Active Alarms (Based on “Active?? field in Subscription Table) c. Grid with Most 20 Active alarms in last 24 hours (Name & Quantity) d. Grid with Most 20 Active High Priority (Priority Field in Table) alarms in last 24 hours (Name & Quantity) e. Chart with Quantity of alarms each day for last 15 days. PAGE 2: a. All Alarms From Date to Date (Filter by Area, by priority, by source) PAGE 3: a. 2 Grids (Subscription & Problem Table) Allow Drag n Drop from Subscription Table to Problem Table with ability to assign problem reason with a dropdown in Subscription Table Grid.
## Platform
Detailed Design plan including any "Dashboard" type development components, additional suggeted tools or componenets, estimated completion dates, and samples of any "dashboard" type sites developed is required in bid to be considered.
One Line comment Bids and price will Not be accepted.