public void Test_Delete_DeletesCategoryFromDatabase()
{
//Arrange
string name1 = "Home stuff";
Category testCategory1 = new Category(name1);
testCategory1.Save();
string name2 = "Work stuff";
Category testCategory2 = new Category(name2);
testCategory2.Save();
DateTime fakeTime = new DateTime(2016, 1, 1);
Task testTask1 = new Task("Mow the lawn", testCategory1.GetId(),fakeTime);
testTask1.Save();
DateTime fakeTime1 = new DateTime(2016, 1, 1);
Task testTask2 = new Task("Send emails", testCategory2.GetId(),fakeTime1);
testTask2.Save();
//Act
testCategory1.Delete();
List<Category> resultCategories = Category.GetAll();
List<Category> testCategoryList = new List<Category> {testCategory2};
List<Task> resultTasks = Task.GetAll();
List<Task> testTaskList = new List<Task> {testTask2};
//Assert
Assert.Equal(testCategoryList, resultCategories);
Assert.Equal(testTaskList, resultTasks);
}
public void Test_FindFindsCategoryInDatabase()
{
//Arrange
Category testCategory = new Category("Household chores");
testCategory.Save();
//Act
Category foundCategory = Category.Find(testCategory.GetId());
//Assert
Assert.Equal(testCategory, foundCategory);
}
public void Test_FindFindsCategoryInDatabase()
{
//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());
firstTask.Save();
Task secondTask = new Task("Do the dishes", testCategory.GetId());
secondTask.Save();
List <Task> testTaskList = new List <Task> {
firstTask, secondTask
};
List <Task> resultTaskList = testCategory.GetTasks();
Assert.Equal(testTaskList, resultTaskList);
}
public void Test_Find_FindCategoryInDatabase()
{
//Arrange
Category newCategory = new Category("Chores");
newCategory.Save();
//Act
Category foundCategory = Category.Find(newCategory.GetId());
//Assert
Assert.Equal(newCategory, foundCategory);
}
public void Test_Save_AssignsIdToCategoryObject()
{
Category testCategory = new Category("Household chores");
testCategory.Save();
Category savedCategory = Category.GetAll()[0];
int result = savedCategory.GetId();
int testId = testCategory.GetId();
Assert.Equal(testId, result);
}
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 descriptionEquality = (this.GetDescription() == newCategory.GetDescription());
return(idEquality && descriptionEquality);
}
}
public void Test_GetTasks_RetrieveAllTasksWithCategory()
{
//Arrange
Category testCategory = new Category("Everyday chores");
testCategory.Save();
DateTime myDate = new DateTime(1999, 6, 4);
Task firstTask = new Task("Mow the lawn", testCategory.GetId(), myDate);
firstTask.Save();
Task secondTask = new Task("Do the Dishes", testCategory.GetId(), myDate);
secondTask.Save();
List <Task> testTaskList = new List <Task> {
firstTask, secondTask
};
List <Task> result = testCategory.GetTask();
Assert.Equal(testTaskList, result);
}
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_AssignsIdToCategory()
{
// Arrange
Category newCategory = new Category("Chores");
// Act
newCategory.Save();
Category savedCategory = Category.GetAll()[0];
int resultId = savedCategory.GetId();
int testId = newCategory.GetId();
// Assert
Assert.Equal(testId, resultId);
}
public void Test_SaveAssignsIdToCategoryObject()
{
//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 Test_Save_AssignIdToCategoryObject()
{
//Arrange
Category testCategory = new Category("Everyday chores");
testCategory.Save();
Category savedCategory = Category.GetAll()[0];
//Act
int result = savedCategory.GetId();
int testId = testCategory.GetId();
//Assert
Assert.Equal(testId, result);
}
public HomeModule()
{
Get["/"] = _ => {
return(View["index.cshtml"]);
};
Get["/categories"] = _ => {
var allCategories = Category.GetAll();
return(View["categories.cshtml", allCategories]);
};
Get["/categories/new"] = _ => {
return(View["category_form.cshtml"]);
};
Post["/categories"] = _ => {
var newCategory = new Category(Request.Form["category-name"]);
newCategory.Save();
var allCategories = Category.GetAll();
return(View["categories.cshtml", allCategories]);
};
Get["/categories/{id}"] = parameters => {
var selectedCategory = Category.Find(parameters.id);
List <Task> categoryTasks = selectedCategory.GetTasks();
return(View["category.cshtml", selectedCategory]);
};
Get["/categories/{id}/tasks/new"] = parameters => {
Dictionary <string, object> model = new Dictionary <string, object>();
Category selectedCategory = Category.Find(parameters.id);
List <Task> allTasks = selectedCategory.GetTasks();
model.Add("category", selectedCategory);
model.Add("tasks", allTasks);
return(View["category_tasks_form.cshtml", model]);
};
Post["/tasks"] = _ => {
Category selectedCategory = Category.Find(Request.Form["category-id"]);
int selectedCategoryId = selectedCategory.GetId();
string taskDescription = Request.Form["task-description"];
DateTime taskDue = Request.Form["task-due"];
Task newTask = new Task(taskDescription, selectedCategoryId, taskDue);
newTask.Save();
List <Task> categoryTasks = selectedCategory.GetTasks();
return(View["category.cshtml", selectedCategory]);
};
Post["/"] = _ => {
Task.DeleteAll();
Category.DeleteAll();
return(View["index.cshtml"]);
};
}
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.AddWithValue("@CategoryId", newCategory.GetId());
cmd.Parameters.AddWithValue("@TaskId", this.GetId());
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
}
public void Test_DeleteCategory_DeletesEntireCategory()
{
// Arrange
Category newCategory = new Category("Kitchen");
newCategory.Save();
int targetId = newCategory.GetId();
Task firstTask = new Task("Wash Dishes", "1999-01-01");
firstTask.Save();
Task secondTask = new Task("Empty Dishwasher", "2000-01-01");
secondTask.Save();
//Act
newCategory.Delete();
//Assert
Assert.Equal(0, Category.GetAll().Count);
}
public void Test_Delete_DeletesCategoryFromDatabase()
{
//Arrange
string name1 = "Home stuff";
Category testCategory1 = new Category(name1);
testCategory1.Save();
string name2 = "Work stuff";
Category testCategory2 = new Category(name2);
testCategory2.Save();
Task testTask1 = new Task("Mow the lawn", testCategory1.GetId());
testTask1.Save();
Task testTask2 = new Task("Send emails", testCategory2.GetId());
testTask2.Save();
//Act
testCategory1.Delete();
List <Category> resultCategories = Category.GetAll();
List <Category> testCategoryList = new List <Category> {
testCategory2
};
List <Task> resultTasks = Task.GetAll();
List <Task> testTaskList = new List <Task> {
testTask2
};
//Assert
Assert.Equal(testCategoryList, resultCategories);
Assert.Equal(testTaskList, resultTasks);
}
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);
SqlParameter categoryIdParameter = new SqlParameter();
categoryIdParameter.ParameterName = "@CategoryId";
categoryIdParameter.Value = newCategory.GetId();
cmd.Parameters.Add(categoryIdParameter);
SqlParameter taskIdParameter = new SqlParameter();
taskIdParameter.ParameterName = "@TaskId";
taskIdParameter.Value = this.GetId();
cmd.Parameters.Add(taskIdParameter);
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
}
public HomeModule()
{
Get["/"] = _ => {
return(View["index.cshtml"]);
};
Get["/tasks/new"] = _ => {
return(View["task_form.cshtml"]);
};
Post["/tasks/new"] = _ => {
Task newTask = new Task(Request.Form["task-description"]);
newTask.Save();
return(View["success.cshtml"]);
};
Get["/categories"] = _ => {
var allCategories = Category.GetAll();
return(View["categories.cshtml", allCategories]);
};
Get["/tasks"] = _ => {
List <Task> allTasks = Task.GetAll();
return(View["tasks.cshtml", allTasks]);
};
Get["/categories/new"] = _ => {
return(View["category_form.cshtml"]);
};
Post["/categories/new"] = _ => {
Category newCategory = new Category(Request.Form["category-name"]);
newCategory.Save();
return(View["success.cshtml"]);
};
Get["tasks/{id}"] = parameters => {
Dictionary <string, object> model = new Dictionary <string, object>();
Task SelectedTask = Task.Find(parameters.id);
List <Category> TaskCategories = SelectedTask.GetCategories();
List <Category> AllCategories = Category.GetAll();
model.Add("task", SelectedTask);
model.Add("taskCategories", TaskCategories);
model.Add("allCategories", AllCategories);
return(View["task.cshtml", model]);
};
Get["categories/{id}"] = parameters => {
Dictionary <string, object> model = new Dictionary <string, object>();
Category SelectedCategory = Category.Find(parameters.id);
List <Task> CategoryTasks = SelectedCategory.GetTasks();
List <Task> AllTasks = Task.GetAll();
model.Add("category", SelectedCategory);
model.Add("categoryTasks", CategoryTasks);
model.Add("allTasks", AllTasks);
return(View["category.cshtml", model]);
};
Post["/categories"] = _ => {
var newCategory = new Category(Request.Form["category-name"]);
newCategory.Save();
var allCategories = Category.GetAll();
return(View["categories.cshtml", allCategories]);
};
Post["/tasks"] = _ => {
Category selectedCategory = Category.Find(Request.Form["category-id"]);
int selectedCategoryId = selectedCategory.GetId();
string taskDescription = Request.Form["task-description"];
Task newTask = new Task(taskDescription);
newTask.Save();
List <Task> categoryTasks = selectedCategory.GetTasks();
return(View["category.cshtml", selectedCategory]);
};
Post["task/add_category"] = _ => {
Category category = Category.Find(Request.Form["category-id"]);
Task task = Task.Find(Request.Form["task-id"]);
task.AddCategory(category);
return(View["success.cshtml"]);
};
Post["category/add_task"] = _ => {
Category category = Category.Find(Request.Form["category-id"]);
Task task = Task.Find(Request.Form["task-id"]);
category.AddTask(task);
return(View["success.cshtml"]);
};
}
public void AddCategory(Category newCategory)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlDataReader rdrCheckForDuplicate = null;
SqlCommand cmdCheckForDuplicate = new SqlCommand("SELECT * FROM categories_tasks WHERE category_id=@CategoryId AND task_id=@TaskId", conn);
SqlParameter categoryIdParameterCheckForDuplicate = new SqlParameter();
categoryIdParameterCheckForDuplicate.ParameterName = "@CategoryId";
categoryIdParameterCheckForDuplicate.Value = newCategory.GetId();
cmdCheckForDuplicate.Parameters.Add(categoryIdParameterCheckForDuplicate);
SqlParameter taskIdParameterCheckForDuplicate = new SqlParameter();
taskIdParameterCheckForDuplicate.ParameterName = "@TaskId";
taskIdParameterCheckForDuplicate.Value = this.GetId();
cmdCheckForDuplicate.Parameters.Add(taskIdParameterCheckForDuplicate);
List<int> matchedJoins = new List<int> {};
rdrCheckForDuplicate = cmdCheckForDuplicate.ExecuteReader();
while(rdrCheckForDuplicate.Read())
{
matchedJoins.Add(rdrCheckForDuplicate.GetInt32(0));
}
if (rdrCheckForDuplicate != null) rdrCheckForDuplicate.Close();
if (matchedJoins.Count == 0)
{
SqlCommand cmd = new SqlCommand("INSERT INTO categories_tasks (category_id, task_id) VALUES (@CategoryId, @TaskId);", conn);
SqlParameter categoryIdParameter = new SqlParameter();
categoryIdParameter.ParameterName = "@CategoryId";
categoryIdParameter.Value = newCategory.GetId();
cmd.Parameters.Add(categoryIdParameter);
SqlParameter taskIdParameter = new SqlParameter();
taskIdParameter.ParameterName = "@TaskId";
taskIdParameter.Value = this.GetId();
cmd.Parameters.Add(taskIdParameter);
cmd.ExecuteNonQuery();
}
if (conn != null)
{
conn.Close();
}
}
public void Test_GetTasks_RetrievesAllTaskWithCategory()
{
Category testCategory = new Category("Household chores");
testCategory.Save();
DateTime fakeTime = new DateTime(2014, 1, 1);
Task firstTask = new Task ("Mow the lawn", testCategory.GetId(), fakeTime);
firstTask.Save();
Task secondTask = new Task("Do the dishes", testCategory.GetId(), fakeTime);
secondTask.Save();
List<Task> testTaskList = new List<Task> {firstTask, secondTask};
List<Task> resultTaskList = testCategory.GetTasks();
Assert.Equal(testTaskList, resultTaskList);
}
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);
SqlParameter categoryIdParameter = new SqlParameter();
categoryIdParameter.ParameterName = "@CategoryId";
categoryIdParameter.Value = newCategory.GetId();
cmd.Parameters.Add(categoryIdParameter);
SqlParameter taskIdParameter = new SqlParameter();
taskIdParameter.ParameterName = "@TaskId";
taskIdParameter.Value = this.GetId();
cmd.Parameters.Add(taskIdParameter);
cmd.ExecuteNonQuery();
if (conn != null)
{
conn.Close();
}
}
