当前位置: 首页>>代码示例>>C#>>正文


C# Category.GetId方法代码示例

本文整理汇总了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);
        }
开发者ID:Rouz1130,项目名称:Delete-Update-Category,代码行数:31,代码来源:CategoryTest.cs

示例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);
    }
开发者ID:jmk22,项目名称:todo_categories_databases_CRUD,代码行数:12,代码来源:CategoryTest.cs

示例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);
    }
开发者ID:jmk22,项目名称:todo_categories_databases_CRUD,代码行数:15,代码来源:CategoryTest.cs

示例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);
        }
开发者ID:Rouz1130,项目名称:Delete-Update-Category,代码行数:16,代码来源:CategoryTest.cs

示例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();
      }
    }
开发者ID:jmk22,项目名称:todo_categories_databasesextended_02,代码行数:24,代码来源:Task.cs

示例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();
              }
        }
开发者ID:CharlesEwel,项目名称:csharp-todo-week4,代码行数:48,代码来源:Task.cs


注:本文中的ToDoList.Category.GetId方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。