Closed

.NET Document and Record Management

This project received 31 bids from talented freelancers with an average bid price of $1360 USD.

Get free quotes for a project like this
Employer working
Project Budget
$500 - $2000 USD
Total Bids
31
Project Description

[url removed, login to view], C# web application for Ms. SQL database. Requirements:
1. The security of the system should be based on Active [url removed, login to view] 2? define which users are allows to add/edit/delete/read a table or a record in the system such as customers of salesperson X
2. The order form is a word template (around 20 templates? so the web form option isnt feasable) that will be submitted (NOT uploaded) to the database as a document, and the relevant metadata should be extracted/linked to it (using a mapped folder using webdav or something similar to what SharePoint does)
3. Ability of store different kind of orders(Customer Orders, Business Order etc)
4. Ability to attach documents to records
5. Row level versioning and security (versions of each product etc)
6. Document level versioning and security (such as versions of each order document)
7. Offline Access to the system
8. Support full text indexing and search based on column values
9. Every entity should store the CreatedBy (User), Created(datetime), LastModified (DateTime), LastModifiedBy(User), Version Number
10. The database schema is prelaminary and could be adjusted
11. The system design must be robust to support adding millions of records/documents and additional tables.

Tables:
Customers:
• ID (PK, identity, int)
• FullName (varchar 100)
• FullNameAr (nvarchar 100) ? Arabic Name
• Email
• Address
Companies:
• ID (PK, identity, int)
• Title (varchar 100)
• TitleAr (nvarchar(100))
• Address
• Email
• Fax
Products:
• ID (PK, identity, int)
• Name (varchar 100)
• Description (varchar 200)
• AvailableInStock (int)
• OrderLevel (int)
• UnitPrice (int)
Orders:
• ID (PK, identity, int)
• CustomerID (int)
• CompanyID (int)
• OrderDate (Datetime)
• Amount (money
• DeliveryTerms (varchar 100)
• PaymentTerms (varchar 100)
• Status
OrderDetails:
• ID (PK, identity, int)
• OrderId (int)
• ProductID (int)
• UnitPrice (money)
• Quantity (int)
• Total (money)
Attachments:
• ID (PK, identity, int)
• Document (Binary)
• RelatedRecordId (int)
• RelatedTable (varchar 20)

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online