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;
}
