In Progress

Database Table Editor/Viewer - for User Permissions

I have 2 Tables. STATIONS & PERSONS

Each of these tables has numerous columns.

STATIONS has a column called MRPCapability.

PERSONS has it's own column called MRPCapability.

Although these columns in each table are NOT related - they do both have a Comma Separated List of Integers.

These integers are the PRIMARYKEYs to a separate Table (MRPTransactionCode).

Background context - the MRPTransactionCodes are 'PossibleTasks' . The list of MRPTransactionCodes for each Person or each Station is acting like a PERMISSION check to allow a certain Tasks to be actioned.

In brief - the Comma Separated List is saving having to create a many to many table to link Station to MRPTransactionCode & Persons to MRPTransactionCode.

REQUIREMENT

I need 2 user Controls. One for PERSONs - described below (and the 2nd for STATIONs, which will be the same as for Persons).

I would like a Grid style UserControl to visualise all Persons, showing which MRPTransaction they have permission to action.

The UserControl must allow editing of the MRPTransactionCode list (the comma separated Integers), in a user friendly GUI.

The Grid would have all Persons listed down the side (Row Headings).

Each MRPTransactionCode would be listed across the top (Colum Headings).

The data in the grid would be either true or false.

If false - leave blank.

If true - show an Icon (I can change the Icon later or send one now).

The database is MSSQL (2008 onwards).

The code should be written as a VS c# Project. (VS2015 or earlier).

.Net Framework 4.0.

This needs to be a Win Forms application.
If the Grid can be DevExpress (v14.1) grid - that is an advantage.

Cancelled 1st offer as the Freelancer would only communicate on Skype and would not accept payment through Freelancer.

Skills: PHP, Software Architecture

See more: database grid script user permissions, user registartion table database dnn, software write mq4, software write chip epson, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, software write books, software write protection, free software write book, software write book, user table database website address zip, mysql group permissions user permissions, xml table database, simple web app update table database, move table database, use table database, apply collation table database, mediawiki text editor table, extract name table database vb6, free webpage table database

About the Employer:
( 3 reviews ) Wigan, United Kingdom

Project ID: #12147516

Awarded to:

sheikDev

Hello, I have understood the requirement provided. you want to develop a windows application in .NET Which will show the two grids Persons and Stations. You want to show the Persons name in the Row Heading and Co More

£75 GBP in 4 days
(30 Reviews)
5.4

12 freelancers are bidding on average £139 for this job

maxpl

Hi, Im web developer from Poland, I have 5+ years of experience in webdesign/ development, WordPress, OperCart, E-commerce, obile Development, SEO and I have done number of projects. I can handle proje More

£222 GBP in 5 days
(30 Reviews)
6.6
sunsoftpro

First, I am sunsoftpro, I from VietNam. Nice to meet you! I have read your description and been interested in your project. I'm ready to discuss and do hard working so that complete great job. Please discuss requi More

£120 GBP in 3 days
(110 Reviews)
6.8
£222 GBP in 3 days
(28 Reviews)
6.4
urmate

HI Contact me for an efficient, perfect, well documented development of your project according to 100% accuracy and requirements, with dedicated support. Thanks Farah Saif

£80 GBP in 3 days
(167 Reviews)
6.4
£142 GBP in 3 days
(56 Reviews)
5.9
zhangbaksan

hello,how are you.i read your bid carefully. i can complete your project fully and have full database management app developing. i am database programming expert and have full experience for 12 years. java/javafx, c More

£150 GBP in 3 days
(33 Reviews)
6.0
expertwriter2010

Hello, Kindly award to me this order for high quality work within the given deadline. I have worked on more than 200 similar jobs and I have samples to show. With my great experience on this type of work, I am 100% More

£150 GBP in 3 days
(20 Reviews)
4.6
rehan828

Hi there, I am a professional Graphic Designer & wordpress expert with 2+ years experience. I am also a Student of Software Engineering in Pakistan. I have read and understand your project Description. I can make co More

£80 GBP in 3 days
(10 Reviews)
3.6
hniaz

lets get it done in 3 days please pm me for further details i can do this job and i can complete grip over mysql and c# i can do this for you and you will be satisfied with my work :)

£222 GBP in 3 days
(0 Reviews)
0.0
£150 GBP in 4 days
(0 Reviews)
0.0
£55 GBP in 4 days
(0 Reviews)
0.0