public void DeleteUserItemDALTest()
{
// Arrange
DbContextOptions <ToDoAppContext> options = new DbContextOptionsBuilder <ToDoAppContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.EnableSensitiveDataLogging()
.Options;
using (var context = new ToDoAppContext(options))
{
context.Database.EnsureDeleted();
}
ToDoEFDAL testDAL = new ToDoEFDAL(options);
UserItem testUserItem = new UserItem()
{
FirstName = "TestFN",
LastName = "TestLN",
Username = "******",
Email = "*****@*****.**",
RoleId = "Customer",
};
testUserItem.Id = testDAL.AddUserItem(testUserItem);
testDAL.DeleteUserItem(testUserItem.Id);
//Act
UserItem returnedTestUser = testDAL.GetUserItem(testUserItem.Id);
// Assert
Assert.IsNull(returnedTestUser);
}
public void UpdateUserItemDALTest()
{
// Arrange
DbContextOptions <ToDoAppContext> options = new DbContextOptionsBuilder <ToDoAppContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.EnableSensitiveDataLogging()
.Options;
using (var context = new ToDoAppContext(options))
{
context.Database.EnsureDeleted();
}
ToDoEFDAL testDAL = new ToDoEFDAL(options);
UserItem testUserItem = new UserItem()
{
FirstName = "TestFN",
LastName = "TestLN",
Username = "******",
Email = "*****@*****.**",
RoleId = "Customer",
};
testUserItem.Id = testDAL.AddUserItem(testUserItem);
UserItem updatedTestUserItem = new UserItem()
{
FirstName = "FNTest",
LastName = "LNTest",
Username = "******",
Email = "*****@*****.**",
RoleId = "Administrator",
Id = testUserItem.Id
};
testDAL.UpdateUserItem(updatedTestUserItem);
//Act
UserItem returnedTestUser = testDAL.GetUserItem(updatedTestUserItem.Id);
// Assert
Assert.AreEqual(updatedTestUserItem.FirstName, returnedTestUser.FirstName);
Assert.AreEqual(updatedTestUserItem.LastName, returnedTestUser.LastName);
Assert.AreEqual(updatedTestUserItem.Username, returnedTestUser.Username);
Assert.AreEqual(updatedTestUserItem.Email, returnedTestUser.Email);
Assert.AreEqual(updatedTestUserItem.RoleId, returnedTestUser.RoleId);
Assert.AreEqual(updatedTestUserItem.Id, returnedTestUser.Id);
}
public void AddToDoListItemDALTest()
{
// Arrange
DbContextOptions <ToDoAppContext> options = new DbContextOptionsBuilder <ToDoAppContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.EnableSensitiveDataLogging()
.Options;
using (var context = new ToDoAppContext(options))
{
context.Database.EnsureDeleted();
}
ToDoEFDAL testDAL = new ToDoEFDAL(options);
ToDoListItem testToDoListItem = new ToDoListItem()
{
Name = "TestName",
Description = "TestDescription",
Category = "TestCategory",
UserItemId = 1,
TimeCreated = DateTime.Now
};
//Act
testDAL.AddToDoList(testToDoListItem, testToDoListItem.UserItemId);
// Assert
using (var context = new ToDoAppContext(options))
{
Assert.AreEqual(testToDoListItem.Name, context.ToDoListItem.First().Name);
Assert.AreEqual(testToDoListItem.Description, context.ToDoListItem.First().Description);
Assert.AreEqual(testToDoListItem.Category, context.ToDoListItem.First().Category);
Assert.AreEqual(testToDoListItem.TimeCreated.ToString(), context.ToDoListItem.First().TimeCreated.ToString());
Assert.AreEqual(testToDoListItem.UserItemId, context.ToDoListItem.First().UserItemId);
};
}
public void AddUserItemDALTest()
{
// Arrange
DbContextOptions <ToDoAppContext> options = new DbContextOptionsBuilder <ToDoAppContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.EnableSensitiveDataLogging()
.Options;
using (var context = new ToDoAppContext(options))
{
context.Database.EnsureDeleted();
}
ToDoEFDAL testDAL = new ToDoEFDAL(options);
UserItem testUserItem = new UserItem()
{
FirstName = "TestFN",
LastName = "TestLN",
Username = "******",
Email = "*****@*****.**",
RoleId = "Customer",
};
//Act
testDAL.AddUserItem(testUserItem);
// Assert
using (var context = new ToDoAppContext(options))
{
Assert.AreEqual("TestFN", context.UserItem.First().FirstName);
Assert.AreEqual("TestLN", context.UserItem.First().LastName);
Assert.AreEqual("TestUser", context.UserItem.First().Username);
Assert.AreEqual("*****@*****.**", context.UserItem.First().Email);
Assert.AreEqual("Customer", context.UserItem.First().RoleId);
};
}
public void DeleteToDoListItemDALTest()
{
// Arrange
DbContextOptions <ToDoAppContext> options = new DbContextOptionsBuilder <ToDoAppContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.EnableSensitiveDataLogging()
.Options;
using (var context = new ToDoAppContext(options))
{
context.Database.EnsureDeleted();
}
ToDoEFDAL testDAL = new ToDoEFDAL(options);
ToDoListItem testToDoListItem = new ToDoListItem()
{
Name = "TestName",
Description = "TestDescription",
Category = "TestCategory",
UserItemId = 1,
TimeCreated = DateTime.Now
};
//Act
testToDoListItem.Id = testDAL.AddToDoList(testToDoListItem, testToDoListItem.UserItemId);
testDAL.DeleteToDoList(testToDoListItem);
ToDoListItem returnedTestToDoList = testDAL.GetToDoListItem(testToDoListItem.Id);
// Assert
Assert.IsNull(returnedTestToDoList);
}