Find Jobs
Hire Freelancers

Backend Code for asp.net and mysql

₱440-1200 PHP

Closed
Posted almost 8 years ago

₱440-1200 PHP

Paid on delivery
I need you to develop some software for me. I would like this software to be developed for Windows using asp.net and mysqlAddCustomProperty Creates a new custom field for an asset table, which dynamically extends the asset type to support any fields as needed by the user.  Input Parameters: - TableID: An integer value which references a valid asset table in sys_assettables. - CustomProperties (datatable): Same table properties as in the CreateNewAssetType function. Business Logic - Using the TableID provided, for each row in the CustomProperties datatable add a row to the sys_assettables_properties table, matching the fields that are provided in the datatable with those in the sys_assettables_properties table. - Add a field to the existing AssetNameAsset table schema, extending the default field set created above to include each of the custom properties in the datatable. - Create a system audit log entry to indicate that a new field has been added to the table specified, by whom and at what date/time. Return Value: Upon success the function should return a blank string, indicating success, or in case of error return the error details in a human readable format (something that can just be passed back to the UI and understood by the user).  DeleteCustomProperty Deletes a field from the asset table specified, which also removes all of the data stored in the table within that field.  Input Parameters: - TableID: An integer value which references a valid asset table in sys_assettables. - PropertyName: A string value indicating the property/field to be deleted.  Business Logic: - First, validate that the PropertyName provided is not one of the core fields in our database schema, if it is it cannot be deleted and an error is returned to the user.  If this validation passes: o Delete the field from the sys_assettables_properties table for the TableID specified. o Delete the field from the actual database table. - Create a system audit log entry to indicate that the property was deleted, by whom and at what date/time. Output Format: Upon success the function should return a blank string, indicating success, or in case of error return the error details in a human readable format (something that can just be passed back to the UI and understood by the user).  DeleteAssetType Deletes an entire asset type/structure from the system as a soft-delete, leaving the tables/etc in tact.  Input Parameters: - TableID: An integer value which references a valid asset table in sys_assettables. Business Logic: - Toggles the IsDeleted bit field in the sys_assettables table for the TableID specified. - Create a system audit log entry to indicate that the table was soft-deleted, by whom and at what date/time. Output Format: Upon success the function should return a blank string, indicating success, or in case of error return the error details in a human readable format (something that can just be passed back to the UI and understood by the user).
Project ID: 10409814

About the project

5 proposals
Remote project
Active 8 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
5 freelancers are bidding on average ₱1,014 PHP for this job
User Avatar
Hi, I’ve had a good look at your project description and I’m very interested in providing a solution. I have 4+ hands on experience on developing quality web solutions as well as desktop standalone solutions. I used to develop systems using latest adaptive technology such as 1. .NET/ASP.NET - MVC4,MVC5 - Entity Framework - SQL - C# (for .NET solutions) 2. JQuery/Javascript/HTML5 - Angular.js/Bootstrap etc (for designing and front end implementations) I want to start work immediately and awaiting for your positive response on skp id "agilepksolutions" so I can show you some of my Quality Development Work as well as we can discuss project in details. Thank you.
₱1,000 PHP in 1 day
5.0 (61 reviews)
7.5
7.5
User Avatar
Hi, My name is Saddam and I am representing MuteX Solutions. We read your detailed description and we understand the main features you want in the backend code. We are professionals and we want you to send a brief understanding document of this project. You need to message us here to tell us that you are interested to see the brief understanding document. We have experienced individuals who have expertise in the field of ASP.NET and MySQL. We have also completed various projects in the past and we have worked with different clients but we are new to this website and want to show our skills and expertise to get started here. Looking forward to work with you. Thanks
₱920 PHP in 1 day
5.0 (2 reviews)
2.6
2.6

About the client

Flag of CANADA
Canada
5.0
1
Payment method verified
Member since May 4, 2016

Client Verification

Other jobs from this client

Javascript data gridview
₱440-1200 PHP
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.