AUTOMATION OF WEB-FORM CREATION

- KINNERA ANGADI– MS FINAL DEFENSE

GUIDANCE BY – DR. DANIEL ANDRESEN

PRESENTATION OVERVIEW

Introduction Motivation Challenge System Overview Features Modules Testing

Unit testing Performance testing

Project Metrics Time Frame Lessons Learnt Demo Conclusion

INTRODUCTION Create any web form dynamically using a web interface Input – Form Questions

INTRODUCTION (Cont’d..)

Output – Form Designed

MOTIVATION

Creation of a new form every day by Code Form entries being saved to a database Advantages of this interface:

Creation in few clicks Form Entries - Save & e-mail Question Types Question Order Required Field Number of Characters

CHALLENGE

Create everything dynamic. Dynamic binding. Mapping the actual form

controls to the form questions. Mapping all the form questions

and entries of a form in the database.

Reporting in 2 ways. Exporting to an

excel sheet.

Question order

User Order

CHALLENGE (Contd..)

SYSTEM OVERVIEW

FEATURES

Automatic Creation No limit to the number of forms Reusability Flexibility Form entries to be both saved and e-mailed Reporting

MODULES INVOLVED

Creation of a new web form Add/Edit/Delete Questions

Adding the form to that module Add/Copy/Delete forms

Reporting the form entries View by Questions Order View by User Order Export to an Excel Sheet

FLOW CONTROL

MODULE 1 -CREATE A NEW FORM

Step1. Form Information Form name, description, author

Step2. Add Form Items/Questions. a) Text Question b) Option Button List c) Check Box List

d) Dropdown List. Step3. Add/Edit Item/Question.

Question Text, Question Order, Answer data type, Number of characters.

Step4. Add/Edit Option Questions. Option text, Option Order. Edit options

Edit/ Update/ Delete Options Step5. Form Preview

Edit/ Update Questions/ Options

MODULE 2- ADDING THE CREATED FORM TO A MODULE

Navigate to the form. Check the option (s) for the form entries to be either e-

mailed to a designated person, saved into the database, or both. Enter the e-mail address where the form entries have to be e-mailed.

Click the corresponding Add/Update button to add that form to the module. Once a form is added to the module it will be displayed on the first main page.

You can delete the form from your module. If you do so, your data entries will be lost.

Using copy function you can create a replica of an existing form and modify it the way you want.

MODULE 2- ADDING THE CREATED FORM TO A MODULE

MODULE 3- REPORTING THE FORM ENTRIES

View by Entry: This button will display the entries of the form based on entries.

If you need to export the data displayed to an excel file then click the button “Export to Excel”.

View by Question: This button will display the entries of the form based on question numbers.

TESTING-ANTS LOAD

ANTS LOAD is used to predict a web application's behavior and performance under the stress of a multiple user load

I have used up to 25 concurrent users

ANTS LOAD - RESULTS

The time to connect to the web page is not too high and hence the web page will not be abandoned by the users.

The time between the first byte and the last byte received is not too high when the application was tested from a dial up connection. Hence typically this application should perform with less level of “frustration” and “lost ness” while creating forms from typical networks speeds.

TESTING- MATC

This is used to stress test web servers and analyze performance and scalability problems with web applications.

This type of testing is accomplished by opening multiple connections to the server and rapidly sending HTTP requests, thereby simulating a large group of users.

It’s a great tool that provides a lot of capability, and it’s “free”

It lets you simulate upto a large number of concurrent users. I have used up to 100 simultaneous users.

TESTING- MATC - RESULTS

PERFORMANCE-VIEW STATE ENABLED Vs VIEW STATE DISABLED

VIEW STATE ENABLED

VIEW STATE DISABLED

TESTING – HARNESSIT-How it was performed

Test performed Result

Form DetailsChecking for the form

information The form information was validated. For example: form name, title, description

Form Question/OptionsTesting the form questions and answers, Question order, Question size, Required fields, Data Types – TB, RB, CB, DDL

The form questions and answers were obtained as expected. The test for the Question order, Question size, Required fields, Data Types – TB, RB, CB, DDL gave expected results.

Delete Form Questions/ Options

The form questions and options were deleted and checked for the correct functioning of the

delete mode

The results were expected as desired after the question was deleted.

TESTING – HARNESSIT - RESULTS

TESTING – HARNESSIT - RESULTS

TESTING – HARNESSIT – TEST CASES

PROJECT METRICS

Microsoft Visual Studio.NET 2003 ASP.NET, C# Oracle 10g Source Code Lines

Web Forms :2210 Web User Control :1570 Class File : 960 Total : ------------------

4740

----------------------

TIME FRAME

October 05 – December -05 Data base Design, Analysis, System Architecture

January 06 – April 06 Implementation, Modules – Create form, Add form, Reporting

April 06 – June 06 Testing, Documentation

LESSONS LEARNT

Usage of data grid item templates, properties, how to embed edit update cancel hyperlink columns into the data grid, how to dynamically bind text to data grid.

I have learnt the importance of user controls in ASP.NET. I have learnt the usage of Object oriented concepts in ASP.NET. Export results form a data grid to an excel sheet I have learnt auto e-mail generation. Validation of forms - usage of Regular expressions in ASP.NET. I have learnt to create stored procedures and packages. I have learnt

the usage of input output parameters used in the tables. I have also learnt nested queries, usage of sequence and triggers.

I have learnt the testing tools ANTS Load (version 1.7), HarnessIt and Microsoft Application test Center.

DEMO!!

CONCLUSION

QUESTIONS???