Encerrado

VB.NET and ASP.NET

This project is a **Test** project.

The goal is to create 2 applications:

1st in VB.NET

2nd in ASP.NET

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

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 VB.NET 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 ASP.NET 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 VB.NET 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 conventions, writing code for apps, writing a compiler, web design simple programs, web design for mvc project, web design asp net, vb programs, vb note, vb.net simple programs, vb.net if, vb.net example programs, vb net example programs, vb.net articles, vb net 11, vb articles, use of vb net, use in vb.net, simple vb net programs, simple vb net code, simple programs in vb.net, simple asp net project with design and code, requirement application format, programs for vb.net, if vb net, id tech

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

ID do Projeto: #2983825

20 freelancers are bidding on average $35 for this job

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