本文整理汇总了C#中ToDoList.Category类的典型用法代码示例。如果您正苦于以下问题：C# Category类的具体用法？C# Category怎么用？C# Category使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
Category类属于ToDoList命名空间，在下文中一共展示了Category类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: Find
public static Category Find(int id)
{
SqlConnection conn = DB.Connection();
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM categories WHERE id = @CategoryId;", conn);
SqlParameter categoryIdParameter = new SqlParameter();
categoryIdParameter.ParameterName = "@CategoryId";
categoryIdParameter.Value = id.ToString();
cmd.Parameters.Add(categoryIdParameter);
SqlDataReader rdr = cmd.ExecuteReader();
int foundCategoryId = 0;
string foundCategoryDescription = null;
while(rdr.Read())
{
foundCategoryId = rdr.GetInt32(0);
foundCategoryDescription = rdr.GetString(1);
}
Category foundCategory = new Category(foundCategoryDescription, foundCategoryId);
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return foundCategory;
}
开发者ID:Rick1970，项目名称:todo-with-join-statement，代码行数:32，代码来源:Category.cs
示例2: 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
示例3: GetAll
public static List<Category> GetAll()
{
List<Category> allCategories = new List<Category>{};
SqlConnection conn = DB.Connection();
SqlDataReader rdr = null;
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM categories;", conn);
rdr = cmd.ExecuteReader();
while(rdr.Read())
{
int categoryId = rdr.GetInt32(0);
string categoryName = rdr.GetString(1);
Category newCategory = new Category(categoryName, categoryId);
allCategories.Add(newCategory);
}
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return allCategories;
}
开发者ID:CharlesEwel，项目名称:csharp-todo-week4，代码行数:30，代码来源:Category.cs
示例4: HomeModule
public HomeModule()
{
Get["/"] = _ => {
return View["index.cshtml"];
};
Get["/tasks"] = _ => {
var AllTasks = Task.All();
return View["tasks.cshtml", AllTasks];
};
Get["/tasks/new"] = _ => {
return View["task_form.cshtml"];
};
Get["/tasks/{id}"] = parameters => {
var SelectedTask = Task.Find(parameters.id);
return View["/task.cshtml", SelectedTask];
};
Get["/categories"] = _ => {
var AllCategories = Category.All();
return View["categories.cshtml", AllCategories];
};
Get["/categories/new"] = _ => {
return View["category_form.cshtml"];
};
Post["/categories"] = _ => {
var NewCategory = new Category(Request.Form["category-name"]);
var AllCategories = Category.All();
return View["categories.cshtml", AllCategories];
};
Get["/categories/{id}"] = parameters => {
Dictionary<string, object> model = new Dictionary<string, object>();
var SelectedCategory = Category.Find(parameters.id);
var CategoryTasks = SelectedCategory.GetTasks();
model.Add("category", SelectedCategory);
model.Add("tasks", CategoryTasks);
return View["/category.cshtml", model];
};
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"] = _ => {
Dictionary<string, object> model = new Dictionary<string, object>();
Category SelectedCategory = Category.Find(Request.Form["category-id"]);
List<Task> CategoryTasks = SelectedCategory.GetTasks();
string TaskDescription = Request.Form["task-description"];
Task NewTask = new Task(TaskDescription);
CategoryTasks.Add(NewTask);
model.Add("tasks", CategoryTasks);
model.Add("category", SelectedCategory);
return View["/category.cshtml", model];
};
}
开发者ID:jmk22，项目名称:nancy_todolist_categories_complexobjectsinobjects，代码行数:58，代码来源:HomeModule.cs
示例5: T2_Equal_ReturnsTrueForSameName
public void T2_Equal_ReturnsTrueForSameName()
{
// Arrange, act
Category firstCategory = new Category("Household chores");
Category secondCategory = new Category("Household chores");
// Assert
Assert.Equal(firstCategory, secondCategory);
}
开发者ID:Rick1970，项目名称:todo-with-join-statement，代码行数:9，代码来源:CategoryTest.cs
示例6: Test_CategoryEqualOverrideTrueForSameName
public void Test_CategoryEqualOverrideTrueForSameName()
{
//Arrange, Act
Category firstCategory = new Category("Household chores");
Category secondCategory = new Category("Household chores");
//Assert
Assert.Equal(firstCategory, secondCategory);
}
开发者ID:jmk22，项目名称:todo_categories_databases_CRUD，代码行数:9，代码来源:CategoryTest.cs
示例7: LinkButtonSaveCategory_Click
protected void LinkButtonSaveCategory_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
ToDoListEntities context = new ToDoListEntities();
Category Category = new Category();
Category.Name = this.TextBoxCategoryName.Text;
context.Categories.Add(Category);
context.SaveChanges();
Response.Redirect("~/ManageCategories.aspx");
}
}
开发者ID:nkolarov，项目名称:telerik-academy，代码行数:12，代码来源:ManageCategories.aspx.cs
示例8: 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
示例9: T3_Save_SavesCategoryToDatabase
public void T3_Save_SavesCategoryToDatabase()
{
// Arrange
Category testCategory = new Category("Household chores");
testCategory.Save();
// Act
List<Category> result = Category.GetAll();
List<Category> testList = new List<Category>{testCategory};
// Assert
Assert.Equal(testList, result);
}
开发者ID:Rick1970，项目名称:todo-with-join-statement，代码行数:13，代码来源:CategoryTest.cs
示例10: HomeModule
public HomeModule()
{
//Index
Get["/"] = _ => {
List<Category> AllCategories = Category.GetAll();
return View["index.cshtml", AllCategories];
};
//Get: Lists
Get["/tasks"] = _ => {
List<Task> AllTasks = Task.GetAll();
return View["tasks.cshtml", AllTasks];
};
Get["/categories"] = _ => {
List<Category> AllCategories = Category.GetAll();
return View["categories.cshtml", AllCategories];
};
Get["/categories/new"] = _ => {
return View["categories_form.cshtml"];
};
Post["/categories/new"] = _ => {
Category newCategory = new Category(Request.Form["category-name"]);
newCategory.Save();
return View["success.cshtml"];
};
Get["/tasks/new"] = _ => {
List<Category> AllCategories = Category.GetAll();
return View["tasks_form.cshtml", AllCategories];
};
Post["/tasks/new"] = _ => {
Task newTask = new Task(Request.Form["task-description"], Request.Form["category-id"]);
newTask.Save();
return View["success.cshtml"];
};
Post["/tasks/delete"] = _ => {
Task.DeleteAll();
return View["cleared.cshtml"];
};
Get["categories/{id}"] = parameters => {
Dictionary<string, object> model = new Dictionary<string, object>();
var SelectedCategory = Category.Find(parameters.id);
var CategoryTasks = SelectedCategory.GetTasks();
model.Add("category", SelectedCategory);
model.Add("tasks", CategoryTasks);
return View["/category.cshtml", model];
};
}
开发者ID:jtf86，项目名称:todo_rzor_databases_12m，代码行数:51，代码来源:HomeModule.cs
示例11: 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
示例12: Test_GetTasks_RetrievesAllTasksWithCategory
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);
}
开发者ID:jmk22，项目名称:todo_categories_databases_CRUD，代码行数:16，代码来源:CategoryTest.cs
示例13: Test_AddCategory_AddsCategoryToTask
public void Test_AddCategory_AddsCategoryToTask()
{
//Arrange
Task testTask = new Task("Mow the lawn", new DateTime(2016, 2, 2), false);
testTask.Save();
Category testCategory = new Category("Home stuff");
testCategory.Save();
//Act
testTask.AddCategory(testCategory);
List<Category> result = testTask.GetCategories();
List<Category> testList = new List<Category>{testCategory};
//Assert
Assert.Equal(testList, result);
}
开发者ID:nlarion，项目名称:ToDoCsharp，代码行数:18，代码来源:TaskTest.cs
示例14: Test18_GetCategories_ReturnsAllTaskCategories
public void Test18_GetCategories_ReturnsAllTaskCategories()
{
DateTime testTime = new DateTime(2016, 1, 1);
Task testTask = new Task("Mow the lawn",testTime);
testTask.Save();
Category testCategory1 = new Category("Home Stuff");
testCategory1.Save();
Category testCategory2 = new Category("Work Stuff");
testCategory2.Save();
testTask.AddCategory(testCategory1);
List<Category> result = testTask.GetCategories();
List<Category> testList= new List<Category>{testCategory1};
Assert.Equal(testList,result);
}
开发者ID:Rick1970，项目名称:todo-with-join-statement，代码行数:19，代码来源:TaskTest.cs
示例15: Test_Delete_DeletesCategoryAssociationsFromDatabase
public void Test_Delete_DeletesCategoryAssociationsFromDatabase()
{
//Arrange
Task testTask = new Task("Mow the lawn", false);
testTask.Save();
string testName = "Home stuff";
Category testCategory = new Category(testName);
testCategory.Save();
//Act
testCategory.AddTask(testTask);
testCategory.Delete();
List<Category> resultTaskCategories = testTask.GetCategories();
List<Category> testTaskCategories = new List<Category> {};
//Assert
Assert.Equal(testTaskCategories, resultTaskCategories);
}
开发者ID:Rouz1130，项目名称:todo_manyTomany，代码行数:20，代码来源:CategoryTest.cs
示例16: Test_Delete_DeletesTaskAssociationsFromDatabase
public void Test_Delete_DeletesTaskAssociationsFromDatabase()
{
//Arrange
Category testCategory = new Category("Home stuff");
testCategory.Save();
string testDescription = "Mow the lawn";
Task testTask = new Task(testDescription, new DateTime(2016, 2, 2));
testTask.Save();
//Act
testTask.AddCategory(testCategory);
testTask.Delete();
List<Task> resultCategoryTasks = testCategory.GetTasks();
List<Task> testCategoryTasks = new List<Task> {};
//Assert
Assert.Equal(testCategoryTasks, resultCategoryTasks);
}
开发者ID:nlarion，项目名称:ToDoCsharp，代码行数:20，代码来源:TaskTest.cs
示例17: Test_AddTask_AddsTaskToCategory
public void Test_AddTask_AddsTaskToCategory()
{
//Arrange
Category testCategory = new Category("Household chores");
testCategory.Save();
Task testTask = new Task("Mow the lawn", false);
testTask.Save();
Task testTask2 = new Task("Water the garden", false);
testTask2.Save();
//Act
testCategory.AddTask(testTask);
testCategory.AddTask(testTask2);
List<Task> result = testCategory.GetTasks();
List<Task> testList = new List<Task>{testTask, testTask2};
//Assert
Assert.Equal(testList, result);
}
开发者ID:Rouz1130，项目名称:todo_manyTomany，代码行数:22，代码来源:CategoryTest.cs
示例18: Test_GetCategories_ReturnsAllTaskCategories
public void Test_GetCategories_ReturnsAllTaskCategories()
{
//Arrange
Task testTask = new Task("Mow the lawn");
testTask.Save();
Category testCategory1 = new Category("Home stuff");
testCategory1.Save();
Category testCategory2 = new Category("Work stuff");
testCategory2.Save();
//Act
testTask.AddCategory(testCategory1);
List<Category> result = testTask.GetCategories();
List<Category> testList = new List<Category> {testCategory1};
//Assert
Assert.Equal(testList, result);
}
开发者ID:jtf86，项目名称:Final-Nancy-ToDo，代码行数:20，代码来源:TaskTest.cs
示例19: Test_Delete_DeletesTaskFromDatabase
public void Test_Delete_DeletesTaskFromDatabase()
{
//Arrange
Category testCategory = new Category("Home stuff");
testCategory.Save();
string description1 = "Mow the lawn";
Task testTask1 = new Task(description1);
testTask1.Save();
string description2 = "Do homework";
Task testTask2 = new Task(description2);
testTask2.Save();
//Act
testTask1.AddCategory(testCategory);
testTask1.Delete();
List<Task> resultTasks = Task.GetAll();
List<Task> testTaskList = new List<Task> {testTask2};
List<Task> resultCategoryTasks = testCategory.GetTasks();
List<Task> testCategoryTasks = new List<Task> {};
//Assert
Assert.Equal(testTaskList, resultTasks);
Assert.Equal(testCategoryTasks, resultCategoryTasks);
}
开发者ID:jtf86，项目名称:Final-Nancy-ToDo，代码行数:28，代码来源:TaskTest.cs
示例20: T7_Update_UpdatesCategoryInDatabase
public void T7_Update_UpdatesCategoryInDatabase()
{
//Arrange
string name = "Home Chores";
Category testCategory = new Category(name);
testCategory.Save();
string newName = "Work Chores";
//Act
testCategory.Update(newName);
string result = testCategory.GetName();
//Assert
Assert.Equal(newName, result);
}
开发者ID:Rick1970，项目名称:todo-with-join-statement，代码行数:16，代码来源:CategoryTest.cs
注：本文中的ToDoList.Category类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论