//Send post request as the following json in the body
// {
//"breedingHabitat" : "",
//"scientificName" : "",
//"commonName" : "",
//"confirmed" : int 1 or 0
// }
public Mosquito AddNewMosquito(AddNewMosquito newMosquito)
{
using (var connection = new SqlConnection(ConnectionString))
{
var queryString = @"INSERT into [Species](breedingHabitat, scientificName, commonName, confirmed)
Output inserted.*
Values(@breedingHabitat, @scientificName, @commonName, @confirmed)";
var mosquito = connection.QueryFirstOrDefault <Mosquito>(queryString, newMosquito);
if (mosquito != null)
{
return(mosquito);
}
throw new Exception("Error, can't add the submission");
}
}
public ActionResult AddMosquito(AddNewMosquito newMosquito)
{
var createdMosquito = _connections.AddNewMosquito(newMosquito);
return(Accepted(createdMosquito));
}
