We have an asp.net web-based application using an MSSQL database, and we need an additional editing screen.
The web application is based on a VFP desktop application that evolved over many years to include several screens to edit data in a particular manner. Attached is a shot of a VFP screen that allows editing multiple records simultaneously. We need to duplicate this in our asp.net web app.
The VFP screen contains approximately 500 lines of code, and uses class objects with about another 200 lines. It is an application that sums records from 2 tables, showing daily totals for each day in a given month. Users are able to change the values for any given day, or enter a value on a day with zero records, and save new or changed records for each day they have modified.
In the screen shot, the 'cash', 'check', and 'card' fields are editable, the 'total' field is a sum of those three and is not editable. The user can change multiple fields and as they change each field, the text color changes to red to indicate a changed value that has not been saved. When they click save, the changed value is compared to the original value, the difference is calculated and a new record is saved in 2 tables for each field that has been updated.
In addition, the user can quickly view the sub-total of several fields by right-clicking on individual fields, and the sub total is displayed at the bottom of the screen.
Other than the general structure of the Select statements, none of the VFP code will be of much use for translation to asp.net, but if you understand VFP it will make it that much easier for you to understand what we are doing.
40 freelancers are bidding on average $491 for this job
Good day! We have explored the attached shot. There are no difficulties to complete this work at first sight. If you are interested in our collaboration, please, contact us in the PM for more details. Thank you.