本文整理汇总了C#中ToDoList.Category.GetId方法的典型用法代码示例。如果您正苦于以下问题:C# Category.GetId方法的具体用法?C# Category.GetId怎么用?C# Category.GetId使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类ToDoList.Category
的用法示例。
在下文中一共展示了Category.GetId方法的6个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Test_Delete_DeletesCategoryFromDatabase
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);
}
示例2: Test_FindFindsCategoryInDatabase
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);
}
示例3: Test_SaveAssignsIdToCategoryObject
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);
}
示例4: Test_GetTasks_RetrievesAllTaskWithCategory
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);
}
示例5: AddCategory
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();
}
}
示例6: AddCategory
public void AddCategory(Category newCategory)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlDataReader rdrCheckForDuplicate = null;
SqlCommand cmdCheckForDuplicate = new SqlCommand("SELECT * FROM categories_tasks WHERE [email protected] AND [email protected]", 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();
}
}