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); } }