Concluído

Build CRUD operations for a WebAPI using EntityFramework (20 queries)

I am building a Contact management Web App with ASP.NET Core, EntityFramework Core, and AngularJS.

Front-end is already done, I have written the Models, migrated and populated the Data Base with dummy data.

The data structure (tables in the data base) is like:

- Organizations: Each Company/Organization contains one to any number of contacts and tags

- Contacts: each contact belongs to an organization or be on its own. each contact contains one to any number of phones, addresses, bankdata and tags

- phones: Zero to any number of phones belonging to a contact.

- banks data: Zero to any number of bankdata belonging to a contact.

- addresses: Zero to any number of addresses belonging to a contact.

- tags: Similar to tags in a blog. Each belong to an Organization, to a contact or [login to view URL] sensitive, meaning that: company = COMPANY

Contacts could add in the front-end as many phones, addresses, banks data and tags as they want. The Database should be able to accept those new items. Just one will be marked as main (main phone, main address, main bankdata)

The project consist in writing these 20 queries in the repository

1- CRUD functionalities:

CREATE

1.1 - createOrganization: as per Organization model

1.2 - createContact: as per Contact model

1.3 - createTag: if it does not exist added to its table and linked to a contact or a company

READ

1.3 - getAllOrganizations: Return a list of all companies + total number of organizations + number of contacts of each organization.

1.4 - getAllContacts: Return a list all the contacts. Each contact with its data + the organization it belongs to + main phone (phone table) + main address (address table)

1.5 - getOrganizationbyID: Return the data of an Organization + all the contacts belonging to it. Each contact with data + its main phone (phone table) + its main address (address table)

1.6 - getContactbyId: Return the data of a Contact + the data of the organization it belongs to + collection of phones, addresses and bankdata

UPDATE

1.7 - updateOrganization: edit one, some or all properties and save in DB

1.8 - updateContact: edit one, some or all properies and save in DB. Edition could be also editing or adding new phones, addresses or bank data to a contact.

1.9 - updateTag: link or unlink a tag to a contact or company

DELETE

1.10 - trashOrganization: set a value of true to a property "hide"

1.11 - unTrashOrganization: set a value of false to a property "hide"

1.12 - deleteorganization: if hide == true, remove organization from Database. Contacts belonging to a deleted organization won't be deleted.

1.13 - trasContact: set a value of true to a property "hide"

1.15 - unTrashContact: set a value of false to a property "hide"

1.16 - deleteContact: if hide == true, contact will be removed from Database along with its phones, bankdata and addreses

1.17 - deleteTag: unlink the tag from contacts and organizations it was related to and remove it from the database.

SAVE IMAGE METHODS

1.18 - uploadImage: Upload an image (logo) to (public/images) + adding the link to the image in the data base.

1.19 - editImage: overwrite the previous image for a new one, link in database remain the same

1.20 - deleteImage: delete the image from the images directory, remove the address in the database.

data should be returned as object or array that allow to show results with AngularJS in the front-end like, for example:

{{ [login to view URL] }}

I will be delivering all needed files, plus screenshots of the front-end.

Project is running late, so I will need somebody engaged to finish, deliver and test it in a short term. 20 queries should not get more than two days.

Project is part of a bigger project, other phases coming

Clarification:
The Project is JUST for writing the 20 needed queries in the repository inside this structure:
front-end -> angularController -> repository -> model->database

Front-end, the AngularControllers, the model and the database are already done. Of course you will have to propose any needed change on the dataBase schema to make your queries work.

If you need more than 2 days to understand the project plus 1 day to write the 20 queries, this project is obviously not for you.

Actually I will explain the project via Skype and be making the changes live and testing the results of the queries in Postman

Habilidades: Angular.js, ASP.NET, Programação C#, LINQ, MVC

Veja mais: crud operations using interface, crud operations using jquery ajax, crud operations using ajax, crud operations using sql, crud operations using jquery, crud operations wpf using wcf, crud operations wpf, crud operations java ajax, telerik wpf radgridview crud operations, crud operations wcf, software write mq4, software write chip epson, useful software write book, software write web specs, crud operations database generic jsf, crud operations jsp, free software write user guide, software write edid, free software write company profile, send search queries using perl

Acerca do Empregador:
( 0 comentários ) Karlsruhe, Germany

ID do Projeto: #11650081

Concedido a:

gogora

Hi This project seems really quick and I can do it in 1 day(maybe 6-7 working hours). Queries are pretty basic, doesn't involve really difficult logic and are very well described. As for me, I am a veteran .NET Mais

€140 EUR em 1 dia
(7 Comentários)
4.8

42 freelancers estão ofertando em média €238 para esse trabalho

ambar

I agree with you, you have already made it easy for a developer and still you are ready for help. Would be really pleasure to work a person like you. Do not award please as I just want to discuss with you before start Mais

€263 EUR in 7 dias
(33 Comentários)
7.8
Anuitex

Hi, Thank you for the opportunity to apply to your project. We are the team of IT professionals, who are passionate about what they do. Given our 7+ years experience and deep specialization in C#/ASP.NET develo Mais

€355 EUR in 3 dias
(47 Comentários)
7.7
mycuretech

Hi, I have extensive development experience in MVC Can we discuss details Please review my portfolio or blog to get most recent samples about ASP.NET,CSS,HTML,C# and other development technologies. http://c Mais

€400 EUR in 5 dias
(59 Comentários)
7.2
arityinfoway

Hello Sir, I have gone through your requirements regarding Build CRUD operations for a WebAPI using EntityFramework (20 queries). we brief and understand your idea and preference for job as you are looking for. I Mais

€168 EUR in 6 dias
(39 Comentários)
6.1
nikmah344

Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am having 7+ years of experience in Web Development. I have worked on below technologie Mais

€155 EUR in 2 dias
(35 Comentários)
5.8
€210 EUR in 3 dias
(31 Comentários)
5.8
sheikDev

Hello, I have gone through the requirements and understood well. Im ready to deliver within Sunday(3 days). I have good experience in Web APi methos using Entity Framework. Im overall 8 years experience in .NET Mais

€150 EUR in 3 dias
(52 Comentários)
5.5
SJMDEVELOPER

Hello, I have reviewed the initial RFP and can design and develop application as per your requirement. Portfolio: • [login to view URL] : web application • [login to view URL] • http: Mais

€155 EUR in 3 dias
(3 Comentários)
5.2
ludiac

Hi, We have gone through the project description and understood the requirements of the project. We do these kind of tasks on daily basis almost. We have plenty of experience in both desktop and web development and Mais

€155 EUR in 3 dias
(8 Comentários)
5.3
virals2583

Hello, I am from Maven Infotech ([login to view URL]). I have more than 12 years of experience in C#/VB .Net & have 70+ reviews. I have read your requirement to make repository classes for each entities. I ca Mais

€333 EUR in 7 dias
(2 Comentários)
4.8
gkalish

Having 10 + years experience in .NET and willing to start the work immediately .

€277 EUR in 3 dias
(24 Comentários)
4.8
webmynesys

Hello There, I have read your requirement carefully and have keen interest to complete his CRUD in you application. Please share access to the application to begin the work. I have 8+ years of experience in de Mais

€388 EUR in 3 dias
(8 Comentários)
4.7
AImran

Hi, I am an Expert web application developer having 7+ years of experience with ASP, ASP.NET, ASP.NET MVC, WCF, LINQ, Entity Framework, VB.NET, C#.NET, VB, VBA, MS SQL Server, Oracle, MYSQL, MS ACCESS, MS EXCEL, AJA Mais

€150 EUR in 2 dias
(21 Comentários)
4.4
pakaimsolutions

Hello, I hope you doing very well! I have gone through the description and would like to provide a quality solution using my 5+ years of professional experience in required skills. (.NET/ASP.NET - MVC, EF, SQL, C#). Mais

€128 EUR in 3 dias
(12 Comentários)
4.1
thesaw

Hello, I am a senior .NET developer 4 years experience , have muliple skills ( C#, VB.NET, ASP.NET, MVC, MS SQL , JQuery, AJAX and etc..) hope to work with you just contact me at Skype : [login to view URL]

€200 EUR in 10 dias
(20 Comentários)
4.2
RKYSP

Hi, I am an individual freelance, having more than 10yrs of exp in developing various applications using Microsoft Technologies (C#.Net, Asp.Net (MVC), Web API, XML, WPF, WCF (Webservices) kendo ui, Angular JS, NodeJS Mais

€200 EUR in 3 dias
(12 Comentários)
4.0
VnBestSolutions

Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Lo Mais

€377 EUR in 6 dias
(2 Comentários)
3.8
dekinghtg

hi, the query should be returned as list of class or list of dictionary for angularJS to read the result. i can do this for you.

€250 EUR in 2 dias
(8 Comentários)
3.7
vicksan

HI, I have more than 5 years of experience in working with web services, also i have been working on web api from last 18 months. I can definitely deliver the solution for you. Thanks

€122 EUR in 5 dias
(4 Comentários)
4.2
MuteXsolutions

Hi, We reviewed your job description and we are interested to assist you in writing the required queries for your task. We have the required expertise and experience to work on these queries. We would like to set u Mais

€140 EUR in 3 dias
(7 Comentários)
3.2