Freelancer

Description

TASK PART 1
Objective:
The objective is making a script to retrieve the six variables (see 1.1) in the test1.FLA and update the fields in the database (see 1.2).
The flash file has been developed already. All dynamic fields are already developed. Your only objective is updating the database with the available variable fields.


TASK PART 2
Objective:
The objective is making a script to retrieve data from database table tblUsers (see 1.5) and to place the data in the Flash file test2.FLA.


******************
1.1 Dynamic text field Variables in Flash file test1.FLA and test2.FLA
st1_txt
ut1_txt
st2_txt
ut2_txt
st3_txt
ut3_txt
******************


Database = MS sql server 2005
******************
1.2 Database table: tblUsers
- User_ID (FK int)
- User_Dash_Brutow_marketscore
- User_Dash_Brutow_ownscore
- User_Dash_Omz_marketscore
- User_Dash_Omz_ownscore
- User_Dash_Renta_marketscore
- User_Dash_Renta_ownscore
- User_Shoptype_ID
******************


******************
1.3 Stored Procedure
@User_ID int,
@st1_txt int,
@ut1_txt int,
@st2_txt int,
@ut2_txt int,
@st3_txt int,
@ut3_txt int,
@selectedShop int

AS
UPDATE tblusers
SET
User_ID=@User_ID,
User_Dash_Brutow_ownscore = @st1_txt
User_Dash_Brutow_ownscore = @ut1_txt
User_Dash_Renta_marketscore = @st2_txt
User_Dash_Renta_ownscore = @ut2_txt
User_Dash_Omz_marketscore = @st3_txt
User_Dash_Omz_ownscore = @ut3_txt
User_Shoptype_ID = @selectedShop

WHERE
tblusers.User_ID=@User_ID
*********************


******************
1.4 Session name:
M_User_ID
******************


******************
1.5 Stored Procedure

@User_ID int
AS
SELECT User_Dash_Brutow_marketscore, User_Dash_Brutow_ownscore,
User_Dash_Omz_marketscore, User_Dash_Omz_ownscore, User_Dash_Renta_marketscore,
User_Dash_Renta_ownscore, User_Shoptype_ID

FROM tblusers
where User_id=@user_id
******************

******************
Available resources:
1. test1.FLA file
2. test database
******************


******************
Used technologies:
1. MS SQL server 2005
2. ASP.NET
3. C#
4. Flash

The first one who come with a good proposal will get the project.
So please react ASAP.