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