This is a MYSQL multiuser system where users can post notes (Details) against a list of primary records (Parents) via a C# application run on their individual desktops.
I have a "Parent" table with a integer primary key field and text description field as well as some other fields. I have another "Detail" table that has a second integer key field as well as a reference field back to the first table, a TEXT notes field, and and some other fields (user, timeStamp, etc). Its similar to an Order/LineItems setup. The PK's shown below can be adjusted as per your suggestions.
I need a C# windows application that can scroll through the Parent table (Alerts) and view and make entries (Notes), either insert, update, or delete in the Child Table.
A user should only be able to edit or delete their own notes.
An Apply button should post inserts or updates to the notes table as the case may be.
A timed function should indicate to the user that new parent or detail records are available, and which of the detail records has new inserts or updates.
A refresh button should update the Parent records or the Detail records.
More features may be added as we go.
I can make the parent and detail tables on my MYSQL server available to the developer.
The table specs are:
Parent Table:
INT pk (Primary Key)
DATETIME timeStamp [sortable]
VHARCHAR sSymbol [sortable]
VHARCHAR oSymbol [sortable]
TEXT alert
[Some other fields, sortable]
Detail Table:
INT pk
INT fk (references the Parent)
VARCHHAR user
DATETIME postTime (or update time as the case may be)
TEXT notes
[possibly some other fields]
Hello, I am an expert .NET programmer with over 15 years of application design and development experience. I have done a lot of work with C# and MySQL and should be able to have this done for you in just a couple days. Please let me know if you have any questions. I look forward to working with you.
Dear Sir,
I am writing with reference to your advertisement. I consider that my credentials and interests match with your requirement and want to apply for the same.
Please check PMB for details.
HI AustinKalb ,
I (Myself a senior ASP.NET programmer using C# and VB) have a team having experience of more than 5 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-free codes at the very first instance. After seeing our quality of work and the cooperation offered to you even after the work has been delivered to you, you'll come to us again and again to avail our services.
I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I can achieve the results that you are asking for within your timeframe and budget. I am confident I can exceed your expectations and I would love to work on your project.
Thanks,
Murtaza
Hi; I have studied your project requirement and understood the requirement. We feel confident about this project. We would like to share our experience to develop your project also. Please open chat so that we can show you the best work from our portfolio.