Find Jobs
Hire Freelancers

Database Table Editor/Viewer - for User Permissions

£20-250 GBP

Completed
Posted over 7 years ago

£20-250 GBP

Paid on delivery
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.
Project ID: 12147516

About the project

11 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 Column Heading shows the MRPCode (referring Excel file) and have to show the icon if its exists for the person. Its the same for Stations also. The one thing i want to understand that the capability column values are starts with -999. Note : Im using VS2012 and no devExpress. Thanks, Sheik
£75 GBP in 4 days
4.9 (46 reviews)
5.8
5.8
11 freelancers are bidding on average £147 GBP for this job
User Avatar
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
4.9 (259 reviews)
6.8
6.8
User Avatar
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#, c/c++ is my top skill and passision. i can provide most quality and high speed. if you want to success, please contact me. Then, I will give you good result. hire me.
£150 GBP in 3 days
4.8 (34 reviews)
6.1
6.1
User Avatar
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% confident that I will offer you high quality work. I charge fairly and deliver on time. Assign to me this work and I will give you my best. I will start immediately.
£150 GBP in 3 days
4.9 (34 reviews)
5.2
5.2
User Avatar
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.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Wigan, United Kingdom
5.0
4
Payment method verified
Member since Nov 2, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.