ASSET MANAGER
1.
INTRODUCTION
Asset intensive industries face the harsh realities of operating in highly competitive markets and dealing with high value facilities and equipment where each failure is disruptive and costly. At the same time, they must also adhere to stringent occupational safety, health and environmental regulations. Maintaining optimal availability reliability and operational safety of plant, equipment, facilities and other assets is therefore essential for an organizational competitiveness.
The function of asset management are taking a fundamental turn where organizations are moving from historical reactive (run-to-failure) models and beginning to embrace whole life planning, life cycle costing, planned and proactive maintenance and other industry best practices. Asset Management is not operational excellence but instead focused on effectiveness; bring out the most of every capital investment or expense from a planning perspective. It has a long-term view, strives for balanced investment-risk-performance levels and supports data driven decision-making required for all ‘discretionary spending’. However, some companies still regard manual asset management procedure, despite the evolution of information technology, which cannot meet up the above challenges; hence the objective of this project work is to present a conceptual and practical approach for the management of asset using a computer program. This is necessary due to the accuracy, efficiency and reliability of computer in performing rigorous tasks such as manipulation and querying of large volume of data which is relevant in managing asset.
Definition
of Terms
The major variables in this work are Asset, Management, Computerization and System. The definitions of these variables are given below:
Asset – this could be defined as a person or thing that is valuable or useful to something. Banking and Finance defines asset as a thing which belongs to a company or person which has value.
Management – this could be defined as the act of running and controlling a business or similar organization.
Computerization – this word is derived from the word computerized, which means to provide a computer or computers to do the work of something.
System – this is defined as a collection or assemblage of different part or component that is connected together in an organized way in order to achieve a particular goal to satisfy a particular interest. System could also define in computer term as a collection of procedures and devices working together as a unit.
What are
Assets?
In this context the definition of asset is very broad. Anything that is used by an organization in order for it to achieve its function can be considered and asset of the organization. This will include a number of different types of assets and are classified based their characteristics. Some types of assets are listed below:
· Fixed Assets – these are assets that could last as long as the company or organization exists. They include office furniture, vehicles, etc.
· Liquid Assets – liquid assets include cash or bills that can easily be converted to cash.
· Financial Assets – these include investment and cash at hand. These kinds of assets could also be seen as claim against the income or wealth of business organization; usually represented by a certificate or legal documents, which include bonds, insurance policies, stocks, deposits etc.
However, considering the importance of financial assets in this project, it is necessary to consider some of its characteristics and categories.
Characteristics
of Financial Assets
· Financial assets cannot be depreciated
· They do not provide continuous stream of service to their owners
· They can easily be converted to another form, which could be substituted for other assets. For example shares can be converted to another form of asset desired by its owner.
Different
types of Financial Assets
Basically financial assets are divided into four groups; namely:
· Equities – this is also known as stock, which represents ownership shares in a business firm in which it could be used as claim against the firm’s success. Equities are also categorized into common stock and preferred stock. Common stock entitles its holder to vote for the members of the firm’s board of directors while preferred stock has no such privileges. Preferred Stock also known as capital stock provides a specific dividend that is paid before any dividends are paid to common stock holders, and which takes precedence over common stock in the event of liquidation.
· Money – this is any financial asset that is generally accepted as payment of the purchase of goods and services.
· Derivatives – these are the newest type of financial assets being introduced, which has unique financial claims. Its market value is influenced by the return on a related financial instrument such as loans, bonds, stock etc.
What is
Asset Management?
Asset management is a general term with many different meanings, depending on which governmental agency or organization is using it. The clerk considers asset management the appropriate recording and report of assets in accordance with generally accepted accounting principles. The finance director considers asset management as a strategic financial plan. The utility director thinks of his or her job and maintaining the utility’s infrastructure in good working order. The utility supervisor thinks of a work order system that helps plan and control resources and equipment. The Information Technology (IT) director sees asset management as another enterprise wide, integrated suite of computer software and hardware requirements. Since all of these agencies have policy criteria they are responsible to meet, designing asset management system must consider all criteria in order to be useful and successful.
What is
Computerization?
This is concern with provision of computer or computers to do the work of something. Computerization could be defined as the technological application of electrical and computer based systems to supplement the operations and control the activities of an organization. This technological application could include computer process control, feedback control, planning, data collection and decision making support facilities. Computerization aids in automation of processes that usually required tedious manual inputs and outputs.
In the light of these broad definitions Computerized Asset Management System could be seen as professional management of investments such as stocks and bonds, along with real estate by means of technological application of electrical and computer based systems to supplement the operations and control the activities of an organization.
Asset management can be relatively tedious and is error prone when using the manual system that is associated with rendering such services. However, with the use of computers, this can be easily done in record time and faster than the manual process.
In relation to the above mentioned facts, this work (Computerized Asset Management System) seeks to highlight the problems associated with the existing manual system with a view to making necessary recommendations that seek to eliminate the indices inherent problems thereby presenting the computerized system as a preferred solution.
ABSTRACT:
The record keeping routines, information tracking, complicated logistics and many other administrative procedures are all regular activities that constantly make up the core processes in the management of real and financial assets. However these processes could be quite cumbersome and inefficient when manual systems being used continue to play prominent roles in organizations that offer such services.
Basically, with the advent of Information Technology (IT), some organizations, government agencies, individuals etc. have employed various database management software including relational database and spreadsheet software for the management of assets. However, these application software are generic; hence there is need to design a system that is tailored to specific need of asset management.
Consequently, this project work finds it necessary to study and analyze the difficulties inherent in the administration and management of asset manually in organizations with a view to proposing an extensive solution to these problems.
1.1 PROJECT OVERVIEW
Modules:
·
New Asset
·
Lab
·
Software
·
Rental
·
Vendor
1.2 OBJECTIVES
AND SCOPE OF
THE PROJECT
The objectives of the study are:
· To eliminate the error associated with the existing system.
· To provide more reliable storage and retrieval of asset record through the use of computer.
· To increase information availability and accessibility.
· To enable asset managers easily estimate asset net-worth through the use of inbuilt computerized logic on asset models.
Scope of the Project
The scope of this study covers the following:
· Basic procedures and process associated with record keeping
· Availability of interactive and easy to use Graphical User Interface (GUI) with vital components in form format, which enable users to enter information about financial assets and fixed assets.
· The application includes tools that allow users to estimate the net-worth of a particular asset.
Significance of the Study
The significance of computerization of asset management system includes the following:
· Speed – computers operate at a very high speed that enables users to enter, store data and retrieve information within a very short time
· Storage – Computer has a very high storage capacity; be it internal or external storage media, which is a vital aspect of asset management.
· Accuracy – the high degree of accuracy exhibited by computer is of essence in record keeping and accounting procedures in asset management.
· Efficiency – the efficiency of computers can improve the overall efficiency of organization.
· Reduction of Complexity – the complexities in record keeping and computation of asset values can be drastically reduced by the application of some statistical tools embedded in computer systems.
· Security – computerized system offers better security facilities, which is needed in asset management to safeguard the integrity and confidentiality of vital data and information organizations.
· Error Detection and Correction – computerized systems can easily detect errors like wrong spelling or formula in processing data and suggest appropriate correction needed.
LIMITATIONS AND CONSTRAINTS OF THE
PROJECT
The following limitations and constraints were experienced:
· The project is generic in its approach to Asset Management as it is not targeted towards any specific Organization.
· Effective utilization of advanced accounting and administrative tools were intentionally omitted from our research and study specifications due to restrictions we were subject to under specified curriculum.
· Finance – this research work has been constrained by lack of funds. Hence, it was difficult to acquire some materials that would have enhanced the work.
· Time – considering the originality of this project, more time would have been required for an extensive work.
· Insufficient information – Some organizations relevant to this research work could not release some vital information for fear of compromising the integrity of their management procedures.
2. SYSTEM ANALYSIS
Analysis involved a detailed study of the current system, leading to specifications of a new system. It is also a detailed study of various operations performed by a system and their relationships within and outside the system.
System Study.
System study is the first stage of system development life cycle. This gives a clear picture of what actually the physical system is. This study is usually done in two phases. In the first phase, the preliminary survey of the system is done which helps in identifying the scope of the system. The second phase is more detailed and in-depth study in which the identification of user’s requirement and the limitations and problems of the present system are studied. It also involves checking existing system by carefully analyzing the process involved, in this case manual method of asset management.
Hence, problems noticed in the existing system prompted us to consider a better solution to the current method of manual processing.
2.1 PROBLEM STATEMENT
The application of computer in virtually all fields of human endeavor has tremendously improved the mode of operations in organizations. However, some organizations and companies still rely on manual asset management as well as record keeping, which is tedious and the procedure is cumbersome. These problems are listed below:
· Inaccurate data entry and mix-up of records
· Unavailability of accurate data-bank of records since paper is a bio-degradable material they tend to spoil with time
· Ineffective security of documents
· Long process on retrieval of record due to large volume of paper stored
· Delay in accounting and auditing proceedings due to tedious process involved in record retrieval
· Documents occupy a lot of space that could be put into other profitable use.
2.2 EXISTING
SYSTEM AND ITS LIMITATIONS
The Existing system is manual system where
information was maintained in records etc
Whenever any information was required there was
a need for referring to previous records.
The
information may not be available in one record and there may occur the
possibility if no-availability of information for instance.
The
records may be lost or the records may corrupt.
Limitations of Existing
System:
Time Consumption.
High human Resource.
No powerful Decision tools
2.3 PROPOSED SYSTEM
To overcome the drawback’s of existing system.
As the volume of the data grows it becomes difficult to handle the system
manually. Computerization of the process is carried out after analyzing all the
details of the employees. The proposed system definitely increases the speed of
work, gives reliable storage and very good retrieval facility.
User will have the complete control over the
data and appropriate validations are done.
Access of the data is very easy
We can easily manipulate with data.
Advantages
We can easily manipulate with data.
The data validation is done efficiently.
Efficient processing capability of information
system makes easy and affordable to obtain the required information.
Accurate information as per user requirement can
be obtained by user of the system so that the management can make decisions at
right time.
2.4 FEASIBILITY STUDY
Feasibility Study. On the basis of result of the initial study,
feasibility study takes place. The feasibility study is basically the test of
the proposed system in the light of its workability, meeting user’s
requirements, effective use of resources and of course the cost effectiveness.
2.4.1 TECHNICAL
FEASIBILITY
Evaluating the technical feasibility is
the trickiest part of a feasibility study. This is because at this point in
time, not too many-detailed design of the system are present, making it
difficult to access issues like performance, costs on (on account of the kind
of technology to be deployed) etc. A number of issues have to be considered
while doing a technical analysis.
Understand the different technologies involved in the
proposed system:
Before
commencing the project, we have to be very clear about what are the
technologies that are to be required for the development of the new system.
Find out whether the organization currently possesses
the required technologies:
Is the
required technology available with the organization? If so is the capacity sufficient?
For instance:
“Will the
current printer be able to handle the new reports and forms required for the
new system?”
2.4.2 OPERATIONAL FEASIBILITY
Proposed projects are beneficial only if
they can be turned into information systems that will meet the organizations
operating requirements. Simply stated, this test of feasibility asks if the
system will work when it is developed and installed. Are there major barriers
to Implementation? Here are questions that will help test the operational
feasibility of a project:
Is there
sufficient support for the project from management from users? If
The current
system is well liked and used to the extent that persons will not be able to
see reasons for change, there may be resistance.
Are the current
business methods acceptable to the user? If they are not,
Users may
welcome a change that will bring about a more operational and useful systems.
Have the user
been involved in the planning and development of the project?
Early
involvement reduces the chances of resistance to the system and in general and
increases the likelihood of successful project.
Since the
proposed system was to help reduce the hardships encountered in the existing
manual system, the new system was considered to be operational feasible.
2.4.3 ECONOMIC
FEASIBILITY
Economic feasibility attempts 2 weigh
the costs of developing and implementing a new system, against the benefits
that would accrue from having the new system in place. This feasibility study
gives the top management the economic justification for the new system.
A simple economic analysis which
gives the actual comparison of costs and benefits are much more meaningful in
this case. In addition, this proves to be a useful point of reference to
compare actual costs as the project progresses. There could be various types of
intangible benefits on account of automation. These could include increased
customer satisfaction, improvement in product quality better decision making
timeliness of information, expediting activities, improved accuracy of
operations, better documentation and record keeping, faster retrieval of
information, better employee morale.
3. SYSTEM
SPECIFICATION
System Architecture
The proposed system combine page layout with application content to create sophisticated database-driven windows forms with controls, validation and security.
- Presentation Layer – The system comprises windows (forms)-based user interface, including data validation logic for built-in field types. An extensive set of intelligent field types is supported providing built-in validation for data types like email addresses, currency, and phone numbers
- Business Layer - The Business layer is where the bulk of business logic resides.
- Data-Access Layer – the application’s data access code, table sorting logic, table filtering logic etc are all part of this layer. It includes SQL statements and queries needed for storing retrieving, and filtering data from the database.
- Database Layer – This is the actual RDBMS and objects of the database such as SQL Queries, Views, and Stored Procedures.
System
Requirement
This consists of the hardware and software requirements needed
for the proposed system to operate at a maximum efficiency.
3.1 The Hardware Requirements
·
Pentium 4 2.4 GHz
·
80GB Hard disk drive
·
512 MB RAM
·
BIOS standard with embedded extensions (Basic
input/ Output system)
3.2 The Software Requirement
·
Window XP embedded
with service pack 2
·
Database Software
(MsSQLserver2000)
- Visual Basic.Net
The final stage of implementation is the conversion of the system. At this stage, manual working has to shift from manual to computerized working. Basically, two strategies are applied on conversion process, which are Pilot and Parallel. In Pilot run or conversion strategy, the new system is installed in parts. Some part of the new system is installed first and executed successfully for considerable time period. When the results are found satisfactory that other parts are implemented. While in Parallel conversion, both the computerized and manual systems are executed in parallel. This strategy is recommended for the implementation of this project because of the following benefits:
· Manual results can be compared with the results of the computerized system.
Failure of the computerized system at the early stage, does not affect the working of the organization, because the manual system continues to work, as it used to do.
3.3 BRIEF OVERVIEW OF SOFTWARE TOOLS
Environment:
After analyzing the requirements of the task
to be performed, the next step is to analyze the problem and understand its
context. The first activity in the phase is studying after analyzing the
requirements of the task to be performed, the next step is to the existing
system and other is to understand the requirements and domain of the new
system. Both the activities are equal important, but the first activity serves
as a basis of giving the financial specifications and then successful design of
the proposed system. Understanding the properties and requirements of a new
system is more difficult and requires creative thinking and understanding of
existing running system is also difficult, improper understanding of present
system can lead diversion from solution.
ABOUT VB.NET
Visual Studio .NET is a complete set of development tools for building ASP web applications, XML web services, desktop applications and mobile applications. Visual Basic .NET, Visual C++ .NET and Visual C# .NET all use the same Intergraded Development Environment (IDE), which allows them to share tools and facilitates in the creation of mixed-language solutions.
Visual studio 2005 is the latest IDE from Microsoft to facilitate building .NET components and applications. Visual Studio 2005 building on Visual Studio .NET 2003, provides one of the best development environments for coding your ASP.NET applications.
The .NET
Framework
.NET is a software framework that includes everything required for developing software for web services. It integrates presentation technologies, component technologies and data technologies on a single platform so as to enable users to develop Internet applications as easily as they do on desktop systems. The NET is a multi-language environment for building, deploying and running XML web services and applications. Intermediate Language (IL) allows for true cross language integration.
.NET Framework consists of three distinct technologies such as
Common Language Runtime (CLR)
Framework Base Classes
User and program interfaces (ASP.NET and Windows
forms)
Principal
design features
Interoperability
Because interaction between new and older applications is commonly required, the .NET Framework provides means to access functionality that is implemented in programs that execute outside the .NET environment. Access to COM components is provided in the System. Runtime Interpol Services and System. Enterprise Services namespaces of the framework; access to other functionality is provided using the P/Invoke feature.
Common Language Runtime
Common Language Runtime (CLR) is a runtime environment in which programs written in C# and other .NET languages are executed. It also supports cross-languages interoperability.
The CLR provides a number of services that include
Loading and execution of programs.
Memory isolation for applications.
Verification of type safety.
Compilation of IL into native executable code.
Memory management (automatic garbage collection).
Interoperability with other systems.
Managing exceptions and errors.
Support for tasks such as debugging and Profiling.
Common Type System (CTS)
The .NET framework provides multiple language support using the feature known as Common Type System that is built into the CLR. The CTS supports a variety of types and operations found in most programming languages and therefore calling one language from another does not require type conversions. C# language is specially designed for the .NET platform, but we can build .NET programs in a number of other languages including C++ and Visual Basic.
Common Language Specification (CLS)
The Common Language Specification defines a set of rules that enables interoperability on the .NET platform. These rules serve as a guide to third-party compiler designers and library builders. The CLS is a subset of CTS and therefore the language supporting the CLS can use each other’s class libraries as if they are their own.
Microsoft Intermediate Language (MSIL)
MSIL or simply IL, is an instruction set into which all the .NET programs are compiled. It is similar to assembly language and contains instructions for loading,
Storing, initializing and calling methods. When we compile a C# or any program written in a CLS-compliant language, the source code is compiled into MSIL.
Framework Base Classes
.NET supplies a library of base classes that we can use to implement applications quickly. Much of the functionality in the base framework classes resides in the vast
namespace called System. We can use the base classes in the System namespace for many different tasks including
Input/output Operations
String handling
Managing arrays, lists, maps, etc.
Accessing files and file systems
Security
Windowing
Database management
Evaluation of mathematical functions
Drawing
Managing errors and exceptions
Connecting to the Internet
Simplified
Deployment
Installation of computer software must be carefully managed to ensure that it does not interfere with previously installed software, and that it conforms to security requirements. The .NET framework includes design features and tools that help address these requirements.
Security
The design is meant to address some of the vulnerabilities, such as buffer overflows, that have been exploited by malicious software. Additionally, .NET provides a common security model for all applications.
Portability
The design of the .NET Framework allows it to theoretically be platform agnostic, and thus cross-platform compatible. That is, a program written to use the framework should run without change on any type of system for which the framework is implemented. Microsoft's commercial implementations of the framework cover Windows, Windows CE, and the Xbox 360. In addition, Microsoft submits the specifications for the Common Language Infrastructure (which includes the core class libraries, Common
Type System, and the Common Intermediate Language), the C# language, and the C++/CLI language to both ECMA and the ISO, making them available as open standards. This makes it possible for third parties to create compatible implementations of the framework and its languages on other platforms.
FEATURES OF VB.NET
Full support for Object Oriented Programming
Structured error handling Capabilities.
Access to NET Frame work.
Powerful unified Integrated Development
Environment [IDE]
Better windows application with windows forms.
New console capabilities of VB.NET.
New Web capabilities with Web forms.
Immense power of tools & controls.
Interpretability with other .NET complain languages.
Better database programming approach ADO.NET.
ABOUT SQL SERVER
Microsoft SQL Server is an application used to create computer databases for the Microsoft Windows Family of server operating System. It provides an environment used to generate databases that can be accessed from workstations, the web, or other media such as personal digital assistant (PDA).
Microsoft SQL Server is probably the most accessible & the most documented enterprise database environment right now. This also means that you can learn it a little quicker than most other databases environments on the market.
SQL Server is a Relational Database Management system. It is the product of Microsoft. The version of SQL used by SQL Server is called Transact-SQL.
SQL Server is one such RDBMS that Support the client server architecture. It receives request from the clients for data and returns the result of the processed query. Many client software are available that are supported by SQL- Server. Transact-SQL is one such client that could be used only with SQL Server. All the SQL statements are submitted to the Transact-SQL which on receiving them passes it on to the SQL server. It also receives.
FEATURES OF SQL-SERVER
Adding objects to the database
New administrative options like moving tables
between table Spaces.
Many new DBMS packages.
COPY
option
Smart SQL loader options
4. SYSTEM DESIGN
4.1 OBJECT ORIENTED ANALYSIS
Analysis involved a detailed study of the current system, leading to specifications of a new system. It is also a detailed study of various operations performed by a system and their relationships within and outside the system.
System Study. System study is the first stage of system development life cycle. This gives a clear picture of what actually the physical system is. This study is usually done in two phases. In the first phase, the preliminary survey of the system is done which helps in identifying the scope of the system. The second phase is more detailed and in-depth study in which the identification of user’s requirement and the limitations and problems of the present system are studied. It also involves checking existing system by carefully analyzing the process involved, in this case manual method of asset management.
Hence, problems noticed in the existing system prompted us to consider a better solution to the current method of manual processing.
Feasibility Study. On the basis of
result of the initial study, feasibility study takes place. The feasibility
study is basically the test of the proposed system in the light of its
workability, meeting user’s requirements, effective use of resources and of
course the cost effectiveness.
The word system covers a very broad spectrum of concepts. This is derived from the Greek word “System” which means an organize relationship among the functioning units or components. In our daily life we need to come with the communication system and the computer system.
System analysis and design refers to the process of examining a business situation with the system development can generally thought of as having two major components.
System Analysis
System Design
The logical development of user requirements, into system concepts, and system specification through the knowledgeable application of state-of-the-art technology and evaluation criteria applied in analytical trade-off analysis.
First the problem of the user should be understood. Requirements analysis is the first technical step in the software process. It is at this point that a general statement of software scope is refined into a concrete specification that becomes the foundation for all software engineering activities that fallow. Analysis must focus on information, functional, and behavioral domains of a problem. It is essential to establish to establish error to prevent to prevent errors on in the system life cycle.
OBJECT
ORINTED DESIGN
Design in the first step in the development phase for any engineering products or system it may be defined as the process of applying various technique and principle for the purpose of defining a device process or a system in sufficient detail to permit its physical realization. When designing the system the points taken care are identify the data to be stored identify the reports to be generated. The potential objects are thoroughly analyzed class hierarchies and identified to check the system a behaving the way it has to there after the classes are individually tested and subsequently they are integrated to form the overall system the different phases are:
1. Input design: The screen in this project are designed using the C#.Net
2. Output design: The output design include providing various user friendly views and reports this are involves reports based on the user requirements
3. Database design: Database design is a process of creation of database. Proper database design is absolutely vital to the success of the database and any application using the database. Without designing correctly, the following problems can be introduced into the database. Data becomes redundant and a large burden is placed on the individual applications to keep the data in synchronization.
Based on the user requirements and the detailed analysis of a new system, the new system must be designed. In the design of the proposed system, the following specific requirements are considered.
Specification Requirement
Input Specification - Considering the proposed system various input are required by the user such as Username, password, new asset acquired including its type, value,
Location, date etc. However these input data has to be specified so that the computer can carry on necessary manipulation.
Output Specification/Expectation
Expected output includes windows-based forms for data entry and manipulation, validation, security, and hard copy reports printing features on assets.
File and Storage Requirements - Data is stored on a relational database; the data base software used is Microsoft SQL Server2002. The storage device used for the proposed system is hard drive.
Control and backups – the security and control facilities of the proposed system ensure the accuracy, security and privacy of the software resources. Control and backups control for the proposed system include:
- Requirement of password for access
- Software checks
- Periodic backup copies of the system
Personnel and Procedure – The proposed software is going to be used by client and company’s administrator; hence there would be need to hire the service of a database manager.
6. PSEUDO
CODE
Coding
This refers to the process of writing the program instructions that will process the data and produce the output specified in the program design.
Analysis of some
VB.Net code
·
Imports System.Data
·
Imports
System.Data.SqlClient
·
Imports
System.Data.OleDb
These objects enable you to interface with all sorts of
data sources, from text files to Microsoft SQL Server, to Oracle, or even with
custom data sources created by the programmer.
Login Form
Code
Imports System.Data
Imports System.Data.OleDb
Public Class
LoginBox
Dim con As New
OleDbConnection("Provider=SQLNCLI.1;Data
Source=.;Integrated Security=SSPI;Initial Catalog=Aptman")
Dim adap As OleDbDataAdapter
Dim ds As New DataSet
'The below code
is been used to achive the Login Feature
Private Sub OK_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles OK.Click
ds.Clear()
adap = New
OleDbDataAdapter("select * from login where
uname='" & UsernameTextBox.Text & "'
and upass='" & PasswordTextBox.Text & "'", con)
adap.Fill(ds, "Login")
If
(ds.Tables(0).Rows.Count = 0) Then
MsgBox("Invalid
User Name or Password", MsgBoxStyle.Critical, "Invalid user Credentials")
Else
Form1.valid = True
UserName = UsernameTextBox.Text
Form1.UnLock() 'The Unlock method of the form is called to enable the Menus.
Me.Close()
End If
End Sub
Private Sub Cancel_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles Cancel.Click
Me.Close()
End Sub
Asset
Form code
Imports System.Data
Imports System.Data.OleDb
Imports Asset_Manager.AllMethods
Public Class
CreateAsset
Dim com As New OleDbCommand
Dim con As New
OleDbConnection("Provider=SQLNCLI.1;Data
Source=.;Integrated Security=SSPI;Initial Catalog=Aptman")
Dim ds As New DataSet
Dim adap As New
OleDbDataAdapter()
Private Sub AddNewAsset(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
If
AllMethods.Vaildate(proname, ErrorProvider1, "Cannot
Keep Product Name Blank") = False Or AllMethods.Vaildate(labName, ErrorProvider1, "Cannot Keep Lab Name Blank") = False Or
AllMethods.Vaildate(AsSrno, ErrorProvider1, "Cannot
Keep Asset Code Blank") = False Or AllMethods.Vaildate(AsName, ErrorProvider1, "Cannot Keep Asset Name Blank") = False Then 'Calling the Validate method of the AllMethods Class to
Validate the Form
Exit
Sub
End If
Try
con.Open()
com.Connection = con
com.CommandText = "insert into asset values('" & proname.Text &
"','" & AsSrno.Text & "','" & labName.Text & "','" & AsName.Text & "')" 'Inserting
Records in the DataBase
com.ExecuteNonQuery()
MsgBox("Asset
Added Successfully", MsgBoxStyle.OkOnly, "Added
Successfully")
ds.Clear()
CreateAsset_Load(sender, e)
proname.SelectedIndex = -1
proname.SelectedIndex = 0
Catch
ex As Exception
MsgBox("Some
Error Occurred " & vbNewLine & "
Please Check Application Log", MsgBoxStyle.Critical, "ERROR")
Finally
con.Close()
End Try
End Sub
Private Sub proname_SelectedIndexChanged(ByVal sender As
System.Object, ByVal e As
System.EventArgs) Handles
proname.SelectedIndexChanged
GenSerial()
If
ds.Tables("SER").Rows.Count = 0 Then
AsSrno.Text = proname.Text & "-01"
Else
AsSrno.Text = proname.Text & "-0" & (ds.Tables("SER").Rows.Count + 1)
End If
End Sub
Private Sub LinkLabel1_LinkClicked(ByVal
sender As System.Object, ByVal e As
System.Windows.Forms.LinkLabelLinkClickedEventArgs) Handles
LinkLabel1.LinkClicked
productdetails.asset = True
productdetails.MdiParent = Form1
Me.Close()
productdetails.Show()
End Sub
Sub
FillCombo()
com.CommandText = "select * from product"
com.Connection = con
adap.SelectCommand = com
adap.Fill(ds, "PRO")
com.CommandText = "select * from labdetails"
com.Connection = con
adap.SelectCommand = com
adap.Fill(ds, "LAB")
labName.DataSource = ds.Tables("LAB")
labName.DisplayMember = ds.Tables("LAB").Columns(1).Caption
proname.DataSource = ds.Tables("PRO")
proname.DisplayMember = ds.Tables("PRO").Columns(0).Caption
If
labName.Items.Count = 0 Then
labName.SelectedIndex = -1
Else
proname.SelectedIndex = 0
End If
If
proname.Items.Count = 0 Then
proname.SelectedIndex = -1
Else
proname.SelectedIndex = 0
End If
End Sub
Private Sub CreateAsset_Load(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
FillCombo()
GenSerial()
NoRec()
If
proname.SelectedIndex <> -1 Then
proname.SelectedIndex = 0
ElseIf
proname.SelectedIndex = 0 Then
proname.SelectedIndex = 1
proname.SelectedIndex = 0
End If
AsName.Text = ""
End Sub
Sub NoRec()
If
ds.Tables("PRO").Rows.Count = 0 Then
MsgBox("No
Products In Products Table Cannot Add Asset", MsgBoxStyle.Critical,
"No Products Available")
Button1.Enabled = False
End If
If
ds.Tables("LAB").Rows.Count = 0 Then
MsgBox("No
Lab Details In Database Cannot Add Asset", MsgBoxStyle.Critical, "No Products Available")
Button1.Enabled = False
End If
End Sub
Dim asnames As String
Private Sub labName_SelectedIndexChanged(ByVal sender As
System.Object, ByVal e As
System.EventArgs) Handles
labName.SelectedIndexChanged
GenName()
If ds.Tables("ASNAME").Rows.Count = 0 Then
AsName.Text = labName.Text & "-" & proname.Text & "-01"
Else
AsName.Text = labName.Text & "-" & proname.Text & "-0" & (ds.Tables("ASNAME").Rows.Count + 1)
End If
End Sub
Product Form code
Imports System.Data
Imports System.Data.OleDb
Public Class
productdetails
Dim com As New OleDbCommand
Dim con As New
OleDbConnection("Provider=SQLNCLI.1;Data
Source=.;Integrated Security=SSPI;Initial Catalog=Aptman")
Dim ds As New DataSet
Dim adap As OleDbDataAdapter
Private Sub AddProduct(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
If
AllMethods.Vaildate(proname, ErrorProvider1, "Product
Name Required") = False Or AllMethods.Vaildate(proDis, ErrorProvider1, "Product Discribtion Required") = False Then
Exit
Sub
End If
Try
com.CommandText = "insert into product values('" &
UCase(proname.Text) & "','"
& proDis.Text & "')"
com.Connection = con
con.Open()
com.ExecuteNonQuery()
MsgBox("New
Product Added Successfully" & vbNewLine & "To Maintain Stock Goto Asset Management -->
Stock", MsgBoxStyle.OkOnly, "Added
New Product")
con.Close()
com.CommandText = "insert into stock values('" &
UCase(proname.Text) & "',0)"
con.Open()
com.ExecuteNonQuery()
con.Close()
com.CommandText = "insert into NotWorking values('" &
UCase(proname.Text) & "',0)"
con.Open()
com.ExecuteNonQuery()
con.Close()
Catch
ex As Exception
MsgBox("Some
Error Occured While Adding Records in The Database" & vbNewLine
& "Please Check The Application Log",
MsgBoxStyle.Critical, "Error In
Application")
End Try
End Sub
Public
asset As Boolean
Private Sub productdetails_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing
If
asset = True Then
CreateAsset.MdiParent = Form1
CreateAsset.Show()
End If
End Sub
Private Sub Button2_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles Button2.Click
Me.Close()
End Sub
End Class
Lab Form code
Imports System.Data
Imports System.Data.OleDb
Public Class
LabDetails
Dim com As New OleDbCommand
Dim con As New
OleDbConnection("Provider=SQLNCLI.1;Data
Source=.;Integrated Security=SSPI;Initial Catalog=Aptman")
Dim ds As New DataSet
Dim adap As New OleDbDataAdapter
Private Sub AddLabDetails(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
'If
AllMethods.Vaildate(LabCode, ErrorProvider1, "Lab Code Required") =
False Or AllMethods.Vaildate(LabName, ErrorProvider1, "Lab Name
Required") = False Or AllMethods.Vaildate(LabDisc, ErrorProvider1,
"Lab Discription Required") = False Then
' Exit Sub
'End If
Try
com.CommandText = "insert into LabDetails values('" &
LabCode.Text & "','" &
UCase(LabName.Text) & "','"
& LabDisc.Text & "')"
MsgBox("Added
Successfully", MsgBoxStyle.OkOnly, "LAB
Details Added")
com.Connection = con
con.Open()
com.ExecuteNonQuery()
con.Close()
Catch ex As Exception
Finally
con.Close()
LabDetails_Load(sender, e)
End Try
End Sub
Private Sub Button2_Click(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles Button2.Click
Me.Close()
End Sub
Private Sub LabDetails_Load(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
com.CommandText = "select * from labdetails"
com.Connection = con
adap.SelectCommand = com
adap.Fill(ds, "LABS")
If ds.Tables("LABS").Rows.Count = 0 Then
LabCode.Text = "LAB - 01"
Else
LabCode.Text = "LAB - 0" & ds.Tables("LABS").Rows.Count + 1
End If
End Sub
End Class
Software Form code
Imports System.Data
Imports System.Data.OleDb
Public Class
SoftwareDetalis
Dim com As New OleDbCommand
Dim con As New
OleDbConnection("Provider=SQLNCLI.1;Data
Source=.;Integrated Security=SSPI;Initial Catalog=Aptman")
Dim ds As New DataSet
Dim adap As New
OleDbDataAdapter
Private Sub AddSoftware(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
If
AllMethods.Vaildate(SofName, ErrorProvider1, "Software
Name Required") = False Or AllMethods.Vaildate(sofType, ErrorProvider1, "Software Type Required") = False Then
Exit
Sub
End If
com.CommandText = "insert into SoftwareDetails values('"
& SofName.Text & "','"
& sofType.Text & "',"
& noDis.Value & "," &
noCop.Value & ")"
com.Connection = con
con.Open()
com.ExecuteNonQuery()
MsgBox("Added
Successfully", MsgBoxStyle.OkOnly, "Software
Details Added")
SofName.Text = ""
sofType.SelectedIndex = 0
noCop.Value = 1
noDis.Value = 1
con.Close()
End Sub
Sub
getSoftType()
com.CommandText = "select * from softwaretype"
com.Connection = con
adap.SelectCommand = com
adap.Fill(ds, "SOFT")
sofType.DataSource = ds.Tables("SOFT")
sofType.DisplayMember = ds.Tables("SOFT").Columns(0).Caption
End Sub
Private Sub SoftwareDetalis_Load(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
getSoftType()
End Sub
Vendor Form Code
Imports System.Data
Imports System.Data.OleDb
Public Class
VendorDetails
Dim com As New OleDbCommand
Dim con As New
OleDbConnection("Provider=SQLNCLI.1;Data
Source=.;Integrated Security=SSPI;Initial Catalog=Aptman")
Dim ds As New DataSet
Dim adap As OleDbDataAdapter
Private Sub AddVen(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
If
AllMethods.Vaildate(venName, ErrorProvider1, "Vendor
Name is Required") = False Or AllMethods.Vaildate(venCon, ErrorProvider1, "Vendor Contact Number Required") = False Or
AllMethods.Vaildate(venAddr, ErrorProvider1, "Vendor
Address Required") = False Then
Exit
Sub
End If
com.CommandText = "insert into vendorDet values('" &
UCase(venName.Text) & "','"
& venCon.Text & "','"
& venAddr.Text & "')"
MsgBox("Added
Successfully", MsgBoxStyle.OkOnly, "Vendor
Details Added")
com.Connection = con
con.Open()
com.ExecuteNonQuery()
con.Close()
End Sub
End Class
SOFTWARE TYPE FORM CODE
Imports System.Data
Imports System.Data.OleDb
Public Class
sType
Dim com As New OleDbCommand
Dim con As New
OleDbConnection("Provider=SQLNCLI.1;Data
Source=.;Integrated Security=SSPI;Initial Catalog=Aptman")
Dim ds As New DataSet
Dim adap As New
OleDbDataAdapter
Private Sub AddType(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
If
AllMethods.Vaildate(SofType, ErrorProvider1, "Software
Type Required") = False Or AllMethods.Vaildate(sofDis, ErrorProvider1, "Software Discribtion Required") = False Then
Exit
Sub
End If
com.CommandText = "insert into Softwaretype values('"
& SofType.Text & "','"
& sofDis.Text & "')"
MsgBox("Added
Successfully", MsgBoxStyle.OkOnly, "Softwaretype
Details Added")
com.Connection = con
con.Open()
com.ExecuteNonQuery()
con.Close()
End Sub
Private Sub Button2_Click(ByVal
sender As System.Object, ByVal e As System.EventArgs)
Handles Button2.Click
Me.Close()
End Sub
End Class
STOCK DETAILS FORM CODE
Public Class
Stock_details
Private Sub Stock_details_Load(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
'TODO: This
line of code loads data into the 'AptManDataSet6.Stock' table. You can move, or
remove it, as needed.
Me.StockTableAdapter.Fill(Me.AptManDataSet6.Stock)
End Sub
Private Sub Button1_Click(ByVal
sender As System.Object, ByVal e As System.EventArgs)
Handles Button1.Click
If
AptManDataSet6.HasChanges Then
Try
StockTableAdapter.Update(AptManDataSet6.Stock)
Catch
ex As Exception
MsgBox("Some
Error Occured While Updating Stock Details" & vbNewLine & "Technical Staff Please Check The Error Log",
MsgBoxStyle.OkOnly, "Error In
Application")
End
Try
Else
MsgBox("No
Changes Have Been Made. Nothing To Update",
MsgBoxStyle.Information, "No Changes Have Been
Made")
End If
End Sub
Private Sub DataGridView1_DataError(ByVal
sender As Object,
ByVal e As
System.Windows.Forms.DataGridViewDataErrorEventArgs) Handles
DataGridView1.DataError
MsgBox("Error
Occured in Row{" & e.RowIndex + 1 & "} and Column{" & e.ColumnIndex + 1 & "}" & vbNewLine & "Reason For Error : " &
e.Exception.Message, MsgBoxStyle.Critical, "Error
")
End Sub
End Class
VIEW SOFTWARE’s FORM CODE
Public Class
View_Softwares
Private Sub View_Softwares_Load(ByVal
sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
'TODO: This
line of code loads data into the 'AptManDataSet3.SoftwareDetails' table. You
can move, or remove it, as needed.
Me.SoftwareDetailsTableAdapter.Fill(Me.AptManDataSet3.SoftwareDetails)
End Sub
Private Sub DataGridView1_CellContentClick(ByVal sender As
System.Object, ByVal e As
System.Windows.Forms.DataGridViewCellEventArgs) Handles
DataGridView1.CellContentClick
End Sub
End Class
7. TESTING AND
IMPLEMENTATION
Software testing is a critical element of software quality assurance and represents the ultimate review of specification, design and coding. In fact, testing is the one step in the software engineering process that could be viewed as destructive rather than constructive.
A strategy for software testing integrates software test case design methods into a well-planned series of steps that result in the successful construction of software. Testing is the set of activities that can be planned in advance and conducted systematically. The underlying motivation of program testing is to affirm software quality with methods that can economically and effectively apply to both strategic to both large and small scale systems.
SOFTWARE TESTING
In system testing, the software and other elements are tested as whole software once validated, must be combined with other system elements (e.g. hardware, people and database). System testing verifies that all elements mesh properly and overall system function/performance is achieved system testing is actually a series of different tests whose primary purpose is to fully exercise the computer based. Although each test has a different purpose, all wok to verify that all system elements have been properly integrated and perform allocated functions.
Testing tried to make sure that the product does exactly what is supposed to do testing is the final verification and validation activity within the organization itself. In the testing stage try to achieve the following goals:
To affirm the quality of their product
To find and eliminate any residual errors from
previous stages,
To validate the software as a solution to the
original problem
To demonstrate the presence of all specified
functionality in the product to estimate the operational reliability of the
system. During testing the major activities are concentrated on the examination
and modification of it source code.
The following are the Testing Methodologies:
Unit
Testing:
Unit testing focuses verification effort on the smallest unit of software design that is the module. Unit testing exercises specific paths in a module’s control structure to ensure complete coverage and maximum error detection. This test focuses on each module individually ensuring that it functions properly as a unit. Hence the naming is unit testing her each module is tested individually
Integration
Testing:
It is a systematic technique for constructing different program module in to an integrated software structure. This test uncovers the errors during the entire module and validated.
Output
testing:
Output testing is done to verify whether the given output is right or wrong. Some time the output will be wrong to come out of this problem this testing is done.
Validation
Testing:
After the culmination of integration testing to software is ready as per the specification. But it has to be validated as per the specification and uncover the
Unexpected future errors and to improve its reliability. The random value and boundary values as input is fed to the software developed and studied the software performance and validated.
FUTURE
ENHANCEMENT
This project is having a broad future scope as it can extend. This developed system has to good extend succeeded in rectifying the problems that are present in the manual system. The newly developed system consumes less processing time and reduces the manual work.
The goals have been achieved by the development of this project are:
It simplifies the operation.
The less Processing time increase the productivity.
Avoids errors by minimizing human intervention.
User friendly screens to enter the data and require the data.
Help message to operate the system.
Reduce more manpower requirements.
Reduce processing time.
Reduce use of stationary
IMPLEMENTATION
The objective of this maintenance work is to make sure that the system gets into work all time without any bug. Provision must be for environmental changes which may affect the computer or software system. This is called the maintenance of the system. Now a day there is a rapid change in the software world. Due to this rapid change, the system should be capable of adopting these changes. In our project the process can be added without affecting other parts of the system. Maintenance plays a vital role. The system liable to accept any modification after its implementation. This system has been designed
to favor all new changes. Doing this will not affect the system’s performance or its accuracy.
Implementation is the stage of a project during which theory is turned into practice. This stage includes software acquisition and development, personnel hiring and training, site preparation and data preparation, installation, testing etc. The stages for implementing the proposed system are listed enumerated below:
Language of Implementation
The programming language used is Microsoft’s Visual Basic. VB.NET is an offshoot of Visual Basic programming language developed by Microsoft. It is one of the fourth generation Object Oriented Programming Languages, as against Visual Basic that is largely a procedural language. VB.NET is the only .NET language that supports late binding. In the VS.NET IDE, VB.NET provides a dropdown list at the top of the code window with all the objects and events; the IDE does not provide this functionality for any other language. VB.NET is also unique for providing default values for optional parameters, and for having a collection of the controls available to the developer.
Update and Maintenance of System
Since humans and their demands are dynamic, the system needs to be maintained and updated frequently to adapt to the ever-changing technological world and the changing environment.
Periodic updating of the computerized asset management system is necessary with the assistance of a system programmer, system designer and database administrator to ensure that no corrupt hardware or software has been installed in the system.
Also needed is virus protection software to safeguard the system from falling victim to many types of viruses e.g. a Trojan Horse and worms. (A virus is simply malicious software that is intended to infiltrate a computer system and corrupt it).
Username and password of administrator should be kept secret, as exposure of this detail would allow unauthorized users access to the database, thus exposing the financial details of clients.
A periodic update of the database is needed to keep the system up to date, as the need arises. The maintenance process would also involve correcting errors as and when they occur, documentation of the system updates and corrections.
8. CONCLUSION
This software is developed to overcome
the problems in the present system. This software is a more user friendly. It
is developed using VB.NET language
as a front-end and SQL Server
database as back-end whose friendliness has already been described. It is
successfully working integrated with the consents workflow product.
9. BIBLIOGRAPHY
1. Microsoft
visual Basic.NET
By: Michael
Halvorson
Step by Step
Publisher:
Microsoft Press
2. Microsoft
visual Basic.NET
By: Michael Halvorson
Deluxe learning Edition
Publisher: Microsoft Press
3. Learning
VB.NET (2nd Edition)
By: Richards Blair et al
Publisher: Worx
Press
4. Microsoft
SQL Server
By: Robert Vieira
Web Sites:
Comments
Post a Comment