Home

Content Management System For Conference Paper Handling

1. Note that the runat must be set to server because the control is a server control lt asp DropDownList ID userrole runat server gt lt asp Listltem gt Doctor lt asp Listltem gt lt asp Listltem gt Faculty lt asp Listltem gt lt asp Listltem gt Librarian lt asp Listltem gt lt asp Listltem gt Researcher lt asp Listltem gt lt asp Listltem gt Student lt asp Listltem gt lt asp Listltem gt Teacher lt asp Listltem gt lt asp Listltem gt Other lt asp Listltem gt lt asp DropDownList gt lt td gt Tong Jiao Content Management System for Conference Paper Handling 18 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report In addition a list of world country names is displayed in a dropdownlist in this page as well by attaching the dropdownlist control to a list of world country names stored in the database Here the SqlDataSource control is used to bind the data The SqlDataSource control is a data source control that represents a connection to an ADO NET SQL database provider such as SQL OLEDB ODBC or Oracle In this project the database provider is OLEDB The details about the data connection part will be discussed later in the database development section The screenshot of final register page is shown in the Figure 8 The Conference Paper Management System Home Register Login Nid Contact Us Each author or reviewer sho
2. Communication and Electrical Engineering BSc Final Year Project Report myConn ConnectionString Provider Microsoft Jet OLEDB 4 0 Data Source DataDirectory CMS mdb After the SqlDataSource control is added in the page the next step is to bind this control to a GridView Control Again this can be done in the VS2005 by dragging and dropping a GridView Control Once the GridView control is added to the page in design mode a small arrow will appear on on the right upper corner of the GridView This brings up a dialog where the developers can specify which datasource to bind to so the SqlDataSource control is selected here 3 6 ASP NEI Web config File An ASP NET application has one web config file which keeps the configurations required for the corresponding application Web config file is written in Extensible Markup Language XML with specific tags having specific meanings There are number of important settings that can be stored in the configuration file In this project database connections error handling and security information are stored inside Web config file The database connection string is the most important configuration data that can be stored inside the web config file Storing the connection string in the web config file makes sense since any modifications to the database configurations can be maintained at a single location and it can be read and used anywhere in the program 17 The following figure shows the
3. No Access error Error 404 is File not found error If custom error mode is turned off then the designers will see ASP NET default error message The most critical aspect of any application is the security ASP NET offers many different types of security method such as Windows authentication passport authentication or forms authentication which can be used depending on the condition and type of security the users need Within this project the Windows authentication is used The main benefit of using Windows authentication is that it can be coupled with IIS authentication so that no custom code needs to be written 18 The Windows authentication provider is the default provider for ASP NET It authenticates users based on the users Windows accounts Windows authentication in ASP NET actually relies on IIS to do the authentication IIS can be configured so that only users on a Windows domain can log in If a user attempts to access a page and is not authenticated they ll be shown a dialog box asking them to enter their username and password This information is then passed to the Web server and checked against the list of users in the domain H the user has supplied valid credentials access is granted The identity of the user is then passed to the ASP NET engine 19 Tong Jiao Content Management System for Conference Paper Handling 34 University of Hertfordshire School of Electronic Communication and Electrical Engineeri
4. database 3 2 7 Conference Website There are two conference websites managed by this CMS These two websites have got the same structure Each website has its own Homepage Call for Paper page Conference Organization page Paper Submission page and Contact Us page when it comes to the Paper Submission the users will be taken to the CMS login page Then the users will be required to login first Tong Jiao Content Management System for Conference Paper Handling 14 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report 3 2 8 Navigation Diagram A navigation diagram in the Figure 5 is used to describe how each page involved in this CMS will be related to each other Figure 5 Navigation Diagram Tong Jiao Content Management System for Conference Paper Handling 15 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report 3 3 Description of Navigation Design From the starting point of this CMS the first page that the user will encounter will be the login page Here the user will be asked to enter a valid userID and password to access the system The userlD and password can be obtained after the user registered successfully via Register page within the system In addition the hyperlinks of the two conference websites which are managed by this CMS are listed on the bottom of this page A
5. database connection string which is stored in the web config file lt configuration gt lt appSettings gt lt connectionStrings gt lt remove name LocalSqlServer gt lt add name CMSConnsStr connectionString Provider Microsoft Jet OLEDB 4 0 Data Source DataDirectory CMS mdb providerName System Data OleDb gt lt connectionStrings gt lt system web gt lt Error handling is one of the most important parts of any web application Each error has to be caught and suitable action has to be taken to resolve that problem ASP NET web config file lets application developers configure what is going to do when an error occurs in the application The following figure shows the XML tag in the web config file that deals with errors Tong Jiao Content Management System for Conference Paper Handling 33 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report lt customErrors mode RemoteOnly defaultRedirect GenericErrorPage htm gt lt error statusCode 403 redirect NoAccess htm gt lt error statusCode 404 redirect FileNotFound htm gt lt customErrors gt RemoteOnly specifies that custom errors are shown only to remote clients and ASP NET errors are shown to the local host This is default and tells the ASP NET to display custom errors from a remote client and display a page named GenericErrorPage htm Error 403 is
6. http www asp101 com articles sample_chapters sitepoint_byoaspnet20 chapter3 asp 14 W3Schools ASP NET Tutorial ASP NET Calendar Control Internet Available at http www w3schools com aspnet control_calendar asp Accessed 25 March 15 Learning Space The database development life cycle Internet Available at http openlearn open ac uk mod resource view php id 187274 Accessed 26 March 16 Ryan K Stephens and Ronald R Plew 2001 Database Design Sams Publishing 17 Codersource net 2005 what is Web Config File Internet Available at http www codersource net asp_net_web_configuration_file ntml Accessed 19 March 2008 18 J D Meier Alex Mackman Blaine Wastell Prashant Bansode Andy Wigley Kishore Gopalan August 2005 MSDN Security Developer Center How To Use Windows Authentication in ASP NET 2 0 Internet Available at http msdn2 microsoft com en us library ms998358 aspx Accessed 19 March 2008 19 Nandini Venugopalan March 12 2004 An Overview of Authentication and Authorization Options in ASP NET Internet Available at http aspnet 4guysfromrolla com articles 031204 1 aspx Accessed 19 March 2008 20 Learning Space 18 January 2008 The database development life cycle Internet http openlearn open ac uk mod resource view php id 187278 Accessed 26 March Tong Jiao Content Management System for Conference Paper Handling 43 University of Hertfordshire School of Electronic Communication
7. 24 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report The Conference Paper Management System Welcome to The 7th World Congress on Intelligent Control and Automation Yune 25 27 2008 International Convention Why you should attend the conference Home Dall tor Paper Conference Organization Paper Submission the 7th World Congress on Intelligent Control and Automation WCICA 08 is now a bi annual event and a major international control conference held in China The WCICA 08 will be held in the famous mountain city Chongqing in southwestern China on June 25 27 2008 The congress aims to provide a broad international forum for world researchers engineers and professionals working in the areas of Intelligent Control and Automation to discuss and exchange their findings ideas and views The Congress will focus on both theory and applications In addition to the regular technical sessions there will be plenary and invited sessions as well as social activities The papers in the proceedings of WCICA 08 are published by IEEE and indexed by EL Important Dates Paper submission deadline April 25 2008 Figure 13 screen shot of Conference Website II Homepage 3 4 7 Feedback Page The Conference Paper Management System Contact Us and Send us feedback Label3 Name Email Title EN Nour Comments Figure 14 screen shot of Feedback Page Tong J
8. Distributed Parameter Systems S5 Hybrid Systems and DEDS S6 Large Scale Systems S7 Stochastic Systems Figure 22 Call for Paper Page E Association Automation ical Committee on Control CAA ee X Ee The 27th We 2 gt KK S Ch BE Eon t rol Conference f Minmens University of Science and Technology Home Call for Paper Conference Organization Paper Submission Contact Us Conference Organization Sponsoring Organizations Tech Com On Control Theory CAA Kunming University of Science and Technology Yunnan Automation Association Co Sponsored by IEEE Control Systems Society CSS The Society of ICE SICE of Japan The ICROS of Korea Institute of Systems Science AMSS CAS Yunnan University Yunnan Normal University Figure 23 Conference Organization Page Tong Jiao Content Management System for Conference Paper Handling 55 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report Appendix Other Webpages for the 7 World Congress on Intelligent Control and Automation The Conference Paper Management System Welcome to The 7th World Congress on Intelligent Control and Automation June 25 27 2008 International Convention Why you should attend the conference Home CallforPaper Conference Organization Paper Submission The 7th World Congress on Intelligent Control and Automation WCICA 08 will be held in Chongqi
9. Figure 15 Summary of steps for database design 15 After that it will go to the implementation stage The Implementation stage mainly involves the construction of a database according to the specification given in the previous stage The first step of implementation would include meeting the design requirements with the best available implementing tools and then using those tools for the implementation 3 5 1 Table Design As stated in the literature research chapter Microsoft Access is a very powerful relational database management system and it provides users with one of the simplest and most flexible database management solutions For this reason the database within the project was created using Microsoft Access as the implementing tool Although a relational database might be comprised of various objects such as tables queries forms reports or modules design always begins with the tables Tables are the fundamental logical building blocks of relational databases In the context of database a table is a grouping of columns of data that pertains to a single particular class of things about which information needs to be stored Columns can also be referred to as fields or attributes and rows can be called records 16 The following steps show the process to create tables in Microsoft Access gt Start Microsoft Access by double clicking on the icon Tong Jiao Content Management System for Conference Paper Handling 27 Uni
10. It consists of Author Center where authors can upload research files and Reviewer Center where reviewers have the facilities for accessing papers and uploading comments Following the test it can be included that the majorities of objectives were met However it still had been considered that many improvements could be made to the system in the future and these future developments well be explained later in the next chapter Tong Jiao Content Management System for Conference Paper Handling 39 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report 5 Conclusion amp Future Development This chapter makes a conclusion about this project It covers all the core content that has been mentioned in the previous chapters to establish whether the aims and objectives of this project have been achieved or not 5 1 Conclusion In this project the aim of this project was to develop a web based content management system offering the functionality required for the design of paper handling aspects of conference websites The outcomes should allow the authors to upload the research files and reviewers facilities for accessing papers and uploading comments The majority of requirements required by the users were met by implementing the Conference Center Page in the sytem It consists of Author Center and Reviewer Center which are used to offer the functionality required by the
11. Management Bible 2nd Edition Wiley Publishing Inc Indianapolis Indiana 2 A Euro resource for Content Managers and Content Management System CMS Suppliers What is a CMS Internet Available at http www contentmanager eu com history htm Accessed 20 March 3 Chris Price 2007 Compare CMS Internet Available at http www a3webtech com index php cms html cms v php asp Accessed 20 March 4 Rob Prideaux February 25 2004 Knowing When You Need a CMS Internet Available at http www techsoup org learningcenter webbuilding page4896 cfm Accessed 23 March 5 Tucows 2007 A New Way of Developing Software at Tucows Part 1 Internet Available at http images google co uk imgres imgurl http about tucows com wp wp content uploads 2007 05 agile waterfall model gif amp imgrefurl http about tucows com 2007 05 amp h 269 amp w 350 amp sz 7 amp hl en amp start 24 amp um 1 amp tbnid 8Xh8SEIfRBHAM amp tbnh 92 amp tbnw 1 20 amp prev images 3Fq 3Dwaterfall 2Bmodel 26start 3D18 26ndsp 3D18 26uM 3D1 26hI 3Den 26sa 3DN accessed 12 March 2008 6 TomR 2006 ntroducing the wicket A new application development model Online Available at http www newrowley com 2006 08 introducing_the_wicket_a_new_a html accessed 12 March 2008 7 Melonfire 2007 Understanding the pros and cons of the Waterfall Model of software development Online Available at http www builderau com au strategy designprinciples soa U
12. Response Write lt script gt alert You login attempt was not succssful Please try again lt script gt End If reader Close myConn Close reader Close myConn Close End Sub End Class Tong Jiao Content Management System for Conference Paper Handling 46 University of Hertfordshire School of Electronic Communication and Electrical Engineering Appendix C Author Center Page VB Code Imports System Imports System Data Imports System Configuration Imports System Collections Imports System Web Imports System Web Security Imports System Web UI Imports System Web UI WebControls Imports System Web UI WebControls WebParts Imports System Web UI HtmlControls Partial Class uploadfile Inherits System Web UI Page BSc Final Year Project Report Protected Sub Button1_Click ByVal sender As Object ByVal e As System EventArgs Handles Button Click Dim myConn As New Data OleDb OleDbConnection myConn ConnectionString Provider Microsoft Jet OLEDB 4 0 Data Source DataDirectory CMS mdb myConn Open Dim comm As OleDb OleDbCommand Dim strtitle As String Trim title Text Dim strauthor As String Trim author Text values Dim strabstract As String Trim abstract Text Dim strkeywords As String Trim keywords Text Dim strarea As String Trim area Text Dim strfile As String Trim FileUpload1 FileName Dim strinsql As String strinsql insert into tab_paper title author abstract keywords area
13. Tong Jiao Content Management System for Conference Paper Handling 1 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report 1 3 Plan of Work The key to a successful project is in the planning As the aims and objectives are established in the above the project work breakdown structure needs to be identified Also a detailed project planning schedule corresponding to the breakdown work needs to be created Therefore the entire project is divided into five stages That is system analysis stage system design stage system implementation stage system testing stage as well as report writing stage The activities involved in the system analysis stage is to have a deep understanding about content management system CMS and then gather the requirements of this particular CMS for conference paper handling As part of this work research is conducted into the paper handling characteristics expected for international conference websites For this reason a series of conference websites such as ICASSP 2007 Interspeech and IEEE Odyssey are visited The system design stage involves lay out the user interface and construct the database related to the project This stage is the translation of the requirements and information gathered in previous stage of what needs to be accomplished into how it will be accomplished The system implementation phase is where the system becomes
14. authors and reviewers respectively The process of project development was based on Waterfall Model which is a classic System Development Life Cycle model explained in the literature research section And the scenario of this project was met by means of using ASP NET web technology based on VB NET programming language within the Integrated Development Environment Visual Studio 2005 from Microsoft Also all of these were tested after implementation stage by means of Alpha tesing methodology using server side technology such as IIS To make a conclusion for this project it can be said that the system has been developed near enough to its original specification The majority of functionality required are met even if there were still a number of addition can be made to this system in the future 5 2 Future Development It has been identified following recommendations can be proposed for further development to improve the current system if more time was given Which are gt There may perhaps be a Personal Messaging Service implemented in the system which is used to allow the direct interactive communications between the authors and the reviewers gt For the authors paper status tracking function should be taken into account For example a the research paper submission information in tables can be presented for quick reference Authors can track whether the paper is accepted or not by the conference committee here Tong Jiao Cont
15. e As System EventArgs Handles GridView1 SelectedIndexChanged End Sub Tong Jiao Content Management System for Conference Paper Handling 49 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report Protected Sub SqlDataSource1_Selecting ByVal sender As Object ByVal e As System Web UI WebControls SqiDataSourceSelectingEventArgs Handles SqlDataSource1 Selecting End Sub End Class Tong Jiao Content Management System for Conference Paper Handling 50 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report Appendix E Register Page VB Code Imports System Imports System Data Imports System Configuration Imports System Collections Imports System Web Imports System Web Security Imports System Web UI Imports System Web UI WebControls Imports System Web UI WebControls WebParts Imports System Web UI HtmlControls Partial Class _ Default Inherits System Web UI Page Protected Sub Button1_Click ByVal sender As Object ByVal e As System EventArgs Handles Button1 Click Dim myConn As New Data OleDb OleDbConnection myConn ConnectionString Provider Microsoft Jet OLEDB 4 0 Data Source DataDirectory CMS mdb myConn Open Dim comm As OleDb OleDbCommand Dim comm2 As OleDb OleDbCommand Dim tables As OleDb OleDbDataReader Dim strsql As String Dim strtitle As String Trim title Text Dim strlast
16. real For a CMS solution this means not only configuring the software to meet the specifications outlined in the previous stage but also following a traditional software development process of coding and testing navigation and browser Both these items are then put through system testing stage Based on the analysis of various working stages as described above a detailed project planning schedule or in other words time management is drawn up using Gantt chart method Time management is a subset of project management that includes the processes required to ensure timely completion of the project The Gantt Chart is shown in the Appendix A 1 4 Outline of the Report Since this project is aimed to develop a content management system for conference paper handling the outline of this report is based on a typical system development process This report consists of five chapters in total Tong Jiao Content Management System for Conference Paper Handling 2 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report Chapter 1 is about the introduction to the project It gives the necessary background information with regard to this project such as description of project aims and objectives initial plan of work as well as the main structure of this report Chapter 2 covers the review of literature research conducted relating to the project First it discusses the general
17. this particular content management system from initial literature research to the final evaluation progress Tong Jiao Content Management System For Conference Paper Handling University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report ACKNOWLEDGEMENTS First of all would like to thank my supervisor Aladdin Ariyaeeinia for all the guidance and support that he has given to me throughout this project He was always there to listen and to give advice to me with much patience have learned a lot from him about the attitude as well as skills for conducting this project would also like to thank Johann Siau for all the technical assistance that he has given to me for completing this project effectively Last but not least am greatly thankful to my parents for their financial support and encouragement throughout my final year Their love and trust help me go through all the difficulties in the process of this project Tong Jiao Content Management System For Conference Paper Handling University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report TABLE OF CONTENTS DECLARATION EH WR EE HE i ERT i ACKNOWLEDGEMENTS tg egen kaanane naai aea aaa aaoi a a aa iaaea ege ii TABLE OF GON TIENTS emer d eges gef optincyesecetehcawecnteyendeuebuawecnive geg eesgekte gege degen iii EIS TOF FIGURES EE v G
18. window location default aspx lt script gt End If Else Response Write lt script gt alert Password do no match Please re enter all password data history back 1 lt script gt End If myConn Close End Sub Protected Sub SqlDataSource1_Selecting ByVal sender As Object ByVal e As System Web UI WebControls SqiDataSourceSelectingEventArgs Handles SqlDataSource1 Selecting End Sub Protected Sub country_SelectedIndexChanged ByVal sender As Object ByVal e As System EventArgs Handles country SelectedIndexChanged End Sub Protected Sub userrole_SelectedIndexChanged ByVal sender As Object ByVal e As System EventArgs Handles userrole SelectedIndexChanged End Sub End Class Tong Jiao Content Management System for Conference Paper Handling 52 University of Hertfordshire School of Electronic Communication and Electrical Engineering Appendix F Feedback Page VB Code Imports System Imports System Data Imports System Configuration Imports System Collections Imports System Web Imports System Web Security Imports System Web UI Imports System Web UI WebControls Imports System Web UI WebControls WebParts Imports System Web UI HtmIControls Partial Class bbs Inherits System Web UI Page BSc Final Year Project Report Protected Sub Button1_Click ByVal sender As Object ByVal e As System EventArgs Handles Button1 Click Dim myConn As New Data OleDb OleDbConnection myConn ConnectionString Provider Microsoft Je
19. would be included on each page of the system are designed correspondingly Tong Jiao Content Management System for Conference Paper Handling 12 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report 3 2 1 Home Page Login Page The homepage of this CMS which is the login page at the same time is mainly designed for providing authorized access to this system This page has got links to access the upcoming conference websites managed by this CMS If the user just wants to have a look at either one of the upcoming conferences websites he doesn t need to log in Access those websites just by clicking the links listed on the page If he wants to submit a research paper as an author or makes any comments to the paper as a reviewer he must login first 3 2 2 Register Page The Register Page requires basic information related to the user such as Last Name First Name E mail address and so on to give him his own User ID which is used to log in the system Any user who wants to use this CMS to submit a research paper or gives comments to the paper will be asked to register via this page 3 2 3 Welcome Page When the user logs in successfully he is taken to the Welcome Page Here the user will see links to the conference center which consists of author center and reviewer center Users logged in as authors or logged in as reviewers are given Author and Reviewer permis
20. 21 problem occurred 4 4 System Evaluation As this project is aimed to create a web based content management system offering the functionality required for the design of paper handling aspects of conference websites The outcomes should allow different interactive operations for the authors and reviewers Tong Jiao Content Management System for Conference Paper Handling 38 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report Following the analysis of user authors and reviewers requirements stated in the Chapter 1 it was apparent that a friendly user interface navigate with ease and data security were some of the key issues which need to be taken into account seriously for this CMS Specific functionality required by the authors or reviewers such as uploading the research paper or facilities for accessing the papers and submitting comments need to be met According to these requirements a web based content management system for conference paper handling was developed The system consists of ASP NET web based application and the database using Microsoft Access Both authors and reviewers would be provided with userlD and password for the security reason Based on the login details the CMS system recognizes the user role and direct the relevant page to the user For example the Conference Center Page was created to meet the requirements required by the main users
21. BACHELOR OF SCIENCE DEGREE DEGREE WITH HONOURS IN DIGITAL TECHNOLOGY Final Year Project Report School of Electronic Communication and Electrical Engineering University of Hertfordshire Content Management System For Conference Paper Handling Report by Tong Jiao Supervisor Aladdin Ariyaeeinia Date April 2008 DECLARATION STATEMENT certify that the work submitted is my own and that any material derived or quoted from the published or unpublished work of other persons has been duly acknowledged ref UPR AS C 6 1 Appendix Section 2 Section on cheating and plagiarism Student Full Name Tong Jiao Student Registration Number 06130545 el KEE Date 06 April 2008 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report ABSTRACT The Content Management System within this project is a web application which is used to offer functionality required for the design of paper handling aspects of international conference websites Microsoft Visual Studio 2005 is the integrated development environment and the main tool used to develop this system The completed project is dedicated to the easy and affordable management of all aspects of the process of organizing conference papers such as uploading research papers and reviewers facilities for accessing papers as well as uploading comments This report explores in detail the development stages of
22. LOSSARY EE vi Urteel Let 1 1 1 Background Dit tu e TT 1 1 2 Project Aims and Objectives ceecceceeceeeeeeeeeeeceeeeeeeaeeeeaaeseeeecaaeeesaaeeseaeeseeessnaeeeeaaeseneees 1 1 2 1 Ee 1 1 2 2 Project e TEE 1 CH Plan of WOK EE 2 1 4 Outline of the Heport cee ceccececeeeceeeceeeeeeaaeeeeeeeeeaeeeeaaeseeaaeseaeeecaaeeseaaesseaeeseaeestaeeseaaessnees 2 2 Literature Heeearelt screutiiedeuseSeeeuieg Seet ed DEEN DEENEN EE EA AAA EA a ai 4 2 1 Understanding Content Management Gvstem 4 2 1 1 Introduction of CMS 4 2 1 2 TYPOS EE 4 2 2 System Development Life Cycle Model Overview sssssssssrsssrrssrrssrnssrnsrnssrnssrnsrrnssrnsns 5 2 3 Web Application Framework ASP NET cess eeeeeeeeeeeeceaeeeeaeeseeeeeseaeeeseaeeneaeeees 7 2 3 1 How does ASP NET work 7 2 3 2 What iS AN ASP NET Fle ou cccccccccccccceceencececeeecaeeeeaaeeeeneecaeeeeaaeseeaaeseaeeeseaeeseaaeseeaeeseaes 8 2 4 Misual Studio 2005 E 9 2 5 Microsoft Access Database 0 ccccceeeccceeeeeceeeeeeeceeeeeeeceeeeeeaeeesseaaaeeeeeaeaeseeeaseeeeeeaeenetees 10 2 6 Programming Language Technologies 10 2 6 1 VB NET KEE 10 EE 11 26 3 XML EE 11 3 System Design and Implementation 12 3 1 Defining User Requirements of this CMS 12 3 2 Description of Actual Page Content 12 32 1 Home Page LOGIN PaQe vesicoinecccttscaaciteten fo Gtaacteeat eecents A AANEEN SAA 13 2 2 RORO PAGO E 13 29 Welcome PAGO ssa xaceicitienccitusaacusiin sccenlacaceeten eaceitteaeielin excenl
23. School of Electronic Communication and Electrical Engineering University of Hertfordshire GLOSSARY ASP NET CMS DBMS lis ODBC SDLC SQL VB NET VS XML Tong Jiao Content Management System For Conference Paper Handling the latest version of Microsoft s Active Server Page Technology Content Management System Database Management System Internet Information Services Open Database Connectivity System Development Life Cycle Structured Query Language Visual Basic NET Visual Studio Extensible Markup Language vi BSc Final Year Project Report University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report 1 Introduction 1 1 Background Information A Content Management System CMS is a software system used for content management The content management systems are deployed primarily for interactive use by a potentially large number of contributors As for this project the particular CMS is mainly for conference paper handling aspect it s designed to offer extensive support throughout all phases of submission and review process for the International conference papers The completed application is dedicated to the easy and affordable management of all aspects of the process of organizing conference papers It will enable a user to access the system with ease by its ease of navigation and allow such interactive operations a
24. Writing 3 3 08 4 6 08 jojo gt S S e Ps m Se cn C 3 cn gt co cn S S Et lt ir S S lee lr Ir CO 5 Tong Jiao Content Management System for Conference Paper Handling 45 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report Appendix B Login Page VB Code Imports System Data SqIClient Imports System Net Partial Class _Default Inherits System Web UI Page Protected Sub Login1_Authenticate ByVal sender As Object ByVal e As System Web UI WebControls AuthenticateEventArgs Handles Login1 Authenticate Dim myConn As New Data OleDb OleDbConnection myConn ConnectionString Provider Microsoft Jet OLEDB 4 0 Data Source DataDirectory CMS mdb myConn Open Dim Name As Siring Trim Login1 UserName Dim Password As String Trim Login1 Password Dim myCmdStr As String myCmdStr SELECT reg_name reg_pass FROM tab_user where reg_name Name _ and reg_pass Password Dim myCmd As Data OleDb OleDbCommand New Data OleDb OleDbCommand myCmdsSir myConn Dim reader As Data OleDb OleDbDataReader myCmd ExecuteReader If reader Read Then Session username reader reg_name Response Redirect homepage aspx Else
25. achiertelt eerthenaeneein seemaceceetion 13 3 2 4 Author Center Page 13 3 2 5 Reviewer Center Page cscccccccccecceeseeceeneeceeeeeaaeseeaeeseeeeesaaeseeaaesseeeeseaeeseaeeeeaeeesaes 13 326 Feedback PAGE cc setazctc ce csegenteeendeteneshtes betangenvd andes bandeaex ested atten onde ate eee 14 3 2 7 Conference Webseite 14 3 2 8 Navigation Diagram eeeeeceee cette ee ente ee te tnte ee teen ee eee KEENE AEAEE ENEON EEUE EEEREN 15 Tong Jiao Content Management System For Conference Paper Handling University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report 3 3 Description of Navigation Design 16 3 4 System Implementation ccecceeececeeeeeceeeeeeeeceeeeeceaeeeeaaeseeeeeseaeeesaaeeseaeeseeeeescaeseseaeeeenees 16 JA T LOOF AJE eege Dogue chink dence ee ee eg Deedes dnd ae Eege 16 dA e E FAQ EE 18 94 9 WOIGCOME PAGO EEN 19 3 4 4 Author Center Page 20 3 4 5 Reviewer Center Page ccccccccceccceesseceeceeceeeeeaaeseeneeceeeesaaeeteaaeseeeeeseeeeeeaaesteaeeeeaes 22 3 4 6 Conference Website Homepage esueseesisesinesinesrrssrnssrnssiresinnsinssrnssrnssrnnsrnesnnnt 23 2A FOCUDACK EE ee ees eege ee e Hentai debe eege ebe e ee EEN 25 3 5 Database Development ecceeececeeeeeceeeeeeeeeeeeeeeeeesaeeaeeesaaeaeeesaaeaeeesaeeaeeeseeeaeeeseeeaeenenaes 26 35 17 Table DOSION EEN 27 3 5 2 Connection to DAtADASE sceccccceceeeceenteceeneecee
26. agencies or graphic design firms 4 As mentioned in the beginning the main aim of this project is to develop a CMS offering the functionality required for the design of paper handling aspects of international conference websites so this project can be regarded as a Web Content Management System 2 2 System Development Life Cycle Model Overview The system development life cycle SDLC is a project management technique that divides complex project into smaller more easily managed stages from an initial feasibility study through maintenance of the completed application Various SDLC methodologies have been developed to guide the processes involved The waterfall model is a classic SDLC model Figure 1 and it is the most widely used paradigm The classic waterfall development model Requirements analysis Figure 1 the Classic Waterfall Model 6 Tong Jiao Content Management System for Conference Paper Handling 5 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report The waterfall model regards software developments as a set of phases or stages that a developer goes down in a cascading way just like water going down a waterfall That s why it is called this name In the waterfall model the developers start at the first phase and move on to the next one as soon as the current phase is complete 5 gt Requirements Analysis This first step involv
27. and Electrical Engineering BSc Final Year Project Report BIBLIOGRAPHY 1 Bob Boiko 2005 Content Management Bible 2nd Edition Wiley Publishing Inc Indianapolis Indiana 2 Gavin Powell 2006 Beginning Database Desin Wiley Publishing Inc Indianapolis Indiana 3 Thearon Willis Bryan Newsome Beginning Visual Basic 2005 Wiley Publishing Inc Indianapolis Indiana Tong Jiao Content Management System for Conference Paper Handling 44 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report APPENDICES Appendix A Gantt Chart i fi D BPG H IJ RIL MN OP QRS T UVR XY 2 AM AB AC AD AB AR October November December January February March April TASK arn inn wf an ol a System Analysis vol el TTT TTT TT TTT ETE ETT ET Project Title Definition one ohonso 2 Mm TL TTL ELLE ELLER ERE Functional Requirement Specification 10 20 07 10 30 ITIIIIITIIIIIIITITIIIIIIITI Feasibility Stud 10 19 07110 30 PEE EEL TLL ELEL ELLE LL ELL ELLE System Design Content Flow Chart 14 2 07 11 7 0 Design Of Interface It 25 0 Database Design 14 28 07112 System Implementation Learning Visual Studio 2005 12 10 07 1 1 08 Web Site Implementation 12 20 07 1 10 08 Database Implementation 1 12 08 2 3 08 Connection to Database 2 5 08 2 20 08 System Testing Navigation Test 2 21 08 2 23 t Browser Test 2 25 07 2 27 System Evaluation 3 1 08 3 8 08 Report
28. b front end to the database is a very important part of the system In the context of this CMS for example when an author uploads a research paper the database will record the uploading information with date and time The research paper is then saved on the server but the link is saved in the databse These data can then be retrieved by the reviewers via reviewer center using web front end Reviewers then submit their recommendations or comments for each research paper And those recommendations or comments should be retrieved to the web front end for the conference organizors to view ASP NET gives their users flexibility in how they connect to databases One of the features in ASP NET is its data specific controls which are divided into two groups DataSource controls and Data Bound controls DataSource controls are used to create the connection to the databases whereas the Data Bound controls are used to take the information from the data source controls and create a rendering on the page A number of data source controls are available in ASP NET SqiDataSource Control is one of them and is used in this project The Data Bound controls like GridView Control or DropDownList control mentioned in the previous section already are used to take the information from the data source controls As ASP NET is part of the NET Framework the application developers have access to all the goodies that are built into it in the form of the NET Framework Class Lib
29. choices are made as to which tables are most appropriate for representing the data in a database These choices must take into account various design criteria including for example flexibility for change control of duplication and how best to represent the constraints It is the tables defined by the logical schema that determine what data are stored and how they may be manipulated in the database This first step Sometimes called a first cut design will accurately represent the tables and constraints needed to satisfy the conceptual data model description and so satisfies the completeness and integrity requirements but it may be inflexible or offer poor usability The first cut design is then flexed to improve the quality of the database design Figure 15 summarizes the steps involved in the database design stage 15 Tong Jiao Content Management System for Conference Paper Handling 26 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report Use a relational representation of the conceptual data model to give a set of tables for a first cut database design Do the tables represent the data in an acceptable way according to the given criteria for usability efficiency and so on Define constituents of schema Flex tables to produce for each table such as second cut design ev columns a primary keys foreign keys s constraints Implementation
30. complexity and range gt Enterprise Content Management Systems ECMS ECMS emphasize comprehensiveness They are used to manage all aspects of an organization s content publication processes including Web print and any alternative outputs The products offer a good amount of functionality complexity and range Tong Jiao Content Management System for Conference Paper Handling 4 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report gt Document Management Systems DMS Technically these are parallel to CMS but they focus on documents such as Microsoft Word files and are more for internal use than for presenting content for public consumption They vary broadly in functionality complexity and range gt Digital Rights Management Systems DRMS These are also parallel or complementary to CMS These systems only manage intellectual property rights information for any content that exists They vary broadly in functionality complexity and range but tend to specialize in areas where Digital Rights are a priority such as music or video gt Asset Management Systems AMS These are also parallel to CMS These systems manage so called content assets images video audio and other binary non textual content They vary broadly in functionality complexity and range but tend to be used in organizations where assets like these are numerous such as photo
31. ctable by the author This function is achieved by using the DropDownList control as the same way as a list of world country shown in the register page Tong Jiao Content Management System for Conference Paper Handling 20 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report The file types which are allowed to upload via this CMS are restricted to Word or PDF In order to impose this restriction the If statement is used here in conjunction with an Else statement which specifies what should happen if the condition is not met So the code written below means if it is found that the uploading file type is not Word or PDF the user will see a warning sentence like failed Only pdf and doc files are allowed on the screen If _fileExtension pdf Then Save File to the proper directory _postedFile SaveAs System Web HttpContext Current Request MapPath _ files _ fileName _message Append _fileName lt BR gt Elself _fileExtension doc Then Save File to the proper directory _postedFile SaveAs System Web HittpContext Current Request MapPath _ doc _ fileName _message Append _fileName lt BR gt Else _message Append _fileName amp lt font color red gt failed Only pdf and doc files are allowed lt font gt lt BR gt End If Upon successful submission the uploading research paper will
32. eecaaeeeeaeeseeeeesaaeeeeaaeseeeeeseeeesiaeeseeeseaes 32 3 6 ASP NET Web config Ee 33 4 System Testing and Evaluatton ntun nunannnnnnnnn nnna 35 EARG iVeflddErtele kille VE 35 4 2 Testing Tables nennen ea DEENEN Eed eee eee 35 4 3 Problems Occured nnan na a aa e aaa a a aea d eaaa Ea 38 Aa T LODIT FOUET EE 38 4 3 2 Failed lo View Full EE 38 4 4 System Evaluatio EE 38 5 Conclusion amp Future Development 40 CH CONCUSSION caves sxcthctesseescunevehscubiaeeenawoit anaiena aeea aa ianea aa a AEE 40 D2 Future Developme sesiis bnaan ta a a a a a en D sen 40 REFERENGES deeuegeehtfee gekiert aai aaea ad aonana k aE e ae eA 42 BIBLIOGRAPHY EE 44 APPENDICES ut idiot senei tt verdee beet aaa aaa aare ana kaai ege aaaea anai 45 Tong Jiao Content Management System For Conference Paper Handling iv University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report LIST OF FIGURES Figure 1 the Classic Waterfall Model Il 5 Figure 2 A user interacting with a web application IO 8 Figure 3 The parts of an ASP NET page IO 8 Figure 4 Selelcting a ASP NET Web Application in Visual Studio 2005 9 Figure S Navigation Dia Grain sssaaa a a aa Ea A 15 Figure 6 Login Control Property in VS2005 000 ceecceeeeeeceeeeeeeeeeeeee eee eeeaaeeeeaeeseeeeeseaeeeeaeeeeneeees 17 Figure 7 screen Shot Of HOMEPAGE eee eeeeeteeeeeenneeeeeeeaeeeceeaaeeeeeeaaeeeeeeaaeeeeeeaaeeeseeaa
33. eeeeeeaeeeeneaaes 18 Figure 8 screen shot of Register Page 19 Figure 9 screen shot of Conference Center Page cccccesceceeeeeeeeeeeeeaeeeeneeseneeeseaeeesaeeeeneeees 20 Figure 10 screen shot of Author Center Page cceccceceeeeeeeeeceeeeeeeeeeeeaeeeeaeeseneeeseaeeesaeeeeneeee 22 Figure 11 screen shot of Reviewer Center Page essssseessesssiessrsssrrsirrstnnstnrsennstnnernssrnssrnsnnt 23 Figure 12 screen shot of Conference Website Homepage sssssseessessressrrssrrssrnesrnesrnssrnssns 24 Figure 13 screen shot of Conference Website I Homepage 25 Figure 14 screen shot of Feedback Page asssssssesssrresssrneussnnesrinnnnrnnnestnnnnnnnnnnntannnnnnnnnnnnnnnannannn 25 Figure 15 Summary of steps for database design TE 27 Figure 16 Creating Database in Access 28 Figure 17 User Table acne gi ecaads ceeedarhstecstabbcaedavictecsdnsenedardebeastibbeeeuiiieiesceinet 29 Figure e E 30 Figure 19 Review Table EE 31 Figure 20 Feedback Table sesir ranna an e EEEa A AANE E 31 Figure 21 problem OCCULTE eeeeeceeeeene cece eee eeeeeaaeeeeeeaaeeeeeeaaeeeeeeaaeeeeeeaaeeeeeeaaeeeeeeaaeeeeeeaeeeeneaaes 38 Figure 22 Call for Paper Page 55 Figure 23 Conference Organization Page 55 Figure 24 Call for Paper Page 56 Figure 25 Conference Organization Page II ccscccesceceeeeeeeeeeeeeee eee eeceaeeseaeeseaeeescaeeesaeeeeneeees 56 Tong Jiao Content Management System For Conference Paper Handling V
34. em for Conference Paper Handling 28 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report Field Name Data Type Description AutoNumber The unique identifier for this tablee 8 namee Reg Passworde Texte The user s registered passworde Country Texte Which country the user comes from Organization Texte Which organization the user belongs toe Userrolee Texte The user s role reviewer or author e Titlee Texte The title of the user s articlee Figure 17 User Table As shown in the above Figure 17 the User Table has eight fields including primary key ID registered name registered password country organization email user role and title All the data fields are self explanatory through their names This table is created to collect the basic information associated with the user as mentioned in the Register Page of the CMS Tong Jiao Content Management System for Conference Paper Handling 29 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report Field Name Data Type Description 7 alll EEN The area which the paper belongs to a Se Text The reasons why the paper is recommended Text The comments given to the paper Text The review user who gives the comments to the paper Figure 18 Paper Table In the Figure 18 t
35. ent Management System 2 1 1 Introduction of CMS The phrase Content Management System means different things to different people To fully understand what it is a Content Management System CMS the word content needs to be defined at first Basically content is all the information and functionality that has been organized toward some particular use 1 Hence content management is the effective management of those information and functionality The system itself can be defined as a tool that facilitates the efficient and effective production of the desired output using the managed content To combine all these three definitions the content management system can be defined as a tool for managing content usually on a Web site that separates the design interactivity and content from one another to make it easier for content authors to provide content 2 A CMS is now the preferred choice for those who need easy content changes and simplified control of large amounts of content and above all the ability to do a lot more a lot easier and a lot faster than with any other system 3 2 1 2 Types of CMS In the CMS world there are many different types of products with different styles each Elements of various CMS styles can even be mixed and matched Several main types of CMS are as follows gt Web Content Management Systems WCMS This subset of CMS focuses managing only Web content Products vary in functionality
36. ent Management System for Conference Paper Handling 40 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report gt Keeping track of research paper submissions is useful for the authors being able to follow review the paper is vital for the reviewers as well For this reason a status property can be added to the reviews in the system which reflects what the reviewer has done gt Multi user authoring The CMS will have many simultaneous users Record locking feature is the technique of preventing simultaneous access to data in a database to prevent inconsistent results and to ensure that clashing changes are prevented gt Another aspect of development that has been considered is a hit counter There will be statistics for most read paper over a certain period of time and a latest paper list It would be interesting to know how many people actually viewed the research paper This is interesting for the author to find out how popular his conference paper is It can also be interesting to your visitors as it might give an indication whether the content item is worth reading The next walkthrough shows you how to implement the hit counter Tong Jiao Content Management System for Conference Paper Handling 41 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report REFERENCES 1 Bob Boiko 2005 Content
37. es are allowed in are allowed in red format except pdf or doc red color on the page color on the page as file extension expected 4 Click Reviewer Center Link Go to the Reviewer Center The link works as in this page page expected Logged in as a reviewer The given research files The given research first access to the should be displayed by files are displayed by Reviewer Center page and alphabetical order when alphabetical order or then review the given clicked Title Author Area and uploading time order as research papers by clicking displayed by uploading time expected order when clicked Update Tests showed above are mainly used to test the website functionality that was implemented within the system In additon database testing has been carried out throughout the stages in the development processes and it includes appropriate reviews to examine carefully the outputs of the development activities The aim of database testing is to discover errors in the design and implementation of the database Validation and verification are the two main tasks involved in the database testing process Validation is used to answer the question has the right database been developed to meet the requirements It attempts to confirm that the right database has been constructed with the right characteristics to meet the specified requirements And verification answers the question has the database design been implemented correctl
38. es gathering information about what the customers need and defining the problem that the output is expected to solve Analysis mainly includes understanding the functionalities the product must perform and the results of the analysis are typically captured in a formal requirements specification which serves as an input to the next step gt Design Based on the requirements specification outlined in the preceding step the design step involves defining the hardware and software architecture specifying performance and security parameters choosing programming language and so on The output of this stage is one or more design specifications which are used in the next stage of implementation gt Coding Implementation The developers in this step build the actual application using the predefined design specification This step is normally performed by a development team consisting of programmers interface designers and other specialists The output of this step is one or more product components which are built to satisfy the functionalities required for the system gt Testing Once the application is complete it goes to the testing stage The application is tested to make sure that it meets all the requirements and is error free Once the application has passed the testing process it can be released This is also the stage at which product documentation such as a user manual is prepared reviewed and published gt Maintenance Thi
39. eview the submissions or to recall the review comments for the corresponding conference Conferences 27th Chinese Control Conference CCC 08 e Author Center e Reviewer Center 7th World Congress on Intelligent Control and Automation e Author Center e Reviewer Center Figure 9 screen shot of Conference Center Page 3 4 4 Author Center Page As stated in the Chapter 1 the most important functionality required by the authors is to allow them to upload the research paper via this CMS And this objective is achieved by using the FileUpload control provided in the Visual Studio 2005 because the FileUpload control allows developers to drop the control on a page let it browse a file and upload the file to the server To realize the uploading function the first step is to drop the FileUpload control from Toolbox to the Web page in the VS2005 The following code adds the FileUpLoad control lt asp FileUpload ID FileUpload1 runat server gt In order to support file upload functionality a Button control named Submit in this page needs to be added lt asp Button ID Button1 runat server Font Bold True Text Submit Font Size Medium gt lt td gt As mentioned in the description of Author Center Page conten the specific area of the research paper needs to be specified when the author is going to upload a research file The area of the conference paper is displayed in the form of a drop down list and is sele
40. filepath up_user strtitle strauthor strabstract strkeywords strtitle strarea strfile Session username comm New OleDb OleDbCommand strinsql myConn comm CommandType CommandType Text comm CommandType CommandType Text comm CommandText strinsql comm ExecuteNonQuery myConn Close Savelmages Response Write lt script gt alert upload file Successfull lt script gt End Sub Private Function Savelmages As System Boolean loop through the files uploaded Dim _files As System Web HttpFileCollection System Web HttpContext Current Request Files Message to the user Dim _message As New System Text StringBuilder Files Uploaded lt br gt Dim _iFile As System Int32 Try For _iFile 0 To _files Count 1 Tong Jiao Content Management System for Conference Paper Handling 47 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report Check to make sure the uploaded file is a pdf file Dim _postedFile As System Web HttpPostedFile _files _iFile Dim _fileName _fileExtension As System String _ fileName Session Uusername System lO Path GetFileName _postedFile FileName _fileExtension System lO Path GetExtension _ fileName If _fileExtension pdf Then Save File to the proper directory _postedFile SaveAs System Web HttpCon
41. g 10 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report 2 6 2 SQL The structured query language SQL is a standard interactive and programming language for getting information from a database SQL statements are used to retrieve and update data from a database SQL works well with database programs like Microsoft Access Primary keywords within the SQL such as SELECT UPDATE DELETE INSERT and WHERE are common used query to retrieve and update data from the databse for this CMS 2 6 3 XML Extensible Markup Language XML is a new and very powerful Internet technology It is part of a suite of technologies used for management display and exchange of data XML with specific tags having specific meanings needs to be written to define the Web config file in Visual Studio 2005 for this CMS Tong Jiao Content Management System for Conference Paper Handling 11 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report 3 System Design and Implementation This chapter discusses about the system design and implementation processes in detail Before starts to describe clearly and exactly how the user interface and database is designed the user requirements are defined in the first place After that in the next subchapter it illustrates how each page was produced using the software application men
42. get stored in the database on the server and the corresponding reviewers will have facilities for accessing the paper via Reviewer Center Page which will be explained in the next section What s more a calendar is put here to remind the authors what exact date it is by using a calendar control provided in Visual Studio 2005 The calendar control displays a one month calendar that allows the user to select dates and move to the next and previous months In this page a Calendar control is declared in an aspx file The days are displayed with full names the user may select a day a week or the whole month and the selected day week month is displayed with a grey background color 14 The Figure 10 shown in the below represents Author Center page which is only accessible by a registered author The author can upload research paper by clicking on Browse and then select the file from specified location on his local computer Tong Jiao Content Management System for Conference Paper Handling 21 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report The Conference Paper Management System Author Center Datei Title of the Paper Author Abstract Keywords BERE v Area SqlDataSource SqiDataSource1 Paper File Figure 10 screen shot of Author Center Page 3 4 5 Reviewer Center Page The Reviewer Center Page is only accessible by a registered rev
43. he Paper Table has eleven fields including primary key ID title abstract author keywords area update time update user reasons comments and reviewer user The table shows the type of data stored in each field clearly and it has a record of all the information related to the research paper Tong Jiao Content Management System for Conference Paper Handling 30 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report Description Paper ID number which comes from paper table User ID number which comes from paper table eegnen Figure 19 Review Table In the Review Table shown in the above Figure 19 there are four fields in total including primary key ID paper ID user ID and Add Date The table also shows the data type Field Name Description The actual feedback given related to the website Figure 20 Feedback Table The Feedback Table see Figure 20 is designed to record comments or suggestions from registered users about the CMS in order to improve the service quality In this table there are five fields in total which are primary key ID username email title and content Tong Jiao Content Management System for Conference Paper Handling 31 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report 3 5 2 Connection to Database Connect the we
44. iao Content Management System for Conference Paper Handling 25 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report The above Figure 14 shows feedback page which is for any registered user like authors or reviewers to leave comments or suggestions to improve the system service quality The user needs to fill in his name email address the title of the paper he had uploaded or reviewed as well as the comments giving to the system After user has successfully submitted the information via this page this page reads it and stores into the database And the feedback information will be available to view by the conference organizors 3 5 Database Development Database development begins discussing the physical design of a relational database using Microsoft Access Database Database design starts with a conceptual data model and produces a specification of a logical schema this will usually determine the specific type of database system that is required 15 The approach to develop the database here is to use a relational database environment A relational representation of the conceptual data model is used as input to the design process The output of the design stage is a detailed relational specification the logical schema of all the tables and constraints needed to satisfy the description of the data in the conceptual data model It is during the design activity that
45. ict Lex ty Magie tp www CH org TR xhem 11 foTo xhtmll strict dtd gt lt html gt lt head gt saple pastiri lt script runat server gt script runat server gt Sub Page_Load i Sub Page_Load A messageLabel Text Hello world messageLabel Text d b Erd Sud End su KEE lt script gt Server side lt body gt I A Comment ee easp Label id messageLabel runat server RG SS lt aspiLabe I _ ASP NET lt p gt gt dek Declare the title as _string and set it ber Control Son tie aia TRAE YE GENE ated by a code render Koch x gt lt Dim Title As String This is generated by a code render block gt Ste Title LS Bierg Code Render Blocks Figure 3 The parts of an ASP NET page 9 Tong Jiao Content Management System for Conference Paper Handling 8 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report ASP NET has a few features that really are unique gt ASP NET pages are compiled not interpreted In ASP NET s predecessor ASP pages were interpreted every time a user requested a page the server would read the page s code into memory figure out how to execute the code that is interpret the code and execute it In ASP NET the server need only figure out how to execute the code once The code is compiled into efficient binary files which can be run very quickly again a
46. iewer the reviewers have facilities for accessing research papers uploaded by the authors and giving recommendations such as accept or reject to those papers to the conference organization Moreover the reviewers can upload comments to the papers as well As shown in the following Figure 11 the Reviewer Center page has got a table to display the detailed information related to the research paper uploaded by the user to the reviewers In this table each column represents a field and each row represents a record This table displays comprehensive information about the uploaded research paper Instead of just showing the title area and the full text it also displays information like the date the paper was uploaded and the author that created the research paper When the reviewers click on each of these fields such as Title Author or Keywords the research paper will be displayed by alphabetical order or by the time order The page has also got text boxes that need to be filled in by the reviewers to submit their Opinions about the research paper The text boxes have Reasons for Recommendation and Comments to the Author fields for the reviewers to explain why the paper they are reviewing is accepted or rejected Tong Jiao Content Management System for Conference Paper Handling 22 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report In order to display
47. ing BSc Final Year Project Report The Conference Paper Management System Home Re gister Login Contact Us amp i Login LoginID Welcome E Password Welcome to the Conference Paper Management System The system is used for both conference paper submission and conference paper review Please log in with your Login ID and password for conference paper submission and or review Cl Remember me next time Hot Registered Upcoming Conferences 27th Chinese Control Conference CCC 08 ith World Congress on Intelligent Control and Automation WCICA 08 Figure 7 screen shot of Homepage 3 4 2 Register Page As descripted in the last section the user will be asked to offer basic information in order to register successfully These basic information includes what is his title what user role and organization type does he belong to Some choices are given in the form of a dropdownlist for the users to select So in order to display a list of titles user roles and organization types in the form of a dropdownlist a DropDownList Control is used when developed this page This DropDownList is provided as a server control in ASP NET like many other controls When users click the button a list of items will be displayed Each selectable item ina DropDownList control is defined by a Listltem element A declaration for this DropDownList is shown below and hence on the user s side he can select one of user roles from several items
48. l specification the waterfall model can aid efficient knowledge transfer when team members are dispersed in different locations Hence the CMS involved in this project is developed base on this system development life cycle theory 2 3 Web Application Framework ASP NET ASP NET is the latest version of Microsoft s Active Server Pages technology ASP It is a part of the Microsoft NET framework and a powerful tool for creating dynamic and interactive web pages 8 To run ASP NET a computer capable of running Windows is needed The Internet Information Services IIS from the Add Remove Windows components dialog needs to be installed because ASP NET is a program that runs inside IIS Internet Information Services IIS is a set of Internet based services for servers using Microsoft Windows When a browser requests an ASP NET file IIS passes the request to the ASP NET engine on the server The ASP NET engine reads the file line by line and executes the scripts in the file And finally the ASP NET file is returned to the browser as plain HTML 2 3 1 How does ASP NET work ASP NET is a server side technology which means that it runs on the web server When a web browser requests a web page created with only client side technologies like HTML the web server simply grabs the files that the browser or client requests and sends them down the line The client is entirely responsible for reading the markup in those files and interpreting that
49. markup to display the page on the screen Server side technologies like ASP NET are different Instead of being interpreted by the client server side code is interpreted by the web server In the case of ASP NET the code in the page is read by the server and used to generate HTML that is then sent to the browser Since the processing of the ASP NET code occurs on the server it s called a server side technology As Figure 2 shows the client only sees the HTML The server is entirely responsible for processing the server side code Tong Jiao Content Management System for Conference Paper Handling 7 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report Server side application processes request 1 Request made to server Response sent back to client Figure 2 A user interacting with a web application 9 2 3 2 What is an ASP NET File ASP NET pages are simply text files that have the aspx file name extension and can be placed on any web server equipped with ASP NET An ASP NET page consists of the following elements 10 v directives code declaration blocks code render blocks ASP NET server controls server side comments literal text and HTML tags Figure 3 illustrates the various parts of a simple ASP NET page SS mS Directive e se Fe Page Language VB Ce lt M Page L lt DOCTYPE yy al PUBLIC Aw3c OTO xHTML 1 0 str
50. mdb files Access is a desktop database package that can be used by almost any user with skills ranging from beginner to world expert Creating tables and relationships in Access is quick and relatively easy the beginners can learn to use the wizards whereas experts can push it to its limits and do some extraordinary things with it Against the other desktop databases Access is rich in feature It provides its users with one of the simplest and most flexible database management solutions and allows them to input extract and manipulate the data into all the different forms as they want 12 2 6 Programming Language Technologies Many different types of languages need to be used to develop this CMS These languages have different functionalities and requirements respectively 2 6 1 VB NET As mentioned in the previous subchapter unlike traditional server technologies NET supports many various languages In fact there s no limit to the number of languages that could be supported But in order to keep things simple Visual Basic NET is selected for this system Visual Basic NET VB NET can be viewed as an evolution of Microsoft s Visual Basic VB implemented on the Microsoft NET framework It is an object oriented computer language which means that VB NET generally stays close to the structured legible syntax that has always made it so easy to read use and maintain 13 Tong Jiao Content Management System for Conference Paper Handlin
51. n1 Click Dim strsql As String Dim selectedcodes As String Request checkbox1 Dim selectpaper As String Dim i As Integer Dim str As String Dim myConn As New Data OleDb OleDbConnection myConn ConnectionString Provider Microsoft Jet OLEDB 4 0 Data Source DataDirectory CMS mdb myConn Open Dim comm As Data OleDb OleDbCommand If selectedcodes lt gt Then selectpaper selectedcodes Split For i 0 To selectpaper Length 1 strsql update tab_paper set reviewflag TextBox1 Text comments TextBox2 Text where id selectpaper i ToString DropDownList1 SelectedValue reasons reviewuser Session username comm New Data OleDb OleDbCommand strsql myConn comm CommandType Command Type Text comm CommandType CommandType Text comm CommandText strsq comm ExecuteNonQuery Next End If SqlDataSource1 SelectCommand SELECT FROM tab_paper WHERE Reviewflag wait SqlDataSource1 DataBind End Sub Protected Sub Button2_Click ByVal sender As Object ByVal e As System EventArgs Handles Button2 Click SqlDataSource1 SelectCommand SELECT FROM tab_paper WHERE Reviewflag wait and title like TextBox1 Text or keywords like TextBox1 Text or abstract like TextBox1 Text and author like TextBox2 Text SqlDataSource1 DataBind End Sub Protected Sub GridView1_SelectedIndexChanged ByVal sender As Object ByVal
52. name As String Trim lastname Text Dim strfirstname As String Trim firstname Text Dim stremail As String Trim email Text Dim strcountry As String Trim country Text Dim struserrole As String Trim userrole Text Dim strorganization As String Trim organization Text Dim strpassword As String Trim pas Text Dim strconfirpas As String Trim confirmpas Text Dim strinsql As String If strpassword strconfirpas Then lbname Visible False strsql select reg_name reg_pass From tab_user where reg_name strlastname strfirstname comm2 New OleDb OleDbCommand strsql myConn comm2 CommandType CommandType Text tables comm2 ExecuteReader If tables WasRows True Then lbname Visible True Return Else strinsql insert into tab_user reg_name reg_pass email title country userrole organization values strlastname strfirstname strpassword stremail strtitle strcountry struserrole strorganization comm New OleDb OleDbCommand strinsql myConn comm CommandType CommandType Text Tong Jiao Content Management System for Conference Paper Handling 51 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report comm CommandType CommandType Text comm CommandText strinsq comm ExecuteNonQuery Response Write lt script gt alert Registration Successful
53. nd again without the overhead involved in re reading the page each time This represents a big jump in performance from the old days of ASP gt ASP NET has full access to the functionality of the NET Framework Support for XML Extensible Markup Language web services database interaction email regular expressions and many other technologies are built right into NET which saves you from having to reinvent the wheel gt ASP NET allows you to separate the server side code in your pages from the HTML layout gt ASP NET makes it easy to reuse common User Interface elements in many web forms as it allows us to save those components as independent web user controls 10 2 4 Visual Studio 2005 Visual Studio is the main Integrated Development Environment from Microsoft From its first NET version released in 2002 till now the biggest change in Visual Studio was a single integrated development environment for all NET languages Microsoft removed the NET moniker from Visual Studio 2005 but it still primarily targets the NET Framework which was upgraded to version 2 0 Figure 4 is Selelcting a ASP NET Web Application in Visual Studio 2005 File Edit View Tools Window Community Help D EL 4 General There are no usable controls in this group Drag an item onto this text to add it to the toolbox Templates Visual Studio installed templates GRASP NET Web Ste SP ASP NET Web Service Personal Web Ste Starter Kit Empt
54. nderstanding the pros and cons of the Waterfall Model of software development 0 339028846 339273696 00 htm accessed 12 March 2008 8 W3Schools ASP net tutorial ASP net introduction Internet Available at http www w3schools com aspnet aspnet_intro asp accessed 12 March 2008 9 ASP101 Articles Build YourOwn ASP NET 2 0 Web Site Using C amp VB 2nd Edition Chapter 1 Introducing ASP NET and the NET Platform Internet Available at http www asp101 com articles sample_chapters sitepoint_byoaspnet20 chapter1 asp accessed 12 March 2008 10 ASP101 Articles Build YourOwn ASP NET 2 0 Web Site Using C amp VB 2nd Edition Chapter 2 ASP NET Basics Internet Available at http www asp101 com articles sample_chapters sitepoint_byoaspnet20 chapter2 asp accessed 12 March 2008 11 Peter Abrahams November 2005 Visual Studio 2005 makes accessibility a real possibility Internet Available at http www it analysis com content php articleid 13021 accessed 14 March 2008 12 2000 San Diego State University Introduction to Microsoft Access l Tong Jiao Content Management System for Conference Paper Handling 42 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report Overview and Tables A Workshop for San Diego State University Faculty and Staff 13 SitePoint Pty Ltd 2006 Build YourOwn ASP NET 2 0 Web Site Using C amp VB 2nd Edition Available at
55. nference Click CCC 08 Conference Go to the Homepage of Go to the homepage of Website Link CCC 08 Conference Website CCC 08 as expected which is managed by the CMS 2 Click Call for Paper Link Go to Call for Paper page Access to the page as Click Conference Go to Conference Access to the page as Organization Link Organization page Click Paper Submission Directly take the user back to The login page of CMS 5 Click Contact Us Link Go to Contact Us page Access to the page as TT E fee 1 Login as an author and Go to the Author Center page The link works as then Click Author Center expected Link in the conference center page Logged in as an author An Alert box saying Upload Upload the file Tong Jiao Content Management System for Conference Paper Handling 36 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report access to the Author File Successful pops up and successfully as Center page and then the name as well as the format expected upload a file with either pdf of uploading file is displayed in or doc file extension red color on the page 3 Logged in as an author An Alert box saying Upload Failed to upload the first access to the Author File Unsuccessful pops up file Message says Center page and then and message says Only pdf Only pdf and doc files upload a file with other file and doc fil
56. ng China during June 25 27 2008 The congress aims to provide a broad international forum for world researchers engineers and professionals working in the areas of Intelligent Control and Automation to discuss and exchange their findings ideas and views The Congress will focus on both the theoretic aspects and the applications in the fields of Intelligent Control and Automation Topics of the congress include but are not limited to the following areas Al Intelligent Control Theory and Applications A2 Compute Intelligence B1 System Theory B2 Control Theory Figure 24 Call for Paper Page Il Welcome to The 7th World Congress on Intelligent Control and Automation June 25 27 2008 International Convention Why you should attend the conference Home CallforPaper Conference Organization Paper Submission Conference Organization Technical Sponsors IEEE Robotics and Automation Society IEEE Control System Society Beijing Chapter National Natural Science Foundation Chinese Association of Automation Chinese Association of Artificial Intelligence Conference Co Organizer Chongqing Institute of Technology China Chongqing University of Science and Technology General Chairs Li Zushu Chongqing University China Meng MaxQ H Chinese University Hong Kong China Sun Yue Chongqing University China Figure 25 Conference Organization Page II Tong Jiao Content Management System for Conference Paper Handling 56
57. ng BSc Final Year Project Report 4 System Testing and Evaluation A system test is one which exercises a complete system in much the same way as a user would The purpose of testing is to discover and resolve the errors occurred in the process so as to achieve a functional system This chapter provides findings of a number of tests which were carried out on the system and evaluate the system afterwards 4 1 Testing Methodology Typically software will go through two stages of testing before it is considered to be completely finished The first stage is called Alpha testing In this stage the testers and real customers test the software in development site combinedly The second stage which is called Beta testing generally involves a limited number of external users Therefore the tests involved in this CMS were carried out by using Alpha Testing 4 2 Testing Tables Tesing of this content management system has been conducted throughout system development testing navigational links and connections to the database This CMS has been tested on Windows XP Professional with IIS and the University Server The following table shows a number of test procedures performed on the system ACTION EXPECTED RESULT ACTUAL RESULT K i i EE Click Register Page Link Go to Register Page Directly go to the Register page as expected Register as an Author and A n Alert box saying Directly go to the login then click submit button Registration Succe
58. ny user can access the information related to those conference simply by clicking the links However when it comes to research paper submission the user will be taken back to the login page automatically Once logged in the user will see a Welcome Page which the user will be asked to select an Author Center page or Reviewer Center page for either one of the two conferences managed by this CMS To upload or to review a specific research file can be done in the Author Center page and Reviewer Center page respectively 3 4 System Implementation This section mainly illustrate how the content management system was produced and what exact techniques were used to meet the aims and objectives stated in the previous chapter It discusses about how each of the software applications mentioned in the literature research chapter was utilized in the development process 3 4 1 Login Page As stated in the literature research part at the heart of any ASP NET page lie server controls which represent dynamic elements with which the users can interact The Login control implemented in the login page belongs to one of them It s convenient to create a login page using visual studio 2005 because the inbuilt login tab has been added into the toolbox of VS 2005 editor and it has different types of control related to login function Drag and drop the login control on the page and then the control will look like a login page at design time It comes with t
59. ol Theory and Applications View Full Text 12 Recommendation Accept Reasons for Recommendation Figure 11 screen shot of Reviewer Center Page 3 4 6 Conference Website Homepage The two screen shots Figure 12 and Figure 13 in the below shows the homepage of the two international conference websites managed by this CMS One is the 27 Chinese Control Conference and the other is the 7 World Congress on Intelligent Control and Animation The links of these two conference websites are listed in the system homepage These two websites have the same structure which means both of them have Homepage Call for Paper Conference Organization Paper Submission and Contact Us page The information about these two conferences is clear described in each page Any user has access to this information simply by clicking on the hyperlinks However when it comes to the Tong Jiao Content Management System for Conference Paper Handling 23 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report Paper Submission the users will be taken to the CMS homepage which is the login page at the same time An Email function is put into operation via Contact Us page if the user clicks on this link it will pop up an Outlook Express dialogue box for the user to leave message for the conference organizo
60. ort Appendix H Other Webpages for the 27th Chinese Control Conference website Maese Association Automation Bical Committee on Control CAA A AM A ci The 27th a e Lhintge Control Conference 5 ig University of Science and Technology lt Home Call for Paper Conference Organization Paper Submission Contact Us Call for Papers The Chinese Control Conference CCC is an annual international conference organized by Tech Com on Control Theory CAA It provides a forum for scientists and engineers over the world to present their new theoretical results and techniques in the field of systems and control The conference consists of plenary talks panel discussions oral and poster sessions etc for academic exchanges The conference proceedings have been selected for coverage in ISI proceedings ISTP Index to Scientific and Technical Proceedings since 2005 and included in the IEEE CPP Conference Publications Program since 2006 The 27th CCC is organized by the Kunming University of Science and Technology and will be held in Kunming which is located in the west of China and is known as the Spring City Taking this opportunity we sincerely welcome our colleagues worldwide to join us for this conference Topics of interests are in the broad areas of systems and control including but not limited to S1 System Theory and Control Theory S2 Nonlinear System and Control S3 Complexity and Complex System Theory S4
61. rary This library represents a huge resource of tools and features in the form of classes these classes are organized in a hierarchy of namespaces The data provider is a class that communicates with a specific type of database The System Data Oledb data provider is used in this CMS to connect to the database from ASP NET applications Several steps as follows are used to create the connection to the Access database using the SqlDataSource control In Visual Studio 2005 open a Web site add an ASP NET page Web Form and switch to Design view From the Data group in the Toolbox drag a SqiDataSource control onto the page On the SqiDataSource Tasks shortcut menu click Configure Data Source Then Click New Connection In the Add Connection dialog box click Change in the Change Data Source dialog box click Microsoft Access Database File and then click OK In the Database file name box enter the path D Backup My Documents Visual Studio 2005 WebSites Content Management System CMS App_Data cms mdb to connect the Access database A connection string provides the information that a provider needs to communicate with a particular database The connection string usually supplies the server or location of the database server and the particular database to use The connection string used in this CMS is as follows Tong Jiao Content Management System for Conference Paper Handling 32 University of Hertfordshire School of Electronic
62. rs The other webpages of these two websites are shown in the Appendix H and Appendix e Kr i Nehinese Association Automation 3 4 The 27th Bolinical Committee on Control CAA Oo 7 E SC et R Tar ES VK g Chin se Control Conference mg University of Science and Technology Wis tall for Paper Conference Organization Paper Submission Contact Us Home the Chinese Control Conference CCC is an annual international conference organized by Tech Com on Control Theory CAA It provides a forum for scientists and engineers over the world to present their new theoretical results and techniques in the field of systems and control The conference consists of plenary talks panel discussions oral and poster sessions etc for academic exchanges The conference proceedings have been selected for coverage in ISI proceedings ISTP Index to Scientific and Technical Proceedings since 2005 and included in the IEEE CPP Conference Publications Program since 2006 The 27th CCC is organized by the Kunming University of Science and Technology and will be held in Kunming which is located in the west of China and is known as the Spring City Taking this opportunity we sincerely welcome our colleagues worldwide to join us for this conference Conference Date duly 16 18 2008 thonference Address Kunming Yunnan Chinal Figure 12 screen shot of Conference Website Homepage Tong Jiao Content Management System for Conference Paper Handling
63. s step involves making modifications to the system to improve performance or to meet new users needs These modifications arise either due to change requests initiated by the customer or defects uncovered during live use of the system Typically every change made to the product during the maintenance cycle is recorded and a new product release is performed to enable the customer to gain the benefit of the update 7 The waterfall model as described above describes a development method that is linear and sequential It mainly offers the following advantages First it has distinct goals for each stage of development Development moves from concept through design implementation testing and ends up at operation and maintenance Each phase of development proceeds in strict order without any overlapping The emphasis on requirements and design before writing every single source code ensures minimal wastage of effort and reduces the risk of customer expectations not being met In addition getting the requirements and design out of the way Tong Jiao Content Management System for Conference Paper Handling 6 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report first also improves quality it s much easier to catch and correct possible flaws at the design stage than at the testing stage Finally because the first two steps respectively end up with the production of a forma
64. s uploading research papers and reviewers facilities for accessing papers and uploading comments Its key features are a comfortable management of participants support for any kind of contribution and configurable review forms 1 2 Project Aims and Objectives An aim of a project is a general statement of the goal It tries to summarize the activity which is about to take place in broad terms Once the aims are established it is important to break them down into small and achievable parts which are called objectives The aims and objectives of the project are stated as follows 1 2 1 Project Aims The main aim of this project is to develop a content management system offering the functionality required for the design of paper handling aspects of international conference websites 1 2 2 Project Objectives The main objectives of the project are as follows gt Create a user friendly interface to enable the user to access the system with ease gt Incorporate a login page within the system for security reason gt Allow registered authors to do such operations as uploading research papers assigning papers to reviewers and paper status tracking gt Allow registered reviewers to access the research papers uploaded by the authors and give comments on the papers gt Create a secure database to hold the large amount of information gt Apply programming language to update retrieve and delete the data from the database
65. sions respectively 3 2 4 Author Center Page The Author Center page offers the uploading functionality to the registered authors Within the Author Center page Title of the paper name of the Author Abstract as well as the Keywords need to be offered by the author The specific area of the research paper can be selected from a list of choices 3 2 5 Reviewer Center Page The Reviewer Center page list all the research papers uploaded by the authors to the registered reviewers The title author keywords update time and area related to the research file are shown to the reviewers The users can review the papers by a certain order Reviewers also have facilities to give comments to the authors and then give recommendations to the conference organization about whether the paper is accepted or not Tong Jiao Content Management System for Conference Paper Handling 13 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report 3 2 6 Feedback Page The feedback page is used for any registered user like authors or reviewers to leave comments or suggestions to the organization to improve the system service quality in the future The user needs to fill in his name email address the title of the paper he had uploaded or reviewed as well as the comments give to the system After user has successfully submitted the information via this page this page reads it and stores into the
66. ssful pops page of the CMS as up and the user is taken to the expected login page automatically ee E 1 Enter wrong password at User is not allowed to enter the Error message appear login page system Error message You in red color as login attempt was not expected successful Please try again should appear login page successfully and Welcome as expected Page should appear i Enter correct password at Login to the system Logged in successfully Tong Jiao Content Management System for Conference Paper Handling 35 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report Once logged in to the Log out current user and Logged out and go system click on the Log redirect to the login page back to the login page Out link as expected Click Contact Us Link Go to Contact Us Page Directly go to the Contact Us page as expected Upcoming Conference CCC 08 Website Click CCC 08 Conference Go to the Homepage of Go to the homepage of Website Link CCC 08 Conference Website CCC 08 as expected which is managed by the CMS 2 Click Call for Paper Link Go to Call for Paper page Access to the page as TT ae 3 Click Conference Go to Conference Access to the page as 4 Click Paper Submission Directly take the user back to The login page of CMS 5 Click Contact Us Link Go to Contact Us page Access to the page as OO a eee Upcoming Co
67. t PasswordRecoveryUrl PasswordRequiredErrorMessage Password is required RememberMeSet False RememberMeText Remember me next time SkinID TabIndex 0 act Us p system is used for both ease log in with your Login ID GEZ 4 lt div gt lt table gt lt tr gt lt td gt lt asp login login1 gt Sg Bae TextBoxStyle d TextLayout TextOnTop TitleText Login TitleTextStyle ToolTip UserName UserNameLabelText LoginID UserNameRequiredErrorMessage User Name is required Figure 6 Login Control Property in VS2005 Double click on the control and it will be redirected to Authenticate event of Login control in code behind class file Some code needs to be written for authenticating a user The complete source code will be attached to the Appendix B and some codewill be explained later The screenshot of final homepage is shown below in the Figure 7 If a password or the LoginID is not entered conrrectly the user will not be able to access the system Form validation has been used here For example if an unauthorized user was trying to access to the system leaving all the login textboxes empty it will appear two red asterisks on the right of the textbox to remind the user to enter the correct Login information Tong Jiao Content Management System for Conference Paper Handling 17 University of Hertfordshire School of Electronic Communication and Electrical Engineer
68. t OLEDB 4 0 Data Source DataDirectory CMS mdb myConn Open Dim comm As OleDb OleDbCommand Dim strname As String Trim name Text Dim stremail As String Trim email Text Dim strtitle As String Trim title Text Dim strcontent As String Trim content Text Dim strip As String Request UserHostAddress ToString Dim strinsql As String strinsql insert into tab_ feedback username email title content ip values strname stremail strtitle strcontent strip TI comm New OleDb OleDbCommand strinsql myConn comm CommandType CommandType Text comm CommandType CommandType Text comm CommandText strinsql comm ExecuteNonQuery myConn Close Response Write lt script gt alert Send Successfull lt script gt End Sub End Class Tong Jiao Content Management System for Conference Paper Handling 53 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report Appendix G Web Config File Source Code lt xml version 1 0 gt lt configuration gt lt appSettings gt lt connectionStrings gt lt remove name LocalSqlServer gt lt add name CMSConnStr connectionString Provider Microsoft Jet OLEDB 4 0 Data Source DataDirectory CMS mdb providerName System Data OleDb gt lt connectionStrings gt lt system web gt lt l lt compilation debug true strict false explicit
69. text Current Request MapPath _ files _ fileName _message Append _fileName lt BR gt Elself _fileExtension doc Then Save File to the proper directory _postedFile SaveAs System Web HttpContext Current Request MapPath _ doc _ fileName _message Append _fileName lt BR gt Else _message Append _fileName amp lt font color red gt failed Only pdf and doc files are allowed lt font gt lt BR gt End If Next Label3 Text lt font color red gt __message ToString lt font gt lt BR gt Return True Catch Ex As System Exception Label3 Text lt font color red gt Ex Message lt font gt lt BR gt Return False End Try End Function Protected Sub SqlDataSource1_Selecting ByVal sender As Object ByVal e As System Web UI WebControls SqiDataSourceSelectingEventArgs Handles SqlDataSource1 Selecting End Sub End Class Tong Jiao Content Management System for Conference Paper Handling 48 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report Appendix D Reviewer Center Page VB Code Imports System Data OleDb Imports System Data Partial Class Paper_Review Inherits System Web UI Page Protected Sub Page_Load ByVal sender As Object ByVal e As System EventArgs Handles Me Load End Sub Protected Sub Button1_Click ByVal sender As Object ByVal e As System EventArgs Handles Butto
70. the information related to the research paper in the form of a table as shown in the figure the GridView control provided in the toolbox in Visual Studio 2005 is used The GridView control provides more flexibility in displaying and working with data from the database for example it enables the users to select sort and edit those displayed items just by specifying a couple options in the control To utilize this control the first step is to configure a SqiDataSource control and then bind this control to the DataView control After that in order tosee the text in the cells of the GridView Control the Bound column needs to be set This can be done by using the Smart tag which appears when right clicks on the GridView Control The details about the data binding will be discussed later in the database development section The Conference Paper Management System Reviewer Center Reviewer Submit Author Keywords Up date Area Up user Full Text 2008 1 5 18 53 58 View Full Text 2008 1 5 18 54 00 View Full Text 2008 1 5 18 54 02 View Full Text 2008 1 5 19 20 46 View Full Text CMSVivian 2008 3 9 08 49 45 System Theory View Full Text CMSVivian N 2008 3 9 08 49 54 System Theory View Full Text CMSVivian N 2008 3 9 08 50 18 System Theory View Full Text 2008 3 10 11 25 09 Intelligent Control Theory and Applications View Full Text 2008 3 10 22 40 23 Intelligent Control Theory and Applications View Full Text 2008 3 10 22 49 35 Intelligent Contr
71. tioned in the chapter 2 3 1 Defining User Requirements of this CMS As mentioned in the Waterfall methodology overview the first step in any system development is to define the actual use requirements So this section lists some starting points for the requirements gathering process for this CMS gt Integrated authoring environment The CMS must provide a powerful environment for the authors This ensures that authors have easy access to the full range of features provided by the CMS gt Metadata creation Capturing metadata abstract subject keywords etc is critical when managing a large content repository gt Non technical authoring Authors must not be required to use HTML or other technical knowledge when creating pages gt Ease of use amp efficiency For a CMS to be successful it must be easy to create and maintain content In this case the main users involved in this CMS can be categorized into two groups authors and reviewers And this CMS is designed to offer extensive support throughout all phases of the submission and review process for the International conference papers On the authors side it will allow them to upload research papers and track paper status On the reviewers side it will allow them to access details of research papers that they are interested in and upload comments 3 2 Description of Actual Page Content After defining the user requirements for this CMS what type of content
72. true gt lt assemblies gt lt add assembly System Design Version 2 0 0 0 Culture neutral PublicKeyToken B03F5F7F11D50A3A gt lt assemblies gt lt compilation gt lt pages gt lt namespaces gt lt clear gt lt add namespace System gt lt add namespace System Collections gt lt add namespace System Collections Specialized gt lt add namespace System Configuration gt lt add namespace System Text gt lt add namespace System Text RegularExpressions gt lt add namespace System Web gt lt add namespace System Web Caching gt lt add namespace System Web SessionState gt lt add namespace System Web Security gt lt add namespace System Web Profile gt lt add namespace System Web UI gt lt add namespace System Web UI WebControls gt lt add namespace System Web UI WebControls WebParts gt lt add namespace System Web UI HtmIControls gt lt namespaces gt lt pages gt lt authentication mode Windows gt lt l lt customErrors mode RemoteOnly defaultRedirect GenericErrorPage htm gt lt error statusCode 403 redirect NoAccess htm gt lt error statusCode 404 redirect FileNotFound htm gt lt customErrors gt a lt system web gt lt configuration gt Tong Jiao Content Management System for Conference Paper Handling 54 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Rep
73. uld register a Login ID username to submit or review a paper proposal Please fill in the following fields carefully to get your username Title Dr Le Last name i P A User Name already exists First Name e kb KEE Country SqlDataSource SqlDataSource1 Email Address e User Role Doctor Di Organization Type Academic v Password Confirm Password Figure 8 screen shot of Register Page 3 4 3 Welcome Page When the user logs in successfully he is taken to the Welcome Page Users logged in as authors or logged in as reviewers are given Author and Reviewer permissions respectively The Figure 9 is the screen shot of Welcome Page It has got hyperlinks to the Author Center or Reviewer Center A logout function is incorporated in this page which is used to log the user out of the system This function increases the system protection and enhances security against the unauthorized users Tong Jiao Content Management System for Conference Paper Handling 19 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report The Conference Paper Management System Welcome Welcome to the Conference Paper Management System This is the Conference Center which shows the upcoming conferences managed by this system e Click on Author Center to submit a new paper proposal or to view the submission status for the corresponding conference Click on Reviewer Center to r
74. understanding about content management system and then introduces a project management technique the waterfall model a powerful web technology ASP NET a programming language Visual Basic NET as well as the main integrated development environment Visual Studio 2005 used to develop this system in detail Chapter 3 illustrates the system design and implementation processes thoroughly with explanations of necessary terminology This chapter is the most important part within the whole report It describes clearly and exactly how the user interface and database is designed and how the design becomes real afterwards Chapter 4 is about testing carried out on the developed project to evaluate its compliance with specific requirements Testing methodology with related testing results are explained in this chapter And at last the report ends with Chapter 5 which makes the conclusion and future developments Tong Jiao Content Management System for Conference Paper Handling 3 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report 2 Literature Research An investigation was carried out to have a general idear about what is CMS After that a project management technique a powerful web technology as well as the main integrated development environment used to develop this content management system are introduced here one by one in detail 2 1 Understanding Cont
75. versity of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report gt Inthe Task Pane shown in the Figure 16 choose Create a new file item gt Select Blank Database from the Task Pane gt Type the name CMS for the database and select a place to save the file gt Click on Create Then the Database window appears This window shows tabs for several types of database objects These objects are all saved together under CMS as one database with the mdb file extension FJ Microsoft Access iol x Ele Dit Wew mert Iek Window Hep ype a question For help he ae ee ERTS EEST Getting Started zs jim access Database Access 2000 file format eg Steg Microsoft Office Online ig open Kon Enen X a oe SE Connect to Mirasot offica 5 SES nine Create table in Design view Se Tables Tab Gat the latest naws about using STETDE b Access Queries Tab Astomadcaly update this Ist From the wed More Search Fees Example Print move than ane copy Open access mdb Training Oakabese2 mdb access mob Leeming Curriculum Database 2000 mcb ES rore _ Greate anew file Ready NUM E Figure 16 Creating Database in Access Four main tables designed for this particular content management system are shown as below that is User Table Paper Table Review Table and Feedback Table Tong Jiao Content Management Syst
76. wo labels two textboxes one for entering LoginID and the other for entering the password along with a submit button UserNameLableText PasswordLabelText and LoginButtonText are there to change the username password and login button labels respectively In addition RememberMe property is configured to display a checkbox giving the user the option to store a persistent cookie on the users machine See Figure 6 below Note that ASP NET introduced a new development approach that allows code developers to work separately from the presentation designers who lay out individual pages It means the functional code which is VB NET code in this project is separated from presentation code Tong Jiao Content Management System for Conference Paper Handling 16 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report HTML code The visual elements are created in an aspx file At the same time the VB NET code is displayed in a separate class file called the code behind class file aspx vb Default aspx Default aspx vb _uploadfile aspx vb Login1 System Web UI WebControls Login S 7 HelpPageUrl HyperLinkStyle InstructionText InstructionTextStyle LabelStyle LoginButtonImageUrl a LoginButtonStyle LoginButtonText submit LoginButtonType Button MembershipProvider Orientation Vertical PasswordLabelText Password PasswordRecoveryIconUrl PasswordRecoveryTex
77. y Verification ensures that the processing steps have been correctly implemented and contain no errors in program logic or execution sequences 20 Tong Jiao Content Management System for Conference Paper Handling 37 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report 4 3 Problems Occurred 4 3 1 Login Problem Login problem occurred as the user interface failed to connect to the database It was found that the there was something wrong with database connection code and caused the ASP NET pages not connecting to the database correctly After the code was revised the login problem was resolved 4 3 2 Failed to View Full Text Reviewers should be able to view full text of research files uploaded by the authors simply by clicking the View Full Text link in the Reviewer Center Page However an error message appeared as shown in the Figure 21 and failed to view the full text Maybe this problem happened mainly because that by default IIS only serves static content like HTML so IIS disables dynamic content ASP NET page in this project for security reasons Not Found Microsoft Internet Explorer lt 2 v http flocalhost 2433 files UITSAModuleHandbook doc File Edit view Favorites Tools Help w dr Not Found Server Error in CMS Application HTTP Error 404 Not Found Version Information ASP NET Development Server 8 0 0 0 Figure
78. y Web Ste F ASP NET Crystal Reports Web Site My Templates El Search Online Templates EJ Solution Explorer i Server Explorer A blank ASP NET Web site File System Visual Basic gt Figure 4 Selelcting a ASP NET Web Application in Visual Studio 2005 Tong Jiao Content Management System for Conference Paper Handling 9 University of Hertfordshire School of Electronic Communication and Electrical Engineering BSc Final Year Project Report With regard to more technical aspect there follows a brief description of the major enhancements that have been made to ASP NET 11 gt Every ASP NET control that displays an image includes a method for supplying alternate text including the ability to set the text to null and add a long description when required gt Forms can include labels on input fields checkboxes and radio buttons as well as creating sets of fields defining tab orders and access keys gt A skip navigation function can be incorporated into a page gt Tables of data can be set up with the correct headings Complex nested tables can also be defined gt Valid transitional or strict XHTML will be automatically generated gt Tables are not needed for layout 2 5 Microsoft Access Database Microsoft Access is a very powerful relational database management system Its easy to understand interface is familiar to many users and many small offices have resources already stored in Access

Content Management System For Conference Paper Handling

Contents

Download Pdf Manuals

Related Search

Related Contents