public TypeHabitat GetTypeHabitat(int AnnID) { TypeHabitat GetHabitat = new TypeHabitat(); connection.Close(); connection.Open(); using (SqlCommand commander = new SqlCommand("SP_get_TypeHabitat_by_AnnID", connection)) { commander.CommandType = CommandType.StoredProcedure; commander.Parameters.AddWithValue("AnnID", AnnID); using (SqlDataReader reader = commander.ExecuteReader()) { while (reader.Read()) { GetHabitat = new TypeHabitat { TypeID = (int)reader["TypeID"], Name = reader["Name"] == DBNull.Value ? string.Empty : (string)reader["Name"], Image = reader["Image"] == DBNull.Value ? string.Empty : (string)reader["Image"], Text = reader["Text"] == DBNull.Value ? string.Empty : (string)reader["Text"] }; } } } return(GetHabitat); }
public void PostHabitat(TypeHabitat typeHabitat, int AnnID) { using (SqlCommand commander = new SqlCommand("SP_create_MTM_TypeHabitat", connection)) { commander.CommandType = CommandType.StoredProcedure; commander.Parameters.AddWithValue("TypeHabitatID", typeHabitat.TypeID); commander.Parameters.AddWithValue("AnnID", AnnID); commander.ExecuteNonQuery(); } }