Sedang Disiapkan

Add Functionality & Clean Up Classic ASP Page with SQL

Do not bid without reviewing requirements.

We are looking for a developer who is an expert in classic ASP and SQL to help us make changes to our eshop. This project is the first small task that we want to accomplish but there are more.

We have a classic asp page that has a section of code that calculates an estimated ship date using variables from other pages and SQL db. The current code is illogical and confusing and we want to replace it with new, simpler code with new logic. We do not want to change other functionality on the page.

GENERAL DESCRIPTION:

This is a webpage where a customer approves custom artwork. When they approve it, we display an estimate of the date the final product will be shipped (ShipNLT date) and enter the date into the db. The date is dependent on these factors:

1) Productcode of the current OrderDetailID

2) Value of the "Timing of Art" option that is included in an option string. Value can be Normal or Rush.

3) Prep days value (this is preparation time expressed in # business days) that comes from variables on an include page ([login to view URL])

4) Use above to look up business days on a calendar to determine ShipNLT date.

5) Current date/time

Example: A Framed Print (productcode CP-101) is approved today, customer chose "Timing of Art" option = Rush, and the Prepartion Days for this productcode and option is 3 business days and so we loop thru the ArtworkCalendar to determine when we hit 3 business days and get the date.

- We also want to add code that looks at the Productcode of each OrderDetailID on the order to set flags that will be carried to the next page using extendURL.

- There are some other complexities but this is basically it along with cleaning up and removing unnecessary code.

- The core of this calculation is something that can be used on elsewhere on the website so we want it coded as a central function that can be called in to other pages.

- The existing code the selects/updates db info or extracts pertinent option data from the option string is all working code that can and should be reused.

Attached you will find the following:

1) [login to view URL] page - this is the page with the code. Will give unredacted page to winner.

2) [login to view URL] page - this is the page that holds the Prep days variables in #3 above and is called in to the page above. Will be provided to winner.

3) CrossReference showing which Productcodes use which [login to view URL] variable. Will be provided to winner.

4) Calendar Table screenshot - that shows the schema of the table that contains the calendar showing business days. Will be provided to winner.

More detail will be provided to the winner. For this task, developer will provide us changed files and we will test.

If successful, we have many other similar tasks and would like to establish a long term relationship with a qualified developer.

Kemahiran: ASP, Javascript, SQL

Lihat lagi: jobs classic asp javascript sql, classic asp ajax sql express, calling web service classic asp page, classic asp database sql connection, consuming webservice classic asp page using http post, loop classic asp page, classic asp page processing, post classic asp page script, adding captcha classic asp page, captcha classic asp page, call net web service javascript classic asp page, classic asp ms sql, perl classic asp page, classic asp textbox sql, classic asp page rank, classic asp page pdf file, ajax classic asp page, add search list box classic asp

Tentang Majikan:
( 20 ulasan ) Gilbert, United States

ID Projek: #18039932

Dianugerahkan kepada:

intemo

Hi! I offer you my skills for your project. I have long term development skills for classic asp projects (10+ years). I’m expert for ms sql server (full stack). I have experiences for outside API integration into those Lagi

$238 USD dalam 5 hari
(37 Ulasan)
5.0

25 pekerja bebas membida secara purata $212 untuk pekerjaan ini

$200 USD dalam 5 hari
(173 Ulasan)
7.1
JinMeng08

Hello, Sir. As you can see my profile I am professional and loyal to clients and all the clients are satisfied with me. “Very knowledgeable, timely and flexible. Worked with my schedule and features as the program wa Lagi

$200 USD dalam 3 hari
(54 Ulasan)
6.3
codetod

Hi I am more of an SQL programmer who have worked with VB6 and Classic ASP a few years back. Right now I am focused more on database programming, to write and do performance tuning for SQL queries, procedures and tr Lagi

$250 USD dalam 5 hari
(62 Ulasan)
6.2
nurba

Hi, I am interested to your projects, I mainly do classic asp works, I am experienced classic asp coder with more than 10 years experience You can give sample tasks, to check my skills I will need to have mo Lagi

$250 USD dalam 10 hari
(54 Ulasan)
5.4
JinDongZhe

Hi, sir I saw your job post and I would like to apply for this. I am very interested in your job please give me this project. I can finish this work easily and top quality. I have rich experience. I am good in G Lagi

$155 USD dalam 3 hari
(19 Ulasan)
5.3
justdotweaks

Hello, I have genuine skills in *PHP MVC frameworks such as Wordpress, Laravel, Magento*. *Ruby and Ruby on Rails *Angular, React JS, Node JS. Don't wo Lagi

$155 USD dalam 3 hari
(12 Ulasan)
4.9
vinisaac

I am in Chicago, USA. I have worked on a lot of ASP Classic projects outside and here both. I would love to work on your project. I have more than 25 years of experience in web/software development and system adm Lagi

$250 USD dalam 10 hari
(10 Ulasan)
4.5
pnjadhav

I have excellent skill in Classic ASP/VB Script/COM/COM+/JavaScript/jQuery/CSS/SQL with availability to help you full-time engagement for 20-40 hours per week. I am working with JavaScript/Classic ASP/VB Script from Lagi

$250 USD dalam 5 hari
(9 Ulasan)
4.5
vmadhavan15

am not a random bidder... Please ping me if you are interested with my proposal and share more details.... thank you..

$200 USD dalam 3 hari
(5 Ulasan)
4.2
xenoivan

Hi there I'm a Canadian IT Expert and just read description of your project thoroughly, glad to say i have done similar project before. I have working with Microsoft© for past 6 years and possess experimental kno Lagi

$400 USD dalam 3 hari
(4 Ulasan)
3.2
bizdigitalbrain

Hello, I have seen your requirement that you need Add Functionality & Clean Up Classic ASP Page with SQL. I am very expert having 6+ year of professional experience in PHP, wordpress within IT company. I am sure for Lagi

$155 USD dalam 3 hari
(3 Ulasan)
3.5
Proolancer

Hello, I m a web and desktop developer with 8 years of experience in .Net,I did many management web system during my professional life, I can do what you want in the deadline just contact me and we can discuss more a Lagi

$30 USD dalam 15 hari
(6 Ulasan)
2.9
mithlesh1

Over the last 12 years, I provide web design as well as web development. I am completely committed not only to provide basic services, also doing everything possible to get your business growing explosively. My Top Lagi

$155 USD dalam 3 hari
(1 Ulasan)
2.7
waseemsaleemg

Hi Dear, Our best concern is to follow your requirement and deadline and we will do our best for the success of your project. Feel free to send message to discuss your project with us. Thank you very much! Surely, we Lagi

$150 USD dalam 3 hari
(2 Ulasan)
2.4
digitalideas61

Hi, I would like to do your project. Please have a look at my proposal as follow. I have expertise in graphic designing, web designing, app development, SEO and much more. - Samad

$250 USD dalam 3 hari
(3 Ulasan)
2.1
mundadiya

Dear, Sorry I have no review in freelancer because I have not time to work with freelancer now I have full constration on my freelancing but you can check my work history at underlink [login to view URL] Lagi

$166 USD dalam 3 hari
(0 Ulasan)
0.0
freelancernewtec

Hello, I would like to take this assignment. I am having 14 years of experience on web development, deployment and project management. Below are my core technical skills •ASP.Net /HTML/CSS/JavaScript/JQuery •C# Lagi

$222 USD dalam 5 hari
(1 Ulasan)
0.0
fakhirsiddiqi

What I understand is the following: 1) Need to work on classic ASP (ASP 3). 2) Rectify the shipping date calculation logic. Calculation should be as follows: a) Check the current date and time. b) Check Lagi

$155 USD dalam 3 hari
(0 Ulasan)
0.0
abdelghafar

I have built multiple projects based on .net and later using .net core sql server , entity framework , entityframework core , jquery , angular 5 and 6 also built real time apps based on google products

$250 USD dalam 3 hari
(0 Ulasan)
0.0
aarya81

hello i am having vast experience in developing asp.net application. i have developed many window applications using c# and SQL as backend server. hello i am having 13+ years of experience in developing .net appli Lagi

$111 USD dalam 2 hari
(0 Ulasan)
0.0