Đang Thực Hiện

.NET Front End Submission Form with Backend Reporting

.NET Front End Submission Form with Backend Reporting

Front End:

I need a simple form that will allow the sales force to submit data when their pricing is beat. THe form will require the following fields on the Front End Submission Page:

Title of the Form Page: I GOT BEAT!

1. Loan # - Numeric Field, Up to 12 characters, UID

2. Date - Format, 01/01/2011 - Month/Day/Year

3. Branch - Drop down with the following Branches listed:

-Orlando

-Pine Street

-Longwood

-HLT

-StJax

-BrandonMiss

-Tampa

-MintoCC

-Jupiter

-MerrittIsland

-FFM

4. Loan Officer Name - Text Box to enter First Name Last Name.

5. Loan Amount - Text box formatted for Current entry.

6. FBC Rate - Percentage with Drop Down to select a rate. Rates range will be from [url removed, login to view] to [url removed, login to view] increasing by 1/8th of a percent. Ex: [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], 3.5, [url removed, login to view], [url removed, login to view] all the way up the

9.

7. Competitor Rate - Percentage with Drop Down to select a rate. Rates range will be from [url removed, login to view] to [url removed, login to view] increasing by 1/8th of a percent. Ex: [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], 3.5, [url removed, login to view], [url removed, login to view] all the way

up the 9.

8. Rate Difference - Difference between FBC and Competitor Rate. Percentage Drop Down to select a rate difference. Rate diffence will range from [url removed, login to view] to [url removed, login to view] increasing by 1/8th of a percent. EX:

[url removed, login to view], [url removed, login to view], [url removed, login to view], 0.5, [url removed, login to view] all the way up to [url removed, login to view]

9. FBC Fees - Text Box formatted for Currency entry.

10. Competitor Fees - Text Box formatted for Currency entry.

11. Fee Difference - Difference between FBC and COmpetitor Fees. Text Box formatted for Currency entry.

12. Attachment - Browse Button so the user can attach a PDF document that will be stored in the Database to be viewed later.

Upon hitting Submit, the user will have the option to click Edit to go back and edit what they inputted or click "Confirm Submission" which will officially submit the for to the database.

Above are the required 12 form fields for submission. Upon submission of the form, it will be submitted/stored into an MS SQL database.

Back End:

The Back End page will allow us to pull reports based on the information above. The Query form will have the following selections which will display results based on drop down selected. Not all

drop downs are required to pull results.

1. Date Range - Allow to choose a range of dates

2. Branch - Choose one of the Branches listed below from a Drop Down

3. Loan Amount Range - Choose a loan amount range from a drop down. This would pull all matches that were between the range selected. Range goes from $25,000 all the way up to $2,000,000 increasing

by $24,999.

Example Drop Down:

$25,000 - $49,999

$50,000 - $74,999

$75,000 - $99,999

$100,000 - $124,999

All the way up to $2,000,000

4. Rate Difference - Percentage Drop Down to select a rate difference. Rate diffence will range from [url removed, login to view] to [url removed, login to view] increasing by 1/8th of a percent. EX: [url removed, login to view], [url removed, login to view], [url removed, login to view], 0.5, [url removed, login to view] all the way

up to [url removed, login to view]

5. Fee Difference - Drop Down to select fee difference. Choose a fee difference range from a drop down. This would pull all matches that were between the range sleected. Range goes from $0 all the

way up to $5000 increasing by $250.

Example Drop Down:

$0-$249

$250-$499

$500-$749

$750-$999

$1000-$1249

All the way up to $5000

When the user clicks submit on the query form, the results will display all loan data that matches the chosen search criteria in a Table with all the fields submitted from the Front End form. Each table column should be sortable by clicking on the label of the column. The farest column to the right will have an option to click and open any PDF attachment uploaded when the loan data was initially submitted.

Requirements:

Application will be running on Server 2008 R2

IIS7

Must be .NET

Data submitted into a MS SQL 2008 Express Database.

Winner must provide the required pages outlined above plus a .SQL file to create any tables needed which can be easily executed.

Serious bidders only please. Must 5-7 day turn around project.

Kỹ năng: .NET, Lập trình C, Lập trình C#, SQL, Visual Basic

Xem thêm: submit form backend, uid data entry, tampa back page, submission page, submission matches, sql data entry form, simple reporting, rate visual basic, range query, programming plus, programming box requirements, page plus programming, loan officer, sales tampa, front end reporting, format pricing, end user programming, edit pdf form, data front, currency table rate, currency rate table, currency rates table, box net, turn pdf text, back end server

Về Bên Thuê:
( 15 nhận xét ) Orlando, United States

Mã Dự Án: #1021497

Đã trao cho:

aisha2010

Please check PM. Thanks!

$250 USD trong 5 ngày
(3 Đánh Giá)
3.7

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

aptecpymefree

Hi. I can work in your .net project. I have 14 Years of experience in Software development Windows and Web. Expert in Sql Server and .NET. Microsoft Certified as MCP, MCTS, MCPD, MCT. Please contact me to clarify all d Thêm

$250 USD trong 7 ngày
(20 Đánh Giá)
5.6
tamrakar81

Hi, Please check PM . Thanks, T

$250 USD trong 5 ngày
(36 Đánh Giá)
5.3
mohsin649

Thanks for considering my bid. Please check PMB. Thanks

$250 USD trong 6 ngày
(8 Đánh Giá)
4.3
tooltor

Expert programmer here, please read the private message.

$250 USD trong 7 ngày
(2 Đánh Giá)
2.3
akashmathur

Bid is negotiable

$300 USD trong 5 ngày
(0 Đánh Giá)
0.0
HDDevelopment

Kindly check PMB

$250 USD trong 4 ngày
(0 Đánh Giá)
0.0
dozstudio

check the pm box.

$250 USD trong 7 ngày
(0 Đánh Giá)
0.0
vijisivaa

Ready to do.

$250 USD trong 5 ngày
(0 Đánh Giá)
0.0
sreetechnologic

Check your PMB.

$500 USD trong 6 ngày
(0 Đánh Giá)
0.0
indiansoftw

Please see PM

$500 USD trong 7 ngày
(0 Đánh Giá)
5.5
aworsh1

Hello: I am an epxerienced developer of .Net and can meet your expectations. Please consider. Thanks, Imran

$250 USD trong 5 ngày
(0 Đánh Giá)
0.0
devocean

Hi, I've experience in ASP.NET and SQL server. Please check PMB for more details.

$400 USD trong 5 ngày
(0 Đánh Giá)
0.0
muhtariq1

Please check your PM

$250 USD trong 7 ngày
(0 Đánh Giá)
0.0
Arif0605066

Please check your PM.

$250 USD trong 5 ngày
(0 Đánh Giá)
0.0
vbbharathi

As initial 25% is required to start the process. Remaining once we completed the project successfully in mentioned period.

$1000 USD trong 30 ngày
(0 Đánh Giá)
0.0