public Sample AddNewSample(AddNewSample newSample) { using (var connection = new SqlConnection(ConnectionString)) { newSample.date = DateTime.Now; var queryString = @"INSERT into [Sample](userId, numOfSpecies, date, totalNum, zipcode, trapType, lure) Output inserted.* Values(@userId, @numOfSpecies, @date, @totalNum, @zipcode, @trapType, @lure)"; var sample = connection.QueryFirstOrDefault <Sample>(queryString, newSample); if (sample != null) { return(sample); } throw new Exception("Error, can't add the sample"); } }
public ActionResult AddSample(AddNewSample newSample) { var createdSample = _connections.AddNewSample(newSample); return(Accepted(createdSample)); }