I need a developer to create an ASP.NET web service in C# using a SQL Azure Database.
The web service should pull data from [login to view URL] on a regular bases and insert into a database. This database does not exist. You will create it.
It should also Update any records that have already been added to the sql database on a regular basis.
The web service you create should expose a web API for us to consume this data from other applications.
So pretty much, use an existing API to get data from [login to view URL], then store it in our database, then make a web API so we can get it back out.
Here are their API docs: [login to view URL]
This project will most likely need to be updated to pull in data from sources other than [login to view URL] in the near future, which is why we will use GitHub for version control. I will create a github project and invite you.
Create a script to generate the azure database, and seed it with whatever data you need for it to function.
If you do not have an azure account, I will create a database or 2 on our account for you to work with and give you full rights to those databases during development. If you use your own account, we will need a script to generate and seed the database so we can move it to our account.
See attached image for a screen shot of the data we want. Its most likely data that can be stored in a single table. But we can discuss it. We also may need the images saved related to the donee.
Our company does outbound sales, business to business.
What we are going to do with this data:
When our sales agents make a sale in a particular town, we want to present them with some options to search the Donor's Choose data we collect. Such as Teachers, Firefighters, Police, Military, etc. Then they will choose the city and state of the business they sold to. They should then be presented with the TOP 4 results. There will be some constant search arguments that we will want to set in the background that the sales agent can't modify, such as how much the donee is trying to raise, how much is left to be raised, and more. So we need enough data to do this. We will also want to know when a fund has been filled and can no longer accept donations.
We want to make multiple interfaces with this data. One the potential customer can view. One the sales agent can view. One management can view. But all we need right now is to make sure we have the data is phase 1. Further phases are not included in this project. I am just giving you some context. We may create these UIs ourselves, or we may hire again to have a freelancer do it.
Eventually we need to scale this database to contain data from other fund raisers sites like GoFundMe, and about 3 others.