CSE SOLUTION SITE Only For National University

Final Year Or Full Software Idea

Event Quality Management System( A case study of Trade fair).

A Project (CSE-499) is submitted for the partial fulfillment of the requirements of B.Sc.(Hons) in Computer Science & Engineering (CSE), National University, Bangladesh.

Letter of Transmittal

08 Jun 2016.

Md. Moklesur Rahman,


Department of Computer Science and Engineering (CSE)

Tejgaon College, Dhaka.

Subject: Submission the Project Report on “Event Management System ( A case study of Trade fair) ”.

Dear Sir,

It gave me an immense pleasure in presenting the project report, which assigned to me as fulfillment of my CSE degree requirement. In this paper, I have tried my level best to carry out all the requirements of a research project.

In preparing this report, I had to gather information about the subject from Google, Wikipedia, blogs, text book, different article and different web sites. I have also conduct a survey to find out the problems and solution of the problems.

I consider myself very privileged to prepare this research paper under your guidance. This has been an enormous opportunity for me to learn how to conduct a project program. It has provided me with a great scope of learning ICT of modern invention of the world. I must mention here that I am extremely thankful to you for your valuable guidance, tiresome effort and constant attention whenever required.

Sincerely yours,

Sub Raz Suttra Dhar.
NU Roll: 0190344
Registration: 1000393
Session: 2009-2010
Computer Science and Engineering(CSE)
Tejgaon College, Dhaka

Student Declaration

I am Sub RazSuttra Dhar, student of Computer Science and Engineering (CSE) program from the Tejgaon College, Dhaka do here by declare that the project report on “Event Management System ( A case study of Trade fair)” has not been submitted by me before for any degree, diploma, title or recognition.

I hereby warrant that the work I have presented do not breach any existing copyright acts.

Sub RazSuttraDhar

NU Roll: 0190344

Registration: 1000393.

Department of Computer Science and Engineering (CSE)

Session: 2009-2010.

Group Members

Saddam Hossain

NU Roll: 0110338

Registration: 1001284

Department of Computer Science and Engineering(CSE)

Tejgaon College, Dhaka

Group Members

Liaquate Hossain

NU Roll: 0110337

Registration: 1001283

Department of Computer Science and Engineering(CSE)

Tejgaon College, Dhaka

Supervisor’s Certificate

This is to certify that Sub Raz Suttra Dhar, a student of Tejgaon College, Dhaka as under National University bearing Roll No : 0190344, Registration No: 100393, Session: 2009-2010 ExamminationYear – 2014. He has completed successfully his Project Report on “Event Management System ( A case study of Trade fair) ” Under my close supervision. He was found very active, sincere and devoted to his work during the preparation of his Project report.

I wish him every success and prosperity in all his efforts.

Faculty Guide,


Md. MoklesurRahman


Department of computer Science and Engineering (CSE).

Tejgaon College, Dhaka.


Firstly, I would like to express our gratitude to almighty God for enabling us strength and opportunity to complete this report within the schedule time successfully.

I am very much grateful to my honorable supervisor Md Moklesur Rahman for assigning me to prepare this report, which enriches my academic as well as practical knowledge and aptitude. I have got the opportunity to submit this Project report on “Event Management System ( A case study of Trade fair)”.

I must take the opportunity to thank to my honorable Chairman, Professor Md. Abdul Hadi Dep- artment of Computer Science and Engineering, Tejgaon College, Dhaka for helping &giving me much information to prepare this project report.

I also express special gratitude to all the teacher & my friends whom I have got sufficient help and co-operation for preparing the report.

I have tried to fulfill my responsibility as much as possible to make this report attractive but some errors may occur without my intension. So I am requesting to pardon me and accept my report as the precious fruit my hard work.

Thanks from,

Sub RazSuttraDhar

NU Roll: 0190344

Registration: 1000393.

Department of Computer Science and Engineering (CSE)

Session: 2009-2010.


Today’s city people are attending in various events, seminar, etc in every month. Some big events like Dhaka International Trade Fair, Digital World, ICT Fair, IEEE Conference are being arranged around the year. Visitors are gathering there for their fulfillment of desire. They visit there to buy, visit or promote their own products. Companies or Organizations open their stalls on the events. Stalls give their offers or services to the visitors and customers. But in common the visitors who planned to join the event but have no idea about the present conditions of the event. Companies can’t know the offers and visitors on other companies stalls. So to make everything centralized we are planned to develop a centralized system named Event Management System( A case study of trade fair). which will keep everything I one place.

Chapter #1 : Introduction

Topic No Topic Name Page
1.1 Introduction 02
1.2 Fundamentals Of Microsoft Visual Studio 2010 02
1.3 System Requirements for installing Visual Studio 2010 04
1.4 Fundamentals Of Microsoft Visual C# Language 04
1.5 Title Of The Project 05
1.6 Objective Of Event management System (A Case Study Of Trade Fair) 06
1.7 Special Requirements 06
1.8 Scope 06
1.9 Project Category 07

Chapter #2 : Project Planning

Topic No Topic Name Page
2.1 Proces Description 09
2.2 Data Flow Diagram 09
2.3 ER Diagram 012

Chapter #3 : System Analysis

Topic No Topic Name Page
3.1 Proces Model 16
3.2.1 Water Fall Model 16
3.2.2 Water Fall Model Application 17
3.2.3 Advantage Of water Fall Model 17
3.2.4 Disadvantage Of water Fall Model 17
3.2.5 Reasons for use 18

Chapter #4 : System Design

Topic No Topic Name Page
4.1 Introduction 20
4.2 Overview 20
4.3 Scope 20
4.4 Back Ground 21
4.5 Applicable Document - Methodology 21
4.6 Risks 22
4.7 External 23
4.8 Destinations Of Programs 23
4.9 Context Flow Diagram 23
4.10 Data Flow Diagram 24
4.11 Data Flow Diagram Notation 25
4.12 Context Flow Diagram use of Admin 26
4.13 Work Flow Diagram 32
4.14 UML Diagrams 33
4.15 Types of UML Diagrams 33
4.16 ER Diagram 34
4.16.1 System Database Diagram 34
4.16.2 System ER Diagram 35
4.17 CSS Basic Concept 36
4.18 HTML Basic Conceptt 36
4.19 javaScript Concept 36

Chapter #5 : Implementation

Topic No Topic Name Page
5.1 Modules 39
5.2 Front End Technology 39
5.3 ASP.NET 39
5.4 ASP.NET MVC 39
5.5 Back End Technology 40
5.6 About Microsoft SQL Server 2012 40
5.7 Database 41
5.8 Maintenance And Environment 42
5.9 Output Screen 44
5.10 Source Code 53

Chapter #6 : Conclusion ANd Discussion

Topic No Topic Name Page
6.1 Discussion 61
6.2 Future Plan 61
6.3 Conclusion 61

Chapter #1 : Introduction

1.1: Introduction

1.1: Introduction

This project report will introduce how to build part of a c Event Quality Assurance and Development Management System using ASP.NET. ASP support three development model Web page, Web Form, MVC. MVC is a framework for building web applications using a MVC (Model View Controller) design:

  • The Model represents the application core (for instance a list of database records).
  • The View displays the data (the database records).
  • The Controller handles the input (to the database records).

The MVC model also provides full control over HTML, CSS, and JavaScript. This project provide us the information about student registration, teachers record, a department, all the course information, room allocation information, class schedule information & students result information. The system must provide the flexibility of generating the required documents on screen as well as on printer as and when required we can take it by pdf.


1. Easy to check the Event Information.

2. We can update any information in future.

To develop this project Microsoft Visual studio Ultimate 2013 and SQL management studio has been used.

1.2: Fundamental of Microsoft Visual Studio Ultimate 2013

Microsoft Visual Studio is integrated development environment (IDE) from Microsoft. It is used to develop computer programs for Microsoft Windows, as well as web sites, web applications and web services. Visual Studio uses Microsoft software development platforms such as Windows API, Windows Forms, Windows Presentation Foundation, Store and Microsoft Silver light. It can produce both native code and code. Visual Studio includes a code editor supporting IntelliSense (the code completion component) as well as code refactoring. The integrated debugger works both as a source-level debugger and a machine-level debugger.

Visual Studio is a tool-rich programming environment containing the functionality that you need to create large or small C# projects. You can even construct projects that seamlessly combine modules written by using different programming languages such as C++, Visual Basic, and F#. If you are using Visual Studio 2010 Express then it starts like this:

If you are using Visual C# then the following tasks to create a new Windows Form Application:

  • On the File menu, click New Project.
  • In the New Project dialog box, in the middle pane click the Windows Form Application icon.
  • In the Name field, type Event Quality Assurance and Development Management System.
  • Click OK.
  • Visual C# saves solutions to the C:\Users\Mabia\Documents\Visual Studio ultimate 2013\Projects\ Event Quality Assurance and Development Management System MvcApp folder by default. You can specify an alternative location when you save the solution.
  • On the File menu, click Save

1.3: System Requirements for Installing Visual Studio ultimate 2013

When upgrading from Microsoft Visual Studio 2012 to Visual Studio 2013 you will take advantage of a refreshed and simplified environment with enhanced performance without any additional hardware requirements. Some of these core enhancements make use of capabilities that are only present in the latest versions of Windows and might require you to upgrade to a supported operating system.

Hardware Requirements

  • 1.6 GHz or faster processor.
  • 1 GB of RAM (1.5 GB if running on a virtual machine)
  • 10 GB (NTFS) of available hard disk space.
  • 5400 RPM hard drive.
  • DirectX 9-capable video card running at 1024 x 768 or higher display resolution.

Supported Operating System

  • Windows 8.1 (x86 and x64)
  • Windows 8 (x86 and x64)
  • Windows 7 (x86 and x64)
  • Windows Server 2008 R2 SP1 (x64)
  • Windows Server 2012 (x64)

Supported Architectures

  • 32-bit (x86)
  • 64-bit (x64)

1.4: Fundamental of Microsoft Visual C# Language

  • C# Language Basics: New C# programmers are sometimes intimidated by the quirky syntax of the language, which includes special characters such as semicolons (;), curly braces {}, and backward slashes (\).Fortunately, once you get accustomed to C#, these details will quickly melt into the back-ground. In the following sections, you’ll learn about four general principles you need to know about C# before you learn any other concepts.

Case Sensitivity: Some languages are case-sensitive, while others are not. Java, C, C++, and C# are all examples of case-sensitive languages. VB is not. This difference can frustrate former VB programmers who don’t realize that keywords, variables, and functions must be entered with the proper case. For example, if you try to create a conditional statement in C# by entering If instead of if, your code will not be recognized, and the compiler will flag it with an error when you try to build your application.

Commenting: Comments are descriptive text that is ignored by the compiler. C# provides two basic types of comments. The first type is the single-line comment. In this case, the comment starts with two forward slashes and continues for the entire current line. Optionally, C# programmers can also use multiple-line comments using the /* and */ comment brackets. This trick is often used to quickly comment out an entire block of code.

Statement Termination: C# uses a semicolon (;) as a statement-termination character. Every statement in C# code must end with this semicolon, except when you’re defining a block structure such as a method, a conditional statement, or a looping construct. By omitting this semicolon, you can easily split a statement of code over multiple physical lines. You just need to remember to put the semicolon at the end of the last line, to end the statement.

Blocks: The C#, Java, and C languages all rely heavily on curly braces—parentheses with a little more attitude: {}. You can find the curly braces to the right of most keyboards (next to the P key); they share a key with the square brackets .

1.5 Title of The Project

“Event Management System ( A case study of Trade fair)” with reference to Tejgaon College , Dhaka.

1.6 Objective of Event Quality Assurance & Development Management System

  • To develop a web-based application to find the information about past, present and upcoming events.
  • To develop the quality and ensure management of the events.
  • To concern the users about the events & take surveys from the system.
  • All the users will sign up in this application from online and onsite.
  • Every company who will take stalls or pavilion on the event will sign up in this application.
  • User will be able to access the site with provided username and password.
  • Stalls holders can access the site using their own authentication. Companies will be able to take survey and decision on how to develop their qualities and services.
1.7 Special Requirements :

  • HTML
  • SQL
  • CSS 3
  • Java Script
  • JQuery (JavaScript library)
  • Bootstrap

  • 1.8 Scope:

    This project is aimed at how the event can improve the efficiency of the services. Information of Event is one of the applications to improve the information of any particular events. This application involves almost all the features of the information system, the feature implementation will be online help for the users, visitors, companies who are attending an event to obtain information.

    1.9 Project Category

    RDMMS (Relational Database Management System):

    Relational Database Management System is a type of Database Management System that Stores data in the form of related tables. Relational database are powerful because they require few assumptions about how data is related or how it will be extracted from the database. An important feature of relational system is that a single database can be across several tables.


    Chapter #2 : Project Planning

    2.1 Process Description:

    User Control: Manager login the application for control API with database.

    Company Signup: Companies will sign up hereto be enlisted with their stalls here

    User Signup: Users outside of the events or who are going to visit the events is to sign up through a entry process.

    Offers: Stalls of various companies will sign up here. They will post their daily offers for the users and visitors for promoting their services and products.

    Search Edit and delete: Search and Edit option for query update.

    2.2 Data Flow Diagram:

    A data Flow Diagram is a graphical representation of the “flow” of data through an http://en.wikipedia .org/wiki/information system Information System. A data flow diagram can also be used for the visualization of Data Processing it is common practice for a designer to draw a context- level DFD first which shows the interaction between the system and outside entities. This context – level DFD is then “exploded” to show more detail of the system begin modeled. A DFD represent flow of data through a system. Data Flow Diagram are commonly used during problem analysis. It views a system as a function that transforms the input into desired output. A DFD shows movement of data through the different transformations or process in the system.

    Data Flow Diagrams can be used to provide the end user with a physical idea of where the data they input ultimately has an effect upon the structure of the whole determined through a Data Flow Diagram. The appropriate register saved in database and maintained by appropriate authorities.

    Fig 2.1: Data Flow Diagram Notation

    Fig 2.1: Data Flow Diagram Level 0, 1

    Administrator: Administrator assigns the company’s stalls, user and visitors information record. It also collects information from the database.

    Company Information: In company information the information of any company is recorded, which can be edited only by authorized company and can be used to view for any particular information.

    User Details: In the user details the details of any user information is recorded. Which can be edited and delete only by authorized user and can be used to view for any particular details.

    Stalls Offer: They will post their daily offers for the users and visitors for promoting their services and products.

    ER Diagram: Entity Relationship Diagrams (REDs) illustrate the logical structure of database. An entity Relationship Diagram is a piece of data an object or concept about which data is stored..

    Fig: 2.3 ER Diagram Notations.

    There are three types of relationship between entities:

    • One – to - One (1 to 1): One instance of an entity ( A ) is associated with one other instance of another entity (B). For example , in a database of employees, each employee name (A) is associated with only one social security number(B).
    • One – to – many ( 1 to N): One instance of an entity (A) is associated with zero, one or many instance of another entity (B), but for one instance of entity B there is only one instance of entity A. For example, for a company with all employees working in one building name (A) is associated with many different employees (B) , but those employees all share the same singular associated with entity A.
    • Many – to- many (N to N): One instance of an entity (A ) is associated with one, zero or many instance of another entity (B), and one instance of entity B is associated with one, zero or many instances of entity A. For example, for a company is which all of its employees work on multiple projects, each instance of an employee ( A) is associated with many instance of project (B), and at the same time, each instance of a project (B) has multiple employees (A) associated with it.

    Chapter #3 : System Analysis


    The ultimate objectives of software engineering is to produce good quality maintainable software within reasonable time frame and at affordable cost. This is achievable only if we have matured processes to produce it. For a mature process, it should be possible to determine in advance how much time, cost and effort will be required to produce the final product. This can only be done using data from past experience, which requires that we must measure the software process.

    A key component of any software development process is the life cycle model on which the process is based. Life cycle of the software starts from concept exploration and ends at the retirement of the software.

    The system life cycle is the period of time that starts when a software product is conceived and ends when the product is no longer available for use. The software life cycle typically includes a requirement phase, design phase, implementation phase, test phase, installation and check out phase, operation and maintenance phase, and sometimes retirement phase.

    This system is developed mainly following WATERFALL MODEL


    It suggests a systematic, sequential approach to software development that begins at the system level and progress through analysis, design, coding, testing and support. Figure: 3.1. Waterfall Model.

    The sequential phases in Waterfall model are:

    Requirement Gathering and analysis: All possible requirements of the system to be developed are captured in this phase and documented in a requirement specification doc.

    • System Design: The requirement specifications from first phase are studied in this phase and system design is prepared. System Design helps in specifying hardware and system requirements and also helps in defining overall system architecture.

    • Implementation: With inputs from system design, the system is first developed in small programs called units, which are integrated in the next phase. Each unit is developed and tested for its functionality which is referred to as Unit Testing.

    • Integration and Testing: All the units developed in the implementation phase are integrated into a system after testing of each unit. Post integration the entire system is tested for any faults and failures.

    • Deployment of system: Once the functional and non-functional testing is done, the product is deployed in the customer environment or released into the market.

    • Maintenance: There are some issues which come up in the client environment. To fix those issues patches are released. Also to enhance the product some better versions are released. Maintenance is done to deliver these changes in the customer environment.

    All these phases are cascaded to each other in which progress is seen as flowing steadily downwards (like a waterfall) through the phases. The next phase is started only after the defined set of goals are achieved for previous phase and it is signed off, so the name "Waterfall Model". In this model phases do not overlap.

    3.2.2 Waterfall Model Application

    Every software developed is different and requires a suitable SDLC approach to be followed based on the internal and external factors. Some situations where the use of Waterfall model is most appropriate are:

    • Requirements are very well documented, clear and fixed
    • Product definition is stable.
    • Technology is understood and is not dynamic.
    • There are no ambiguous requirements.
    • Ample resources with required expertise are available to support the product.
    • The project is short.

    3.2.3 Advantage of Waterfall Model

    The advantage of waterfall development is that it allows for departmentalization and control. A schedule can be set with deadlines for each stage of development and a product can proceed through the development process model phases one by one. Development moves from concept, through design, implementation, testing, installation, troubleshooting, and ends up at operation and maintenance. Each phase of development proceeds in strict order.

    3.2.4 Disadvantages of Waterfall Model

    The disadvantage of waterfall development is that it does not allow for much reflection or revision. Once an application is in the testing stage, it is very difficult to go back and change something that was not well-documented or thought upon in the concept stage.


    3.2.5. REASONS FOR USE

    • This model can be used when the requirements of the complete system are clearly defined and understood.
    • Major requirements must be defined; however, some details can evolve with time.
    • There is a need to get a product to the market early.
    • A new technology is being used
    • Resources with needed skill set are not available
    • There are some high risk features and goals.

    Chapter #4 : System Design

         4.1 Introduction:
    The purpose of System Design is to create a technical solution that satisfies the functional requirements for the system. During analysis, the focus is on what needs to be done intendment of how it is done. During design, decisions are made about how the problem will be solved, first at a high level, then at increasingly detailed levels.
    System design is  the  first  stage  in  which  the  basic    approach   to  solving  the  problem is selected. During system designing the overall structure and style are decided. The system architecture is the overall organization of the system into components called system. System design deals with transforming the customer requirements, as described in  the SRS document, into a form that is implement able using  the  programming language. Certain items such as modules, relationships among indentified modules, data should designed during this phase.
    4.2 Overview:
    This System Design provides the overall design of the “Event Quality Assurance & Development Management System” implemented during this project, covering the purpose and reasoning behind the system’s major components. 
    4.3 Scope:
    The main scope of the system design is:
    	Organize the system into module .
    	Organization sub-modules for each module.
    	Allocates tasks to process.
    	Choose an approach to manage data store.
    	Handle access to global resource.
    	Choose implementation logic. 
    The basic idea behind System Design is to develop a software system incrementally, allowing the developer to take advantage of what was begin learned during the development of earlier, incremental, deliverable versions of the system
          4.4 Back Ground:
    The “Event Management System( A case study of trade fair)” records basic customer information, Company order information, Visitor information, user information. 
    •	Maker management function involves:
    •	Manage company records
    •	Visitors information
    •	User information
    •	Stall information
    In “Event Quality Assurance & Development Management System” administrator has a Login ID and Password.
    Admin has complete access to the whole system.
    4.5 Applicable document-Methodology:
    This web application is developed for managing Company details , user details , visitors details, employee details and stall details. As the project is user friendly, it can be applied to large database with more information. This software can use by any sanitary administrator to make their work simple. They can get information quickly as possible. It can handle large volume of data and present reports whenever required. 
    Structure of software package
    The main functional components are:
    •	Administrator/Operator login
    •	Company details
    •	Stalls details 
    •	User details
    •	Visitor details
    •	Log Out
          4.6 Risk:
    The risk factors are: 
    1. In case the database lost because of some OS failure or because of Antivirus actions the software should have option for restore data.
    2. The restore is possible only if the backup maintained by the company and user/visitors is up to date .
    3. Otherwise the restore may failure or the restore point may not be up to date.
    Update Requirement Compliance Matrix:
    Since we are using ASP.NET 3.5 version SQL server 2012 version, if there is any update , upgrade  Apache IIS ( Integrated Information/Internet service) to update ASP.NET and SQL.
    System Description:
    The software is decomposed into several modules for the convenience of the user. The operator enters the company details, Visitors/user details , stalls details. In this all information are already stored details and account details. In this all information are already stored in access. Here we can insert, update or delete the existing records. 
          4.7 External Interface:
    A. Name of application
    “Event Management System( A case study of Trade fair)”
    B. Details of interface
     Admin login
    4.8 Description of program:
    Context Flow Diagram.
    Data Flow Diagram.
    4.9 Context Flow Diagram (CFD):
    A context Flow Diagram is a top level (also known as level 0) data flow data diagram. It only contains one process node (process 0) that generalizes the function of the entire system in relationship to external entities. In context diagram the entire system is treated as a single process and all its inputs outputs, sinks and source are indentified and shown. 
    The Notation used in flow diagram are:
    •	Bubble: The Bubble represents a process or transmutation that is applied to the data which changes in some way. Each bubble is assigned a number.
    •	Box: The Box is called an entity which represents a product or a customer of the information.
    •	Arrow: The arrow represents the data flow. All arrows in the data flow diagram are labeled. The arrowhead indicates the direction of data flow.
    •	Parallel: Represents a repository of data that is to be stored for use by one or more process.

    Fig: 4.1 Context Flow Diagram.

          4.10 Data Flow Diagram (DFD):
    A Data Flow Diagram (DFD) is a graphical representation of the “Flow” of data through an http://en.wikipedia.org/wiki/information system Information system. A through flow diagram can also be used for the visualization of Data processing. It is common practice for a designer to draw a context-level DFD first which shows the interaction between the system and outside entities. This context-level DFD is then “exploded” to show more detail of the system being modeled.
    A DFD represents  flow of  data  through a  system. Data f low  diagram  are  commonly  use during problem analysis. It views a system as a function that transforms the input into desired output. A DFD shows movement of data through the different transformations or processes in the system.
    Data flow diagrams can be used to provide the end  user with  a physical  idea of where  the data they input ultimately has an effect upon the structure of the whole system from order to dispatch to restock how any system  is  developed can be  determined  through  a  data flow diagram. The appropriate register saved n database and maintained by appropriate authorities.

    Fig: 4.2 Data Flow Diagram Notation .

    Fig: 4.3 Context Flow Diagram use for admin .

    Top level 0 :

    Fig: 4.4 Context Flow Diagram Level 0-

    L 01: Logic Design

    Fig: 4.5 Context Flow Diagram Level 01.


    L2 Logical design:

    Fig: 4.6 Context flow diagram Level 02.


    Fig4.7: L3 Context Flow diagram Level 03


    Fig4.7: L4 Context Flow diagram Level 04

    Fig 4.9 : Context Flow Diagram Web server.

    4.13 : Work Flow Diagram

    Fig 4.10: Work Flow Diagram

          4.14. UML DIAGRAMS
    Design is the place where quality is fostered in software development. Design is the only way that we can accurately translate a user’s requirements into a finished software product or system. Software design serves as the foundation for all software engineers and software engineers and software maintenance steps that follow. Without changes are made, one that may be difficult to test, and one whose quantity cannot be assessed until late in the software engineering process. 
    Taking software requirements specification document of analysis phase as input to the design phase we have drawn Unified Modeling Language (UML) diagrams. UML depends on the Visual modeling of the system. Visual modeling is the process of taking the information from the model and displaying it graphically using some sort of standards setoff graphical elements. 
    UML Diagrams are drawn using the Visual Paradigm Software. We seem to be able to understand complexity better when it is displayed to us visually as opposed to written textually. By producing visual models of a system, we can show how system works on several levels. We can model the interactions between the users and the system. 
    Each UML diagram is designed to let developers and customers view a software system from a different perspective and in varying degrees of abstraction. UML Diagram commonly created in visual modeling tools include; 
          4.16 . E-R DIAGRAM 
    An entity-relationship diagram (ERD) is a graphical representation of an information system that shows the relationship between people, objects, places, concepts or events within that system. An ERD is a data modeling technique that can help define business processes and can be used as the foundation for a relational database.

    4.16.2 System E-R Diagram

    Fig: 4.11: E-R diagram.

          4.17: CSS Basic Concept:
    	 CSS stands for Cascading Style Sheets
    	CSS describes how HTML elements are to be displayed on screen, paper, or in other media
    	CSS saves a lot of work. It can control the layout of multiple web pages all at once
    	External style sheets are stored in CSS files.
    	CSS is used to define styles for your web pages, including the design, layout and variations in display for different devices and screen sizes. 
          4.18: HTML Basic:
     HTML is a markup language for describing web documents (web pages).
    	HTML stands for Hyper Text Markup Language
    	A markup language is a set of markup tags
    	HTML documents are described by HTML tags
    	Each HTML tag describes different document content
    4.19:  Java Script Concept:
    JavaScript is a very flexible language. In contrast with Java, PHP, C++ and many other languages, there are many ways to implement OOP in JavaScript.
    The three main features should be supported:
    It is possible to create a child object Tree Menu which extends functionality of the Menu.
    The child object automatically gains access to parent’s methods/properties, but it also can have own methods/properties
    That’s great, because allows to reuse generic Menu code for Tree Menu, Sliding Menu and other specific menu types.
    An object can forbid external access to chosen properties and methods, so that they can only be called by other methods of same object.
    That allows to hide internal details of Menu.
    For example, the code which uses a Menu should not directly access it’s DOM structure, handler etc. They are internal.
    On the other hand, there should be open, hide and other publicly accessible methods. These methods are called an external(or public) interface.
    There are three most well-known encapsulation levels:
    Accessible only from the class itself, not accessible from inheritants.
    Accessible from the class itself, inheritants are also allowed to access it.
    Accessible from anywhere
          Encapsulation helps to support the code, because a programmer always knows, which methods could have been used by the external code, and which can be safely modified or even removed.
    Type polymorphism
    A code which uses the Menu object can switch to a Tree Menu object or a Sliding Menu without modifications.
    It’s possible, because the public interface of Menu is inherited.
    In JavaScript, unlike most other languages, there are several syntactically different ways to do implement the OOP concepts described above.

    Chapter #5 : Implementation

          5.1 Modules
    A module consists of a group of procedures, which are called from the host programming language. Each procedure contains a single SQL statement, and data is passed to and from the procedure through parameters.
    5.2 Front End Technology
    5.2.1 ASP.NET
    ASP.NET is a unified Web development model that includes the services necessary for you to build enterprise-class Web applications with a minimum of coding. ASP.NET is part of the .NET Framework, and when coding ASP.NET applications you have access to classes in the .NET Framework.
    The three flavors of ASP.NET: web forms, MVC, and web pages:
    ASP.NET offers three frameworks for creating web applications: ASP.NET Web Forms, ASP.NET MVC, and ASP.NET Web Pages. All three frameworks are stable and mature, and you can create great web applications with any of them.
    Each framework targets a different audience or type of application. Which one you choose depends on a combination of your web development experience, what framework you’re most comfortable with, and which is the best fit for the type of application you’re creating. All three frameworks will be supported, updated, and improved in future releases of ASP.NET.
    5.2.2ASP.NET MVC
    ASP.NET MVC targets developers who are interested in patterns and principles like test-driven development, separation of concerns, inversion of control (IoC), and dependency injection (DI). This framework encourages separating the business logic layer of a web application from its presentation layer.
    By dividing the application into the model (M), views (V), and controllers (C), ASP.NET MVC can make it easier to manage complexity in larger applications. With ASP.NET MVC, you can have multiple teams working on a web site because the code for the business logic is separate from the code and markup for the presentation layer — developers can work on the business logic while designers work on the markup and JavaScript that is sent to the browser
          With ASP.NET MVC, you work more directly with HTML and HTTP than in Web Forms. Web Forms tends to hide some of that by mimicking the way you would program a WinForms or WPF application. For example, Web Forms can automatically preserve state between HTTP requests, but you have to code that explicitly in MVC. The MVC model enables you to take complete control over exactly what your application is doing and how it behaves in the web environment.
    MVC was designed to be extensible, providing power developers the ability to customize the framework for their application needs. In addition, the ASP.NET MVC source code is available under an OSI license.
    MVC 4 includes a feature that helps you develop HTTP services that reach a broad range of clients, including browsers and mobile devices. For more information, see Getting Started with ASP.NET Web API. MVC 4 also helps you develop single-page applications (SPAs) that use client-side JavaScript for responsive client interaction.
    5.3 Back End Technology
    5.3.1 About Microsoft SQL server 2012
    Microsoft SQL Server 2012 is a relational database management system (RDBMS) designed for the enterprise environment. Like its predecessors, SQL Server 2012 comprises a set of programming extensions to enhance the Structured Query Language (SQL), a standard interactive and programming language for getting information from and updating a database.
    Microsoft SQL Server 2012, which supplants SQL Server 2008 R2, offers new capabilities, notable among them the following.
    ▪	Column Store indexes: Read-only indexes that group data, streamlining the processing of large data warehouse queries.
    ▪	Support for Windows Server Core: This is a stripped-down version that places a far lower demand on computer resources than a full install does.
    ▪	Power View: Makes it possible to generate mash-ups of business intelligence (BI) reports.
    ▪	Enhanced Auditing: Users can customize their audit logs to accommodate a wider range of events with greater flexibility than was previously possible.
          ▪	Always On: Users can fail over multiple databases and read secondary copies, enhancing disaster recovery (DR) operations.
    ▪	Distributed Replay: A workload can be taken from a production server and played on another server to test it under realistic conditions before deploying it.
    The original SQL Server code was developed by Sybase. In the late 1980s, Microsoft, Sybase, and Ashton-Tate collaborated to produce the first version of the product, SQL Server 4.2 for OS/2. Subsequently, both Sybase and Microsoft have offered SQL Server products.
    5.3.2 Database
    A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. A database is a similar to a data file in that it is a storage place for data.
    A database typically has two components: the file holding the physical database and the database management system software that applications use to access data. The DBMS is responsible for enforcing the database structure, including:
    ▪	Maintaining the relationship between data in the database.
    ▪	Ensuring that data is stored correctly.
    ▪	Recovering all data to a point of known consistency in case of system failures.
    In computing, databases are sometimes classified according to their organizational approach. The most prevalent approach is the relational database, a tabular database in which data is defined so that it can be reorganized and accessed in a number of different ways. A distributed database is one that can be dispersed or replicated among different points in a network. An object-oriented programming database is one that is congruent with the data defined in object classes and subclasses.
    Computer databases typically contain aggregations of data records or files, such as sales transactions, product catalogs and inventories, and customer profiles. Typically, a database manager provides users the capabilities of controlling read/write access, specifying report generation, and analyzing usage. Databases and database managers are prevalent in large mainframe systems, but are also present in smaller distributed workstation and mid-range systems such as the AS/400 and on personal computers. SQL (Structured Query Language) is a standard language for making interactive queries from and updating a database such as IBM's DB2, Microsoft's SQL Server, and database products from Oracle, Sybase, and Computer Associates
          5.4 Maintenance and environment :
    As the number of computer based systems, grieve libraries of computer software began to expand. In house developed projects produced tones of thousand soft program source statements. Software products purchased from the outside added hundreds of thousands of new statements. A dark cloud appeared on the horizon. All of these programs all of those source statements had to be corrected when false were detected, modified as user requirements changed, or adapted to new hardware that was purchased. These activities were collectively called software maintenance.
    The maintenance phase focuses on change that is associated with error correction, adaptations required as the software's environment evolves, and changes due to enhancements brought about by changing customer requirements. Four types of changes are encountered during the maintenance phase.
    1.	Correction :
    Even with the best quality assurance activities is lightly that the customer will uncover defects in the software. Corrective maintenance changes the software to correct defects.
    Maintenance is a set of software Engineering activities that occur after software bas been delivered to the customer and put into operation. Software configuration management is a set of tracking and control activities that began when a software project  begins and terminates only when the software is taken out of the operation.
    We may define maintenance by describing four activities that are undertaken after a program is released for use :
    ▪	Corrective Maintenance
    ▪	Adaptive Maintenance 
    ▪	Perfective Maintenance or Enhancement
    ▪	Preventive Maintenance or reengineering
    Only About 20 percent of all maintenance work are spent "fixing mistakes" The remaining 80 percent are spent adapting existing systems to changes in their external environment, making enhancements requested by users, and reengineering an application for use.
    2.	Adaptation :
    Over time, the original environment (E>G. CPU, operating system, business rules, external product characteristics) for which the software was developed is likely to change. Adaptive maintenance results in modifications to the software to accommodate change to its external environment.
          3.	Enhancement :
    As software is used, the customer/user will recognize additional functions that will provide benefit. Perceptive maintenance extends the software beyond its original function requirements.
    4.	Prevention :
    Computer software deteriorates due to change, and because of this, preventive maintenance, often called software are engineering, must be conducted to enable the software to serve the needs of its end users. In essence, preventive maintenance makes changes to computer programs so that they can be more easily corrected, adapted, and enhanced. Software configuration management (SCM) is an umbrella activity that is applied throughout the software process. SCM activities are developed to.
          Home Page: 
    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    namespace EventSurveySystem
        public partial class Home : System.Web.UI.Page
            protected void Page_Load(object sender, EventArgs e)
          using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    using Login = EventSurveySystem.BLL.Login;
    namespace EventSurveySystem
        public partial class LoginPage : System.Web.UI.Page
            protected void Page_Load(object sender, EventArgs e)
            protected void btnLogin_OnClick(object sender, EventArgs e)
                string username = txtuser.Text;
                string pass = txtpass.Text;
               Login login=new BLL.Login().GetAllLogin().SingleOrDefault(l=>l.Username==username&&l.Password==pass);
                if (login == null)
                    Alert.Show("Invalid uresname or password!! try again");
                    Alert.Show("Login Successfull");
                    Session["user"] = login;
                    Session["loginId"] = login.Id;
                    Session["roleId"] = login.RoleId;
                    var role=new BLL.Role().GetRoleById(login.RoleId);
                    Session["role"] = role;
          using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    namespace EventSurveySystem
        public partial class Add_Event : System.Web.UI.Page
            protected void Page_Load(object sender, EventArgs e)
          using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    using EventSurveySystem.BLL;
    namespace EventSurveySystem
        public partial class AddCompany : System.Web.UI.Page
            private int loginId;
            protected void Page_Load(object sender, EventArgs e)
                if (!IsPostBack)
                    addDiv.Visible = false;
            private void loadEvents()
                eventDropDown.DataSource=new BLL.Events().GetAllEvents().ToList();
                eventDropDown.DataValueField = "Id";
                eventDropDown.DataTextField = "Name";
            private void LoadCompany()
                string mycompanies = "";
                string myEvents = "";
                var events=new BLL.Events().GetAllEvents().ToList();
                foreach (var ev in events)
                    myEvents +=
    " + ev.Name + "
    "; var companies=new BLL.Company().GetAllCompany().Where(c=>c.EventId==ev.Id); string bodies = ""; foreach (var com in companies) { bodies += "

    "; } myEvents += bodies; myEvents+="
    "; } eventsDiv.InnerHtml = myEvents; } protected void btnSave_OnClick(object sender, EventArgs e) { //try //{ Company obj=new Company(); obj.Id = obj.GetMaxId() + 1; obj.EventId = Convert.ToInt32(eventDropDown.SelectedValue); obj.Name = txtName.Text; obj.Address = txtAddress.Text; obj.Email = txtEmail.Text; obj.Username = obj.Email; obj.Password = txtPass.Text; loginId = Convert.ToInt32(Session["loginId"]); obj.AddedBy = loginId; var lgs=new BLL.Login().GetAllLogin().ToList(); obj.LoginId = lgs.Count + 1; // BLL.Login objLogin=new BLL.Login(); objLogin.Id = objLogin.GetMaxId()+1; objLogin.Username = obj.Username; objLogin.Password = obj.Password; objLogin.RoleId = 1; int ss = objLogin.InsertLogin(); // int success = obj.InsertCompany(); string msg = success > 0 ? "Company added succcessfully" : "Failed try again"; Alert.Show(msg); addDiv.Visible = false; this.loadEvents(); this.LoadCompany(); //} //catch (Exception ex) //{ // Alert.Show(ex.Message); //} } protected void btnAddCompany_OnClick(object sender, EventArgs e) { addDiv.Visible = true; } } }
          using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    namespace EventSurveySystem
        public partial class AddStallaspx : System.Web.UI.Page
            protected void Page_Load(object sender, EventArgs e)
                if (!IsPostBack)
                    addDiv.Visible = false;
            void LoadEvents()
                eventDropDown.DataSource=new BLL.Events().GetAllEvents().ToList();
                eventDropDown.DataValueField = "Id";
                eventDropDown.DataTextField = "Name";
            void LoadStall()
                string mystalls = "";
                string mycompanies="";
                var companies = new BLL.Company().GetAllCompany().ToList();
                foreach (var com in companies)
                    mystalls +=
    " + com.Name + "
    "; var stalls = new BLL.Stall().GetAllStall().Where(c => c.CompanyId == com.Id); string bodies = ""; foreach (var st in stalls) { bodies += "

    "; } mystalls += bodies; mystalls += "
    "; } stallsDiv.InnerHtml = mystalls; } protected void btnSave_OnClick(object sender, EventArgs e) { try { BLL.Stall obj=new BLL.Stall(); obj.Id = obj.GetMaxId() + 1; obj.EventId = Convert.ToInt32(eventDropDown.SelectedValue); obj.CompanyId = Convert.ToInt32(companyDrodown.SelectedValue); obj.StallNo = txtStallNo.Text; obj.Name = txtStallName.Text; obj.Description = txtDescription.Text; int success = obj.InsertStall(); string msg = success > 0 ? "Stall added succcessfully" : "Failed try again"; Alert.Show(msg); addDiv.Visible = false; } catch (Exception ex) { Alert.Show(ex.Message); } } protected void btnAddStall_OnClick(object sender, EventArgs e) { addDiv.Visible = true; this.LoadEvents(); } protected void eventDropDown_OnSelectedIndexChanged(object sender, EventArgs e) { try { int eventId = Convert.ToInt32(eventDropDown.SelectedValue); companyDrodown.DataSource=new BLL.Company().GetAllCompany().Where(c=>c.EventId==eventId).ToList(); companyDrodown.DataValueField = "Id"; companyDrodown.DataTextField = "Name"; companyDrodown.DataBind(); } catch (Exception ex) { Alert.Show(ex.Message); } } } }
          using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    using System.Web.Routing;
    using System.Web.Security;
    using EventSurveySystem;
    namespace EventSurveySystem
        public class Global : HttpApplication
            void Application_Start(object sender, EventArgs e)
                // Code that runs on application startup
            void Application_End(object sender, EventArgs e)
                //  Code that runs on application shutdown
            void Application_Error(object sender, EventArgs e)
                // Code that runs when an unhandled error occurs
    - Propellerads

    Chapter #6 : Conclusion And Discussion

          6.1: Discussion
    This project also can be developed with other languages such Visual Basic, Visual C++, JAVA, Visual J# etc. are most common. Many times Visual studio and C# displays error messages. The Visual studio has the ability to edit and process necessary information. The Visual studio has a well-designed Graphical User Interface and was designed carefully to make it user friendly.  Testing and debugging process can be made much simple adhering to the following concepts and technique.
    	Requirement specification plays an important part in the analysis of a system. Only when the requirement specifications are properly given, it is possible to design a system, which will fit into required environment. It rests largely in the part of the users of the existing system to give the requirement specifications because they are the people who finally use the system. This is because the requirements have to be known during the initial stages so that the system can be designed according to those requirements. It is very difficult to change the system once it has been designed and on the other hand designing a system, which does not cater to the requirements of the user, is of no use.
    The requirement specification for any system can be broadly stated as given below:
    • The system should be able to interface with the existing system
    • The system should be accurate
    • The system should be better than the existing system
    The existing system is completely dependent on the user to perform all the duties. Number of Modules
    A module is a bounded contiguous group of statements having a single name and that can be treated as a unit. In other words, a single block in a pile of blocks.
    6.2: Future plan
          6.3	Conclusion
    The project has been carefully designed and efforts have been made to make the system totally error-free. It is efficient and less time consuming in nature. It is also important to note that the system is robust in nature. Also no malfunction can be caused from outsiders. The software used in the system provides ample scope for future modifications
    1.  Microsoft Visual ultimate 2013 Step by Step
    2. Microsoft SQL server 2012 .
    3. Programming in C#.NET with Microsoft Visual Studio 2010
    4. Microsoft Visual C# 2010 step by step
    5. www.wikipedia.org, www.asp.net,  www.w3schools.com
    6.3 Bibliography and Web References:	
    1.	Microsoft Visual C# 2013 Step by Step (Step by Step Developer) Paperback by Joseph Albahari, C# 5.0 in a Nutshell: The Definitive Reference PaperbackJohn Sharp,
    https://en.wikipedia.org/wiki/C_Sharp_(programming_language), http://www.cprogramming.com/tutorial/csharp.html, https://msdn.microsoft.com/en-us/library/67ef8sbd.aspx, https://msdn.microsoft.com/en-us/library/z1zx9t92.aspx
    2.	https://msdn.microsoft.com/en-us/library/dd831853.aspx, https://en.wikipedia.org/wiki/Microsoft_Visual_Studio
    3.	Introducing Microsoft SQL Server 2014 (2014), by Ross Mistry, Stacia Misner, SQL Server 2012 Query Performance Tuning, 3rd Edition (2012), by Grant Fritchey,https://www.visual-paradigm.com/tutorials/leveled-dfd.jsp, http://creately.com/diagram/example/h82k867g1/DFD+Level-0,
    4.	https://msdn.microsoft.com/en-us/library/4w3ex9c2.aspx#wf_mvc_wp
    5.	http://www.w3schools.com/aspnet/mvc_intro.asp

    © Copyright & reserved CSE Solve

    Newsletter For Subscribe

    Please type an email address