Find Jobs
Hire Freelancers

Backend Code for asp.net and mysql

₱440-1200 PHP

Zamknięte
Opublikowano prawie 8 lat temu

₱440-1200 PHP

Płatne przy odbiorze
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).
Identyfikator projektu: 10409814

Informację o projekcie

5 ofert
Zdalny projekt
Aktywny 8 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
5 freelancerzy składają oferty o średniej wysokości ₱1 014 PHP dla tej pracy
Awatar Użytkownika
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 w 1 dzień
5,0 (61 opinii)
7,5
7,5
Awatar Użytkownika
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 w 1 dzień
5,0 (2 opinii)
2,6
2,6

O kliencie

Flaga CANADA
Canada
5,0
1
Zweryfikowana metoda płatności
Członek od maj 4, 2016

Weryfikacja Klienta

Inne pracę od tego klienta

Javascript data gridview
₱440-1200 PHP
Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.