ONLINE TENDER MANAGEMENT in asp dot net.doc (Size: 1.31 MB / Downloads: 420)
In current tender system a lot of paper work is involved. The system is based on manual bid system which is a very time consuming process. No proper records available which leads to difficulty in manual report generation. People who are interested in tender have to travel long distances to gather at a common place. Also manual work is always prone to errors and errors in such system can have pretty bad consequences.
All the above issues are resolved in online Tender Management System. Companies who want to enter their tender need to register online through the website. After registering the company adds the various items which are needed by the company as per its requirement. Now, when Client visits the site it registers itself and can view the various tender. Thus, now can apply for the tenders that are they fill up the various details required.
Company opens the tenders and select the appropriate of all tenders after the deadline given to clients is over. All the tenders are displayed on the website leading to transparency between clients and company.
In the span of the development of this project, I studied software concepts, technical language details, testing issues, bug fixing and mobile applications.
I started with studying the existing system and then pin pointing to the specifications needed in the new system being developed. Later on I focused more on coding details. After the coding was complete, thorough testing was performed for verifying the system.
1. Interoperability between languages and execution environments
2. Uniformity in schema or formats for Data Exchange using XML, XSL
3. Extend or use existing code that is valid
4. Programming complexity of environment is reduced
The .NET Framework is…
1. A component model for the internet
2. The new approach to building large scale distributed systems for the Internet
3. Provides the capability to integrate multiple devices
4. Built around the tools and protocols (XML, WSDL, SOAP, HTTP) that are becoming standard on the Internet
The .NET in ASP.NET stands for the .NET Framework, a set of objects and blueprints from Microsoft for building applications. All applications developed under the .NET Framework; including ASP.NET applications, have certain key features that ensure compatibility, security, and stability.
Fig:- .NET Framework Architecture
The .NET Framework Design Goals
1. Component Development for the Internet
2. "Cross-Language Development”
3. Inheritance, Debugging, Exception handling
4. Reliability and Security
5. Simple Development and Deployment
ASP.NET is a technology that allows us to build and control dynamic Web pages easily. It also provides many enhancements to take advantage of new technology as we can interact with databases, personalize Web pages for visitors, display page on mobile devices (such as cell phones), and even build an entire e-commerce site from scratch.
Previously internet works on request/response model that is an integral part of client/server model. Although this is a marvelous way of communicate and distribute information, it's rather simple and static. When the process is over, once client receives the requesting page from the server the server has no idea what the client is doing unless it makes another request.
There is another model for communicating between server and clients, known as event-driven model.ASP.NET work on this model, it detects action and responds to them i.e. the server waits around for something to happen on the client. Once it does, the server takes action and performs some piece of functionality. Of course, a Web, server can not know what you are thinking, but it can respond to your actions. If you type some text on Web page, the server responds to it. If you click an image, the server responds.
SQL SERVER: ¬
SQL Server is an SQL-compliant RDBMS. SQL-compliant means it use the ANSI (American National Standard Institute) version of Structured Query Language or ‘SQL’. Structured Query Language is a command that allow us to modify or retrieve information from the database.
Client server means that SQL Server is designed to store data in the central location (the server) and deliver it on demand to numerous other locations (the client). SQL Server is also a Relational Database Management System (RDBMS).
FEATURES OF SQL SERVER 2000:
1 Information representation
2 Unique definition of rows
3 Systematic treatment of Null values
4 Guaranteed access
5 High level Update, Insert, and Delete
6 Retrieving information from the database.
7 Accepting query language statements.
8 Enforcing security specifications.
9 Enforcing data integrity specifications
10 Enforcing transaction consistency
11 Managing data sharing
12 Optimizing queries
13 Managing System catalogs
SQL Server Enterprise Manager is a graphical tool that allows easy configuration and management of Microsoft SQL Server and SQL 2000 program group.
SQL Server Enterprise Manager can also be used to:
1. Manage logins, permission and users.
2. Create a database
3. Take back-up of database and transaction logs.
4. Manage tables
The SQL Server Query Analyzer allows us to create adhoc queries and run them interactively. We may also execute Transact-SQL statements stored in text file and view the result in result plane or result grid. The Query Analyzer also has a color-coded editor to assist the user with checking of syntax. It also has context sensitive help.
Queries are processed in two steps:
Interpret- First the Queries are checked for syntax.
Execute- Then the processing take place.