public GoalTypeDTO getById(int Id)
{
GoalTypeDTO goalTypeDTO;
string query =
"SELECT * FROM goal_type gt WHERE gt.id=@id ";
using (SqlConnection connection = EstablishingConnection.GetConnection())
{
connection.Open();
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@id", Id);
SqlDataReader reader = command.ExecuteReader();
goalTypeDTO = new GoalTypeDTO();
while (reader.Read())
{
GoalTypeDTO newGoalTypeDTO = new GoalTypeDTO()
{
Id = (int)reader["id"],
Name = (string)reader["name"]
};
goalTypeDTO = newGoalTypeDTO;
}
}
connection.Close();
}
return(goalTypeDTO);
}
public List <GoalTypeDTO> GetAll()
{
List <GoalTypeDTO> goalTypes;
using (SqlConnection connection = EstablishingConnection.GetConnection())
{
connection.Open();
using (SqlCommand command = new SqlCommand("select * from goal_type", connection))
{
SqlDataReader reader = command.ExecuteReader();
goalTypes = new List <GoalTypeDTO>();
while (reader.Read())
{
GoalTypeDTO client = new GoalTypeDTO
{
Id = (int)reader["id"],
Name = (string)reader["name"],
};
goalTypes.Add(client);
}
}
return(goalTypes);
}
}
