Create class named incident that consists of public property

Assignment Help Database Management System
Reference no: EM131299454

Project A: Survey customers

For this project, you'll create a page named CustomerSurvey.aspx that surveys customers regarding recent incidents and a page named SurveyComplete.aspx that displays a message when the survey is submitted. These pages use a variety of standard and validation controls. (Required reading: chapters 6 and 7)

• When the Customer Survey page is first displayed, all of the controls except for the Customer ID text box and the Get Incidents button are disabled.

• When the user enters a customer ID and clicks the Get Incidents button, any closed incidents for that customer are displayed in the list box and all of the controls on the page are enabled. If there aren't any closed incidents, the controls are not enabled and an appropriate message is displayed below the customer ID.

• To complete the survey, the user selects an incident, makes the appropriate selections and entries, and then clicks the Submit button. Then, the Survey Complete page is displayed with a message that depends on whether or not the user has asked to be contacted. The user can close this page or complete another survey by clicking the Return to Survey button.

Testing the Customer Survey page

• To test this page, you will need to set the starting page to the Customer Survey page. In project 2-B, however, you will add a navigation bar to this application that lets you access the various pages of the web site.

• To test this page, you can use customer IDs like 1010 and 1070. Or, you can use the Server Explorer to look at the data in the Customer table. To do that, double click on the database in the App_Data folder to open the Server Explorer, drill down in the Server Explorer to the Customers table, right click on it, and select Show Table Data.

Specifications

• Create a class named Incident that consists of one public property for each column in the Incidents table and a method named CustomerIncidentDisplay that formats an incident for display on the Customer Survey page.

• Create a class named Survey that consists of the following properties that represent the data for a survey:

Public Property CustomerID As Integer
Public Property IncidentID As Integer
Public Property ResponseTime As Integer
Public Property TechEfficiency As Integer
Public Property Resolution As Integer
Public Property Comments As String
Public Property Contact As Boolean
Public Property ContactBy As String

• Use radio button lists to implement the ratings for the three categories in the survey.

The Text properties for the list items in these lists should be set as shown on the page, and the Value properties should be set to 1, 2, 3, and 4.

• Use a radio button group for the last two radio buttons on the page.
• Use required field validators for the Customer ID text box and the Incidents list box, and use a compare validator for the Customer ID text box that checks for an integer value. In addition, use validation groups so the validators for the Customer ID text box are executed only when the user clicks the Get Incidents button, and the validator for the Incidents list box is executed only when the user clicks the Submit button.

• When the Customer Survey page is first displayed, set the focus to the customer ID text box. Then, if the user clicks the Get Incidents button and there are incidents for the specified customer, move the focus to the Incidents list box.

• To get the data that's displayed in the Incidents list box, use a SQL data source that retrieves all the rows and all the columns except the Description column from the Incidents table, sorted by the DateClosed column. Then, use a data view to filter the rows so that only the closed incidents for the specified customer are displayed. To do that, you'll need to set the RowFilter property of the data view to a compound condition where the CustomerID column is equal to the customer ID the user enters and the DateClosed column is not null.

• When populating the Incidents list box, create list items whose Text property is set to the value of the CustomerIncidentDisplay method of the incident and whose Value property is set to the incident ID. In addition, the Text property of the first item in the list box should be set as shown on the Customer Survey page, and the Value property of this item should be set to "None."

• When the survey is submitted, the application should create a Survey object and set its properties appropriately. Then, it should save a Boolean value in session state that indicates if the user requested to be contacted. The Survey Complete page can then use that value to determine the message that's displayed on the page. (Although a complete application would also perform some processing on the Survey object, this project doesn't include that processing.)

Reference no: EM131299454

Questions Cloud

Central city is part of columbia county : Central City is part of Columbia County. The Roaring River is located in Columbia County and runs through downtown Central City. On March 8, after several days of unusually heavy rain and melting mountain snow
Create schema that supports companys business and processes : Create a schema that supports the company's business and processes. Explain and support the database schema with relevant arguments that support the rationale for the structure.
What could done to advance integrity of software profession : What could be done to advance integrity and reputation of the software profession? What are the obligations of a programmer/software engineer for CLIENT and EMPLOYER?
Determine the heat loss from the surface of the lake : Determine the heat loss from the surface of the lake by radiation, free convection, and evaporation.
Create class named incident that consists of public property : Create a class named Incident that consists of one public property for each column in the Incidents table and a method named CustomerIncidentDisplay that formats an incident for display on the Customer Survey page.
Complete the flexible budgets for sales volumes : Complete the flexible budgets for sales volumes of 10,000, 12,000, and 14,000 units.
Sources of upward bias in the rate : Suppose you calculate a grocery price inflation rate. Using the arguments presented in the chapter, explain possible sources of upward bias in the rate you calculate, relative to the actual trend of food prices.
Create two user-defined roles in database adventureworks : Create two user-defined roles in database AdventureWorks that are shown in the following table and assign them the specified permissions for the PURCHASING.Vendor table:
Management plan including contingency plans : Develop key success factors, budget, and forecasted financials, including a break-even chart. Create a risk management plan including contingency plans for the identified risks.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Monitor renal outcomes in patients post cardiac bypass

monitor renal outcomes in patients post cardiac bypass surgery?want to identify factors which influence aki post

  Validity of the collected data and include the survey report

Describe the easy and difficult aspects of creating and conducting an online questionnaire. Assess the reliability of the collected data and include the survey report. Assess the validity of the collected data and include the survey report

  Design and build a small database application

Refine research and analysis skills through locating, selecting and compiling a higher-level research essay.

  Select suitable statistical measure to compare consistency

Select an appropriate statistical measure to compare consistency of sales. Make the calculations and write a report. In your calculations, include the mean sales for each salesperson.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Create a new table using the create table command

Obtain the columns names and data types of the view USER_TABLES using the DESCRIBE command. Retrieve the names of all the tables of a user's database tables using the SELECT table_name FROM user_tables; command.

  Explain what do business rules require to be effective

What are the advantages of having the DBMS between the end user's applications and the database. What are some reasons for studying file systems. IT 645 - Database Management Systems

  Create data dictionary that includes description of content

Create a data dictionary that includes the a description of the content for each field, The data type of each field, The format the data will be stored as in the field and The range of value for the field.

  Write steps to follow to create the relational database

Write down short description of database connectivity with Internet using one of widely disseminated technologies. (that is using either active server pages or Java server pages or others).

  Use the prime_minister database

Use the prime_minister database (prime_minister.sql) from the Interact Resources site. Answer the following queries from that database.

  Determine the steps in development of an effective entity

Determine the steps in the development of an effective Entity Relationship Model (ERM) Diagram and determine the possible iterative steps / factors that one must consider in this process with consideration of the HR core functions and responsibili..

  What is term for number used to reference an array element

What is the term for the number used to reference an array element? The number of elements in an array is called the ______ of the array. Arrays are most efficiently processed using ______

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd