customer relationship management
TRANSCRIPT
Enrich Tool for Customer Relation Management
SYNOPSIS
“Customer Relationship Management Application” is a process or
methodology used to learn more about customers' needs and behaviors in order to
develop stronger relationships with them. There are many technological components to
CRM, but thinking about CRM in primarily technological terms is a mistake. The more
useful way to think about CRM is as a process that will help bring together lots of pieces
of information about customers, sales, marketing effectiveness, responsiveness and
market trends.
Customer Relationship Management helps businesses use technology and human
resources to gain insight into the behavior of customers and the value of those customers.
One of sections in the CRM is the Marketing and the telemarketing Section. The
responsibility of the marketing division includes creating new Leads. By launching a
campaign a list of prospect companies that can use our products can be purchased.
Thus we can create accounts, which contain the entities that we do business. They
can be either Leads or Customers. A Lead is an Account that has not yet been fully
qualified by the Sales Department. An Opportunity is a chance to get a new business.
During the second stage of contact management, a Lead can be converted to an
Opportunity. The Calendar graphically represents the events of each day. An appointment
is an item on the calendar that has a date, start time and end time.
1
Enrich Tool for Customer Relation Management
PROJECT DESCRIPTION
The project “Customer Relationship Management Application” has been
developed using Asp .net as front end tool and SQL server as back end as its back end
process.
This application is a fully integrated solution for managing marketing and
campaign management, sales and customer support functions such as helpdesk and
general support services.
The Customer RM application suite supports the following functional areas:
1. Marketing Campaigns and telemarketing Database.
2. Contact Management including Accounts, Contacts and History.
3. Time Management with a full featured Calendar and to-do List.
4. Sales Force Automation including Opportunity Management, Forecasting and
reporting.
5. Customer Support including Service Requests, Tickets and RMA's and a
searchable Knowledge Base.
6. Integration with Microsoft Office, e- mail and Outlook contacts and Calendar.
7. Telephony Support and Seamless Internet Integration.
All opportunities are tracked throughout the sales cycle. Detailed activity logs are
maintained to provide an account history of each contact and their role in opportunity,
interest level, purchase time frames and required follow up activities. Each time we open
an opportunity, the potential and the weighted fields are automatically updated by
calculating the gross potential for all the forecasts associated with the opportunity.
Expenses can be tracked for an opportunity and can also be attached to an account and
contact. A report displays fields from one or more categories in a row column format.
2
Enrich Tool for Customer Relation Management
They can be viewed in a horizontal or vertical format. A document opens a web page as a
view window on the Commence desktop. The document displays the HTML content
within the Commence application.
Support Managers and customer support and service representatives need access
to an account’s history as soon as the phone rings. Commences Support Application
provides complete service and support functionality including call tracking, contract
maintenance, problem resolution and knowledge base management.
Modules:
Admin
Register Products
Marketing
Service
Sales
Customer Reports
Customer
Order Product
Company Service
View Message
View Answers
Modules Description
Admin:
Register Products:
The admin stores all the new products with full catalog for the products.
The Customer can view all the products and can ask query or order the products.
3
Enrich Tool for Customer Relation Management
Marketing:
CRM aligns marketing processes and drive customer demand using
functionality to enhance management of marketing resources, segments and lists,
campaigns, leads, trade promotions, and marketing analytics.
Service:
CRM can drive service revenue and profitability with support for service
sales and marketing. More effectively manage service orders, contracts,
complaints and returns, in-house and depot repairs, warranties, resource planning,
e-service, and service analytics. Functionality to support call centers, field service,
and e-service provides flexible delivery options.
Sales:
CRM enables you to acquire, grow, and retain profitable relationships with
functionality for sales planning and forecasting and the management of territories,
accounts, contacts, activities, opportunities, quotations, orders, product
configuration, pricing, billing, and contracts
Customer Reports:
All the details of the Customer are viewed by the admin so that they can
maintain the relationship between the Customers in a good way.
4
Enrich Tool for Customer Relation Management
Customer:
Order Product:
The Customer can view all the products from the admin and can directly
order the products by applying to the admin. They can order any quantity of
products according to the price.
Company Service:
The Customers can contact the admin in any time and can ask any queries
about the products and can also complaint about any product or service and can
directly contact with the admin.
View Message
The Customers view the messages about the products send by the admin.
They can also ask any questions about the products.
View Answers
They can view answers to their questions in this module.
EXISTING SYSTEM
The normal existing system in the auctioning is manual system. It is a difficult
and ridiculous one to maintain them without using of online system. In the existing
system for every action, lot of records has been needed for updating.
Disadvantages in the existing system
Enormous amount of time consumption for recording all the activities, added and
updated record is very slow.
This is very much error and more complex
This system is not user friendl
5
Enrich Tool for Customer Relation Management
PROPOSED SYSTEM
In the existing system the taxes are getting from some other pages and include in
the production master. But here all taxes are include in the project itself and get all taxes
related for production, sales and for scrap.
Initial investigations are important and place a vital role in the system analysis
process. Before staring to design the new system an initial investigation are conducted to
identify the problem with the existing system. The techniques used for information
gathering are interviewing, collection of various input and outputs sample etc., and the
collection information are deeply analyzed and evaluated.
Advantages of proposed system
Updating and adding of records is very fast and good performance.
Not much knowledge is needed for operating this system.
Auctioning product added is very easy with image. Calculation is very easy.
This is very much user friendly
Finding and replacing the records as very easy access.
6
Enrich Tool for Customer Relation Management
DATA FLOW DIAGRAM
Admin
Add Products
View Sale Reports
CustomerPurchase/Order
Service Send Message
View Messages
Add Product Details
View Sales
Details
View Customer Details
Stored
Select Cardholder
Database
7
Enrich Tool for Customer Relation Management
DATABASE DESIGN
Customer Service
Customer Registration
Name Data type Description
Cus_Id int Customer Id
Cus_Name Text Customer Name
Questions Text Questions
Comments Text Comments
FeedBack Varchar(30) FeedBack
Name Data type Description
Cus_Id int Company Id
Cus_Name Text Customer Name
Contact_No numeric Contact Number
Email Text Email
Address Varchar(30) Address
Desgination Varchar(50) Desgination
Date varchar Date
8
Enrich Tool for Customer Relation Management
Product Registration:
Name Data type Description
Pro_Code Varchar Product Code
Pro_Name Text Product Name
Company Text Company
Description Text Description
Features Varchar(30) Features
Amount_Product Float Amount Per Product
Sale:
Name Data type Description
Pro_Code Varchar Product Code
Pro_Name Text Product Name
Amount_Pro Float Amount Per Product
Total_Quantity Text Total Quantity
Total_Amount Float Total Amount
Con_Id int Customer Id
Con_Name varchar Customer Name
Date Varchar Date
9
Enrich Tool for Customer Relation Management
Send Reply
Send To Customer:
Name Data type Description
Cus_Id int Customer Id
Cus_Name Text Customer Name
Question numeric Question
Answer Text Answer
Name Data type Description
Cus_Id int Customer Id
Cus_Name Text Customer Name
Pro_Code Varchar Product Code
Pro_Name Text Product Name
Company Varchar(30) Company
Description Varchar(50) Description
Features varchar Features
Amount Float Amount
Message text Message
10
Enrich Tool for Customer Relation Management
SOFTWARE TOOLS USED
Operating System : Windows XP Professional
Environment : Visual Studio .Net 2005
.Net Framework : Version 2.0
Language : C#.Net
Web Technology : Active Server Pages.Net
Web Server : Internet information Server 5.0
Back End : Sql Server 2000
11
Enrich Tool for Customer Relation Management
HARDWARE USED
Processor : Pentium IV
RAM : 512MB
Monitor size : 17”SVGA
Extra Device : CD-ROM 52x
Operating System : Windows XP
Keyboard : 104 standards Keyboard
12
Enrich Tool for Customer Relation Management
SOFTWARE TOOLS DESCRIPTION
Windows XP is an operating system that was produced by Microsoft for use on
personal computers, including home and business desktops, laptops, and media centers. It
was first released in August 2001, and is the most popular version of Windows, based on
installed user base. The name "XP" is short for "eXPerience."
Windows XP was the successor to both Windows 2000 and, and was the first
consumer-oriented operating system produced by Microsoft to be built on the and.
Windows XP was released for retail sale on October 25, 2001, and over 400 million
copies were in use in January 2006, according to an estimate in that month by an analyst.
It was succeeded by, which was released to volume license customers on November 8,
2006 and worldwide to the general public on January 30, 2007. Direct and retail sales of
Windows XP ceased on June 30, 2008. Microsoft continued to sell Windows XP through
their System Builders (smaller OEMs who sell assembled computers) program until
January 31, 2009. XP may continue to be available as these sources run through their
inventory or by purchasing Windows 7 Ultimate, Windows 7 Pro, Windows Vista
Ultimate or Windows Vista Business, and then to Windows XP.
The most common editions of the operating system were Windows XP Home Edition,
which was targeted at home users, and Windows XP Professional, which offered
additional features such as support for and , and was targeted at , business and enterprise
clients has additional multimedia features enhancing the ability to record and watch TV
shows, view DVD movies, and listen to music. Was designed to run stylus applications
built using the platform.
Windows XP was eventually released for two additional architectures, for ()
processors and for. There is also, a component version of the Windows XP Professional,
and editions for specific markets such as Windows XP Starter Edition. By mid 2009, a
manufacturer revealed the first Windows XP powered cellular telephone.
13
Enrich Tool for Customer Relation Management
Users can further customize these settings. Some effects, such as (transparency and
fading), are handled entirely by many newer video cards. However, if the video card is
not capable of hardware alpha blending, performance can be substantially hurt, and
Microsoft recommends the feature should be turned off manually. Windows XP added
the ability for Windows to use "Visual Styles" to change the user interface. However,
visual styles must be cryptographically signed by Microsoft to run. Is the name of the
new visual style that ships with Windows XP, and is enabled by default for machines
with more than 64 of? Luna refers only to one particular visual style, not to all of the new
user interface features of Windows XP as a whole. Some users "patch" the uxtheme.dll
file that restricts the ability to use visual styles, created by the general public or the user,
on Windows XP.
New and updated features
Main article:
Windows XP introduced several new features to the Windows line, including:
graphics subsystem
and improvements
A number of new features in
Faster start-up, logon and logoff and sequences.
The ability to discard a newer in favor of the previous one (known as driver
rollback), should a driver upgrade not produce desirable results.
A new, arguably more user-friendly interface, including the framework for
developing for the desktop environment
which allows a user to save the current state and open applications of their
desktop and allow another user to log on without losing that information
The font rendering mechanism, which is designed to improve text readability on
(LCD) and similar monitors
14
Enrich Tool for Customer Relation Management
Editions
The two major editions are Windows XP Home Edition, designed for home users,
and Windows XP Professional, designed for business and power-users. XP Professional
contains advanced features that the average home user would not use. However, these
features are not necessarily missing from XP Home. They are simply disabled, but are
there and can become functional. These releases were made available at retail outlets that
sell computer software, and were preinstalled on computers sold by major computer
manufacturers. As of mid-2008, both editions continue to be sold. A third edition, called
Windows XP Media Center Edition was introduced in 2002 and was updated every year
until 2006 to incorporate new digital media, broadcast television and capabilities. Unlike
the Home and Professional edition, it was never made available for retail purchase, and
was typically either sold through channels, or was preinstalled on computers that were
typically marketed as "media center PCs".
Editions for specific markets
Is a lower-cost edition of Windows XP available in Thailand, Indonesia,
Philippines, Russia, India, Colombia, Brazil, Argentina, Peru, Bolivia, Chile, Mexico,
Ecuador, Uruguay and Venezuela? It is similar to Windows XP Home, but is limited to
low-end hardware, can only run 3 programs at a time, and has some other features either
removed or disabled by default. Each country's edition is also customized for that
country, including desktop backgrounds of popular locations, help features for those who
may not speak English, and other default settings designed for easier use than typical
Windows XP installations. The Malaysian version, for example, contains a desktop
background of the skyline.
That same year, Microsoft also released two additional editions of Windows XP
Home Edition directed towards subscription-based and pay-as-you-go pricing models.
These editions, released as part of Microsoft’s initiative, are used in conjunction with a
hardware component to enforce time limitations on the usage of Windows. Its target
market is emerging economies such as Brazil and Vietnam.
15
Enrich Tool for Customer Relation Management
Languages
Windows XP was available in many languages. In addition, packs and translating
the user interface were also available for certain languages.
ATMs and Vendors
(ATM) vendors, and have all adopted Microsoft Windows XP as their migration
path from. Wincor Nixdorf, who has been pushing for standardization for many years,
began shipping ATMs with Windows when they first arrived on the scene.
Diebold initially shipped XP Home Edition exclusively, but, following extensive
pressure from customer banks to support a common operating system, switched to
support XP Professional to match their primary competitor, NCR Corporation and
Wincor Nixdorf.
Vending machines run a modified version of XP designed for the full screen of
the Vending Touch screen and the DVD vending itself.
Service packs
Microsoft occasionally releases for its Windows operating systems to fix
problems and add features. Each service pack is a superset of all previous service packs
and patches so that only the latest service pack needs to be installed, and also includes
new revisions. However if you still have the earliest version of Windows XP on Retail
CD (without any service packs included), you will need to install SP1a or SP2, before
SP3 can be installed. Older service packs need not be manually removed before
application of the most recent one. Windows Update "normally" takes care of
automatically removing unnecessary files.
The service pack details below only apply to the 32-bit editions. Windows XP
Professional x64 Edition was based on Service Pack 1 and claimed to be "SP1" in system
properties from the initial release. It is updated by the same service packs and hot fixes as
the x64 edition of Windows Server 2003
16
Enrich Tool for Customer Relation Management
FRONT END TOOLS
ABOUT ASP.NET
INTRODUCTION OF VISUAL STUDIO:
In 2002, Visual Studio took the biggest leap in innovation since it was released,
with the introduction of Visual Basic .NET (as it was renamed). After more than a
decade, Visual Basic was overdue for a major overhaul. But .NET goes beyond an
overhaul. It changes almost every aspect of software development. From integrating
Internet functionality to creating object-oriented frameworks, Visual Basic .NET
challenged traditional VB developers to learn dramatic new concepts and techniques.
2005 brings us an enhanced Visual Basic language (renamed this time Visual
Basic 2005). New features have been added that cement this language’s position as a true
object-oriented language. With Visual Basic 2005, it is still going to be a challenge for
the traditional VB6 developers to learn, but it is an easy road and books like this are here
to help you on your path.
First, it’s necessary to learn the differences between Visual Basic 2005 and the
older versions. In some cases, the same functionality is implemented in a different way.
This was not done arbitrarily—there are good reasons for the changes. But you must be
prepared to unlearn old habits and form new ones.
Next, you must be open to the new concepts. Full object orientation, new component
techniques, new visual tools for both local and Internet interfaces—all of these and more
must become part of your skill
THE IMPORTANCE OF VISUAL BASIC
Early in the adoption cycle of .NET, Microsoft’s new language, C#, got the lion’s
share of attention. But as .NET adoption has increased, Visual Basic’s continuing
importance has also been apparent. Microsoft has publicly stated that they consider
17
Enrich Tool for Customer Relation Management
Visual Basic the language of choice for applications where developer productivity is one
of the highest priorities.
Future development of Visual Basic is emphasizing capabilities that enable access
to the whole expanse of the .NET Framework in the most productive way, while C#
development is emphasizing the experience of writing code. That fits the traditional role
of Visual Basic as the language developer’s use in the real world to create business
applications as quickly as possible.
This difference is more than academic. One of the most important advantages of
the .NET Framework is that it allows applications to be written with dramatically less
code. In the world of business applications, the goal is to concentrate on writing business
logic and to eliminate routine coding tasks as much as possible. The value in this new
world is not in churning out lots of code—it is in writing robust, useful applications with
as little code as possible.
An Overview of the .NET Framework
First and foremost, .NET is a framework that covers all the layers of software
development above the operating system level. It provides the richest level of integration
among presentation technologies, component Technologies and data technologies ever
seen on a Microsoft, or perhaps any, platform. Second, the entire architecture has been
created to make it as easy to develop Internet applications as it is to develop for the
desktop.
The .NET Framework actually “wraps” the operating system, insulating software
developed with .NET from most operating system specifics such as file handling and
memory allocation. This prepares for a possible future in which the software developed
for .NET is portable to a wide variety of hardware and operating system foundations.
VS.NET supports Windows 2003, Windows XP, and all versions of Windows
2000. Programs created for .NET can also run under Windows NT, Windows 98, and
Windows Me, though VS.NET does not run on these systems. Note that in some cases
certain service packs are required to run .NET.
18
Enrich Tool for Customer Relation Management
The framework starts all the way down at the memory management and
component loading level and goes all the way up to multiple ways of rendering user and
program interfaces. In between, there are layers that provide just about any system-level
capability that a developer would need.
Microsoft .NET
At the base is the common language runtime, often abbreviated to CLR. This is
the heart of the .NET Framework it is the engine that drives key functionality. It includes,
for example, a common system of data types. These common types, plus a standard
interface convention, make cross-language inheritance possible. In addition to allocation
and management of memory, the CLR also does reference tracking for objects and
handles garbage collection.
The middle layer includes the next generation of standard system Services such as
classes that manage data and Extensible Markup Language (XML). These services are
brought under control of the Framework, making them universally available and making
their usage consistent across languages.
The top layer includes user and program interfaces. Windows Forms is a new and
more advanced way to do standard Win32 screens (often referred to as “‘smart clients”).
Web Forms provides a new Web-based user interface. Perhaps the most revolutionary is
Web Services, which provide a mechanism for programs to communicate over the
Internet, using SOAP. Web Services provide an analog of COM and DCOM for object
brokering and interfacing, but based on Internet technologies so that allowance is made
even for integration to non-Microsoft platforms.
FEATURES OF ASP.NET
ASP.NET is the next version of Active Server Pages (ASP); it is a unified Web
development platform that provides the services necessary for developers to build
19
Enrich Tool for Customer Relation Management
enterprise-class Web applications. While ASP.NET is largely syntax compatible, it also
provides a new programming model and infrastructure for more secure, scalable, and
stable applications.
ASP.NET is a compiled, NET-based environment, we can author applications in
any .NET compatible language, including Visual Basic .NET, C#, and JScript .NET.
Additionally, the entire .NET Framework is available to any ASP.NET application.
Developers can easily access the benefits of these technologies, which include the
managed common language runtime environment (CLR), type safety, inheritance, and so
on.
ASP.NET has been designed to work seamlessly with WYSIWYG HTML editors
and other programming tools, including Microsoft Visual Studio .NET. Not only does
this make Web development easier, but it also provides all the benefits that these tools
have to offer, including a GUI that developers can use to drop server controls onto a Web
page and fully integrated debugging support.
Developers can choose from the following two features when creating an
ASP.NET application. Web Forms and Web services, or combine these in any way they
see fit. Each is supported by the same infrastructure that allows you to use authentication
schemes; cache frequently used data, or customizes your application's configuration, to
name only a few possibilities.
Web Forms allows us to build powerful forms-based Web pages. When building
these pages, we can use ASP.NET server controls to create common UI elements, and
program them for common tasks. These controls allow us to rapidly build a Web Form
out of reusable built-in or custom components, simplifying the code of a page.
ASP.NET takes advantage of performance enhancements found in the .NET
Framework and common language runtime. Additionally, it has been designed to offer
significant performance improvements over ASP and other Web development platforms.
All ASP.NET code is compiled, rather than interpreted, which allows early binding,
strong typing, and just-in-time (JIT) compilation to native code, to name only a few of its
benefits. ASP.NET is also easily factorable, meaning that developers can remove
20
Enrich Tool for Customer Relation Management
modules (a session module, for instance) that are not relevant to the application they are
developing.
ASP.NET provides extensive caching services (both built-in services and caching
APIs). ASP.NET also ships with performance counters that developers and system
administrators can monitor to test new applications and gather metrics on existing
applications.
Writing custom debug statements to your Web page can help immensely in
troubleshooting your application's code. However, it can cause embarrassment if it is not
removed. The problem is that removing the debug statements from your pages when your
application is ready to be ported to a production server can require significant effort.
ASP.NET offers the Trace Context class, which allows us to write custom debug
statements to our pages as we develop them. They appear only when you have enabled
tracing for a page or entire application. Enabling tracing also appends details about a
request to the page, or, if you so specify, to a custom trace viewer that is stored in the root
directory of your application.
The .NET Framework and ASP.NET provide default authorization and
authentication schemes for Web applications. We can easily remove, add to, or replace
these schemes, depending upon the needs of our application.
ASP.NET configuration settings are stored in XML-based files, which are human
readable and writable. Each of our applications can have a distinct configuration file and
we can extend the configuration scheme to suit our requirements.
THE .NET FRAMEWORK
The .NET Framework is a new computing platform that simplifies application
development in the highly distributed environment of the Internet.
21
Enrich Tool for Customer Relation Management
OBJECTIVES OF .NET FRAMEWORK:
1. To provide a consistent object-oriented programming environment whether
object codes is stored and executed locally on Internet-distributed, or executed remotely.
2. To provide a code-execution environment to minimizes software deployment
and guarantees safe execution of code.
3. Eliminates the performance problems.
There are different types of application, such as Windows-based applications and
Web-based applications. To make communication on distributed environment to ensure
that code be accessed by the .NET Framework can integrate with any other code.
THE COMMON LANGUAGE RUNTIME (CLR):
The common language runtime is the foundation of the .NET Framework. It manages
code at execution time, providing important services such as memory management,
thread management, and removing and also ensures more security and robustness. 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 unmanaged code.
THE .NET FRAME WORK CLASS LIBRARY
It is a comprehensive, object-oriented collection of reusable types used to develop
applications ranging from traditional command-line or graphical user interface (GUI)
applications to applications based on the latest innovations provided by ASP.NET, such
as Web Forms and XML Web services.
22
Enrich Tool for Customer Relation Management
The .NET Framework can be hosted by unmanaged components that load the
common language runtime into their processes and initiate the execution of managed
code, thereby creating a software environment that can exploit both managed .
Internet Explorer is an example of an unmanaged application that hosts the
runtime (in the form of a MIME type extension). Using Internet Explorer to host the
runtime to enables embeds managed components or Windows Forms controls in HTML
documents.
FEATURES OF THE COMMON LANGUAGE RUNTIME:
The common language runtime manages memory; thread execution, code
execution, code safety verification, compilation, and other system services these are all
run on CLR.
Security.
Robustness.
Productivity.
Performance.
SECURITY:
The runtime enforces code access security. The security features of the runtime
thus enable legitimate Internet-deployed software to be exceptionally featuring rich. With
regards to security, managed components are awarded varying degrees of trust,
depending on a number of factors that include their origin to perform file-access
operations, registry-access operations, or other sensitive functions.
ROBUSTNESS:
The runtime also enforces code robustness by implementing a strict type- and
code-verification infrastructure called the common type system (CTS). The CTS ensures
that all managed code is self-describing. The managed environment of the runtime
eliminates many common software issues.
PRODUCTIVITY:
23
Enrich Tool for Customer Relation Management
The runtime also accelerates developer productivity. For example, programmers
can write applications in their development language of choice, yet take full advantage of
the runtime, the class library, and components written in other languages by other
developers.
PERFORMANCE:
The runtime is designed to enhance performance. Although the common language
runtime provides many standard runtime services, managed code is never interpreted. A
feature called just-in-time (JIT) compiling enables all managed code to run in the native
machine language of the system on which it is executing. Finally, the runtime can be
hosted by high-performance, server-side applications, such as Microsoft SQL Server™
and Internet Information Services (IIS).
ADO.NET
As you develop applications using ADO.NET, you will have different
requirements for working with data. You might never need to directly edit an XML file
containing data - but it is very useful to understand the data architecture in ADO.NET.
ADO.NET offers several advantages over previous versions of ADO:
Interoperability
Maintainability
Programmability
Performance Scalability
INTEROPERABILITY:
ADO.NET applications can take advantage of the flexibility and broad acceptance
of XML. Because XML is the format for transmitting datasets across the network, any
component that can read the XML format can process data. The receiving component
need not be an ADO.NET component.
24
Enrich Tool for Customer Relation Management
The transmitting component can simply transmit the dataset to its destination
without regard to how the receiving component is implemented. The destination
component might be a Visual Studio application or any other application implemented
with any tool whatsoever.
The only requirement is that the receiving component be able to read XML. SO,
XML was designed with exactly this kind of interoperability in mind.
MAINTAINABILITY:
In the life of a deployed system, modest changes are possible, but substantial,
Architectural changes are rarely attempted because they are so difficult. As the
performance load on a deployed application server grows, system resources can become
scarce and response time or throughput can suffer. Faced with this problem, software
architects can choose to divide the server's business-logic processing and user-interface
processing onto separate tiers on separate machines.
In effect, the application server tier is replaced with two tiers, alleviating the
shortage of system resources. If the original application is implemented in ADO.NET
using datasets, this transformation is made easier.
ADO.NET data components in Visual Studio encapsulate data access
functionality in various ways that help you program more quickly and with fewer
mistakes.
VISUAL STUDIO .NET
Visual Studio .NET is a complete set of development tools for building ASP Web
applications, XML Web services, desktop applications, and mobile applications In
addition to building high-performing desktop applications, you can use Visual Studio's
25
Enrich Tool for Customer Relation Management
powerful component-based development tools and other technologies to simplify team-
based design, development, and deployment of Enterprise solutions.
Visual Basic .NET, Visual C++ .NET, and Visual C# .NET all use the same
integrated development environment (IDE), which allows them to share tools and
facilitates in the creation of mixed-language solutions. In addition, these languages
leverage the functionality of the .NET Framework and simplify the development of ASP
Web applications and XML Web services.
Visual Studio supports the .NET Framework, which provides a common language
runtime and unified programming classes; ASP.NET uses these components to create
ASP Web applications and XML Web services. Also it includes MSDN Library, which
contains all the documentation for these development tools.
XML WEB SERVICES
XML Web services are applications that can receive the requested data using
XML over HTTP. XML Web services are not tied to a particular component technology
or object-calling convention but it can be accessed by any language, component model,
or operating system. In Visual Studio .NET, you can quickly create and include XML
Web services using Visual Basic, Visual C#, JScript, Managed Extensions for C++, or
ATL Server.
XML SUPPORT
Extensible Markup Language (XML) provides a method for describing structured
data. XML is a subset of SGML that is optimized for delivery over the Web. The World
Wide Web Consortium (W3C) defines XML standards so that structured data will be
uniform and independent of applications. Visual Studio .NET fully supports XML,
providing the XML Designer to make it easier to edit XML and create XML schemas.
COMMON LANGUAE SPEGIFICATION (CLS)
Visual Basic.NET is also compliant with CLS (Common Language Specification)
and supports structured exception handling. CLS is set of rules and constructs that are
26
Enrich Tool for Customer Relation Management
supported by the CLR (Common Language Runtime). CLR is the runtime environment
provided by the .NET Framework; it manages the execution of the code and also makes
the development process easier by providing services.
Visual Basic.NET is a CLS-compliant language. Any objects, classes, or
components that created in Visual Basic.NET can be used in any other CLS-compliant
language. In addition, we can use objects, classes, and components created in other CLS-
compliant languages in Visual Basic.NET.
IMPLEMENTATION INHERITANCE
Visual Basic.NET supports implementation inheritance. This means that, while
creating applications in Visual Basic.NET, we can drive from another class, which is
know as the base class that derived class inherits all the methods and properties of the
base class. In the derived class, we can either use the existing code of the base class or
override the existing code. Therefore, with help of the implementation inheritance, code
can be reused.
CONSTRUCTORS AND DESTRUCTORS
Constructors are used to initialize objects, whereas destructors are used to destroy
them. In other words, destructors are used to release the resources allocated to the object.
In Visual Basic.NET the sub finalize procedure is available. The sub finalize procedure is
used to complete the tasks that must be performed when an object is destroyed. The sub
finalize procedure is called automatically when an object is destroyed. In addition, the
sub finalize procedure can be called only from the class it belongs to or from derived
classes.
GARBAGE COLLECTION
Garbage Collection is another new feature in Visual Basic.NET. The .NET
Framework monitors allocated resources, such as objects and variables. In addition,
the .NET Framework automatically releases memory for reuse by destroying objects that
are no longer in use. In Visual Basic.NET, the garbage collector checks for the objects
27
Enrich Tool for Customer Relation Management
that are not currently in use by applications. When the garbage collector comes across an
object that is marked for garbage collection, it releases the memory occupied by the
object.
BACK END TOOLS
SQL – STRUCTURED QUERY LANGUAGE
FEATURES OF SQL SERVER 2000
The OLAP Services feature available in SQL Server version 7.0 is now called
SQL Server 2000 Analysis Services. The term OLAP Services has been replaced with the
term Analysis Services. Analysis Services also includes a new data mining component.
The Repository component available in SQL Server version 7.0 is now called Microsoft
SQL Server 2000 Meta Data Services. References to the component now use the term
Meta Data Services. The term repository is used only in reference to the repository
engine within Meta Data Services
SQL-SERVER database consist of six type of objects,
They are,
1. TABLE
2. QUERY
3. FORM
4. REPORT
5. MACRO
Tables
In relational database systems (DBS) data are represented using tables (relations).
A query issued against the DBS also results in a table. A table has the following
structure:
Column 1 Column 2 . . . Column n
28
Enrich Tool for Customer Relation Management
…………..
A table is uniquely identified by its name and consists of rows that contain the
stored information, each row containing exactly one tuple (or record). A table can have
one or more columns.
A column is made up of a column name and a data type, and it describes an
attribute of the tuples. The structure of a table, also called relation schema, thus is defined
by its attributes.
The type of information to be stored in a table is defined by the data types of the
attributes at table creation time.
SQL uses the terms table, row, and column for relation, tuple, and attribute,
respectively. In this tutorial we will use the terms interchangeably.
A table can have up to 254 columns which may have different or same data types
and sets of values (domains), respectively. Possible domains are alphanumeric data
(strings), numbers and date formats. SQL offers the following basic data types:
• char (n): Fixed-length character data (string), n characters long. The maximum size for
n is 255 bytes (2000 in Oracle8). Note that a string of type char is always padded on right
with blanks to full length of n. (+ can be memory consuming).
Example: char (40)
• varchar2 (n): Variable-length character string. The maximum size for n is 2000 (4000 in
Oracle8). Only the bytes used for a string require storage. Example: varchar(80)
• Number (o, d): Numeric data type for integers and reals. o = overall number of digits,
d = number of digits to the right of the decimal point.
Maximum values: o =38, d= −84 to +127. Examples: number (8), number (5,2)
Note that, e.g., number (5,2) cannot contain anything larger than 999.99 without resulting
in an error. Data types derived from number are int [eger], dec [imal], smallint and real.
• Date: Date data type for storing date and time.
The default format for a date is: DD-MMM-YY. Examples: ’13-OCT-94’, ’07-JAN-98’
• Long: Character data up to a length of 2GB. Only one long column is allowed per table.
29
Enrich Tool for Customer Relation Management
Further properties of tables are:
• The order in which tuples appear in a table is not relevant (unless a query requires an
explicit sorting).
• A table has no duplicate tuples (depending on the query, however, duplicate tuples can
appear in the query result).
A database schema is a set of relation schemas. The extension of a database schema at
database run-time is called a database instance or database, for short.
VIEWS OF TABLE:
We can work with a table in two types,
1. Design View
2. Datasheet View
Design View
To build or modify the structure of a table we work in the table design view. We
can specify what kind of data will be hold.
Datasheet View
To add, edit or analyses the data itself we work in tables datasheet view mode.
QUERY:
A query is a question that has to be asked the data. Access gathers data that
answers the question from one or more table. The data that make up the answer is either
dynast (if you edit it) or a snapshot (it cannot be edited).Each time we run query, we get
30
Enrich Tool for Customer Relation Management
latest information in the dynast. Access either displays the dynast or snapshot for us to
view or perform an action on it, such as deleting or updating.
FORMS:
A form is used to view and edit information in the database record by record .A
form displays only the information we want to see in the way we want to see it. Forms
use the familiar controls such as textboxes and checkboxes. This makes viewing and
entering data easy.
Views of Form:
We can work with forms in several primarily there are two views,
They are,
1. Design View
2. Form View
Design View
To build or modify the structure of a form, we work in forms design view. We can
add control to the form that are bound to fields in a table or query, includes textboxes,
option buttons, graphs and pictures.
Form View
The form view which display the whole design of the form.
SYSTEM TESTING Software testing is an investigation conducted to provide stakeholders with
information about the quality of the product or service under test. Software testing also
31
Enrich Tool for Customer Relation Management
provides an objective, independent view of the software to allow the business to
appreciate and understand the risks of software implementation. Test techniques include,
but are not limited to, the process of executing a program or application with the intent of
finding software bugs.
Software testing can also be stated as the process of validating and verifying that a
software program/application/product:
meets the business and technical requirements that guided its design and
development;
works as expected; and
Can be implemented with the same characteristics.
Unit Testing
In computer programming, unit testing is a method by which individual units of
source code are tested to determine if they are fit for use. A unit is the smallest testable
part of an application. In procedural programming a unit may be an individual function or
procedure. Unit tests are created by programmers or occasionally by white box testers.
Ideally, each test case is independent from the others: substitutes like method
stubs, mock objects, fakes and test harnesses can be used to assist testing a module in
isolation. Unit tests are typically written and run by software developers to ensure that
code meets its design and behaves as intended. Its implementation can vary from being
very manual (pencil and paper) to being formalized as part of build automation.
The goal of unit testing is to isolate each part of the program and show that the
individual parts are correct. A unit test provides a strict, written contract that the piece of
code must satisfy. As a result, it affords several benefits. Unit tests find problems early in
the development cycle.
System Testing
System testing of software or hardware is testing conducted on a complete,
integrated system to evaluate the system's compliance with its specified requirements.
32
Enrich Tool for Customer Relation Management
System testing falls within the scope of black box testing, and as such, should require no
knowledge of the inner design of the code or logic.
As a rule, system testing takes, as its input, all of the "integrated" software
components that have successfully passed integration testing and also the software
system itself integrated with any applicable hardware system(s).
Acceptance Testing
Acceptance testing generally involves running a suite of tests on the completed
system. Each individual test, known as a case, exercises a particular operating condition
of the user's environment or feature of the system, and will result in a pass or fail, or
Boolean, outcome. There is generally no degree of success or failure. The test
environment is usually designed to be identical, or as close as possible, to the anticipated
user's environment, including extremes of such. These test cases must each be
accompanied by test case input data or a formal description of the operational activities
(or both) to be performed intended to thoroughly exercise the specific case and a formal
description of the expected results.
User Acceptance Testing (UAT) is a process to obtain confirmation that a
system meets mutually agreed-upon requirements. A Subject Matter Expert (SME),
preferably the owner or client of the object under test, provides such confirmation after
trial or review. In software development, UAT is one of the final stages of a project and
often occurs before a client or customer accepts the new system.
Users of the system perform these tests, which developers derive from the client's
contract or the user requirements specification.
Test-designers draw up formal tests and devise a range of severity levels. Ideally
the designer of the user acceptance tests should not be the creator of the formal
integration and system test cases for the same system; however in some situations this
may not be avoided.
The results of these tests give confidence to the clients as to how the system will
perform in production. There may also be legal or contractual requirements for
acceptance of the system.
33
Enrich Tool for Customer Relation Management
Software quality assurance (SQA)
Though controversial, software testing is a part of the software quality assurance
(SQA) process. In SQA, software process specialists and auditors are concerned for the
software development process rather than just the artifacts such as documentation, code
and systems. They examine and change the software engineering process itself to reduce
the amount of faults that end up in the delivered software: the so-called defect rate.
What constitutes an "acceptable defect rate" depends on the nature of the
software; a flight simulator video game would have much higher defect tolerance than
software for an actual airplane.
Although there are close links with SQA, testing departments often exist
independently, and there may be no SQA function in some companies.
Software testing is a task intended to detect defects in software by contrasting a
computer programs expected
SOURCE CODINGAdmin Login
34
Enrich Tool for Customer Relation Management
using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;
public partial class AdminLogin : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) {
} protected void Button1_Click(object sender, EventArgs e) { if (txtUserName.Text == "Admin" && txtPassword.Text == "Admin") { Response.Redirect("AdminPage.aspx"); } else { Response.Write("Invalid Login"); } }}
Customer Login:
using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;
public partial class CustomerLogin : System.Web.UI.Page
35
Enrich Tool for Customer Relation Management{ ClsDbLayer _objDb = new ClsDbLayer(); SqlDataReader dr; protected void Page_Load(object sender, EventArgs e) {
} protected void Button1_Click(object sender, EventArgs e) { string Query = "select Con_Id,Con_Name from Customer_Reg where Con_Id='" + txtCustomerId.Text + "' and Con_Name like '" + txtCustomerName.Text + "'"; dr = _objDb.Select(Query); if (dr.Read()) { txtCustomerId.Text = dr[0].ToString(); txtCustomerName.Text = dr[1].ToString(); Session["Id"] = txtCustomerId.Text; Session["Name"] = txtCustomerName.Text; Response.Redirect("CustomerPage.aspx"); } else { Response.Write("Invalid Login"); } }}
Customer Reports:
using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;
public partial class CustomerReports : System.Web.UI.Page{ ClsDbLayer _objDb = new ClsDbLayer(); DataSet ds; protected void Page_Load(object sender, EventArgs e) { string Query = "select * from Customer_Reg"; ds = _objDb.Display(Query);
36
Enrich Tool for Customer Relation Management GridView1.DataSource = ds; GridView1.DataBind(); }}
Customer Registration:
using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;
public partial class CustomerRegistration : System.Web.UI.Page{ ClsDbLayer _objDb = new ClsDbLayer(); protected void Page_Load(object sender, EventArgs e) {
} protected void Button1_Click(object sender, EventArgs e) { string Query = "insert into Customer_Reg values('" + txtCustomerId.Text + "','" + txtCustomerName.Text + "','" + txtContactNo.Text + "','" + txtEmail.Text + "','" + txtAddress.Text + "','" + txtDesgination.Text + "','" + txtDate.Text + "')"; int i = _objDb.Insert(Query); if (i != -1) { Response.Write("Register Successfully"); } else { Response.Write("Not Register"); } }}
Marketing:
37
Enrich Tool for Customer Relation Managementusing System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;
public partial class Marketing : System.Web.UI.Page{ ClsDbLayer _objDb = new ClsDbLayer(); DataSet ds; SqlDataReader dr; protected void Page_Load(object sender, EventArgs e) { if (IsPostBack.Equals(false)) { string Query = "select Con_Id,Con_Name,Email,Address from Customer_Reg"; ds = _objDb.Display(Query); GridView1.DataSource = ds; GridView1.DataBind();
string Query1 = "select Pro_Code from Pro_Reg"; ds = _objDb.Display(Query1); ddlProCode.DataTextField = "Pro_Code"; ddlProCode.DataValueField = "Pro_Code"; ddlProCode.DataSource = ds; ddlProCode.DataBind();
ListItem L1 = new ListItem(); L1.Text = "-Select-"; L1.Value = "0"; ddlProCode.Items.Add(L1); ddlProCode.SelectedValue = "0"; } } protected void ddlProCode_SelectedIndexChanged(object sender, EventArgs e) { string Query = "select Pro_Name,Company,Description,Features,Amount_Product from Pro_Reg where Pro_Code like '" + ddlProCode.SelectedItem + "'"; dr = _objDb.Select(Query); if (dr.Read()) { txtProName.Text = dr[0].ToString(); txtCompany.Text = dr[1].ToString(); txtDescription.Text = dr[2].ToString(); txtFeatures.Text = dr[3].ToString(); txtAmount.Text = dr[4].ToString();
38
Enrich Tool for Customer Relation Management } } protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e) { string Con_Id = GridView1.Rows[e.NewSelectedIndex].Cells[1].Text; txtCustomerId.Text = Con_Id.ToString(); string Con_Name = GridView1.Rows[e.NewSelectedIndex].Cells[2].Text; txtCustomerName.Text = Con_Name.ToString(); } protected void Button1_Click(object sender, EventArgs e) { string Query = "insert into Send_To_Con values('" + txtCustomerId.Text + "','" + txtCustomerName.Text + "','" + ddlProCode.SelectedItem + "','" + txtProName.Text + "','" + txtCompany.Text + "','" + txtDescription.Text + "','" + txtFeatures.Text + "','" + txtAmount.Text + "','" + txtMessage.Text + "')"; int i = _objDb.Insert(Query); if (i != -1) { Response.Write("Send Successfully"); } else { Response.Write("Not Send"); } }}
Product Register:
using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;
public partial class ProductRegister : System.Web.UI.Page{ ClsDbLayer _objDb = new ClsDbLayer(); protected void Page_Load(object sender, EventArgs e) {
39
Enrich Tool for Customer Relation Management
} protected void Button1_Click(object sender, EventArgs e) { string Query = "insert into Pro_Reg values('" + txtProCode.Text + "','" + txtProName.Text + "','" + txtCompany.Text + "','" + txtDescription.Text + "','" + txtFeatures.Text + "','" + txtAmountPerProduct.Text + "')"; int i = _objDb.Insert(Query); if (i != -1) { Response.Write("Saved Successfully"); } else { Response.Write("Not Saved"); } }}
Queries from Admin:
using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;
public partial class QueriesFromAdmin : System.Web.UI.Page{ ClsDbLayer _objDb = new ClsDbLayer(); DataSet ds; protected void Page_Load(object sender, EventArgs e) { Label1.Text = Session["Id"].ToString(); string Query = "select Pro_Code,Pro_Name,Company,Description,Features,Amount_Product from Send_To_Con where Con_Id='" + Label1.Text + "'"; ds = _objDb.Display(Query); GridView1.DataSource = ds; GridView1.DataBind(); string Query1 = "select Message from Send_To_Con where Con_Id ='" + Label1.Text + "'"; ds = _objDb.Display(Query1);
40
Enrich Tool for Customer Relation Management GridView2.DataSource = ds; GridView2.DataBind(); }}
Reply from Admin:
using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;
public partial class ReplyFromAdmin : System.Web.UI.Page{ ClsDbLayer _objDb = new ClsDbLayer(); DataSet ds; protected void Page_Load(object sender, EventArgs e) { Label1.Text = Session["Id"].ToString(); string Query = "select Question,Answer from Send_Reply where Con_Id ='" + Label1.Text + "'"; ds = _objDb.Display(Query); GridView1.DataSource = ds; GridView1.DataBind(); }}
Sale:
using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;
41
Enrich Tool for Customer Relation Managementusing System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;
public partial class Sale : System.Web.UI.Page{ ClsDbLayer _objDb = new ClsDbLayer(); DataSet ds; protected void Page_Load(object sender, EventArgs e) { txtConId.Text = Session["Id"].ToString(); txtConName.Text = Session["Name"].ToString(); string Query = "select * from Pro_Reg"; ds = _objDb.Display(Query); GridView1.DataSource = ds; GridView1.DataBind(); } protected void Button1_Click(object sender, EventArgs e) { string Query = "insert into Sale values('" + txtProCode.Text + "','" + txtProName.Text + "','" + txtAmountPerProduct.Text + "','" + txtTotalQuantity.Text + "','" + txtTotalAmount.Text + "','" + txtConId.Text + "','" + txtConName.Text + "','" + txtDate.Text + "')"; int i = _objDb.Insert(Query); if (i != -1) { Response.Write("Submitted Successfully"); } else { Response.Write("Not Submitted"); } } protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e) { string Pro_Code = GridView1.Rows[e.NewSelectedIndex].Cells[1].Text; txtProCode.Text = Pro_Code.ToString(); string Pro_Name = GridView1.Rows[e.NewSelectedIndex].Cells[2].Text; txtProName.Text = Pro_Name.ToString(); string Amount = GridView1.Rows[e.NewSelectedIndex].Cells[6].Text; txtAmountPerProduct.Text = Amount.ToString(); } protected void txtTotalQuantity_TextChanged(object sender, EventArgs e) { double Tot = Convert.ToDouble(txtAmountPerProduct.Text) * Convert.ToDouble(txtTotalQuantity.Text); txtTotalAmount.Text = Tot.ToString(); }}
42
Enrich Tool for Customer Relation Management
Sale Report:
using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;
public partial class SaleReports : System.Web.UI.Page{ ClsDbLayer _objDb = new ClsDbLayer(); DataSet ds; protected void Page_Load(object sender, EventArgs e) { string Query = "select * from Sale"; ds = _objDb.Display(Query); GridView1.DataSource = ds; GridView1.DataBind(); }}
Service:
using System;
43
Enrich Tool for Customer Relation Managementusing System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;
public partial class Service : System.Web.UI.Page{ ClsDbLayer _objDb = new ClsDbLayer(); protected void Page_Load(object sender, EventArgs e) { txtCustomerId.Text = Session["Id"].ToString(); txtCustomerName.Text = Session["Name"].ToString(); } protected void Button1_Click(object sender, EventArgs e) { string Query = "insert into Con_Service values('" + txtCustomerId.Text + "','" + txtCustomerName.Text + "','" + txtQuestions.Text + "','" + txtComments.Text + "','" + txtFeedBack.Text + "')"; int i = _objDb.Insert(Query); if (i != -1) { Response.Write("Send Successfully"); } else { Response.Write("Not Send"); } }}
View Queries:
using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;
44
Enrich Tool for Customer Relation Managementusing System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;
public partial class ViewQueries : System.Web.UI.Page{ ClsDbLayer _objDb = new ClsDbLayer(); DataSet ds; protected void Page_Load(object sender, EventArgs e) { string Query = "select * from Con_Service"; ds = _objDb.Display(Query); GridView1.DataSource = ds; GridView1.DataBind(); } protected void Button1_Click(object sender, EventArgs e) { string Query = "insert into Send_Reply values('" + txtCustomerId.Text + "','" + txtCustomerName.Text + "','" + txtQuestion.Text + "','" + txtAnswer.Text + "')"; int i = _objDb.Insert(Query); if (i != -1) { Response.Write("Saved Successfully"); } else { Response.Write("Not Saved"); } } protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e) { string Con_Id = GridView1.Rows[e.NewSelectedIndex].Cells[1].Text; txtCustomerId.Text = Con_Id.ToString(); string Con_Name = GridView1.Rows[e.NewSelectedIndex].Cells[2].Text; txtCustomerName.Text = Con_Name.ToString(); string Question = GridView1.Rows[e.NewSelectedIndex].Cells[3].Text; txtQuestion.Text = Question.ToString(); }}
OUTPUTHome Page
45
Enrich Tool for Customer Relation Management
Admin Login
46
Enrich Tool for Customer Relation Management
Admin Page:
47
Enrich Tool for Customer Relation Management
Product Register:
48
Enrich Tool for Customer Relation Management
Customer Reports:
49
Enrich Tool for Customer Relation Management
View Queries:
50
Enrich Tool for Customer Relation Management
Sales Report:
51
Enrich Tool for Customer Relation Management
Customer Login:
52
Enrich Tool for Customer Relation Management
Customer Page:
53
Enrich Tool for Customer Relation Management
From Admin:
54
Enrich Tool for Customer Relation Management
Sale:
55
Enrich Tool for Customer Relation Management
Service:
56
Enrich Tool for Customer Relation Management
Reply from Admin:
57
Enrich Tool for Customer Relation Management
58
Enrich Tool for Customer Relation Management
CONCLUSION
“Customer Relationship Management Application” is very suitable for all the
companies to do their work in an organized way with time consumption. We can manage
and control the whole customers any where in the world. We can assign tasks to the
workers each and every time through this project and monitor from any where. So it
better use this type of project in companies as concluded.
The project was design to fulfill all the requirements of the user. This system was
successfully tested using all testing process tools improve with reliability and
consistency.
The quality factors like correctness, efficiencies, usability, maintainability,
portability, accuracy, errors, tolerance, expandability and communicatively all are
successfully done.
59
Enrich Tool for Customer Relation Management
BIBLIOGRAPHY
Active Server Page Unleashed, Stephen Walther, Second Edition, Sums
Publishing 2003
Active Server Page 2.0, Richard Launcher, Second Reprint, Queue 2003
Roger S.Pressman, 1997, Software Engineering A Parishioners Approach,
Fourth Edition, McGraw-Hill International
MS SQL Server 2000, Kaleen Delaney JOE Cello’s SQL for smartens, JOE
Cello The Guru’s Guide to Transact SQL, Ken Henderson
Websites:
http://www.dotnettutorials.com
http://www.csharpcorner.com
http://www.w3schools.com
60