.NET Document and Record Management

Cancelled

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)

Skills: PHP

See more: windows 10 design web templates, what is binary search in c, what is binary search, what is a binary search, what does binary, web design documents templates, web application requirements template, search binary, schema form, product management companies, order of binary search, ms companies, linked int, email address management, document management system in asp.net, define product design, define binary search, define application security, binary to text, binary search using c, binary search order, binary indexing, asp net web design templates, asp.net order management system, asp.net email templates

Project ID: #2800847

31 freelancers are bidding on average $1360 for this job

ilicotech

See private message.

$1190 USD in 10 days
(74 Reviews)
7.4
txperts

See private message.

$1700 USD in 10 days
(100 Reviews)
6.4
mastermatlab

See private message.

$1062.5 USD in 10 days
(80 Reviews)
6.1
eztechsystems

See private message.

$1275 USD in 10 days
(16 Reviews)
6.1
utsavsoftech

See private message.

$1530 USD in 10 days
(9 Reviews)
6.2
templecityt

See private message.

$765 USD in 10 days
(23 Reviews)
5.6
shekhar20

See private message.

$1274.15 USD in 10 days
(60 Reviews)
5.5
telossolutions

See private message.

$1593.75 USD in 10 days
(9 Reviews)
5.5
bharat28

See private message.

$1530 USD in 10 days
(27 Reviews)
5.6
thrillenium

See private message.

$850 USD in 10 days
(91 Reviews)
5.4
izharuislam

See private message.

$1700 USD in 10 days
(31 Reviews)
4.6
digicorpinf

See private message.

$1700 USD in 10 days
(2 Reviews)
4.5
itcentercom

See private message.

$1275 USD in 10 days
(2 Reviews)
3.9
DoubleBit

See private message.

$850 USD in 10 days
(8 Reviews)
3.6
angan

See private message.

$850 USD in 10 days
(17 Reviews)
3.4
quantumjayesh

See private message.

$1190 USD in 10 days
(2 Reviews)
3.1
johnysmithxperts

See private message.

$1700 USD in 10 days
(4 Reviews)
1.3
mestromani

See private message.

$1700 USD in 10 days
(2 Reviews)
1.9
codersdenvw

See private message.

$1700 USD in 10 days
(2 Reviews)
0.0
synthesisworld

See private message.

$1691.5 USD in 10 days
(0 Reviews)
3.7