public async void TestDeleteTask() { DbContextOptions <PADbcontext> options = new DbContextOptionsBuilder <PADbcontext>().UseInMemoryDatabase("DeleteTask").Options; using (PADbcontext context = new PADbcontext(options)) { DateTime testTime25 = new DateTime(2019, 3, 4, 11, 0, 0); DateTime testTime26 = new DateTime(2019, 3, 5, 11, 0, 0); DateTime testTime27 = new DateTime(2019, 3, 6, 11, 0, 0); Tasks testTask20 = new Tasks(); testTask20.ID = 1; testTask20.ListID = 1; testTask20.TaskName = "aTask"; testTask20.Description = "aDescription"; testTask20.DateCreated = testTime25; testTask20.PlannedDateComplete = testTime26; testTask20.CompletedDate = testTime27; testTask20.IsComplete = false; TasksManagementServices TaskService = new TasksManagementServices(context); await TaskService.CreateTask(testTask20); await TaskService.DeleteTask(testTask20.ID); var expected4 = context.TasksTable.FirstOrDefault(c => c.ID == testTask20.ID); Assert.Null(expected4); } }
public async void TestGetOneTask() { DbContextOptions <PADbcontext> options = new DbContextOptionsBuilder <PADbcontext>().UseInMemoryDatabase("GetOneTask").Options; using (PADbcontext context = new PADbcontext(options)) { DateTime testTime13 = new DateTime(2019, 3, 4, 11, 0, 0); DateTime testTime14 = new DateTime(2019, 3, 5, 11, 0, 0); DateTime testTime15 = new DateTime(2019, 3, 6, 11, 0, 0); Tasks testTask16 = new Tasks(); testTask16.ID = 1; testTask16.ListID = 1; testTask16.TaskName = "aTask"; testTask16.Description = "aDescription"; testTask16.DateCreated = testTime13; testTask16.PlannedDateComplete = testTime14; testTask16.CompletedDate = testTime15; testTask16.IsComplete = false; TasksManagementServices TaskService = new TasksManagementServices(context); await TaskService.CreateTask(testTask16); var Task2Answer = await TaskService.GetOneTask(testTask16.ListID); Assert.Equal(testTask16, Task2Answer); } }
public async void TestUpdateTask() { DbContextOptions <PADbcontext> options = new DbContextOptionsBuilder <PADbcontext>().UseInMemoryDatabase("UpdateTask").Options; using (PADbcontext context = new PADbcontext(options)) { DateTime testTime22 = new DateTime(2019, 3, 4, 11, 0, 0); DateTime testTime23 = new DateTime(2019, 3, 5, 11, 0, 0); DateTime testTime24 = new DateTime(2019, 3, 6, 11, 0, 0); Tasks testTask19 = new Tasks(); testTask19.ID = 1; testTask19.ListID = 1; testTask19.TaskName = "aTask"; testTask19.Description = "aDescription"; testTask19.DateCreated = testTime22; testTask19.PlannedDateComplete = testTime23; testTask19.CompletedDate = testTime24; testTask19.IsComplete = false; TasksManagementServices TaskService = new TasksManagementServices(context); await TaskService.CreateTask(testTask19); testTask19.IsComplete = true; await TaskService.UpdateTask(testTask19); var expected3 = context.TasksTable.FirstOrDefault(c => c.ID == testTask19.ID); Assert.Equal(testTask19, expected3); } }
public async void TestCreateTask() { DbContextOptions <PADbcontext> options = new DbContextOptionsBuilder <PADbcontext>().UseInMemoryDatabase("CreateTask").Options; using (PADbcontext context = new PADbcontext(options)) { DateTime testTime10 = new DateTime(2019, 3, 1, 11, 0, 0); DateTime testTime11 = new DateTime(2019, 3, 2, 11, 0, 0); DateTime testTime12 = new DateTime(2019, 3, 3, 11, 0, 0); Tasks testTask15 = new Tasks(); testTask15.ID = 1; testTask15.ListID = 1; testTask15.TaskName = "aTask"; testTask15.Description = "aDescription"; testTask15.DateCreated = testTime10; testTask15.PlannedDateComplete = testTime11; testTask15.CompletedDate = testTime12; testTask15.IsComplete = false; TasksManagementServices TaskService = new TasksManagementServices(context); await TaskService.CreateTask(testTask15); var Task1Answer = context.TasksTable.FirstOrDefault(c => c.ID == testTask15.ID); Assert.Equal(testTask15, Task1Answer); } }
public async void TestGetAllLists() { DbContextOptions <PADbcontext> options = new DbContextOptionsBuilder <PADbcontext>().UseInMemoryDatabase("GetAllLists").Options; using (PADbcontext context = new PADbcontext(options)) { Lists testLists7 = new Lists(); testLists7.ID = 1; testLists7.UserID = "aUserName"; testLists7.ListName = "ToDoList"; Lists testLists8 = new Lists(); testLists8.ID = 2; testLists8.UserID = "aDiffUserName"; testLists8.ListName = "DiffToDoList"; ListsManagementServices ListService = new ListsManagementServices(context); await ListService.CreateList(testLists7); await ListService.CreateList(testLists8); var List3Answer = await ListService.GetAllLists(); Assert.Equal(2, List3Answer.Count); } }
public async void TestGetAllTasks() { DbContextOptions <PADbcontext> options = new DbContextOptionsBuilder <PADbcontext>().UseInMemoryDatabase("GetAllTask").Options; using (PADbcontext context = new PADbcontext(options)) { DateTime testTime16 = new DateTime(2019, 3, 4, 11, 0, 0); DateTime testTime17 = new DateTime(2019, 3, 5, 11, 0, 0); DateTime testTime18 = new DateTime(2019, 3, 6, 11, 0, 0); Tasks testTask17 = new Tasks(); testTask17.ID = 1; testTask17.ListID = 1; testTask17.TaskName = "aTask"; testTask17.Description = "aDescription"; testTask17.DateCreated = testTime16; testTask17.PlannedDateComplete = testTime17; testTask17.CompletedDate = testTime18; testTask17.IsComplete = false; DateTime testTime19 = new DateTime(2019, 3, 4, 11, 0, 0); DateTime testTime20 = new DateTime(2019, 3, 5, 11, 0, 0); DateTime testTime21 = new DateTime(2019, 3, 6, 11, 0, 0); Tasks testTask18 = new Tasks(); testTask18.ID = 2; testTask18.ListID = 1; testTask18.TaskName = "aDiffTask"; testTask18.Description = "aDiffDescription"; testTask18.DateCreated = testTime19; testTask18.PlannedDateComplete = testTime20; testTask18.CompletedDate = testTime21; testTask18.IsComplete = false; TasksManagementServices TaskService = new TasksManagementServices(context); await TaskService.CreateTask(testTask17); await TaskService.CreateTask(testTask18); var Task3Answer = await TaskService.GetAllTasksForAList(1); Assert.Equal(2, Task3Answer.Count); } }
public async void TestGetOneListID() { DbContextOptions <PADbcontext> options = new DbContextOptionsBuilder <PADbcontext>().UseInMemoryDatabase("GetOneList").Options; using (PADbcontext context = new PADbcontext(options)) { Lists testLists6 = new Lists(); testLists6.ID = 1; testLists6.UserID = "aUserName"; testLists6.ListName = "ToDoList"; ListsManagementServices ListService = new ListsManagementServices(context); await ListService.CreateList(testLists6); var List2Answer = await ListService.GetOneListId(testLists6.UserID); Assert.Equal(testLists6.ID, List2Answer); } }
public async void TestCreateList() { DbContextOptions <PADbcontext> options = new DbContextOptionsBuilder <PADbcontext>().UseInMemoryDatabase("CreateList").Options; using (PADbcontext context = new PADbcontext(options)) { Lists testLists5 = new Lists(); testLists5.ID = 1; testLists5.UserID = "aUserName"; testLists5.ListName = "ToDoList"; ListsManagementServices ListService = new ListsManagementServices(context); await ListService.CreateList(testLists5); var List1Answer = context.ListsTable.FirstOrDefault(c => c.ID == testLists5.ID); Assert.Equal(testLists5, List1Answer); } }
public async void TestDeleteList() { DbContextOptions <PADbcontext> options = new DbContextOptionsBuilder <PADbcontext>().UseInMemoryDatabase("DeleteList").Options; using (PADbcontext context = new PADbcontext(options)) { Lists testLists10 = new Lists(); testLists10.ID = 1; testLists10.UserID = "aUserName"; testLists10.ListName = "ToDoList"; ListsManagementServices ListService = new ListsManagementServices(context); await ListService.CreateList(testLists10); await ListService.DeleteList(testLists10.ID); var expected2 = context.ListsTable.FirstOrDefault(c => c.ID == testLists10.ID); Assert.Null(expected2); } }
public async void TestUpdateList() { DbContextOptions <PADbcontext> options = new DbContextOptionsBuilder <PADbcontext>().UseInMemoryDatabase("UpdateList").Options; using (PADbcontext context = new PADbcontext(options)) { Lists testLists9 = new Lists(); testLists9.ID = 1; testLists9.UserID = "aUserName"; testLists9.ListName = "ToDoList"; ListsManagementServices ListService = new ListsManagementServices(context); await ListService.CreateList(testLists9); testLists9.ListName = "aDiffToDoList"; await ListService.UpdateList(testLists9); var expected1 = context.ListsTable.FirstOrDefault(c => c.ID == testLists9.ID); Assert.Equal(testLists9, expected1); } }
/// <summary> /// makes a connectiong to the database /// </summary> /// <param name="context">the databade</param> public TasksManagementServices(PADbcontext context) { _context = context; }
/// <summary> /// makes a connection to the PA database /// </summary> /// <param name="context">the PA database</param> public ListsManagementServices(PADbcontext context) { _context = context; }