Encerrado

[url removed, login to view] and [url removed, login to view]

This project is a **Test** project.

The goal is to create 2 applications:

1st in [url removed, login to view]

2nd in [url removed, login to view]

Both Applications using MySQL

## Deliverables

Object:

To create 2 applications accessing MySQL database.

1st Application: Console Application in VB.Net.

2nd Application: Web site in [url removed, login to view]

1 ??" Create a MySQL database called easypay_db_dev.

All Tables in innoDb format.

Create 3 tables called message, vendor, agent.

Message table structure

Message_ID Integer

Message String

Type Integer

Status Integer

Vendor table structure

Vendor_ID Integer

Message_ID Integer

Message String

Agent table structure

Agent_ID Integer

Message_ID Integer

Message String

Message_ID is the key to relate to all the tables. Design relationship accordingly.

Note: table names and field names should follow Naming Conventions. Design one or use one you know. Example: <[url removed, login to view]>

2 ??" Create [url removed, login to view] Console application

Use timer to read Message table every 30 second.

For each record In Message table

If status = 0

If type = 1

Check if Message ID exists in Vendor Table

If exists

Update with current Message

Else

Create record in Vendor Table

Set status to 1

If type =2

Check if Message ID exists in Agent Table

If exists

Update with current Message

Else

Create record in Agent Table

Set status to 1

if type <> 1 and type <> 2 then

set status = 3

endif

endif

Next

Rules: Use Naming Conventions

No SQL statement in Code. Use Stored Procedures in MySQL

Use Threadpool to process each Status.

Handle all errors, the system cannot crash. See

<[url removed, login to view]>

Write ErrorLog to File in XML format

Send error messages to console with DEBUG compiler switches

Store MySQL setting and Timer period (30s) in XML format. See

<[url removed, login to view]>

3 ??" Create [url removed, login to view] Web Site

Simple Login Page with User Name and Password -> Create MySQL Table to store User Name and Password.

Once Logged

Read Number of Messages in Messages table with their type and status with Refresh option.

Read XML ErrorLog and Show page in Browser with Refresh option.

Rules: Use Naming Conventions.

HTML files separated from ASP files and CSS files

No SQL statement in Code. Use Stored Procedures in MySQL

Use Microsoft WEB Controls (Grid)

Handle all errors.

Use same XML file for connection string to MySQL as in [url removed, login to view] application.

* * *This broadcast message was sent to all bidders on Monday Nov 23, 2009 11:54:37 PM:

Some clarification to the original bid: The links provided in the requirement document are the implementations needed in the programs. On the ASP.NET. The MVC framework is the requested approach.

Habilidades: ASP, Javascript, PHP, XML

Ver mais: writing code apps, writing compiler, web design simple programs, web design mvc project, web design asp net, vb programs, vb note, net example programs, vb articles, simple net code, requirement application format, id tech, html dev, html compiler, grid html, example net, dev net, css compiler, create use web, conventions writing, mvc framework php, programs needed web design, php compiler, css agent, vbnet project

Acerca do Empregador:
( 6 comentários ) United Kingdom

ID do Projeto: #2983825

20 freelancers estão ofertando em média $35 para este trabalho

chetanasys

See private message.

$42.5 USD in 14 dias
(14 Comentários)
6.2
expertechie

See private message.

$42.5 USD in 14 dias
(99 Comentários)
5.9
izharuislam

See private message.

$42.5 USD in 14 dias
(28 Comentários)
4.5
hafeezmuhammad

See private message.

$42.5 USD in 14 dias
(20 Comentários)
4.4
agupta14

See private message.

$27.2 USD in 14 dias
(24 Comentários)
4.4
tfxthegreat

See private message.

$42.5 USD in 14 dias
(6 Comentários)
3.6
praneeth87

See private message.

$42.5 USD in 14 dias
(17 Comentários)
3.5
nikhilgolchha

See private message.

$25.5 USD in 14 dias
(10 Comentários)
3.2
intellipros

See private message.

$42.5 USD in 14 dias
(1 Comentário)
3.0
itmountsl

See private message.

$38.25 USD in 14 dias
(12 Comentários)
3.0
nick786

See private message.

$42.5 USD in 14 dias
(6 Comentários)
2.7
zeeshandad

See private message.

$42.5 USD in 14 dias
(8 Comentários)
2.4
sinsopevw

See private message.

$42.5 USD in 14 dias
(6 Comentários)
1.5
tghariharan

See private message.

$29.75 USD in 14 dias
(1 Comentário)
0.0
udalkumarbharti

See private message.

$42.5 USD in 14 dias
(0 Comentários)
0.0
raghubhukan

See private message.

$8.5 USD in 14 dias
(0 Comentários)
0.0
vw7401626vw

See private message.

$8.5 USD in 14 dias
(3 Comentários)
0.0
wizardguru

See private message.

$21.25 USD in 14 dias
(3 Comentários)
0.0
arielsmulever

See private message.

$42.5 USD in 14 dias
(0 Comentários)
0.0
andreeacasaru

See private message.

$42.5 USD in 14 dias
(0 Comentários)
0.0