Concluído

Web API (or Stored Procedure) to list out vehicles in 30 miles radios

Speed is of an essence. The quicker you deliver -- higher the chances of getting bonus.

Technology Required

----------------------------------

SQL Server

Visual [login to view URL] (C#.Net)

Google API (or different) Free version

Database Structure

---------------------------------

Office (Table ) - This is a table with Columns "OfficeID", "OfficeName", "Address", "City", "State", Zip"

OfficeCars (Table ) -- This is the table with "CarID", "CarNumber", "CarColor", "Langitude", "Lattitude", "LastUpdatedTimeStamp"

Function / Stored procedure can have an input parameter - OfficeID.

Upon calling the function.

The function needs to read the office table to gather the office address (or longitude & Latitude) from "Offices" table. Then the function needs result a list of cars that are currently located with in 30 mile radios. The result can be a temp table, array, csv, excel or in any other usable format.

NOTE: Offices table may have 100 records, however function is only taking one OfficeID as an input parameter. However, OfficeCars table may have over 1000 records

Deliverable

------------------

1) Preferably a stored procedure, if not a Web API

2) Instructions to install (In case of Web API) and use

3) Database Script to create tables and sample data.

Habilidades: Programação C#, Microsoft SQL Server , Google Maps API, Web API, RESTful API

Veja mais: sql stored procedure usps api, convert stored procedure web service, sharepoint web part stored procedure sybase, web part parameter stored procedure sql sharepoint 2007, mssql stored procedure list schema database, stored procedure sql2005 web service, sql server management studio express create procedure declare, sql server management studio create stored procedure, stored procedure list, visual studio 2010 google analytics api, sql server stored procedure call web api, web api with sql stored procedure example, asp net core web api stored procedure, how to debug sql stored procedure in sql server management studio, unable to start debugging on the web server visual studio 2017, how to automate rest api testing with visual studio c#, rest api stored procedure, sql server management studio web browser, web based sql server management studio, web browser in visual studio c#

Acerca do Empregador:
( 15 comentários ) Royal Oak, United States

ID do Projeto: #30308136

Concedido a:

bsreddy576

I have total 8 plus years of experience in SQL DEVELOPMENT. I can help create database tables and complicated stored procedures which can help you. Please ping me over the chat.

$140 USD em 7 dias
(1 Comentário)
1.6
(9 Comentários)
5.4

12 freelancers estão ofertando em média $221 nesse trabalho

(21 Comentários)
7.2
HajiAhmad

Very skilled, innovative and motivated Sr. Software Engineer with more than 10 years of experience analyzing, designing and developing web applications, desktop application and different software projects. Extensive e Mais

$250 USD in 5 dias
(5 Comentários)
4.5
(3 Comentários)
3.3
neuripa

Hello I read your project 'Web API (or Stored Procedure) to list out vehicles in 30 miles radios' and I think I have the necessary skills to complete it. I am software engineer and database developer I have 4+ years of Mais

$200 USD in 7 dias
(2 Comentários)
1.2
webdesigncanada

WEB DESIGN AND DEVELOPMENT Hello, Warm regards and thank you for reviewing our proposal. Problem Statement: Web API (or Stored Procedure) to list out vehicles in 30 miles radios I am confident that the project can be Mais

$223 USD in 7 dias
(0 Comentários)
0.0
srinivastadela

Having 5 years experience in sql server. Expert in SSMS, SSIS, SSRS and thoroughly using triggers, cursors, dynamic sub queries, jobs and indexing and expert in query optimization and managing performance issues and ha Mais

$140 USD in 7 dias
(0 Comentários)
0.0
(0 Comentários)
0.0
ManimaranCI

This is the Plan UI Platform - Asp.net MVC with LinQ Data Grid - Datatable Jquery plugin Database - Procedure We will write a procedure that will retrieve the data. The retrieved data were processed in an MVC contro Mais

$160 USD em 1 dia
(0 Comentários)
0.0
saadtariq329

Hello, I have taken a brief note of your project description. I’m an expert developer. My preference is to satisfy all of your venture’s prerequisites. Let’s come over the chat to discuss the project module, so we can Mais

$140 USD in 7 dias
(0 Comentários)
0.0
maksimkudria

High speed! Hello. I see that you need a web api or stored procedure to list out vehicles. I have rich experience in .NET, MS SQL, Google API. You may see my profile. I can start right now and complete successfully. I Mais

$250 USD em 1 dia
(1 Comentário)
0.0