Đã Đóng

creating asp.net web page with sql databases

We are part of the “Sheridan Book Club” that would like to exchange book reviews with each other. We have decided to develop a WCF Web Service to provide read/create access to the “Mega Book Database” somewhere on the internet so that we can sell our web service to other book clubs around the world!

You have volunteered to:

1. Develop an ASP.NET Web Site to allow “Sheridan Book Club” members to add new reviews and search for reviews in our own private database. The site also needs to be able to add new books to the Book Database.

2. Develop a WCF Web Service that will eventually provide access to the “Mega Book

Database” somewhere on the internet. Initially we do not have access to the “Mega Book Database” (we are still negotiating rights) so you have also offered to provide a temporary Book database so that we can add some of our favorite books to get started.

Note: The site will initially be hosted on our internal server you do NOT have to authenticate users.

Requirements

1. Create a SQL Server database named "Books" containing (field names in brackets):

A. Book table storing the book name (Name), release date (ReleaseDate), book ISBN number (ISBN) and book ID (Id) (use appropriate data types!)

2. Create a second SQL Server database named "Reviews" containing (field names in brackets):

A. Review table storing reviewer name (Reviewer), review text (Review), review ID (Id), review date (Date), rating (1-10) (Rating) and book ID (BookID) (use appropriate data types!).

3. Create a WCF Service to allow:

A. Adding NEW books to the Book Database. It should return the new Book ID (0 for failure)

B. Fetching books from the Book Database based on the Book ID (-1 for all books)

4. Create an ASP.NET Application that:

A. Provides a Web Form for adding NEW books to the Book Database. This form must use the WCF Service. Note that all fields are mandatory and that the book ID should be automatically generated.

B. Provides a second Web Form to allow users to add new book reviews (all fields are mandatory EXCEPT for the book rating). The user must be able to select the book from the list of available book names which have been retrieved using the WCF Service. This form should:

i. Display the Review ID to the user after a new review is added.

ii. Automatically generate the review date based on when the review is added. iii. Display the number of reviews that the user has added during the current session

C. Provides a third Web Form to allow users to search and view book reviews based on the book ID, book name and/or reviewer name. It should display the fields of the currently selected review(s) based on the search criteria.

Additional Requirements

• Use appropriate controls (ex. Calendar)

• Provide full data validation for user data entry (ASP.NET Data Validation controls strongly recommended)

• Provide a professional and organized user interface with tooltips, error messages, indication of mandatory fields, proper alignment, etc.

• Display the result/outcome of the previous operation to the user

Kĩ năng: .NET, ASP, ASP.NET, Lập trình C#, Microsoft SQL Server

Xem nhiều hơn: asp.net web forms database tutorial, display sql data on web page, asp.net database tutorial, asp.net database connection with sql server using c#, how to connect website to sql database, insert data into database from a web form asp.net c#, asp.net data entry form example, display data from database in asp.net c#, asp net web page master detail design, asp net web page design templates, asp net web page design, developers for hire web developer and database integration skills required will be c# html5 css3 asp net java and sql, developers for hire web developer and database integration skills required will be c html5 css3 asp net java and sql, put google web master tool generated meta data asp net master page, moving graphics asp net web page, improve asp net web page load performane, header footer design asp net web page, creating grid view asp net web control library, convert existing ms access databases sql asp net web interface, code show companys bse stock price asp net web page

Về Bên Thuê:
( 4 nhận xét ) brampton, Canada

ID dự án: #16733106

21 freelancer đang chào giá trung bình $228 cho công việc này

$25 CAD trong 1 ngày
(2 Nhận xét)
0.0
$444 CAD trong 20 ngày
(8 Nhận xét)
0.0
Savio1977

A proposal has not yet been provided

$30 CAD trong 20 ngày
(0 Nhận xét)
0.0
omgonzalez

A proposal has not yet been provided

$25 CAD trong 10 ngày
(0 Nhận xét)
0.0
vijaydbagadai

A proposal has not yet been provided

$242 CAD trong 10 ngày
(1 Nhận xét)
0.0
AmadKhan3

I am just starting my freelancing career. So hope to get good reviews so will make your project with great dedication and will provide cleen code project will be delivered on time

$22 CAD trong 2 ngày
(0 Nhận xét)
0.0
faizy1608

Hi, I am a C# developer and i am vary good in web development I worked on both webforms and MVC. I build several websites with webforms/MVC using SQL Server database and Entity framework. I have expertise on Web AP Thêm

$30 CAD trong 6 ngày
(3 Nhận xét)
0.0
abdelghafar

A proposal has not yet been provided

$555 CAD trong 7 ngày
(2 Nhận xét)
0.0
RanaAssemSaleh

I’ve 7 years of experience in .net web solutions and database architecture

$222 CAD trong 15 ngày
(2 Nhận xét)
0.0
dineshmore

Hi Myself expert in Dot net technologies with 12+yrs of experience in software development. Developed various web and desktop based projects in Finance, Insurance, Research, Education , Research and Retail Domains. Thêm

$1000 CAD trong 30 ngày
(27 Nhận xét)
0.0
garimagaur

Hi, I have 7 years experience in asp.net c#.Recently I am working from home as a freelance developer. You can given me chance to prove myself.

$25 CAD trong 1 ngày
(0 Nhận xét)
0.0
farhan1991

Hello Sir. I have 5 years of experience in web development. I am interested to work for you on this project. Just share more details so that we can start waiting for your positive response :)

$25 CAD trong 1 ngày
(19 Nhận xét)
0.0
PRABHU5013

I have a 6+ years of experience in Asp.Net, WCF and Sql Server. I can understand the requirements quickly and complete the work on time. Relevant Skills and Experience Asp.Net, C#, Sql Server, WCF, HTML, CSS, JS

$25 CAD trong 1 ngày
(0 Nhận xét)
0.0
dvfabia

Hi, I am interested in your project and I like to help you out. I have read the project description and I am confident that I can implement the WCF service and Web Forms project. Please accept my bid so that we c Thêm

$35 CAD trong 2 ngày
(129 Nhận xét)
0.0
theunisjacobs

I am well versed in the technologies need for this projects. I believe I can deliver a high quality program in the allocated time.

$25 CAD trong 3 ngày
(0 Nhận xét)
0.0
$14 CAD trong 1 ngày
(0 Nhận xét)
0.0
nicrosoft

Respected Employer I've read your requirements carefully and confident to work on your project. I'm Asp.Net C# Developer and using MS SQL server for database interaction. I will develop your web pages along with all Thêm

$10 CAD trong 1 ngày
(6 Nhận xét)
0.0
hamzaghanoui

Hello I have a long experience in this field I can help you and thank you With the possibility of challenges in your project

$10 CAD trong 1 ngày
(0 Nhận xét)
0.0
IshtiaqZoho

I am a professional web developer. I would like to develop a website for you. But first we need to discuss your project. Please send me a private message, so that I may start

$25 CAD trong 1 ngày
(1 Nhận xét)
0.0
ONYEMATeam

hi dear i'm expert in client scripting JavaScript , Jquery , AngularJS , ASP.NET AND DESKTOP server scripting PHP , [login to view URL] mvc and database SQL server and mysql i'm expert in webscrap also see my page on facebook Thêm

$1500 CAD trong 20 ngày
(2 Nhận xét)
0.0