DNN Inventory/Order Form Module

Completed Posted Apr 19, 2009 Paid on delivery
Completed Paid on delivery

Create a DotNetNuke (version 5.0) module in C# to provide basic inventory management for a CSA (Community Supported Agriculture) business and a simple online order form.

The order form requires initial input from the buyer and final input (actual weight of vegetables and meats) to finalize the order.

## Deliverables

CSA Inventory and Order Form Module for Dot Net Nuke

Dot Net Nuke Version: 5.0

Implementation Language: C#

# Overview

There are two aspects to this module: inventory management and order form entry and updating by the administrator.

## Inventory Management

Inventory management is accessible only to the administrator.? The inventory to be managed requires the following fields:

·? ? ? ? ? ? ? ? Item name

·? ? ? ? ? ? ? ? Price per unit

·? ? ? ? ? ? ? ? Approximate package size

·? ? ? ? ? ? ? ? Quantity on hand

## Order Form Entry

The order form entry is accessible to users.? The user can enter the following information regarding user information:

·? ? ? ? ? ? ? ? Name

·? ? ? ? ? ? ? ? Shipping Address / Pickup Location

·? ? ? ? ? ? ? ? Contact Phone

·? ? ? ? ? ? ? ? Contact Email

·? ? ? ? ? ? ? ? Pickup Date

The user can enter multiple order items:

·? ? ? ? ? ? ? ? Item name (selected from item list in the database)

·? ? ? ? ? ? ? ? Pieces to purchase

·? ? ? ? ? ? ? ? Preferences/notes/comments

### Administrator Order Update

The final price of each unit and the entire order can only be calculated after the administrator has updated the final weight of each item.? The administrator can also add a comment regarding the item on the order.? These fields are:

·? ? ? ? ? ? ? ? Filled order quantities

·? ? ? ? ? ? ? ? Comments

### Automatic Calculations

Once the administrator has filled in the actual order quantities, the module will automatically calculate:

·? ? ? ? ? ? ? ? Cost of each item (quantity * price per unit * unit amount shipped)

·? ? ? ? ? ? ? ? Total cost

### Automatic Fields

Each order form has two fields that are automatically populated:

·? ? ? ? ? ? ? ? An order ID

·? ? ? ? ? ? ? ? The order date (the current date)

Once these fields are set, they cannot be altered.

### Additional Fields

The following fields are used for record keeping:

·? ? ? ? ? ? ? ? Order cancelled

·? ? ? ? ? ? ? ? Order completed

## Order Form Document Export

The order form can be exported to a text file at any time, downloadable by the user or administrator.

## Other Administrator Functions

The administrator can view all orders in the database.? The administrator can select to view unfulfilled orders (OrderCompleted=false), cancelled orders (OrderCancelled=true), and completed orders (OrderCompleted=true).? Any order in the database can be exported to a text file and downloaded.

## Database

The database will consist of four tables:

### UserInformation

·? ? ? ? ? ? ? ? User ID

·? ? ? ? ? ? ? ? Name

·? ? ? ? ? ? ? ? Shipping Address

·? ? ? ? ? ? ? ? Contact Phone

·? ? ? ? ? ? ? ? ContactEmail

### OrderInformation

·? ? ? ? ? ? ? ? OrderID

·? ? ? ? ? ? ? ? UserID

·? ? ? ? ? ? ? ? OrderDate

·? ? ? ? ? ? ? ? OrderCancelled

·? ? ? ? ? ? ? ? OrderCompleted

·? ? ? ? ? ? ? ? PickupLocation

·? ? ? ? ? ? ? ? PickupDate

Note: Items may be picked up at a particular location and on a particular date, or may be shipped.

### Items

·? ? ? ? ? ? ? ? ItemID

·? ? ? ? ? ? ? ? ItemName

·? ? ? ? ? ? ? ? ItemPricePerUnit

·? ? ? ? ? ? ? ? ApproxPackageSize

·? ? ? ? ? ? ? ? QuantityOnHand

### OrderItems

·? ? ? ? ? ? ? ? OrderID

·? ? ? ? ? ? ? ? ItemID

·? ? ? ? ? ? ? ? Quantity

·? ? ? ? ? ? ? ? FilledOrderQuantity

·? ? ? ? ? ? ? ? UserComment

·? ? ? ? ? ? ? ? Comment

## Business Rules

The module should automatically subtract from the item’s quantity on hand as soon as the item and item quantity is entered by the user.

The user cannot enter a quantity greater than the quantity on hand for that item.

If the order is cancelled, the quantity on hand for each item should be automatically increased for each item’s quantity on the order form.

C# Programming Engineering MySQL PHP Project Management Software Architecture Software Testing SQL Web Hosting Website Management Website Testing

Project ID: #3820938

About the project

9 proposals Remote project Active Apr 27, 2009

Awarded to:

codexp3rts

See private message.

$425 USD in 20 days
(6 Reviews)
4.5

9 freelancers are bidding on average $425 for this job

dnndeveloper

See private message.

$425 USD in 20 days
(23 Reviews)
4.7
qualitysoftdev

See private message.

$425 USD in 20 days
(6 Reviews)
4.3
ObiOne86

See private message.

$425 USD in 20 days
(6 Reviews)
4.2
egyptsoft

See private message.

$425 USD in 20 days
(6 Reviews)
3.5
abdelmawla

See private message.

$425 USD in 20 days
(0 Reviews)
0.0
ss2782

See private message.

$425 USD in 20 days
(0 Reviews)
0.0
alkamodi

See private message.

$425 USD in 20 days
(3 Reviews)
0.0
setrambhardwaj

See private message.

$425 USD in 20 days
(1 Review)
0.0