public IActionResult addUser([FromBody] User _user)
{
string JsonData;
string id = _user.UserId;
User checkUser = _context.User.Find(_user.UserId);
if (checkUser == null)
{
_context.User.Add(_user);
_context.SaveChanges();
var JsonResult = new
{
result = "Success"
};
JsonData = JsonConvert.SerializeObject(JsonResult);
return(Ok(JsonData));
}
else
{
var JsonResult = new
{
result = "Failed"
};
JsonData = JsonConvert.SerializeObject(JsonResult);
return(Ok(JsonData));
}
}
public void Update_UpdatesUser_UserIsUpdated()
{
//Arrange
DbContextOptions <TestDatabaseContext> options = new DbContextOptionsBuilder <TestDatabaseContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
TestDatabaseContext context = new TestDatabaseContext(options);
context.Users.Add(new User()
{
FirstName = "Jan",
LastName = "Kowalski",
});
context.SaveChanges();
UserLogic userLogic = new UserLogic(context);
//Act
User user = userLogic.Read(1);
user.FirstName = "Janusz";
userLogic.Update(user);
//Assert
userLogic.Read(1).FirstName.Should().Be("Janusz");
}
public void Create_CreatesUser_UserIsCreated()
{
//Arrange
DbContextOptions <TestDatabaseContext> options = new DbContextOptionsBuilder <TestDatabaseContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
TestDatabaseContext context = new TestDatabaseContext(options);
UserLogic userLogic = new UserLogic(context);
User user1 = new User()
{
FirstName = "Jan",
LastName = "Kowalski",
};
User user2 = new User()
{
FirstName = "John",
LastName = "Smith",
};
//Act
userLogic.Create(user1);
userLogic.Create(user2);
context.SaveChanges();
//Assert
context.Users.Where(user => user.ID == 1).First().Should().Be(user1);
context.Users.Where(user => user.ID == 2).First().Should().Be(user2);
}
public void Read_ReadsUser_UserIsLoaded()
{
//Arrange
DbContextOptions <TestDatabaseContext> options = new DbContextOptionsBuilder <TestDatabaseContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
TestDatabaseContext context = new TestDatabaseContext(options);
UserLogic userLogic = new UserLogic(context);
User user1 = new User()
{
FirstName = "Jan",
LastName = "Kowalski",
};
User user2 = new User()
{
FirstName = "John",
LastName = "Smith",
};
context.Users.AddRange(user1, user2);
context.SaveChanges();
//Act, Assert
userLogic.Read(1).Should().Be(user1);
userLogic.Read(2).Should().Be(user2);
}
public void DeleteUser_OnNonExistingUser_DoesNothing()
{
// ARRANGE
DbContextOptions <TestDatabaseContext> options = new DbContextOptionsBuilder <TestDatabaseContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
IDatabaseContext dbContext = new TestDatabaseContext(options);
UserRepository repository = new UserRepository(dbContext);
User user = new User()
{
FirstName = "Jan",
LastName = "Kowalski",
OAuthID = "12345"
};
dbContext.Users.Add(user);
dbContext.SaveChanges();
// ACT
repository.DeleteUser(22);
// ASSERT
dbContext.Users.Count().Should().Be(1);
}
public void GetUserOAuth_OnExistingUser_ReturnsUser()
{
// ARRANGE
DbContextOptions <TestDatabaseContext> options = new DbContextOptionsBuilder <TestDatabaseContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
IDatabaseContext dbContext = new TestDatabaseContext(options);
UserRepository repository = new UserRepository(dbContext);
User user = new User()
{
FirstName = "Jan",
LastName = "Kowalski",
OAuthID = "12345"
};
dbContext.Users.Add(user);
dbContext.SaveChanges();
// ACT
UserPublic userPublic = repository.GetUserOAuth("12345");
// ASSERT
userPublic.Should().BeEquivalentTo(new UserPublic()
{
ID = 1,
FirstName = "Jan",
LastName = "Kowalski",
OAuthID = "12345"
});
}
public void Convert_ConvertsExistingServiceModelToEntity_ReturnsConvertedEntity()
{
// ARRANGE
DbContextOptions <TestDatabaseContext> options = new DbContextOptionsBuilder <TestDatabaseContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
IDatabaseContext dbContext = new TestDatabaseContext(options);
User user = new User()
{
ID = 1,
FirstName = "Johhny",
LastName = "Test",
OAuthID = "12345"
};
dbContext.Users.Add(user);
dbContext.SaveChanges();
UserConverter converter = new UserConverter(dbContext);
UserPublic userPublic = new UserPublic()
{
ID = 1,
FirstName = "Johhny",
LastName = "Test",
OAuthID = "12345"
};
// ACT
User user2 = converter.Convert(userPublic);
// ASSERT
user2.Should().BeEquivalentTo <User>(user);
}
public void GetWorkItem_OnValidRequest_ReturnsWorkItem()
{
// ARRANGE
DbContextOptions <TestDatabaseContext> options = new DbContextOptionsBuilder <TestDatabaseContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
IDatabaseContext dbContext = new TestDatabaseContext(options);
WorkItemRepository repository = new WorkItemRepository(dbContext);
WorkItemConverter converter = new WorkItemConverter(dbContext);
WorkItem workItem = new WorkItem()
{
Description = Guid.NewGuid().ToString(),
Name = Guid.NewGuid().ToString(),
WorkItemEnd = DateTime.Now,
WorkItemStart = DateTime.Now,
WorkItemCollectionId = 1
};
dbContext.WorkItems.Add(workItem);
dbContext.SaveChanges();
// ACT
WorkItemPublic result = repository.GetWorkItem(1);
// ASSERT
result.Should().BeEquivalentTo <WorkItemPublic>(converter.Convert(workItem));
}
public void CreateWorkItem_OnWalidWorkItem_CreatesEntryInDB()
{
// ARRANGE
DbContextOptions <TestDatabaseContext> options = new DbContextOptionsBuilder <TestDatabaseContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
IDatabaseContext context = new TestDatabaseContext(options);
WorkItemLogic logic = new WorkItemLogic(context);
WorkItem request = new WorkItem()
{
Name = Guid.NewGuid().ToString(),
Color = Guid.NewGuid().ToString(),
Description = Guid.NewGuid().ToString(),
WorkItemCollectionId = 1,
WorkItemStart = DateTime.Now.AddDays(-1),
WorkItemEnd = DateTime.Now
};
context.WorkItemCollections.Add(new WorkItemCollection()
{
ID = 1,
TaskBoardId = 1
});
context.TaskBoards.Add(new TaskBoard()
{
ID = 1,
UserID = 1
});
context.Users.Add(new User()
{
ID = 1
});
context.SaveChanges();
// ACT
WorkItem result = logic.CreateWorkItem(request);
context.SaveChanges();
request.ID = result.ID;
// ASSERT
result.Should().BeEquivalentTo <WorkItem>(request);
}
public ActionResult Create([Bind(Include = "TodoTitle,DueDate,Priority")] Todo todo)
{
if (ModelState.IsValid)
{
db.Todoes.Add(todo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(todo));
}
public Customer Save(Customer entity)
{
var customerDb = CustomerMapper.Map(entity);
_testDatabaseContext.Customer.Add(customerDb);
_testDatabaseContext.SaveChanges();
entity = CustomerMapper.Map(customerDb);
return(entity);
}
public void DeleteWorkItem_OnValidRequest_DeletesEntry()
{
// ARRANGE
DbContextOptions <TestDatabaseContext> options = new DbContextOptionsBuilder <TestDatabaseContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
IDatabaseContext context = new TestDatabaseContext(options);
WorkItemLogic logic = new WorkItemLogic(context);
WorkItem request = new WorkItem()
{
ID = 1,
};
context.WorkItems.Add(request);
context.SaveChanges();
// ACT
logic.DeleteWorkItem(1);
context.SaveChanges();
// ASSERT
context.WorkItems.Any(wi => wi.ID == 1).Should().BeFalse();
}
public void UpdateWorkItem_OnValidRequest_UpdatesWorkItem()
{
// ARRANGE
DbContextOptions <TestDatabaseContext> options = new DbContextOptionsBuilder <TestDatabaseContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
IDatabaseContext dbContext = new TestDatabaseContext(options);
WorkItemRepository repository = new WorkItemRepository(dbContext);
WorkItemPublic workItem = new WorkItemPublic()
{
ID = 1,
Description = Guid.NewGuid().ToString(),
Name = Guid.NewGuid().ToString(),
WorkItemEnd = DateTime.Now,
WorkItemStart = DateTime.Now,
WorkItemCollectionID = 1
};
dbContext.WorkItems.Add(new WorkItem()
{
ID = 1
});
dbContext.WorkItemCollections.Add(new WorkItemCollection()
{
ID = 1,
TaskBoardId = 1
});
dbContext.TaskBoards.Add(new TaskBoard()
{
ID = 1,
UserID = 1
});
dbContext.Users.Add(new User()
{
ID = 1
});
dbContext.SaveChanges();
// ACT
WorkItemPublic result = repository.UpdateWorkItem(workItem);
// ASSERT
result.Should().BeEquivalentTo <WorkItemPublic>(workItem);
}
private static void CorrectLength(TestDatabaseContext ctxBabies)
{
ctxBabies.Babies.ToList().ForEach(b =>
{
if (b.Length < 10)
{
b.Length = 10;
}
if (b.Length > 60)
{
b.Length = 60;
}
});
ctxBabies.SaveChanges();
}
public void GetUserTaskBoards_OnRequestingUsersTaskBoard_ReturnsOnlyUsersTaskBoards()
{
// ARRANGE
DbContextOptions <TestDatabaseContext> options = new DbContextOptionsBuilder <TestDatabaseContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
IDatabaseContext dbContext = new TestDatabaseContext(options);
TaskBoardRepository repository = new TaskBoardRepository(dbContext);
User user1 = dbContext.Users.Add(new User()
{
FirstName = Guid.NewGuid().ToString(),
LastName = Guid.NewGuid().ToString()
}).Entity;
User user2 = dbContext.Users.Add(new User()
{
FirstName = Guid.NewGuid().ToString(),
LastName = Guid.NewGuid().ToString()
}).Entity;
dbContext.TaskBoards.Add(new TaskBoard()
{
Name = Guid.NewGuid().ToString(),
User = user1
});
dbContext.TaskBoards.Add(new TaskBoard()
{
Name = Guid.NewGuid().ToString(),
User = user1
});
dbContext.TaskBoards.Add(new TaskBoard()
{
Name = Guid.NewGuid().ToString(),
User = user2
});
dbContext.SaveChanges();
// ACT
IEnumerable <TaskBoardPublic> boards = repository.GetUserTaskBoards(1);
// ASSERT
boards.Should().HaveCount(2);
}
public void CreateWorkItem_OnNonExistingCollection_ThrowsArgumentException()
{
// ARRANGE
DbContextOptions <TestDatabaseContext> options = new DbContextOptionsBuilder <TestDatabaseContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
IDatabaseContext context = new TestDatabaseContext(options);
WorkItemLogic logic = new WorkItemLogic(context);
WorkItem request = new WorkItem()
{
WorkItemCollectionId = 1
};
context.SaveChanges();
// ACT
Action act = () => logic.CreateWorkItem(request);
// ASSERT
act.Should().Throw <ArgumentException>().Where(e => e.Message.Contains("doesn't exist"));
}
public void CreateWorkItem_OnInvalidID_ThrowsArgumentException()
{
// ARRANGE
DbContextOptions <TestDatabaseContext> options = new DbContextOptionsBuilder <TestDatabaseContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
IDatabaseContext context = new TestDatabaseContext(options);
WorkItemLogic logic = new WorkItemLogic(context);
WorkItem request = new WorkItem()
{
ID = 123
};
context.SaveChanges();
// ACT
Action act = () => logic.CreateWorkItem(request);
// ASSERT
act.Should().Throw <ArgumentException>().Where(e => e.Message.Contains("ID can't be set on entity"));
}
public void Convert_ConvertsExistingServiceModelToEntity_ReturnsConvertedEntity()
{
// ARRANGE
DbContextOptions <TestDatabaseContext> options = new DbContextOptionsBuilder <TestDatabaseContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
IDatabaseContext dbContext = new TestDatabaseContext(options);
User user = new User()
{
ID = 1,
FirstName = Guid.NewGuid().ToString(),
LastName = Guid.NewGuid().ToString()
};
dbContext.TaskBoards.Add(new TaskBoard()
{
ID = 1
});
dbContext.Users.Add(user);
dbContext.SaveChanges();
TaskBoardConverter converter = new TaskBoardConverter(dbContext);
TaskBoardPublic taskBoardPublic = new TaskBoardPublic()
{
ID = 1,
Name = "Test",
UserID = 1
};
// ACT
TaskBoard taskBoard = converter.Convert(taskBoardPublic);
// ASSERT
taskBoard.Should().BeEquivalentTo <TaskBoard>(new TaskBoard()
{
ID = 1, Name = "Test", UserID = 1, User = user
});
taskBoard.User.Should().NotBeNull();
}
public void DeleteWorkItem_OnValidRequest_DeletesWorkItem()
{
// ARRANGE
DbContextOptions <TestDatabaseContext> options = new DbContextOptionsBuilder <TestDatabaseContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
IDatabaseContext dbContext = new TestDatabaseContext(options);
WorkItemRepository repository = new WorkItemRepository(dbContext);
dbContext.WorkItems.Add(new WorkItem()
{
ID = 1
});
dbContext.SaveChanges();
// ACT
repository.DeleteWorkItem(1);
// ASSERT
dbContext.WorkItems.Any(wi => wi.ID == 1).Should().BeFalse();
}
public void GetTaskBoard_OnExistingTaskBoard_ReturnsTaskBoard()
{
// ARRANGE
DbContextOptions <TestDatabaseContext> options = new DbContextOptionsBuilder <TestDatabaseContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
IDatabaseContext dbContext = new TestDatabaseContext(options);
TaskBoardRepository repository = new TaskBoardRepository(dbContext);
TaskBoardConverter converter = new TaskBoardConverter(dbContext);
TaskBoard taskBoard = new TaskBoard()
{
Name = Guid.NewGuid().ToString(),
};
dbContext.TaskBoards.Add(taskBoard);
dbContext.SaveChanges();
// ACT
TaskBoardPublic taskBoardPublic = repository.GetTaskBoard(1);
// ASSERT
taskBoardPublic.Should().BeEquivalentTo <TaskBoardPublic>(converter.Convert(taskBoard));
}