Distributed Channel Management System

            Propest Co. ltd is one of the popular companies for pesticides, which is expected to provide its valuable services to its customers efficiently. With the advent of new technology every task in modern life is being absorbed rapidly within the routine of human life. Such technologies are applied for various field to improve the overall system performance and to deepen the organization grow.

            Propest Co. has also thought of utilizing such technology to reach its expanding customer base and provide efficient service to the customer. The result one such attempt is this Product called Distribution Channel Management System.

            This product has been mainly designed to overcome some of the problems faced with the previous system. The main problem faced was unnecessary delay in information processing and expensive.

 3. Existing System:

Ø  In order to avoid unnecessary delay and minimize the flaws that existed in the previous system a follow up module for the existing system has been designed called the Distribution Channel Management System which takes concern for the customer service and the distribution of products to the various dealers and clients.

 4. Proposed System:

Ø  In order to avoid unnecessary delay and minimize the flaws that existed in the previous system a follow up module for the existing system has been designed called the Distribution Channel Management System which takes concern for the customer service and the distribution of products to the various dealers and clients.

  5. Features:

·   Automate the communication between the clients and the company.

·   Obtain feed back from the clients and dealers

·   Generate reports from dealers with specific requirement

·   Provide updated details of the company products

·   Generate and report the sales data in accordance with the specific dealers and product.

·   Obtain workshop details.

·   Attain each and every query of the user.

  6. Modules:

The application comprises the following major modules.

·   Dealers

·   Clients

·   Company Management

 7.   Module Description:

Dealer

•         Dealers can know information about the product that their company provides, so that they can market their products effectively.

•         They can know costs and discount information of the products.

•         They can about their clients and their detailed information.

•         They can get the company information and also can communicate with the administrator of the company.

•         They can interact with the clients by knowing their information and can market their products to the clients individually.

•         They can interact with sales employee and send the details of sales of product.

•         They can get assistance from experts on the different marketing strategies by communication with the company.

•         They can send feedback reports to the company about sales of their products and also about the present situation of the market

Clients

•         Clients can purchase products of the company through a secured purchasing system.

•         The are provided with the information about different products of the company.

•         They can know about dealers of the company and their location in the country and all of their information.

•         They can know the usage of the product and also about the material to be used in the usage of the specific product.

•         Clients can get valuable suggestions from experts and professors about the usage of the product and in other issues

Company Management

•         They can inform latest updates of their products to their dealers, clients.

•         They can locate the authorized dealers and can know their information.

•         They can maintain individual accounts for each dealer.

•         The sales dept. can interact with dealer dept. so that it can know up-to-date sales levels. That is this sales dept. takes updated sales levels as input and processes the transactions.

•         The sales dept. interacts with admin of the company.

•         Admin can receive information about the sales of the products to clients and dealers.

•         Sales dept can generate reports on sales and sends it to management.

 8. Requirements:

·         Hardware requirements:

Content	Description
HDD	20 GB Min 40 GB Recommended
RAM	1 GB Min 2 GB Recommended

·         Software requirements:

Content	Description
OS	Windows XP with SP2 or Windows Vista
Database	MS-SQL server 2005
Technologies	ASP.NET with VB.NET
IDE	Ms-Visual Studio .Net 2008
Browser	IE

Distance Erudition System

The project Distance Erudition (Learning) System is a web-based application, which deals exclusively with the online training programs for the employees of the company. It basically list-outs the available courses and time in which courses has to be completed.  It even eases the task of the company to review the courses and the training done by the employees. The company can assess the performance of each employee by the online exam conducted for the course.

   Only the employee of the company can access the system. The registered employee is provided with the online study material covering that particular course along with the corresponding question bank. The course is provided with different levels. Each level covers the sub-topic of the particular course. After reading the study material, the employee must write a test. The test contains random questions selected by the server from the question bank. The employee must qualify the test in order to go to next higher level. Once all the levels in the course are completed, he/she must qualify in a final test, which contains all the subtopics of that course.

In our system, employees are given the flexibility to change the password and can write any type of test (level test, entry test, final test) for 3 times. If the employee is unable to complete the training with in the stipulated time, then they can request the administrator to increase the training time period. The employees can even directly write the entry test for any level. They can view the study material of the completed levels of the registered course.

Software & Hardware Requirements:

Programming Languages	C#
Web Technologies	ASP.NET, HTML, CSS, Java Script
Databases	Microsoft SQL Server 2005
IDEs	Microsoft Visual Studio .NET 2005 and ADO.NET
Web Servers	IIS Web Server
Architects	Windows XP/2000
Productivity Tools	Microsoft Office (Word, Excel, and Power Point)
Design Tools	Microsoft Visio

DEFECT TRACKING SYSTEM

    Abstract of the project:

This project is aimed at developing an online defect tracking system useful for applications developed in an organization. The Defect Tracking System (DTS) is a web based application that can be accessed throughout the organization. This system can be used for logging defects against an application/module, assigning defects to individuals and tracking the defects to resolution. There are features like email notifications, user maintenance, user access control, report generators etc in this system.

The software is fully integrated with CRM (Customer Relationship Management) as well as CMS (Content Management System) solution and developed in a manner that is easily manageable, time saving and relieving one from manual works.

A: Following tasks can be performed with the application:

·         User Maintenance

·         Component Maintenance

·         Defect Tracking

·         Report

User Maintenance: Creating, Granting & Revoking access and deleting users from application.

Component Maintenance: Creating a component (application being developed/ enhanced), Granting & Revoking access on components to Users and Marking a component as “Active” or “Closed”.

Defect Tracking: Creating, Assigning defects to users, Modifying and Closing a defect. A defect screen should at least have following details

·         Defect Id and Title

·         Defect priority

·         Date created

·         Defect description

·         Defect diagnosis

·         Name of originator

·         Status

·         Resolution

Report: Generate reports on defects.

B: Following additional tasks also can be performed by this application:

·         Find User

·         Find component

·         Find defect

Find User: A search screen to find users and display results.

Find component: A search screen to find components and display results.

Find defect: A search screen to find defects and display results.

3. EXISTING SYSTEM:

Ø  Defect Tracking System is a web-based application designed to help a workgroup keep track of Defects and tasks via a shared central resource. The system was designed specifically with the IT department in mind, where quick access to shared data and history is a requirement, both from an internal organizational perspective, as well as to fulfill the needs of the customers.

Ø  It provides one roof solution for all the Defects issues in the software development.  It doesn’t provide any kind of solution to any kind of problem. It only acts as a means to transmit the issues and their details to the concerned office personnel with accuracy. It is a tool that helps in providing the solution for the Employee request Log in right time.

Ø  In addition to all these, it also maintains the preferences, customized settings, priorities, users, etc.  It is very critical to solve different kind of reports at a time in the existing system.  The IT departments have different Operational Administrators who were providing so many problems in each and every day. Tracking these defects is a tough job.

4. PROPOSED SYSTEM:

Ø  The development of the new system contains the following activities, which try to automate the entire process keeping in view of the database integration approach.

Ø  User friendliness is provided in the application with various controls. The system makes the overall project much easier and flexible to the end user. It can also be deployed over the Internet. Various classes have been used to provide file upload and mail features. There is no risk of data mismanagement at any level while the project development is under process. It provides high level of security using different protocols like https etc. The system Interface provides good environment to solve any kind of defect.

Ø  The system capture the overall details of any defect from this user interface and send it to the particular administrator. Every defect details must be stored in the centralized data base server which can be organized by the company.

5. MODULES:                                                

                  1) Administrator

                  2) Operational Administrator

                  3) Operator

                  4) Defect Tracking

                 5) Search

                 6) Reports

                 7) Registration and Authentication

Administrator

Administrator can perform these following tasks

User Maintenance

            Users of this system treated as employees. Employees can be recruited by the administrator. Administrator is only authenticated to assign roles to employees

Role Management

In this system role management can be done by the administrator. The roles can be classified into these types

·         General Employee

·         Net work Administrator

·         Data Base Administrator

·         Technical Administrator

·         General Administrator

Based on the employee experience administrator can assign different roles to various employees which are register into this system.

Component Maintenance

Here component in the sense of software which are using in this organization. The component can be classified into different types and modules

1.    Operating System Software

2.    Programming Software

3.    Networking Software

4.    Data Base Software

The above all tasks should be performed by Admin only.

User Maintenance: Creating, Granting & Revoking access and deleting users from application.

Component Maintenance: Creating a component (application being developed/ enhanced), Granting & Revoking access on components to Users and Marking a component as “Active” or “Closed”.

Operational Administrator

In this system who can responsible for solve any defect in the organization is treated as Operation administrator.  For every operational administrator we are having one target mail id.  Based on this mail id employee send his defect report. After receiving any defect from the employee, these administrators are responsible for sending an acknowledgement to the employees. 

After solving the defect the administrator can send a reply notice to the employees.

Operator

Here operator is treated as employee only. An operator role is sending defect report to the concerned operational administrators.  Operator can post the completed information regarding the defect which are facing by him.

Additional feature is having by an operator is he can set the priority of that defect. Based on the priority operational administrator can solve those defects.

Defect Tracking: Creating, Assigning defects to users, Modifying and Closing a defect. A defect screen should at least have following details and this defect report can be verified by concerned admin. After verify he can send the status to the employees.

·         Defect Id and Title

·         Defect priority

·         Date created Date and Time

·         Defect description

·         Operator Details

·         Operational Administrator

·         Status

Report: Generate reports on defects. Reports can be generated by the administrator.

Search: Search can be provided by every user of this application. Administrator can search what types of component are used in this organization. Employees can search their own profiles.

Registration and Authentication

Every user must be a registered person. This registration can be approved by the administrator. After successful completion of registration process a user can able to log in into the system. The user credentials can be validated in this authentication module.

Password management like forgot password and remember password features can be added in authentication modules.

6. Requirements:

·   Hardware requirements:

Number	Description
1	PC with 2 GB hard-disk and 256 MB RAM

·   Software requirements:

Number	Description
1	Windows 2000/ XP/ or Higher with MS-office
2.	MS-SQL server2000/2005
3.	Ms-Visual Studio .Net 2005
4.	Ms-Internet Explorer