public void Test_Find_FindsCategoryInDatabase()
{
//Arrange
Category testCategory = new Category("Household chores");
testCategory.Save();
//Act
Category foundCategory = Category.Find(testCategory.GetId());
//Assert
Assert.Equal(testCategory, foundCategory);
}
public void Test_GetTasks_RetrievesAllTasksWithCategory()
{
Category testCategory = new Category("Household chores");
testCategory.Save();
Task firstTask = new Task("Mow the lawn", testCategory.GetId(), "01-01-2017");
firstTask.Save();
Task secondTask = new Task("Do the dishes", testCategory.GetId(), "01-01-2017");
secondTask.Save();
List <Task> testTaskList = new List <Task> {
firstTask, secondTask
};
List <Task> resultTaskList = testCategory.GetTasks();
Assert.Equal(testTaskList, resultTaskList);
}
public override bool Equals(System.Object otherCategory)
{
if (!(otherCategory is Category))
{
return(false);
}
else
{
Category newCategory = (Category)otherCategory;
bool idEquality = this.GetId() == newCategory.GetId();
bool nameEquality = this.GetName() == newCategory.GetName();
return(idEquality && nameEquality);
}
}
public void Test_Save_AssignsIdToCategoryObject()
{
//Arrange
Category testCategory = new Category("Household chores");
testCategory.Save();
//Act
Category savedCategory = Category.GetAll()[0];
int result = savedCategory.GetId();
int testId = testCategory.GetId();
//Assert
Assert.Equal(testId, result);
}
public void AddCategory(Category newCategory)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO categories_tasks (category_id, task_id) VALUES (@CategoryId, @TaskId);", conn);
cmd.Parameters.Add(new SqlParameter("@CategoryId", newCategory.GetId()));
cmd.Parameters.Add(new SqlParameter("@TaskId", this.GetId()));
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
}