AUTOMATION OF WEB-FORM CREATION

1
AUTOMATION OF WEB-FORM CREATION

• - KINNERA ANGADI
• MS FINAL DEFENSE
• GUIDANCE BY DR. DANIEL ANDRESEN

2
PRESENTATION OVERVIEW

• Introduction
• Motivation
• Challenge
• System Overview
• Features
• Modules
• Testing
• Unit testing
• Performance testing
• Project Metrics
• Time Frame
• Lessons Learnt
• Demo
• Conclusion

3
INTRODUCTION

• Create any web form dynamically using a web
  interface
• Input Form Questions

4
INTRODUCTION (Contd..)

• Output Form Designed

5
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

6
CHALLENGE
Question order

• 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.

User Order
7
CHALLENGE (Contd..)
8
SYSTEM OVERVIEW
9
FEATURES

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

10
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

11
FLOW CONTROL
12
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

13
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.

14
MODULE 2- ADDING THE CREATED FORM TO A MODULE
15
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.

16
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

17
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.

18
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.
• Its a great tool that provides a lot of
  capability, and its free
• It lets you simulate upto a large number of
  concurrent users. I have used up to 100
  simultaneous users.

19
TESTING- MATC - RESULTS
20
PERFORMANCE-VIEW STATE ENABLED Vs VIEW STATE
DISABLED
VIEW STATE ENABLED
VIEW STATE DISABLED
21
TESTING HARNESSIT -How it was performed
Test performed Result
Form Details Checking for the form information The form information was validated. For example form name, title, description
Form Question/Options Testing 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.
22
TESTING HARNESSIT - RESULTS
23
TESTING HARNESSIT - RESULTS
24
TESTING HARNESSIT TEST CASES
25
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
• ----------------------

26
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

27
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.

28
DEMO!!
29
CONCLUSION





30
QUESTIONS???