DNN Inventory/Order Form Module
$495-500 USD
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.
Project ID: #3820938