public DestinacijaModel Get(int id)
{
DestinacijaModel destinacija = new DestinacijaModel();
using (SqlConnection sqlConnection = new SqlConnection(_konekcioniString))
{
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
sqlCommand.CommandText = "SELECT * FROM Destinacija WHERE Id = @id";
sqlCommand.Parameters.AddWithValue("@id", id);
using (SqlDataReader reader = sqlCommand.ExecuteReader())
{
while (reader.Read())
{
destinacija.Id = (int)reader["Id"];
destinacija.Naziv = reader["Naziv"] as string;
}
}
}
}
return(destinacija);
}
public int Add(DestinacijaModel model)
{
using (SqlConnection sqlConnection = new SqlConnection(_konekcioniString))
{
sqlConnection.Open();
using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
{
sqlCommand.CommandText = "INSERT INTO Destinacija(Naziv) OUTPUT Inserted.Id " +
"VALUES(@Naziv)";;
sqlCommand.Parameters.AddWithValue("@Naziv", model.Naziv);
return((int)sqlCommand.ExecuteScalar());
}
}
}
