public ITeamMemberModel Update(ITeamMemberModel model) { // Validate model BusinessWorkflowBase.ValidateRequiredNullableID(model.Id); //BusinessWorkflowBase.ValidateRequiredString(model.Name, nameof(model.Name)); // Find existing entity // ReSharper disable once PossibleInvalidOperationException var existingEntity = TeamMembersRepository.Get(model.Id.Value); // Check if we would be applying identical information, if we are, just return the original // ReSharper disable once SuspiciousTypeConversion.Global if (TeamMemberMapper.AreEqual(model, existingEntity)) { return(TeamMemberMapper.MapToModel(existingEntity)); } // Map model to an existing entity TeamMemberMapper.MapToEntity(model, ref existingEntity); existingEntity.UpdatedDate = BusinessWorkflowBase.GenDateTime; // Update it TeamMembersRepository.Update(TeamMemberMapper.MapToEntity(model)); // Try to Save Changes TeamMembersRepository.SaveChanges(); // Return the new value return(Get(existingEntity.Id)); }
private TeamMember GetMemberInfo(int teamMemberId) { try { using (SqlConnection sqlConnection = new SqlConnection(CONNECTION_DATA_STRING)) using (SqlCommand sqlCommand = new SqlCommand()) { sqlCommand.Connection = sqlConnection; sqlCommand.CommandText = GET_MEMBER_INFO; sqlCommand.Parameters.Add("@idmember", SqlDbType.Int, 6); sqlCommand.Parameters["@idmember"].Value = teamMemberId; sqlConnection.Open(); SqlDataReader reader = sqlCommand.ExecuteReader(); while (reader.Read()) { return(TeamMemberMapper.MapToTeamMember(reader)); } reader.Close(); } } catch (Exception e) { Console.WriteLine(e.Message); } return(null); }
public ITeamMemberModel Create(ITeamMemberModel model) { // Validate model BusinessWorkflowBase.ValidateIDIsNull(model.Id); //BusinessWorkflowBase.ValidateRequiredString(model.Name, nameof(model.Name)); // Search for an Existing Record (Don't allow Duplicates var results = Search(TeamMemberMapper.MapToSearchModel(model)); if (results.Any()) { return(results.First()); } // Return the first that matches // Map model to a new entity var newEntity = TeamMemberMapper.MapToEntity(model); newEntity.CreatedDate = BusinessWorkflowBase.GenDateTime; newEntity.UpdatedDate = null; newEntity.Active = true; // Add it TeamMembersRepository.Add(newEntity); // Try to Save Changes TeamMembersRepository.SaveChanges(); // Return the new value return(Get(newEntity.Id)); }
public void Verify_AreEqual_WithDifferentObjects_ReturnsFalse() { // Arrange var mapper = new TeamMemberMapper(); var model = TeamMembersMockingSetup.DoMockingSetupForTeamMemberModel(1); var entity = TeamMembersMockingSetup.DoMockingSetupForTeamMember(2); // Act var result = mapper.AreEqual(model.Object, entity.Object); // Assert Assert.False(result); }
public void Verify_MapToModelLite_AssignsLiteOnlyTeamMemberProperties() { // Arrange var mapper = new TeamMemberMapper(); var entity = TeamMembersMockingSetup.DoMockingSetupForTeamMember(); // Act var model = mapper.MapToModelLite(entity.Object); // Assert // <None> // Related Objects Assert.Equal(entity.Object.TeamId, model.TeamId); Assert.Equal(entity.Object.CharacterId, model.CharacterId); }
public void Verify_MapToEntity_AssignsTeamMemberProperties() { // Arrange var mapper = new TeamMemberMapper(); var model = TeamMembersMockingSetup.DoMockingSetupForTeamMemberModel(); // Act var entity = mapper.MapToEntity(model.Object); // Assert // <None> // Related Objects Assert.Equal(model.Object.TeamId, entity.TeamId); Assert.Equal(model.Object.CharacterId, entity.CharacterId); // Associated Objects // <None> }
public void Verify_MapToSearchModel_AssignsTeamMemberSearchProperties() { // Arrange var mapper = new TeamMemberMapper(); var model = TeamMembersMockingSetup.DoMockingSetupForTeamMemberModel(); // Act var searchModel = mapper.MapToSearchModel(model.Object); // Assert Assert.Equal(model.Object.TeamId, searchModel.TeamId); Assert.Equal(model.Object.Team?.CustomKey, searchModel.TeamCustomKey); Assert.Equal(model.Object.Team?.ApiDetailUrl, searchModel.TeamApiDetailUrl); Assert.Equal(model.Object.Team?.SiteDetailUrl, searchModel.TeamSiteDetailUrl); Assert.Equal(model.Object.Team?.Name, searchModel.TeamName); Assert.Equal(model.Object.Team?.ShortDescription, searchModel.TeamShortDescription); Assert.Equal(model.Object.Team?.Description, searchModel.TeamDescription); Assert.Equal(model.Object.CharacterId, searchModel.CharacterId); Assert.Equal(model.Object.Character?.CustomKey, searchModel.CharacterCustomKey); Assert.Equal(model.Object.Character?.ApiDetailUrl, searchModel.CharacterApiDetailUrl); Assert.Equal(model.Object.Character?.SiteDetailUrl, searchModel.CharacterSiteDetailUrl); Assert.Equal(model.Object.Character?.Name, searchModel.CharacterName); Assert.Equal(model.Object.Character?.ShortDescription, searchModel.CharacterShortDescription); Assert.Equal(model.Object.Character?.Description, searchModel.CharacterDescription); }
public void Verify_MapToModel_AssignsTeamMemberProperties() { // Arrange var mapper = new TeamMemberMapper(); var entity = TeamMembersMockingSetup.DoMockingSetupForTeamMember(); // Act var model = mapper.MapToModel(entity.Object); // Assert // <None> // Related Objects Assert.Equal(entity.Object.TeamId, model.TeamId); Assert.Equal(entity.Object.CharacterId, model.CharacterId); // Associated Objects // <None> }
public void Verify_MapToEntity_WithExistingEntity_AssignsTeamMemberProperties() { // Arrange var mapper = new TeamMemberMapper(); var model = TeamMembersMockingSetup.DoMockingSetupForTeamMemberModel(); // Act ITeamMember existingEntity = new TeamMember { Id = 1 }; mapper.MapToEntity(model.Object, ref existingEntity); // Assert // <None> // Related Objects Assert.Equal(model.Object.TeamId, existingEntity.TeamId); Assert.Equal(model.Object.CharacterId, existingEntity.CharacterId); // Associated Objects // <None> }
public void Verify_AreEqual_WithEqualObjects_ReturnsTrue() { // Arrange var mapper = new TeamMemberMapper(); var model = TeamMembersMockingSetup.DoMockingSetupForTeamMemberModel(1); var entity = TeamMembersMockingSetup.DoMockingSetupForTeamMember(1); // Act var result = mapper.AreEqual(model.Object, entity.Object); // Assert Assert.True(result); }
public ITeamMemberModel Get(string key) { BusinessWorkflowBase.ValidateRequiredKey(key); return(TeamMemberMapper.MapToModel(TeamMembersRepository.Get(key))); }
public ITeamMemberModel Get(int id) { BusinessWorkflowBase.ValidateRequiredID(id); return(TeamMemberMapper.MapToModel(TeamMembersRepository.Get(id))); }