public int AddObservation(BirdObservation observation)
{
// TODO use date from user
const string insertStudent = "insert into birdObservation (birdId, userId, latitude, longitude, placeName, population, comment, created) values (@birdId, @userId, @latitude, @longitude, @placeName, @population, @comment, @created)";
using (SqlConnection databaseConnection = new SqlConnection(ConnectionString))
{
databaseConnection.Open();
using (SqlCommand insertCommand = new SqlCommand(insertStudent, databaseConnection))
{
insertCommand.Parameters.AddWithValue("@birdId", observation.BirdId);
insertCommand.Parameters.AddWithValue("@userId", observation.UserId);
//insertCommand.Parameters.AddWithValue("@created", observation.Created);
DateTime?da = observation.Created;
if (da == null)
{
insertCommand.Parameters.AddWithValue("@created", DateTime.Now.Date);
}
else
{
insertCommand.Parameters.AddWithValue("@created", da);
}
insertCommand.Parameters.AddWithValue("@latitude", observation.Latitude);
insertCommand.Parameters.AddWithValue("@longitude", observation.Longitude);
SetParameter("placeName", observation.Placename, insertCommand);
insertCommand.Parameters.AddWithValue("@population", observation.Population);
SetParameter("comment", observation.Comment, insertCommand);
int rowsAffected = insertCommand.ExecuteNonQuery();
// TODO return new ID, or new object
return(rowsAffected);
}
}
}
public int UpdateObservation(string id, BirdObservation observation)
{
return(0);
}