Find Jobs
Hire Freelancers

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

€30-250 EUR

Завершено
Опублікований over 7 years ago

€30-250 EUR

Оплачується при отриманні
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
ID проекту: 11650081

Про проект

40 пропозицій(-ї)
Дистанційний проект
Активність 8 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
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, LINQ and EF developer working with EF and LINQ for over a 6-7 years. Please do not hesitate to contact me, I will be quick to finish your job. Thanks Archil
€140 EUR за 1 день
4,8 (14 відгуки(-ів))
5,5
5,5
40 фрілансерів(-и) готові виконати цю роботу у середньому за €237 EUR
Аватарка користувача
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 work on this project. When you want to discuss on this project. Just a quick request if you can please send me the models and the files you have already done. I think I need maximum 4-6 hours to check what is there and as soon as I will be able to get your demo controller call. As soon as I will get this I need to replace it by my API end point. In a word, I will have to write 20 API end point which will return result in array to view so that you can manage in angular view. - Just a quick question that do you have any role management option for this call? or if there is any you will handle this from your call. Please let me clear. - To hide the property we can use a single call, is it not? We can pass the True or false as a parameter, what do you think? - deleteorganization - I am not sure what you mean by this, if you will please clear me on this. - There is so many call to hide a property, it's very confusing to me. Honestly, I am not sure why I need to call so many methods to hide a property? - For images should we need to rename the image as per system name? I mean we will use some prefix or add something to the image? Whatever, I think if I will ask question would not be helpful for both of you. When I will get your files it would be much more easier to
€263 EUR за 7 дні(-в)
5,0 (64 відгуки(-ів))
8,5
8,5
Аватарка користувача
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 have more than 6+ years of experience in .NET, c#.net, vb.net, asp.net, MVC, Odoo, sql, mysql, Oracle, Azure, Entity Framework, Linq, Umbraco, Telerik, Devexpress, JQuery, Angularjs, CSS, HTML, Kendo UI, RDLC Report, Crystal Report, BioMetric Integration. I have developed more than 20 projects. Please send me message for further conversation. Thanks, Arity Infoway
€168 EUR за 6 дні(-в)
4,9 (46 відгуки(-ів))
6,4
6,4
Аватарка користувача
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 You can see my profile and my previous jobs. Im looking forward to get your reply, Thanks, Sheik
€150 EUR за 3 дні(-в)
4,9 (79 відгуки(-ів))
5,8
5,8
Аватарка користувача
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 can share the portfolio with you in chat. Looking forward to work with you. Thank you.
€155 EUR за 3 дні(-в)
4,9 (11 відгуки(-ів))
5,9
5,9
Аватарка користувача
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 technologies/languages/database server. - Asp.net,C#.net, MVC - Linq to SQL,Entity Framework - Jquery,AngularJS,NodeJS - Crystal Reports,DevExpress Reports - SQL server,SSIS Package,SSRS Reports - Web API 2, WCF Rest WebService - Application Security Remediation,Penetration Testing,OWASP 10 - SVN,TFS,Git I love working on SQL and query/sp optimization . I can achieve the results that you are looking for. We can discuss further on chat. Looking forward from your end. Thanks
€155 EUR за 2 дні(-в)
4,8 (35 відгуки(-ів))
5,9
5,9
Аватарка користувача
Having 10 + years experience in .NET and willing to start the work immediately .
€277 EUR за 3 дні(-в)
4,9 (24 відгуки(-ів))
4,9
4,9
Аватарка користувача
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 designing and developing website and application for various industries. I have expertise in using ASP.NET(C#), MVC 3, 4 &5 , SQL Server/ MySQL, WCF, WPF, Web API, Entity Frame Work, Json, JQuery, AngularJS, HTML5 & CSS3. Let's get connected here to begin the work. Please initiate the chat to discuss. I am also available to work on this project with further more requirement. Thanks and Regards Manish.
€388 EUR за 3 дні(-в)
4,8 (9 відгуки(-ів))
4,8
4,8
Аватарка користувача
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, AJAX, JQuery, HTML5, CSS3, Crystal Reports, web & window based services etc. Thanks
€150 EUR за 2 дні(-в)
5,0 (21 відгуки(-ів))
4,4
4,4
Аватарка користувача
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 за 5 дні(-в)
4,4 (6 відгуки(-ів))
5,0
5,0
Аватарка користувача
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#). Awaiting for your positive response so we can have final talk and start project immediately :)
€128 EUR за 3 дні(-в)
4,9 (12 відгуки(-ів))
4,1
4,1
Аватарка користувача
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 за 2 дні(-в)
4,9 (11 відгуки(-ів))
3,9
3,9
Аватарка користувача
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, SingleR, MySQL, Oracle and SQL Server etc). working with Giants clients as a vendor, got expertise in delivering the quality code with in the time please see my profile. Time and cost may vary based on the complexity and the requirements. Awaiting for your positive response
€200 EUR за 3 дні(-в)
4,7 (12 відгуки(-ів))
4,0
4,0
Аватарка користувача
Hi I'm ready for this project. I'm expert in ASP.NET development. Please give me more detail. I will do it perfectly. Best Regards VnNorthStar
€110 EUR за 2 дні(-в)
4,9 (12 відгуки(-ів))
3,6
3,6
Аватарка користувача
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 up a conf call where we can get the basic understanding from you so that we can get started. Thanks
€140 EUR за 3 дні(-в)
5,0 (9 відгуки(-ів))
3,5
3,5
Аватарка користувача
I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.
€222 EUR за 3 дні(-в)
5,0 (1 відгук)
2,1
2,1
Аватарка користувача
A proposal has not yet been provided
€100 EUR за 3 дні(-в)
5,0 (2 відгуки(-ів))
2,2
2,2
Аватарка користувача
Hi, I can to develop the web apis you need in two days, if you have all the models done. If you are using SQL Server I would recomend you using views to read the data from the database, it's faster and you have all the data easy. In case of urgency, I can start imediatelly. If you want to discuss further details, call me in the chat.
€222 EUR за 2 дні(-в)
5,0 (1 відгук)
2,2
2,2
Аватарка користувача
I've delivered many apis like what you are requesting. My bid is high because I know what I'm doing and will do it right. Especially given your time frame, you are asking a lot for just 2 days of effort. I can do it though (did something similar in Aug), but it will be a full 40 or so hours of work to get it right. Fortunately I'm available for the next few days, so I'm willing to stay up long nights to get it done. What database back-end do you want this in (or does it matter)?
€888 EUR за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I can help you quickly
€250 EUR за 5 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Hi, I have 6 years of experience in microsoft technologies like c#,asp.net,web api,entity framework,mvc and i have one year experience in angular jd and third party cotrols like keno ui , i can work this project. i believe you can accept my bid. thank you.
€155 EUR за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор GERMANY
Karlsruhe, Germany
0,0
0
Спосіб оплати верифіковано
На сайті з жовт. 5, 2015

Верифікація клієнта

Інші роботи від цього клієнта

Upload and setting up a Website and its database
$30-250 USD
Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.