Simple Converting g1948.com to be DB driven (2)
Project language: English with support of presenting Hebrew texts
Environment: ASP + ASP.NET 2 (VS 2005) C# with MDB (2000 or XP) database
Our portal is G1948.com, which presents a table of graphic links to the most popular web sites in Israel. Right now we would like to build a version that will have management capability and the info regarding what icons to present will be taken from db
At that stage the output of the program will be asp text file so we would be able to upload and use it online and that asp will reflect the version that was built by the management tool. The form will have a button : make asp file.
The management form will contain:
1. subjects management
a. functions to select : add / edit / delete subject
2. icons in each subjects – management
a. add / edit / delete for the icons list
b. each icon will have that info:
i. alt text to present
ii. graphic file name
iii. url that this icon will link to
More to notice:
1. The management tool will support Hebrew and English. It will present Heb by using already developed module we will provide to you. With that tool also the programmer can switch the front size language easily with no need to know the other language.
2. Who will we preferred? Of course the price is important factor, but besides there are important parameters we take into consideration:
i. Supplier that uses Messenger / Skype /Yahoo Messenger for chat communication will be preferred. Please mention if you use such tool and WHAT ARE THE HOURS THAT YOU ARE FREE TO CHAT REGARDING THE PROJECT.
i. We will prefer supplier that will agree to get paid after the project is done or "by steps" so we will pay after each significant step of progress we will agree on, rather than paying in advanced with escrow before anything. In your reply please say if you agree to that method or not.
c. Your knowledge: Please provide answers to any of the questions, as you can. The answers will be checked for marking "knowledge advantage" of certain nominates upon others.
i. How would look like SQL string with the scenario of showing orders info from orders table but in orders there is ClientId and we want ClientName so sql should take that from clients table. In that table there are for example 2 fields: ClientId and ClientName.
ii. Let's take for example module which manages customers. The module has to set CustomerId to each new customer in a sequence, not automatic, numbering method (1,2,3.. etc). So if we have 4 customers that the last one is with CustomerId = 8 then the next should have CustomerId =9. When new customer want to register, pls say how would you code (what sql or other method) to find the new CustomerId you should use?
3. Please provide info/answers regarding all issues mentioned above