public async Task <IEnumerable <OrderLineDetail> > GetAllAsync()
{
using (var connection = context.CreateConnection())
{
return(await connection.QueryAsync <OrderLineDetail>(OrderLineDetailQuery.All()));
}
}
public async Task DeleteAsync(Guid id)
{
using (var connection = context.CreateConnection())
{
await connection.ExecuteAsync(OrderLineDetailQuery.Delete(id));
}
}
public async Task <OrderLineDetail> GetByIdAsync(Guid id)
{
using (var connection = context.CreateConnection())
{
var query = await connection.QueryAsync <OrderLineDetail>(OrderLineDetailQuery.ById(id));
return(query.SingleOrDefault());
}
}
public async Task <OrderLineDetail> UpdateAsync(OrderLineDetail OrderLineDetail)
{
using (var connection = context.CreateConnection())
{
await connection.ExecuteAsync(OrderLineDetailQuery.Update(OrderLineDetail));
return(OrderLineDetail);
}
}
public OrderLineDetail Create(OrderLineDetail OrderLineDetail)
{
if (OrderLineDetail.Id == Guid.Empty)
{
OrderLineDetail.Id = Guid.NewGuid();
}
using (var connection = context.CreateConnection())
{
connection.Execute(OrderLineDetailQuery.Insert(OrderLineDetail));
return(OrderLineDetail);
}
}
public async Task <OrderLineDetail> CreateAsync(OrderLineDetail OrderLineDetail)
{
if (OrderLineDetail.Id == Guid.Empty)
{
OrderLineDetail.Id = Guid.NewGuid();
}
using (var connection = context.CreateConnection())
{
await connection.ExecuteAsync(OrderLineDetailQuery.Insert(OrderLineDetail));
return(OrderLineDetail);
}
}
