//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)); }