En cours

.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.

Compétences : .NET, Programmation C, Programmation C#, SQL, Visual Basic

Voir plus : 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

Concernant l'employeur :
( 15 commentaires ) Orlando, United States

N° du projet : #1021497

Décerné à :

aisha2010

Please check PM. Thanks!

250 $ USD en 5 jours
(3 Commentaires)
3.7

16 freelance ont fait une offre moyenne de 341 $ pour ce travail

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 Plus

250 $ USD en 7 jours
(20 Commentaires)
5.6
tamrakar81

Hi, Please check PM . Thanks, T

250 $ USD en 5 jours
(36 Commentaires)
5.3
mohsin649

Thanks for considering my bid. Please check PMB. Thanks

250 $ USD en 6 jours
(8 Commentaires)
4.3
tooltor

Expert programmer here, please read the private message.

250 $ USD en 7 jours
(2 Commentaires)
2.3
akashmathur

Bid is negotiable

300 $ USD en 5 jours
(0 Commentaires)
0.0
HDDevelopment

Kindly check PMB

250 $ USD en 4 jours
(0 Commentaires)
0.0
dozstudio

check the pm box.

250 $ USD en 7 jours
(0 Commentaires)
0.0
vijisivaa

Ready to do.

250 $ USD en 5 jours
(0 Commentaires)
0.0
sreetechnologic

Check your PMB.

500 $ USD en 6 jours
(0 Commentaires)
0.0
indiansoftw

Please see PM

500 $ USD en 7 jours
(0 Commentaires)
5.5
aworsh1

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

250 $ USD en 5 jours
(0 Commentaires)
0.0
devocean

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

400 $ USD en 5 jours
(0 Commentaires)
0.0
muhtariq1

Please check your PM

250 $ USD en 7 jours
(0 Commentaires)
0.0
Arif0605066

Please check your PM.

250 $ USD en 5 jours
(0 Commentaires)
0.0
vbbharathi

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

1000 $ USD en 30 jours
(0 Commentaires)
0.0