Online Computer Store .Net Project

INTRODUCTION

The project entitled “ONLINE COMPUTER STORE” is a web-based application software developed in ASP.Net using C# as front end and SQL Server as a backend.

Client Server Technology

Client/ Server with RDBMS and Web-Based Application

The proposed Online Computer Store system comes under Client/ Server with RDBMS category, as there is need to manipulate the transaction online network based for multi-user and faster and the quires output in quick successive time and also the highly secured. This Online Computer Store project is categorized as Relational Database Management System (RDBMS) which is base on client-server architecture. In client Server architecture the interface for use is created in any programming language (Front-end) and the database where data is stored is called back end. The user interface is treated as a client to which user request for data and user interface sends the user request to the server as database and the server returns the data required by the client program manipulation.

SYSTEM REQUIREMENT

(A) Hardware Requirement-

• PROCESSORS: Pentium 4/Celeron/Dual Core/ Core 2 Duo/Core i 3 /Core i 5
• RAM :1 GB/2 GB/4 GB
• CD/DVD DRIVE
• HDD:40 GB /80 GB/160 GB
• MONITOR :16 “ SVGA
• POINTING/OPTICAL DEVICES: (MOUSE), ONE MICROSOFT NATURAL PS2 KEY BOARD

SYSTEM REQUIREMENT

(B) Software Requirement-

Internet Technology:
Front End
 ASP.Net
RDBMS/BACK END: MICROSOFT ACCESS 2003
Language: C#
Scripting Language: Java Script.
Web Server: IIS(Internet Information Server)
Operating Systems: Windows 7, Windows XP sp2, sp3, Windows 2000 server, Windows server 2003
Application: Web-Based Application

MODULES

Basically, there are four modules. They are as follows-

1. Admin
2. Customer
3. Support
4. Report generation

1. ADMIN- An ‘ADMIN’ is a person who manages all the deeds related to the product. For instance-
• Product creation
• Change price list
• Set discount & offers
• Check the minimum level of product
• Daily sale/purchase report

2. PRODUCT ENTRY- A ‘CUSTOMER’ is a person who visits on the site, make his account, login to the site and then take services given by the providers of the site. For instance-
• New registration
• Login for existing member
• Paid a sales invoice
• Product delivery report

3. PRODUCT PURCHASE- The ‘SUPPORT’ is an area where consumers can give their views and advices related to the product. For instance-
• Customer feedback entry
• Solution of feedback
• Product query.

4. USER LOGIN- The ‘REPORT GENERATION’ module defines all the information related to the project. For instance-
• Customer status report
• Supplier status report
• Product status report

 

DATABASE DESIGN

Admin: This entity store Username and password of the administrator.

Name Data type Key Constraints
Username varchar(20) Primary key Not Null
Password varchar(20) Not Null

MEMBER: This entity store the information of new member.

Name Data type Key Constraints
First name varchar(20) Not Null
Last name varchar(20) Not Null
Address Varchar(100) Not Null
City varchar(20) Not Null
Country varchar(20) Not Null
Contact No. numeric
Email varchar(40) Primary Key
Password varchar(20) Not Null

 

Product Category: This entity store information of products category like mobile, computer, electronic items etc.

Name Data type Key Constraints
Category_Id int Primary Key
Category Name varchar(20) Not Null


Product Item:
 This entity store the information of product items.

Name Data type Key Constraints
Product_Id int Primary key
Category_Id int Foreign Key
Product Name varchar(20) Not Null
Rate numeric Not Null
Unit numeric Not Null
Opening Stock numeric Not Null

Product_trans: This entity store the information of product transition.

Name Data type Key Constraints
Invoice No int Primary key
Member_Id int Foreign
Product_Id int Foreign
Trans_Date int Not null
Qty Numeric Not null
Amount Numeric Not null
Discount Numeric Not null
Net _amount Numeric Not null
Trans_Mode Numeric Not null


Product Supplier:
 This entity store the information of product Supplier.

Name Data type Key Constraints
Supplier_id int Primary key
Product_id int Foreign key
Purchase_Date Date Not null
Qty Numeric Not null
Total amount Numeric Not null
Discount Numeric
Net Amount Numeric Not null
Payment mode int Not null

Software Project Organizer .Net Project

This Software Project Organizer .Net Project is developed to maintain organization’s total info like a number of branches, total working employees with their performance, worksheets, talent transformation, Company ongoing projects with full details, coding standards to develop an application, etc..

This project organizer in a software company application has the following main modules:

1. Branch Information Module:

This module handles the information of all the unique branches existing under the organization. The information is maintained in branch master table.
It also maintains the employees working under a particular branch, which can be known a report generated on employee master table grouping on branch id.

2. Employee information module:

It manages the following submodules

  1. Employee’s performance module.
  2. Employees took assignment module
  3. Employee’s skill set information module.

This module maintains the total information related to the employees working in the organization. Their designations and the departments in which they are recruited. It also gives the information regarding the employee’s performance within the organization related to their job targets. It manages a clear history of an employee skill sets and defines the role played by the employee in a project and the area of his interaction in the project i.e., at the level of project or module component of elements.
It also maintains department master table.

3. Project information management module:

It maintains the total information related to the unique projects that have been signed for a contract of development. The module reveals the information regarding which project belongs to which client and the associated employee who is in charge of the overall project.
The major concentration is surrounded by the facts table, which clearly specifies how many modules a project manages with respect to no. Of components in each module and the no. Of elements in association with each component.
The module also specifies the duration of each entity with respect to the role played by each employee and the entity level in charge.

4. Package information module:

This module manages the entire information regarding the different types of packages that are purposefully used by the organization in their project development process and specifies the required packages list to complete a signed project. It also relates itself to know the different packages an employee can handle, which can serve as an information to recognize which employee can be resourceful to which type of project.

5. Project documentation Module:

This module maintains the overall information related to all the documents that are produced in course of project development process by different employees with respect to different areas of the project.
The module also serves to build on online help like system for the sake of user convenience and serves as a reference material to the developers as well as users.

6. Employee’s performance management module:

This module maintains the specific time levels taken by the employer in completing his tasks in turn serving the project analysis team to get the history of employees response towards an assigned task. The information from this module can be used as a cross-referential check to know the rating levels of the employee as designated within the company.

7. Report designing module:

This module practically manages the descriptive reports that are necessary within the organization as per the requirements of the information format at different levels of designations or departments.

Software and Hardware Specifications:

Hardware:

Processor : Intel Pentium 4 Processor with 700MHZ or more
Ram : 256 MB or more
Cache : 512 KB
Hard disk : 20 GB hard disk recommended.

Software:

Operating system : Windows 2000 SERVER
Front End Software : ASP.NET
Code behind : VB.NET (Visual Basic .NET)
Validations : Jscript
Back End Software : SQL Server 2000

Secure Multimedia Audio & Video Streaming .Net Project

Introduction

Purpose

This project is used to efficiently uses the Bandwidth when downloading Audio/Video files by using Streaming Procedure. Streaming is nothing but a process of Transferring data(Audio/Video) from source system to destination in the form of bits/ bytes through an application.

For example, suppose 100 users log in to the web server, there will be less bandwidth when uploading/downloading the files from the web. So by introducing a Streaming concept, we can reduce the time required for uploading/downloading the audio/video files.

Document Conventions

To prepare this SRS we had used the lettering style of Times New Roman and Font size we used for sub had subheadings which are of bold. The matter which is mentioned in this SRS is 14 with a lettering style Times New Roman. Then coming to the part of headings which are of lettering style Times New Roman which is of Font size 16.Then next coming to the part of important point in our SRS is shown through the italic box.

Intended Audience and Reading Suggestions

This SRS is for better understanding the concept of Streaming. The rest of the part of the SRS is mentioned with the what our product benefits, how to use the product, how the product was developed, what are the major things we have taken in to the consideration all are mentioned in this rest of  the part of the SRS.

System Features

There are four modules which need to be develop are

Streaming Module:

Defines the procedure of transferring the Audio/video files in the forms of streams. Each audio/video file is converted into bit and bytes while playing the file. Each part of downloaded bit and bytes stream is played along with the corresponding another part is downloaded in parallel.

Users:

It defines how the users have to be interacting with the site. Each user has own authentication based on the registration done. All the users information is maintained corresponding to their audio/video files downloads.

Search Module:

It involves using of various search criteria’s to get required audio/ video files. Various search criteria’s to search for the songs like user can search for the required song based on song wise search, artist wise search etc.

Uploading and Downloading Audio/Video:

It provides the procedure of uploading the Audio/Video Files. Uploading of different audio/video files and downloading is audio/video files based on the file type like payment type or free.

Information Screen in Share Marketing .Net Project

In this Information Screen in Share Marketing system, Login Screen contains an online catalog for the user, The menu should contain following screens: Registration Screen it is used by Insurance agent which is for registering this system, Stock registration Screen facilitates the trader to add a new share that he/she has purchased and sold those stocks which are not  purchased. Other forms like Stock Performance Screen 1, Stock Performance Screen 2, Asset Indicator screen, Buy Stock Request screen, Sell Stock Request screen, Sell Stock
Request screen, Buy Stock screen, Sell Stock screen, Sell Stock screen.

PROJECT DESCRIPTION

The project titled “INFORMATION SCREEN IN SHARE MARKETING” is designed using Active Server Pages .NET with Microsoft Visual Studio.Net 2005 as front end and Microsoft SQL Server 2000 as backend which works in .Net framework version 2.0. The coding language used is C#.Net.

The project contains the following main modules:

The project contains three main modules:

1. Home
2. Administrator
3. Share Holder
4. Company
5. Contacts

Home:

The home module is the main page of this system. In this page all modules link are available.

Admin:

The Admin Login page contains the following submodules.
1. View Share Holders
2. View Company Information
3. View Shares.

View Share Holders

• It consists of the information of the shareholder
• Company name, city, mobile number, share amount, number of shares and the name of the shareholder
• It contains the hyperlink to go to first, last, previous and last page

View Company Information

• It consists of the information of the company who announces their Shares
• And also display owner of the company, company name, city, mobile number, Number of the employee, last year profit, and current year profit, group.
• It contains the hyperlink to go to first, last, previous and last page

View Shares:

This page contains all the information about shares who are sold and buy.

Share Holder:

The Shareholder login page contains the following submodules.
1. Buy Shares
2. Sell Shares
3. My Profile
4. View Shares

Buy Shares:

It displays the Share rate and how much shares are available for which company. From that page, we can buy the particular shares online.

Sell Shares:

It is the option of selling our shares to the broker through online.

My Profile:

The profile page consists of the details of that shareholder.

View Shares:

It displays the whole share details with all modifications.

Company:

The Company login page contains the following submodules.

1. Buy Shares
2. Sell Shares
3. New Shares
4. View Shares

Contacts:

The contact page contains the Address of the broker as well as owner.

SYSTEM SPECIFICATION

SOFTWARE SPECIFICATION

The software used for the development of the project is:

OPERATING SYSTEM : Windows 2000 Professional, Latest OS
ENVIRONMENT : Visual Studio .NET 2005, Latest Edition.
.NET FRAMEWORK : Version 2.0
LANGUAGE : C# .NET
WEB TECHNOLOGY : Active Server Pages.NET
WEB SERVER : Internet Information Server 5.1
BACK END : MS-SQLSERVER 2008
REPORTS : Web Form Data Grid control

Mobile Payment System .Net Project

Abstract

The project entitled Mobile payment system is an application to assist mobile phone users to access the information of different bills, send and receive a request from almost anywhere, anytime.
At the single touch of a button, the user is provided with an array of information. This project mainly caters to the professionals. Housewives and also business people who like to save their time and do their work in the home.

Mobile Bill Online Payment system has the most advanced set of accessibility features for providing users with a flexible, user-friendly interface. Some of the exclusive features of this application include accessing the data at the server and retrieving the data from the database.
When a user selects to launch Mobile Bill Payment, he is logged on to a screen where he is asked to select which service he would like to access. Then based upon the users choose the user is presented with a list of the particular service bill details. If the user selects the options provided on the screen given he is instantly provided with the information pertaining to that particular service.

Scope:

The objective of this system is to provide a solution to make payment of the Bills and recharge the mobiles using a single window system. In this system, the Administrator should able to add new Vendors of the mobile company to the system. The Administrator will add or update the different offers provided by the company which can be done through online. If the customer is facing issues in Online payment or other transactions he/she should able to register Complaint to the Administrator to the system.

Out of Scope:

• Online Payment for recharge amount is should reflect in customer bank account.
• After recharging to the mobile the SMS should be sent to the mobile as confirmation of the transaction.

Modules:

1 Administrator
2 Customer
3 Web Registration
4 Reports
5 Authentication

Administrator

• Should able to add new Vendors of the mobile connection company.
• Should able to add or update the different offers provided by the Vendors which can be used by the customers through the internet.
• Should able to receive the Complaint from Customers for the transaction related issues.
• Should update the Mobile numbers from Vendors into the system.

Customers

• Should able to register to the site to get pay the Mobile bill online.
• Should able to Recharge their mobile with different top-ups provided by the vendors. The mobile number given by the customer will be cross verified by the Vendors (using the vendor database).
• Should able to register Complaint against the issues in Recharge or Mobile Online payments.
• Should able to check the previous payment details as History.

Registration:

The system has a process of registration. Every User need to submit his complete details in the form of registration. Whenever a User registration completed automatically he/she can get a user id and password. By using that user id and password he/she can log into the system.

Reports

Different kind of reports is generated by the system.

1. Customers Report
2. Complaints Report

Web Mining Project in .Net

Abstract:

Web mining is the useful website for students in this we have a large amount of data which is very useful to different category students it has data about many subjects. In this, we have mainly two types of sites like adaptive sites and video library. Adaptive sites contain information like java and .net framework. Video library has information about different things like databases, technologies, multimedia, and scripts. In this it again divided into subtypes like Oracle, SQL server etc. in this we have large amount of information

Modules:

  • adaptive sites
  • video library.
  • search. 

Adaptive sites:

In this, we have information about different programming languages like Java and .net in this there is a huge amount of information about programming languages it is very useful for basic learning students.

Video library

In this, we have very large amount of information for different technologies like databases, technology, multimedia, scripts in this it is again subdivided into different types like if we take database we have information about Oracle, SQL server. If we take script languages means we have java server pages, active server pages, PHP, python etc

Search:

In this module, if you have any doubt you can search it in the search bar in this enter your language you need and press search button you will get information about related search item.

System Specifications:

Hardware Requirements:                      

  • Pentium-IV (Processor).
  • 256 MB Ram
  • 512 KB Cache Memory
  • Hard disk 10 GB
  • Microsoft Compatible 101 or more Key Board 

Software Requirements:                                

  • Operating System:           Windows XP
  • Programming Language:           C#
  • Web-Technology:           Asp.Net 2.0
  • Back-End:           SQL Server 2005
  • Web Server:           IIS

Software Requirements Specification for Student Management System

This is the Software Requirements Specification for Student Management System, Which is developed using .Net and SQL Server.

1: Introduction

1.1 Purpose

Our product is student management system gives all the services that must be provided to a student over the internet to find fee details provided by that administrator of the college.
This product contains each and every data regarding student, payment etc., personal details which can be updated by the student and viewed by the administrator. It provides the detailed information about the fee details and the location (place) of college. Our product is a subpart of university management system.

1.2 Intended Audience and Reading Suggestions

The intended audience for this Student Management System document is the internal guides of the organization where the team has developed the project. Further modifications and reviewing will be done by the organization and deliver a final version. The final version of this document is reviewed by the Internal Guides and Head of the Department of the college.

1.3 Project Scope

Our Student Management System product usage makes work done at the faster way the software is applicable to view the fee details provided by the administrator of the organization and student can edit his personal details which can be viewed by the administrator.

2: Overall Description

2.1 Product Perspective

Student Management System is capable of managing each and every data regarding student, payments etc. Student Management System helps us in managing in an extremely efficient way. This Student Management System works in an efficient manner.

We have two modules in this project. One is admin and other is the user. Admin can maintain the fee details of students and can generate the reports can export the details to excel. User module can edit their personal details and can view the fee details.

2.2 Product Features

  • Reduces the manual workload.
  • Complete details of the student can be stored and retrieved.
  • Admin can see all the student’s payment details and also export to excel sheets.
  • The student can view all his details, payment details and the location of the college.

2.3 Design and Implementation Constraints

The Student Management System software is designed in such a way that the user can easily interact with the screen because of GUI. The admin and the user are the two users who use the project. The admin inserts the details of the students and the fee details that the students have paid. User/ student can view his/her details, update if required and check the fee details.

Software requirements:

• Microsoft .Net framework 3.5
• Microsoft Visual Studio 2008
• Microsoft ASP.Net 3.5
• Microsoft C#.Net language
• Microsoft SQL Server 2005
• ADO.NET
• HTML

Hardware Requirements:

Processor: Intel Pentium 4 or more

Ram: 1 GB or more

Hard disk: 40 GB hard disk recommended for the primary partition.

2.5 User Documentation

In our user manual, we are going to keep the information regarding our product which can be understandable by a new person who is going to use it. If a new person is using it online help will be provided in that we are going to explain each and every step clearly by our product can be useful for any user.

3: System Features

This Student Management System project is divided into 2 modules

1. Administrator and
2. User

Module Description

Admin: Admin is a person whose responsibility is to maintain the database that contains each and every data regarding the all the student. Admin can add student details into the database, can be able to delete student details and can update the student fee details.
Admin has some other responsibilities they are
• Admin is can maintain the fee details of each and every student.
• Admin can generate the reports of the students and
• Admin can export the details to excel.

User: Here the user means the student. The responsibility of the student is to login into the site and can view his/her fee details and can able update his/her personal details if there is any wrong details are present. Whenever the student will register his/her name then the student will be given by one individual username and password. When the student will type the correct username and password then the will enter into another page. In that page, the student can select two options that are updated details and view details. A student can able to update his/her personal details and can be able to view the fee details but cannot update the fee details.

4: External Interface Requirements

Hardware Interfaces

We require LAN connection for interacting with the database and local computers for any help or any other requirement. We use TCP/IP protocol for communicating with local hosts. We also need a system with P4 processor; 1GB RAM and database memory.

Software Interfaces

We use MS.Net 3.5 and C#.Net 3.5 Programming language for writing the code for the project. ASP.Net 3.5 for creating the web pages, using GUI for login screens and interacting with the database. SQL server 2005 is used for creating the local and global database (server). Microsoft Visual Studio 2008 IDE for writings the programs. Operating system: Windows XP or higher version.

Communications Interfaces

The communications functions required by this product are LAN connection within the whole company so that the Admin, employee, and customer can interact with each other. We use TCP/IP protocol.

Local Search Engine .Net Abstract

Search engine is a web based application to search any information on internet. This Local Search Engine .Net project local search engine stores all the information for a particular locality (like hotels, restaurant, visiting places, home for rent, grocery store, online travel services, market places and so on) in a database.

So that if a new person comes to that locality he/she can use the local search engine to fulfill his/her requirement without any trouble .

This local search engine has a live chat application so that any person can place order online.

Software Requirements:

  • Windows (XP onwards)
  • SQL SERVER
  • MICROSOFT.NET
  • NOTEPAD

Store Management System .Net Project

Abstract:

Stores Management System is a project developed to automate the processes to reduce the clerical labor of the staff working in stores both technical and as well as accounts departments.

This system uses the latest technologies and cost-effective tools thereby providing the better control to the management by avoiding manual errors.

Stores management system is a web-based manufacturing system that enables a manufacturing industry to schedule its manufacturing operations based on the daily update of sales from its dealers.

Existing System:

In the existing system, all the details of the records are maintained manually. Details of the items are not maintained properly. Takes a lot of time and less security. Records are not maintained in a proper order. Loss of data may happen sometimes.

Proposed System:

The proposed system maintains the information in the database. It is used as an intranet application. This system provides high-security. This system provides easy business solutions to the users.

Modules:

Admin:

Admin will get login with a valid username and password. Admin can view the customer requests. Admin can add the details of the supply forms. Admin views all the customer information. Admin can add the material forms.

Customer:

Customer needs to fill the registration and get a valid username and password. The customer can make a request for ordering the form. The customer can accept the request and reject the request.

Conclusion:

Our project store management system has succeeded in managing the details and the list of materials in an easy way without taking much time.

Web Based Digital Watermarking .Net Synopsis

Abstract:

Web-based digital watermarking is a project developed to provide copyright protection to images over the web. The original content could easily be copied and displayed so this application provides copyright protection to the data. This application concentrates on the transmission of images safely through watermarking. where the authorized user only can obtain the images without distortion. On the request of user watermarking of the image is done. User watermarking can be retrieved and image can be viewed.

Existing System:

In the existing system, the process of watermarking has no copy rights. Less security. Takes a lot of time and the work done is not effective.

Proposed System:

The proposed system transmits images safely through watermarking. where the authorized user only can obtain the images without distortion. On the request of the user, we take the image and watermark image. Highly secured. Takes less time.

Modules:

Admin:

Admin can enter the application by entering a valid username and password. Admin can view the details of the user. Admin views the requests sent by the users and accepts the requests. Admin views the details of the file on which watermarking has to be done and sends to the users. Admin can send comments to the user.

User:

The user needs to fill the registration form and enter into the application by giving a valid username and password. The user can send the details of the file to the admin. The user can send request and images to admin. The user can view the comments made by admin.

Conclusion:

Our project web-based watermarking is a project which has successfully applied secure watermarking by providing copyrights to the user’s files on the web.