public void AddCategory(ToDoCategory category)
{
SqlConnection connection = new SqlConnection(_connectionString);
SqlCommand command = connection.CreateCommand();
command.CommandText = "INSERT INTO Categories VALUES (@name); SELECT @@Identity";
command.Parameters.AddWithValue("@name", category.Name);
connection.Open();
category.Id = (int)(decimal)command.ExecuteScalar();
}
public void UpdateCategory(ToDoCategory category)
{
SqlConnection connection = new SqlConnection(_connectionString);
SqlCommand command = connection.CreateCommand();
command.CommandText = "UPDATE Categories SET Name = @name WHERE Id = @id";
command.Parameters.AddWithValue("@name", category.Name);
command.Parameters.AddWithValue("@id", category.Id);
connection.Open();
command.ExecuteNonQuery();
}
public IEnumerable <ToDoCategory> GetCategories()
{
SqlConnection connection = new SqlConnection(_connectionString);
SqlCommand command = connection.CreateCommand();
command.CommandText = "SELECT * FROM Categories";
connection.Open();
List <ToDoCategory> categories = new List <ToDoCategory>();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
ToDoCategory c = new ToDoCategory
{
Id = (int)reader["Id"],
Name = (string)reader["Name"]
};
categories.Add(c);
}
return(categories);
}