HELP DESK - DOC

							INTRODUCTION 1.1OBJECTIVE
This project is aimed at developing an Online Help Desk (OHD) for the facilities in the campus. This is an Intranet based application that can be accessed throughout the campus. This system can be used to automate the workflow of service requests for the various facilities in the campus. This is one integrated system that covers different kinds of facilities like class-rooms, labs, hostels, mess, canteen, gymnasium, computer center, faculty club etc. Registered users (students, faculty, lab-assistants and others) will be able to log in a request for service for any of the supported facilities. These requests will be sent to the concerned people, who are also valid users of the system, to get them resolved. There are features like email notifications/reminders, addition of a new facility to the system, report generators etc in this system. There are registered people in the system (students, faculty, lab-assistants and others). Some of them are responsible for maintaining the facilities (like, the labassistant is responsible for keeping the lab ready with all the equipment in proper condition, the students council is responsible for taking forward students’ complaints/requests to the faculty/administration etc). MODULES  Student Details  Staff Details  Specialties  Mail Services  Meeting Maker  Classroom Equipment

 Desk side Coaching  Accounts  Search Details  Report Student Details This Module is used to maintain the overall student information. Any time we can easy to get any student information. It also maintain name of the student, dateofbirth, address, phone no, standard, etc. Staff Details This Module is used to store the staff overall information, such as staff name, staffed, qualification, dateofbirth, dateofjoin, salary etc. Specialties This module maintain overall Specialties in the campus like class-rooms, labs, hostels, mess, canteen, gymnasium, computer center, faculty club etc. Mail Services This module provide the mail services specialities.we can easy to sent student feedback to their parents through mail. Meeting Making This Module provides the meeting details. Staffs easy to receive the meeting details using this module. Class Room Equipment

This module is easy to maintain the class room equipment. First we want to store overall Room equipment details. After the we can easy to get overall information. Desk side Coaching This module maintains the book details, magazine etc.we can easy to learn book through online. This module maintains book information. Students can easy to learn topic through online. Accounts This module maintains the overall account information of campus. Search Details This module is used to search student’s details, staffs details, department’s details, mess details, hostel details, etc

Report This module Maintain overall Report of students, staff, Account details etc.

Existing System:

The existing system is a manual system. It is done with some important constraints, they are volume of data, time consuming, and Calculations with errors etc. The large volume of data has to be handled with regard to various transactions. Number of documents is to be referred to access any information about any audit. A lot of validation work is to be done. These processes are time consuming and tedious. Any changes made at any point have to

incorporate with the whole system and are really cumbersome. Preparing any report is the most daunting task.

Draw Backs:  Time consuming  Error prone  Updating is very difficult  Large volume of data  Security  Retrieval of Information

 Preparation of information between any two dates at any time

In order to overcome these hurdles the computerized is suggested.

Proposed System:

The proposed system rectifies most of the problem in the present system. The system is menu driven which guarantees the ease of use even for native users. The most important aspect of the new system is that it is flexible to incorporate the changes, error free. Calculations etc. data validation is done during data entry itself so that the errors are minimized. Reports can be

generated for any audit process for given two dates. These reports make the function of the management an easier. Reports generation facilities are provided to all users. An authorized person will maintain master data.

The main features are:  Menu driven  Eliminates manual intervention as far as possible  Error free modification facilities  On line error modification facilities  Secured environment  Immediate report generation for may given two dates  To maintain security.

3.1 TABLES / DICTIONARY

IMPLEMENTATION: Implementation is the stage of the project when the theoretical design is turned out into a working system. Thus it can be considered to be the most critical stage in achieving a successful new system and in giving the user, confidence that the new system will work and be effective.

The implementation stage involves careful planning, investigation of the existing system and it’s constraints on implementation, designing of methods to achieve changeover and evaluation of changeover methods.

The project is implemented by accessing simultaneously from more than one system and more than one window in one system. The application is implemented in the Internet Information Services 5.0 web server under the Windows 2000 Professional and accessed from various clients.

TESTING:

Testing

has become an integral part of any system or project

especially in the field of technology. Testing is the method of justifying. When software is developed before giving into the user, it must be tested, to see whether it is solving the purpose for which it is developed.

Testing Procedure

Testing is the process where the data is prepared and is used for testing the modules individually and latter validations given for the fields then the system testing takes place, which makes sure that, all the components with the system properly function as unit.

Various testing strategies carried out during the testing period are:

Code Testing: This examines the logic of the program. It checks whether there are any logical mistakes.

Acceptance Testing: Acceptance testing is running the system with live data by the actual user. The software was given with actual data. The responsible staff fed the data. This testing is done by the actual users.

Stress Testing: The purpose of stress testing is to prove that the newly developed system does not perform some function under peak loads. For stress testing, the system was dumped with large data and the result was observed carefully. The system is running under peak loads also.

Integration Testing: Integration testing is combining all the modules together and test the system as a whole. All the modules that undergone the unit testing are integrated together to get the whole software as a single module.

Validation Testing: Validation testing is testing the system from uncover functional errors, that is to check whether the functional characteristics conform to the specification or not. The objective is to demonstrate the software to the requirements. The proposed system was tested to see whether all the user requirements were attained or not.

Stress Testing: Programs are invariably related to one another and interact in a total system. Each program is tested to see whether it conforms to related programs in the system. Each portion of the new system was tested against the entire module with both test and live data.

Unit Testing: In unit testing different modules are tested against the specifications produced during the design of the module. It is essential for verification of the code produced during the code phase. Hence the goal is to test the internal logic of the module.

 BOTTOM UP TESTING Starting with the smallest and the lowest modules and processing one at a time for each module. For each module in bottom up testing, a short program executes the module and provides the needed data, so that the system is asked to perform the way it will, when embedded within the largest system.

 TOP DOWN TESTING

It begins with the upper level modules. However, since the detailed activities usually performed in lower level routines are not provided, steps are written. A stub is a module shell that can be called by upper level module and that, when reached properly, will return a message to the calling module, indicating that proper interaction occur

Hardware Requirements:

Model Main Processer Mother Board Clock Speed RAM Hard Disk Floppy Disk Drive CD Drive Monitor Mouse Keyboard

: : : : : : : : : : :

Intel PIII Intel Processor Mercury 1.1GHz 128 MB 40 GM 1.44 MB Sony 52x Samtron 15-inch 56V Logitech Samsung

Software Requirements:

Operating System Web Server Front-End Back-End Development tool Development IDE Browser

: : : : :. : :

Windows 2000 Professional/Windows XP IIS (Internet Information Server) C# .Net, ASP.Net SQL Server2000 Net Framework SDK Visual Studio.Net 2003 Internet Explorer

SOFTWARE DESCRIPTION: Microsoft .NET is a set of Microsoft software technologies for connecting your world of information, people, systems, and devices. It enables an unprecedented level of software integration through the use of XML Web services: small, discrete, buildingblock applications that connect to each other—as well as to other, larger applications— via the Internet. XML Web services link applications, services, and devices together into connected solutions that enable you to act on information anytime, any place, and from any smart device. .NET-connected software delivers what developers need to create and connect XML Web services. The benefit to individuals is seamless, compelling experiences with information sharing. Infrastructure of .NET

Development Environment

JIT

Visual Studio .Net

BCL MSIL CLR

. NET FRAMEWORK K

OS

JIT  Just In Time … An acronym for "just-in-time," a phrase that describes an action that is taken only when it becomes necessary, such as just-in-time compilation

or just-in-time object activation. JIT compilation The compilation that converts Microsoft intermediate language (MSIL) into machine code at the point when the code is required at run time. MSIL  MicroSoft Intermediate Language … A language used as the output of a number of compilers and as the input to a just-in-time (JIT) compiler. The common language runtime includes a JIT compiler for converting MSIL to native code. CLR  Common Language Runtime ... The engine at the core of managed code execution. The runtime supplies managed code with services such as crosslanguage integration, code access security, object lifetime management, and debugging and profiling support. BCL  Base Class Library … Consists of program applications, all objects, types and classes. Client Application Development Client applications are the closest to a traditional style of application in Windows-based programming. These are the types of applications that display windows or forms on the desktop, enabling a user to perform a task. Client applications include applications such as word processors and spreadsheets, as well as custom business applications such as data-entry tools, reporting tools, and so on. Client applications usually employ windows, menus, buttons, and other GUI elements, and they likely access local resources such as the file system and peripherals such as printers. Another kind of client application is the traditional ActiveX control (now replaced by the managed Windows Forms control) deployed over the Internet as a Web page. This application is much like other client applications: it is executed natively, has access to local resources, and includes graphical elements. In the past, developers created such applications using C/C++ in conjunction with the Microsoft Foundation Classes (MFC) or with a rapid application development

(RAD) environment such as Microsoft® Visual Basic®. The .NET Framework incorporates aspects of these existing products into a single, consistent development environment that drastically simplifies the development of client applications. The Windows Forms classes contained in the .NET Framework are designed to be used for GUI development. You can easily create command windows, buttons, menus, toolbars, and other screen elements with the flexibility necessary to accommodate shifting business needs. For example, the .NET Framework provides simple properties to adjust visual attributes associated with forms. In some cases the underlying operating system does not support changing these attributes directly, and in these cases the .NET Framework automatically recreates the forms. This is one of many ways in which the .NET Framework integrates the developer interface, making coding simpler and more consistent. Unlike ActiveX controls, Windows Forms controls have semi-trusted access to a user's computer. This means that binary or natively executing code can access some of the resources on the user's system (such as GUI elements and limited file access) without being able to access or compromise other resources. Because of code access security, many applications that once needed to be installed on a user's system can now be safely deployed through the Web. Your applications can implement the features of a local application while being deployed like a Web page. Server Application Development Server-side applications in the managed world are implemented through runtime hosts. Unmanaged applications host the common language runtime, which allows your custom managed code to control the behavior of the server. This model provides you with all the features of the common language runtime and class library while gaining the performance and scalability of the host server.

The Execution Process in the .NET Framework Source Code

MSIL (Assembly File , Meta Data ) JIT Compiler for Compiling NATIVE CODE

.NET Runtime Manager (Type Checking) Security Check

O/P

ASP.NET

ASP.net is a Server-side scripting technology, Files containing HTML and scripting code, it Access via HTTP requests and Scripting code is interpreted on server side. ASP.net can be done Easily and quickly to create simple Web applications, to Generate dynamic Web content Client-side scripting for validation and to Access COM components to extend functionality and Databases

ASP can be outdated by mixing layout (HTML) and logic (scripting code),Interpreting ASP code leads to performance loss and its Update files only when server is down

.It Uses scripting languages that are not strongly typed such as

 Microsoft JScript  Microsoft Visual Basic Scripting Edition (VBScript)

ASP.NET Core Concepts  Web development platform  New programming model  Separate layout and business logic  Use services provided by the .NET Framework  Code is compiled the first time a page is requested  State management

ASP.NET Page Syntax  Directives  <%@ Page language=“VB“ […] %>

 Code Declaration Blocks  <script [ </script>  Code Render Blocks  <% [ %> inline code or expression ] lines runat=“server“ of code […]> ]

 HTML Control Syntax  <HTMLelement </HTMLelement> runat=“server“ [attribute(s)]>

 Custom Control Syntax     Custom server controls <ASP:TextBox id=“MyTb1“ runat=“server“> Server control property <ASP:TextBox maxlength=“80“ runat=“server“> Subproperty <ASP:Label font-size=“14“ runat=“server“> Server control event binding <ASP:Button OnClick=“MyClick“ runat=“server“>  Data Binding Expression  <asp:label text=‘<%# runat=“server” />  Server-side Object Tags  <object identifier=“idName“ />  Server-side Include Directives  <!-- #include pathtype = filename --> id=“id“ runat=“server“ databinding expression %>’

 Server-side Comments  %-- comment block --%>

An application in ASP.NET consists of files, pages, modules, and executable code that reside in one virtual directory and its subdirectories. Application state is stored in global variables for a given ASP.NET application. For that reason developers have to follow some implementation rules:  Variables for storing application state occupy system resources.

 A global variable has to be locked and unlocked to prevent problems with concurrent access.  Be careful when using those locks in multithreaded server environments.  Application state will be lost if the application host is torn down.  Application state cannot be shared across Web farms. Web Forms Server Controls The term server controls always means Web Forms server controls, because they are specifically designed to work with Web Forms. Server Control Families Web Forms provide different server control families.      HTML server controls ASP.NET server controls Validation controls User controls Mobile controls

Data Binding: You can bind Web Forms control properties to any data in a data store. This socalled data binding gives you nearly complete control over how data moves to the page and back again to the data store. Page Class When a page is loaded, the ASP.NET runtime generates and instantiates a Page class. This object forms a collection of your separate components (like visual elements and business logic). So all (visual and code) elements are accessible through this object. HTML Server Controls

You can convert simple HTML elements to HTML server controls, let the ASP.NET engine create an instance on the server, and now they are programmable on the server. The conversion is done by simply adding attributes to the HTML tag. The attribute runat=server informs the framework to create a server-side instance of the control. If you additionally assign an ID, you can reference the control in your code. For example, you can use the HTMLAnchor control to program against the HTML <a> tag to dynamically generate the HRef value, or use HtmlTable (HTML
<table>) to

dynamically create tables and their content.

ASP.NET Server Controls ASP.NET server controls are abstract controls. There is no one-to-one mapping to HTML server controls. But ASP.NET comes with a rich set of controls. Another feature is the typed object model. This gives you the potential for typesafe programming.Server controls can automatically detect what browser you are using and generate the proper version of HTML output. Button This is a way to enable the user to finish editing a form. A Button enforces the submitting of the page, and you can additionally raise events like the Click event.

TextBox A TextBox is an input box where the user can enter information like numbers, text, or dates formatted as single line, multiline, or password. This control raises a TextChanged event when the focus “leaves” the control. Validation Controls Another group of server controls are validation controls. These can be used to check the user’s entries. Validation can be processed on the client and on the server. Validation on the client side can be performed using a client script. In that case, the user will be confronted with immediate feedback—without a roundtrip to the server.

Server-side validation in addition provides, for example, security against users bypassing client-side validation.

ASP.NET provides the following types of validation:   Required entry—the field must be filled in by the user. Comparison to a value—the entered value is checked against another value of another field, a database, or a constant value by using comparison operators.    Range checking—the user’s entry is checked to see whether it resides between given boundaries. Pattern matching—a regular expression is defined that the entered value must match. User defined—implement your own validation logic.

When the validation fails, an error message is generated and sent back to the client browser. This can be done in several ways. For example, all error messages related to a specific transaction could be collected and presented to the user in summary. User Controls (Pagelets) If you want to design your own server control, you can extend existing ones, combine them, or create a new control. Like all others, your own controls must inherit from the WebControl base class.User controls are sometimes referred to as Pagelets. Mobile Controls With mobile controls a developer can encapsulate Wireless Markup Language (WML) to target multiple devices such as WAP devices.

C-SHARP:
An ASP.NET page is restricted to code written in a single programming language. Currently, ASP.NET supports Visual Basic, C#, and JScript. The default language is Visual Basic, but any other language can be declared as the default language for the page by placing a directive at the top of the page, such as the following:
<%@Language="C#"%>

The language can also be declared in a <script language = ...> block, as in the example provided in the Code Blocks topic. If different languages are declared in separate script blocks on the same page, an error will be thrown. Although only one language can be used on a single page, any user controls that you use on a page can be written in different languages. This allows applications to take advantage of function libraries in different languages (accomplished by the use of #include files in ASP today).

Visual Basic Scripting Edition (VBScript) is no longer supported, but VBScript syntax is very similar to Visual Basic .NET syntax, so any required changes to existing code should be minor. For an example of converting VBScript code to Visual Basic .NET, see the example in Visual Basic Language Changes.

ASP.NET supports all the Common Language Specification (CLS)-compatible programming languages supported by the common language runtime, including Visual Basic and C#.

SQL SERVER INTRODUCTION

SQL stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. The standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database. This tutorial will provide you with the instruction on the basics of each of these commands as well as allow you to put them to practice using the SQL Interpreter. Table Basics A relational database system contains one or more objects called tables. The data or information for the database are stored in these tables. Tables are uniquely identified by their names and are comprised of columns and rows. Columns contain the column name, data type, and any other attributes for the column. Rows contain the records or data for the columns. Selecting Data The select statement is used to query the database and retrieve selected data that match the criteria that you specify. Here is the format of a simple select statement: select "column1" [,"column2",etc] from "tablename" [where "condition"]; [] = optional

The column names that follow the select keyword determine which columns will be returned in the results. You can select as many column names that you'd like, or you can use a "*" to select all columns. The table name that follows the keyword from specifies the table that will be queried to retrieve the desired results. The where clause (optional) specifies which data values or rows will be returned or displayed, based on the criteria described after the keyword where. Conditional selections used in the where clause: = > < >= <= <> Equal Greater than Less than Greater than or equal Less than or equal Not equal to

LIKE *See note below The LIKE pattern matching operator can also be used in the conditional selection of the where clause. Like is a very powerful operator that allows you to select only rows that are "like" what you specify. The percent sign "%" can be used as a wild card to match any possible character that might appear before or after the characters specified. For example: select first, last, city from empinfo where first LIKE 'Er%'; This SQL statement will match any first names that start with 'Er'. Strings must be in single quotes.

Or you can specify, select first, last from empinfo where last LIKE '%s'; This statement will match any last names that end in a 's'. select * from user where first = 'Eric'; This will only select rows where the first name equals 'Eric' exactly. Creating Tables The create table statement is used to create a new table. Here is the format of a simple create table statement: create table "tablename" ("column1" "data type", "column2" "data type", "column3" "data type"); Format of create table if you were to use optional constraints: create table "tablename" ("column1" "data type" [constraint], "column2" "data type" [constraint], "column3" "data type" [constraint]); [ ] = optional Note: You may have as many columns as you'd like, and the constraints are optional.

To create a new table, enter the keywords create table followed by the table name, followed by an open parenthesis, followed by the first column name, followed by the data type for that column, followed by any optional constraints, and followed by a closing parenthesis. It is important to make sure you use an open parenthesis before the beginning table, and a closing parenthesis after the end of the last column definition. Make sure you seperate each column definition with a comma. All SQL statements should end with a ";". The table and column names must start with a letter and can be followed by letters, numbers, or underscores - not to exceed a total of 30 characters in length. Do not use any SQL reserved keywords as names for tables or column names (such as "select", "create", "insert", etc). Data types specify what the type of data can be for that particular column. If a column called "Last_Name", is to be used to hold names, then that particular column should have a "varchar" (variable-length character) data type. Here are the most common Data types: Fixed-length character string. Size is specified in parenthesis. Max
Char(size)

255 bytes. Variable-length character string. Max size is specified in

Varchar(size)

parenthesis. Number value with a max number of column digits specified in
Number(size)

parenthesis. Date value Number value with a maximum number of digits of "size" total,

Date

Number(size,d)

with a maximum number of "d" digits to the right of the decimal. Number value with a maximum number of digits of "size" total,
Number(size,d)

with a maximum number of "d" digits to the right of the decimal.

What are constraints? When tables are created, it is common for one or more columns to have constraints associated with them. A constraint is basically a rule associated with a column that the data entered into that column must follow. For example, a "unique" constraint specifies that no two records can have the same value in a particular column. They must all be unique. The other two most popular constraints are "not null" which specifies that a column can't be left blank, and "primary key". A "primary key" constraint defines a unique identification of each record (or row) in a table. All of these and more will be covered in the future Advanced release of this Tutorial. Constraints can be entered in this SQL interpreter, however, they are not supported in this Intro to SQL tutorial & interpreter. They will be covered and supported in the future release of the Advanced SQL tutorial - that is, if "response" is good. Inserting into a Table The insert statement is used to insert or add a row of data into the table. To insert records into a table, enter the key words insert into followed by the table name, followed by an open parenthesis, followed by a list of column names separated by commas, followed by a closing parenthesis, followed by the keyword values, followed by the list of values enclosed in parenthesis. The values that you enter will be held in the rows and they will match up with the column names that you specify. Strings should be enclosed in single quotes, and numbers should not. insert into "tablename" (first_column,...last_column) values (first_value,...last_value); Updating Records The update statement is used to update or change records that match a specified criteria. This is accomplished by carefully constructing a where clause.

update "tablename" set "columnname" = "newvalue" [,"nextcolumn" = "newvalue2"...] where "columnname" OPERATOR [and|or "column" OPERATOR "value"]; Deleting Records The delete statement is used to delete records or rows from the table. Delete from "tablename" where "columnname" OPERATOR "value" [and|or "column" OPERATOR "value"]; To delete an entire record/row from a table, enter "delete from" followed by the table name, followed by the where clause which contains the conditions to delete. If you leave off the where clause, all records will be deleted. Drop a Table The drop table command is used to delete a table and all rows in the table. To delete an entire table including all of its rows, issue the drop table command followed by the tablename. drop table is different from deleting all of the records in the table. Deleting all of the records in the table leaves the table including column and constraint information. Dropping the table removes the table definition as well as all of its rows. drop table "tablename" Table Joins, a must "value"

All of the queries up until this point have been useful with the exception of one major limitation - that is, you've been selecting from only one table at a time with your SELECT statement. It is time to introduce you to one of the most beneficial features of SQL & relational database systems - the "Join". To put it simply, the "Join" makes relational database systems "relational". Joins allow you to link data from two or more tables together into a single query result--from one single SELECT statement. A "Join" can be recognized in a SQL SELECT statement if it has more than one table after the FROM keyword.

CONCLUSION

The software has been successfully implemented and has been found to replace the existing system effectively. It has also possible methods to eliminate the human errors likely to creep in to this kind of work in which bulk quantity of data has been processed. This application as been designed to suit exact needs.

It is user friendly providing graphical user interface. Its interface conforms to the standard windows interface. So the user is at ease the system. It provides the selection of the data wherever possible instead of typing it.

The software is developed with scalability in mind. Additional modules can be easily added when necessary. The software is developed with modular approach. Additional reports can be easily added. Most of decision rules are not statically coded. It can be changed running the software.

As already mentioned no system is perfect. This project has been developed with the intention to provide the management with useful software.

-STEVE HARRIS AND ROBMACDONALD Moving to ASP.NET: Web Development with C#.NET: (Apress) 2005 -MATTHEW MACDONALD Microsoft C#.NET Programmer’s Cookbook: (Tata McGraw Hill Edition) 2005 -CHRIS GOODE, JOHN KAUFFMAN

Beginning ASP.NET 2.0 with C#.NET
(Wrox Programmer to Programmer) 2005 -Douglas O.Reilly

Designing Microsoft ASP.NET Applications
TataMcGrawHill Edition 2005

Web References www.msdn.microsoft.com www.codeproject.com www.windowsforms.net www.xtremedotnettalk.com www.oracle.com/industries/life_sciences