Download - Final Report of Jaskiran
-
8/2/2019 Final Report of Jaskiran
1/71
1
CHAPTER 1
INTRODUCTION
1.1 Introduction
AS, TODAY is the age of 21st century where every work is done by advanced technology to
make a work simpler and easier with less manual power, so day by day the use of technology is
increasing like the use of INTERNET. So the best way, to convey the information publicly, is the
use of WEBSITES... A website is a space on the internet offering information or selling
products. It is like an electronic brochure which can be accessed from the Internet almost 24
hours a day and from any location. For example this page is a part of the website The Online
World. A website may be a collection of one or many such pages called web pages. So keeping
in mind, the problems faced by the people who need their services, we convinced the director to
make a website for the society. So we made the website for society using Asp.Net with C#..
With the ongoing online custom bidding where innovations are taking place at the blink
of the eye, it is impossible to keep pace with the emerging trends. Excellence is an attitude that
whole of the human race is born with. It is the environment that makes sure that whether the
result of this attitude is visible or otherwise. A well planned, properly executed and evaluated
industrial training helps a lot in inculcating a professional attitude.
During this period, the students get the real, first hand experience for working in the
actual environment. Most of the theoretical knowledge that has been gained during the course of
their studies is put to test here. I had the opportunity to have a real experience on many ventures,
which increased my sphere of knowledge to a great extent.
-
8/2/2019 Final Report of Jaskiran
2/71
2
This report is a brief summarization of the project work and tasks that I have completed
till now. Report includes company profile and the ongoing ventures of the company. And all
credit goes to organization C.S TECHNOLOGIES which is true self made this possible.
1.2 Necessity
The necessity of ONLINE CUSTOM BIDDING is to make it easy for the clients to make bid for
products that are available for bidding. Clients can get information about all the products ,
available for bidding. This website will help them in saving their precious time and money. The
organizers will not make any seating arrangement for the clients. The project deals with
optimizing online custom bidding. Online custom bidding means the auction of goods under
custom department of a country through computer network. It covers all the areas of the custom
department. It makes the bidding process easy and fast. It also makes the process transparent.
1.3 Objectives
Easy to store information and fast accessing of information regarding customservices.
Centralized management reporting & decision support. Accurate and timely control program. To make it easy for fast processing and modification. List of all clients is available. Easy retrieval of goods. Quick feedback
-
8/2/2019 Final Report of Jaskiran
3/71
3
1.4 Theme
The project is based on online customs bidding. Current system is providing online auctions to
different users. This project includes live auctions, future auctions and closed auctions. By using
this system users can make a bid for every object that is available for the bidding. In this project
admin can view the whole users, state of bids, maintain the bids and stock. And currently all
these processes are managed manually. And more over users have to contact personally to the
admin if they need to get any information about any of the services provided by the company
that holds auctions. So in this way current system is performing its all the tasks and managing all
the information manually.
Features of proposed website are as follow:
1. In the current system there no common interface for the users from where they can getthe required information and manage information of different personnel involved in
performing different processes of the auctions.
2. In the current system user has to get all the information regarding his bid with the adminof the project personally. There is no interface provided from where he can get
information of his or her bids.
3. In the current system there is no proper management of resources available like there isno centralization of data so it takes a lot of time in processing information regarding
different users.
-
8/2/2019 Final Report of Jaskiran
4/71
4
1.5 Organisation
1.5.1 Introduction to C.S Technologies
C.S Technologies Pvt. Ltd. having development office in INDIA and Office in Amritsar (Punjab)
is one of the leading Software Development Company with extensive experience in designing
and development cutting edge software solutions. It contains of highly motivated IT
professionals with an ability to innovate a strong desire to excel.
C.S Technologies Pvt. Ltd. is a customer focused company working to provide software
solutions, which are delivered with Reliability, Timeliness, Flexibility and low cost customer
satisfaction as the primary aim. The designing solutions are purely based on business and
technical requirements of the project in hand. Software Development Life Cycle is strictly
followed to ensure the timely delivery of the projectwithout compromising on quality.
C.S Technologies provides a broad range of offshore outsourcing services including Application
and Systems Level Programming on Leading Technologies. It also provides wide range of
Networking Solutions for Corporate, Industries and Software Development Firms.
C.S Technologies has a niche in providing training to Engineering & MCA Students. Thousands
of engineering students from Chandigarh, Punjab, Haryana, and Rajasthan & Himachal have
-
8/2/2019 Final Report of Jaskiran
5/71
5
successfully completed their Industrial and Summer Training. The focus of the Industrial
Training is to facilitate students with Live Projects on latest technologies like VB.NET,
ASP.NET, ORACLE DBA/DEVELOPER, J2EE, JDO, STRUTS, LINUX, Networking under
the strict guidance of Industry Experts.
1.5.2 Company Profile
Leading Name in Designing & Development of cutting Edge Software Solutions Application & System Level Programming , Network solutions for clients across India &
Abroad
Tie ups with International honchos- Sun, Microsoft, Red Hat, Pearsons and Oracle. Training DivisionReputation in offering Practical courses on Latest Industry oriented
Technologies.
1.5.3 Corporate Exposure
Live Projects Analysis of Software Development Life cycle for the projects Practical Work to understand Industrial issues e.g. Cost Benefit analysis of the project
etc.
All team work Expert Lectures by those from Industry.
-
8/2/2019 Final Report of Jaskiran
6/71
6
1.5.4 Software Development Services
C.S Technologies has a high-end dedicated Software development design center with a versatile
skill pool specializing in technologies like .NET, J2EE, PHP, Ajax Development and is fully
equipped to expand for various projects as per the client's requirements.
Keeping just the right balance of the client's industrial experience and our tech minds, our
projects transform into long-term partnerships from day one.
C.S Technologies range of services provides:
Design, Development & Support of Business Software Applications.
Free and Open-Source Software Development, Customization & Support. Programming for Mobile, Handheld Devices, OEM Hardware & Embedded Systems. Networking Consultancy & Project Implementation.
Dedicated Offshore Technology Center.
1.5.5 Company tie-ups:
Microsoft Oracle Pearsons Red Hat Sun Microsystems
-
8/2/2019 Final Report of Jaskiran
7/71
7
1.5.6 Technology Expertise
Java Technologies
J2EE, EJB, JSP, Web Logic, J2ME, SOA, Web Services, STRUTS Framework, SunOne.
Microsoft Technologies
VS 6.0, .NET Framework, ASP.Net, VB.Net, C#, Web Services, SQL Services, BIZ Talk
Databases
Oracle 9i / 10g, Microsoft SQL Server
Open Source Technologies
PL/SQL, LINUX, C, C++, COM, DCOM, PHP
Data Warehousing/Business Intelligence
Business Objects, Cognos, Informatica, Data Stage, Decision Support System (DSS)
Operating System- Windows XP, 2000, Red Hat Linux
Software Tools
-
8/2/2019 Final Report of Jaskiran
8/71
8
Microsoft Visual Studio.Net, Microsoft Source Safe, Install Shield, Load/WIN Runner
1.5.7 Training Programs
C.S Technologies Training Division offers specialized Industrial Training Program which maps
according to the current industry requirements. The focus of the Industrial Training is to
facilitate students with Live Projects on latest technologies like VB.NET, ASP.NET, ORACLE
DBA/DEVELOPER, J2EE, JDO, STRUTS, LINUX, Networking under the strict guidance of
Industry Experts.
C.S.'s Training Division has a successful track record and experience in training more than
50000 engineering / MCA's students for the past 11 years.
C.S. training division has state-of-art campus spread over 8000 sq.ft. in the heart of Chandigarh.
It has a world class infrastructure having latest machinces, high-end Routers and Switches,
Licensed Software, Multimedia Projectors for training etc.
1.5.8 Special Features:
Specialist in 6 Weeks / 6 Months Industrial Training for Engineers / MCA students. Authorized Training Partner of ORACLE, MICROSOFT, RED HAT & SUN
MICROSYSTEMS.
C.S's Industrial Training programs are designed according to the industry needs.
Training programs are Authorized and Certified by International companies. Original Certificate & Courseware directly from parent companies like SUN Microsystems,
Microsoft, Oracle, Red Hat etc.
-
8/2/2019 Final Report of Jaskiran
9/71
9
More than 40 Qualified & Certified Trainers with experience in software development. Every student is provided with Live Projects mentored by Software Development Experts. Guest Lectures by Industry Experts. Industrial Training Certificate from Software Development Company. Classroom Training includes Audio-Visual aid, Wi-Fi Labs. Seminars on Advanced Technologies for Oracle, Sun Microsystems & Microsoft etc. Air Conditioned Labs having high standard of hygiene. Dedicated Placement Cell with 100% placement assistance.
1.5.9 Company Information
Table 1.5.9 : Company Information
Title C.S.TECHNOLOGIES PVT. LTD
City CHANDIGARH
Complete Address SCO 148-149, 2ND FLOOR, SECTOR
34A CHANDIGARH
Contact person MS. KHUSHI
Description of company SOFTWARE DEVLOPMENT
-
8/2/2019 Final Report of Jaskiran
10/71
10
CHAPTER 2
LITERATURE SURVEY RELATED WITH TRAINING
2.1 Websites for programming.
Microsoft.com/sql/default.mspx: This URL provides with the programming concepts and
queries used in sql.sql stands for structured query language. This language provides you with the
queries, tables, triggers which are used for inserting, updating, deleting or modifying the data of
the websites. So this URL helps in better understanding of the features and concepts of sql
server.
Wikipedia: It is a type of collaborative website and its articles provides links to guide the user to
related pages with additional information.
www.google.com/images: For the purpose of graphics and images, we make use of
google.com/images thus it helps us in providing rich images.
2.2 Books for programming.
a) ASP.NET 4.0 programming by Joydip Kanjilal.
b) ASP.NET 4.0 programming by Watson.
c) Professional C# 4.0 and .NET 4 by Christian Nagel, Bill Evjen, Jay Glynn
-
8/2/2019 Final Report of Jaskiran
11/71
11
CHAPTER 3
PROJECT WORK
3.1 Hardware and Software Requirements
Fig. No.3.1: Hardware and Software Requirements
-
8/2/2019 Final Report of Jaskiran
12/71
12
3.1.1 Hardware Requirements
computer that has a 1.6ghz or faster processor 1 gb (32 bit) or 2 gb (64 bit) ram (add 512 mb if running in a virtual machine) 3gb of available hard disk space 5400 rpm hard disk drive directx 9 capable video card running at 1024 x 768 or higher-resolution display dvd-rom drive
3.1.2 Software requirements
Visual studio 2010 can be installed on the following operating systems:
windows xp (x86) with service pack 3 - all editions except starter edition windows vista (x86 & x64) with service pack 2 - all editions except starter edition windows 7 (x86 & x64) windows server 2003 (x86 & x64) with service pack 2 windows server 2003 r2 (x86 & x64) windows server 2008 (x86 & x64) with service pack 2 windows server 2008 r2 (x64)
Software Tools To Be Used During Development
Microsoft Visual Studio 2010 .Net Framework 4.0 SQL Server 2008
-
8/2/2019 Final Report of Jaskiran
13/71
13
3.2 Introduction to ASP.NET
3.2.1 Planning
Microsoft Visual Studio is an Integrated Development Environment (IDE) from
Microsoft. It can be used to develop console and graphical user interface applications along with
Windows Forms applications, web sites, web applications, and web services in both native code
together with managed code for all platforms supported by Microsoft Windows, Windows
Mobile, Windows CE, .NET Framework, .NET Compact Framework and Microsoft Silverlight.
Visual Studio includes a code editor supporting IntelliSense as well as code refactoring.
The integrated debugger works both as a source-level debugger and a machine-level debugger.
Other built-in tools include a forms designer for building GUI applications, web designer, class
designer, and database schema designer.
Visual Studio 2008 is focused on development of Windows Vista, 2007 Office system,
and Web applications. For visual design, a new Windows Presentation Foundation visual
designer and a new HTML/CSS editor influenced by Microsoft Expression Web are included.
3.2.2 Positioning and Sizing Controls Using the Grid
When adding controls to a form it is possible to configure how controls are positioned and sized
by activating a grid. When the grid is active, controls "snap" to the nearest grid position when
added to a form. There are a number of ways to configure the granularity and behavior of the
Visual Studio grid. These settings are global in that once defined, they apply to all forms and
-
8/2/2019 Final Report of Jaskiran
14/71
14
projects, not just to the current form or project. Note also that for some reason, changes to the
grid do not immediately take effect in forms in which you are already working.
Studio projects. To open the Toolbox, click Toolbox on the View menu. You can dock the
Toolbox, and you can pin it open or set it to Auto Hide. Every Toolbox icon can be dragged to a
design view or pasted in a code editor in the Visual Studio integrated development environment
(IDE). Either action adds the fundamental code to create an instance of the Toolbox item in the
active project file.
Toolbox:-
The Toolbox displays icons for controls and other items that you can add to Visual
Fig 3.2 Options- Grid view
-
8/2/2019 Final Report of Jaskiran
15/71
15
Fig 3.3 Toolbox
The Toolbox only displays items appropriate to the type of file you are working in. The
collection of available controls also depends on the .NET Framework version your project
targets. By default, Visual Studio 2010 projects target the .NET Framework 4 Client Profile. This
reduces the size of deployment packages by not requiring the entire .NET Framework for
installation. If your project requires a control that is not supported by the Client Profile, you can
set your project to target .NET Framework 4 by editing the project properties.
3.2.3 Solution Explorer
Solution Explorer provides you with an organized view of your projects and their files as well as
ready access to the commands that pertain to them. A toolbar associated with this window offers
-
8/2/2019 Final Report of Jaskiran
16/71
-
8/2/2019 Final Report of Jaskiran
17/71
17
Fig 3.5 Properties
Use this window to view and change the design-time properties and events of selected
objects that are located in editors and designers. You can also use the Properties window to edit
and view file, project, and solution properties. Properties Window is available from the View
menu.
3.2.5 Server Explorer Window
Server Explorer is the server management console for Visual
Studio .NET. Use Server Explorer to open data connections and to log on to servers and explore
their databases and system services. You can drag nodes from Server Explorer and drop them
onto Visual Studio .NET designers. This creates new data components that are preconfigured to
reference the item dropped.
To access Server Explorer, select Server Explorer on the View menu. To make the Server
Explorer window close automatically when not in use, select Auto Hide on the Window menu.
-
8/2/2019 Final Report of Jaskiran
18/71
18
Fig. 3.6 Server Explorer
There are two primary nodes in Server Explorer.
1. Data ConnectionsTop-level node that lists any data connections added by a user to the server. Beneath this
node are listed the diagrams, tables, views, stored procedures, and functions for each connection.
You can make Data Connections to many types of databases, including Oracle databases running
on UNIX or Microsoft Windows operating systems.
2. ServersTop-level node that lists the servers currently available for use. Beneath each server node
are listed the databases and server resources you can use in your applications.
Note The Servers node and its children are not available in some editions of Visual
Studio .NET.
-
8/2/2019 Final Report of Jaskiran
19/71
19
3.2.6 Securing Your ASP.NET Applications
Web security is a complex topic that's often confusing to
both developers and end users, but it's a necessary one in today's Internet. Security involves
validating user credentials (authentication) and determining access to resources (authorization).
There are many ways to accomplish these steps with ASP.NET, and fortunately none of them are
very complex to implement.
ASP.NET makes securing your applications easy. Once you've got a grip on the
fundamentals of security, implementing the necessary security measures with ASP.NET is a
snap.
It will cover the following:
What Web security is How Windows handles security What the three different forms of authentication are and how to implement them. How to control access to server resources What impersonation is and how to use it
The Session Object:-
The Session object presents a very interesting concept. Because the Web is a stateless
medium (see Day 2), information about a particular user is hard to keep track of. There's no way
to use HTTP to find out if a series of requests comes from one user or a bunch of different users.
This makes it hard to tailor a Web site for one user.
The Session object combats this limitation. It allows you to store items (such as
variables, objects, strings, or whatever) that are pertinent to a specific user in a single location on
-
8/2/2019 Final Report of Jaskiran
20/71
20
the server. Essentially, it acts as that user's personal storage locker of information. Imagine
lockers in a schoolyou put your belongings in your locker to store while you're in class. When
you leave for the day, the locker is emptied.
The Session object works by the same mechanism. When a user visits your site,
he's allocated a "locker" into which the developer can put whatever information she likes. The
user's time at the site is called a session. Once the user leaves the site, the locker is abandoned,
the information is lost, and the session ends. Imagine that a user comes to your site and enters his
name in a form, which you would like to remember. You can put the name into the Session
object and then recall it from anywhere you want, assuming the session hasn't ended. The syntax
is as follows:
Session.Add(variablename, value)
Or:
Session(variablename) = value;
You can store as many variables in session for each user as your computer's memory will hold.
Listing 4.7 is a page that implements the preceding example.
Listing 4.7 Storing Variables in Session
sub Submit_Click(Sender as Object, e as EventArgs)
if tbName.Value ""
Session("Name") = tbName.Value
Response.Write("Hi " & Session("Name") & "!")
else
-
8/2/2019 Final Report of Jaskiran
21/71
21
Response.Write("You forgot to enter a name.")
end if
end sub
Please enter your name:
3.3 Understanding .Net Frame Work
3.3.1 Definition:
The .Net framework can be defined as a language neutral platform designed to provide a number
of rich and powerful application development tools and technologies. It has an
-
8/2/2019 Final Report of Jaskiran
22/71
22
extensive class library that provides wide-ranging support for data access. .Net framework has an
independent code execution and management environment called the Common Language
Runtime (CLR) which ensures that code is safe to run, and provides an abstract layer on top of
the operating system, which allows the elements of the .Net framework to run on many operating
systems and devices.
3.3.2 The .NET Vision
The basic idea behind the development of the .Net framework is that a global broadband network
will someday globally connect all devices and the software will become a service provided over
this network. The .Net framework provides the foundation and the plumbing on which the
Microsoft .Net vision is built. The vision is about having a global network and open standards
like XML to make it easier for parties to exchange data and work together. Now devices will use
common languages like XML over standardized or shared protocols such as HTTP and these
devices will be running a multitude of software on various operating systems. This is not
limited to Microsoft but also to other operating systems such as sun, IBM.
The .Net framework provides the tools and the technologies needed to write applications that can
seamlessly and easily communicate over the Internet using open standards like XML and SOAP.
It also aims at solving the various problems that are faced by developers while working on
applications made using the windows DNA. It provides a solution to problems such as
registering of components and shutting down applications in order to upgrade them.
3.3.3 Why FRONT END - ASP.NET 4.0
1: ASP.NET is integrated with the .NET Framework
-
8/2/2019 Final Report of Jaskiran
23/71
23
The .NET Framework is divided into an almost painstaking collection of functional
parts, with a staggering total of more than 10,000 types (the .NET term for classes,
structures, interfaces, and other core programming ingredients). The massive collection
of functionality that the .NET Framework provides is organized in a way that traditional
Windows programmers will see as a happy improvement. Each one of the thousands of
classes in the .NET Framework is grouped into a logical, hierarchical container called a
namespace.
Different namespaces provide different features. Taken together, the .NET namespaces
offer functionality for nearly every aspect of distributed development from message
queuing to security. This massive toolkit is called the class library.
2: ASP.NET Is Compiled, Not Interpreted
One of the major reasons for performance degradation in classic ASP pages is its use of
interpreted script code. Every time an ASP page is executed, a scripting host on the web
server needs to interpret the script code and translate it to lower-level machine code, line
by line. ASP.NET applications are always compiledin fact, its impossible to execute
C# or Visual Basic code without it being compiled first.
3: ASP.NET Is Multilanguage
IL is a stepping stone for every managed application. (A managed application is any
application thats written for .NET and executes inside the managed environment of the
-
8/2/2019 Final Report of Jaskiran
24/71
24
CLR.) In a sense, IL is the language of .NET, and its the only language that the CLR
recognizes.
4: ASP.NET Is Hosted by the Common Language Runtime
The most important aspect of the ASP.NET engine is that it runs inside the runtime
environment of the CLR.
5: ASP.NET Is Object-Oriented:
ASP provides a relatively feeble object model. It provides a small set of objects; these
objects are really just a thin layer over the raw details of HTTP and HTML. On the
other hand, ASP.NET is truly object-oriented. Not only does your code have full access
to all objects in the .NET Framework, but you can also exploit all the conventions of an
OOP (object-oriented programming) environment. For example, you can create reusable
classes, standardize code with interfaces, extend existing classes with inheritance, and
bundle useful functionality in a distributable, compiled component.
6: ASP.NET Is Multi device and Multi browser:
One of the greatest challenges web developers face is the wide variety of browsers they
need to support. Different browsers, versions, and configurations differ in their support of
HTML. Web developers need to choose whether they should render their content
according to HTML 3.2, HTML 4.0, or something else entirelysuch as XHTML 1.0 or
even WML (Wireless Markup Language) for mobile devices. This problem, fueled by the
various browser companies, has plagued developers since the World Wide Web
Consortium (W3C) proposed the first version of HTML. Life gets even more complicated
-
8/2/2019 Final Report of Jaskiran
25/71
25
if you want to use an HTML extension such as JavaScript to create a more dynamic page
or provide validation.
3.3.4 Why BACK END SQL SERVER 2008
Back end a description
The back-end comprises the components that process the output from the front-end.Back-end is hidden from the user.
A back-end database is a database that is accessed by users indirectly through anexternal application rather than by application programming stored within the
database itself or by low level manipulation of the data (e.g. through SQL
commands).
A back-end database stores data but does not includeend-userapplication elementssuch as stored queries, forms,macrosor reports.
SQL SERVER 2008
Microsoft SQL-Server 2008 is scalable, high-performance database management with built-in
replication capabilities, Internet integration. Open system architecture, and powerful graphic-
based management tools that are designed specifically for distributed client/server computing.
SQL-Server 2008 extends to performance and reliability by providing server-based job
scheduling to give visual control multiple servers and remote operations.
http://en.wikipedia.org/wiki/Databasehttp://en.wikipedia.org/wiki/Databasehttp://en.wikipedia.org/wiki/Application_softwarehttp://en.wikipedia.org/wiki/Application_softwarehttp://en.wikipedia.org/wiki/SQLhttp://en.wikipedia.org/wiki/SQLhttp://en.wikipedia.org/wiki/End-userhttp://en.wikipedia.org/wiki/End-userhttp://en.wikipedia.org/wiki/End-userhttp://en.wikipedia.org/wiki/Macro_(computer_science)http://en.wikipedia.org/wiki/Macro_(computer_science)http://en.wikipedia.org/wiki/Macro_(computer_science)http://en.wikipedia.org/wiki/Macro_(computer_science)http://en.wikipedia.org/wiki/End-userhttp://en.wikipedia.org/wiki/SQLhttp://en.wikipedia.org/wiki/Application_softwarehttp://en.wikipedia.org/wiki/Database -
8/2/2019 Final Report of Jaskiran
26/71
26
SQL-Server 2008 was designed with Internet and intranets in minds. When it is used with Web
Assistant, it can populate web server with SQL data through a variety of methods and provide
high-performance access to information on companys web site.
SQL-Server 2008 includes new features and components for both the server and the client. The
new features can be grouped into several categories: SQL Enterprise Manager, Transact-SQL,
and SQL-DMO
3.3.5 Client/Server Architecture of SQL server
Microsoft SQL Server is designed to work effectively in a number of environments:
As a two-tier or multi-tier client/server database system As a desktop database system
Client/Server Database Systems
Client/server systems are constructed so that the database can reside on a central computer,
known as aserver, and be shared among several users. Users access the server through a client
or server application.
In a two-tier client/server system, users run an application on their local computer, known as a
client that connects over a network to the server running SQL Server. The client application
runs both business logic and the code to display output to the user, and is also known as a thick
client. In a multi-tier client/server system, the client application logic is run in two locations.
The thin client runs on the users local computer and is focused on displaying results to the
user. The business logic is located in server applications running on a server. Thin client
http://gloss01.htm/http://gloss01.htm/http://gloss01.htm/http://gloss01.htm/#_client_gloss01http://gloss01.htm/#_client_gloss01http://gloss01.htm/#_client_gloss01http://gloss01.htm/ -
8/2/2019 Final Report of Jaskiran
27/71
27
requests functions from the server application that is a multithreaded application capable of
working with many concurrent users. The server application opens connections to the database
server and can run on the same server as the database, or it can connect across the network to a
separate server operating as a database server.
This is a typical scenario for an Internet application. For example, a server application can run
on Microsoft Internet Information Services (IIS) and service thousands of thin clients running
on the Internet or an intranet. The server application uses a pool of connections to
communicate with a copy of SQL Server. SQL Server can be installed on the same computer as
IIS, or it can be installed on a separate server in the network.
Feature and Utilities
Transparent Data Encryption
Enable encryption of an entire database, data files, or log files, without the need for application
changes. Benefits of this include: Search encrypted data using both range and fuzzy searches,
search secure data from unauthorized users, and data encryption without any required changes in
existing applications.
Extensible Key Management
SQL Server 2008 provides a comprehensive solution for encryption and key management. SQL
Server 2008 delivers an excellent solution to this growing need by supporting third-party key
management and HSM products.
-
8/2/2019 Final Report of Jaskiran
28/71
28
Auditing
Create and manage auditing via DDL, while simplifying compliance by providing more
comprehensive data auditing. This enables organizations to answer common questions, such as,
"What data was retrieved?"
Enhanced Database Mirroring
SQL Server 2008 builds on SQL Server 2005 by providing a more reliable platform that has
enhanced database mirroring, including automatic page repair, improved performance, and
enhanced supportability.
Automatic Recovery of Data Pages
SQL Server 2008 enables the principal and mirror machines to transparently recover from
823/824 types of data page errors by requesting a fresh copy of the suspect page from the
mirroring partner transparently to end users and applications.
Predictable Query Performance
Enable greater query performance stability and predictability by providing functionality to lock
down query plans, enabling organizations to promote stable query plans across hardware server
replacements, server upgrades, and production deployments.
Data Compression
Enable data to be stored more effectively, and reduce the storage requirements for your data.
Data compression also provides significant performance improvements for large I/O bound
workloads, like data warehousing.
-
8/2/2019 Final Report of Jaskiran
29/71
29
3.4 Microsoft Visual Studio 2010
Microsoft Visual Studio is an integrated development environment (IDE)
from Microsoft. It can be used to develop console and graphical user interface applications along
with Windows Forms applications, web sites, web applications, and web services in both native
code together with managed code for all platforms supported by Microsoft Windows, Windows
Mobile, Windows CE, .NET Framework, .NET Compact Framework and Microsoft Silverlight.
Visual Studio includes a code editor supporting IntelliSense as well as code refactoring. The
integrated debugger works both as a source-level debugger and a machine-level debugger. Other
built-in tools include a forms designer for building GUI applications, web designer, class
designer, and database schema designer. It accepts plug-ins that enhance the functionality at
almost every levelincluding adding support for source-control systems (like Subversion and
Visual SourceSafe) and adding new toolsets like editors and visual designers for domain-specific
languages or toolsets for other aspects of the software development lifecycle (like the Team
Foundation Server client: Team Explorer).
Visual Studio supports different programming languages by means of language services, which
allow the code editor and debugger to support (to varying degrees) nearly any programming
language, provided a language-specific service exists. Built-in languages include C/C++ (via
Visual C++), VB.NET (via Visual Basic .NET), C# (via Visual C#), and F# (as of Visual Studio
2010). Support for other languages such as M, Python, and Ruby among others is available via
language services installed separately. It also supports XML/XSLT, HTML/XHTML, JavaScript
and CSS. Individual language-specific versions of Visual Studio also exist which provide more
-
8/2/2019 Final Report of Jaskiran
30/71
30
limited language services to the user: Microsoft Visual Basic, Visual J#, Visual C#, and Visual
C++.
Microsoft provides "Express" editions of its Visual Studio 2010 components Visual
Basic, Visual C#, Visual C++, and Visual Web Developer at no cost. Visual Studio 2010, 2008
and 2005 Professional Editions, along with language-specific versions (Visual Basic, C++, C#,
J#) of Visual Studio 2005 are available.
3.4.1 Features of Microsoft Visual Studio
Interoperability
Because interaction between new and older applications is commonly required, the .NET
Framework provides means to access functionality that is implemented in programs that execute
outside the .NET environment. Access to COM components is provided in the System Runtime
Interop Services and System Enterprise Services namespaces of the framework; access to other
functionality is provided using the P/Invoke feature.
Common Runtime Engine
http://en.wikipedia.org/wiki/Interoperabilityhttp://en.wikipedia.org/wiki/Interoperabilityhttp://en.wikipedia.org/wiki/Component_Object_Modelhttp://en.wikipedia.org/wiki/Platform_Invocation_Serviceshttp://en.wikipedia.org/wiki/Platform_Invocation_Serviceshttp://en.wikipedia.org/wiki/Component_Object_Modelhttp://en.wikipedia.org/wiki/Interoperability -
8/2/2019 Final Report of Jaskiran
31/71
31
The Common Language Runtime (CLR) is the virtual machine component of the .NET
framework. All .NET programs execute under the supervision of the CLR, guaranteeing certain
properties and behaviors in the areas of memory management, security, and exception handling.
Language Independence
The .NET Framework introduces a Common Type System, or CTS. The CTS specification
defines all possible data types and programming constructs supported by the CLR and how they
may or may not interact with each other. Because of this feature, the .NET Framework supports
the exchange of instances of types between programs written in any of the .NET languages. This
is discussed in more detail in Microsoft .NET Languages.
Base Class Library
The Base Class Library (BCL), part of the Framework Class Library (FCL), is a library of
functionality available to all languages using the .NET Framework. The BCL provides classes
which encapsulate a number of common functions, including file reading and writing, graphic
rendering, database interaction and XML document manipulation.
Security
The design is meant to address some of the vulnerabilities, such as buffer overflows, that have
been exploited by malicious software. Additionally, .NET provides a common security model for
all applications.
http://en.wikipedia.org/wiki/Common_Language_Runtimehttp://en.wikipedia.org/wiki/Common_Type_Systemhttp://en.wikipedia.org/wiki/Specificationhttp://en.wikipedia.org/wiki/Datatypeshttp://en.wikipedia.org/wiki/Programminghttp://en.wikipedia.org/wiki/Microsoft_.NET_Languageshttp://en.wikipedia.org/wiki/Base_Class_Libraryhttp://en.wikipedia.org/wiki/Class_(computer_science)http://en.wikipedia.org/wiki/Computer_filehttp://en.wikipedia.org/wiki/Rendering_(computer_graphics)http://en.wikipedia.org/wiki/Rendering_(computer_graphics)http://en.wikipedia.org/wiki/Databasehttp://en.wikipedia.org/wiki/XMLhttp://en.wikipedia.org/wiki/Buffer_overflowhttp://en.wikipedia.org/wiki/Buffer_overflowhttp://en.wikipedia.org/wiki/XMLhttp://en.wikipedia.org/wiki/Databasehttp://en.wikipedia.org/wiki/Rendering_(computer_graphics)http://en.wikipedia.org/wiki/Rendering_(computer_graphics)http://en.wikipedia.org/wiki/Computer_filehttp://en.wikipedia.org/wiki/Class_(computer_science)http://en.wikipedia.org/wiki/Base_Class_Libraryhttp://en.wikipedia.org/wiki/Microsoft_.NET_Languageshttp://en.wikipedia.org/wiki/Programminghttp://en.wikipedia.org/wiki/Datatypeshttp://en.wikipedia.org/wiki/Specificationhttp://en.wikipedia.org/wiki/Common_Type_Systemhttp://en.wikipedia.org/wiki/Common_Language_Runtime -
8/2/2019 Final Report of Jaskiran
32/71
32
Portability
The design of the .NET Framework allows it to theoretically be platform agnostic, and thus
cross-platform compatible. That is, a program written to use the framework should run without
change on any type of system for which the framework is implemented. Microsoft's commercial
implementations of the framework cover Windows, Windows CE, and the Xbox 360. In
addition, Microsoft submits the specifications for the Common Language Infrastructure (which
includes the core class libraries, Common Type System, and the Common Intermediate
Language), the C# language, and the C++/CLI language to both ECMA and the ISO, making
them available as open standards.
3.5 Models Used For Project Development
3.5.1 Conceptual Model
A mental model captures ideas in a problem domain, while a conceptual model represents
concepts' (entities) and relationships between them. Conceptual modelling is a well known
technique of data modelling, together with physical modeling. The conceptual model is explicitly
chosen to be independent of implementation details, such as concurrency or data storage. The
aim of conceptual model is to express the meaning of terms and concepts used by domain experts
to discuss the problem, and to find the correct relationships between different concepts. This is
also called semantic model. The conceptual model attempts to clarify the meaning of various
usually ambiguous terms, and ensure that problems with different interpretations of the terms and
concepts cannot occur. Such differing interpretations could easily cause the software projects
that are based on the interpretation of the concepts to fail. Once the domain concepts have been
http://en.wikipedia.org/wiki/Cross-platformhttp://en.wikipedia.org/wiki/Windows_CEhttp://en.wikipedia.org/wiki/Xbox_360http://en.wikipedia.org/wiki/Common_Language_Infrastructurehttp://en.wikipedia.org/wiki/Common_Type_Systemhttp://en.wikipedia.org/wiki/Common_Intermediate_Languagehttp://en.wikipedia.org/wiki/Common_Intermediate_Languagehttp://en.wikipedia.org/wiki/C_Sharp_(programming_language)http://en.wikipedia.org/wiki/International_Organization_for_Standardizationhttp://en.wikipedia.org/wiki/International_Organization_for_Standardizationhttp://en.wikipedia.org/wiki/C_Sharp_(programming_language)http://en.wikipedia.org/wiki/Common_Intermediate_Languagehttp://en.wikipedia.org/wiki/Common_Intermediate_Languagehttp://en.wikipedia.org/wiki/Common_Type_Systemhttp://en.wikipedia.org/wiki/Common_Language_Infrastructurehttp://en.wikipedia.org/wiki/Xbox_360http://en.wikipedia.org/wiki/Windows_CEhttp://en.wikipedia.org/wiki/Cross-platform -
8/2/2019 Final Report of Jaskiran
33/71
33
modelled, the model becomes a stable basis for subsequent development of applications in the
domain.
3.5.2 Computational Model
A computational model is a mathematical model in computational science that requires extensive
computational resources to study the behavior of a complex system by computer simulation. The
system under study is often a complex nonlinear system for which simple, intuitive analytical
solutions are not readily available. Rather than deriving a mathematical analytical solution to the
problem, experimentation with the model is done by changing the parameters of the system in
the computer, and study the differences in the outcome of the experiments. Theories of operation
of the model can be derived/deduced from these computational experiments.
-
8/2/2019 Final Report of Jaskiran
34/71
34
3.6 Data Flow Diagram
Fig 3.7: DFD FOR NEW SYSTEM
As shown in the above diagram first of all server will open the auction for clients for
particular product or services then after studying all the terms and conditions about the
bidding and the clients submit the application form through online system and after
considering all these application form the administrator send the comparative statements
to the clients for further action .This system is transparent as every client can see the
application forms submitted by all the clients and bidding can be finalized by using
software system.
DATABASE
-
8/2/2019 Final Report of Jaskiran
35/71
35
3.7 Software Development Life Cycle
2.
3.Fig 3.8: SDLC
Problem Definition
Feasibility Study
Analysis
Design
Test Plan
Implementation
Maintenance
-
8/2/2019 Final Report of Jaskiran
36/71
36
3.8 Requirement Analysis
Prior to the software efforts in any type of system it is very essential to understand the
requirement of the system and users. A complete specification of the software is the 1st step in
the analysis of system. Requirements analysis provides the designer with the representation of
function and procedures that can be translated into data, architecture and procedural design.
The goal of requirement analysis is to find out how current system is working and of there are
any areas where improvement analysis is to find out how current system is working and of there
are any area where improvement is necessary and possible.
The software requirement specification is produced at the culmination of the analysis task. The
function and performance allocated to software as part of system engineering are refined by
establishing a complete information description, a detailed functional description, a
representation of system behavior, an indication of performance requirement and design
constraints appropriate validation criteria, and other information pertinent to requirement.
The introduction to software requirements specification states the goals and objectives of the
software, describing it in the context of the computer based system.
The Information Description provides a detailed description of the problem that the software
must solve. Information content, flow and structure are documented.
A description of each function required to solve the problem is presented in the Functional
Description. Validation Criteria is probably the most important and ironically the most often
neglected section of the software requirement specification.
-
8/2/2019 Final Report of Jaskiran
37/71
-
8/2/2019 Final Report of Jaskiran
38/71
38
and the developer understands the problem of the client. If the gap between the client and
developer is not removed then actual solution can never be obtained. The problem statement
must be stated clearly, understood and agreed upon by the user and the developer. It must state
the objective the user is trying to active and the result user wants to see
3.11 Project Legacy
The Project is mainly divided into following modules:
1) User Maintenance2) Stock Maintenance3) Live Auctions4) Future Auctions5) Closed Auctions
3.12 Feasibility analysis
Depending upon the result of the initial investigation, the survey is expanded to a more detailed
feasibility study. A feasibility study is a test of a system proposal according to its workability,
impact on the organization, ability to meet users needs and effective use of resources. Feasibility
is the determination of whether or not a project is worth doing. A feability study is an analysis of
a problem to determine if it can be solved effectively in the given budgetary, operational,
technical and schedule constraints in place. The results of the feasibility study determine which,
if any, of a number of feasibility solutions to be developed in the design phase. The aim of the
feasibility study is to identify the best solution under the circumstance by identifying the effects
of this solution on the organization. The content and recommendations of such a study will be
-
8/2/2019 Final Report of Jaskiran
39/71
39
used as a sound basis for deciding whether to proceed, postpone or cancel the project. It included
three main questions:
1. What are the users needs and how the candidates system does meet them?
2. What resources are available for given candidate system?
3. What is the likely impact of the candidates system on the organization?
Three key considerations are involved in the feasibility analysis, Economical, technical and
operational. All of these are discussed one by one in the following section.
Technical Feasibility:-
What technologies are required to accomplish system function and performance?
What new materials, methods, algorithms or processes are required and what are
their development risks.
The Projects Technical Feasibility:-
I have used the ASP.NET as development language for developing my project and SQLSERVER
as backend.
Economical Feasibility:-
How will these technology issues affect cost?
Cost-benefit analysis?
-
8/2/2019 Final Report of Jaskiran
40/71
40
The Projects Economical Feasibility:-
The system investigation cost is very low. We already have .NET framework installed on every
system in our company.
Operational Feasibility:-
Is their sufficient support for the project from the management? From customers?
Are current business methods acceptable to the users?
Will the proposed system cause harm? Will it produce poorer result in any case or
area?
The Projects Operational Feasibility:-
There was very good response from the top management and from the user, in lieu for
development of the project. Besides it, no harm could be foreseen to developers or to other
environment due to this project.
-
8/2/2019 Final Report of Jaskiran
41/71
41
3.13 System Design
Fig 3.9: System design
-
8/2/2019 Final Report of Jaskiran
42/71
42
3.14 DETAILED DESIGN
Fig. 3.10 detailed design
Admin New User
Users
Verify
Info
Verify
User
Add basic
info
Feedback
ContactUs
Feedback
Login
Register
View
View Bid
Emails
username &
password
-
8/2/2019 Final Report of Jaskiran
43/71
43
3.15 Tables
Table 3.15.1: tbl_bid
Field Name Key Data Type Constraints
Bidid PK Int Not Null
Bidname Varchar(100) Null
dos_time Date time Null
doe_time Date time Null
Categoryid FK Int Null
Itemid Int Null
Price Varchar(100) Null
Location Varchar(100) Null
Table 3.15.2: tbl_comment
Field Name Key Data Type Constraints
Srno PK Int Not Null
Username varchar(100) Null
Userid varchar(100) Null
Comment varchar(MAX) Null
Commentdate Datetime Null
-
8/2/2019 Final Report of Jaskiran
44/71
44
Table 3.15.3: tbl_futurebids
Field Name Key Data Type Constraints
Srno PK Int Not Null
Image varchar(200) Null
Bidname varchar(200) Null
Dateofstarting Datetime Null
Table 3.15.4: productcategory
Field Name Key Data Type Constraints
Categoryid PK Int Not Null
Category Varchar(50) Null
Image Varchar(100) Null
Table 3.15.5: tbl_imgtxt
Field Name Key Data Type Constraints
No PK Int Not Null
Image Varchar(50) Null
Imgtxt Varchar(50) Null
-
8/2/2019 Final Report of Jaskiran
45/71
45
Table 3.15.6: tbl_stock
Field Name Key Data Type Constraints
Itemid PK Int Not Null
Itemname Varchar(50) Null
Quantity Int Null
Doa Varchar(50) Null
Categoryid FK Int Not Null
Image Varchar(50) Null
Table 3.15.7: tbl_mybid
Field Name Key Data Type Constraints
Srno PK Int Not Null
Userid varchar(100) Null
Contactno varchar(50) Null
Category varchar(50) Null
Itemname varchar(100) Null
Image varchar(100) Null
Minprice varchar(50) Null
Sdat Datetime Null
Edat Datetime Null
-
8/2/2019 Final Report of Jaskiran
46/71
46
Table 3.15.8: tbl_userdetails
Field Name Key Data Type Constraints
Regno PK Int Not Null
Fname Varchar(100) Null
Lname Varchar(100) Null
Father_name Varchar(100) Null
Dob Varchar(30) Null
Gender Varchar(15) Null
Address Varchar(200) Null
Ph_no Varchar(50) Null
Emailed Varchar(50) Null
Password Varchar(50) Null
C_password Varchar(50) Null
Usertype Varchar(50) Null
Image Varchar(100) Null
-
8/2/2019 Final Report of Jaskiran
47/71
47
Table 3.15.9: tbl_onlbid
Field Name Key Data Type Constraints
Bidid PK Int Not Null
Userid PK varchar(50) Not Null
Bidname varchar(100) Null
Itemname varchar(100) Null
Username Varchar(100) Null
Bidprice varchar(200) Null
Bidtime Datetime Null
-
8/2/2019 Final Report of Jaskiran
48/71
48
Table 3.15.10: tbl_pastbid
Field Name Key Data Type Constraints
Srno PK Int Not Null
Image Varchar(100) Null
Bidid Int Null
Bidname Varchar(100) Null
Urbiddingtime Datetime Null
Location varchar(200) Null
Userimage Varchar(200) Null
Winner varchar(200) Null
Soldprice varchar(100) Null
Address varchar(200) Null
-
8/2/2019 Final Report of Jaskiran
49/71
49
CHAPTER 4
EVALUATION OF TRAINING
4.1 Profile of the problem and existing system
The project is based on online customs bidding. Current system is providing online auctions to
different users. This project includes live auctions, future auctions and closed auctions. By using
this system users can make a bid for every object that is available for the bidding. In this project
admin can view the whole users, state of bids, maintain the bids and stock. And currently all
these processes are managed manually. And more over users have to contact personally to the
admin if they need to get any information about any of the services provided by the company
that holds auctions. So in this way current system is performing its all the tasks and managing all
the information manually.
4.2 Limitations of current system
4. In the current system there no common interface for the users from where they can getthe required information and manage information of different personnel involved in
performing different processes of the auctions.
5. In the current system user has to get all the information regarding his bid with the adminof the project personally. There is no interface provided from where he can get
information of his or her bids.
6.
In the current system there is no proper management of resources available like there is
no centralization of data so it takes a lot of time in processing information regarding
different users.
-
8/2/2019 Final Report of Jaskiran
50/71
50
4.3 Users of the system
The different users of the system are:
1 Administrator: Administrator would have all capabilities. Administrator will configure thesystem with information regarding different bids available for users and the requirements for
those bids and also other services offered by the Bidding Company. Also administrator is
responsible managing information regarding all the employees.
2 User:User is the end user who is in the need of products that are available for bidding.4.4 Snapshots
Fig.4.1: Home
-
8/2/2019 Final Report of Jaskiran
51/71
51
HOME: This page includes notices, products and login functions. In notices, we have displayed
date and starting time of bidding of products. Products which are available for bidding are
displayed here. If user has not created his/her account, then one can create it and login from this
page.
Fig. 4.2: About Us
ABOUT US: This page includes information about our system ONLINE CUSTOM BIDDING.
-
8/2/2019 Final Report of Jaskiran
52/71
52
Fig. 4.3: Feedback
FEEDBACK: Using this page, Users can comment here.
-
8/2/2019 Final Report of Jaskiran
53/71
53
Fig. 4.4: Contact Us
CONTACT US: From here, User can get details about admins contact details.
-
8/2/2019 Final Report of Jaskiran
54/71
54
Fig. 4.5: Welcome
WELCOME: After login, welcome page will open and from here, user and admin can view the
table of contents also.
-
8/2/2019 Final Report of Jaskiran
55/71
55
Fig. 4.6: My Profile
MY PROFILE: Here user can view his details and edit his profile.
-
8/2/2019 Final Report of Jaskiran
56/71
56
Fig. 4.7: Edit Profile
EDIT PROFILE: Here user or admin can change his image and change his details.
-
8/2/2019 Final Report of Jaskiran
57/71
57
Fig. 4.8: User List
USER LIST: This page contains users details.
-
8/2/2019 Final Report of Jaskiran
58/71
58
Fig. 4.9: Category
CATEGORY: It includes category id and category. Only admin can add new category.
-
8/2/2019 Final Report of Jaskiran
59/71
59
Fig. 4.10 Stock
STOCK: This includes quantity, item name and date of arriving of category. Only admin can add
new stock.
-
8/2/2019 Final Report of Jaskiran
60/71
60
Fig. 4.11: Bid
BID: It includes bidding of product, item name, its minimum price, date, starting and ending
time of bidding and its location where bidding takes place. Only admin can add new bid details.
-
8/2/2019 Final Report of Jaskiran
61/71
61
Fig. 4.12: Toshiba
TOSHIBA: It includes some information about Toshiba.
-
8/2/2019 Final Report of Jaskiran
62/71
62
Fig. 4.13: Result Of Bids
RESULT OF BIDS: It displays the winners of past bids.
-
8/2/2019 Final Report of Jaskiran
63/71
-
8/2/2019 Final Report of Jaskiran
64/71
64
Fig. 4.15: Bid List
BID LIST: It includes all the users who had participated in the past bids.
-
8/2/2019 Final Report of Jaskiran
65/71
65
Fig. 4.16: Bid Form
BID FORM: Here user can add his own product which he wants to sell.
-
8/2/2019 Final Report of Jaskiran
66/71
66
Fig. 4.17: Message To Users
MESSAGE TO USERS: Admin can send message to users using this page.
-
8/2/2019 Final Report of Jaskiran
67/71
67
Fig. 4.18: New Admin/ User Account
NEW ADMIN/ USER ACCOUNT: Here user or admin can create his new account.
-
8/2/2019 Final Report of Jaskiran
68/71
68
Fig. 4.19: To Participate In Bid
TO PARTICIPATE IN BID: If user wants to participate in bid, then he can use this page.
-
8/2/2019 Final Report of Jaskiran
69/71
69
Fig. 4.20: Put Your Bid Amount
PUT YOUR BID AMOUNT: Here user can put his bid amount.
-
8/2/2019 Final Report of Jaskiran
70/71
70
CHAPTER 5
CONCLUSIONS AND FUTURE SCOPE OF TRAINING
5.1 Conclusions and Objectives Achieved
The project that I underwent was truly a rewarding experience for me in more than one way. It
not only gave me a big thrust to my technical knowledge as prospective web development
professional but also helped me to enhance my skills on the personal front.
I feel truly satisfied by the fact that though getting a chance to work in such a real live
application project is rare still I managed to get it. I have exploited the opportunity that came my
way to the fullest extent by increasing my technical know-how and also gaining the valuable
work experience from the esteemed organization.
This project is a generalized approach in managing the various modules. It is faster, accurate and
cheaper than existing system. It is a transparent system.
5.2 Future scope
ONLINE CUSTOM BIDDING is a website that is designed to make it easy for the clients to
make bid for products that are available for bidding. Clients can get information about all the
products , available for bidding. This website will help them in saving their precious time and
money. The organizers will not make any seating arrangement for the clients. The project deals
with optimizing online custom bidding. Online custom bidding means the auction of goods under
custom department of a country through computer network. It covers all the areas of the custom
department. It makes the bidding process easy and fast. It also makes the process transparent.
-
8/2/2019 Final Report of Jaskiran
71/71
BIBLIOGRAPHY
http://www.google.comhttp://www.roseindia.nethttp://www.clicktutorials.comhttp://www.wikipedia.comhttp://www.w3schools.com