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 (Cont’d..) • 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. • 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.

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

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???