DNN Inventory/Order Form Module

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.