26-02-2010, 11:40 PM
[attachment=2467]
WEB BASED SUPPLY CHAIN MANAGEMENT SYSTEM
By
ENU JOHN KATTAKKAYAM LINISHAN .K TINTU THAMPI .P
Project Title
eSCM.Corn Tools / Platform
¦The project will be in Windows-2000 platform with ASP .Net (Scripting to be done using VB.Net) And SQL Server 2000. The Web Server will be IIS, WAP enabled features for accessing the site
Introduction To application Area
The project deals with the web based Supply Chain Management (SCM) systems. SCM is an integrated approach to Stock Transfer across warehouses and Distributors located all over the country.
Modules Of The Project
1) Company Registration Module
The module helps in registering the company with the SCM site. The company will be allotted a User Id and Password to enter in to the site
2) Products Module
The module helps in creation and maintenance of Products offered by the company.
3) Stock Depot Module
The module helps keeping track of maintaining the stock depots all over the country and assigning user id and password to these stock depots.
4) Distributor Module
The module helps in creation and maintenance of Distributors across all over the country and assigning them to a Stock Depot.
5) Order Processing Module
The module helps in generation of purchase orders and submitting the order to the concerned stock depot.
6) Packing List Module
The module helps in creation of packing lists by the stock depots based on the orders placed by the distributors
7) Invoicing Module
The module helps in generation of invoices based on the Packing Lists prepared by the Stock Depots and dispatching it to the distributors
8) Reporting and Analysis Module
The module helps in keeping track of the number of distributors and their order status, performance level of distributors all over the country on region basis etc. The module also helps in automatic backup and recovery of data from the database.
System Study
Introduction To Application Area
Main objective of this project is to create a supplying environment service for both Distributors and Company registered with this site.
Problem
Multinational companies like HLL (Hindustan Lever Ltd) a subsidiary of Unilever is involved in the trading of consumer goods. The company is one of the major FMCG companies operating in the country. The operations of the company are spread all over the country. Due to its complicated network of operations the company is facing lot of problems with its distributors all over world. The present system is described below.
Existing system
The present system of operations includes Factories, Stock Depots and Distributors. The manufactured goods will be moved from the factory to the Stock depots located in different regions of the country. From there the distributors of the particular region will be receiving the products. The system has many limitations.
Limitations of Existing System
1) The Stock available at a particular stock depot at any point of time is not available readily. This creates a lot of problems for the distributors as they won't be able to find out The Stock Balance available at a particular he stock depot at any point of time is not available readily. The stock position regional stock depot.
2) Distributors are placing the orders through couriers. This causes a lot of delay in reaching stock depot and also distributors will not
have an idea about the processing stage of the orders placed. (Whether it is dispatched or not etc.)
¦ 3) Distributors are not getting the up to date outstanding balance amount due to the company at any moment.
Proposed system
The proposed system includes a company module, distributor module and a stock depot module. Here a company who want to market its products will have to first register with the site. After registration with the site the company has to enter company details, category, subcategory, products etc. The company also has to transfer stock to the stock department. After that the stock depot has to check for pending orders and create pending pack slips. These details will be stored in the invoice table.
In the case of distributor he must first register with the site. After registering he has to check for his credit limit before placing the orders. The order details will be stored in order master and order details table. The registered distributor can check for outstanding balance, check for payments made, check for order status, check for grade allotment, check before stock availability.
In stock depot the stock department has to log into the site using depot id and password. After login they have to check for pending orders from distributors from order master table. If there are any pending orders they have to create pack slips for pending orders The stock department also has record of all Distributors of that particular Depot.
Advantages of Proposed System
The proposed system has the following advantages over the present system:
1) The Stock available at a particular stock depot at any point of time can be found out readily. This helps the distributors, as they will be able to find out The Stock Balance available at a particular stock depot at any point of time.
2) Distributors are placing the orders through company's website. This helps the distributors in getting the products; they need with in a limited amount of time.
3) Distributors will be able to know the up to date outstanding balance amount due to the company at any moment by browsing through the company site
Feasibility Analysis
Feasibility analysis is the procedure for identifying the candidate system, evaluating and electing the most feasible system. This is done by investigating the existing system in the area under investigation or generally ideas about a new system. It is a test of a system proposal according to its workability, impact on the organization, ability to meet user needs, and effective use of resources. The objective of feasibility study is not to solve the problem but to acquire a sense of its scope. Feasibility analysis involves 8 steps:
1. Form a project team and appoint a project leader.
2. Prepare system flow charts.
3. Enumerate potential candidate system.
4. Describe and identify characteristics of candidate systems.
5. Determine and evaluate performance and cost effectiveness of each candidate system.
6. Weigh system performance and cost data.
7. Select the best candidate system.
¦ 8. Repair and report final project directive to management. Three key considerations are involved in the feasibility analysis: economic, technical and behavioral.
¦
Economic feasibility
Economic analysis is the most frequently used method for evaluating the effectiveness of a candidate system. It is more commonly known as cost benefit analysis, the procedure to determine the benefits and saving that are expected from a candidate system and compare them with costs. If the benefits outweigh costs then a decision is made to design and implement the system. Otherwise make alterations in the proposed system.
Technical feasibility
The assessments of technical feasibility centers on the existing system and to what extent it can support the proposed addition. This was based on an outline design of system requirements in turns of inputs, files, programs, procedures, and staff. It involves financial considerations to accommodate technical enhancements.
Behavioral feasibility
People are inherently resistant to change, and computers have been known to facilitate change. An estimate should be made about the reaction of the user staff towards the development of a computerized system. Computer installations have something to do with turnover, transfers and changes in job status. The introduction of a candidate system requires special effort to educate, sell and train the staff for conducting the business.
The candidate system was found to be technically, economically, and behaviorally feasible. The system was developed user friendly, needless training and improves the working environment. Justification for any capital outlay is that it will increase profit, reduce expenditure or improve the quality
of service or goods, which in turn may be expected to provide increased profits. Disregarding the initial expenses, the candidate system was assessed to be feasible in all ways.
FRONT END Microsoft .NET
Microsoft .NET is software that connects information, people, systems, and devices. It spans clients, servers, and developer tools, and consists of:
¢ The .NET Framework 1.1, used for building and running all kinds of software, including Web-based applications, smart client applications, and XML Web servicesâ€components that facilitate integration by sharing data and functionality over a network through standard, platform-independent protocols such as XML (Extensible Markup Language), SOAP, and HTTP.
¢ Developer tools, such as Microsoft Visual Studio® .NET 2003 which provides an integrated development environment (IDE) for maximizing developer productivity with the NET Framework.
¢ A set of servers, including Microsoft Windows® Server 2003, Microsoft SQL Server„¢, and Microsoft BizTalk® Server, that integrates, runs, operates, and manages Web services and Web-based applications.
¢ Client software, such as Windows XP, Windows CE, and Microsoft Office XP, that helps developers deliver a deep and compelling user experience across a family of devices and existing products.
.NET Framework
The .NET Framework is an integral Windows component for building and running the next generation of software applications and Web services. The .NET Framework:
¢ Supports over 20 different programming languages.
¢ Manages much of the plumbing involved in developing software, enabling developers to focus on the core business logic code..
¢ Makes it easier than ever before to build, deploy, and administer secure, robust, and high-performing applications.
The .NET Framework is composed of the common language runtime and a unified set of class libraries.
Common Language Runtime
Class Libraries
Base classes provide standard functionality such as input/output, string manipulation, security management, network communications, thread management, text management, and user interface design features.
The ADO.NET classes enable developers to interact with data accessed in the form of XML through the OLE DB, ODBC, Oracle, and SQL Server interfaces. XML classes enable XML manipulation, searching, and translations. The ASP.NET classes support the development of Web-based applications and Web services. The Windows Forms classes support the development of desktop-based smart client applications.
Together, the class libraries provide a common, consistent development interface across all languages supported by the .NET Framework.
System Requirements for Visual Studio .NET 2003
Requirements vary for different combinations of components within Visual Studio .NET 2003. Review the table below to determine the minimum system requirements for running Visual Studio .NET 2003.
MinimumRe quirements
Processor 450-megahertz (MHz) Pentium ll-class processor, 600-MHz Pentium Ill-class processor recommended
Operating System Visual Studio .NET 2003 can be installed onto any of the following systems:
¢ Microsoft Windows® Server 2003
¢ Windows XP Professional
¢ Windows XP Home Edition1
¢ Windows 2000 Professional (SP3 or later required for installation)
¢ Windows 2000 Server (SP3 or later required for installation) Applications can be deployed onto the following systems2:
¢ Windows Server 2003
¢ Windows XP Professional
¢ Windows XP Home Edition
¢ Windows 2000 (Service Pack 2 recommended)
¢ Windows Millennium Edition (Windows Me)
¢ Windows 98
¢ Microsoft Windows NT® 4.0 (Service Pack 6a required)
¢ Windows 95 (using Microsoft Visual C++® .NET)
Memory ¢ Windows Server 2003:
160 megabytes (MB) of RAM
¢ Windows XP Professional: 160 MB of RAM
¢ Windows XP Home Edition: 96 MB of RAM
¢ Windows 2000 Professional: 96 MB of RAM
¢ Windows 2000 Server: 192 MB of RAM
Hard Disk ¢ 900 MB of available space required on system drive, 3.3 gigabytes (GB) of available space required on installation drive
¢ Additional 1.9 GB of available space required for optional MSDN Library documentation
Drive CD-ROM or DVD-ROM drive
Display Super VGA (1024 x 768) or higher-resolution display with 256 colors
Mouse Microsoft Mouse or compatible pointing device
ASP.NET
ASP.NET is a programming framework built on the common language runtime that can be used on a server to build powerful Web applications. ASP.NET offers several important advantages over previous Web development models:
¢ Enhanced Performance
ASP.NET is compiled common language runtime code running on the server. Unlike its interpreted predecessors, ASP.NET can take advantage of early binding, just-in-time compilation, native optimization, and caching services right out of the box. This amounts to dramatically better performance before you ever write a line of code.
¢ World-Class Tool Support
The ASP.NET framework is complemented by a rich toolbox and designer in the Visual Studio integrated development environment. WYSIWYG editing, drag-and-drop server controls, and automatic deployment are just a few of the features this powerful tool provides.
¢ Power and Flexibility
Because ASP.NET is based on the common language runtime, the power and flexibility of that entire platform is available to Web application developers. The .NET Framework class library, Messaging, and Data Access solutions are all seamlessly accessible from the Web. ASP.NET is also language-independent, so you can choose the language that best applies to your application or partition your application across many languages. Further, common language runtime interoperability guarantees that your existing investment in COM-based development is preserved when migrating to ASP.NET.
¢ Simplicity
ASP.NET makes it easy to perform common tasks, from simple form submission and client authentication to deployment and site configuration. For example, the ASP.NET page framework allows you to build user interfaces that cleanly separate application logic from presentation code and to handle events in a simple, Visual Basic - like forms processing model. Additionally, the common language runtime simplifies development, with managed code services such as automatic reference counting and garbage collection.
¢ Manageability
ASP.NET employs a text-based, hierarchical configuration system, which simplifies applying settings to your server environment and Web applications. Because configuration information is stored as plain text, new settings may be applied without the aid of local administration tools. This "zero local administration" philosophy extends to deploying ASP.NET Framework applications as well. An ASP.NET Framework application is deployed to a server simply by copying the necessary files to the server. No server restart is required, even to deploy or replace running compiled code.
¢ Scalability and Availability
ASP.NET has been designed with scalability in mind, with features specifically tailored to improve performance in clustered and multiprocessor environments. Further, processes are closely monitored and managed by the ASP.NET runtime, so that if one misbehaves (leaks, deadlocks), a new process can be created in its place, which helps keep your application constantly available to handle requests.
¢ Customizability and Extensibility
ASP.NET delivers a well-factored architecture that allows developers to "plug-in" their code at the appropriate level. In fact, it is possible to extend or replace any subcomponent of the ASP.NET runtime with your own custom-written component. Implementing custom authentication or state services has never been easier.
¢ Security
With built in Windows authentication and per-application configuration, you can be assured that your applications are secure.
¢ Language Support
The Microsoft NET Platform currently offers built-in support for three languages: C#, Visual Basic, and JScript.
The exercises and code samples in this tutorial demonstrate how to use C#, Visual Basic, and JScript to build .NET applications. For information regarding the syntax of the other languages, refer to the complete documentation for the .NET Framework SDK.
BACK END
History of Microsoft SQL Server
Microsoft SQL Server was introduced in 1990 for the Microsoft OS/2 platform in partnership with Sybase. The product was originally ported from the Sybase SQL Server 4.x for the UNIX platform. With the introduction of Microsoft Windows NT, a second porting initiative was undertaken to build a native Windows NT version. Microsoft SQL Server version 4.2 was the first commercially available database server natively designed for the Windows NT platform. The partnership with Sybase continued, and two additional versions of SQL Server were released(version 6.0 and version 6.5)
SQLServer6.5 made improvements in transactional performance, scalability, realiability, and became one of the most widely used client server database product for operational systems on the Windows NT platforms.
- As the database market evolved and the business relationship with Sybase changed, it became apparent that in order to address customer requirements and evolved SQL Server to support the next generation of database application, SQL Server products required a fundamental redesign.
This resulted in the termination of the business relationship between Sybase and Microsoft, and lead to the development of SQL Server 7.0. SQL Server 7.0 is a modern database engine architecture implemented completely by Microsoft, and is designed to address the most demanding database application requirements for operational and decision-support systems implemented today and in the future.
SQL Server 2000
Business today demands a different kind of data management solution. Performance, scalability, and reliability are essential, but businesses now expect more from their key IT investments.
SQL Server 2000 exceeds dependability requirements and provides innovative capabilities that increase employee effectiveness, integrate heterogeneous IT ecosystems, and maximize capital and operating budgets. SQL Server 2000 provides the enterprise data management platform your organization needs to adapt quickly in a fast-changing environment.
With the lowest implementation and maintenance costs in the industry, SQL Server 2000 delivers rapid return on your data management investment. SQL Server 2000 supports the rapid development of enterprise-class business applications that can give your company a critical competitive advantage.
Benchmarked for scalability, speed, and performance, SQL Server 2000 is a fully enterprise-class database product, providing core support for Extensible Markup Language (XML) and Internet queries.
Easy-to-Use Business Intelligence (Bl) Tools
Through rich data analysis and data mining capabilities that integrate with familiar applications such as Microsoft Office, SQL Server 2000 enables you to provide all of your employees with critical, timely business information tailored to their specific information needs. Every copy of SQL Server 2000 ships with a suite of Bl services.
Self-Tuning and Management Capabilities
Revolutionary self-tuning and dynamic self-configuring features optimize database performance, while management tools automate standard activities. Graphical tools and wizards simplify setup, database design, and performance monitoring, allowing database administrators to focus on meeting strategic business needs.
Data Management Applications and Services
Unlike its competitors, SQL Server 2000 provides a powerful and comprehensive data management platform. Every software license includes extensive management and development tools, a powerful extraction, transformation, and loading (ETL) tool, business intelligence and analysis services, and new capabilities such as Notification Services. The result is the best overall business value available.
SQL Server Standard, Developer and Enterprise Editions
Standard edition is an affordable option for small and medium-sized organizations. It includes the core functionality needed for non-mission-critical e-commerce, data warehousing, and line-of-business solutions. For instance, all of the XML features present in Enterprise Edition are also included in Standard Edition. And while a handful of advanced OLAP features are reserved for Enterprise Edition, all data mining features and the core OLAP functionality are included in SQL Server 2000 Analysis Services in Standard Edition. Similarly, components that other database vendors charge for as separate add-on products for their highest-end editions are included in Standard Edition: Data Transformation Services (DTS) Replication (snapshot, transactional, and merge) Full-Text Search English Query Stored procedure development and debugging tools SQL Profiling and performance analysis tools. ¦
Enterprise Edition includes the complete set of SQL Server data management and analysis features and is uniquely characterized by several features that make it the most scalable and available edition of SQL Server 2000. It scales to the performance levels required to support the largest Web sites, Enterprise Online Transaction Processing (OLTP) systems and Data Warehousing systems. Its support for failover clustering also makes it ideal for any mission critical line-of-business application. Additionally, this edition includes several advanced analysis features that are not included in SQL Server 2000 Standard Edition. There are four main areas in which the additional features of SQL Server 2000 Enterprise Edition are most evident: Scalability Availability/uptime Performance Advanced analysis
Enterprise Edition (64-bit) provides the most scalable data platform to take advantage of the class of Intel Itanium-based servers. Addressing more memory than any other edition of SQL Server, it scales to the performance levels required to support the largest Data warehousing and analysis applications, ecommerce websites and Enterprise business systems. Supporting up to 8 nodes in failover clustering, SQL Server 2000 (64-bit) provides a high level of reliability and availability for your mission-critical applications.
Introduction to Database Server Backup Technology
Those who are new to database server technology may need a quick
Orientation on the difference between inline database server backups and normal file backups. The data files associated with an application database are opened exclusively by the database server process, and therefore performing a file based backups of the individual data files is usually not possible unless the database server is stopped to perform the file backup operation. File based backups do not offer several options provided by server backups, and so should be avoided.
Database server backups involve invoking a special online backups process with in the database server. Once a backup process has been initiated, the database server proceeds to stream backups information in a very high performance fashion to a backup device , which can be either an operating system file or some other kind of media such as tape device. A database backup can be performed even if there are active user transactions in the database. Once the backups completes, the backup device will contain a snapshot of the database as it exited when the backup process was initiated. This snapshot includes any active uncommitted transactions that may have been in progress at the time the backup was initiated.
When a database is restored from a backup device, it will be restored to the same state that existed when the backup process was initiated. When the restore operation is complete, the database will be put through a normal recovery process. Any active transaction that were committed to the transactions log but not yet written to the data file will be "rolled forward", and any active, uncommitted transactions that were running when the backup was initiated will be "rolled back". This recovery process ensures that the database will be recovered to a consistence state.
A single backup device can contain multiple "backup sets", which can be used later to restore the database. E.g. a backup device can contain a full backup as well as several transactions log backups. If a backup device is implemented as a operating system file, this file can be backed up using conventional file backups procedures instead of trying to backup the open database files themselves.
System Requirements
H/W Specification
PROCESSOR CLOCK SPEED SYSTEM BUS RAM HDD
MONITOR KEY BOARD MOUSE FDD
PRINTER
PENTIUM III and above
500 MHz
32 BIT
128MB
3 GB
SVGA COLOR 108 KEYS LOGITECH 1.44 MB HP
S/W Specification
OPERATING SYSTEM
SERVER
FRONT END
BACKEND
BROWSER
CONNECTION
PROTOCOL
WINDOWS 2000 SERVER IIS
ASP .NET(scriptinVB.NET) SQL SERVER 2000 INTERNET EXPLORER 6.0 TCP / IP
HTTP, SMTP, POP3
System (Design
Input Design
Input is considered as the process of keying in data into the system, which will be converted to system format. People all over the world who belong to different cultures and geographies will use a web site. So the input screens given in the site should be really flexible and faster to use. With highly competitive environment existing today in web based businesses the success of the site depends on the number users logging on to the site and transacting with the company. A smooth and easy to use site interface and flexible data entry screens are a must for the success of the site. The easy to use hyperlinks of the site help in navigating between different pages of the site in a faster way.
I have concentrated a lot in designing the site and formatting of the web pages. The site navigation and the customized error messages are formed in such a way that it attracts the more people to the site. The options for input data entry are as follows.
1) Add
The adding option in each of the forms helps in keying in data to the system. Web based features like emailing of the keyed in data to the user etc. are included in this. For commercial and security reasons some of the adding options are restricted to the administrators of the site.
2) Edit
The editing option helps in updating the user data. Web based features like emailing of the modified profile to the user etc. are included in this. For commercial and security reasons some of the editing options are restricted to the administrators of the site.
3) Delete
The deletion option helps in removal of data from the system. For commercial and security reasons some of the deletion options are restricted to the administrators of the site.
4) Search
The option helps in searching for the data available in the database. Since web sites are visited by large number of people on a daily basis the searching option is very important for the end users of the site as well as from the point of view of site administrators. For maximum effectiveness we have added features like 360-degree view of search results etc.
5) Print
The printing option helps the users of the site Print the search results as well as the updated profile of the users and other details from the site.
Output Design
The success or failure of a software is decided by the integrity and correctness output that is produced form the system. One of the main objective behind the automation of business systems itself is the fast and prompt generation of reports in a short time period. In today's competitive world of business it is very important for companies to keep themselves up to date about the happenings in the business. Prompt and reliable reports are considered to be the lifeline of every business today. At the same time wrong reports can shatter the business itself and create huge and irreparable losses for the business. So the outputs/reports generated by the software systems are of paramount importance.
Web site such SCM, ERP and CRM deal with reports that are highly complex in nature. Other end user and e-Commerce sites also deal with reports which are considered to be the lifeline of these web sites. Reports are divided into 4
types. 1) Statutory or Legal reports 2) Internal Reports 3) End User Reports and 4) System Reports
1) Statutory Reports
These reports which should be submitted to the Govt, authorities like Tax Departments , Registrar of Companies , Share Holders etc.
2) Internal Reports
These type of reports are used by the management and staff of the organization. They help the management and staff in planning, organizing, coordinating and controlling the activities of the organization.
3) End User Reports
These are reports of ordinary nature, which are generated by the user of the site. This include transactions Report etc. etc.
4) System Reports
They are reports generated by the system for the administrators and managers of the site. These include user registrations reports, site management reports, performance analysis report, database status reports etc. etc.
Stock Depot Module
Testing is the penultimate step of software development. An elaborate testing of the data is prepared and the system is using test data. While doing testing, errors are noted and correction is made. The users are trained to operate the developed system. Both hardware and software securities are made to run the developed system successfully.
System testing is aimed at ensuring the system works accurately before live operation commences. Testing is vital to the system. System testing make a logical assumption that if all part of the system are correct the goal will be successfully achieved. The candidate system is subjected to a variety of test: Online Response, Volume , Stress Recovering and security and usable tests. A series of testing are performed for the proposed system before the system is ready for user acceptance testing. Nothing is complete without testing, as it is vital for the success of the system.
The entire testing process can be divided into three phases.
¢ Unit testing
¢ Integration testing
¢ Final / System testing
Testing Process
When a system is developed, it is hoped that it performs properly. In practice, however, some errors always occur. The main purpose of testing an information system is to find the errors and correct them. A successful test is one which finds an error.
The main objectives of system testing are :-
¢ To ensure during operation the system will perform as per specifications.
¢ To make sure that the system meets users requirements during operation.
¢ To verify that the controls incorporated in the system function as intended.
¢ To see that when correct inputs are fed to the system the outputs are correct.
¢ To make sure that during operation, incorrect input and output will be deleted.
The scope of a system test should include both manual operations and computerized. Operation System Testing is a comprehensive evaluation of the programs, manual procedures, computer operations and controls. System testing is the process of checking if the developed systems is working according to the original objectives and requirements. All testing needs to be conducted in accordance to the test conditions specified earlier.
Unit Testing
Unit Testing focuses verification efforts on the smallest unit of software designs module. To check whether each modules in the software works properly, so that it gives desired outputs to the given inputs. I tested all the validations and conditions for each units by inputting different types of data and checking the corresponding outputs. I tested the control paths by checking all conditions for minimum, maximum and medium values, flow of data and loops. Control paths are tested to ensure the information properly. Flows into, and out of the program unit under test. Boundary condition is tested to ensure that the modules operate at boundaries. All independent paths through the control structure ensure that all statements in a module have been executed at least once.
Integration Testing
The major concern of integration testing is developing an incremental strategy that will limit the complexity of entire actions among components as they are added to the system. Developing a component as they are added to the system, developing an implementation and integration schedule that will make the modules available when needed, and designing test cases that will demonstrate the viability of the evolving system. Though each program
works individually, they should work after linking them together. This is also referred to as interfacing. Data may be lost across interface and one module can have an adverse effect on another. Sub routings, after linking, may not do the desired functions expected b y the main rooting.. Integration testing is a systematic technique for constructing program structure while at same time, conducting test to uncover errors associated with the interface.
Validation Testing
Data validation is done to see whether the corresponding entries made in the tables are correct. Proper validations are done in case of insertion and updating of tables. If any such case arises, then proper error messages or warning, if any, has to be displayed.
The different test cases are:-
¢ Guarantee that all independent parts within a module have been excercised at least once.
¢ Exercise all logical decisions on their true or false side.
¢ Exercise all loops at their boundaries and within their operational bounds
¢ Exercise internal data stricture to ensure their validity.
¢ Each module was tested and the tested modules were linked and integration test was carried out.
Undertaken in this project an acceptance test as the objective of selling the user on the validity and reliability of the system. It verifies that the system procedures operate to system specification and that the integrity of vital data is maintained. I tested the system with a large collection of records. The system is found to be user friendly.
eSCM
"6 rž. ¦
"¦fa File Window Help
% P 0
Column Name Data Type [Length | Allow Nulls |
T "3BBBI varchar 50
password varchar 50
Column Name
Data Type
File Window Help
LengthT Allow Nulls]
ateaoryid
numeric ¦varchar
9
50
J
"^j File Window Help
Column Name Data Type Length Allow Mulls
name
address
userid
password numeric varchar varchar varchar varchar varchar
50 50 50 50 50
V V V V V
n SQL Seiver Enteiprise Manager - [Design hible de.pi.-tdetails' in
File Window Help
ji % *g qr (I
Column Name Data Type [Length! Allow Nulls J
companyid numeric 9
fi stockdepotid numeric 9
region varchar 50
userid varchar 50
password varchar 50
stockdepotnarne varchar 50 f :
^§0 File Window Help
«5 H
Column Name Data Type |Length Allow Nulls j
JL depotid numeric Q
country varchar 50
state varchar 50
T address varchar 50 f""i
phno numeric 9 V
fax varchar 50 V
email varchar 50
I ¥
order id
1 f pdtid
| quantit
rate total
numeric numeric numeric numeric numeric
"^j File Window Help
Column Name
Data Type Length j Allow Nulls
distributorid pdtname currentqty unitprice
numeric varchar numeric numeric
IcfWi w.wH>,ei -[Design Table 'inbox1 in SHGSCM'
S*^S##v^r Enterprise Managei - [Design Table 'invoir.emastet^ft ^g^.
"|jjrj File Window Help
I 3 ® % % ¦ dj ffe ocg
Column Name Data Type Length j Allow Nulls
invoicenumber numeric 9
invoicedate datetime 8 V
distributorid numeric g
T orderid numeric 9 ! J
totalamount numeric 9
tu SQL Seiver Enterprise Manage
Column Name Data Type Length | Allow Nulls!
orderid numeric 9
productid numeric 9
T quantity numeric 9
†rate numeric 9
S** Vver Enterprise Manager^[0^nTalih'pMducli'in*SM&CM'j
'j^j File Window Help
Column Name Data Type | Length | Allow Nulls |
1 productid numeric 9
.name varchar 50
categoryid numeric 9
subcategoryid numeric 9
†.dealerprice numeric 9
retailprice numeric 9
image image 16 V
20
9
9
V V
CREATE PROCEDURE CategorySelect as
begin
select * from category
end
GO
CREATE PROCEDURE checklogin
@userid varchar(50),
@pwd varchar(50)
AS
begin
select count(*) from depotdetails where userid=@userid and
[password]=@pwd
end
GO
CREATE PROCEDURE getdepotname
©region varchar(10)
as
begin
select stockdepotname,stockdepotid from depotdetails where
region=@region
end
GO
CREATE PROCEDURE geteachproduct
@subcatid numeric
as
begin
select * from products where subcategoryid=@subcatid
end
GO
CREATE PROCEDURE pdtload
as
begin
select name.productid from products
end
GO
CREATE PROCEDURE subcategoryselect
@catid numeric as
begin
select * from subcategory where categoryid=@catid
end
GO
eSCM
j SBlsi
^1
About Pi-Contact Us
1 Depot details
ShowAJI Depot
Update company
ShowOrderDetails )
Enter Category
Check Mail
File Edit View Favorites Took Help
About 1J> Contact IFa
Stock Depot Details
Company name JHL
Region North
User Name juser
Password 1"**°.°**.
Retype Password
Stock Depot name [v^Hl _
dl
prl wel
125-:
67
South India 1 anulmdii t-5.ch«uui 44 09¬78 ; 345-!
MP A'4'.UP 123
Delhi 12/H.apttr 23 4354; a[at]yriioo.com;
Local rtranet
Hi Ed* View Favorites lock Help
"Welcome ' HL '
Hone
iTgfrJ ¦ >
File Edit View Favorites Tools Help
Of Back ¢ ^ _*i , S«r.' f =avor*« r'^.j
hup- rVTocalwrJ^WCesCrl/ftj^vcjot i .htir,
User Name
Password
Stock Depot Name
Sign In
Tod* HHp
©** ¢ - * *¦ *. / *¢* irr'««» <> iS*'^ S3" 0 IK <4
EE
Abcut Vs Contact U3
¦gdcr Products
.; how Al Diitrit.iifcr Srier Pro iicts
¦ 3 Me^-ed (*»r v
06w * * * *Ji /5 Search ^Favortes £J jgj- ^ 55 '
. ,H*,:-5r/5r*iESCrtfFrameset 1 .htm
Unit Price Rate
Product Name : Hp Printer Quantity 134 i saw 1
'About Us Eâ€
Product Name1;- ¦ Gorjrej 3 10000 Quantity
5fX«"> | save [
Contact Us Product Name ¦' JHP Quantity i | save |
Product Name !hp Quantity i i save"!
Product Name "hp Quantity r 1 s«e 1
Fie Ed* View Favonte* Took Help
Qtock - © - ,*5 ft /"Search -^Favortes 0
From ;e[at]e.com
To ;ti©y com
Subject jinvoice received
Body ;¦' hello. INVOICE recelveedj
*j Local intranet
. . .
Fie E<* View Favorites Toob Help
About 0*g Contact Us
User Name DISTRIBUTOR Password *¢¢*¢Â»¢!
J Sign In'J
Sign In
Order Products
/iew Order Status
Invoice Details
- *j Local rtoanet
The software which we developed was implemented and tested with real data and were found to be error free. Also, it is found that the system will work successfully. We tried to make the system maximum user friendly. Stock transfer is the main consideration in this project. The system is protected from any unauthorized access by giving user name and password during log in process. All the necessary validations are carried out in this project, so that any kind of users can make use of this software and necessary messages makes them conscious of the error they have made. This software is developed with scalability in mind. Additional modules can be easily added when necessary. The software is developed with modular approach. All modules in this system have been tested separately and put together to form the main system. Finally the system is tested with real data and everything worked successfully. Thus the system has fulfilled all the objectives identified and is able to replace the existing system. The advantage of this system is that, this package can be easily incorporated with another package.
(Bibliography
1) Gary Cornell&Jonathan Morrison, "Programming VB.NET" Pares publications
2) Billy Hollis,Rockford Lhotka, "VB.NET Programming"Shrove publications & Distributors Pvt.Ltd
3) Mike Gunderloy,Joseph L.Jorden, "Mastering SQL server2000" BPB Publications,New Delhi,First Indian Edition 2001
Websites
1) http://msdn.microsoft.com
2) http://wrox.com
