public ContactDetail GetById(Guid id)
{
using (var connection = context.CreateConnection())
{
return(connection.Query <ContactDetail>(ContactDetailQuery.ById(id)).SingleOrDefault());
}
}
public IEnumerable <ContactDetail> GetAll()
{
using (var connection = context.CreateConnection())
{
return(connection.Query <ContactDetail>(ContactDetailQuery.All()));
}
}
public void Delete(Guid id)
{
using (var connection = context.CreateConnection())
{
connection.Execute(ContactDetailQuery.Delete(id));
}
}
public ContactDetail Update(ContactDetail contactdetail)
{
using (var connection = context.CreateConnection())
{
connection.Execute(ContactDetailQuery.Update(contactdetail));
return(contactdetail);
}
}
public ContactDetail Create(ContactDetail contactdetail)
{
if (contactdetail.Id == Guid.Empty)
{
contactdetail.Id = Guid.NewGuid();
}
using (var connection = context.CreateConnection())
{
connection.Execute(ContactDetailQuery.Insert(contactdetail));
return(contactdetail);
}
}
public async Task <ActionResult <ContactDetailDto> > GetContactByDetail(int id)
{
var query = new ContactDetailQuery(id);
_logger.LogInformation(
"----- Sending query: ContactDetailQuery - {id}",
id);
var queryResult = await _mediator.Send(query);
if (queryResult == null)
{
return(BadRequest("Query not created"));
}
return(Ok(queryResult));
}
