Online Medicine Search Web Application .Net Project

SYNOPSIS

This “GOOGLE A MEDICINE” is an online medicine search web application. This application allows a visitor to search for a medicine and addresses of medical stores (wholesale and retail sales) where the medicine is available. This application is a solution. So, this web application is planned to develop based on the requirements of the client.

The client is a small scale pharmaceutical company that is distributing generic medicines to emergency medicines and having a good network of medical (retail) stores. Main need of the client is to prepare an online application to help the needy people in finding the availability of the medicine and a list of medical stores where the medicine is available. The visitor can quickly find the nearest medical store by selecting the area in the search tools.

This application also provides a login account to a registered medical store. Using this account a person from the medical store can update the list of medicines and their stock on daily-wise. This avoids providing outdated data to the visitor.

Emergency medical services for chronic health problems are depending on the availability of medicines. Most of the times, unavailability of medicines affect the lives of deceased persons. Addresses of medical shops that are providing 24 hours service should be made available to all. Some medical shops provide door delivery service for the needy people in an emergency even though the medical shop or distributor is not providing 24 hours service.

PROJECT DESCRIPTION

The application software is titled “ GOOGLE A MEDICINE ”.The tailor-made software which suites the requirements of a medicine searching software is developed using ASP.NET as front end and SQL SERVER as the backend

This project is an online medicine search web application. This application allows a visitor to search for a medicine and addresses of medical stores (wholesale and retail sales) where the medicine is available.

This application is a solution. So, this web application is planned to develop based on the requirements of the client.

This project contains the following module:

PUBLIC PAGES MODULE:

These modules are useful in providing information to a visitor (login is not required) about the website and contact address and numbers. The homepage displays the main features of the website.

MEDICAL STORE MODULE:

These modules can do add a new medicine to list, manage existing Medicines List, and edit or Update medicines stock and maintain the application settings

MEDICINE SEARCH MODULES:

This module can do for Search and advanced search for search results and search results filtration

ADMIN MODULE (Operator):

These modules allow an administrator of the website to manage cities and manage master data. And also provide Manage Medical Store User Accounts.

DATA FLOW DIAGRAM:

USER, ADMIN, USERLOGIN, MEDICINE SEARCH, BLOOD SEARCH, SEND QUERIES Dataflow Diagrams:

UML DIAGRAMS

Use Case Diagram: Visitor and Facilities

Use Case Diagram: Medical-Member and Facilities

Use Case Diagram: Blood Bank-Member and Facilities

Use Case Diagram: Administrator and Facilities

USE CASE RELATIONSHIP DIAGRAMS

ACTIVITY DIAGRAM FOR ADMINISTRATOR’S ACTIVITIES

ACTIVITY DIAGRAM FOR MEMBER’S ACTIVITIES

HARDWARE SPECIFICATION:

Processor: Pentium IV

Ram: 2 GB RAM

Hard DDisk: 80 G.B Hard Disk

SOFTWARE REQUIREMENTS

Operating System: Windows Server

RDBMS: SqlServer

Web Browser: Internet Explorer

Web Server: IIS

Technology: ASP.NET

Languages used: C#.NET

DATABASE DESIGN

TABLENAME: USER LOGIN

ColumnName	DataType	Description
Sno	Int	Sno
UserID	Varchar(10)	UserID
LoginTime	Datetime	LoginTime

TABLENAME: USER QUERIES

ColumnName	DataType	Description
UserID	Varchar(10)	UserID
UserQuery	Varchar(max)	UserQuery
Reply	Varchar(max)	Reply
Status	Int	Status

TABLENAME : BLOOD BANKS

ColumnName	DataType	Description
Sno	Int	Sno
UserID	Varchar(10)	UserID
BankName	Varchar(50)	BankName
Bgroup	Varchar(10)	BGroup
Stock	Int	Stock

TABLENAME: MEDICINES

ColumnName	DataType	Description
Sno	int	Sno
UserID	Varchar(10)	UserID
MedicineName	Varchar(100)	MedicineName
Dosage	Varchar(50)	Dosage
Stock	int	Stock
Pdate	DateTime	Pdate

TABLENAME: PASSWORD

ColumnName	DataType	Description
UserID	Varchar(10)	UserID
SQuestion	Varchar(100)	SQuestion
Answer	Varchar(100)	Answer

TABLENAME: USER DETAILS

ColumnName	DataType	Description
UserID	Varchar(10)	UserID
OrgName	Varchar(100)	OrgName
Area	Varchar(100)	Area
Address	Varchar(200)	Address
City	Varchar(50)	City
Contactphones	Varchar(50)	Contactphones

TABLENAME: USER

ColumnName	DataType	Description
UserID	Varchar(10)	UserID
OrgName	Varchar(100)	OrgName
Area	Varchar(100)	Area
Address	Varchar(200)	Address
City	Varchar(50)	City
Contactphones	Varchar(50)	Contactphones