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