public async Task <bool> Save(ObservationDTO observation)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@observation", observation.CreateXML(), DbType.Xml);
using (SqlConnection con = _connectionManager.GetConnection())
{
con.Open();
var result = await con.QueryAsync <bool>("uspSaveObservation", param : parameters, commandType : CommandType.StoredProcedure);
return(result.FirstOrDefault());
}
}
public async Task <Unit> Handle(CreateObservationCommand request, CancellationToken cancellationToken)
{
var entity = new ObservationDTO
{
Id = request.Id,
Discussion = request.Discussion,
DiscussionDate = request.DiscussionDate,
DiscussionLocation = request.DiscussionLocation,
DiscussionWith = request.DiscussionWith,
Subject = request.Subject,
Outcome = request.Outcome,
RecordedBy = request.RecordedBy,
RecordedDate = request.RecordedDate
};
var result = await _observationRepository.Save(entity);
return(Unit.Value);
}
public async Task <IActionResult> PostAsync([FromBody] ObservationDTO observation)
{
//return _observationService.Save(observation);
var command = new CreateObservationCommand
{
Id = 0,
Discussion = observation.Discussion,
DiscussionDate = observation.DiscussionDate,
DiscussionLocation = observation.DiscussionLocation,
DiscussionWith = observation.DiscussionWith,
Subject = observation.Subject,
Outcome = observation.Outcome,
RecordedBy = observation.RecordedBy,
RecordedDate = observation.RecordedDate
};
var result = await Mediator.Send(command);
return(Ok(result));
}
public async Task CreateObservationQueryTest()
{
DatabaseSettingsConfig dbSettings = new DatabaseSettingsConfig()
{
ConnectionString = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename='E:\\MicroService CQRS\\MicroServicesCQRSDotNetCore\\Dot.Net.Infrastructure.Data\\Database\\PalindromeDB.mdf';Integrated Security=True;Connect Timeout=30"
};
IOptions <DatabaseSettingsConfig> iDBSettings = Options.Create(dbSettings);
IConnectToDatabase connection = new ConnectDB(iDBSettings);
IObservationRepository observationRepository = new ObservationRepository(connection);
var entity = new ObservationDTO
{
Id = 0,
Discussion = "CQRS",
DiscussionDate = DateTime.Now,
DiscussionLocation = "Office",
DiscussionWith = "Staff",
Subject = "CQRS Pros vs Cons",
Outcome = "Decided to go with CQRS",
RecordedBy = "Hari",
RecordedDate = DateTime.Now
};
var sut = new CreateObservationCommandHandler(observationRepository);
var result = await sut.Handle(new CreateObservationCommand
{
Id = 0,
Discussion = "CQRS",
DiscussionDate = DateTime.Now,
DiscussionLocation = "Office",
DiscussionWith = "Staff",
Subject = "CQRS Pros vs Cons",
Outcome = "Decided to go with CQRS",
RecordedBy = "Hari",
RecordedDate = DateTime.Now
}, CancellationToken.None);
result.ShouldBeOfType <bool>();
//result.ShouldBe(Unit);
}
