1.

INTRODUCTION

1.1 ABOUT THE PROJECT

The “MATERIAL INWARD AND OUTWARD SYSTEM” is a computerized

system for the integrated set of operations that is performed by the material inward and
outward transactions with in the college.

The system involves various material inwards and outward activities of the college.
Details regarding them can be viewed in the forms whenever necessary.

The modules are divided into 2 levels such as Admin, User. Admin Module has the
process of User Management and Material Inward and Outward Management. User Module
has User Login Maintenance and Material Outward and available Details.

1
1.2 SYSTEM SPECIFICATION

1.2.1 HARDWARE SPECIFICATION

Processor : Intel Core i3

RAM capacity : 4 GB

Hard disk drive : 1TB

Keyboard : Multi Media

Mouse : Optical

Monitor : 17” Color

1.2.2 SOFTWARE SPECIFICATION

Operating System : Windows

Front end used : ASP .Net with C#

Back end used : SQL Server

2
1.3 ABOUT THE SOFTWARE

FRONT END

This Project work has completed in ASP. NET with C# 2.0 as front end and SQL
Server 2005 as back end. Microsoft .NET is software that connects information, people,
systems and devices. It spans clients, servers and developer tools and consists of:
 The .NET Framework programming model that enables developers to build
Web-based applications which expose their functionality programmatically
over a network using standard protocols such as SOAP and HTTP.
 Developer tools such as Microsoft Visual Studio .NET, which provide a rapid
application integrated development environment for programming with the
.NET Framework.
 A set of servers including Microsoft Windows 2000, Microsoft SQL, Server
and Microsoft BizTalk Server that integrates, runs, operates and manages
XML Web services and applications.
 Client software such as Windows XP, Windows CE and Microsoft Office XP,
7 that help developers deliver a deep and compelling user experience across a
family of devices and existing products.
The .NET Framework is the programming model of the .NET environment for
building, deploying and running Web- based applications, smart client applications and XML
Web services. It manages much of the plumbing, enabling developers to focus on writing the
business logic code for their applications. The .NET Framework includes the common
language runtime and class libraries.

OVERVIEW OF THE LANGUAGE USED

MICROSOFT VISUAL STUDIO
Microsoft Visual Studio is Microsoft’s flagship software development product for
computer programmers. It centers on an integrated distribution environment which has
programmers create stand alone, and web services that run on any platforms supported by
Microsoft’s .Net Framework (for all versions after 6). Supported platforms include Microsoft
windows, servers and workstations, Pocket PC, Smart Phones and World Wide Web
browsers not the Java Virtual Machine that all other java tools target.

3
VISUAL STUDIO 2010
The most important language added in this version was the introduction of
generics, which are similar in many aspects to C++ templates. This potentially increases the
number of bugs caught at compile- time instead of run- time by encouraging the use of strict
type checking in areas where it was not possible before, C++ also got a similar upgrade with
the addition of C++/CLI which is slated to replace the use of Managed C++. Other new
features of Visual Studio 2010 include the “Development Designer” which allows application
designs to be validated before deployments, an improved environment for web publishing
when combined with ASP.NET 2.0 and load testing to see application performance under
various sorts of user loads. Visual Studio 2010 also added extensive 64- bit support. While
the development environment itself only available as a 32- bit application, visual C++ 2010
supports compiling for (x64AMD64 and EM64T) as well as IA- 64 (Itanium). The platforms
SDK include 64- bit and 64-bit versions of the libraries.

NET FRAMEWORK SDK

The .NET framework is an integral windows component that supports building
and running the next generation of applications and XML web services. The key component
of the .NET frame work are the common language run time and the . NET frame work class
library, which includes ADO.NET, ASP.NET and windows forms. The .NET framework
provides a managed execution environment simplified development and deployment and
integration with a wide variety of programming languages.
This framework is made up of the following parts:
 The common language runtime(CLR)

 The base class libraries.

 Object oriented internet development with ASP.NET

 Rich client user interface using windows forms

 RAD for the internet using web forms

4
OVERVIEW OF THE .NET FRAME WORK

The .NET framework is a new computing platform that simplifies application

development in the highly distributed environment of the internet. The .NET framework is
designed to fulfill following objectives:
 To provide a consistent object oriented programming environment whether
object code is stored and executed locally but internet- distributed or executed
remotely.

 To provide a code execution environment that minimizes software deployment

and versioning conflicts.

 To provide a code execution environment that guarantees safe execution of

code, including code created by an unknown or semi trusted third party.

 To provide a code execution environment that eliminates the performance

problem of scripted or interpreted environments.

 To make the developer experience consistent across widely types of

application, such as windows based applications and web based applications.

 To build all communication on industry standards to ensure that code based on

the .NET framework can integrate with any other code.

The .NET framework has two main components: the common language runtime
and the .Net framework class library. The common language runtime is the foundation of
the .NET framework. You can think of the runtime as an agent that manages code at
execution time and remoting while also enforcing strict type safely and other forms of code
accuracy that ensure security and robustness in fact the concept of code management is a
fundamental principle of the runtime.
Code that targets the runtime is known as managed code, while code that does not
target the runtime is known as un managed code. The class library, the other main
component of the .NET frameworks is a comprehensive, object-oriented collection reusable
types that you can use to develop applications ranging from traditional command line or
graphical user interface (FGUI) applications to application base d on the latest innovations
provided by ASP.NET, such as web forms and XML web services.

5
 The .NET framework can be hosted by unmanaged component that load the common
language runtime into their processes and initiate the execution of managed code. ASP.NET
works directly with the runtime to enable ASP.NET application and XML web services, both
of which are discussed later in this topic, Internet explorer is an example of unmanaged
application that hosts the runtime (in the form of a MIME type extension). Using internet
explorer to the host runtime enables you to embed managed components or windows forms
controls in HTML documents. Hosting the runtime in this way makes mobile code 9similar
to Microsoft Active X controls) possible, but with significant improvement that only
managed code can offer, such as semi-trusted execution and secure isolated file storage.
The following illustration shows the relationship of the common language runtime
and the class library to your application and to the overall system. The illustration also shows
how managed code operated with in a larger architecture.
We can use the .NET framework to develop the following types of application and services:
 Console applications
 Window GUI application (Windows Forms) ASP.NET applications
 XML Web services
 Windows services

COMMON LANGUAGE RUNTIME (CLR)

The common language runtime (CLR) is responsible for runt-time services such as
language integration; security enforcement; and memory, process and thread management. In
addition, it has a roll at development time when features such as life cycle management
strong type naming, cross-language exception handling, dynamic binding and so on, reduce
the amount of code that a developer must write to turn the business logic the reusable
component. The runtime can be hosted by high performance, server-side applications, such a
s Microsoft Internet Information Services (IIS) for building web applications with ASP.NE
and the next release of Microsoft SQL Server. This infrastructure enables you to use code
“managed “ by the .NET framework to write your business logic, while still enjoying the
superior performance of the industry’s best enterprises servers that support runtime hosting.

6
ASP.NET
ASP.NET is a set of Microsoft.NET framework technologies used for building web
applications and XML Web services. ASP.NET page execute on the server and generate
markup such as HTML, WML or XML that is sent to a desktop or mobile browser.
ASP.NET pages use a compiled, event-driven programming model that improves
performance and enables the separation of application logic and user interface. Both
ASP.NET pages and ASP.NET web services files contain server-side (as opposed to client
side logic) written in Visual basic .NET, C#.NET or any .NET compatible language, Web
applications and XML Web Services take advantage of the features of the common language
runtime, such as type safety, inheritance, language, interoperability, versioning, and
integrated security.
IIS
Microsoft Internet Information S4ervices (IIS; formerly called Server is a set of
Internet-based services for servers using Microsoft Windows. It is the world’s second most
popular web server in terms of overall websites. As of September 2007 it served 34.94% of
all websites and 36.63% of all active websites according to Net craft. The servers currently
include FTP, SMTP, NNTOP, and HTTP/HTTPS.
ADO.NET
ADO.NET provides consistent access to data sources such a Microsoft SQL Server
and XML, as well as to data sources exposed through OLE DB and ODBC. Data sharing
consumer applications can use ADO.NET to connect to these data sources and retrieve,
manipulate and update the data that they contain.
ADO.NET separates data access from data manipulation into discrete components
that can be used separately or in tandem. ADO.NET includes .NET Frame work data
providers for connecting to a database, executing commands and retrieving results. Those
results are either processed directly, placed in and ADO.NET Dataset objects in order to be
exposed to the used in an ad hoc manner, combined with data from multiple sources or
remote between tiers. The ADO.NET Dataset object can also be used independently of a
.NET Framework data provider to manage data local to the application or sourced from
XML.
The ADO.NET classes are found in System.Data.dll and are integrated with the XML
classes found in System.Xml.dll. When compiling code that uses the System. Data,
namespace reference both System.Data.dll and System.Xml.dll.

7
 ADO.NET provided functionality to developers writing managed code similar to the
functionality provided to native component object model (COM) developers by ActiveX Data
Objects (ADO).

ADO.NET COMPONENTS
There are two components of ADO.NET that you can use to access and manipulate
data:
 .NET Framework data providers.
 The DataSet

NET FRAMEWORK DATA PROVIDERS

The .NET Framework Data providers are components that have been explicitly
designed for data manipulation and fast, forward-only, read-only access to data. The
connection object provides connectivity to a data source. The command object enables
access to database commands to return data, modify data, run stored procedures and send or
retrieve parameter information. The Data Adapter provides a high-performance stream of
data from the data source. Finally, the Data Adapter provides the bridge between the Data Set
object and the data source. The Data Adapter uses command object to execute SQL
commands at the data source to both load the Data Set with data and reconcile changes made
to the data in the Data Set back to the data source.
THE DATASET
The ADO.NET Data Set is explicitly designed for data access independent of any data
source. As a result, it can be used with multiple and differing data sources used with XML
data or used to manage data local to the application. The Data Set contains a collection n of
one or more Data Table objects made up to rows and columns of data as well as primary key,
foreign key, constraint and relation information about the data in the Data Table objects.
BENEFITS OF ADO.NET
ADO.NET offers several advantages over previous versions of ADO and over other
data access components. These benefits fall into the following categories:
1. Interoperability
2. Maintainability
3. Programmability
4. Salability

8
BACK END

MS SQL SERVER

DATABASE

Database is an organized list of data (information) that can be queried to find

information quickly and easily based chosen reference point. Such a last name of security
number. In database terminology, the columns are called fields and the rows are called
records. The kind of organization in a database is called a table.

SQL SERVER

.SQL Server is a RDBMS that you can store and manipulate large amount of information.
A relational database is a database, which consists of tables of that related information that
are linked together on key fields.
The tools of SQL Server are user friendly and provide a powerful development
environment, making it equally appropriate for novices and MIS professionals. For example
we can access quickly and easily create a database of mailing list information that we can
merge with other document.
SQL Server commands are related to Oracle, So that the oracle users can easily operate
the SQL Server, One of the main advantage is it can easily execute set of queries at a time..

MAIN ELEMENTS OF SQL SERVER

SQL Server is an Object Oriented program. Objects are modules, which is used to
provide information and programs, which any of user can directly apply to create application.
Each Object has properties that defines how the looks and perform. It has the following
Objects.
 Tables
 Queries
 Forms & Reports
 Modules

9
TABLES

Tables are primary building blocks of SQL SERVER database. All data is stored in
tables. Every table in the database focus on one subject. We can combine specific fields from
multiple tables into one data sheet. The datasheet that a query written is called a record set.
QUERIES

Queries are used to perform some operation for retrieve the data from the table and to

store the data to the table.

FORMS

Forms are used to access and maintain the database.

RELATIONSHIPS

Relationship is mainly used to join the two databases. Join is an object, which has

three forms that are (inner join, simple join, and outer join)

Fundamental Design Concepts

A set of fundamental design concepts are evolved over the past three decades,

although the degree of interest in each concept has varied over the years, each has stood the

test of time. Each one provides the software designer with a foundation from which more

sophisticated design methods can be applied. Fundamental design concepts provide the

necessary framework for “getting it right”.

Abstraction
Abstraction permits one to concentrate on a problem at some level of generalization
without regard to irrelevant low level details, use of abstraction also permits one to work with
concepts and terms that are familiar in the problem environment without having to transform
them to an unfamiliar structure. Two types of abstraction are there, one is procedural
abstraction and data abstraction. A procedural abstraction is a named sequence of instructions
that has a specific and limited function. A data abstraction is a named collection of data that
describes a data object.

10
Modularity
Modularity is the single attribute software that allows a program to be intellectually
manageable. Software architecture embodies modularity, that is, software is divided into
named and addressable components, called modules that are integrated to satisfy problem
requirements.
Software Architecture
Software Architecture alludes to “the overall structure of the software and the ways in
which that structure provides conceptual integrity for a system”. Control hierarchy also called
program structure”, represents the organization of control. The tree structure used to represent
the control hierarchy.
Structural Partitioning
The program structure should be partitioned both horizontally and vertically. Horizontal
partitioning defines separate branches of the modular hierarchy for each major program
function, Vertical partitioning called factoring, suggest that control and work should be
distributes top-down in the program architecture. Top level modules should perform control
functions and do actual processing work. Modules reside low in the architecture should be the
workers, performing all input, computational and output tasks.
Data Structure

Data Structure is a representation of logical relationship among individual elements of

data. Because the structure of information will invariably affects the final procedural design,
data structure is very important as the program structure to the representation of the software
architecture. Data structure dictates the organization, methods of access, degree of
associatively, and processing alternatives for information. The organization and complexity
of a data structure are limited only by the ingenuity of the designer. Scalar item array and
linked list are some of the representations of the data structure.
Software Procedure
Program structure defines control hierarchy without regard to the sequence of processing and
decisions. Software procedure focuses on the processing details of each module individually.
Procedure must provide a precise specification of processing, including sequence of events,
exact, decision points, repetitive operations and even data organization /structure.
Information hiding suggests that modules be “characterized by design decisions that hide
from all others.” In other words, modules should be specified and designed so that
information contained within module is inaccessible to other module.

11
 2. SYSTEM STUDY

2.1 EXISTING SYSTEM

In the existing system, the material inward and outward transactions are recorded
manually. This may lead to time consuming and less accuracy. To avoid these, the system
can be computerized and worked through computers. Thus the existing system can be switch
in to the computers and developed in the manner of fine and accuracy
DISADVANTAGES OF EXISTING SYSTEM
There may be many drawbacks in the existing system since humans can work it.
They may be as follows,
 Inaccuracy and error can be arising during transaction
 Report may be not clear and neat
 Time consumption may be high to generate the reports or cross reference
 Increase data redundancy
 Stock taking and updating to be difficult.
To avoid all these limitations and make the working more accurately the system needs
to be computerized and implemented in online.

2.2 PROPOSED SYSTEM

Material Inward and Outward System is aimed at developing a web-based

system. In this System is a computerized system for the integrated set of operations that is
performed by the material inward and outward transactions with in the college.

ADVANTAGES OF PROPOSED SYSTEM

 Fully automated system to remove the paper work completely.

 Preparing hard copies of reports.
 Supports data independence.
 Controls the data redundancy.
 More reliability and maintainability.
 Easy stock level identification.

12
2.3 FEASIBILTY STUDY
A feasibility analysis usually involves a thorough assessment of the operational(need),
financial and technical aspects of a proposal. Feasibility study is the test of the system
proposal made to identify whether the user needs may be satisfied using the current software
and hardware technologies, whether the system will be cost effective from a business point of
view and whether it can be developed with the given budgetary constraints. A feasibility
study should be relatively cheap and done at the earliest possible time. Depending on the
study, the decision is made whether to go ahead with a more detailed analysis.

When a new project is proposed, it normally goes through feasibility assessment.

Feasibility study is carried out to determine whether the proposed system is possible to
develop with available resources and what should be the cost consideration. Facts considered
in the feasibility analysis were.

 Technical Feasibility
 Economic Feasibility
 Behavioral Feasibility

Technical Feasibility
Technical Feasibility deals with the hardware as well as software requirements.
Technology is not a constraint to type system development. To find out whether the
necessary technology, the proposed equipments have the capacity to hold the data, which is
used in the project, should be checked to carry out this technical feasibility.
The technical feasibility issues usually raised during the feasibility stage of
investigation includes these
 This software is running in windows 7 Operating System, which can be easily
installed.
 The hardware required is Pentium based server.
 The system can be expanded.

13
Economical Feasibility
This feasibility study present tangible and intangible benefits from the prefect by
comparing the development and operational cost. The technique of cost benefit analysis is
often used as a basis for assessing economic feasibility. This system needs some more initial
investment than the existing system, but it can be justifiable that it will improve quality of
service.
Thus feasibility study should center along the following points:
 Improvement resulting over the existing method in terms of accuracy,
timeliness.
 Cost comparison
 Estimate on the life expectancy of the hardware
 Overall objective
Our project is economically feasible. It does not require much cost to be involved in the
overall process. The overall objectives are in easing out the requirement processes.

Behavioral/ Operational Feasibility

This analysis involves how it will work when it is installed and the assessment of
political and managerial environment in which it is implemented. People are inherently
resistant to change and computers have been known to facilitate change. The new proposed
system is very much useful to the useful to the users and there for it will accept broad
audience from around the world.

14
 3. SYSTEM DESIGN AND DEVELOPMENT

The most creative and challenging face of the system development is System Design.
It provides the understanding and procedural details necessary for implementing the system
recommended in the feasibility study. Design goes through the logical and physical stages of
development.

Design of a system can be defined as a process of applying various techniques and

principles for the purpose of defining a device, a process or a system in sufficient detail to
permit its physical realization. Thus system design is a solution to “how to” approach to the
creation of a new system. Thus important phase provides the understanding and the
procedural details necessary for implementing the system recommended in the feasibility
study. The design step provides a data design, architectural design, and a procedural design.

3.1 INPUT DESIGN

In the input design, user-oriented inputs are converted into a computer based system
format. It also includes determining the record media, method of input, speed of capture and
entry on to the screen. Online data entry accepts commands and data through a keyboard. The
major approach to input design is the menu and the prompt design. In each alternative, the
user’s options are predefined. The data flow diagram indicates logical data flow, data stores,
source and destination. Input data are collected and organized into a group of similar data.
Once identified input media are selected for processing.
In this software, importance is given to develop Graphical User Interface (GUI),
which is an important factor in developing efficient and user-friendly software. For inputting
user data, attractive forms are designed. User can also select desired options from the menu,
which provides all possible facilities.

Also the important input format is designed in such a way that accidental errors are
avoided. The user has to input only just the minimum data required, which also helps in
avoiding the errors that the users may make. Accurate designing of the input format is very
important in developing efficient software. The goal or input design is to make entry as easy,
logical and free from errors.

15
Material Inward and Outward has the following module description

Admin Module
The Administrator logins to the application through the login form, and storing the
material inward , and view the material outward and net stock details from the corresponding
tables from the database.

User Module
The user registration contains dept id, department name, username, password, email,
mobile number.
After the registration, department incharge login into material outward form through
the username and password. From this form they can view the available stock items of the
material and apply for required materials to the department.

3.2 OUTPUT DESIGN

In the output design, the emphasis is on producing a hard copy of the information
requested or displaying the output on the CRT screen in a predetermined format. Two of the
most output media today are printers and the screen. Most users now access their reports from
a hard copy or screen display. Computer’s output is the most important and direct source of
information to the user, efficient, logical, output design should improve the systems relations
with the user and help in decision-making.
As the outputs are the most important source of information to the user, better design
should improve the system’s relation and also should help in decision-making. The output
device’s capability, print capability, print capability, response time requirements etc should
also be considered form design elaborates the way output is presented and layout available
for capturing information. It’s very helpful to produce the clear, accurate and speedy
information for end users.

User Module
The user can view their profile and also material outward status .

3.3 LOGICAL DESIGN

16
 Logical data design is about the logically implied data. Each and every data in the
form can be designed in such a manner to understand the meaning. Logical data designing
should give a clear understanding and idea about the related data used to construct a form.

3.4 DATABASE DESIGN

Database design is the process of producing a detailed data model of a database.

logical data model contains all the needed logical and physical design choices and physical
storage parameters needed a design in a Definition Language, Which can then be used to
create a database. A fully attributed data model contains detailed attributes for each entity.

17
 4. SYSTEM TESTING & IMPLEMENTATION

SYSTEM TESTING

Software testing is an important element of software quality assurance and represents the
ultimate review of specification, design and coding. It increasing visibility of software as a
system element and the costs associates with a software failure are motivating forces for all
well planned through testing .The system is tested with giving wrong information. Cascade
deletion and, the software developer checks updating. Testing and debugging are different
activities, but debugging must be accommodated in any testing strategy.

TYPES OF TESTING

UNIT TESTING
Unit testing is the important and major part of the project. So errors can be rectified
easily in each module and program clarity can be increased. In this project, the entire system
is divided into several modules and is developed individually. Hence, unit testing is
conducted to individual modules.

INTEGRATION TESTING
Integration testing is the systematic technique for constructing the program structure
while conducting tests to uncover errors associated with integrating. After the unit test, each
module is gradually integrated to form one final system. All the modules when unit tested
will work properly but after integrating the data can cause error one module can have an
inadvertent, adverse effect on another; sub functions when combined may not produce the
desired major function; global data structures can cause problems, etc. In this project the
integration testing is performed by combing login, material inward and outward modules are
generated the report.

18
PERFORMANCE TESTING
A type of Physical test covering a wide range of engineering or functional evaluations
where a material, product, or system is not specified by detailed material or component
specifications: rather, emphasis is on the final measurable performance characteristics.
Testing can be a qualitative or quantitative procedure.

ACCEPTANCE TESTING

The User Acceptance testing focuses mainly on the functionality thereby validating
the fitness-for-use of the system by the business user. The user acceptance test is performed
by the users and application managers.

4.2 SYSTEM IMPLEMENTATION

Implementation is used here to mean the process of converting a new or revised system
design into operational one; conversion is one aspect of implementation. The other aspect is
post implementation review and software and maintenance.

Implementation is the process of converting a new or revised system design into an

operational one when the initial design was done for the system, a demonstration was given
to the end user about the working system. This process is used to verify and identify any
logical mis-working of the system by feeding various combinations of test data. After the
approval of the system by both end user and management the system was implemented.

The best suited application package to develop purchase system is Visual Studio and
Sql Server under Windows 7 environment.

19
 5. CONCLUSION AND FUTURE ENHANCEMENT

 The Project “MATERIAL INWARD AND OUTWARD” replaced the manual

process of various material inwards and outward activities of the college.

 The main objective of the website is to reduce the effort by the college and save the
time and avoid unwanted rushes at the college office and assure a smooth working
schedule at college office without affecting regular scheduled like fees collection,
record entries, affiliation , etc.,

 The project could very well be enhanced further as per the requirements

20
 6. FUTURE ENHANCEMENT

In Material Inward and Outward System the users can sign up and login within
their material out area. In Further System, the user cannot enter immediately after the signup
without getting permission of the admin, add the material return option and as per the college
requirements.

21
 7. BIBILIOGRAPHY

Reference Books

 Eilas awared “SYSTEM ANALYSIS DESIGN” and Tata Mcgraw hill publication
sixth edition, 2003

 S. Ramachandran ”COMPUTER AIDED DESIGN” Airwalk publications, third

edition, 2003

 Richard Fairley ”SOFTWARE ENGINEERING ” concepts, Tata Mcgraw hill

publication, second, 1997

 DISTRIBUTED.NET PROGRAMMING IN C#.NET by Torm Barnaby

 PROFESSIONAL C#.NET, second edition by Fred Barwell et all

 THE .NET LANGUAES: A QUICK TRANSLATION guide by Brian Bischof

Reference Websites

 www.asp.net

 www.microsoft.com

 www.codeproject.com

 www.c-sharpcorner.com

 www.programmersheaven.com

 www.w3schools.com

22
23
 8. APPENDIX

DATA FLOW DIAGRAM

A Data Flow Diagram (DFD) is a diagram that describes the flow of data and the
processes that change data throughout a system. It’s a structured analysis and design tool that
can be used for flowcharting in place of or in association with information. Oriented and
process oriented system flowcharts. When analysts prepare the Data Flow Diagram, they
specify the user needs at a level of detail that virtually determines the information flow into
and out of the system and the required data resources. This network is constructed by using a
set of symbols that do not imply physical implementations. The Data Flow Diagram reviews
the current physical system, prepares input and output specification, specifies the
implementation plan etc.

Four basic symbols are used to construct data flow diagrams. They are symbols that
represent data source, data flows, and data transformations and data storage. The points at
which data are transformed are represented by enclosed figures, usually circles, which are
called nodes.

DATA FLOW DIAGRAM SYMBOLS:-

- Source or Destination of data

- Data Flow

- Process

- Storage

24
 CONTEXT DIAGRAM

User Details Material

Inward and View Details
User Administrator
Outward
View Details System Manage

Level 1 DFD- User

Details
Material
Logi
Outward
n
Confirmation
User name, Password Validation Add

User Login
Material Outward
Files
User Details Add Details

Registration Registration

25
Level 1 DFD- Administrator

Administrator

Login Details Login

Log
in
Material Inward and
Verifications & Outward Files
Approvals
Overall
Material Control
Inward
and
Outward

Material
Inward and
Outward

User Managing

26
Level 2 DFD- User

User

Login Details
Login Material Out Files

Add Details
Logi
n Material
Out Entry

Material View Details Stock Files

Out

Stock
Available

27
Level 2 DFD- Admin

Admin

Login Details
Login Material In Files

Add Details
Logi
n Material
Inward
Entry

Material View Details Stock Files

Inward and
Outward
Stock
Available

View Details Material Out Files

Material
Out

28
TABLE SPECIFICATIONS

Table Name: Admin Login

Field Name Data Type Size

Username Varchar 10
Password Varchar 10

Table Name: Users

Primary Key: Username

Field Name Data Type Size

Did int Identity Column
DepartmentName Varchar 20
InchargeName Varchar 20
UserName Varchar 10
Password Varchar 10
Email Varchar 25
Address Varchar 50
Gender Varchar 10
Mobile Varchar 10

Table Name: Materialmaster

Field Name Data Type Size

Sno int Identity Column
Pid Varchar 10
Pname Varchar 20
Pdescription Varchar 50

Table Name: Materialin

Field Name Data Type Size

Ino int Identity Column
Pid Varchar 10
Pname Varchar 20
Pdescription Varchar 50
Qty Varchar 5
Price Varchar 10
Dateofin Date/Time 8
Purpose Varchar 50

29
Table Name: MaterialOut

Field Name Data Type Size

Ono int Identity Column
Pid Varchar 10
Pname Varchar 20
Pdescription Varchar 50
Qty Varchar 5
Price Varchar 10
Dept Varchar 20
Dateofout Date/Time 8
Purpose Varchar 50

30
SCREEN SHOTS

About Us

31
Admin Login page

32
Admin Page

33
Registered User Details

34
Material Master Entry

35
Material List

36
Material Inward

37
Material Inward Report

38
Material Outward Report

39
Material Outward (Track Department Wise)

40
Material Outward (Track Material Wise)

41
User Signup Page

42
User Login

43
Material Out

44
Contact Us

45
Source Code
Signup Form
Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration
Partial Class SignUpVB
Inherits System.Web.UI.Page

Private Sub ClearControls(ByVal ctrl As Control)

For Each tb As Control In ctrl.Controls
If TypeOf tb Is TextBox Then
DirectCast(tb, TextBox).Text = ""
Else
If tb.Controls.Count > 0 Then
ClearControls(tb)
End If
End If
Next
End Sub

Protected Sub btnSave_Click(ByVal sender As Object, ByVal e As

System.EventArgs) Handles btnSave.Click
'Create ConnectionString and Inser Statement
Dim connectionString As String =
ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString
Dim insertSql As String = "INSERT INTO Users
(DeptName,IncName,UserName,Password,Email,Address,Gender,Mobile) values
(@DeptName,@IncName,@UserName,@Password,@Email,@Address,@Gender,@Mobile)"
'Create SQL connection
Dim con As New SqlConnection(connectionString)

'Create SQL Command And Sql Parameters

Dim cmd As New SqlCommand()

cmd.Connection = con
cmd.CommandType = CommandType.Text
cmd.CommandText = insertSql
con.Open()
Dim DeptName As New SqlParameter("@DeptName", SqlDbType.VarChar,
50)
DeptName.Value = txtDeptName.SelectedItem.ToString()
cmd.Parameters.Add(DeptName)

Dim IncName As New SqlParameter("@IncName", SqlDbType.VarChar, 50)

IncName.Value = txtIncName.Text.ToString()
cmd.Parameters.Add(IncName)

Dim userName As New SqlParameter("@UserName", SqlDbType.VarChar,

50)
userName.Value = txtUserName.Text.ToString()
cmd.Parameters.Add(userName)

Dim pwd As New SqlParameter("@Password", SqlDbType.VarChar, 50)

pwd.Value = txtPwd.Text.ToString()
cmd.Parameters.Add(pwd)

Dim email As New SqlParameter("@Email", SqlDbType.VarChar, 50)

email.Value = txtEmailID.Text.ToString()
cmd.Parameters.Add(email)

46
 Dim address As New SqlParameter("@Address", SqlDbType.VarChar, 50)
address.Value = txtAdress.Text.ToString()
cmd.Parameters.Add(address)

Dim gender As New SqlParameter("@Gender", SqlDbType.VarChar, 10)

gender.Value = rdoGender.SelectedItem.ToString()
cmd.Parameters.Add(gender)

Dim mobile As New SqlParameter("@Mobile", SqlDbType.VarChar, 10)

mobile.Value = txtmobile.Text.ToString()
cmd.Parameters.Add(mobile)

Try

cmd.ExecuteNonQuery()
lblMsg.Text = "User Registration successful,you can now <a
href='LoginVB.aspx'>Login</a>"
ClearControls(Me)
Catch ex As SqlException
Dim errorMessage As String = "Error in registring user"
errorMessage += ex.Message

Throw New Exception(errorMessage)

Finally
con.Close()
End Try
End Sub
End Class

47
Login Form
Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration
Partial Class LoginVB
Inherits System.Web.UI.Page

Protected Sub btnLogIn_Click(ByVal sender As Object, ByVal e As

System.EventArgs) Handles btnLogIn.Click
'Create Connection String And SQL Statement
Dim strCon As String =
ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString
Dim strSelect As String = "SELECT COUNT(*) FROM Users WHERE
UserName = @Username AND Password = @Password"
Dim con As New SqlConnection(strCon)
Dim cmd As New SqlCommand()
cmd.Connection = con
cmd.CommandType = CommandType.Text
cmd.CommandText = strSelect

Dim username As New SqlParameter("@Username", SqlDbType.VarChar,

50)
username.Value = txtUserName.Text.Trim().ToString()
cmd.Parameters.Add(username)

Dim password As New SqlParameter("@Password", SqlDbType.VarChar,

50)
password.Value = txtPwd.Text.Trim().ToString()
cmd.Parameters.Add(password)

con.Open()
Dim result As Integer = DirectCast(cmd.ExecuteScalar(), Int32)
con.Close()

If result >= 1 Then

Session("userName") = txtUserName.Text.ToString().Trim()
Response.Redirect("matout.aspx")
Else
lblMsg.Text = "Incorrect Username or Password"
End If

End Sub
End Class

48
Material Master
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class productentry : System.Web.UI.Page

{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void add_Click(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString =
"Server=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\material.mdf;Integrated Security=True;User Instance=True";
SqlCommand objcmd = new SqlCommand();
string query = "insert into materialmaster (Pid,Pname,Pdescription)
values ('" + pid.Text + "','" + pname.Text + "','" + pdescription.Text +
"')";
objcmd = new SqlCommand(query, myConnection);
myConnection.Open();
objcmd.ExecuteNonQuery();
Label1.Text = "Added";
myConnection.Close();
}
}

49
Material In
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class matin : System.Web.UI.Page
{
protected void ADD_Click(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString =
"Server=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\material.mdf;Integrated Security=True;User Instance=True";
DataTable dt = new DataTable();
myConnection.Open();
// SqlCommand objcmd = new SqlCommand();
SqlDataReader myReader = null;
SqlCommand myCommand = new SqlCommand("select * from materialmaster
where Pid='" + pid.SelectedItem + "'", myConnection);
myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
pname.Text = (myReader["Pname"].ToString());
pdescription.Text = (myReader["Pdescription"].ToString());

}
}
protected void MATERIALIN_Click(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString =
"Server=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\material.mdf;Integrated Security=True;User Instance=True";
SqlCommand objcmd = new SqlCommand();
string query = "insert into Materialin
(Pid,Pname,Pdescription,Qty,Price,Dateofin,Purpose) values ('" +
pid.SelectedItem + "','" + pname.Text + "','" + pdescription.Text + "','" +
qty.Text + "','" + price.Text + "','" + dateofin.SelectedDate + "','" +
purpose.Text + "')";
objcmd = new SqlCommand(query, myConnection);
myConnection.Open();
objcmd.ExecuteNonQuery();
Label1.Text = "Added";
myConnection.Close();
}
}

50
Material Out
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class matout : System.Web.UI.Page

{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void ADD_Click(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString =
"Server=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\material.mdf;Integrated Security=True;User Instance=True";
DataTable dt = new DataTable();
myConnection.Open();
// SqlCommand objcmd = new SqlCommand();
SqlDataReader myReader = null;
SqlCommand myCommand = new SqlCommand("select * from materialmaster
where Pid='" + pid.SelectedItem + "'", myConnection);

myReader = myCommand.ExecuteReader();

while (myReader.Read())
{
pname.Text = (myReader["Pname"].ToString());
pdescription.Text = (myReader["Pdescription"].ToString());
}
}
protected void MATERIALIN_Click(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString =
"Server=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\material.mdf;Integrated Security=True;User Instance=True";
SqlCommand objcmd = new SqlCommand();
string query = "insert into Matout
(Pid,Pname,Pdescription,Qty,Dept,Dateofout,Purpose) values ('" +
pid.SelectedItem + "','" + pname.Text + "','" + pdescription.Text + "','" +
qty.Text + "','" + txtDeptName.SelectedItem + "','" +
dateofout.SelectedDate + "','" + purpose.Text + "')";
objcmd = new SqlCommand(query, myConnection);
myConnection.Open();
objcmd.ExecuteNonQuery();
Label1.Text = "Added";
myConnection.Close();
}
}

51