private async Task <ApiDatabaseLogResponseModel> CreateRecord()
{
var model = new ApiDatabaseLogRequestModel();
model.SetProperties("B", "B", "B", DateTime.Parse("1/1/1988 12:00:00 AM"), "B", "B", "B");
CreateResponse <ApiDatabaseLogResponseModel> result = await this.Client.DatabaseLogCreateAsync(model);
result.Success.Should().BeTrue();
return(result.Record);
}
public async Task <ValidationResult> ValidateUpdateAsync(int id, ApiDatabaseLogRequestModel model)
{
this.DatabaseUserRules();
this.@EventRules();
this.@ObjectRules();
this.PostTimeRules();
this.SchemaRules();
this.TsqlRules();
this.XmlEventRules();
return(await this.ValidateAsync(model, id));
}
public virtual async Task <IActionResult> Create([FromBody] ApiDatabaseLogRequestModel model)
{
CreateResponse <ApiDatabaseLogResponseModel> result = await this.DatabaseLogService.Create(model);
if (result.Success)
{
return(this.Created($"{this.Settings.ExternalBaseUrl}/api/DatabaseLogs/{result.Record.DatabaseLogID}", result));
}
else
{
return(this.StatusCode(StatusCodes.Status422UnprocessableEntity, result));
}
}
private async Task <ApiDatabaseLogRequestModel> PatchModel(int id, JsonPatchDocument <ApiDatabaseLogRequestModel> patch)
{
var record = await this.DatabaseLogService.Get(id);
if (record == null)
{
return(null);
}
else
{
ApiDatabaseLogRequestModel request = this.DatabaseLogModelMapper.MapResponseToRequest(record);
patch.ApplyTo(request);
return(request);
}
}
public virtual async Task <CreateResponse <ApiDatabaseLogResponseModel> > Create(
ApiDatabaseLogRequestModel model)
{
CreateResponse <ApiDatabaseLogResponseModel> response = new CreateResponse <ApiDatabaseLogResponseModel>(await this.databaseLogModelValidator.ValidateCreateAsync(model));
if (response.Success)
{
var bo = this.bolDatabaseLogMapper.MapModelToBO(default(int), model);
var record = await this.databaseLogRepository.Create(this.dalDatabaseLogMapper.MapBOToEF(bo));
response.SetRecord(this.bolDatabaseLogMapper.MapBOToModel(this.dalDatabaseLogMapper.MapEFToBO(record)));
}
return(response);
}
public void MapResponseToRequest()
{
var mapper = new ApiDatabaseLogModelMapper();
var model = new ApiDatabaseLogResponseModel();
model.SetProperties(1, "A", "A", "A", DateTime.Parse("1/1/1987 12:00:00 AM"), "A", "A", "A");
ApiDatabaseLogRequestModel response = mapper.MapResponseToRequest(model);
response.DatabaseUser.Should().Be("A");
[email protected]().Be("A");
[email protected]().Be("A");
response.PostTime.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM"));
response.Schema.Should().Be("A");
response.Tsql.Should().Be("A");
response.XmlEvent.Should().Be("A");
}
public virtual BODatabaseLog MapModelToBO(
int databaseLogID,
ApiDatabaseLogRequestModel model
)
{
BODatabaseLog boDatabaseLog = new BODatabaseLog();
boDatabaseLog.SetProperties(
databaseLogID,
model.DatabaseUser,
model.@Event,
model.@Object,
model.PostTime,
model.Schema,
model.Tsql,
model.XmlEvent);
return(boDatabaseLog);
}
public async void Create()
{
var mock = new ServiceMockFacade <IDatabaseLogRepository>();
var model = new ApiDatabaseLogRequestModel();
mock.RepositoryMock.Setup(x => x.Create(It.IsAny <DatabaseLog>())).Returns(Task.FromResult(new DatabaseLog()));
var service = new DatabaseLogService(mock.LoggerMock.Object,
mock.RepositoryMock.Object,
mock.ModelValidatorMockFactory.DatabaseLogModelValidatorMock.Object,
mock.BOLMapperMockFactory.BOLDatabaseLogMapperMock,
mock.DALMapperMockFactory.DALDatabaseLogMapperMock);
CreateResponse <ApiDatabaseLogResponseModel> response = await service.Create(model);
response.Should().NotBeNull();
mock.ModelValidatorMockFactory.DatabaseLogModelValidatorMock.Verify(x => x.ValidateCreateAsync(It.IsAny <ApiDatabaseLogRequestModel>()));
mock.RepositoryMock.Verify(x => x.Create(It.IsAny <DatabaseLog>()));
}
public async void Delete()
{
var mock = new ServiceMockFacade <IDatabaseLogRepository>();
var model = new ApiDatabaseLogRequestModel();
mock.RepositoryMock.Setup(x => x.Delete(It.IsAny <int>())).Returns(Task.CompletedTask);
var service = new DatabaseLogService(mock.LoggerMock.Object,
mock.RepositoryMock.Object,
mock.ModelValidatorMockFactory.DatabaseLogModelValidatorMock.Object,
mock.BOLMapperMockFactory.BOLDatabaseLogMapperMock,
mock.DALMapperMockFactory.DALDatabaseLogMapperMock);
ActionResponse response = await service.Delete(default(int));
response.Should().NotBeNull();
mock.RepositoryMock.Verify(x => x.Delete(It.IsAny <int>()));
mock.ModelValidatorMockFactory.DatabaseLogModelValidatorMock.Verify(x => x.ValidateDeleteAsync(It.IsAny <int>()));
}
public void CreatePatch()
{
var mapper = new ApiDatabaseLogModelMapper();
var model = new ApiDatabaseLogRequestModel();
model.SetProperties("A", "A", "A", DateTime.Parse("1/1/1987 12:00:00 AM"), "A", "A", "A");
JsonPatchDocument <ApiDatabaseLogRequestModel> patch = mapper.CreatePatch(model);
var response = new ApiDatabaseLogRequestModel();
patch.ApplyTo(response);
response.DatabaseUser.Should().Be("A");
[email protected]().Be("A");
[email protected]().Be("A");
response.PostTime.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM"));
response.Schema.Should().Be("A");
response.Tsql.Should().Be("A");
response.XmlEvent.Should().Be("A");
}
public virtual async Task <UpdateResponse <ApiDatabaseLogResponseModel> > Update(
int databaseLogID,
ApiDatabaseLogRequestModel model)
{
var validationResult = await this.databaseLogModelValidator.ValidateUpdateAsync(databaseLogID, model);
if (validationResult.IsValid)
{
var bo = this.bolDatabaseLogMapper.MapModelToBO(databaseLogID, model);
await this.databaseLogRepository.Update(this.dalDatabaseLogMapper.MapBOToEF(bo));
var record = await this.databaseLogRepository.Get(databaseLogID);
return(new UpdateResponse <ApiDatabaseLogResponseModel>(this.bolDatabaseLogMapper.MapBOToModel(this.dalDatabaseLogMapper.MapEFToBO(record))));
}
else
{
return(new UpdateResponse <ApiDatabaseLogResponseModel>(validationResult));
}
}
public virtual async Task <IActionResult> Update(int id, [FromBody] ApiDatabaseLogRequestModel model)
{
ApiDatabaseLogRequestModel request = await this.PatchModel(id, this.DatabaseLogModelMapper.CreatePatch(model));
if (request == null)
{
return(this.StatusCode(StatusCodes.Status404NotFound));
}
else
{
UpdateResponse <ApiDatabaseLogResponseModel> result = await this.DatabaseLogService.Update(id, request);
if (result.Success)
{
return(this.Ok(result));
}
else
{
return(this.StatusCode(StatusCodes.Status422UnprocessableEntity, result));
}
}
}
public virtual async Task <IActionResult> Patch(int id, [FromBody] JsonPatchDocument <ApiDatabaseLogRequestModel> patch)
{
ApiDatabaseLogResponseModel record = await this.DatabaseLogService.Get(id);
if (record == null)
{
return(this.StatusCode(StatusCodes.Status404NotFound));
}
else
{
ApiDatabaseLogRequestModel model = await this.PatchModel(id, patch);
UpdateResponse <ApiDatabaseLogResponseModel> result = await this.DatabaseLogService.Update(id, model);
if (result.Success)
{
return(this.Ok(result));
}
else
{
return(this.StatusCode(StatusCodes.Status422UnprocessableEntity, result));
}
}
}
