Category: SQL Server Projects

Universal Feed Reader is a content management application that acts as a feed aggregator and feed manager. It is a web application that adds feeds, such as news, blogs, podcasts, and video blogs in one place to facilitate viewing. It allows its users to see and manage their registered feeds in one place. There are no restrictions on the formats of all RSS formats, the atom, etc. are supported, hence the name Universal Feed Reader Management System.

Problem Specification

In the current scenario, the user follows his favorite set of sites by visiting them manually and checking out if any latest are available or subscribes to them via email, then feeds are sent to his email. Both these methods are cumbersome and time taking. the user may skip some important updates on a site tired of clicking and navigating through pages on a website. Email feeds are also very uninteresting as they involve clicking on each email separately and also result in cluttering of Inbox.

Every user may have a list of his favorite websites that he wishes to follow regularly, a user may not be able to remember all these websites. So it is important to organize and store this list. Therefore the task is to automate these manual processes of navigation and organization. Hence, automation of the existing system is proposed as a solution to solve the problem.

UML Diagrams:

Use case Diagram:

Objective of Project

The main purpose of this application is to eliminate the need to visit each and every website manually to catch up latest updates, by organizing them in one place. And enable the user to read websites in an elegant and easy to grasp way, manage subscribed websites in a single place, and view feeds based on category.

Limitations of Project

It works only when the internet is available. It’s Not run on a Windows environment, it’s run only on the web environment. And all applications are not providing RSS.

Scope

The aim is to provide an automated and integrated solution to the process of feed reading and gathering. The user can now organize his favorite collection of websites and view them in a simple and interactive environment.

There are three types of users in this system. They are:

1. Admin
2. User

The following describes the Roles of all the users in this System.

1. Admin: An admin in the system takes care of authorization and authentication, responsible for background functions like crawling for feed updates. The process of the administrator is automated no external supervision is required.
2. User: A User feeds the application with his set of favorite URLs and organizes them based on category. The user after feeding a valid URL to the application can view the feeds from the website. He can even bookmark a specific URL in the feeds for later reference. He can also remove the URLs and categories that he previously added.

Modules

User/Register Module

This is the module responsible for the authentication and authorization of users. Register module is responsible for authentication of the user and adding to the database.

Updates Module

This module is responsible for calculating the number of updates of a particular URL, It has a background script that runs periodically and fetches the feeds and stores the URL and published date. It uses this information to calculate the number of updates since the user’s last visit.

Add/Remove Module

In this module, the Users can add or delete websites and organize them into categories. And can also add multiple websites at once.

Admin Module

This module enables the Users to share specific URLs/articles that they like on social networking sites like youtube.

PROBLEM IN EXISTING SYSTEM

• Need To go to every website for updates.
• No use of Web Services and Remoting.

SOLUTION TO THESE PROBLEMS

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

1. User-friendliness is provided in the application with various controls.
2. The system makes the overall project management much easier and more flexible.
3. Readily upload the latest updates, allowing the user to download the alerts by clicking the URL.

PROPOSED SYSTEM

To provide information about audits on a different level and also to reflect the current work status depending on organization/auditor or date. To build a strong password mechanism.

SOFTWARE REQUIREMENTS:              

• WINDOWS OS
• Visual Studio .Net 2012 Enterprise Edition
• Internet Information Server 5.0 (IIS)
• Visual Studio .Net Framework (Minimal for Deployment)
• SQL Server 2008 Enterprise Edition

Output Screen Shots Step by Step:

User Login :

Add RSS Channel Page

Display URL Page

RSS Channels to Read Page

Read RSS Feeds

Sorting Channel BY Type

Add Video Channel

Display Video channel

Read Video channel feeds

Change User Password

Admin Login

Admin Home

Admin Change Password

Display All Users page:

ReadRSS From Admin End

Read Videos From Admin End

Download The Universal Feed Reader .Net Project Source Code & Database.

Abstract:

Web mart online shopping paradise is a project developed to allow business grow larger and faster. Users can view and order products online from anywhere and anytime. Web mart sell different type of new products and services.web mart online shopping paradise services users online quickly and comfortably. This project develops an e-commerce store for the users.

Existing System:

The existing system is a manual system this is not an automated system.

Risk of mismanagement of data. Less security. No proper coordination between different applications and users. Fewer users – friendly. Accuracy not guaranteed. Not in reach of distant users.

Proposed System:

The proposed system is a visual store on the internet where customer can browse the catalog and select the products of their interest. Customer can receive the order within time and high security will be provided. Billing address, shipping address , shipping options and payment details can be selected by the customer.

Modules:

Customer:

Customer can register to the site and get a unique username and password. Customer can place the order by providing the details of the items. Customer can check the status.

Admin:

Admin gets login by valid username and password. Admin can view the request send by customers. Admin can add new products to the application. Admin can view all the details of the registered customer details. Admin can add, edit , update and delete the details of the products and sends the product to the customer.

Conclusion:

The main purpose of the system is to enable customers to browse and order from any part of the world and hence increasing business scope.

Abstract: Online shopping system is a system which is developed to improve the services of customers and vendors. The main features of this project is high accuracy,design flexibility and easy availability.This application allows customers to shop and buy the items online.

This online shopping system allows users to shop from anywhere and anytime.This system provides users to find more variety of products with fewer expenses.Users can compare multiple items at a time in this application.This application saves lot of time and users can avoid crowd for shopping.

This Online Shopping System application maintains the details of the customer payments,product receipts and all the details of the selected items.

Modules:

Users: User should fill the registration by submitting all the details like email and address. Users can make search for the product and add the item to cart. User can place order by completing the payment process.

Guest customers: Guest customers can view all the products and search for a particular items if he want to purchase the item he should get register to the application.

Admin: Admin can view all the transaction made by the users . Admin will add new products to the site.All the data regrading customers and the transaction will be saved by admin.

ENVIRONMENT :           

Web Technologies : ASP.NET

Language                 : C#

Database                  : SQL SERVER

Web Server              : IIS

Operating System   : WINDOWS XP

Context:

“ASP Training Institute” is a small company that specializes in IT related training. The company offers workshops for both individuals and organizations. Workshops can be offered in the company’s facilities and are open to both individuals and group registrations. “ASP Training Institute” also offers workshops for various organizations in their facilities. These sessions are to be attended by the organization’s employees only. The company has several full and part time staff with different areas of IT expertise.

As the business has grown, the ASP Training Institute company needs a computer system to handle information about workshops and registrations. Currently, registrations are made by phone and data is stored in an Excel spreadsheet. The company wants the new system to keep information about trainers and workshops as well as allow individuals and organizations to register for the workshops.

General Requirements

There will be three levels of users: administrator, trainer and registrants.

The Administrator will

1. edit his own credentials
2. create and edit trainer accounts
3. indicate which workshops will be offered each month
4. specify which trainer is assigned to which workshop, based on their expertise
5. generate a report for a specific workshop
6. lookup the status of a particular registrant
7. generate a report about the schedule of a particular trainer

The Trainer will

1. edit his/her credentials, contact info
2. update his/her areas of expertise
3. generate a list of registrants for a specific workshop
4. update his/her availability

The Registrant will

1. be able to register in the system
2. edit his/her credentials, contact info
3. be able to register for a workshop
4. be able to arrange a workshop in the case of an organization wanting to train their employees in their facilities.

Technology/tool to be used

The system will be a web based application that will be developed using ASP.NET and SQL server databases. I plan to use Visual Studio 2012, the code will be written in C# and I will use the SQL Server Express that comes with Visual Studio.

Traveler information system is a software application which is a computerized system. This system allows to maintain all the records related to agencies and customers travel information in a computerized way which saves lot of time. This System provides accurate, real-time traveler information which is viewed by many public transportation agencies.

Traveler information system provides a website to the users to use all the services. Websites first page is ‘about us’ which gives a small introduction to the customers about the site.

The next page shows ‘contact us’ and ‘contact information’ which provides the detailed information about the traveler agency which includes mobile number,telephone number,email,website and location of the agency.User can contact them for more information. The traveler acency page contains  fields at the buttom left of the page which includes agency register,login and home If the user is older member of the agency then he can get logged in by giving username and password. If he is a new user he need to get registered to the website by giving some personal information After submitting all the information user will get an valid agency id and password wher he can get logged with them an do the further activities. User can find customer reports,agency timings,logout and add branches fields on the left size of the page Agent will enter into customer queries page where he need to fill some information like send to customer name,customer mail id and agency mail id. After filling the details he will sent to the customer. Agency timings page where he need to fill all the information about agency name,bus no,timings,agency id and branch name and click the save button. All the information given by will be stored in the database. User can add a new branch by providing the information about the branch name.begin place-end place,contact,agency id and branch mail id and click the submit button User after clicking the submit button will create a new branch.The information given will be stored and displayed in a tabelar form Customer view page has registration,login and home fields The customer can get registered to the site by filling the personal details He can get logged in by using the valid customer id and password Customer can book tickets by filling the fields which include customer id,customer name,contact email id,luggage details,agency name,from details,to details ,date,comment and agency mailid and click ok button which start the process of booking the ticket Customer will get all his entered details in a tabler form and need to conform once before proceding Customer can check all the information entered by him  in the process of booking ticket Customer can cancel the ticket which is already booked. For this process he need to give the customer id,agency name from and to details Customer from the next time can open the site directly by giving the login-id and password and click login button Customer can view the branch details also Traveler information system provides an extra feature for the customer to view all the details of the other customer in the site

Customer can add new root by filling the details of travel agency name,root to and from,email amnd phone number and click submit button